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

(-)a/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql (+3 lines)
Line 0 Link Here
1
ALTER TABLE virtualshelves CHANGE COLUMN sortfield sortfield VARCHAR(16) DEFAULT 'title';
2
3
UPDATE virtualshelves SET sortfield='title' WHERE sortfield IS NULL;
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2285-2291 CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) Link Here
2285
  `shelfname` varchar(255) default NULL, -- name of the list
2285
  `shelfname` varchar(255) default NULL, -- name of the list
2286
  `owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int)
2286
  `owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int)
2287
  `category` varchar(1) default NULL, -- type of list (private [1], public [2])
2287
  `category` varchar(1) default NULL, -- type of list (private [1], public [2])
2288
  `sortfield` varchar(16) default NULL, -- the field this list is sorted on
2288
  `sortfield` varchar(16) default 'title', -- the field this list is sorted on
2289
  `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified
2289
  `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified
2290
  `created_on` TIMESTAMP NOT NULL, -- creation time
2290
  `created_on` TIMESTAMP NOT NULL, -- creation time
2291
  `allow_add` tinyint(1) default 0, -- permission for adding entries to list
2291
  `allow_add` tinyint(1) default 0, -- permission for adding entries to list
2292
- 

Return to bug 14544