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 |
- |
|
|