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 3738-3744 CREATE TABLE `localization` ( Link Here
3738
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3738
      lang varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, -- could be a foreign key
3739
      translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
3739
      translation MEDIUMTEXT COLLATE utf8mb4_unicode_ci,
3740
      PRIMARY KEY (localization_id),
3740
      PRIMARY KEY (localization_id),
3741
      UNIQUE KEY `entity_code_lang` (`entity`,`code`,`lang`)
3741
      UNIQUE KEY `entity_code_interface_lang` (`entity`,`code`,`interface`,`lang`)
3742
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3742
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3743
3743
3744
--
3744
--
3745
- 

Return to bug 20307