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 3664-3670 CREATE TABLE `localization` ( Link Here
3664
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3664
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3665
      translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
3665
      translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
3666
      PRIMARY KEY (localization_id),
3666
      PRIMARY KEY (localization_id),
3667
      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
3667
      UNIQUE KEY `entity_code_interface_lang` (`entity`,`code`,`interface`,`lang`)
3668
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3668
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3669
3669
3670
--
3670
--
3671
- 

Return to bug 20307