@@ -, +, @@ --- .../atomicupdate/bug_13881_create_desks_table.perl | 16 ++++++++++++++++ installer/data/mysql/kohastructure.sql | 17 ++++++++++++++++- 2 files changed, 32 insertions(+), 1 deletion(-) 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` -- @@ -1828,7 +1842,7 @@ CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE + CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- @@ -1871,6 +1885,7 @@ CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b ON DELETE SET NULL ON UPDATE SET NULL, CONSTRAINT `old_reserves_ibfk_4` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE SET NULL ON UPDATE SET NULL + ON DELETE SET NULL ON UPDATE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- --