Редакция 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`
|