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

(-)a/installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql (+2 lines)
Lines 45-47 ALTER TABLE items_search_fields Link Here
45
    DROP FOREIGN KEY items_search_fields_authorised_values_category;
45
    DROP FOREIGN KEY items_search_fields_authorised_values_category;
46
ALTER TABLE items_search_fields
46
ALTER TABLE items_search_fields
47
    ADD CONSTRAINT `items_search_fields_authorised_values_category` FOREIGN KEY (`authorised_values_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE;
47
    ADD CONSTRAINT `items_search_fields_authorised_values_category` FOREIGN KEY (`authorised_values_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE;
48
ALTER TABLE authorised_values
49
    ADD CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE;
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 118-124 CREATE TABLE `authorised_values` ( -- stores values for authorized values catego Link Here
118
  PRIMARY KEY  (`id`),
118
  PRIMARY KEY  (`id`),
119
  KEY `name` (`category`),
119
  KEY `name` (`category`),
120
  KEY `lib` (`lib`),
120
  KEY `lib` (`lib`),
121
  KEY `auth_value_idx` (`authorised_value`)
121
  KEY `auth_value_idx` (`authorised_value`),
122
  CONSTRAINT `authorised_values_authorised_values_category` FOREIGN KEY (`category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE CASCADE ON UPDATE CASCADE
122
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
123
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
123
124
124
--
125
--
125
- 

Return to bug 17216