Редакция 41 | Редакция 45 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 41 | Редакция 44 | ||
---|---|---|---|
Строка 1... | Строка 1... | ||
1 | -- phpMyAdmin SQL Dump
|
1 | -- phpMyAdmin SQL Dump
|
2 | -- version 3.2.1deb1
|
2 | -- version 3.2.1deb1
|
3 | -- http://www.phpmyadmin.net
|
3 | -- http://www.phpmyadmin.net
|
4 | --
|
4 | --
|
5 | -- Хост: localhost
|
5 | -- Хост: localhost
|
6 | -- Время создания: Окт 15 2009 г., 20:46
|
6 | -- Время создания: Окт 15 2009 г., 22:34
|
7 | -- Версия сервера: 5.1.37
|
7 | -- Версия сервера: 5.1.37
|
8 | -- Версия PHP: 5.2.10-2ubuntu5
|
8 | -- Версия PHP: 5.2.10-2ubuntu5
|
9 | 9 | ||
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
11 | 11 | ||
Строка 241... | Строка 241... | ||
241 | `resource_id` INT(2) NOT NULL, |
241 | `resource_id` INT(2) NOT NULL, |
242 | `network_id` INT(2) NOT NULL, |
242 | `network_id` INT(2) NOT NULL, |
243 | `state_id` INT(2) NOT NULL, |
243 | `state_id` INT(2) NOT NULL, |
244 | PRIMARY KEY (`id`), |
244 | PRIMARY KEY (`id`), |
245 | KEY `resource_id` (`resource_id`,`network_id`) |
245 | KEY `resource_id` (`resource_id`,`network_id`) |
246 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=57 ; |
246 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=105 ; |
247 | 247 | ||
248 | --
|
248 | --
|
249 | -- Дамп данных таблицы `res_net_stat`
|
249 | -- Дамп данных таблицы `res_net_stat`
|
250 | --
|
250 | --
|
251 | 251 | ||
252 | INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES |
252 | INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES |
253 | (1, 1, 2, 1), |
253 | (1, 1, 2, 1), |
254 | (2, 1, 3, 1), |
254 | (2, 1, 3, 1), |
255 | (3, 1, 4, 4), |
255 | (3, 1, 4, 4), |
256 | (4, 1, 5, 3), |
256 | (4, 1, 5, 3), |
257 | (5, 2, 2, 2), |
257 | (5, 2, 2, 1), |
258 | (6, 2, 3, 2), |
258 | (6, 2, 3, 1), |
259 | (7, 2, 4, 4), |
259 | (7, 2, 4, 4), |
260 | (8, 2, 5, 1), |
260 | (8, 2, 5, 1), |
261 | (9, 3, 1, 1), |
261 | (9, 3, 1, 1), |
262 | (10, 3, 2, 1), |
262 | (10, 3, 2, 1), |
263 | (11, 3, 3, 2), |
263 | (11, 3, 3, 2), |
Строка 276... | Строка 276... | ||
276 | (24, 7, 3, 1), |
276 | (24, 7, 3, 1), |
277 | (25, 7, 5, 3), |
277 | (25, 7, 5, 3), |
278 | (26, 8, 2, 1), |
278 | (26, 8, 2, 1), |
279 | (27, 8, 3, 1), |
279 | (27, 8, 3, 1), |
280 | (28, 8, 5, 3), |
280 | (28, 8, 5, 3), |
281 | (29, 9, 2, 4), |
281 | (29, 9, 2, 5), |
282 | (30, 9, 3, 4), |
282 | (30, 9, 3, 5), |
283 | (31, 9, 5, 4), |
283 | (31, 9, 5, 5), |
284 | (32, 10, 1, 1), |
284 | (32, 10, 1, 1), |
285 | (33, 10, 2, 1), |
285 | (33, 10, 2, 1), |
286 | (34, 10, 3, 2), |
286 | (34, 10, 3, 2), |
287 | (35, 10, 5, 3), |
287 | (35, 10, 5, 3), |
288 | (36, 11, 1, 1), |
288 | (36, 11, 1, 1), |
Строка 293... | Строка 293... | ||
293 | (41, 2, 7, 3), |
293 | (41, 2, 7, 3), |
294 | (42, 5, 7, 3), |
294 | (42, 5, 7, 3), |
295 | (43, 6, 7, 3), |
295 | (43, 6, 7, 3), |
296 | (44, 7, 7, 3), |
296 | (44, 7, 7, 3), |
297 | (45, 8, 7, 3), |
297 | (45, 8, 7, 3), |
298 | (46, 9, 7, 4), |
298 | (46, 9, 7, 5), |
299 | (47, 3, 8, 3), |
299 | (47, 3, 8, 3), |
300 | (48, 4, 8, 3), |
300 | (48, 4, 8, 3), |
301 | (49, 1, 8, 3), |
301 | (49, 1, 8, 3), |
302 | (50, 2, 8, 3), |
302 | (50, 2, 8, 3), |
303 | (51, 5, 8, 3), |
303 | (51, 5, 8, 3), |
304 | (52, 6, 8, 3), |
304 | (52, 6, 8, 3), |
305 | (53, 7, 8, 3), |
305 | (53, 7, 8, 3), |
306 | (54, 8, 8, 3), |
306 | (54, 8, 8, 3), |
307 | (55, 9, 8, 4), |
307 | (55, 9, 8, 5), |
308 | (56, 10, 8, 3); |
308 | (56, 10, 8, 3), |
- | 309 | (57, 1, 9, 4), |
|
- | 310 | (58, 2, 9, 4), |
|
- | 311 | (59, 3, 9, 4), |
|
- | 312 | (60, 4, 9, 4), |
|
- | 313 | (61, 5, 9, 4), |
|
- | 314 | (62, 6, 9, 4), |
|
- | 315 | (63, 7, 9, 4), |
|
- | 316 | (64, 8, 9, 4), |
|
- | 317 | (65, 9, 9, 5), |
|
- | 318 | (66, 10, 9, 4), |
|
- | 319 | (67, 1, 10, 4), |
|
- | 320 | (68, 2, 10, 4), |
|
- | 321 | (69, 3, 10, 4), |
|
- | 322 | (70, 4, 10, 4), |
|
- | 323 | (71, 5, 10, 4), |
|
- | 324 | (72, 6, 10, 4), |
|
- | 325 | (73, 7, 10, 4), |
|
- | 326 | (74, 8, 10, 4), |
|
- | 327 | (75, 9, 10, 5), |
|
- | 328 | (76, 10, 10, 4), |
|
- | 329 | (77, 1, 11, 4), |
|
- | 330 | (78, 2, 11, 4), |
|
- | 331 | (79, 3, 11, 4), |
|
- | 332 | (80, 4, 11, 4), |
|
- | 333 | (81, 5, 11, 4), |
|
- | 334 | (82, 6, 11, 4), |
|
- | 335 | (83, 7, 11, 4), |
|
- | 336 | (84, 8, 11, 4), |
|
- | 337 | (85, 9, 11, 5), |
|
- | 338 | (86, 10, 11, 4), |
|
- | 339 | (87, 1, 12, 4), |
|
- | 340 | (88, 2, 12, 4), |
|
- | 341 | (89, 3, 12, 4), |
|
- | 342 | (90, 4, 12, 4), |
|
- | 343 | (91, 5, 12, 4), |
|
- | 344 | (92, 6, 12, 4), |
|
- | 345 | (93, 7, 12, 4), |
|
- | 346 | (94, 8, 12, 4), |
|
- | 347 | (95, 9, 12, 5), |
|
- | 348 | (96, 10, 12, 4), |
|
- | 349 | (97, 3, 4, 4), |
|
- | 350 | (98, 4, 4, 4), |
|
- | 351 | (99, 5, 4, 4), |
|
- | 352 | (100, 6, 4, 4), |
|
- | 353 | (101, 7, 4, 4), |
|
- | 354 | (102, 8, 4, 4), |
|
- | 355 | (103, 9, 4, 5), |
|
- | 356 | (104, 10, 4, 4); |
|
309 | 357 | ||
310 | -- --------------------------------------------------------
|
358 | -- --------------------------------------------------------
|
311 | 359 | ||
312 | --
|
360 | --
|
313 | -- Структура таблицы `states`
|
361 | -- Структура таблицы `states`
|
Строка 317... | Строка 365... | ||
317 | CREATE TABLE IF NOT EXISTS `states` ( |
365 | CREATE TABLE IF NOT EXISTS `states` ( |
318 | `id` INT(3) NOT NULL AUTO_INCREMENT, |
366 | `id` INT(3) NOT NULL AUTO_INCREMENT, |
319 | `image` VARCHAR(50) NOT NULL, |
367 | `image` VARCHAR(50) NOT NULL, |
320 | `description` VARCHAR(50) NOT NULL, |
368 | `description` VARCHAR(50) NOT NULL, |
321 | PRIMARY KEY (`id`) |
369 | PRIMARY KEY (`id`) |
322 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; |
370 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; |
323 | 371 | ||
324 | --
|
372 | --
|
325 | -- Дамп данных таблицы `states`
|
373 | -- Дамп данных таблицы `states`
|
326 | --
|
374 | --
|
327 | 375 | ||
328 | INSERT INTO `states` (`id`, `image`, `description`) VALUES |
376 | INSERT INTO `states` (`id`, `image`, `description`) VALUES |
329 | (1, './img/state/main.png', 'Основной ресурс'), |
377 | (1, './img/state/tick_gold.png', 'Основной ресурс'), |
330 | (2, './img/state/mirror.png', 'Зеркало ресурса'), |
378 | (2, './img/state/tick_blue.png', 'Зеркало ресурса'), |
331 | (3, './img/state/access.png', 'Свободный высокоскоростной доступ'), |
379 | (3, './img/state/tick_green.png', 'Свободный высокоскоростной доступ'), |
- | 380 | (4, './img/state/tick_gray.png', 'Доступ без преимуществ'), |
|
332 | (4, './img/state/freeze.png', 'Временно недоступен'); |
381 | (5, './img/state/snowflake.png', 'Приостановлен'); |
333 | 382 | ||
334 | -- --------------------------------------------------------
|
383 | -- --------------------------------------------------------
|
335 | 384 | ||
336 | --
|
385 | --
|
337 | -- Структура таблицы `subnets`
|
386 | -- Структура таблицы `subnets`
|