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

(-)a/installer/data/mysql/kohastructure.sql (-8 / +7 lines)
Lines 210-216 CREATE TABLE `additional_fields` ( Link Here
210
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier',
210
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier',
211
  `tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'tablename of the new field',
211
  `tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'tablename of the new field',
212
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'name of the field',
212
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'name of the field',
213
  `authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'is an authorised value category',
213
  `authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'is an authorised value category',
214
  `marcfield` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record',
214
  `marcfield` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record',
215
  `searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?',
215
  `searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?',
216
  PRIMARY KEY (`id`),
216
  PRIMARY KEY (`id`),
Lines 824-830 CREATE TABLE `auth_subfield_structure` ( Link Here
824
  `repeatable` tinyint(4) NOT NULL DEFAULT 0,
824
  `repeatable` tinyint(4) NOT NULL DEFAULT 0,
825
  `mandatory` tinyint(4) NOT NULL DEFAULT 0,
825
  `mandatory` tinyint(4) NOT NULL DEFAULT 0,
826
  `tab` tinyint(1) DEFAULT NULL,
826
  `tab` tinyint(1) DEFAULT NULL,
827
  `authorised_value` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
827
  `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!',
828
  `value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
828
  `value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
829
  `seealso` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
829
  `seealso` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
830
  `isurl` tinyint(1) DEFAULT NULL,
830
  `isurl` tinyint(1) DEFAULT NULL,
Lines 854-860 CREATE TABLE `auth_tag_structure` ( Link Here
854
  `libopac` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
854
  `libopac` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
855
  `repeatable` tinyint(4) NOT NULL DEFAULT 0,
855
  `repeatable` tinyint(4) NOT NULL DEFAULT 0,
856
  `mandatory` tinyint(4) NOT NULL DEFAULT 0,
856
  `mandatory` tinyint(4) NOT NULL DEFAULT 0,
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
  PRIMARY KEY (`authtypecode`,`tagfield`),
858
  PRIMARY KEY (`authtypecode`,`tagfield`),
859
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
859
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
860
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
860
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Lines 1868-1874 CREATE TABLE `club_template_enrollment_fields` ( Link Here
1868
  `club_template_id` int(11) NOT NULL,
1868
  `club_template_id` int(11) NOT NULL,
1869
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
1869
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
1870
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1870
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1871
  `authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1871
  `authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1872
  PRIMARY KEY (`id`),
1872
  PRIMARY KEY (`id`),
1873
  KEY `club_template_id` (`club_template_id`),
1873
  KEY `club_template_id` (`club_template_id`),
1874
  CONSTRAINT `club_template_enrollment_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1874
  CONSTRAINT `club_template_enrollment_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
Lines 1887-1893 CREATE TABLE `club_template_fields` ( Link Here
1887
  `club_template_id` int(11) NOT NULL,
1887
  `club_template_id` int(11) NOT NULL,
1888
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
1888
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
1889
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1889
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1890
  `authorised_value_category` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1890
  `authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1891
  PRIMARY KEY (`id`),
1891
  PRIMARY KEY (`id`),
1892
  KEY `club_template_id` (`club_template_id`),
1892
  KEY `club_template_id` (`club_template_id`),
1893
  CONSTRAINT `club_template_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1893
  CONSTRAINT `club_template_fields_ibfk_1` FOREIGN KEY (`club_template_id`) REFERENCES `club_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
Lines 3467-3473 CREATE TABLE `marc_subfield_structure` ( Link Here
3467
  `important` tinyint(4) NOT NULL DEFAULT 0,
3467
  `important` tinyint(4) NOT NULL DEFAULT 0,
3468
  `kohafield` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3468
  `kohafield` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3469
  `tab` tinyint(1) DEFAULT NULL,
3469
  `tab` tinyint(1) DEFAULT NULL,
3470
  `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3470
  `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!',
3471
  `authtypecode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3471
  `authtypecode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3472
  `value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3472
  `value_builder` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3473
  `isurl` tinyint(1) DEFAULT NULL,
3473
  `isurl` tinyint(1) DEFAULT NULL,
Lines 3501-3507 CREATE TABLE `marc_tag_structure` ( Link Here
3501
  `repeatable` tinyint(4) NOT NULL DEFAULT 0,
3501
  `repeatable` tinyint(4) NOT NULL DEFAULT 0,
3502
  `mandatory` tinyint(4) NOT NULL DEFAULT 0,
3502
  `mandatory` tinyint(4) NOT NULL DEFAULT 0,
3503
  `important` tinyint(4) NOT NULL DEFAULT 0,
3503
  `important` tinyint(4) NOT NULL DEFAULT 0,
3504
  `authorised_value` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3504
  `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '#TODO This is a AV category!',
3505
  `ind1_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
3505
  `ind1_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
3506
  `ind2_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
3506
  `ind2_defaultvalue` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
3507
  `frameworkcode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
3507
  `frameworkcode` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
3508
- 

Return to bug 29336