Редакция 153 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 153 | Редакция 158 | ||
|---|---|---|---|
| Строка 346... | Строка 346... | ||
| 346 | `vcodename` VARCHAR(10) DEFAULT NULL, |
346 | `vcodename` VARCHAR(10) DEFAULT NULL, |
| 347 | PRIMARY KEY (`version_id`), |
347 | PRIMARY KEY (`version_id`), |
| 348 | KEY `dist_id` (`dist_id`) |
348 | KEY `dist_id` (`dist_id`) |
| 349 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
349 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
| 350 | 350 | ||
| 351 | -- --------------------------------------------------------
|
- | |
| 352 | - | ||
| 353 | --
|
351 | --
|
| 354 | -- Структура таблицы `origin`
|
352 | -- Структура таблицы `origin`
|
| 355 | --
|
353 | --
|
| 356 | 354 | ||
| 357 | CREATE TABLE IF NOT EXISTS `origin` ( |
355 | CREATE TABLE IF NOT EXISTS `origin` ( |
| 358 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
356 | `orig_id` INT(5) NOT NULL AUTO_INCREMENT, |
| 359 | `origin` VARCHAR(25) DEFAULT NULL, |
357 | `origin` VARCHAR(30) DEFAULT NULL, |
| 360 | `desk` text NOT NULL, |
358 | `desk` text NOT NULL, |
| 361 | `basedir` VARCHAR(50) NOT NULL, |
359 | `basedir` VARCHAR(50) NOT NULL, |
| 362 | `homeurl` VARCHAR(50) NOT NULL, |
360 | `homeurl` VARCHAR(50) NOT NULL, |
| 363 | `keyurl` VARCHAR(50) NOT NULL, |
361 | `keyurl` VARCHAR(50) NOT NULL, |
| 364 | PRIMARY KEY (`id`) |
362 | PRIMARY KEY (`orig_id`) |
| 365 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; |
363 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
| 366 | 364 | ||
| 367 | -- --------------------------------------------------------
|
365 | -- --------------------------------------------------------
|
| 368 | 366 | ||
| 369 | --
|
367 | --
|
| 370 | -- Структура таблицы `orig2rep`
|
368 | -- Структура таблицы `orig2dist`
|
| 371 | --
|
369 | --
|
| 372 | 370 | ||
| 373 | CREATE TABLE IF NOT EXISTS `orig2reps` ( |
371 | CREATE TABLE IF NOT EXISTS `orig2dist` ( |
| 374 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
372 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
| 375 | `orig_id` INT(5) DEFAULT NULL, |
373 | `orig_id` INT(5) DEFAULT NULL, |
| 376 | `dist_id` INT(5) DEFAULT NULL, |
374 | `dist_id` INT(5) DEFAULT NULL, |
| 377 | `ver_id` INT(5) DEFAULT NULL, |
- | |
| 378 | `rep_id` INT(5) DEFAULT NULL, |
- | |
| 379 | PRIMARY KEY (`id`), |
375 | PRIMARY KEY (`id`), |
| 380 | KEY `orig_id` (`orig_id`), |
376 | KEY `orig_id` (`orig_id`), |
| 381 | KEY `dist_id` (`dist_id`), |
377 | KEY `dist_id` (`dist_id`) |
| 382 | KEY `ver_id` (`ver_id`), |
- | |
| 383 | KEY `rep_id` (`rep_id`) |
- | |
| 384 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
378 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |