|
Lines 319-334
CREATE TABLE collections (
Link Here
|
| 319 |
colTitle varchar(100) NOT NULL DEFAULT '', |
319 |
colTitle varchar(100) NOT NULL DEFAULT '', |
| 320 |
colDesc MEDIUMTEXT NOT NULL, |
320 |
colDesc MEDIUMTEXT NOT NULL, |
| 321 |
colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.' |
321 |
colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.' |
| 322 |
PRIMARY KEY (colId) |
322 |
PRIMARY KEY (colId), |
|
|
323 |
CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCAD E ON UPDATE CASCADE |
| 323 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
324 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 324 |
|
325 |
|
| 325 |
-- |
326 |
-- |
| 326 |
-- Constraints for table `collections` |
|
|
| 327 |
-- |
| 328 |
ALTER TABLE `collections` |
| 329 |
ADD CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE; |
| 330 |
|
| 331 |
-- |
| 332 |
-- Table structure for table `branch_borrower_circ_rules` |
327 |
-- Table structure for table `branch_borrower_circ_rules` |
| 333 |
-- |
328 |
-- |
| 334 |
|
329 |
|
|
Lines 971-985
CREATE TABLE collections_tracking (
Link Here
|
| 971 |
collections_tracking_id integer(11) NOT NULL auto_increment, |
966 |
collections_tracking_id integer(11) NOT NULL auto_increment, |
| 972 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
967 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
| 973 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
968 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
| 974 |
PRIMARY KEY (collections_tracking_id) |
969 |
PRIMARY KEY (collections_tracking_id), |
|
|
970 |
CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 971 |
CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CAS CADE ON UPDATE CASCADE |
| 975 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
972 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 976 |
|
973 |
|
| 977 |
ALTER TABLE `collections_tracking` |
|
|
| 978 |
ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE; |
| 979 |
|
| 980 |
ALTER TABLE `collections_tracking` |
| 981 |
ADD CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE; |
| 982 |
|
| 983 |
-- |
974 |
-- |
| 984 |
-- Table structure for table `default_branch_item_rules` |
975 |
-- Table structure for table `default_branch_item_rules` |
| 985 |
-- |
976 |
-- |
| 986 |
- |
|
|