Bug 13881: Datebase changes, kohastructure and atomicupdate

Signed-off-by: Séverine QUEUNE <severine.queune@bulac.fr>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

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 (file)
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 2d411a7..75df8f6 100644 (file)
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -372,6 +372,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`
 --