| 
      
            Lines 119-124
          CREATE TABLE `authorised_values` ( -- stores values for authorized values catego
      
      
        Link Here
      
     | 
  
        
          | 119 | 
            KEY `name` (`category`),  | 
          119 | 
            KEY `name` (`category`),  | 
        
        
          | 120 | 
            KEY `lib` (`lib` (191)),  | 
          120 | 
            KEY `lib` (`lib` (191)),  | 
        
        
          | 121 | 
            KEY `auth_value_idx` (`authorised_value`),  | 
          121 | 
            KEY `auth_value_idx` (`authorised_value`),  | 
        
            
               | 
               | 
              122 | 
                CONSTRAINT `category_code` UNIQUE (`category`,`authorised_value`),  | 
            
        
          | 122 | 
            CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          123 | 
            CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 123 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          124 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
        
          | 124 | 
           | 
          125 | 
           | 
        
            
              | 125 | 
              -   | 
               | 
               |