Редакция 306 | Редакция 459 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 306 | Редакция 328 | ||
|---|---|---|---|
| Строка 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 | -- Время создания: Окт 14 2009 г., 17:09
|
6 | -- Время создания: Окт 16 2009 г., 19:12
|
| 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 | ||
| Строка 109... | Строка 109... | ||
| 109 | (2, 'rpm'); |
109 | (2, 'rpm'); |
| 110 | 110 | ||
| 111 | -- --------------------------------------------------------
|
111 | -- --------------------------------------------------------
|
| 112 | 112 | ||
| 113 | --
|
113 | --
|
| 114 | -- Структура таблицы `g_host2net`
|
- | |
| 115 | --
|
- | |
| 116 | - | ||
| 117 | DROP TABLE IF EXISTS `g_host2net`; |
- | |
| 118 | CREATE TABLE IF NOT EXISTS `g_host2net` ( |
- | |
| 119 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
- | |
| 120 | `rhost_id` INT(3) NOT NULL, |
- | |
| 121 | `nb_id` INT(2) NOT NULL, |
- | |
| 122 | PRIMARY KEY (`id`), |
- | |
| 123 | KEY `rhost_id` (`rhost_id`) |
- | |
| 124 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts into network block' AUTO_INCREMENT=3 ; |
- | |
| 125 | - | ||
| 126 | --
|
- | |
| 127 | -- Дамп данных таблицы `g_host2net`
|
- | |
| 128 | --
|
- | |
| 129 | - | ||
| 130 | INSERT INTO `g_host2net` (`id`, `rhost_id`, `nb_id`) VALUES |
- | |
| 131 | (1, 1, 1), |
- | |
| 132 | (2, 2, 1); |
- | |
| 133 | - | ||
| 134 | -- --------------------------------------------------------
|
- | |
| 135 | - | ||
| 136 | --
|
- | |
| 137 | -- Структура таблицы `g_netblock`
|
- | |
| 138 | --
|
- | |
| 139 | - | ||
| 140 | DROP TABLE IF EXISTS `g_netblock`; |
- | |
| 141 | CREATE TABLE IF NOT EXISTS `g_netblock` ( |
- | |
| 142 | `nb_id` INT(2) NOT NULL AUTO_INCREMENT, |
- | |
| 143 | `netblock` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
- | |
| 144 | PRIMARY KEY (`nb_id`) |
- | |
| 145 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Network blocks' AUTO_INCREMENT=3 ; |
- | |
| 146 | - | ||
| 147 | --
|
- | |
| 148 | -- Дамп данных таблицы `g_netblock`
|
- | |
| 149 | --
|
- | |
| 150 | - | ||
| 151 | INSERT INTO `g_netblock` (`nb_id`, `netblock`) VALUES |
- | |
| 152 | (1, 'AltLUG'), |
- | |
| 153 | (2, 'SibNET'); |
- | |
| 154 | - | ||
| 155 | -- --------------------------------------------------------
|
- | |
| 156 | - | ||
| 157 | --
|
- | |
| 158 | -- Структура таблицы `g_protos`
|
114 | -- Структура таблицы `g_protos`
|
| 159 | --
|
115 | --
|
| 160 | 116 | ||
| 161 | DROP TABLE IF EXISTS `g_protos`; |
117 | DROP TABLE IF EXISTS `g_protos`; |
| 162 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
118 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
| Строка 202... | Строка 158... | ||
| 202 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
158 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
| 203 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
159 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
| 204 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
160 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
| 205 | PRIMARY KEY (`rhost_id`), |
161 | PRIMARY KEY (`rhost_id`), |
| 206 | KEY `proto_id` (`rhost`) |
162 | KEY `proto_id` (`rhost`) |
| 207 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=3 ; |
163 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ; |
| 208 | 164 | ||
| 209 | --
|
165 | --
|
| 210 | -- Дамп данных таблицы `g_rephost`
|
166 | -- Дамп данных таблицы `g_rephost`
|
| 211 | --
|
167 | --
|
| 212 | 168 | ||
| 213 | INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
169 | INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
| 214 | (1, 'apt.nix-files.org.ru'), |
170 | (1, 'apt.nix-files.org.ru'), |
| 215 | (2, 'hyperion.uni-altai.ru'); |
171 | (2, 'hyperion.uni-altai.ru'), |
| - | 172 | (3, 'apt.nix-files.uni-altai.ru'); |
|
| 216 | 173 | ||
| 217 | -- --------------------------------------------------------
|
174 | -- --------------------------------------------------------
|
| 218 | 175 | ||
| 219 | --
|
176 | --
|
| 220 | -- Структура таблицы `g_repository`
|
177 | -- Структура таблицы `g_repository`
|
| Строка 227... | Строка 184... | ||
| 227 | `rhost_id` INT(3) NOT NULL, |
184 | `rhost_id` INT(3) NOT NULL, |
| 228 | `rfolder_id` INT(5) NOT NULL, |
185 | `rfolder_id` INT(5) NOT NULL, |
| 229 | `version` INT(5) NOT NULL, |
186 | `version` INT(5) NOT NULL, |
| 230 | `rtype_id` INT(2) NOT NULL, |
187 | `rtype_id` INT(2) NOT NULL, |
| 231 | `scheme_id` INT(2) NOT NULL, |
188 | `scheme_id` INT(2) NOT NULL, |
| - | 189 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
|
| 232 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
190 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
| 233 | `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL, |
191 | `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL, |
| 234 | PRIMARY KEY (`rep_id`), |
192 | PRIMARY KEY (`rep_id`), |
| 235 | KEY `proto_id` (`proto_id`), |
193 | KEY `proto_id` (`proto_id`), |
| 236 | KEY `rhost_id` (`rhost_id`), |
194 | KEY `rhost_id` (`rhost_id`), |
| 237 | KEY `rfolder_id` (`rfolder_id`), |
195 | KEY `rfolder_id` (`rfolder_id`), |
| 238 | KEY `version` (`version`), |
196 | KEY `version` (`version`), |
| 239 | KEY `rtype_id` (`rtype_id`), |
197 | KEY `rtype_id` (`rtype_id`), |
| 240 | KEY `scheme_id` (`scheme_id`) |
198 | KEY `scheme_id` (`scheme_id`) |
| 241 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=1 ; |
199 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ; |
| 242 | 200 | ||
| 243 | --
|
201 | --
|
| 244 | -- Дамп данных таблицы `g_repository`
|
202 | -- Дамп данных таблицы `g_repository`
|
| 245 | --
|
203 | --
|
| 246 | 204 | ||
| - | 205 | INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `repname`, `repinfo`, `repkey`) VALUES |
|
| - | 206 | (1, 1, 1, 1, 1, 1, 1, 'Sarge Base', 'eeee', ''); |
|
| 247 | 207 | ||
| 248 | -- --------------------------------------------------------
|
208 | -- --------------------------------------------------------
|
| 249 | 209 | ||
| 250 | --
|
210 | --
|
| 251 | -- Структура таблицы `g_repscheme`
|
211 | -- Структура таблицы `g_repscheme`
|
| Строка 307... | Строка 267... | ||
| 307 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
267 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
| 308 | `sect_id` INT(2) NOT NULL, |
268 | `sect_id` INT(2) NOT NULL, |
| 309 | `rep_id` INT(5) NOT NULL, |
269 | `rep_id` INT(5) NOT NULL, |
| 310 | PRIMARY KEY (`id`), |
270 | PRIMARY KEY (`id`), |
| 311 | KEY `sect_id` (`sect_id`,`rep_id`) |
271 | KEY `sect_id` (`sect_id`,`rep_id`) |
| 312 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=1 ; |
272 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
| 313 | 273 | ||
| 314 | --
|
274 | --
|
| 315 | -- Дамп данных таблицы `g_sect2rep`
|
275 | -- Дамп данных таблицы `g_sect2rep`
|
| 316 | --
|
276 | --
|
| 317 | 277 | ||
| - | 278 | INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES |
|
| - | 279 | (1, 1, 1), |
|
| - | 280 | (2, 2, 1), |
|
| - | 281 | (3, 3, 1); |
|
| 318 | 282 | ||
| 319 | -- --------------------------------------------------------
|
283 | -- --------------------------------------------------------
|
| 320 | 284 | ||
| 321 | --
|
285 | --
|
| 322 | -- Структура таблицы `g_section`
|
286 | -- Структура таблицы `g_section`
|