View | Details | Raw Unified | Return to bug 29336
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
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
- 

Return to bug 29336