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 |
- |
|
|