@@ -, +, @@ --- .../bug_14544_set_default_value_for_virtualshelves_sortfield.sql | 3 +++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql --- a/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql +++ a/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql @@ -0,0 +1,3 @@ +ALTER TABLE virtualshelves CHANGE COLUMN sortfield sortfield VARCHAR(16) DEFAULT 'title'; + +UPDATE virtualshelves SET sortfield='title' WHERE sortfield IS NULL; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2285,7 +2285,7 @@ CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) `shelfname` varchar(255) default NULL, -- name of the list `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) `category` varchar(1) default NULL, -- type of list (private [1], public [2]) - `sortfield` varchar(16) default NULL, -- the field this list is sorted on + `sortfield` varchar(16) default 'title', -- the field this list is sorted on `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified `created_on` TIMESTAMP NOT NULL, -- creation time `allow_add` tinyint(1) default 0, -- permission for adding entries to list --