Редакция 555 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 555 | Редакция 673 | ||
---|---|---|---|
Строка 1... | Строка 1... | ||
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 | ||
Строка 52... | Строка 52... | ||
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`
|
Строка 74... | Строка 129... | ||
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`
|
Строка 140... | Строка 196... | ||
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`
|
Строка 159... | Строка 238... | ||
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`
|
Строка 185... | Строка 265... | ||
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`
|
Строка 216... | Строка 324... | ||
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 | ||
Строка 230... | Строка 338... | ||
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`
|
Строка 268... | Строка 380... | ||
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`
|
Строка 302... | Строка 477... | ||
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', ''), |
Строка 379... | Строка 554... | ||
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 | ||
Строка 395... | Строка 570... | ||
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'); |