|
Lines 92-97
CREATE TABLE `auth_tag_structure` (
Link Here
|
| 92 |
CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
92 |
CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 93 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
93 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 94 |
|
94 |
|
|
|
95 |
|
| 96 |
-- |
| 97 |
-- Table structure for table `authorised_value_categories` |
| 98 |
-- |
| 99 |
|
| 100 |
DROP TABLE IF EXISTS `authorised_value_categories`; |
| 101 |
CREATE TABLE `authorised_value_categories` ( |
| 102 |
`category_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', |
| 103 |
PRIMARY KEY (`category_name`) |
| 104 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 105 |
|
| 95 |
-- |
106 |
-- |
| 96 |
-- Table structure for table `authorised_values` |
107 |
-- Table structure for table `authorised_values` |
| 97 |
-- |
108 |
-- |
|
Lines 3572-3578
CREATE TABLE items_search_fields (
Link Here
|
| 3572 |
authorised_values_category VARCHAR(32) NULL DEFAULT NULL, |
3583 |
authorised_values_category VARCHAR(32) NULL DEFAULT NULL, |
| 3573 |
PRIMARY KEY(name), |
3584 |
PRIMARY KEY(name), |
| 3574 |
CONSTRAINT items_search_fields_authorised_values_category |
3585 |
CONSTRAINT items_search_fields_authorised_values_category |
| 3575 |
FOREIGN KEY (authorised_values_category) REFERENCES authorised_values (category) |
3586 |
FOREIGN KEY (authorised_values_category) REFERENCES authorised_value_categories (category_name) |
| 3576 |
ON DELETE SET NULL ON UPDATE CASCADE |
3587 |
ON DELETE SET NULL ON UPDATE CASCADE |
| 3577 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3588 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3578 |
|
3589 |
|
| 3579 |
- |
|
|