| 3,7 → 3,7 |
|---|
| -- http://www.phpmyadmin.net |
| -- |
| -- Хост: localhost |
| -- Время создания: Авг 03 2009 г., 15:02 |
| -- Время создания: Авг 03 2009 г., 17:28 |
| -- Версия сервера: 5.0.51 |
| -- Версия PHP: 4.4.7 |
| -- |
| 41,14 → 41,21 |
|---|
| DROP TABLE IF EXISTS `members`; |
| CREATE TABLE IF NOT EXISTS `members` ( |
| `id` int(2) NOT NULL auto_increment, |
| `member` varchar(50) collate utf8_unicode_ci NOT NULL, |
| `nick` varchar(50) collate utf8_unicode_ci NOT NULL, |
| `avatar` varchar(50) collate utf8_unicode_ci NOT NULL, |
| `jabber` varchar(50) collate utf8_unicode_ci NOT NULL, |
| `icq` int(15) NOT NULL, |
| PRIMARY KEY (`id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; |
| |
| -- |
| -- Дамп данных таблицы `members` |
| -- |
| |
| INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES |
| (1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0), |
| (2, 'firstleon', './img/avatar/firstleon.jpg', '—', 0), |
| (3, 'SlipKnoT8', './img/avatar/slipknot8.gif', '—', 0); |
| |
| -- -------------------------------------------------------- |
| |
| 78,6 → 85,31 |
|---|
| -- -------------------------------------------------------- |
| |
| -- |
| -- Структура таблицы `res_mem_rank` |
| -- |
| |
| DROP TABLE IF EXISTS `res_mem_rank`; |
| CREATE TABLE IF NOT EXISTS `res_mem_rank` ( |
| `id` int(5) NOT NULL auto_increment, |
| `member_id` int(2) NOT NULL, |
| `res_net_id` int(5) NOT NULL, |
| `rank_id` int(2) NOT NULL, |
| PRIMARY KEY (`id`), |
| KEY `resource_id` (`res_net_id`,`rank_id`), |
| KEY `member_id` (`member_id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; |
| |
| -- |
| -- Дамп данных таблицы `res_mem_rank` |
| -- |
| |
| INSERT INTO `res_mem_rank` (`id`, `member_id`, `res_net_id`, `rank_id`) VALUES |
| (1, 3, 1, 1), |
| (2, 3, 2, 1); |
| |
| -- -------------------------------------------------------- |
| |
| -- |
| -- Структура таблицы `res_net_stat` |
| -- |
| |