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 2297-2303 CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) Link Here
2297
  `shelfname` varchar(255) default NULL, -- name of the list
2297
  `shelfname` varchar(255) default NULL, -- name of the list
2298
  `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)
2298
  `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)
2299
  `category` varchar(1) default NULL, -- type of list (private [1], public [2])
2299
  `category` varchar(1) default NULL, -- type of list (private [1], public [2])
2300
  `sortfield` varchar(16) default NULL, -- the field this list is sorted on
2300
  `sortfield` varchar(16) default 'title', -- the field this list is sorted on
2301
  `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified
2301
  `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified
2302
  `created_on` TIMESTAMP NOT NULL, -- creation time
2302
  `created_on` TIMESTAMP NOT NULL, -- creation time
2303
  `allow_add` tinyint(1) default 0, -- permission for adding entries to list
2303
  `allow_add` tinyint(1) default 0, -- permission for adding entries to list
2304
- 

Return to bug 14544