WebSVN - www_nix-files - Различия - Редакция 41 и 44

 -- phpMyAdmin SQL Dump
 -- version 3.2.1deb1
 -- http://www.phpmyadmin.net
 --
 -- Хост: localhost
--- Время создания: Окт 15 2009 г., 20:46
+-- Время создания: Окт 15 2009 г., 22:34
 -- Версия сервера: 5.1.37
 -- Версия PHP: 5.2.10-2ubuntu5
 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
   `resource_id` INT(2) NOT NULL,
   `network_id` INT(2) NOT NULL,
   `state_id` INT(2) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `resource_id` (`resource_id`,`network_id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=57 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=105 ;
 --
 -- Дамп данных таблицы `res_net_stat`
 --
 INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES
 (1, 1, 2, 1),
 (2, 1, 3, 1),
 (3, 1, 4, 4),
 (4, 1, 5, 3),
-(5, 2, 2, 2),
+(5, 2, 2, 1),
-(6, 2, 3, 2),
+(6, 2, 3, 1),
 (7, 2, 4, 4),
 (8, 2, 5, 1),
 (9, 3, 1, 1),
 (10, 3, 2, 1),
 (11, 3, 3, 2),
 (24, 7, 3, 1),
 (25, 7, 5, 3),
 (26, 8, 2, 1),
 (27, 8, 3, 1),
 (28, 8, 5, 3),
-(29, 9, 2, 4),
+(29, 9, 2, 5),
-(30, 9, 3, 4),
+(30, 9, 3, 5),
-(31, 9, 5, 4),
+(31, 9, 5, 5),
 (32, 10, 1, 1),
 (33, 10, 2, 1),
 (34, 10, 3, 2),
 (35, 10, 5, 3),
 (36, 11, 1, 1),
 (41, 2, 7, 3),
 (42, 5, 7, 3),
 (43, 6, 7, 3),
 (44, 7, 7, 3),
 (45, 8, 7, 3),
-(46, 9, 7, 4),
+(46, 9, 7, 5),
 (47, 3, 8, 3),
 (48, 4, 8, 3),
 (49, 1, 8, 3),
 (50, 2, 8, 3),
 (51, 5, 8, 3),
 (52, 6, 8, 3),
 (53, 7, 8, 3),
 (54, 8, 8, 3),
-(55, 9, 8, 4),
+(55, 9, 8, 5),
-(56, 10, 8, 3);
+(56, 10, 8, 3),
+(57, 1, 9, 4),
+(58, 2, 9, 4),
+(59, 3, 9, 4),
+(60, 4, 9, 4),
+(61, 5, 9, 4),
+(62, 6, 9, 4),
+(63, 7, 9, 4),
+(64, 8, 9, 4),
+(65, 9, 9, 5),
+(66, 10, 9, 4),
+(67, 1, 10, 4),
+(68, 2, 10, 4),
+(69, 3, 10, 4),
+(70, 4, 10, 4),
+(71, 5, 10, 4),
+(72, 6, 10, 4),
+(73, 7, 10, 4),
+(74, 8, 10, 4),
+(75, 9, 10, 5),
+(76, 10, 10, 4),
+(77, 1, 11, 4),
+(78, 2, 11, 4),
+(79, 3, 11, 4),
+(80, 4, 11, 4),
+(81, 5, 11, 4),
+(82, 6, 11, 4),
+(83, 7, 11, 4),
+(84, 8, 11, 4),
+(85, 9, 11, 5),
+(86, 10, 11, 4),
+(87, 1, 12, 4),
+(88, 2, 12, 4),
+(89, 3, 12, 4),
+(90, 4, 12, 4),
+(91, 5, 12, 4),
+(92, 6, 12, 4),
+(93, 7, 12, 4),
+(94, 8, 12, 4),
+(95, 9, 12, 5),
+(96, 10, 12, 4),
+(97, 3, 4, 4),
+(98, 4, 4, 4),
+(99, 5, 4, 4),
+(100, 6, 4, 4),
+(101, 7, 4, 4),
+(102, 8, 4, 4),
+(103, 9, 4, 5),
+(104, 10, 4, 4);
 -- --------------------------------------------------------
 --
 -- Структура таблицы `states`
 CREATE TABLE IF NOT EXISTS `states` (
   `id` INT(3) NOT NULL AUTO_INCREMENT,
   `image` VARCHAR(50) NOT NULL,
   `description` VARCHAR(50) NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
 --
 -- Дамп данных таблицы `states`
 --
 INSERT INTO `states` (`id`, `image`, `description`) VALUES
-(1, './img/state/main.png', 'Основной ресурс'),
+(1, './img/state/tick_gold.png', 'Основной ресурс'),
-(2, './img/state/mirror.png', 'Зеркало ресурса'),
+(2, './img/state/tick_blue.png', 'Зеркало ресурса'),
-(3, './img/state/access.png', 'Свободный высокоскоростной доступ'),
+(3, './img/state/tick_green.png', 'Свободный высокоскоростной доступ'),
+(4, './img/state/tick_gray.png', 'Доступ без преимуществ'),
-(4, './img/state/freeze.png', 'Временно недоступен');
+(5, './img/state/snowflake.png', 'Приостановлен');
 -- --------------------------------------------------------
 --
 -- Структура таблицы `subnets`

Хранилища Subversion www_nix-files

(root)/trunk/db/nix-files.sql @ 207 - Редакция 41 → 44