Lines 1175-1188
CREATE TABLE `borrower_debarments` (
Link Here
|
1175 |
`borrower_debarment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for the restriction', |
1175 |
`borrower_debarment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for the restriction', |
1176 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key for borrowers.borrowernumber for patron who is restricted', |
1176 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key for borrowers.borrowernumber for patron who is restricted', |
1177 |
`expiration` date DEFAULT NULL COMMENT 'expiration date of the restriction', |
1177 |
`expiration` date DEFAULT NULL COMMENT 'expiration date of the restriction', |
1178 |
`type` enum('SUSPENSION','OVERDUES','MANUAL','DISCHARGE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MANUAL' COMMENT 'type of restriction', |
1178 |
`type` varchar(50) NOT NULL COMMENT 'type of restriction, FK to debarment_types.code', |
1179 |
`comment` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'comments about the restriction', |
1179 |
`comment` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'comments about the restriction', |
1180 |
`manager_id` int(11) DEFAULT NULL COMMENT 'foreign key for borrowers.borrowernumber for the librarian managing the restriction', |
1180 |
`manager_id` int(11) DEFAULT NULL COMMENT 'foreign key for borrowers.borrowernumber for the librarian managing the restriction', |
1181 |
`created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date the restriction was added', |
1181 |
`created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date the restriction was added', |
1182 |
`updated` timestamp NULL DEFAULT NULL COMMENT 'date the restriction was updated', |
1182 |
`updated` timestamp NULL DEFAULT NULL COMMENT 'date the restriction was updated', |
1183 |
PRIMARY KEY (`borrower_debarment_id`), |
1183 |
PRIMARY KEY (`borrower_debarment_id`), |
1184 |
KEY `borrowernumber` (`borrowernumber`), |
1184 |
KEY `borrowernumber` (`borrowernumber`), |
1185 |
CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
1185 |
CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
1186 |
CONSTRAINT `borrower_debarments_ibfk_2` FOREIGN KEY (`type`) REFERENCES `debarment_types` (`code`) ON DELETE NO ACTION ON UPDATE CASCADE |
1186 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1187 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1187 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1188 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1188 |
|
1189 |
|
Lines 2010-2015
CREATE TABLE `collections_tracking` (
Link Here
|
2010 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2011 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2011 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2012 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2012 |
|
2013 |
|
|
|
2014 |
DROP TABLE IF EXISTS `debarment_types`; |
2015 |
CREATE TABLE debarment_types ( |
2016 |
code varchar(50) NOT NULL PRIMARY KEY, |
2017 |
display_text text NOT NULL, |
2018 |
ronly tinyint(1) NOT NULL DEFAULT 0, |
2019 |
dflt tinyint(1) NOT NULL DEFAULT 0 |
2020 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2021 |
|
2013 |
-- |
2022 |
-- |
2014 |
-- Table structure for table `columns_settings` |
2023 |
-- Table structure for table `columns_settings` |
2015 |
-- |
2024 |
-- |
2016 |
- |
|
|