Lines 2022-2029
CREATE TABLE `subscription` ( -- information related to the subscription
Link Here
|
2022 |
`branchcode` varchar(10) NOT NULL default '', -- default branches (items.homebranch) |
2022 |
`branchcode` varchar(10) NOT NULL default '', -- default branches (items.homebranch) |
2023 |
`lastbranch` varchar(10), |
2023 |
`lastbranch` varchar(10), |
2024 |
`serialsadditems` tinyint(1) NOT NULL default '0', -- does receiving this serial create an item record |
2024 |
`serialsadditems` tinyint(1) NOT NULL default '0', -- does receiving this serial create an item record |
2025 |
`staffdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the staff |
2025 |
`staffdisplaycount` INT(11) NULL DEFAULT NULL, -- how many issues to show to the staff |
2026 |
`opacdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the public |
2026 |
`opacdisplaycount` INT(11) NULL DEFAULT NULL, -- how many issues to show to the public |
2027 |
`graceperiod` int(11) NOT NULL default '0', -- grace period in days |
2027 |
`graceperiod` int(11) NOT NULL default '0', -- grace period in days |
2028 |
`enddate` date default NULL, -- subscription end date |
2028 |
`enddate` date default NULL, -- subscription end date |
2029 |
`closed` INT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed |
2029 |
`closed` INT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed |
2030 |
- |
|
|