| 
      
            Lines 3980-3985
          CREATE TABLE biblio_metadata (
      
      
        Link Here
      
     | 
  
        
          | 3980 | 
              `format` VARCHAR(16) NOT NULL,  | 
          3980 | 
              `format` VARCHAR(16) NOT NULL,  | 
        
        
          | 3981 | 
              `marcflavour` VARCHAR(16) NOT NULL,  | 
          3981 | 
              `marcflavour` VARCHAR(16) NOT NULL,  | 
        
        
          | 3982 | 
              `metadata` LONGTEXT NOT NULL,  | 
          3982 | 
              `metadata` LONGTEXT NOT NULL,  | 
        
            
               | 
               | 
              3983 | 
                  timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched  | 
            
        
          | 3983 | 
              PRIMARY KEY(id),  | 
          3984 | 
              PRIMARY KEY(id),  | 
        
        
          | 3984 | 
              UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),  | 
          3985 | 
              UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),  | 
        
        
          | 3985 | 
              CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE  | 
          3986 | 
              CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
  
    | 
      
            Lines 3996-4001
          CREATE TABLE deletedbiblio_metadata (
      
      
        Link Here
      
     | 
  
        
          | 3996 | 
              `format` VARCHAR(16) NOT NULL,  | 
          3997 | 
              `format` VARCHAR(16) NOT NULL,  | 
        
        
          | 3997 | 
              `marcflavour` VARCHAR(16) NOT NULL,  | 
          3998 | 
              `marcflavour` VARCHAR(16) NOT NULL,  | 
        
        
          | 3998 | 
              `metadata` LONGTEXT NOT NULL,  | 
          3999 | 
              `metadata` LONGTEXT NOT NULL,  | 
        
            
               | 
               | 
              4000 | 
                  timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched  | 
            
        
          | 3999 | 
              PRIMARY KEY(id),  | 
          4001 | 
              PRIMARY KEY(id),  | 
        
        
          | 4000 | 
              UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),  | 
          4002 | 
              UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`),  | 
        
        
          | 4001 | 
              CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE  | 
          4003 | 
              CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE  |