Lines 240-246
CREATE TABLE `additional_fields` (
Link Here
|
240 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
240 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
241 |
`tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'tablename of the new field', |
241 |
`tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'tablename of the new field', |
242 |
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'name of the field', |
242 |
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'name of the field', |
243 |
`authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'is an authorised value category', |
243 |
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'is an authorised value category', |
244 |
`marcfield` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', |
244 |
`marcfield` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', |
245 |
`searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?', |
245 |
`searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?', |
246 |
PRIMARY KEY (`id`), |
246 |
PRIMARY KEY (`id`), |
Lines 854-860
CREATE TABLE `auth_subfield_structure` (
Link Here
|
854 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
854 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
855 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
855 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
856 |
`tab` tinyint(1) DEFAULT NULL, |
856 |
`tab` tinyint(1) DEFAULT NULL, |
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 |
`value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
858 |
`value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
859 |
`seealso` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
859 |
`seealso` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
860 |
`isurl` tinyint(1) DEFAULT NULL, |
860 |
`isurl` tinyint(1) DEFAULT NULL, |
Lines 884-890
CREATE TABLE `auth_tag_structure` (
Link Here
|
884 |
`libopac` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
884 |
`libopac` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
885 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
885 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
886 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
886 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
887 |
`authorised_value` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
887 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
888 |
PRIMARY KEY (`authtypecode`,`tagfield`), |
888 |
PRIMARY KEY (`authtypecode`,`tagfield`), |
889 |
CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
889 |
CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
890 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
890 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
Lines 1899-1905
CREATE TABLE `club_template_enrollment_fields` (
Link Here
|
1899 |
`club_template_id` int(11) NOT NULL, |
1899 |
`club_template_id` int(11) NOT NULL, |
1900 |
`name` text COLLATE utf8mb4_unicode_ci NOT NULL, |
1900 |
`name` text COLLATE utf8mb4_unicode_ci NOT NULL, |
1901 |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1901 |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1902 |
`authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1902 |
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1903 |
PRIMARY KEY (`id`), |
1903 |
PRIMARY KEY (`id`), |
1904 |
KEY `club_template_id` (`club_template_id`), |
1904 |
KEY `club_template_id` (`club_template_id`), |
1905 |
CONSTRAINT `club_template_enrollment_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
1905 |
CONSTRAINT `club_template_enrollment_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
Lines 1918-1924
CREATE TABLE `club_template_fields` (
Link Here
|
1918 |
`club_template_id` int(11) NOT NULL, |
1918 |
`club_template_id` int(11) NOT NULL, |
1919 |
`name` text COLLATE utf8mb4_unicode_ci NOT NULL, |
1919 |
`name` text COLLATE utf8mb4_unicode_ci NOT NULL, |
1920 |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1920 |
`description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1921 |
`authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1921 |
`authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
1922 |
PRIMARY KEY (`id`), |
1922 |
PRIMARY KEY (`id`), |
1923 |
KEY `club_template_id` (`club_template_id`), |
1923 |
KEY `club_template_id` (`club_template_id`), |
1924 |
CONSTRAINT `club_template_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
1924 |
CONSTRAINT `club_template_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
Lines 3502-3508
CREATE TABLE `marc_subfield_structure` (
Link Here
|
3502 |
`important` tinyint(4) NOT NULL DEFAULT 0, |
3502 |
`important` tinyint(4) NOT NULL DEFAULT 0, |
3503 |
`kohafield` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3503 |
`kohafield` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3504 |
`tab` tinyint(1) DEFAULT NULL, |
3504 |
`tab` tinyint(1) DEFAULT NULL, |
3505 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3505 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
3506 |
`authtypecode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3506 |
`authtypecode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3507 |
`value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3507 |
`value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3508 |
`isurl` tinyint(1) DEFAULT NULL, |
3508 |
`isurl` tinyint(1) DEFAULT NULL, |
Lines 3536-3542
CREATE TABLE `marc_tag_structure` (
Link Here
|
3536 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
3536 |
`repeatable` tinyint(4) NOT NULL DEFAULT 0, |
3537 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
3537 |
`mandatory` tinyint(4) NOT NULL DEFAULT 0, |
3538 |
`important` tinyint(4) NOT NULL DEFAULT 0, |
3538 |
`important` tinyint(4) NOT NULL DEFAULT 0, |
3539 |
`authorised_value` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
3539 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
3540 |
`ind1_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3540 |
`ind1_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3541 |
`ind2_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3541 |
`ind2_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3542 |
`frameworkcode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3542 |
`frameworkcode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', |
3543 |
- |
|
|