@@ -, +, @@ --- .../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 --- a/installer/data/mysql/atomicupdate/bug_13881_create_desks_table.perl +++ a/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"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/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` -- --