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

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

Return to bug 29336