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

Сравнить редакции

Не учитывать пробелы Редакция 43 → Редакция 44

/trunk/db/nix-files.sql
3,7 → 3,7
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Окт 15 2009 г., 20:46
-- Время создания: Окт 15 2009 г., 22:34
-- Версия сервера: 5.1.37
-- Версия PHP: 5.2.10-2ubuntu5
 
243,7 → 243,7
`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`
254,8 → 254,8
(2, 1, 3, 1),
(3, 1, 4, 4),
(4, 1, 5, 3),
(5, 2, 2, 2),
(6, 2, 3, 2),
(5, 2, 2, 1),
(6, 2, 3, 1),
(7, 2, 4, 4),
(8, 2, 5, 1),
(9, 3, 1, 1),
278,9 → 278,9
(26, 8, 2, 1),
(27, 8, 3, 1),
(28, 8, 5, 3),
(29, 9, 2, 4),
(30, 9, 3, 4),
(31, 9, 5, 4),
(29, 9, 2, 5),
(30, 9, 3, 5),
(31, 9, 5, 5),
(32, 10, 1, 1),
(33, 10, 2, 1),
(34, 10, 3, 2),
295,7 → 295,7
(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),
304,8 → 304,56
(52, 6, 8, 3),
(53, 7, 8, 3),
(54, 8, 8, 3),
(55, 9, 8, 4),
(56, 10, 8, 3);
(55, 9, 8, 5),
(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);
 
-- --------------------------------------------------------
 
319,7 → 367,7
`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`
326,10 → 374,11
--
 
INSERT INTO `states` (`id`, `image`, `description`) VALUES
(1, './img/state/main.png', 'Основной ресурс'),
(2, './img/state/mirror.png', 'Зеркало ресурса'),
(3, './img/state/access.png', 'Свободный высокоскоростной доступ'),
(4, './img/state/freeze.png', 'Временно недоступен');
(1, './img/state/tick_gold.png', 'Основной ресурс'),
(2, './img/state/tick_blue.png', 'Зеркало ресурса'),
(3, './img/state/tick_green.png', 'Свободный высокоскоростной доступ'),
(4, './img/state/tick_gray.png', 'Доступ без преимуществ'),
(5, './img/state/snowflake.png', 'Приостановлен');
 
-- --------------------------------------------------------