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

(-)a/installer/data/mysql/atomicupdate/bug_13881_create_desks_table.perl (+16 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(qq{
4
             CREATE TABLE desks ( -- authorized values for 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 into
8
             PRIMARY KEY  (desk_id),
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;
12
13
             });
14
    SetVersion( $DBversion );
15
    print "Upgrade to $DBversion done (Bug 13881 - Add desk management)\n";
16
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +14 lines)
Lines 373-378 CREATE TABLE `cities` ( -- authorized values for cities/states/countries to choo Link Here
373
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
373
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
374
374
375
--
375
--
376
-- Table structure for table desks
377
--
378
379
DROP TABLE IF EXISTS desks;
380
CREATE TABLE desks ( -- authorized values for desks available in a Library
381
  desk_id int(11) NOT NULL auto_increment, -- unique identifier
382
  desk_name varchar(100) NOT NULL default '', -- name of the desk
383
  branchcode varchar(10) NOT NULL,       -- Library the desk is located into
384
  PRIMARY KEY  (desk_id),
385
  KEY `fk_desks_branchcode` (branchcode),
386
  CONSTRAINT `fk_desks_branchcode` FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE
387
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
388
389
--
376
-- Table structure for table `class_sort_rules`
390
-- Table structure for table `class_sort_rules`
377
--
391
--
378
392
379
- 

Return to bug 13881