Lines 1994-2000
CREATE TABLE `subscription` ( -- information related to the subscription
Link Here
|
1994 |
`opacdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the public |
1994 |
`opacdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the public |
1995 |
`graceperiod` int(11) NOT NULL default '0', -- grace period in days |
1995 |
`graceperiod` int(11) NOT NULL default '0', -- grace period in days |
1996 |
`enddate` date default NULL, -- subscription end date |
1996 |
`enddate` date default NULL, -- subscription end date |
1997 |
`closed` INT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed |
1997 |
`closed` TINYINT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed |
1998 |
`reneweddate` date default NULL, -- date of last renewal for the subscription |
1998 |
`reneweddate` date default NULL, -- date of last renewal for the subscription |
1999 |
`itemtype` VARCHAR( 10 ) NULL, |
1999 |
`itemtype` VARCHAR( 10 ) NULL, |
2000 |
`previousitemtype` VARCHAR( 10 ) NULL, |
2000 |
`previousitemtype` VARCHAR( 10 ) NULL, |
2001 |
- |
|
|