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