Lines 4869-4876
CREATE TABLE `subscription` (
Link Here
|
4869 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'default branches (items.homebranch)', |
4869 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'default branches (items.homebranch)', |
4870 |
`lastbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4870 |
`lastbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4871 |
`serialsadditems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'does receiving this serial create an item record', |
4871 |
`serialsadditems` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'does receiving this serial create an item record', |
4872 |
`staffdisplaycount` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'how many issues to show to the staff', |
4872 |
`staffdisplaycount` INT(11) NULL DEFAULT NULL, -- how many issues to show to the staff |
4873 |
`opacdisplaycount` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'how many issues to show to the public', |
4873 |
`opacdisplaycount` INT(11) NULL DEFAULT NULL, -- how many issues to show to the public |
4874 |
`graceperiod` int(11) NOT NULL DEFAULT 0 COMMENT 'grace period in days', |
4874 |
`graceperiod` int(11) NOT NULL DEFAULT 0 COMMENT 'grace period in days', |
4875 |
`enddate` date DEFAULT NULL COMMENT 'subscription end date', |
4875 |
`enddate` date DEFAULT NULL COMMENT 'subscription end date', |
4876 |
`closed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes / no if the subscription is closed', |
4876 |
`closed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'yes / no if the subscription is closed', |
4877 |
- |
|
|