| 
      
            Lines 1-17
          
      
      
        Link Here
      
     | 
  
        
          | 1 | 
          $DBversion = 'XXX'; # will be replaced by the RM  | 
          1 | 
          $DBversion = 'XXX'; # will be replaced by the RM  | 
        
        
          | 2 | 
          if( CheckVersion( $DBversion ) ) { | 
          2 | 
          if( CheckVersion( $DBversion ) ) { | 
        
        
          | 3 | 
           | 
          3 | 
           | 
        
            
              | 4 | 
                  unless (TableExists('marc_overlay_rules_modules')) { | 
               | 
               | 
            
            
              | 5 | 
                      $dbh->do(q{ | 
            
            
              | 6 | 
                          CREATE TABLE `marc_overlay_rules_modules` (  | 
            
            
              | 7 | 
                            `name` varchar(127) NOT NULL,  | 
            
            
              | 8 | 
                            `description` varchar(255),  | 
            
            
              | 9 | 
                            `specificity` int(11) NOT NULL UNIQUE,  | 
            
            
              | 10 | 
                            PRIMARY KEY(`name`)  | 
            
            
              | 11 | 
                          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
            
            
              | 12 | 
                      });  | 
            
            
              | 13 | 
                  }  | 
            
            
              | 14 | 
               | 
            
        
          | 15 | 
              unless (TableExists('marc_overlay_rules')) { | 
          4 | 
              unless (TableExists('marc_overlay_rules')) { | 
        
        
          | 16 | 
                  $dbh->do(q{ | 
          5 | 
                  $dbh->do(q{ | 
        
        
          | 17 | 
                      CREATE TABLE IF NOT EXISTS `marc_overlay_rules` (  | 
          6 | 
                      CREATE TABLE IF NOT EXISTS `marc_overlay_rules` (  | 
        
  
    | 
      
            Lines 23-30
          if( CheckVersion( $DBversion ) ) {
      
      
        Link Here
      
     | 
  
        
          | 23 | 
                        `append` TINYINT(1) NOT NULL DEFAULT 0,  | 
          12 | 
                        `append` TINYINT(1) NOT NULL DEFAULT 0,  | 
        
        
          | 24 | 
                        `remove` TINYINT(1) NOT NULL DEFAULT 0,  | 
          13 | 
                        `remove` TINYINT(1) NOT NULL DEFAULT 0,  | 
        
        
          | 25 | 
                        `delete` TINYINT(1) NOT NULL DEFAULT 0,  | 
          14 | 
                        `delete` TINYINT(1) NOT NULL DEFAULT 0,  | 
        
          
            
              | 26 | 
                            PRIMARY KEY(`id`),  | 
              15 | 
                            PRIMARY KEY(`id`)  | 
            
            
              | 27 | 
                            CONSTRAINT `marc_overlay_rules_ibfk1` FOREIGN KEY (`module`) REFERENCES `marc_overlay_rules_modules` (`name`) ON DELETE CASCADE ON UPDATE CASCADE  | 
               | 
               | 
            
        
          | 28 | 
                      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          16 | 
                      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
        
          | 29 | 
                  });  | 
          17 | 
                  });  | 
        
        
          | 30 | 
              }  | 
          18 | 
              }  |