Lines 373-378
CREATE TABLE `cities` ( -- authorized values for cities/states/countries to choo
Link Here
|
373 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
373 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
374 |
|
374 |
|
375 |
-- |
375 |
-- |
|
|
376 |
-- Table structure for table desks |
377 |
-- |
378 |
|
379 |
DROP TABLE IF EXISTS desks; |
380 |
CREATE TABLE desks ( -- authorized values for desks available in a Library |
381 |
desk_id int(11) NOT NULL auto_increment, -- unique identifier |
382 |
desk_name varchar(100) NOT NULL default '', -- name of the desk |
383 |
branchcode varchar(10) NOT NULL, -- Library the desk is located into |
384 |
PRIMARY KEY (desk_id), |
385 |
KEY `fk_desks_branchcode` (branchcode), |
386 |
CONSTRAINT `fk_desks_branchcode` FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE |
387 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
388 |
|
389 |
-- |
376 |
-- Table structure for table `class_sort_rules` |
390 |
-- Table structure for table `class_sort_rules` |
377 |
-- |
391 |
-- |
378 |
|
392 |
|
Lines 1828-1834
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha
Link Here
|
1828 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1842 |
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1829 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1843 |
CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
1830 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1844 |
CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
1831 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE |
1845 |
CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, |
1832 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1846 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1833 |
|
1847 |
|
1834 |
-- |
1848 |
-- |
Lines 1871-1876
CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b
Link Here
|
1871 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1885 |
ON DELETE SET NULL ON UPDATE SET NULL, |
1872 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
1886 |
CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) |
1873 |
ON DELETE SET NULL ON UPDATE SET NULL |
1887 |
ON DELETE SET NULL ON UPDATE SET NULL |
|
|
1888 |
ON DELETE SET NULL ON UPDATE SET NULL |
1874 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1889 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1875 |
|
1890 |
|
1876 |
-- |
1891 |
-- |
1877 |
- |
|
|