From ec45a4668be87dd94ed8237c51d7c13a86ac3255 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 26 Aug 2015 14:48:35 +0100 Subject: [PATCH] Bug 14544: DB Changes: Set a default value for sortfield --- .../bug_14544_set_default_value_for_virtualshelves_sortfield.sql | 4 ++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 5 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql diff --git a/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql b/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql new file mode 100644 index 0000000..11d95e2 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14544_set_default_value_for_virtualshelves_sortfield.sql @@ -0,0 +1,4 @@ +ALTER TABLE virtualshelves CHANGE COLUMN sortfield sortfield VARCHAR(16) DEFAULT 'title'; + +UPDATE virtualshelves SET sortfield='title' WHERE sortfield IS NULL; + diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3a497ae..171bc63 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2313,7 +2313,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 -- 2.1.0