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

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

Return to bug 22335