From 730519ed5ca75b8a703fd05f5d61e0d8fc4bbafc Mon Sep 17 00:00:00 2001 From: Nicolas Legrand Date: Wed, 2 Oct 2019 14:25:50 +0200 Subject: [PATCH] Bug 13881: Datebase changes, kohastructure and atomicupdate MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Séverine QUEUNE Signed-off-by: Katrin Fischer Signed-off-by: Martin Renvoize --- .../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 0000000000..21559f86a4 --- /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 2d411a70ad..75df8f6275 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -371,6 +371,20 @@ CREATE TABLE `cities` ( -- authorized values for cities/states/countries to choo PRIMARY KEY (`cityid`) ) 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.39.2