Lines 329-346
ALTER TABLE `collections`
Link Here
|
329 |
ADD CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE; |
329 |
ADD CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE; |
330 |
|
330 |
|
331 |
-- |
331 |
-- |
332 |
-- Table: collections_tracking |
|
|
333 |
-- |
334 |
|
335 |
DROP TABLE IF EXISTS collections_tracking; |
336 |
CREATE TABLE collections_tracking ( |
337 |
collections_tracking_id integer(11) NOT NULL auto_increment, |
338 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
339 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
340 |
PRIMARY KEY (collections_tracking_id) |
341 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
342 |
|
343 |
-- |
344 |
-- Table structure for table `branch_borrower_circ_rules` |
332 |
-- Table structure for table `branch_borrower_circ_rules` |
345 |
-- |
333 |
-- |
346 |
|
334 |
|
Lines 975-980
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
975 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
963 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
976 |
|
964 |
|
977 |
-- |
965 |
-- |
|
|
966 |
-- Table: collections_tracking |
967 |
-- |
968 |
|
969 |
DROP TABLE IF EXISTS collections_tracking; |
970 |
CREATE TABLE collections_tracking ( |
971 |
collections_tracking_id integer(11) NOT NULL auto_increment, |
972 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
973 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
974 |
PRIMARY KEY (collections_tracking_id) |
975 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
976 |
|
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 |
-- |
978 |
-- Table structure for table `default_branch_item_rules` |
984 |
-- Table structure for table `default_branch_item_rules` |
979 |
-- |
985 |
-- |
980 |
|
986 |
|
981 |
- |
|
|