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