Редакция 153 | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
74 | alex-w | 1 | -- phpMyAdmin SQL Dump |
2 | -- version 3.0.0-alpha |
||
3 | -- http://www.phpmyadmin.net |
||
4 | -- |
||
5 | -- Хост: localhost |
||
144 | alex-w | 6 | -- Время создания: Апр 01 2009 г., 14:43 |
74 | alex-w | 7 | -- Версия сервера: 5.0.51 |
8 | -- Версия PHP: 5.2.6-1+lenny2 |
||
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 | -- База данных: `ant` |
||
20 | -- |
||
21 | |||
22 | -- -------------------------------------------------------- |
||
23 | |||
24 | -- |
||
25 | -- Структура таблицы `arch` |
||
26 | -- |
||
27 | |||
28 | CREATE TABLE IF NOT EXISTS `arch` ( |
||
29 | `arch_id` INT(2) NOT NULL AUTO_INCREMENT, |
||
30 | `arch` VARCHAR(10) DEFAULT NULL, |
||
31 | PRIMARY KEY (`arch_id`) |
||
32 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; |
||
33 | |||
78 | alex-w | 34 | -- |
35 | -- Дамп данных таблицы `arch` |
||
36 | -- |
||
37 | |||
38 | INSERT INTO `arch` (`arch_id`, `arch`) VALUES |
||
39 | (1, 'i386'), |
||
40 | (2, 'amd64'); |
||
41 | |||
74 | alex-w | 42 | -- -------------------------------------------------------- |
43 | |||
44 | -- |
||
45 | -- Структура таблицы `arch2rep` |
||
46 | -- |
||
47 | |||
48 | CREATE TABLE IF NOT EXISTS `arch2rep` ( |
||
49 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
||
50 | `arch_id` INT(2) DEFAULT NULL, |
||
51 | `rep_id` INT(5) DEFAULT NULL, |
||
52 | PRIMARY KEY (`id`), |
||
53 | KEY `arch_id` (`arch_id`), |
||
54 | KEY `rep_id` (`rep_id`) |
||
78 | alex-w | 55 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
74 | alex-w | 56 | |
78 | alex-w | 57 | |
74 | alex-w | 58 | -- -------------------------------------------------------- |
59 | |||
60 | -- |
||
92 | alex-w | 61 | -- Структура таблицы `changelog` |
62 | -- |
||
63 | |||
64 | CREATE TABLE IF NOT EXISTS `changelog` ( |
||
65 | `log_id` INT(5) NOT NULL AUTO_INCREMENT, |
||
66 | `log_record` datetime NOT NULL, |
||
67 | `log_title` VARCHAR(35) NOT NULL, |
||
68 | `log_desc` text NOT NULL, |
||
69 | PRIMARY KEY (`log_id`) |
||
70 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
||
71 | |||
72 | |||
73 | -- -------------------------------------------------------- |
||
74 | |||
75 | -- |
||
74 | alex-w | 76 | -- Структура таблицы `distribution` |
77 | -- |
||
78 | |||
79 | CREATE TABLE IF NOT EXISTS `distribution` ( |
||
80 | `dist_id` INT(5) NOT NULL AUTO_INCREMENT, |
||
81 | `distname` VARCHAR(25) DEFAULT NULL, |
||
82 | `distua` VARCHAR(50) NOT NULL, |
||
83 | `disttype` INT(1) NOT NULL, |
||
86 | alex-w | 84 | `distlogo` enum('0','1') NOT NULL, |
74 | alex-w | 85 | PRIMARY KEY (`dist_id`), |
86 | alex-w | 86 | KEY `disttype` (`disttype`), |
87 | KEY `distlogo` (`distlogo`) |
||
78 | alex-w | 88 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
74 | alex-w | 89 | |
86 | alex-w | 90 | |
74 | alex-w | 91 | -- -------------------------------------------------------- |
92 | |||
93 | -- |
||
94 | -- Структура таблицы `dtype` |
||
95 | -- |
||
96 | |||
97 | CREATE TABLE IF NOT EXISTS `dtype` ( |
||
98 | `type_id` INT(1) NOT NULL AUTO_INCREMENT, |
||
99 | `type` CHAR(3) CHARACTER SET utf8 NOT NULL, |
||
100 | PRIMARY KEY (`type_id`) |
||
101 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; |
||
102 | |||
78 | alex-w | 103 | -- |
104 | -- Дамп данных таблицы `dtype` |
||
105 | -- |
||
106 | |||
107 | INSERT INTO `dtype` (`type_id`, `type`) VALUES |
||
108 | (1, 'deb'), |
||
109 | (2, 'rpm'); |
||
110 | |||
74 | alex-w | 111 | -- -------------------------------------------------------- |
112 | |||
113 | -- |
||
78 | alex-w | 114 | -- Структура таблицы `interfaces` |
115 | -- |
||
116 | |||
117 | CREATE TABLE IF NOT EXISTS `interfaces` ( |
||
118 | `if_id` INT(2) NOT NULL AUTO_INCREMENT, |
||
119 | `interface` VARCHAR(25) NOT NULL, |
||
120 | `interfaceinfo` VARCHAR(100) NOT NULL, |
||
121 | PRIMARY KEY (`if_id`) |
||
122 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
||
123 | |||
124 | -- |
||
125 | -- Дамп данных таблицы `interfaces` |
||
126 | -- |
||
127 | |||
128 | INSERT INTO `interfaces` (`if_id`, `interface`, `interfaceinfo`) VALUES |
||
129 | (1, 'classic', 'Классический'), |
||
130 | (2, 'modern', 'Современный'), |
||
131 | (3, 'telepathy', 'Телепатический'); |
||
132 | |||
133 | -- -------------------------------------------------------- |
||
134 | |||
135 | -- |
||
74 | alex-w | 136 | -- Структура таблицы `owner` |
137 | -- |
||
138 | |||
139 | CREATE TABLE IF NOT EXISTS `owner` ( |
||
140 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
||
141 | `login` CHAR(32) DEFAULT NULL, |
||
142 | `passwd` CHAR(32) DEFAULT NULL, |
||
143 | PRIMARY KEY (`id`) |
||
144 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
||
145 | |||
78 | alex-w | 146 | -- |
147 | -- Дамп данных таблицы `owner` |
||
148 | -- |
||
149 | |||
150 | INSERT INTO `owner` (`id`, `login`, `passwd`) VALUES |
||
151 | (1, 'admin', 'b167f5e9e5794a7e1eaca776fed7afb9'); |
||
152 | |||
74 | alex-w | 153 | -- -------------------------------------------------------- |
154 | |||
155 | -- |
||
156 | -- Структура таблицы `repository` |
||
157 | -- |
||
158 | |||
159 | CREATE TABLE IF NOT EXISTS `repository` ( |
||
160 | `rep_id` INT(5) NOT NULL AUTO_INCREMENT, |
||
161 | `repname` VARCHAR(20) DEFAULT NULL, |
||
162 | `repdescribe` text, |
||
163 | `scheme_id` INT(2) NOT NULL, |
||
164 | `rtype_id` INT(2) NOT NULL, |
||
90 | alex-w | 165 | `root_id` INT(2) NOT NULL, |
74 | alex-w | 166 | PRIMARY KEY (`rep_id`), |
167 | KEY `scheme` (`scheme_id`), |
||
90 | alex-w | 168 | KEY `rtype_id` (`rtype_id`), |
169 | KEY `root_id` (`root_id`) |
||
78 | alex-w | 170 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
74 | alex-w | 171 | |
86 | alex-w | 172 | |
74 | alex-w | 173 | -- -------------------------------------------------------- |
174 | |||
175 | -- |
||
90 | alex-w | 176 | -- Структура таблицы `root` |
177 | -- |
||
178 | |||
179 | CREATE TABLE IF NOT EXISTS `root` ( |
||
180 | `root_id` INT(2) NOT NULL AUTO_INCREMENT, |
||
181 | `root_folder` VARCHAR(50) NOT NULL, |
||
182 | PRIMARY KEY (`root_id`) |
||
183 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
||
184 | |||
185 | -- |
||
186 | -- Дамп данных таблицы `root` |
||
187 | -- |
||
188 | |||
189 | INSERT INTO `root` (`root_id`, `root_folder`) VALUES |
||
190 | (1, '/'); |
||
191 | |||
192 | -- -------------------------------------------------------- |
||
193 | |||
194 | -- |
||
74 | alex-w | 195 | -- Структура таблицы `rtype` |
196 | -- |
||
197 | |||
198 | CREATE TABLE IF NOT EXISTS `rtype` ( |
||
199 | `rtype_id` INT(2) NOT NULL AUTO_INCREMENT, |
||
200 | `rtype` VARCHAR(25) NOT NULL, |
||
201 | PRIMARY KEY (`rtype_id`) |
||
202 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
||
203 | |||
78 | alex-w | 204 | -- |
205 | -- Дамп данных таблицы `rtype` |
||
206 | -- |
||
207 | |||
208 | INSERT INTO `rtype` (`rtype_id`, `rtype`) VALUES |
||
209 | (1, 'Базовый'), |
||
210 | (2, 'Дополнительный'), |
||
211 | (3, 'Extra (добавочный)'); |
||
212 | |||
74 | alex-w | 213 | -- -------------------------------------------------------- |
214 | |||
215 | -- |
||
216 | -- Структура таблицы `scheme` |
||
217 | -- |
||
218 | |||
219 | CREATE TABLE IF NOT EXISTS `scheme` ( |
||
220 | `scheme_id` INT(2) NOT NULL AUTO_INCREMENT, |
||
221 | `scheme` VARCHAR(200) NOT NULL, |
||
222 | PRIMARY KEY (`scheme_id`) |
||
223 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; |
||
224 | |||
78 | alex-w | 225 | -- |
226 | -- Дамп данных таблицы `scheme` |
||
227 | -- |
||
228 | |||
229 | INSERT INTO `scheme` (`scheme_id`, `scheme`) VALUES |
||
90 | alex-w | 230 | (4, '{TYPE} {PROTO}{URL}{ROOT}{REP} {DIST} {SECT}'), |
231 | (5, '{TYPE} {PROTO}{URL}{ROOT}{REP} {DIST}-proposed-updates {SECT}'), |
||
232 | (6, '{TYPE} {PROTO}{URL}{ROOT}{REP} {DIST}/updates {SECT}'), |
||
233 | (7, '{TYPE} {PROTO}{URL}{ROOT}{REP} {DIST}/volatile {SECT}'), |
||
234 | (8, '{TYPE} {PROTO}{URL}{ROOT}{REP} {DIST}/volatile-sloppy {SECT}'), |
||
235 | (9, '{TYPE} {PROTO}{URL}{ROOT}{REP} {DIST}-backports {SECT}'), |
||
236 | (10, '{TYPE} {PROTO}{URL}{ROOT}{REP} {DIST}-updates {SECT}'), |
||
237 | (11, '{TYPE} {PROTO}{URL}{ROOT}{REP} {DIST}-security {SECT}'); |
||
78 | alex-w | 238 | |
74 | alex-w | 239 | -- -------------------------------------------------------- |
240 | |||
241 | -- |
||
242 | -- Структура таблицы `sect2dist` |
||
243 | -- |
||
244 | |||
245 | CREATE TABLE IF NOT EXISTS `sect2dist` ( |
||
246 | `id` INT(10) NOT NULL AUTO_INCREMENT, |
||
247 | `sect_id` INT(3) NOT NULL, |
||
248 | `dist_id` INT(5) NOT NULL, |
||
249 | PRIMARY KEY (`id`), |
||
250 | KEY `sect_id` (`sect_id`,`dist_id`) |
||
78 | alex-w | 251 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
74 | alex-w | 252 | |
86 | alex-w | 253 | |
74 | alex-w | 254 | -- -------------------------------------------------------- |
255 | |||
256 | -- |
||
257 | -- Структура таблицы `sect2rep` |
||
258 | -- |
||
259 | |||
260 | CREATE TABLE IF NOT EXISTS `sect2rep` ( |
||
261 | `id` INT(10) NOT NULL AUTO_INCREMENT, |
||
262 | `sect_id` INT(3) NOT NULL, |
||
263 | `rep_id` INT(5) NOT NULL, |
||
264 | PRIMARY KEY (`id`), |
||
265 | KEY `sect_id` (`sect_id`,`rep_id`) |
||
78 | alex-w | 266 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
74 | alex-w | 267 | |
86 | alex-w | 268 | |
74 | alex-w | 269 | -- -------------------------------------------------------- |
270 | |||
271 | -- |
||
272 | -- Структура таблицы `section` |
||
273 | -- |
||
274 | |||
275 | CREATE TABLE IF NOT EXISTS `section` ( |
||
276 | `sect_id` INT(3) NOT NULL AUTO_INCREMENT, |
||
277 | `sectname` VARCHAR(25) NOT NULL, |
||
278 | `sectinfo` text NOT NULL, |
||
279 | PRIMARY KEY (`sect_id`) |
||
92 | alex-w | 280 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; |
74 | alex-w | 281 | |
92 | alex-w | 282 | -- |
283 | -- Дамп данных таблицы `section` |
||
284 | -- |
||
78 | alex-w | 285 | |
92 | alex-w | 286 | INSERT INTO `section` (`sect_id`, `sectname`, `sectinfo`) VALUES |
287 | (1, 'main', 'Основной раздел, в котором собраны пакеты ПО только под свободными лицензиями.'), |
||
288 | (4, 'restricted', ''), |
||
289 | (5, 'universe', ''), |
||
290 | (2, 'contrib', 'Пакеты в этой части распространяются владельцем авторских прав на условиях свободной лицензии, но зависят от несвободного программного обеспечения.'), |
||
291 | (6, 'multiverse', ''), |
||
292 | (3, 'non-free', 'Лицензии пакетов в этой части содержат условия, ограничивающие использование или распространение ПО'), |
||
293 | (7, 'partner', ''); |
||
294 | |||
74 | alex-w | 295 | -- -------------------------------------------------------- |
296 | |||
297 | -- |
||
298 | -- Структура таблицы `settings` |
||
299 | -- |
||
300 | |||
301 | CREATE TABLE IF NOT EXISTS `settings` ( |
||
302 | `opt_id` INT(2) NOT NULL AUTO_INCREMENT, |
||
303 | `opt` VARCHAR(50) NOT NULL, |
||
304 | `optvalue` VARCHAR(200) NOT NULL, |
||
305 | PRIMARY KEY (`opt_id`) |
||
144 | alex-w | 306 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; |
74 | alex-w | 307 | |
78 | alex-w | 308 | -- |
309 | -- Дамп данных таблицы `settings` |
||
310 | -- |
||
311 | |||
312 | INSERT INTO `settings` (`opt_id`, `opt`, `optvalue`) VALUES |
||
313 | (1, 'proto', 'http://'), |
||
314 | (2, 'url', 'apt.nix-files.org.ru'), |
||
144 | alex-w | 315 | (3, 'version', '0.2.3'), |
316 | (4, 'interface', 'telepathy'), |
||
317 | (5, 'codename', 'Ant'); |
||
78 | alex-w | 318 | |
74 | alex-w | 319 | -- -------------------------------------------------------- |
320 | |||
321 | -- |
||
322 | -- Структура таблицы `ver2rep` |
||
323 | -- |
||
324 | |||
325 | CREATE TABLE IF NOT EXISTS `ver2rep` ( |
||
326 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
||
327 | `ver_id` INT(5) DEFAULT NULL, |
||
328 | `rep_id` INT(5) DEFAULT NULL, |
||
329 | PRIMARY KEY (`id`), |
||
330 | KEY `ver_id` (`ver_id`), |
||
331 | KEY `rep_id` (`rep_id`) |
||
78 | alex-w | 332 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
74 | alex-w | 333 | |
86 | alex-w | 334 | |
74 | alex-w | 335 | -- -------------------------------------------------------- |
336 | |||
337 | -- |
||
338 | -- Структура таблицы `version` |
||
339 | -- |
||
340 | |||
341 | CREATE TABLE IF NOT EXISTS `version` ( |
||
342 | `version_id` INT(5) NOT NULL AUTO_INCREMENT, |
||
343 | `dist_id` INT(5) DEFAULT NULL, |
||
344 | `vname` VARCHAR(25) DEFAULT NULL, |
||
345 | `version` VARCHAR(10) NOT NULL, |
||
346 | `vcodename` VARCHAR(10) DEFAULT NULL, |
||
347 | PRIMARY KEY (`version_id`), |
||
348 | KEY `dist_id` (`dist_id`) |
||
78 | alex-w | 349 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
350 | |||
146 | diffor | 351 | -- |
352 | -- Структура таблицы `origin` |
||
353 | -- |
||
354 | |||
355 | CREATE TABLE IF NOT EXISTS `origin` ( |
||
158 | diffor | 356 | `orig_id` INT(5) NOT NULL AUTO_INCREMENT, |
357 | `origin` VARCHAR(30) DEFAULT NULL, |
||
153 | diffor | 358 | `desk` text NOT NULL, |
359 | `basedir` VARCHAR(50) NOT NULL, |
||
360 | `homeurl` VARCHAR(50) NOT NULL, |
||
361 | `keyurl` VARCHAR(50) NOT NULL, |
||
158 | diffor | 362 | PRIMARY KEY (`orig_id`) |
363 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
||
146 | diffor | 364 | |
365 | -- -------------------------------------------------------- |
||
366 | |||
367 | -- |
||
158 | diffor | 368 | -- Структура таблицы `orig2dist` |
146 | diffor | 369 | -- |
370 | |||
158 | diffor | 371 | CREATE TABLE IF NOT EXISTS `orig2dist` ( |
146 | diffor | 372 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
373 | `orig_id` INT(5) DEFAULT NULL, |
||
374 | `dist_id` INT(5) DEFAULT NULL, |
||
375 | PRIMARY KEY (`id`), |
||
376 | KEY `orig_id` (`orig_id`), |
||
158 | diffor | 377 | KEY `dist_id` (`dist_id`) |
378 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |