| 
      
            Lines 227-233
          CREATE TABLE `additional_field_values` (
      
      
        Link Here
      
     | 
  
        
          | 227 | 
            `record_id` int(11) NOT NULL COMMENT 'record_id',  | 
          227 | 
            `record_id` int(11) NOT NULL COMMENT 'record_id',  | 
        
        
          | 228 | 
            `value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field',  | 
          228 | 
            `value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field',  | 
        
        
          | 229 | 
            PRIMARY KEY (`id`),  | 
          229 | 
            PRIMARY KEY (`id`),  | 
        
          
            
              | 230 | 
                UNIQUE KEY `field_record` (`field_id`,`record_id`),  | 
              230 | 
                KEY `afv_fk` (`field_id`),  | 
            
        
          | 231 | 
            CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          231 | 
            CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 232 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          232 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
        
          | 233 | 
          /*!40101 SET character_set_client = @saved_cs_client */;  | 
          233 | 
          /*!40101 SET character_set_client = @saved_cs_client */;  | 
        
  
    | 
      
            Lines 247-252
          CREATE TABLE `additional_fields` (
      
      
        Link Here
      
     | 
  
        
          | 247 | 
            `marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record',  | 
          247 | 
            `marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record',  | 
        
        
          | 248 | 
            `marcfield_mode` enum('get','set') NOT NULL DEFAULT 'get' COMMENT 'mode of operation (get or set) for marcfield', | 
          248 | 
            `marcfield_mode` enum('get','set') NOT NULL DEFAULT 'get' COMMENT 'mode of operation (get or set) for marcfield', | 
        
        
          | 249 | 
            `searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?',  | 
          249 | 
            `searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?',  | 
        
            
               | 
               | 
              250 | 
                `repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field repeatable?',  | 
            
        
          | 250 | 
            PRIMARY KEY (`id`),  | 
          251 | 
            PRIMARY KEY (`id`),  | 
        
        
          | 251 | 
            UNIQUE KEY `fields_uniq` (`tablename`(191),`name`(191))  | 
          252 | 
            UNIQUE KEY `fields_uniq` (`tablename`(191),`name`(191))  | 
        
        
          | 252 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          253 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
            
              | 253 | 
              -   | 
               | 
               |