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

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

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

/trunk/db/nix-files.sql
3,7 → 3,7
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Авг 03 2009 г., 22:02
-- Время создания: Авг 03 2009 г., 23:24
-- Версия сервера: 5.0.83
-- Версия PHP: 5.2.10-1ubuntu1
 
30,7 → 30,7
`id` int(2) NOT NULL auto_increment,
`category` varchar(15) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
 
--
-- Дамп данных таблицы `categories`
39,7 → 39,8
INSERT INTO `categories` (`id`, `category`) VALUES
(1, 'file'),
(2, 'repo'),
(3, 'info');
(3, 'info'),
(4, 'misc');
 
-- --------------------------------------------------------
 
79,7 → 80,7
`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=4 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
 
--
-- Дамп данных таблицы `members`
87,8 → 88,13
 
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);
(2, 'firstleon', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0),
(4, 'mistiman', './img/avatar/mistiman.png', '', 0),
(5, 'IK', './img/avatar/ik.jpg', '', 0),
(6, 'Aduchi Mergen', '', '', 0),
(7, 'SP|Scream', './img/avatar/spscream.png', '', 0),
(8, 'Yamah', './img/avatar/yamah.png', '', 0);
 
-- --------------------------------------------------------
 
131,7 → 137,7
`link_res` varchar(50) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `category_id` (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
 
--
-- Дамп данных таблицы `resources`
146,7 → 152,9
(6, 2, 'mandriva', './img/logo/mandrake.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2005', 'http://mandriva.nix-files.org.ru'),
(7, 2, 'arch', './img/logo/archlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1884', 'http://arch.nix-files.org.ru'),
(8, 2, 'alt', './img/logo/altlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2009', 'http://alt.nix-files.org.ru'),
(9, 2, 'freebsd', './img/logo/freebsd.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1990', 'http://freebsd.nix-files.org.ru');
(9, 2, 'freebsd', './img/logo/freebsd.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1990', 'http://freebsd.nix-files.org.ru'),
(10, 4, 'www', './img/logo/www.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1858', 'http://www.nix-files.org.ru'),
(11, 4, 'fail', './img/logo/fail.png', '', 'http://fail.nix-files.org.ru');
 
-- --------------------------------------------------------
 
166,7 → 174,7
KEY `member_id` (`member_id`),
KEY `network_id` (`network_id`),
KEY `resource_id_2` (`resource_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
 
--
-- Дамп данных таблицы `res_mem_rank`
175,7 → 183,41
INSERT INTO `res_mem_rank` (`id`, `resource_id`, `network_id`, `member_id`, `rank_id`) VALUES
(1, 1, 2, 3, 1),
(2, 1, 3, 3, 1),
(3, 1, 5, 2, 0);
(3, 1, 5, 4, 0),
(4, 2, 2, 2, 0),
(5, 2, 3, 3, 0),
(6, 2, 5, 2, 0),
(7, 3, 1, 5, 0),
(8, 3, 2, 5, 0),
(9, 3, 3, 5, 0),
(15, 5, 2, 4, 0),
(11, 4, 1, 5, 0),
(12, 4, 2, 5, 0),
(13, 4, 3, 5, 0),
(14, 4, 5, 5, 0),
(16, 3, 5, 5, 0),
(17, 5, 3, 4, 0),
(18, 5, 5, 4, 0),
(19, 6, 2, 8, 0),
(20, 6, 3, 8, 0),
(21, 6, 5, 8, 0),
(22, 7, 2, 4, 0),
(23, 7, 3, 4, 0),
(24, 7, 5, 4, 0),
(25, 8, 2, 4, 0),
(26, 8, 3, 4, 0),
(27, 8, 5, 4, 0),
(28, 9, 2, 4, 0),
(29, 9, 3, 4, 0),
(30, 9, 5, 2, 0),
(31, 10, 1, 1, 0),
(32, 10, 2, 1, 0),
(33, 10, 3, 1, 0),
(34, 10, 5, 1, 0),
(35, 11, 1, 1, 0),
(36, 11, 2, 1, 0),
(37, 11, 3, 1, 0),
(38, 11, 5, 1, 0);
 
-- --------------------------------------------------------
 
191,7 → 233,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=32 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=37 ;
 
--
-- Дамп данных таблицы `res_net_stat`
228,4 → 270,9
(28, 8, 5, 3),
(29, 9, 2, 1),
(30, 9, 3, 1),
(31, 9, 5, 2);
(31, 9, 5, 2),
(32, 10, 1, 1),
(33, 10, 2, 1),
(34, 10, 3, 2),
(35, 10, 5, 3),
(36, 11, 1, 1);