2 if( CheckVersion( $DBversion ) ) {
4 CREATE TABLE desks ( -- desks available in a library
5 desk_id int(11) NOT NULL auto_increment, -- unique identifier added by Koha
6 desk_name varchar(100) NOT NULL default '', -- name of the desk
7 branchcode varchar(10) NOT NULL, -- library the desk is located at
9 KEY `fk_desks_branchcode` (branchcode),
10 CONSTRAINT `fk_desks_branchcode` FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
14 SetVersion( $DBversion );
15 print "Upgrade to $DBversion done (Bug 13881 - Add desk management)\n";