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