| 
      
            Lines 1255-1264
          CREATE TABLE `matchchecks` (
      
      
        Link Here
      
     | 
  
        
          | 1255 | 
          --  | 
          1255 | 
          --  | 
        
        
          | 1256 | 
           | 
          1256 | 
           | 
        
        
          | 1257 | 
          DROP TABLE IF EXISTS `need_merge_authorities`;  | 
          1257 | 
          DROP TABLE IF EXISTS `need_merge_authorities`;  | 
        
          
            
              | 1258 | 
              CREATE TABLE `need_merge_authorities` ( -- keeping track of authority records still to be merged by merge_authority cron job (used only if pref dontmerge is ON)  | 
              1258 | 
              CREATE TABLE `need_merge_authorities` ( -- keeping track of authority records still to be merged by merge_authority cron job  | 
            
        
          | 1259 | 
            `id` int NOT NULL auto_increment PRIMARY KEY, -- unique id  | 
          1259 | 
            `id` int NOT NULL auto_increment PRIMARY KEY, -- unique id  | 
        
          
            
              | 1260 | 
                `authid` bigint NOT NULL, -- reference to authority record  | 
              1260 | 
                `authid` bigint NOT NULL, -- reference to original authority record  | 
            
            
              | 1261 | 
                `done` tinyint DEFAULT 0  -- indication whether merge has been executed (0=not done, 1= done, 2= in progress)  | 
              1261 | 
                `authid_new` bigint, -- reference to optional new authority record  | 
            
            
               | 
               | 
              1262 | 
                `reportxml` text, -- xml showing original reporting tag  | 
            
            
              | 1263 | 
                `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date and time last modified  | 
            
            
              | 1264 | 
                `done` tinyint DEFAULT 0  -- indication whether merge has been executed (0=not done, 1=done, 2=in progress)  | 
            
            
              | 1265 | 
              -- Note: authid and authid_new should NOT be FOREIGN keys !  | 
            
            
              | 1266 | 
              -- authid may have been deleted; authid_new may be zero  | 
            
        
          | 1262 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          1267 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
        
          | 1263 | 
           | 
          1268 | 
           | 
        
        
          | 1264 | 
          --  | 
          1269 | 
          --  | 
        
            
              | 1265 | 
              -   | 
               | 
               |