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

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

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

/trunk/db/nix-files.sql
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,14 → 22,42
-- --------------------------------------------------------
 
--
-- Структура таблицы `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,
PRIMARY KEY (`id`)
`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,12 → 78,12
 
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,
PRIMARY KEY (`id`),
`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,12 → 102,12
 
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`)
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,10 → 131,10
 
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,
PRIMARY KEY (`id`)
`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,13 → 156,13
 
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,
PRIMARY KEY (`id`),
`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,12 → 191,12
 
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,
`rank_id` int(2) NOT NULL,
PRIMARY KEY (`id`),
PRIMARY KEY (`id`),
KEY `resource_id` (`rank_id`),
KEY `member_id` (`member_id`),
KEY `network_id` (`network_id`),
227,11 → 254,11
 
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,
PRIMARY KEY (`id`),
PRIMARY KEY (`id`),
KEY `resource_id` (`resource_id`,`network_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=37 ;