@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -854,7 +854,7 @@ CREATE TABLE `auth_subfield_structure` ( `repeatable` tinyint(4) NOT NULL DEFAULT 0, `mandatory` tinyint(4) NOT NULL DEFAULT 0, `tab` tinyint(1) DEFAULT NULL, - `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', + `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `seealso` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isurl` tinyint(1) DEFAULT NULL, @@ -884,7 +884,7 @@ CREATE TABLE `auth_tag_structure` ( `libopac` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `repeatable` tinyint(4) NOT NULL DEFAULT 0, `mandatory` tinyint(4) NOT NULL DEFAULT 0, - `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', + `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`authtypecode`,`tagfield`), CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3502,7 +3502,7 @@ CREATE TABLE `marc_subfield_structure` ( `important` tinyint(4) NOT NULL DEFAULT 0, `kohafield` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tab` tinyint(1) DEFAULT NULL, - `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', + `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `authtypecode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isurl` tinyint(1) DEFAULT NULL, @@ -3536,7 +3536,7 @@ CREATE TABLE `marc_tag_structure` ( `repeatable` tinyint(4) NOT NULL DEFAULT 0, `mandatory` tinyint(4) NOT NULL DEFAULT 0, `important` tinyint(4) NOT NULL DEFAULT 0, - `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!', + `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ind1_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ind2_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `frameworkcode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', --