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