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