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