View | Details | Raw Unified | Return to bug 22335
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 3012-3018 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
3012
   rejecteddate date default NULL, -- date the suggestion was marked as rejected
3012
   rejecteddate date default NULL, -- date the suggestion was marked as rejected
3013
   lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time
3013
   lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time
3014
   lastmodificationdate date default NULL, -- date of the last modification
3014
   lastmodificationdate date default NULL, -- date of the last modification
3015
  `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
3015
  `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)
3016
  `note` LONGTEXT, -- note entered on the suggestion
3016
  `note` LONGTEXT, -- note entered on the suggestion
3017
  `author` varchar(80) default NULL, -- author of the suggested item
3017
  `author` varchar(80) default NULL, -- author of the suggested item
3018
  `title` varchar(255) default NULL, -- title of the suggested item
3018
  `title` varchar(255) default NULL, -- title of the suggested item
3019
- 

Return to bug 22335