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

(-)a/installer/data/mysql/atomicupdate/bug_17216_2_add_fk.sql (+7 lines)
Line 0 Link Here
1
INSERT IGNORE INTO authorised_value_categories( category_name ) SELECT DISTINCT(authorised_value) FROM marc_subfield_structure;
2
3
UPDATE marc_subfield_structure SET authorised_value = NULL WHERE authorised_value = ';';
4
5
ALTER TABLE marc_subfield_structure
6
    MODIFY COLUMN authorised_value VARCHAR(32) DEFAULT NULL,
7
    ADD CONSTRAINT marc_subfield_structure_ibfk_1 FOREIGN KEY (authorised_value) REFERENCES authorised_value_categories (category_name) ON UPDATE CASCADE ON DELETE SET NULL;
(-)a/installer/data/mysql/kohastructure.sql (-3 / +3 lines)
Lines 1118-1124 CREATE TABLE `marc_subfield_structure` ( Link Here
1118
  `mandatory` tinyint(4) NOT NULL default 0,
1118
  `mandatory` tinyint(4) NOT NULL default 0,
1119
  `kohafield` varchar(40) default NULL,
1119
  `kohafield` varchar(40) default NULL,
1120
  `tab` tinyint(1) default NULL,
1120
  `tab` tinyint(1) default NULL,
1121
  `authorised_value` varchar(20) default NULL,
1121
  `authorised_value` varchar(32) default NULL,
1122
  `authtypecode` varchar(20) default NULL,
1122
  `authtypecode` varchar(20) default NULL,
1123
  `value_builder` varchar(80) default NULL,
1123
  `value_builder` varchar(80) default NULL,
1124
  `isurl` tinyint(1) default NULL,
1124
  `isurl` tinyint(1) default NULL,
Lines 1131-1137 CREATE TABLE `marc_subfield_structure` ( Link Here
1131
  PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
1131
  PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
1132
  KEY `kohafield_2` (`kohafield`),
1132
  KEY `kohafield_2` (`kohafield`),
1133
  KEY `tab` (`frameworkcode`,`tab`),
1133
  KEY `tab` (`frameworkcode`,`tab`),
1134
  KEY `kohafield` (`frameworkcode`,`kohafield`)
1134
  KEY `kohafield` (`frameworkcode`,`kohafield`),
1135
  CONSTRAINT `marc_subfield_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
1135
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1136
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1136
1137
1137
--
1138
--
1138
- 

Return to bug 17216