|
Lines 210-216
CREATE TABLE `additional_fields` (
Link Here
|
| 210 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
210 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
| 211 |
`tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'tablename of the new field', |
211 |
`tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'tablename of the new field', |
| 212 |
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'name of the field', |
212 |
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'name of the field', |
| 213 |
`authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'is an authorised value category', |
213 |
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'is an authorised value category', |
| 214 |
`marcfield` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', |
214 |
`marcfield` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', |
| 215 |
`searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?', |
215 |
`searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?', |
| 216 |
PRIMARY KEY (`id`), |
216 |
PRIMARY KEY (`id`), |
|
Lines 824-830
CREATE TABLE `auth_subfield_structure` (
Link Here
|
| 824 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
824 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
| 825 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
825 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
| 826 |
`tab` tinyint(1) DEFAULT NULL, |
826 |
`tab` tinyint(1) DEFAULT NULL, |
| 827 |
`authorised_value` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
827 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
| 828 |
`value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
828 |
`value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 829 |
`seealso` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
829 |
`seealso` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 830 |
`isurl` tinyint(1) DEFAULT NULL, |
830 |
`isurl` tinyint(1) DEFAULT NULL, |
|
Lines 854-860
CREATE TABLE `auth_tag_structure` (
Link Here
|
| 854 |
`libopac` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
854 |
`libopac` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
| 855 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
855 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
| 856 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
856 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
| 857 |
`authorised_value` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
857 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
| 858 |
PRIMARY KEY (`authtypecode`,`tagfield`), |
858 |
PRIMARY KEY (`authtypecode`,`tagfield`), |
| 859 |
CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
859 |
CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 860 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
860 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
|
Lines 1868-1874
CREATE TABLE `club_template_enrollment_fields` (
Link Here
|
| 1868 |
`club_template_id` int(11) NOT NULL, |
1868 |
`club_template_id` int(11) NOT NULL, |
| 1869 |
`name` text COLLATE utf8mb4_unicode_ci NOT NULL, |
1869 |
`name` text COLLATE utf8mb4_unicode_ci NOT NULL, |
| 1870 |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1870 |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1871 |
`authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1871 |
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1872 |
PRIMARY KEY (`id`), |
1872 |
PRIMARY KEY (`id`), |
| 1873 |
KEY `club_template_id` (`club_template_id`), |
1873 |
KEY `club_template_id` (`club_template_id`), |
| 1874 |
CONSTRAINT `club_template_enrollment_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
1874 |
CONSTRAINT `club_template_enrollment_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
Lines 1887-1893
CREATE TABLE `club_template_fields` (
Link Here
|
| 1887 |
`club_template_id` int(11) NOT NULL, |
1887 |
`club_template_id` int(11) NOT NULL, |
| 1888 |
`name` text COLLATE utf8mb4_unicode_ci NOT NULL, |
1888 |
`name` text COLLATE utf8mb4_unicode_ci NOT NULL, |
| 1889 |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1889 |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1890 |
`authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1890 |
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 1891 |
PRIMARY KEY (`id`), |
1891 |
PRIMARY KEY (`id`), |
| 1892 |
KEY `club_template_id` (`club_template_id`), |
1892 |
KEY `club_template_id` (`club_template_id`), |
| 1893 |
CONSTRAINT `club_template_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
1893 |
CONSTRAINT `club_template_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
Lines 3467-3473
CREATE TABLE `marc_subfield_structure` (
Link Here
|
| 3467 |
`important` tinyint(4) NOT NULL DEFAULT 0, |
3467 |
`important` tinyint(4) NOT NULL DEFAULT 0, |
| 3468 |
`kohafield` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3468 |
`kohafield` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 3469 |
`tab` tinyint(1) DEFAULT NULL, |
3469 |
`tab` tinyint(1) DEFAULT NULL, |
| 3470 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3470 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
| 3471 |
`authtypecode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3471 |
`authtypecode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 3472 |
`value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3472 |
`value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
| 3473 |
`isurl` tinyint(1) DEFAULT NULL, |
3473 |
`isurl` tinyint(1) DEFAULT NULL, |
|
Lines 3501-3507
CREATE TABLE `marc_tag_structure` (
Link Here
|
| 3501 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
3501 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
| 3502 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
3502 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
| 3503 |
`important` tinyint(4) NOT NULL DEFAULT 0, |
3503 |
`important` tinyint(4) NOT NULL DEFAULT 0, |
| 3504 |
`authorised_value` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3504 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
| 3505 |
`ind1_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3505 |
`ind1_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
| 3506 |
`ind2_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3506 |
`ind2_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
| 3507 |
`frameworkcode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3507 |
`frameworkcode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
| 3508 |
- |
|
|