Lines 2147-2153
DROP TABLE IF EXISTS `suggestions`;
Link Here
|
2147 |
CREATE TABLE `suggestions` ( -- purchase suggestions |
2147 |
CREATE TABLE `suggestions` ( -- purchase suggestions |
2148 |
`suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha |
2148 |
`suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha |
2149 |
`suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table |
2149 |
`suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table |
2150 |
`suggesteddate` date NOT NULL default 0, -- date the suggestion was submitted |
2150 |
`suggesteddate` date NOT NULL, -- date the suggestion was submitted |
2151 |
`managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table |
2151 |
`managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table |
2152 |
`manageddate` date default NULL, -- date the suggestion was updated |
2152 |
`manageddate` date default NULL, -- date the suggestion was updated |
2153 |
acceptedby INT(11) default NULL, -- borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table |
2153 |
acceptedby INT(11) default NULL, -- borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table |