1,11 → 1,11 |
-- phpMyAdmin SQL Dump |
-- version 3.2.0.1deb1 |
-- version 3.2.1deb1 |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
-- Время создания: Авг 03 2009 г., 23:24 |
-- Версия сервера: 5.0.83 |
-- Версия PHP: 5.2.10-1ubuntu1 |
-- Время создания: Авг 31 2009 г., 23:35 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.10-2ubuntu2 |
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|
22,13 → 22,41 |
-- -------------------------------------------------------- |
|
-- |
-- Структура таблицы `apt_mirrors` |
-- |
|
DROP TABLE IF EXISTS `apt_mirrors`; |
CREATE TABLE IF NOT EXISTS `apt_mirrors` ( |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`src_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
`src_url` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
`desk` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ; |
|
-- |
-- Дамп данных таблицы `apt_mirrors` |
-- |
|
INSERT INTO `apt_mirrors` (`id`, `src_name`, `src_url`, `desk`) VALUES |
(1, 'debian', 'ftp://ftp.us.debian.org/debian', ''), |
(2, 'debian-security', 'ftp://security.debian.org/debian-security', ''), |
(3, 'debian-multimedia', 'http://www.debian-multimedia.org', ''), |
(4, 'ubuntu', 'http://archive.ubuntu.com/ubuntu', ''), |
(5, 'ubuntu-security', 'http://security.ubuntu.com/ubuntu', ''), |
(6, 'ubuntu-canonical', 'http://archive.canonical.com', ''), |
(7, 'medibuntu', 'http://packages.medibuntu.org/', ''); |
|
-- -------------------------------------------------------- |
|
-- |
-- Структура таблицы `categories` |
-- |
|
DROP TABLE IF EXISTS `categories`; |
CREATE TABLE IF NOT EXISTS `categories` ( |
`id` int(2) NOT NULL auto_increment, |
`category` varchar(15) collate utf8_unicode_ci NOT NULL, |
`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=5 ; |
|
50,11 → 78,11 |
|
DROP TABLE IF EXISTS `details`; |
CREATE TABLE IF NOT EXISTS `details` ( |
`id` int(2) NOT NULL auto_increment, |
`title` varchar(50) collate utf8_unicode_ci NOT NULL, |
`description` text collate utf8_unicode_ci NOT NULL, |
`link` varchar(50) collate utf8_unicode_ci NOT NULL, |
`talklink` varchar(50) collate utf8_unicode_ci NOT NULL, |
`id` int(2) NOT NULL AUTO_INCREMENT, |
`title` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
`description` text COLLATE utf8_unicode_ci NOT NULL, |
`link` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
`talklink` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`id`), |
KEY `resource_id` (`title`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; |
74,10 → 102,10 |
|
DROP TABLE IF EXISTS `members`; |
CREATE TABLE IF NOT EXISTS `members` ( |
`id` int(2) NOT NULL auto_increment, |
`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, |
`id` int(2) NOT NULL AUTO_INCREMENT, |
`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=9 ; |
92,7 → 120,6 |
(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); |
|
104,9 → 131,9 |
|
DROP TABLE IF EXISTS `networks`; |
CREATE TABLE IF NOT EXISTS `networks` ( |
`id` int(2) NOT NULL auto_increment, |
`network` varchar(15) collate utf8_unicode_ci NOT NULL, |
`link` varchar(50) collate utf8_unicode_ci NOT NULL, |
`id` int(2) NOT NULL AUTO_INCREMENT, |
`network` varchar(15) COLLATE utf8_unicode_ci NOT NULL, |
`link` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; |
|
129,12 → 156,12 |
|
DROP TABLE IF EXISTS `resources`; |
CREATE TABLE IF NOT EXISTS `resources` ( |
`id` int(2) NOT NULL auto_increment, |
`id` int(2) NOT NULL AUTO_INCREMENT, |
`category_id` int(2) NOT NULL, |
`resource` varchar(15) collate utf8_unicode_ci NOT NULL, |
`picture` varchar(50) collate utf8_unicode_ci NOT NULL, |
`link_talk` varchar(50) collate utf8_unicode_ci NOT NULL, |
`link_res` varchar(50) collate utf8_unicode_ci NOT NULL, |
`resource` varchar(15) COLLATE utf8_unicode_ci NOT NULL, |
`picture` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
`link_talk` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
`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=12 ; |
164,7 → 191,7 |
|
DROP TABLE IF EXISTS `res_mem_rank`; |
CREATE TABLE IF NOT EXISTS `res_mem_rank` ( |
`id` int(5) NOT NULL auto_increment, |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`resource_id` int(2) NOT NULL, |
`network_id` int(2) NOT NULL, |
`member_id` int(2) NOT NULL, |
227,7 → 254,7 |
|
DROP TABLE IF EXISTS `res_net_stat`; |
CREATE TABLE IF NOT EXISTS `res_net_stat` ( |
`id` int(5) NOT NULL auto_increment, |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`resource_id` int(2) NOT NULL, |
`network_id` int(2) NOT NULL, |
`state_id` int(2) NOT NULL, |