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 1120-1126 CREATE TABLE `marc_subfield_structure` ( Link Here
1120
  `mandatory` tinyint(4) NOT NULL default 0,
1120
  `mandatory` tinyint(4) NOT NULL default 0,
1121
  `kohafield` varchar(40) default NULL,
1121
  `kohafield` varchar(40) default NULL,
1122
  `tab` tinyint(1) default NULL,
1122
  `tab` tinyint(1) default NULL,
1123
  `authorised_value` varchar(20) default NULL,
1123
  `authorised_value` varchar(32) default NULL,
1124
  `authtypecode` varchar(20) default NULL,
1124
  `authtypecode` varchar(20) default NULL,
1125
  `value_builder` varchar(80) default NULL,
1125
  `value_builder` varchar(80) default NULL,
1126
  `isurl` tinyint(1) default NULL,
1126
  `isurl` tinyint(1) default NULL,
Lines 1133-1139 CREATE TABLE `marc_subfield_structure` ( Link Here
1133
  PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
1133
  PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
1134
  KEY `kohafield_2` (`kohafield`),
1134
  KEY `kohafield_2` (`kohafield`),
1135
  KEY `tab` (`frameworkcode`,`tab`),
1135
  KEY `tab` (`frameworkcode`,`tab`),
1136
  KEY `kohafield` (`frameworkcode`,`kohafield`)
1136
  KEY `kohafield` (`frameworkcode`,`kohafield`),
1137
  CONSTRAINT `marc_subfield_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
1137
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1138
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1138
1139
1139
--
1140
--
1140
- 

Return to bug 17216