Редакция 697 | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
306 | alex-w | 1 | -- phpMyAdmin SQL Dump |
2 | -- version 3.0.0-alpha |
||
3 | -- http://www.phpmyadmin.net |
||
4 | -- |
||
5 | -- Хост: localhost |
||
692 | alex-w | 6 | -- Время создания: Ноя 30 2009 г., 17:25 |
306 | alex-w | 7 | -- Версия сервера: 5.1.37 |
8 | -- Версия PHP: 5.2.11-1 |
||
9 | |||
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
||
11 | |||
12 | |||
13 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
||
14 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
||
15 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
||
16 | /*!40101 SET NAMES utf8 */; |
||
17 | |||
18 | -- |
||
19 | -- База данных: `generator` |
||
20 | -- |
||
21 | |||
22 | -- -------------------------------------------------------- |
||
23 | |||
24 | -- |
||
25 | -- Структура таблицы `g_arch` |
||
26 | -- |
||
27 | |||
28 | DROP TABLE IF EXISTS `g_arch`; |
||
29 | CREATE TABLE IF NOT EXISTS `g_arch` ( |
||
30 | `arch_id` int(2) NOT NULL AUTO_INCREMENT, |
||
31 | `arch` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
||
32 | PRIMARY KEY (`arch_id`), |
||
33 | KEY `arch` (`arch`) |
||
34 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ; |
||
35 | |||
36 | -- |
||
37 | -- Дамп данных таблицы `g_arch` |
||
38 | -- |
||
39 | |||
40 | INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES |
||
41 | (1, 'i386'), |
||
42 | (2, 'amd64'); |
||
43 | |||
44 | -- -------------------------------------------------------- |
||
45 | |||
46 | -- |
||
47 | -- Структура таблицы `g_arch2rep` |
||
48 | -- |
||
49 | |||
50 | DROP TABLE IF EXISTS `g_arch2rep`; |
||
51 | CREATE TABLE IF NOT EXISTS `g_arch2rep` ( |
||
52 | `id` int(5) NOT NULL AUTO_INCREMENT, |
||
53 | `arch_id` int(2) NOT NULL, |
||
54 | `rep_id` int(5) NOT NULL, |
||
55 | PRIMARY KEY (`id`), |
||
56 | KEY `arch_id` (`arch_id`,`rep_id`) |
||
673 | alex-w | 57 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=103 ; |
306 | alex-w | 58 | |
59 | -- |
||
60 | -- Дамп данных таблицы `g_arch2rep` |
||
61 | -- |
||
62 | |||
673 | alex-w | 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); |
||
306 | alex-w | 118 | |
119 | -- -------------------------------------------------------- |
||
120 | |||
121 | -- |
||
122 | -- Структура таблицы `g_distribution` |
||
123 | -- |
||
124 | |||
125 | DROP TABLE IF EXISTS `g_distribution`; |
||
126 | CREATE TABLE IF NOT EXISTS `g_distribution` ( |
||
127 | `dist_id` int(5) NOT NULL AUTO_INCREMENT, |
||
128 | `distname` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
||
129 | `distua` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
||
130 | `disttype` int(1) NOT NULL, |
||
131 | `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, |
||
132 | PRIMARY KEY (`dist_id`), |
||
133 | KEY `disttype` (`disttype`,`distlogo`) |
||
673 | alex-w | 134 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=7 ; |
306 | alex-w | 135 | |
136 | -- |
||
137 | -- Дамп данных таблицы `g_distribution` |
||
138 | -- |
||
139 | |||
140 | INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES |
||
555 | alex-w | 141 | (1, 'Debian GNU/Linux', 'debian', 1, '1'), |
142 | (2, 'Ubuntu Linux', 'ubuntu', 1, '0'), |
||
673 | alex-w | 143 | (5, 'ALTLinux', 'altlinux', 2, '0'), |
144 | (6, 'InfraLinux', 'infralinux', 1, '0'); |
||
306 | alex-w | 145 | |
146 | -- -------------------------------------------------------- |
||
147 | |||
148 | -- |
||
149 | -- Структура таблицы `g_dtype` |
||
150 | -- |
||
151 | |||
152 | DROP TABLE IF EXISTS `g_dtype`; |
||
153 | CREATE TABLE IF NOT EXISTS `g_dtype` ( |
||
154 | `type_id` int(1) NOT NULL AUTO_INCREMENT, |
||
155 | `type` varchar(3) COLLATE utf8_unicode_ci NOT NULL, |
||
156 | PRIMARY KEY (`type_id`), |
||
157 | KEY `type` (`type`) |
||
158 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
||
159 | |||
160 | -- |
||
161 | -- Дамп данных таблицы `g_dtype` |
||
162 | -- |
||
163 | |||
164 | INSERT INTO `g_dtype` (`type_id`, `type`) VALUES |
||
165 | (1, 'deb'), |
||
166 | (2, 'rpm'); |
||
167 | |||
168 | -- -------------------------------------------------------- |
||
169 | |||
170 | -- |
||
171 | -- Структура таблицы `g_protos` |
||
172 | -- |
||
173 | |||
174 | DROP TABLE IF EXISTS `g_protos`; |
||
175 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
||
176 | `proto_id` int(1) NOT NULL AUTO_INCREMENT, |
||
177 | `proto` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
||
178 | PRIMARY KEY (`proto_id`), |
||
179 | KEY `proto` (`proto`) |
||
180 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ; |
||
181 | |||
182 | -- |
||
183 | -- Дамп данных таблицы `g_protos` |
||
184 | -- |
||
185 | |||
186 | INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES |
||
187 | (1, 'http://'); |
||
188 | |||
189 | -- -------------------------------------------------------- |
||
190 | |||
191 | -- |
||
192 | -- Структура таблицы `g_repfolder` |
||
193 | -- |
||
194 | |||
195 | DROP TABLE IF EXISTS `g_repfolder`; |
||
196 | CREATE TABLE IF NOT EXISTS `g_repfolder` ( |
||
197 | `rfolder_id` int(5) NOT NULL AUTO_INCREMENT, |
||
198 | `rfolder` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
||
199 | PRIMARY KEY (`rfolder_id`), |
||
200 | KEY `rhost_id` (`rfolder`) |
||
673 | alex-w | 201 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=23 ; |
306 | alex-w | 202 | |
203 | -- |
||
204 | -- Дамп данных таблицы `g_repfolder` |
||
205 | -- |
||
206 | |||
673 | alex-w | 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'); |
||
306 | alex-w | 230 | |
231 | -- -------------------------------------------------------- |
||
232 | |||
233 | -- |
||
234 | -- Структура таблицы `g_rephost` |
||
235 | -- |
||
236 | |||
237 | DROP TABLE IF EXISTS `g_rephost`; |
||
238 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
||
239 | `rhost_id` int(3) NOT NULL AUTO_INCREMENT, |
||
240 | `rhost` varchar(150) COLLATE utf8_unicode_ci NOT NULL, |
||
241 | PRIMARY KEY (`rhost_id`), |
||
242 | KEY `proto_id` (`rhost`) |
||
673 | alex-w | 243 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=8 ; |
306 | alex-w | 244 | |
245 | -- |
||
246 | -- Дамп данных таблицы `g_rephost` |
||
247 | -- |
||
248 | |||
249 | INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
||
250 | (1, 'apt.nix-files.org.ru'), |
||
328 | alex-w | 251 | (2, 'hyperion.uni-altai.ru'), |
673 | alex-w | 252 | (3, 'apt.nix-files.uni-altai.ru'), |
253 | (7, 'alt.nix-files.org.ru'); |
||
306 | alex-w | 254 | |
255 | -- -------------------------------------------------------- |
||
256 | |||
257 | -- |
||
258 | -- Структура таблицы `g_repository` |
||
259 | -- |
||
260 | |||
261 | DROP TABLE IF EXISTS `g_repository`; |
||
262 | CREATE TABLE IF NOT EXISTS `g_repository` ( |
||
263 | `rep_id` int(5) NOT NULL AUTO_INCREMENT, |
||
264 | `proto_id` int(1) NOT NULL, |
||
265 | `rhost_id` int(3) NOT NULL, |
||
266 | `rfolder_id` int(5) NOT NULL, |
||
267 | `version` int(5) NOT NULL, |
||
268 | `rtype_id` int(2) NOT NULL, |
||
269 | `scheme_id` int(2) NOT NULL, |
||
673 | alex-w | 270 | `sign_id` int(3) NOT NULL, |
328 | alex-w | 271 | `repname` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
306 | alex-w | 272 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
673 | alex-w | 273 | `repkey` varchar(200) COLLATE utf8_unicode_ci NOT NULL, |
306 | alex-w | 274 | PRIMARY KEY (`rep_id`), |
275 | KEY `proto_id` (`proto_id`), |
||
276 | KEY `rhost_id` (`rhost_id`), |
||
277 | KEY `rfolder_id` (`rfolder_id`), |
||
278 | KEY `version` (`version`), |
||
279 | KEY `rtype_id` (`rtype_id`), |
||
673 | alex-w | 280 | KEY `scheme_id` (`scheme_id`), |
281 | KEY `sign_id` (`sign_id`) |
||
282 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ; |
||
306 | alex-w | 283 | |
284 | -- |
||
285 | -- Дамп данных таблицы `g_repository` |
||
286 | -- |
||
287 | |||
673 | alex-w | 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', ''), |
||
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', 'Обновления безопасности', ''); |
||
306 | alex-w | 316 | |
317 | -- -------------------------------------------------------- |
||
318 | |||
319 | -- |
||
320 | -- Структура таблицы `g_repscheme` |
||
321 | -- |
||
322 | |||
323 | DROP TABLE IF EXISTS `g_repscheme`; |
||
324 | CREATE TABLE IF NOT EXISTS `g_repscheme` ( |
||
325 | `scheme_id` int(2) NOT NULL AUTO_INCREMENT, |
||
326 | `scheme` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
||
327 | PRIMARY KEY (`scheme_id`), |
||
328 | KEY `scheme` (`scheme`) |
||
673 | alex-w | 329 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ; |
306 | alex-w | 330 | |
331 | -- |
||
332 | -- Дамп данных таблицы `g_repscheme` |
||
333 | -- |
||
334 | |||
335 | INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES |
||
336 | (1, '{DIST}'), |
||
337 | (2, '{DIST}-proposed-updates'), |
||
338 | (3, '{DIST}/updates'), |
||
339 | (4, '{DIST}/volatile'), |
||
340 | (5, '{DIST}/volatile-sloppy'), |
||
341 | (6, '{DIST}-backports'), |
||
342 | (7, '{DIST}-updates'), |
||
673 | alex-w | 343 | (8, '{DIST}-security'), |
344 | (9, 'noarch'), |
||
345 | (10, 'x86_64'), |
||
346 | (11, 'i586'), |
||
347 | (12, 'x86_32'); |
||
306 | alex-w | 348 | |
349 | -- -------------------------------------------------------- |
||
350 | |||
351 | -- |
||
352 | -- Структура таблицы `g_rtype` |
||
353 | -- |
||
354 | |||
355 | DROP TABLE IF EXISTS `g_rtype`; |
||
356 | CREATE TABLE IF NOT EXISTS `g_rtype` ( |
||
357 | `rtype_id` int(2) NOT NULL AUTO_INCREMENT, |
||
358 | `rtype` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
||
359 | PRIMARY KEY (`rtype_id`) |
||
360 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ; |
||
361 | |||
362 | -- |
||
363 | -- Дамп данных таблицы `g_rtype` |
||
364 | -- |
||
365 | |||
366 | INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES |
||
367 | (1, 'Базовый репозиторий'), |
||
368 | (2, 'Обновления'), |
||
369 | (3, 'Репозитории 3-х лиц'), |
||
370 | (4, 'Репозитории партнеров'); |
||
371 | |||
372 | -- -------------------------------------------------------- |
||
373 | |||
374 | -- |
||
375 | -- Структура таблицы `g_sect2rep` |
||
376 | -- |
||
377 | |||
378 | DROP TABLE IF EXISTS `g_sect2rep`; |
||
379 | CREATE TABLE IF NOT EXISTS `g_sect2rep` ( |
||
380 | `id` int(5) NOT NULL AUTO_INCREMENT, |
||
381 | `sect_id` int(2) NOT NULL, |
||
382 | `rep_id` int(5) NOT NULL, |
||
383 | PRIMARY KEY (`id`), |
||
384 | KEY `sect_id` (`sect_id`,`rep_id`) |
||
673 | alex-w | 385 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ; |
306 | alex-w | 386 | |
387 | -- |
||
388 | -- Дамп данных таблицы `g_sect2rep` |
||
389 | -- |
||
390 | |||
328 | alex-w | 391 | INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES |
673 | alex-w | 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), |
||
410 | (19, 1, 3), |
||
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), |
||
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); |
||
306 | alex-w | 458 | |
459 | -- -------------------------------------------------------- |
||
460 | |||
461 | -- |
||
462 | -- Структура таблицы `g_section` |
||
463 | -- |
||
464 | |||
465 | DROP TABLE IF EXISTS `g_section`; |
||
466 | CREATE TABLE IF NOT EXISTS `g_section` ( |
||
467 | `sect_id` int(2) NOT NULL AUTO_INCREMENT, |
||
468 | `secname` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
||
469 | `sectinfo` varchar(250) COLLATE utf8_unicode_ci NOT NULL, |
||
470 | PRIMARY KEY (`sect_id`), |
||
471 | KEY `secname` (`secname`) |
||
555 | alex-w | 472 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=15 ; |
306 | alex-w | 473 | |
474 | -- |
||
475 | -- Дамп данных таблицы `g_section` |
||
476 | -- |
||
477 | |||
478 | INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES |
||
555 | alex-w | 479 | (1, 'main', 'раздел со свободными пакетами'), |
480 | (2, 'contrib', 'раздел со свободными пакетами, зависимыми от несвободных'), |
||
481 | (3, 'non-free', 'раздел с несвободными пакетами'), |
||
673 | alex-w | 482 | (4, 'restricted', 'поддерживаемое ПО доступное под не полностью свободными лицензиями'), |
483 | (5, 'universe', 'поддерживемое сообществом ПО'), |
||
484 | (6, 'multiverse', 'несвободное ПО'), |
||
306 | alex-w | 485 | (7, 'partner', ''), |
555 | alex-w | 486 | (8, 'unofficial', 'раздел с неофициальными пакетами'), |
487 | (9, 'astro', 'раздел с пакетами астрономических программ'), |
||
488 | (10, 'altspa', 'раздел пакетов для АлтГПА'), |
||
489 | (11, 'classic', ''), |
||
490 | (12, 'daedalus', ''), |
||
491 | (13, 'updates', ''), |
||
492 | (14, 'backports', ''); |
||
306 | alex-w | 493 | |
494 | -- -------------------------------------------------------- |
||
495 | |||
496 | -- |
||
497 | -- Структура таблицы `g_settings` |
||
498 | -- |
||
499 | |||
500 | DROP TABLE IF EXISTS `g_settings`; |
||
501 | CREATE TABLE IF NOT EXISTS `g_settings` ( |
||
502 | `opt_id` int(2) NOT NULL AUTO_INCREMENT, |
||
503 | `opt` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
||
504 | `optvalue` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
||
505 | PRIMARY KEY (`opt_id`), |
||
506 | KEY `opt` (`opt`) |
||
555 | alex-w | 507 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=6 ; |
306 | alex-w | 508 | |
509 | -- |
||
510 | -- Дамп данных таблицы `g_settings` |
||
511 | -- |
||
512 | |||
513 | INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES |
||
697 | alex-w | 514 | (1, 'codename', 'ant-ng'), |
692 | alex-w | 515 | (2, 'version', '0.9.1'), |
555 | alex-w | 516 | (5, 'description', 'Генератор sources.list для apt-дистрибутивов Linux'), |
517 | (4, 'passwd', 'b5c5bd7428b6509b5235953ad7aaae12'); |
||
306 | alex-w | 518 | |
519 | -- -------------------------------------------------------- |
||
520 | |||
521 | -- |
||
555 | alex-w | 522 | -- Структура таблицы `g_signs` |
523 | -- |
||
524 | |||
525 | DROP TABLE IF EXISTS `g_signs`; |
||
526 | CREATE TABLE IF NOT EXISTS `g_signs` ( |
||
527 | `sign_id` int(3) NOT NULL AUTO_INCREMENT, |
||
528 | `sname` varchar(25) NOT NULL, |
||
529 | `sinfo` varchar(150) NOT NULL, |
||
530 | PRIMARY KEY (`sign_id`) |
||
531 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ; |
||
532 | |||
533 | -- |
||
534 | -- Дамп данных таблицы `g_signs` |
||
535 | -- |
||
536 | |||
537 | INSERT INTO `g_signs` (`sign_id`, `sname`, `sinfo`) VALUES |
||
538 | (1, 'alt', ''), |
||
539 | (2, 'p5', 'Пятая платформа'), |
||
540 | (3, 'updates', 'Обновления'), |
||
541 | (4, 'backports', 'Бэкпортированые пакеты'), |
||
542 | (5, 'school', 'Школьные'); |
||
543 | |||
544 | -- -------------------------------------------------------- |
||
545 | |||
546 | -- |
||
306 | alex-w | 547 | -- Структура таблицы `g_version` |
548 | -- |
||
549 | |||
550 | DROP TABLE IF EXISTS `g_version`; |
||
551 | CREATE TABLE IF NOT EXISTS `g_version` ( |
||
552 | `version_id` int(5) NOT NULL AUTO_INCREMENT, |
||
553 | `dist_id` int(5) NOT NULL, |
||
554 | `vname` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
||
555 | `version` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
||
556 | `vcodename` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
||
557 | PRIMARY KEY (`version_id`), |
||
558 | KEY `dist_id` (`dist_id`) |
||
673 | alex-w | 559 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ; |
306 | alex-w | 560 | |
561 | -- |
||
562 | -- Дамп данных таблицы `g_version` |
||
563 | -- |
||
564 | |||
565 | INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES |
||
566 | (1, 1, 'Sarge', '3.1', 'sarge'), |
||
567 | (2, 1, 'Etch', '4.0', 'etch'), |
||
568 | (3, 1, 'Lenny', '5.0', 'lenny'), |
||
569 | (4, 1, 'Squeeze', '6.0', 'squeeze'), |
||
570 | (5, 2, 'Hardy Heron', '8.04', 'hardy'), |
||
571 | (6, 2, 'Intrepid Ibex', '8.10', 'intrepid'), |
||
572 | (7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'), |
||
555 | alex-w | 573 | (8, 2, 'Karmic Koala', '9.10', 'karmic'), |
574 | (12, 5, 'Школьный Мастер', '5.0', 'master'), |
||
673 | alex-w | 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'); |