From cdda7fa7acb235e483824c3f07bc23b5ef025f41 Mon Sep 17 00:00:00 2001 From: Nicolas Legrand Date: Wed, 2 Oct 2019 14:25:50 +0200 Subject: [PATCH] Bug 13881: kohastructure and atomic update MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Séverine QUEUNE --- .../mysql/atomicupdate/bug_13881_create_desks_table.perl | 16 ++++++++++++++++ installer/data/mysql/kohastructure.sql | 14 ++++++++++++++ 2 files changed, 30 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_13881_create_desks_table.perl diff --git a/installer/data/mysql/atomicupdate/bug_13881_create_desks_table.perl b/installer/data/mysql/atomicupdate/bug_13881_create_desks_table.perl new file mode 100644 index 0000000..21559f8 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_13881_create_desks_table.perl @@ -0,0 +1,16 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + $dbh->do(qq{ + CREATE TABLE desks ( -- authorized values for desks available in a Library + desk_id int(11) NOT NULL auto_increment, -- unique identifier added by Koha + desk_name varchar(100) NOT NULL default '', -- name of the desk + branchcode varchar(10) NOT NULL, -- Library the desk is located into + PRIMARY KEY (desk_id), + KEY `fk_desks_branchcode` (branchcode), + CONSTRAINT `fk_desks_branchcode` FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + + }); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 13881 - Add desk management)\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 15e1304..efc4815 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -373,6 +373,20 @@ CREATE TABLE `cities` ( -- authorized values for cities/states/countries to choo ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- +-- Table structure for table desks +-- + +DROP TABLE IF EXISTS desks; +CREATE TABLE desks ( -- authorized values for desks available in a Library + desk_id int(11) NOT NULL auto_increment, -- unique identifier + desk_name varchar(100) NOT NULL default '', -- name of the desk + branchcode varchar(10) NOT NULL, -- Library the desk is located into + PRIMARY KEY (desk_id), + KEY `fk_desks_branchcode` (branchcode), + CONSTRAINT `fk_desks_branchcode` FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- -- Table structure for table `class_sort_rules` -- -- 2.1.4