Редакция 555 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 555 | Редакция 673 | ||
---|---|---|---|
1 | -- phpMyAdmin SQL Dump
|
1 | -- phpMyAdmin SQL Dump
|
2 | -- version 3.0.0-alpha
|
2 | -- version 3.0.0-alpha
|
3 | -- http://www.phpmyadmin.net
|
3 | -- http://www.phpmyadmin.net
|
4 | --
|
4 | --
|
5 | -- Хост: localhost
|
5 | -- Хост: localhost
|
6 | -- Время создания: Ноя 26 2009 г., 13:47
|
6 | -- Время создания: Ноя 30 2009 г., 14:09
|
7 | -- Версия сервера: 5.1.37
|
7 | -- Версия сервера: 5.1.37
|
8 | -- Версия PHP: 5.2.11-1
|
8 | -- Версия PHP: 5.2.11-1
|
9 | 9 | ||
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
11 | 11 | ||
12 | 12 | ||
13 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
13 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
14 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
14 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
15 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
15 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
16 | /*!40101 SET NAMES utf8 */;
|
16 | /*!40101 SET NAMES utf8 */;
|
17 | 17 | ||
18 | --
|
18 | --
|
19 | -- База данных: `generator`
|
19 | -- База данных: `generator`
|
20 | --
|
20 | --
|
21 | 21 | ||
22 | -- --------------------------------------------------------
|
22 | -- --------------------------------------------------------
|
23 | 23 | ||
24 | --
|
24 | --
|
25 | -- Структура таблицы `g_arch`
|
25 | -- Структура таблицы `g_arch`
|
26 | --
|
26 | --
|
27 | 27 | ||
28 | DROP TABLE IF EXISTS `g_arch`; |
28 | DROP TABLE IF EXISTS `g_arch`; |
29 | CREATE TABLE IF NOT EXISTS `g_arch` ( |
29 | CREATE TABLE IF NOT EXISTS `g_arch` ( |
30 | `arch_id` INT(2) NOT NULL AUTO_INCREMENT, |
30 | `arch_id` INT(2) NOT NULL AUTO_INCREMENT, |
31 | `arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
31 | `arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
32 | PRIMARY KEY (`arch_id`), |
32 | PRIMARY KEY (`arch_id`), |
33 | KEY `arch` (`arch`) |
33 | KEY `arch` (`arch`) |
34 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ; |
34 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ; |
35 | 35 | ||
36 | --
|
36 | --
|
37 | -- Дамп данных таблицы `g_arch`
|
37 | -- Дамп данных таблицы `g_arch`
|
38 | --
|
38 | --
|
39 | 39 | ||
40 | INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES |
40 | INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES |
41 | (1, 'i386'), |
41 | (1, 'i386'), |
42 | (2, 'amd64'); |
42 | (2, 'amd64'); |
43 | 43 | ||
44 | -- --------------------------------------------------------
|
44 | -- --------------------------------------------------------
|
45 | 45 | ||
46 | --
|
46 | --
|
47 | -- Структура таблицы `g_arch2rep`
|
47 | -- Структура таблицы `g_arch2rep`
|
48 | --
|
48 | --
|
49 | 49 | ||
50 | DROP TABLE IF EXISTS `g_arch2rep`; |
50 | DROP TABLE IF EXISTS `g_arch2rep`; |
51 | CREATE TABLE IF NOT EXISTS `g_arch2rep` ( |
51 | CREATE TABLE IF NOT EXISTS `g_arch2rep` ( |
52 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
52 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
53 | `arch_id` INT(2) NOT NULL, |
53 | `arch_id` INT(2) NOT NULL, |
54 | `rep_id` INT(5) NOT NULL, |
54 | `rep_id` INT(5) NOT NULL, |
55 | PRIMARY KEY (`id`), |
55 | PRIMARY KEY (`id`), |
56 | KEY `arch_id` (`arch_id`,`rep_id`) |
56 | KEY `arch_id` (`arch_id`,`rep_id`) |
57 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ; |
57 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=103 ; |
58 | 58 | ||
59 | --
|
59 | --
|
60 | -- Дамп данных таблицы `g_arch2rep`
|
60 | -- Дамп данных таблицы `g_arch2rep`
|
61 | --
|
61 | --
|
62 | 62 | ||
- | 63 | INSERT INTO `g_arch2rep` (`id`, `arch_id`, `rep_id`) VALUES |
|
- | 64 | (82, 2, 8), |
|
- | 65 | (81, 1, 8), |
|
- | 66 | (30, 2, 7), |
|
- | 67 | (29, 1, 7), |
|
- | 68 | (28, 2, 6), |
|
- | 69 | (27, 1, 6), |
|
- | 70 | (62, 2, 5), |
|
- | 71 | (61, 1, 5), |
|
- | 72 | (9, 1, 2), |
|
- | 73 | (10, 2, 2), |
|
- | 74 | (11, 1, 3), |
|
- | 75 | (12, 2, 3), |
|
- | 76 | (13, 1, 4), |
|
- | 77 | (14, 2, 4), |
|
- | 78 | (84, 2, 9), |
|
- | 79 | (83, 1, 9), |
|
- | 80 | (92, 2, 10), |
|
- | 81 | (91, 1, 10), |
|
- | 82 | (86, 2, 11), |
|
- | 83 | (85, 1, 11), |
|
- | 84 | (43, 1, 12), |
|
- | 85 | (44, 2, 12), |
|
- | 86 | (45, 1, 13), |
|
- | 87 | (46, 2, 13), |
|
- | 88 | (88, 2, 14), |
|
- | 89 | (87, 1, 14), |
|
- | 90 | (49, 1, 15), |
|
- | 91 | (50, 2, 15), |
|
- | 92 | (90, 2, 16), |
|
- | 93 | (89, 1, 16), |
|
- | 94 | (53, 1, 17), |
|
- | 95 | (54, 2, 17), |
|
- | 96 | (94, 2, 18), |
|
- | 97 | (93, 1, 18), |
|
- | 98 | (96, 2, 19), |
|
- | 99 | (95, 1, 19), |
|
- | 100 | (59, 1, 20), |
|
- | 101 | (60, 2, 20), |
|
- | 102 | (63, 1, 21), |
|
- | 103 | (64, 2, 21), |
|
- | 104 | (69, 1, 22), |
|
- | 105 | (70, 2, 22), |
|
- | 106 | (78, 2, 23), |
|
- | 107 | (77, 1, 23), |
|
- | 108 | (73, 1, 24), |
|
- | 109 | (74, 2, 24), |
|
- | 110 | (75, 1, 25), |
|
- | 111 | (76, 2, 25), |
|
- | 112 | (79, 1, 26), |
|
- | 113 | (80, 2, 26), |
|
- | 114 | (97, 1, 27), |
|
- | 115 | (98, 2, 27), |
|
- | 116 | (102, 2, 28), |
|
- | 117 | (101, 1, 28); |
|
63 | 118 | ||
64 | -- --------------------------------------------------------
|
119 | -- --------------------------------------------------------
|
65 | 120 | ||
66 | --
|
121 | --
|
67 | -- Структура таблицы `g_distribution`
|
122 | -- Структура таблицы `g_distribution`
|
68 | --
|
123 | --
|
69 | 124 | ||
70 | DROP TABLE IF EXISTS `g_distribution`; |
125 | DROP TABLE IF EXISTS `g_distribution`; |
71 | CREATE TABLE IF NOT EXISTS `g_distribution` ( |
126 | CREATE TABLE IF NOT EXISTS `g_distribution` ( |
72 | `dist_id` INT(5) NOT NULL AUTO_INCREMENT, |
127 | `dist_id` INT(5) NOT NULL AUTO_INCREMENT, |
73 | `distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
128 | `distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
74 | `distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
129 | `distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
75 | `disttype` INT(1) NOT NULL, |
130 | `disttype` INT(1) NOT NULL, |
76 | `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, |
131 | `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, |
77 | PRIMARY KEY (`dist_id`), |
132 | PRIMARY KEY (`dist_id`), |
78 | KEY `disttype` (`disttype`,`distlogo`) |
133 | KEY `disttype` (`disttype`,`distlogo`) |
79 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=6 ; |
134 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=7 ; |
80 | 135 | ||
81 | --
|
136 | --
|
82 | -- Дамп данных таблицы `g_distribution`
|
137 | -- Дамп данных таблицы `g_distribution`
|
83 | --
|
138 | --
|
84 | 139 | ||
85 | INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES |
140 | INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES |
86 | (1, 'Debian GNU/Linux', 'debian', 1, '1'), |
141 | (1, 'Debian GNU/Linux', 'debian', 1, '1'), |
87 | (2, 'Ubuntu Linux', 'ubuntu', 1, '0'), |
142 | (2, 'Ubuntu Linux', 'ubuntu', 1, '0'), |
88 | (5, 'ALTLinux', 'altlinux', 2, '0'); |
143 | (5, 'ALTLinux', 'altlinux', 2, '0'), |
- | 144 | (6, 'InfraLinux', 'infralinux', 1, '0'); |
|
89 | 145 | ||
90 | -- --------------------------------------------------------
|
146 | -- --------------------------------------------------------
|
91 | 147 | ||
92 | --
|
148 | --
|
93 | -- Структура таблицы `g_dtype`
|
149 | -- Структура таблицы `g_dtype`
|
94 | --
|
150 | --
|
95 | 151 | ||
96 | DROP TABLE IF EXISTS `g_dtype`; |
152 | DROP TABLE IF EXISTS `g_dtype`; |
97 | CREATE TABLE IF NOT EXISTS `g_dtype` ( |
153 | CREATE TABLE IF NOT EXISTS `g_dtype` ( |
98 | `type_id` INT(1) NOT NULL AUTO_INCREMENT, |
154 | `type_id` INT(1) NOT NULL AUTO_INCREMENT, |
99 | `type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL, |
155 | `type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL, |
100 | PRIMARY KEY (`type_id`), |
156 | PRIMARY KEY (`type_id`), |
101 | KEY `type` (`type`) |
157 | KEY `type` (`type`) |
102 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
158 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
103 | 159 | ||
104 | --
|
160 | --
|
105 | -- Дамп данных таблицы `g_dtype`
|
161 | -- Дамп данных таблицы `g_dtype`
|
106 | --
|
162 | --
|
107 | 163 | ||
108 | INSERT INTO `g_dtype` (`type_id`, `type`) VALUES |
164 | INSERT INTO `g_dtype` (`type_id`, `type`) VALUES |
109 | (1, 'deb'), |
165 | (1, 'deb'), |
110 | (2, 'rpm'); |
166 | (2, 'rpm'); |
111 | 167 | ||
112 | -- --------------------------------------------------------
|
168 | -- --------------------------------------------------------
|
113 | 169 | ||
114 | --
|
170 | --
|
115 | -- Структура таблицы `g_protos`
|
171 | -- Структура таблицы `g_protos`
|
116 | --
|
172 | --
|
117 | 173 | ||
118 | DROP TABLE IF EXISTS `g_protos`; |
174 | DROP TABLE IF EXISTS `g_protos`; |
119 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
175 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
120 | `proto_id` INT(1) NOT NULL AUTO_INCREMENT, |
176 | `proto_id` INT(1) NOT NULL AUTO_INCREMENT, |
121 | `proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
177 | `proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
122 | PRIMARY KEY (`proto_id`), |
178 | PRIMARY KEY (`proto_id`), |
123 | KEY `proto` (`proto`) |
179 | KEY `proto` (`proto`) |
124 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ; |
180 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ; |
125 | 181 | ||
126 | --
|
182 | --
|
127 | -- Дамп данных таблицы `g_protos`
|
183 | -- Дамп данных таблицы `g_protos`
|
128 | --
|
184 | --
|
129 | 185 | ||
130 | INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES |
186 | INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES |
131 | (1, 'http://'); |
187 | (1, 'http://'); |
132 | 188 | ||
133 | -- --------------------------------------------------------
|
189 | -- --------------------------------------------------------
|
134 | 190 | ||
135 | --
|
191 | --
|
136 | -- Структура таблицы `g_repfolder`
|
192 | -- Структура таблицы `g_repfolder`
|
137 | --
|
193 | --
|
138 | 194 | ||
139 | DROP TABLE IF EXISTS `g_repfolder`; |
195 | DROP TABLE IF EXISTS `g_repfolder`; |
140 | CREATE TABLE IF NOT EXISTS `g_repfolder` ( |
196 | CREATE TABLE IF NOT EXISTS `g_repfolder` ( |
141 | `rfolder_id` INT(5) NOT NULL AUTO_INCREMENT, |
197 | `rfolder_id` INT(5) NOT NULL AUTO_INCREMENT, |
142 | `rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
198 | `rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
143 | PRIMARY KEY (`rfolder_id`), |
199 | PRIMARY KEY (`rfolder_id`), |
144 | KEY `rhost_id` (`rfolder`) |
200 | KEY `rhost_id` (`rfolder`) |
145 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ; |
201 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=23 ; |
146 | 202 | ||
147 | --
|
203 | --
|
148 | -- Дамп данных таблицы `g_repfolder`
|
204 | -- Дамп данных таблицы `g_repfolder`
|
149 | --
|
205 | --
|
150 | 206 | ||
- | 207 | INSERT INTO `g_repfolder` (`rfolder_id`, `rfolder`) VALUES |
|
- | 208 | (1, '/debian'), |
|
- | 209 | (2, '/debian-backports'), |
|
- | 210 | (3, '/debian-multimedia'), |
|
- | 211 | (4, '/opera-beta'), |
|
- | 212 | (5, '/opera'), |
|
- | 213 | (6, '/debian-security'), |
|
- | 214 | (7, '/debian-volatile'), |
|
- | 215 | (8, '/debian-winehq'), |
|
- | 216 | (9, '/gfoss'), |
|
- | 217 | (10, '/2gis'), |
|
- | 218 | (11, '/freenx'), |
|
- | 219 | (12, '/virtualbox'), |
|
- | 220 | (13, '/ubuntu'), |
|
- | 221 | (14, '/playonlinux'), |
|
- | 222 | (15, '/xneur'), |
|
- | 223 | (16, '/ubuntu-winehq'), |
|
- | 224 | (17, '/ubuntu-commercial'), |
|
- | 225 | (18, '/infralinux'), |
|
- | 226 | (19, '/sarge-backports'), |
|
- | 227 | (20, '/sarge-proposed-updates'), |
|
- | 228 | (21, '/sarge'), |
|
- | 229 | (22, '/p5/branch'); |
|
151 | 230 | ||
152 | -- --------------------------------------------------------
|
231 | -- --------------------------------------------------------
|
153 | 232 | ||
154 | --
|
233 | --
|
155 | -- Структура таблицы `g_rephost`
|
234 | -- Структура таблицы `g_rephost`
|
156 | --
|
235 | --
|
157 | 236 | ||
158 | DROP TABLE IF EXISTS `g_rephost`; |
237 | DROP TABLE IF EXISTS `g_rephost`; |
159 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
238 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
160 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
239 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
161 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
240 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
162 | PRIMARY KEY (`rhost_id`), |
241 | PRIMARY KEY (`rhost_id`), |
163 | KEY `proto_id` (`rhost`) |
242 | KEY `proto_id` (`rhost`) |
164 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ; |
243 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=8 ; |
165 | 244 | ||
166 | --
|
245 | --
|
167 | -- Дамп данных таблицы `g_rephost`
|
246 | -- Дамп данных таблицы `g_rephost`
|
168 | --
|
247 | --
|
169 | 248 | ||
170 | INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
249 | INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
171 | (1, 'apt.nix-files.org.ru'), |
250 | (1, 'apt.nix-files.org.ru'), |
172 | (2, 'hyperion.uni-altai.ru'), |
251 | (2, 'hyperion.uni-altai.ru'), |
173 | (3, 'apt.nix-files.uni-altai.ru'); |
252 | (3, 'apt.nix-files.uni-altai.ru'), |
- | 253 | (7, 'alt.nix-files.org.ru'); |
|
174 | 254 | ||
175 | -- --------------------------------------------------------
|
255 | -- --------------------------------------------------------
|
176 | 256 | ||
177 | --
|
257 | --
|
178 | -- Структура таблицы `g_repository`
|
258 | -- Структура таблицы `g_repository`
|
179 | --
|
259 | --
|
180 | 260 | ||
181 | DROP TABLE IF EXISTS `g_repository`; |
261 | DROP TABLE IF EXISTS `g_repository`; |
182 | CREATE TABLE IF NOT EXISTS `g_repository` ( |
262 | CREATE TABLE IF NOT EXISTS `g_repository` ( |
183 | `rep_id` INT(5) NOT NULL AUTO_INCREMENT, |
263 | `rep_id` INT(5) NOT NULL AUTO_INCREMENT, |
184 | `proto_id` INT(1) NOT NULL, |
264 | `proto_id` INT(1) NOT NULL, |
185 | `rhost_id` INT(3) NOT NULL, |
265 | `rhost_id` INT(3) NOT NULL, |
186 | `rfolder_id` INT(5) NOT NULL, |
266 | `rfolder_id` INT(5) NOT NULL, |
187 | `version` INT(5) NOT NULL, |
267 | `version` INT(5) NOT NULL, |
188 | `rtype_id` INT(2) NOT NULL, |
268 | `rtype_id` INT(2) NOT NULL, |
189 | `scheme_id` INT(2) NOT NULL, |
269 | `scheme_id` INT(2) NOT NULL, |
- | 270 | `sign_id` INT(3) NOT NULL, |
|
190 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
271 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
191 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
272 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
192 | `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL, |
273 | `repkey` VARCHAR(200) COLLATE utf8_unicode_ci NOT NULL, |
193 | PRIMARY KEY (`rep_id`), |
274 | PRIMARY KEY (`rep_id`), |
194 | KEY `proto_id` (`proto_id`), |
275 | KEY `proto_id` (`proto_id`), |
195 | KEY `rhost_id` (`rhost_id`), |
276 | KEY `rhost_id` (`rhost_id`), |
196 | KEY `rfolder_id` (`rfolder_id`), |
277 | KEY `rfolder_id` (`rfolder_id`), |
197 | KEY `version` (`version`), |
278 | KEY `version` (`version`), |
198 | KEY `rtype_id` (`rtype_id`), |
279 | KEY `rtype_id` (`rtype_id`), |
199 | KEY `scheme_id` (`scheme_id`) |
280 | KEY `scheme_id` (`scheme_id`), |
- | 281 | KEY `sign_id` (`sign_id`) |
|
200 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ; |
282 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ; |
201 | 283 | ||
202 | --
|
284 | --
|
203 | -- Дамп данных таблицы `g_repository`
|
285 | -- Дамп данных таблицы `g_repository`
|
204 | --
|
286 | --
|
205 | 287 | ||
206 | INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `repname`, `repinfo`, `repkey`) VALUES |
288 | INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `sign_id`, `repname`, `repinfo`, `repkey`) VALUES |
- | 289 | (5, 1, 1, 21, 1, 1, 1, 0, 'Sarge Base', 'Базовый репозиторий для sarge', ''), |
|
- | 290 | (2, 1, 1, 1, 2, 1, 1, 0, 'Etch Base', 'Основной репозиторий для etch', ''), |
|
- | 291 | (3, 1, 1, 2, 2, 2, 6, 0, 'Etch Backports', 'Бэкпортированный софт для etch', ''), |
|
207 | (1, 1, 1, 1, 1, 1, 1, 'Sarge Base', 'eeee', ''); |
292 | (4, 1, 1, 12, 2, 3, 1, 0, 'VirtualBox', 'Sun VirtualBox', ''), |
- | 293 | (6, 1, 2, 1, 3, 3, 1, 0, 'Hyperion', 'Неофициальный репозиторий АлтГПА и AltLUG\\''а', 'wget -O - http://hyperion.uni-altai.ru/hyperion.key | apt-key add -'), |
|
- | 294 | (7, 1, 2, 1, 4, 3, 1, 0, 'Hyperion', 'Неофициальный репозиторий АлтГПА и AltLUG\\''а', 'wget -O - http://hyperion.uni-altai.ru/hyperion.key | apt-key add -'), |
|
- | 295 | (8, 1, 1, 1, 3, 1, 1, 0, 'Lenny Base', 'Базовый репозиторий Lenny', 'apt-get install debian-keyring'), |
|
- | 296 | (9, 1, 1, 6, 3, 2, 3, 0, 'Security', 'Обновления безопасности', 'apt-get install debian-keyring'), |
|
- | 297 | (10, 1, 1, 2, 3, 2, 6, 0, 'Backports', 'Бэкпортированное ПО для Lenny', 'apt-get install debian-backports-keyring'), |
|
- | 298 | (11, 1, 1, 7, 3, 2, 4, 0, 'Volatile', 'Непостоянные обновления для Lenny', 'apt-get install debian-keyring'), |
|
- | 299 | (12, 1, 1, 13, 7, 1, 1, 0, 'Jaunty Base', 'Базовый репозиторий Jaunty Jackalope', ''), |
|
- | 300 | (13, 1, 1, 1, 13, 1, 1, 0, 'Sid Base', 'Базовый репозиторий', ''), |
|
- | 301 | (14, 1, 1, 1, 3, 2, 2, 0, 'Updates', 'Предлагаемые обновления', 'apt-get install debian-keyring'), |
|
- | 302 | (15, 1, 1, 3, 3, 3, 1, 0, 'Multimedia', 'Мультимедийное ПО и набор кодеков', ''), |
|
- | 303 | (16, 1, 1, 7, 3, 2, 5, 0, 'Volatile-sloppy', 'Непостоянные обновления для Lenny', 'apt-get install debian-keyring'), |
|
- | 304 | (17, 1, 1, 8, 3, 3, 1, 0, 'WineHQ', 'Репозиторий с WineHQ', ''), |
|
- | 305 | (18, 1, 1, 5, 3, 3, 1, 0, 'Opera', 'Репозиторий с браузером Opera', 'wget -O - http://deb.opera.com/archive.key | apt-key add -'), |
|
- | 306 | (19, 1, 1, 4, 3, 3, 1, 0, 'Opera Beta', 'Репозиторий с бета-версиями браузера Opera', 'wget -O - http://deb.opera.com/archive.key | apt-key add -'), |
|
- | 307 | (20, 1, 1, 9, 3, 3, 1, 0, 'gfoss', 'Репозиторий с ГИС', ''), |
|
- | 308 | (21, 1, 1, 10, 3, 3, 1, 0, '2GIS', 'Репозиторий с 2GIS', ''), |
|
- | 309 | (22, 1, 1, 18, 14, 1, 1, 0, 'InfraLinux 8.10 Base', 'базовый репозиторий', ''), |
|
- | 310 | (23, 1, 1, 18, 14, 2, 8, 0, 'Security', 'Обновления безопасности', ''), |
|
- | 311 | (24, 1, 1, 18, 14, 2, 7, 0, 'Updates', 'Предлагаемые обновления', ''), |
|
- | 312 | (25, 1, 1, 18, 14, 2, 6, 0, 'Backports', 'Официально неподдерживаемые обновления', ''), |
|
- | 313 | (26, 1, 1, 12, 3, 3, 1, 0, 'VirtualBox', 'Репозиторий с Sun Microsystems VirtualBox', ''), |
|
- | 314 | (27, 1, 7, 22, 12, 1, 11, 2, 'Master Base', 'Базовый репозиторий', ''), |
|
- | 315 | (28, 1, 7, 22, 12, 2, 11, 3, 'Security', 'Обновления безопасности', ''); |
|
208 | 316 | ||
209 | -- --------------------------------------------------------
|
317 | -- --------------------------------------------------------
|
210 | 318 | ||
211 | --
|
319 | --
|
212 | -- Структура таблицы `g_repscheme`
|
320 | -- Структура таблицы `g_repscheme`
|
213 | --
|
321 | --
|
214 | 322 | ||
215 | DROP TABLE IF EXISTS `g_repscheme`; |
323 | DROP TABLE IF EXISTS `g_repscheme`; |
216 | CREATE TABLE IF NOT EXISTS `g_repscheme` ( |
324 | CREATE TABLE IF NOT EXISTS `g_repscheme` ( |
217 | `scheme_id` INT(2) NOT NULL AUTO_INCREMENT, |
325 | `scheme_id` INT(2) NOT NULL AUTO_INCREMENT, |
218 | `scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
326 | `scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
219 | PRIMARY KEY (`scheme_id`), |
327 | PRIMARY KEY (`scheme_id`), |
220 | KEY `scheme` (`scheme`) |
328 | KEY `scheme` (`scheme`) |
221 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ; |
329 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ; |
222 | 330 | ||
223 | --
|
331 | --
|
224 | -- Дамп данных таблицы `g_repscheme`
|
332 | -- Дамп данных таблицы `g_repscheme`
|
225 | --
|
333 | --
|
226 | 334 | ||
227 | INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES |
335 | INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES |
228 | (1, '{DIST}'), |
336 | (1, '{DIST}'), |
229 | (2, '{DIST}-proposed-updates'), |
337 | (2, '{DIST}-proposed-updates'), |
230 | (3, '{DIST}/updates'), |
338 | (3, '{DIST}/updates'), |
231 | (4, '{DIST}/volatile'), |
339 | (4, '{DIST}/volatile'), |
232 | (5, '{DIST}/volatile-sloppy'), |
340 | (5, '{DIST}/volatile-sloppy'), |
233 | (6, '{DIST}-backports'), |
341 | (6, '{DIST}-backports'), |
234 | (7, '{DIST}-updates'), |
342 | (7, '{DIST}-updates'), |
235 | (8, '{DIST}-security'); |
343 | (8, '{DIST}-security'), |
- | 344 | (9, 'noarch'), |
|
- | 345 | (10, 'x86_64'), |
|
- | 346 | (11, 'i586'), |
|
- | 347 | (12, 'x86_32'); |
|
236 | 348 | ||
237 | -- --------------------------------------------------------
|
349 | -- --------------------------------------------------------
|
238 | 350 | ||
239 | --
|
351 | --
|
240 | -- Структура таблицы `g_rtype`
|
352 | -- Структура таблицы `g_rtype`
|
241 | --
|
353 | --
|
242 | 354 | ||
243 | DROP TABLE IF EXISTS `g_rtype`; |
355 | DROP TABLE IF EXISTS `g_rtype`; |
244 | CREATE TABLE IF NOT EXISTS `g_rtype` ( |
356 | CREATE TABLE IF NOT EXISTS `g_rtype` ( |
245 | `rtype_id` INT(2) NOT NULL AUTO_INCREMENT, |
357 | `rtype_id` INT(2) NOT NULL AUTO_INCREMENT, |
246 | `rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
358 | `rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
247 | PRIMARY KEY (`rtype_id`) |
359 | PRIMARY KEY (`rtype_id`) |
248 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ; |
360 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ; |
249 | 361 | ||
250 | --
|
362 | --
|
251 | -- Дамп данных таблицы `g_rtype`
|
363 | -- Дамп данных таблицы `g_rtype`
|
252 | --
|
364 | --
|
253 | 365 | ||
254 | INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES |
366 | INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES |
255 | (1, 'Базовый репозиторий'), |
367 | (1, 'Базовый репозиторий'), |
256 | (2, 'Обновления'), |
368 | (2, 'Обновления'), |
257 | (3, 'Репозитории 3-х лиц'), |
369 | (3, 'Репозитории 3-х лиц'), |
258 | (4, 'Репозитории партнеров'); |
370 | (4, 'Репозитории партнеров'); |
259 | 371 | ||
260 | -- --------------------------------------------------------
|
372 | -- --------------------------------------------------------
|
261 | 373 | ||
262 | --
|
374 | --
|
263 | -- Структура таблицы `g_sect2rep`
|
375 | -- Структура таблицы `g_sect2rep`
|
264 | --
|
376 | --
|
265 | 377 | ||
266 | DROP TABLE IF EXISTS `g_sect2rep`; |
378 | DROP TABLE IF EXISTS `g_sect2rep`; |
267 | CREATE TABLE IF NOT EXISTS `g_sect2rep` ( |
379 | CREATE TABLE IF NOT EXISTS `g_sect2rep` ( |
268 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
380 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
269 | `sect_id` INT(2) NOT NULL, |
381 | `sect_id` INT(2) NOT NULL, |
270 | `rep_id` INT(5) NOT NULL, |
382 | `rep_id` INT(5) NOT NULL, |
271 | PRIMARY KEY (`id`), |
383 | PRIMARY KEY (`id`), |
272 | KEY `sect_id` (`sect_id`,`rep_id`) |
384 | KEY `sect_id` (`sect_id`,`rep_id`) |
273 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
385 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ; |
274 | 386 | ||
275 | --
|
387 | --
|
276 | -- Дамп данных таблицы `g_sect2rep`
|
388 | -- Дамп данных таблицы `g_sect2rep`
|
277 | --
|
389 | --
|
278 | 390 | ||
279 | INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES |
391 | INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES |
- | 392 | (119, 3, 9), |
|
- | 393 | (118, 2, 9), |
|
- | 394 | (117, 1, 9), |
|
- | 395 | (116, 3, 8), |
|
- | 396 | (115, 2, 8), |
|
- | 397 | (114, 1, 8), |
|
- | 398 | (46, 10, 7), |
|
- | 399 | (45, 9, 7), |
|
- | 400 | (44, 8, 7), |
|
- | 401 | (43, 8, 6), |
|
- | 402 | (42, 9, 6), |
|
- | 403 | (41, 10, 6), |
|
- | 404 | (85, 3, 5), |
|
- | 405 | (84, 2, 5), |
|
- | 406 | (83, 1, 5), |
|
- | 407 | (16, 1, 2), |
|
- | 408 | (17, 2, 2), |
|
- | 409 | (18, 3, 2), |
|
280 | (1, 1, 1), |
410 | (19, 1, 3), |
281 | (2, 2, 1), |
411 | (20, 2, 3), |
- | 412 | (21, 3, 3), |
|
- | 413 | (22, 3, 4), |
|
- | 414 | (131, 3, 10), |
|
- | 415 | (130, 2, 10), |
|
- | 416 | (129, 1, 10), |
|
- | 417 | (122, 3, 11), |
|
- | 418 | (121, 2, 11), |
|
- | 419 | (120, 1, 11), |
|
- | 420 | (65, 1, 12), |
|
- | 421 | (66, 4, 12), |
|
- | 422 | (67, 5, 12), |
|
- | 423 | (68, 6, 12), |
|
- | 424 | (69, 1, 13), |
|
- | 425 | (70, 2, 13), |
|
- | 426 | (71, 3, 13), |
|
- | 427 | (125, 3, 14), |
|
- | 428 | (124, 2, 14), |
|
- | 429 | (123, 1, 14), |
|
- | 430 | (75, 1, 15), |
|
- | 431 | (128, 3, 16), |
|
- | 432 | (127, 2, 16), |
|
- | 433 | (126, 1, 16), |
|
- | 434 | (79, 1, 17), |
|
- | 435 | (132, 3, 18), |
|
282 | (3, 3, 1); |
436 | (133, 3, 19), |
- | 437 | (82, 1, 20), |
|
- | 438 | (86, 3, 21), |
|
- | 439 | (93, 1, 22), |
|
- | 440 | (94, 4, 22), |
|
- | 441 | (95, 5, 22), |
|
- | 442 | (96, 6, 22), |
|
- | 443 | (112, 6, 23), |
|
- | 444 | (111, 5, 23), |
|
- | 445 | (110, 4, 23), |
|
- | 446 | (109, 1, 23), |
|
- | 447 | (101, 1, 24), |
|
- | 448 | (102, 4, 24), |
|
- | 449 | (103, 5, 24), |
|
- | 450 | (104, 6, 24), |
|
- | 451 | (105, 1, 25), |
|
- | 452 | (106, 4, 25), |
|
- | 453 | (107, 5, 25), |
|
- | 454 | (108, 6, 25), |
|
- | 455 | (113, 1, 26), |
|
- | 456 | (134, 11, 27), |
|
- | 457 | (136, 13, 28); |
|
283 | 458 | ||
284 | -- --------------------------------------------------------
|
459 | -- --------------------------------------------------------
|
285 | 460 | ||
286 | --
|
461 | --
|
287 | -- Структура таблицы `g_section`
|
462 | -- Структура таблицы `g_section`
|
288 | --
|
463 | --
|
289 | 464 | ||
290 | DROP TABLE IF EXISTS `g_section`; |
465 | DROP TABLE IF EXISTS `g_section`; |
291 | CREATE TABLE IF NOT EXISTS `g_section` ( |
466 | CREATE TABLE IF NOT EXISTS `g_section` ( |
292 | `sect_id` INT(2) NOT NULL AUTO_INCREMENT, |
467 | `sect_id` INT(2) NOT NULL AUTO_INCREMENT, |
293 | `secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
468 | `secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
294 | `sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL, |
469 | `sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL, |
295 | PRIMARY KEY (`sect_id`), |
470 | PRIMARY KEY (`sect_id`), |
296 | KEY `secname` (`secname`) |
471 | KEY `secname` (`secname`) |
297 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=15 ; |
472 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=15 ; |
298 | 473 | ||
299 | --
|
474 | --
|
300 | -- Дамп данных таблицы `g_section`
|
475 | -- Дамп данных таблицы `g_section`
|
301 | --
|
476 | --
|
302 | 477 | ||
303 | INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES |
478 | INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES |
304 | (1, 'main', 'раздел со свободными пакетами'), |
479 | (1, 'main', 'раздел со свободными пакетами'), |
305 | (2, 'contrib', 'раздел со свободными пакетами, зависимыми от несвободных'), |
480 | (2, 'contrib', 'раздел со свободными пакетами, зависимыми от несвободных'), |
306 | (3, 'non-free', 'раздел с несвободными пакетами'), |
481 | (3, 'non-free', 'раздел с несвободными пакетами'), |
307 | (4, 'restricted', ''), |
482 | (4, 'restricted', 'поддерживаемое ПО доступное под не полностью свободными лицензиями'), |
308 | (5, 'universe', ''), |
483 | (5, 'universe', 'поддерживемое сообществом ПО'), |
309 | (6, 'multiverse', ''), |
484 | (6, 'multiverse', 'несвободное ПО'), |
310 | (7, 'partner', ''), |
485 | (7, 'partner', ''), |
311 | (8, 'unofficial', 'раздел с неофициальными пакетами'), |
486 | (8, 'unofficial', 'раздел с неофициальными пакетами'), |
312 | (9, 'astro', 'раздел с пакетами астрономических программ'), |
487 | (9, 'astro', 'раздел с пакетами астрономических программ'), |
313 | (10, 'altspa', 'раздел пакетов для АлтГПА'), |
488 | (10, 'altspa', 'раздел пакетов для АлтГПА'), |
314 | (11, 'classic', ''), |
489 | (11, 'classic', ''), |
315 | (12, 'daedalus', ''), |
490 | (12, 'daedalus', ''), |
316 | (13, 'updates', ''), |
491 | (13, 'updates', ''), |
317 | (14, 'backports', ''); |
492 | (14, 'backports', ''); |
318 | 493 | ||
319 | -- --------------------------------------------------------
|
494 | -- --------------------------------------------------------
|
320 | 495 | ||
321 | --
|
496 | --
|
322 | -- Структура таблицы `g_settings`
|
497 | -- Структура таблицы `g_settings`
|
323 | --
|
498 | --
|
324 | 499 | ||
325 | DROP TABLE IF EXISTS `g_settings`; |
500 | DROP TABLE IF EXISTS `g_settings`; |
326 | CREATE TABLE IF NOT EXISTS `g_settings` ( |
501 | CREATE TABLE IF NOT EXISTS `g_settings` ( |
327 | `opt_id` INT(2) NOT NULL AUTO_INCREMENT, |
502 | `opt_id` INT(2) NOT NULL AUTO_INCREMENT, |
328 | `opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
503 | `opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
329 | `optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
504 | `optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
330 | PRIMARY KEY (`opt_id`), |
505 | PRIMARY KEY (`opt_id`), |
331 | KEY `opt` (`opt`) |
506 | KEY `opt` (`opt`) |
332 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=6 ; |
507 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=6 ; |
333 | 508 | ||
334 | --
|
509 | --
|
335 | -- Дамп данных таблицы `g_settings`
|
510 | -- Дамп данных таблицы `g_settings`
|
336 | --
|
511 | --
|
337 | 512 | ||
338 | INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES |
513 | INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES |
339 | (1, 'codename', 'ant-ng'), |
514 | (1, 'codename', 'ant-ng'), |
340 | (2, 'version', '0.1'), |
515 | (2, 'version', '0.1'), |
341 | (5, 'description', 'Генератор sources.list для apt-дистрибутивов Linux'), |
516 | (5, 'description', 'Генератор sources.list для apt-дистрибутивов Linux'), |
342 | (4, 'passwd', 'b5c5bd7428b6509b5235953ad7aaae12'); |
517 | (4, 'passwd', 'b5c5bd7428b6509b5235953ad7aaae12'); |
343 | 518 | ||
344 | -- --------------------------------------------------------
|
519 | -- --------------------------------------------------------
|
345 | 520 | ||
346 | --
|
521 | --
|
347 | -- Структура таблицы `g_signs`
|
522 | -- Структура таблицы `g_signs`
|
348 | --
|
523 | --
|
349 | 524 | ||
350 | DROP TABLE IF EXISTS `g_signs`; |
525 | DROP TABLE IF EXISTS `g_signs`; |
351 | CREATE TABLE IF NOT EXISTS `g_signs` ( |
526 | CREATE TABLE IF NOT EXISTS `g_signs` ( |
352 | `sign_id` INT(3) NOT NULL AUTO_INCREMENT, |
527 | `sign_id` INT(3) NOT NULL AUTO_INCREMENT, |
353 | `sname` VARCHAR(25) NOT NULL, |
528 | `sname` VARCHAR(25) NOT NULL, |
354 | `sinfo` VARCHAR(150) NOT NULL, |
529 | `sinfo` VARCHAR(150) NOT NULL, |
355 | PRIMARY KEY (`sign_id`) |
530 | PRIMARY KEY (`sign_id`) |
356 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ; |
531 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ; |
357 | 532 | ||
358 | --
|
533 | --
|
359 | -- Дамп данных таблицы `g_signs`
|
534 | -- Дамп данных таблицы `g_signs`
|
360 | --
|
535 | --
|
361 | 536 | ||
362 | INSERT INTO `g_signs` (`sign_id`, `sname`, `sinfo`) VALUES |
537 | INSERT INTO `g_signs` (`sign_id`, `sname`, `sinfo`) VALUES |
363 | (1, 'alt', ''), |
538 | (1, 'alt', ''), |
364 | (2, 'p5', 'Пятая платформа'), |
539 | (2, 'p5', 'Пятая платформа'), |
365 | (3, 'updates', 'Обновления'), |
540 | (3, 'updates', 'Обновления'), |
366 | (4, 'backports', 'Бэкпортированые пакеты'), |
541 | (4, 'backports', 'Бэкпортированые пакеты'), |
367 | (5, 'school', 'Школьные'); |
542 | (5, 'school', 'Школьные'); |
368 | 543 | ||
369 | -- --------------------------------------------------------
|
544 | -- --------------------------------------------------------
|
370 | 545 | ||
371 | --
|
546 | --
|
372 | -- Структура таблицы `g_version`
|
547 | -- Структура таблицы `g_version`
|
373 | --
|
548 | --
|
374 | 549 | ||
375 | DROP TABLE IF EXISTS `g_version`; |
550 | DROP TABLE IF EXISTS `g_version`; |
376 | CREATE TABLE IF NOT EXISTS `g_version` ( |
551 | CREATE TABLE IF NOT EXISTS `g_version` ( |
377 | `version_id` INT(5) NOT NULL AUTO_INCREMENT, |
552 | `version_id` INT(5) NOT NULL AUTO_INCREMENT, |
378 | `dist_id` INT(5) NOT NULL, |
553 | `dist_id` INT(5) NOT NULL, |
379 | `vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
554 | `vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
380 | `version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
555 | `version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
381 | `vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
556 | `vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
382 | PRIMARY KEY (`version_id`), |
557 | PRIMARY KEY (`version_id`), |
383 | KEY `dist_id` (`dist_id`) |
558 | KEY `dist_id` (`dist_id`) |
384 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=13 ; |
559 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ; |
385 | 560 | ||
386 | --
|
561 | --
|
387 | -- Дамп данных таблицы `g_version`
|
562 | -- Дамп данных таблицы `g_version`
|
388 | --
|
563 | --
|
389 | 564 | ||
390 | INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES |
565 | INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES |
391 | (1, 1, 'Sarge', '3.1', 'sarge'), |
566 | (1, 1, 'Sarge', '3.1', 'sarge'), |
392 | (2, 1, 'Etch', '4.0', 'etch'), |
567 | (2, 1, 'Etch', '4.0', 'etch'), |
393 | (3, 1, 'Lenny', '5.0', 'lenny'), |
568 | (3, 1, 'Lenny', '5.0', 'lenny'), |
394 | (4, 1, 'Squeeze', '6.0', 'squeeze'), |
569 | (4, 1, 'Squeeze', '6.0', 'squeeze'), |
395 | (5, 2, 'Hardy Heron', '8.04', 'hardy'), |
570 | (5, 2, 'Hardy Heron', '8.04', 'hardy'), |
396 | (6, 2, 'Intrepid Ibex', '8.10', 'intrepid'), |
571 | (6, 2, 'Intrepid Ibex', '8.10', 'intrepid'), |
397 | (7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'), |
572 | (7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'), |
398 | (8, 2, 'Karmic Koala', '9.10', 'karmic'), |
573 | (8, 2, 'Karmic Koala', '9.10', 'karmic'), |
399 | (12, 5, 'Школьный Мастер', '5.0', 'master'), |
574 | (12, 5, 'Школьный Мастер', '5.0', 'master'), |
400 | (11, 5, 'Ark', '5.0', 'ark'); |
575 | (11, 5, 'Ark', '5.0', 'ark'), |
- | 576 | (13, 1, 'Sid', '', 'sid'), |
|
- | 577 | (14, 6, 'Intrepid Ibex', '8.10', 'intrepid'), |
|
- | 578 | (15, 6, 'Jaunty Jackalope', '9.04', 'jaunty'), |
|
- | 579 | (16, 6, 'Karmic Koala', '9.10', 'karmic'); |
|
401 | 580 |