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 3680-3686 CREATE TABLE `localization` ( Link Here
3680
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3680
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3681
      translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
3681
      translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
3682
      PRIMARY KEY (localization_id),
3682
      PRIMARY KEY (localization_id),
3683
      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
3683
      UNIQUE KEY `entity_code_interface_lang` (`entity`,`code`,`interface`,`lang`)
3684
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3684
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3685
3685
3686
--
3686
--
3687
- 

Return to bug 20307