View | Details | Raw Unified | Return to bug 23355
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-9 / +8 lines)
Lines 21274-21287 if( CheckVersion( $DBversion ) ) { Link Here
21274
$DBversion = '19.12.00.054';
21274
$DBversion = '19.12.00.054';
21275
if( CheckVersion( $DBversion ) ) {
21275
if( CheckVersion( $DBversion ) ) {
21276
    $dbh->do(qq{
21276
    $dbh->do(qq{
21277
             CREATE TABLE desks ( -- desks available in a library
21277
         CREATE TABLE IF NOT EXISTS `desks` ( -- desks available in a library
21278
             desk_id int(11) NOT NULL auto_increment, -- unique identifier added by Koha
21278
           `desk_id` int(11) NOT NULL auto_increment, -- unique identifier added by Koha
21279
             desk_name varchar(100) NOT NULL default '', -- name of the desk
21279
           `desk_name` varchar(100) NOT NULL default '', -- name of the desk
21280
             branchcode varchar(10) NOT NULL,       -- library the desk is located at
21280
           `branchcode` varchar(10) NOT NULL,       -- library the desk is located at
21281
             PRIMARY KEY  (desk_id),
21281
           PRIMARY KEY (`desk_id`),
21282
             KEY `fk_desks_branchcode` (branchcode),
21282
           KEY `fk_desks_branchcode` (`branchcode`),
21283
             CONSTRAINT `fk_desks_branchcode` FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE
21283
           CONSTRAINT `fk_desks_branchcode` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
21284
             ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
21284
         ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
21285
    });
21285
    });
21286
21286
21287
    NewVersion( $DBversion, 13881, "Add desk management");
21287
    NewVersion( $DBversion, 13881, "Add desk management");
21288
- 

Return to bug 23355