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

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

Return to bug 22335