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

(-)a/installer/data/mysql/atomicupdate/bug_20307.sql (+2 lines)
Line 1 Link Here
1
alter table localization add column interface varchar(30) default null after entity;
1
alter table localization add column interface varchar(30) default null after entity;
2
alter table localization drop constraint entity_code_lang;
3
alter table localization add unique key entity_code_interface_lang (entity, code, interface, lang);
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 3701-3707 CREATE TABLE `localization` ( Link Here
3701
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3701
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3702
      translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
3702
      translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
3703
      PRIMARY KEY (localization_id),
3703
      PRIMARY KEY (localization_id),
3704
      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
3704
      UNIQUE KEY `entity_code_interface_lang` (`entity`,`code`,`interface`,`lang`)
3705
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3705
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3706
3706
3707
--
3707
--
3708
- 

Return to bug 20307