Редакция 158 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 158 | Редакция 206 | ||
|---|---|---|---|
| Строка 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 | -- Время создания: Апр 01 2009 г., 14:40
|
6 | -- Время создания: Апр 16 2009 г., 20:12
|
| 7 | -- Версия сервера: 5.0.51
|
7 | -- Версия сервера: 5.0.51
|
| 8 | -- Версия PHP: 5.2.6-1+lenny2
|
8 | -- Версия PHP: 5.2.6-1+lenny2
|
| 9 | 9 | ||
| 10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| 11 | 11 | ||
| Строка 103... | Строка 103... | ||
| 103 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
103 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
| 104 | 104 | ||
| 105 | -- --------------------------------------------------------
|
105 | -- --------------------------------------------------------
|
| 106 | 106 | ||
| 107 | --
|
107 | --
|
| - | 108 | -- Структура таблицы `origin`
|
|
| - | 109 | --
|
|
| - | 110 | ||
| - | 111 | CREATE TABLE IF NOT EXISTS `origin` ( |
|
| - | 112 | `orig_id` INT(5) NOT NULL AUTO_INCREMENT, |
|
| - | 113 | `origin` VARCHAR(30) DEFAULT NULL, |
|
| - | 114 | `desk` text NOT NULL, |
|
| - | 115 | `basedir` VARCHAR(50) NOT NULL, |
|
| - | 116 | `homeurl` VARCHAR(50) NOT NULL, |
|
| - | 117 | `keyurl` VARCHAR(50) NOT NULL, |
|
| - | 118 | PRIMARY KEY (`orig_id`) |
|
| - | 119 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; |
|
| - | 120 | ||
| - | 121 | -- --------------------------------------------------------
|
|
| - | 122 | ||
| - | 123 | --
|
|
| 108 | -- Структура таблицы `owner`
|
124 | -- Структура таблицы `owner`
|
| 109 | --
|
125 | --
|
| 110 | 126 | ||
| 111 | CREATE TABLE IF NOT EXISTS `owner` ( |
127 | CREATE TABLE IF NOT EXISTS `owner` ( |
| 112 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
128 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
| Строка 126... | Строка 142... | ||
| 126 | `repname` VARCHAR(20) DEFAULT NULL, |
142 | `repname` VARCHAR(20) DEFAULT NULL, |
| 127 | `repdescribe` text, |
143 | `repdescribe` text, |
| 128 | `scheme_id` INT(2) NOT NULL, |
144 | `scheme_id` INT(2) NOT NULL, |
| 129 | `rtype_id` INT(2) NOT NULL, |
145 | `rtype_id` INT(2) NOT NULL, |
| 130 | `root_id` INT(2) NOT NULL, |
146 | `root_id` INT(2) NOT NULL, |
| - | 147 | `orig_id` INT(5) NOT NULL, |
|
| - | 148 | `default` tinyint(1) NOT NULL, |
|
| 131 | PRIMARY KEY (`rep_id`), |
149 | PRIMARY KEY (`rep_id`), |
| 132 | KEY `scheme` (`scheme_id`), |
150 | KEY `scheme` (`scheme_id`), |
| 133 | KEY `rtype_id` (`rtype_id`), |
151 | KEY `rtype_id` (`rtype_id`), |
| 134 | KEY `root_id` (`root_id`) |
152 | KEY `root_id` (`root_id`), |
| - | 153 | KEY `orig_id` (`orig_id`) |
|
| 135 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ; |
154 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ; |
| 136 | 155 | ||
| 137 | -- --------------------------------------------------------
|
156 | -- --------------------------------------------------------
|
| 138 | 157 | ||
| 139 | --
|
158 | --
|
| Строка 194... | Строка 213... | ||
| 194 | `id` INT(10) NOT NULL AUTO_INCREMENT, |
213 | `id` INT(10) NOT NULL AUTO_INCREMENT, |
| 195 | `sect_id` INT(3) NOT NULL, |
214 | `sect_id` INT(3) NOT NULL, |
| 196 | `rep_id` INT(5) NOT NULL, |
215 | `rep_id` INT(5) NOT NULL, |
| 197 | PRIMARY KEY (`id`), |
216 | PRIMARY KEY (`id`), |
| 198 | KEY `sect_id` (`sect_id`,`rep_id`) |
217 | KEY `sect_id` (`sect_id`,`rep_id`) |
| 199 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=529 ; |
218 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=671 ; |
| 200 | 219 | ||
| 201 | -- --------------------------------------------------------
|
220 | -- --------------------------------------------------------
|
| 202 | 221 | ||
| 203 | --
|
222 | --
|
| 204 | -- Структура таблицы `section`
|
223 | -- Структура таблицы `section`
|
| Строка 235... | Строка 254... | ||
| 235 | `ver_id` INT(5) DEFAULT NULL, |
254 | `ver_id` INT(5) DEFAULT NULL, |
| 236 | `rep_id` INT(5) DEFAULT NULL, |
255 | `rep_id` INT(5) DEFAULT NULL, |
| 237 | PRIMARY KEY (`id`), |
256 | PRIMARY KEY (`id`), |
| 238 | KEY `ver_id` (`ver_id`), |
257 | KEY `ver_id` (`ver_id`), |
| 239 | KEY `rep_id` (`rep_id`) |
258 | KEY `rep_id` (`rep_id`) |
| 240 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ; |
259 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ; |
| 241 | 260 | ||
| 242 | -- --------------------------------------------------------
|
261 | -- --------------------------------------------------------
|
| 243 | 262 | ||
| 244 | --
|
263 | --
|
| 245 | -- Структура таблицы `version`
|
264 | -- Структура таблицы `version`
|
| Строка 252... | Строка 271... | ||
| 252 | `version` VARCHAR(10) NOT NULL, |
271 | `version` VARCHAR(10) NOT NULL, |
| 253 | `vcodename` VARCHAR(10) DEFAULT NULL, |
272 | `vcodename` VARCHAR(10) DEFAULT NULL, |
| 254 | PRIMARY KEY (`version_id`), |
273 | PRIMARY KEY (`version_id`), |
| 255 | KEY `dist_id` (`dist_id`) |
274 | KEY `dist_id` (`dist_id`) |
| 256 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; |
275 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; |
| 257 | - | ||
| 258 | --
|
- | |
| 259 | -- Структура таблицы `origin`
|
- | |
| 260 | --
|
- | |
| 261 | - | ||
| 262 | CREATE TABLE IF NOT EXISTS `origin` ( |
- | |
| 263 | `orig_id` INT(5) NOT NULL AUTO_INCREMENT, |
- | |
| 264 | `origin` VARCHAR(30) DEFAULT NULL, |
- | |
| 265 | `desk` text NOT NULL, |
- | |
| 266 | `basedir` VARCHAR(50) NOT NULL, |
- | |
| 267 | `homeurl` VARCHAR(50) NOT NULL, |
- | |
| 268 | `keyurl` VARCHAR(50) NOT NULL, |
- | |
| 269 | PRIMARY KEY (`orig_id`) |
- | |
| 270 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; |
- | |
| 271 | - | ||
| 272 | -- --------------------------------------------------------
|
- | |
| 273 | - | ||
| 274 | --
|
- | |
| 275 | -- Структура таблицы `orig2dist`
|
- | |
| 276 | --
|
- | |
| 277 | - | ||
| 278 | CREATE TABLE IF NOT EXISTS `orig2dist` ( |
- | |
| 279 | `id` INT(11) NOT NULL AUTO_INCREMENT, |
- | |
| 280 | `orig_id` INT(5) DEFAULT NULL, |
- | |
| 281 | `dist_id` INT(5) DEFAULT NULL, |
- | |
| 282 | PRIMARY KEY (`id`), |
- | |
| 283 | KEY `orig_id` (`orig_id`), |
- | |
| 284 | KEY `dist_id` (`dist_id`) |
- | |
| 285 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; |
- | |
| 286 | - | ||