#
# MySQL upgrade script for upgrade database from version 2.0.61 to 2.0.62
#



#-----------------------------------------------------------------------------
#-- translation
#-----------------------------------------------------------------------------

INSERT INTO translation (code) VALUES ('drafts');
INSERT INTO translation (code) VALUES ('orders-management');
INSERT INTO translation (code) VALUES ('settings');
INSERT INTO translation (code) VALUES ('administration');
INSERT INTO translation (code) VALUES ('statistics');
INSERT INTO translation (code) VALUES ('budgets-states');
INSERT INTO translation (code) VALUES ('ecd-title');
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'en', 'Drafts' FROM translation WHERE code = 'drafts';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'fr', 'Brouillons' FROM translation WHERE code = 'drafts';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'en', 'Orders management' FROM translation WHERE code = 'orders-management';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'fr', 'Gestion des commandes' FROM translation WHERE code = 'orders-management';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'en', 'Settings' FROM translation WHERE code = 'settings';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'fr', 'Préférences' FROM translation WHERE code = 'settings';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'en', 'Administration' FROM translation WHERE code = 'administration';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'fr', 'Administration' FROM translation WHERE code = 'administration';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'en', 'Statistics' FROM translation WHERE code = 'statistics';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'fr', 'Statistiques' FROM translation WHERE code = 'statistics';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'en', 'Budgets states' FROM translation WHERE code = 'budgets-states';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'fr', 'Gestion du budget' FROM translation WHERE code = 'budgets-states';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'en', 'EasyCreaDoc' FROM translation WHERE code = 'ecd-title';
INSERT INTO translation_i18n (id, culture, value) SELECT translation.id, 'fr', 'EasyCreaDoc' FROM translation WHERE code = 'ecd-title';


