St4MbEju

1CREATE TEMPORARY TABLE `expense_types_lang` (
2      `id` int(11) NOT NULL,
3      `value` varchar(50) COLLATE utf8_czech_ci NOT NULL,
4      `template` varchar(50) COLLATE utf8_czech_ci NOT NULL,
5      `lang` varchar(5) COLLATE utf8_czech_ci NOT NULL
6) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
7
8INSERT INTO `expense_types_lang` (`id`, `value`, `template`, `lang`) VALUES
9(1,	'Obecné',	'general',	'ces'),
10(1,	'General',	'general',	'eng'),
11(1,	'Všeobecné',	'general',	'slk'),
12(1,	'Allgemein',	'general',	'deu'),
13(1,	'în general',	'general',	'rom'),
14(2,	'Cestovné (auto)',	'travel',	'ces'),
15(2,	'Reise mit dem Auto',	'travel',	'deu'),
16(2,	'Călătorind cu mașina',	'travel',	'rom'),
17(2,	'Cestovné (auto)',	'travel',	'slk'),
18(2,	'Travel by car',	'travel',	'eng');
19
20
21INSERT INTO expenses_types (`id`, `name`, `template`) SELECT l.`id`,`value`, `template`FROM expense_types_lang l INNER JOIN company_info ON company_info.language = l.lang;
22
23DROP TABLE IF EXISTS `expense_types_lang`;