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(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
857 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
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(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
887 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
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 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 COMMENT '#TODO This is a AV category!', |
3505 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
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(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', |
3539 |
`authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
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 |
- |
|
|