|
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 |
- |
|
|