Lines 1969-1975
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
1969 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) |
1969 |
`STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) |
1970 |
`note` mediumtext, -- note entered on the suggestion |
1970 |
`note` mediumtext, -- note entered on the suggestion |
1971 |
`author` varchar(80) default NULL, -- author of the suggested item |
1971 |
`author` varchar(80) default NULL, -- author of the suggested item |
1972 |
`title` varchar(80) default NULL, -- title of the suggested item |
1972 |
`title` varchar(255) default NULL, -- title of the suggested item |
1973 |
`copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item |
1973 |
`copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item |
1974 |
`publishercode` varchar(255) default NULL, -- publisher of the suggested item |
1974 |
`publishercode` varchar(255) default NULL, -- publisher of the suggested item |
1975 |
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the suggestion was updated |
1975 |
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the suggestion was updated |