|
Lines 248-254
CREATE TABLE `additional_fields` (
Link Here
|
| 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 |
PRIMARY KEY (`id`), |
250 |
PRIMARY KEY (`id`), |
| 251 |
UNIQUE KEY `fields_uniq` (`tablename`(191),`name`(191)) |
251 |
UNIQUE KEY `fields_uniq` (`tablename`(191),`name`(191)), |
|
|
252 |
CONSTRAINT `additional_fields_authorised_value_categories_fk` FOREIGN KEY (`authorised_value_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
| 252 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
253 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 253 |
/*!40101 SET character_set_client = @saved_cs_client */; |
254 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 254 |
|
255 |
|
|
Lines 921-927
CREATE TABLE `auth_subfield_structure` (
Link Here
|
| 921 |
`display_order` int(2) NOT NULL DEFAULT 0, |
922 |
`display_order` int(2) NOT NULL DEFAULT 0, |
| 922 |
PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), |
923 |
PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), |
| 923 |
KEY `tab` (`authtypecode`,`tab`), |
924 |
KEY `tab` (`authtypecode`,`tab`), |
| 924 |
CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
925 |
CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
926 |
CONSTRAINT `auth_subfield_structure_authorised_value_categories_fk` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
| 925 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
927 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 926 |
/*!40101 SET character_set_client = @saved_cs_client */; |
928 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 927 |
|
929 |
|
|
Lines 941-947
CREATE TABLE `auth_tag_structure` (
Link Here
|
| 941 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
943 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
| 942 |
`authorised_value` varchar(32) DEFAULT NULL, |
944 |
`authorised_value` varchar(32) DEFAULT NULL, |
| 943 |
PRIMARY KEY (`authtypecode`,`tagfield`), |
945 |
PRIMARY KEY (`authtypecode`,`tagfield`), |
| 944 |
CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
946 |
CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
947 |
CONSTRAINT `auth_tag_structure_authorised_value_categories_fk` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
| 945 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
948 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 946 |
/*!40101 SET character_set_client = @saved_cs_client */; |
949 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 947 |
|
950 |
|
|
Lines 1183-1189
CREATE TABLE `borrower_attribute_types` (
Link Here
|
| 1183 |
PRIMARY KEY (`code`), |
1186 |
PRIMARY KEY (`code`), |
| 1184 |
KEY `auth_val_cat_idx` (`authorised_value_category`), |
1187 |
KEY `auth_val_cat_idx` (`authorised_value_category`), |
| 1185 |
KEY `category_code` (`category_code`), |
1188 |
KEY `category_code` (`category_code`), |
| 1186 |
CONSTRAINT `borrower_attribute_types_ibfk_1` FOREIGN KEY (`category_code`) REFERENCES `categories` (`categorycode`) |
1189 |
CONSTRAINT `borrower_attribute_types_ibfk_1` FOREIGN KEY (`category_code`) REFERENCES `categories` (`categorycode`), |
|
|
1190 |
CONSTRAINT `borrower_attribute_types_authorised_value_categories_fk` FOREIGN KEY (`authorised_value_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
| 1187 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1191 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1188 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1192 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1189 |
|
1193 |
|
|
Lines 1999-2005
CREATE TABLE `club_template_enrollment_fields` (
Link Here
|
| 1999 |
`authorised_value_category` varchar(32) DEFAULT NULL, |
2003 |
`authorised_value_category` varchar(32) DEFAULT NULL, |
| 2000 |
PRIMARY KEY (`id`), |
2004 |
PRIMARY KEY (`id`), |
| 2001 |
KEY `club_template_id` (`club_template_id`), |
2005 |
KEY `club_template_id` (`club_template_id`), |
| 2002 |
CONSTRAINT `club_template_enrollment_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
2006 |
CONSTRAINT `club_template_enrollment_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
2007 |
CONSTRAINT `club_template_enrollment_fields_authorised_value_categories_fk` FOREIGN KEY (`authorised_value_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2003 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2008 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2004 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2009 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2005 |
|
2010 |
|
|
Lines 2018-2024
CREATE TABLE `club_template_fields` (
Link Here
|
| 2018 |
`authorised_value_category` varchar(32) DEFAULT NULL, |
2023 |
`authorised_value_category` varchar(32) DEFAULT NULL, |
| 2019 |
PRIMARY KEY (`id`), |
2024 |
PRIMARY KEY (`id`), |
| 2020 |
KEY `club_template_id` (`club_template_id`), |
2025 |
KEY `club_template_id` (`club_template_id`), |
| 2021 |
CONSTRAINT `club_template_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
2026 |
CONSTRAINT `club_template_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
2027 |
CONSTRAINT `club_template_fields_authorised_value_categories_fk` FOREIGN KEY (`authorised_value_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2022 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2028 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2023 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2029 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2024 |
|
2030 |
|
|
Lines 4147-4153
CREATE TABLE `marc_tag_structure` (
Link Here
|
| 4147 |
`ind1_defaultvalue` varchar(1) NOT NULL DEFAULT '', |
4153 |
`ind1_defaultvalue` varchar(1) NOT NULL DEFAULT '', |
| 4148 |
`ind2_defaultvalue` varchar(1) NOT NULL DEFAULT '', |
4154 |
`ind2_defaultvalue` varchar(1) NOT NULL DEFAULT '', |
| 4149 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '', |
4155 |
`frameworkcode` varchar(4) NOT NULL DEFAULT '', |
| 4150 |
PRIMARY KEY (`frameworkcode`,`tagfield`) |
4156 |
PRIMARY KEY (`frameworkcode`,`tagfield`), |
|
|
4157 |
CONSTRAINT `marc_tag_structure_authorised_value_categories_fk` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE |
| 4151 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4158 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4152 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4159 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 4153 |
|
4160 |
|
| 4154 |
- |
|
|