From e8798acfeb21518ff6a4272c8de3de025bf99bba Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 15 May 2017 10:44:47 -0300 Subject: [PATCH] Bug 18228: Add missing comma in kohastructure.sql Signed-off-by: Marcel de Rooy Signed-off-by: Nick Clemens --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e7ab6c7..baacaca 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2270,7 +2270,7 @@ CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified `created_on` datetime NOT NULL, -- creation time `allow_change_from_owner` tinyint(1) default 1, -- can owner change contents? - `allow_change_from_others` tinyint(1) default 0 -- can others change contents? + `allow_change_from_others` tinyint(1) default 0, -- can others change contents? PRIMARY KEY (`shelfnumber`), CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- 2.1.4