ALJ6qgBL

1CREATE TABLE IF NOT EXISTS `lang` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
4  PRIMARY KEY (`id`)
5) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
6
7
8CREATE TABLE IF NOT EXISTS `programs` (
9  `id` int(11) NOT NULL AUTO_INCREMENT,
10  `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
11  PRIMARY KEY (`id`)
12) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
13
14
15CREATE TABLE IF NOT EXISTS `programs_lang` (
16  `id_lang` int(11) NOT NULL,
17  `id_programs` int(11) NOT NULL,
18  `priority` int(11) NOT NULL DEFAULT '0'
19) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
20
21
22INSERT INTO `programs` (`id`, `name`) VALUES
23(1, 'парсер'),
24(2, 'snippet_site');
25
26INSERT INTO `lang` (`id`, `name`) VALUES
27(1, 'python'),
28(2, 'php'),
29(3, 'cpp'),
30(4, 'js'),
31(5, 'jango');
32
33INSERT INTO `programs_lang` (`id_lang`, `id_programs`, `priority`) VALUES
34(1, 1, 1),
35(2, 1, 2),
36(3, 1, 3),
37(4, 2, 1),
38(5, 2, 2);
39
40select programs.id, programs.name, lang.id, lang.name from programs 
41INNER JOIN programs_lang ON programs_lang.id_programs = programs.id
42INNER JOIN lang ON programs_lang.id_lang = lang.id