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

Редакция

Редакция 18 | Редакция 20 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS

Редакция Автор № строки Строка
2 diffor 1 
-- phpMyAdmin SQL Dump
17 diffor 2 
-- version 3.2.1deb1
2 diffor 3 
-- http://www.phpmyadmin.net
5 diffor 4 
--
2 diffor 5 
-- Хост: localhost
19 diffor 6 
-- Время создания: Сен 27 2009 г., 12:41
17 diffor 7 
-- Версия сервера: 5.1.37
8 
-- Версия PHP: 5.2.10-2ubuntu4
5 diffor 9 
 
10 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11 
 
12 
 
13 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14 
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15 
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16 
/*!40101 SET NAMES utf8 */;
17 
 
18 
--
2 diffor 19 
-- База данных: `nix-files`
5 diffor 20 
--
2 diffor 21 
 
22 
-- --------------------------------------------------------
23 
 
5 diffor 24 
--
10 diffor 25 
-- Структура таблицы `apt_mirrors`
26 
--
27 
 
28 
DROP TABLE IF EXISTS `apt_mirrors`;
29 
CREATE TABLE IF NOT EXISTS `apt_mirrors` (
17 diffor 30 
  `id` INT(5) NOT NULL AUTO_INCREMENT,
31 
  `src_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
32 
  `src_url` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
18 diffor 33 
  `description` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
17 diffor 34 
  PRIMARY KEY (`id`)
11 diffor 35 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;
10 diffor 36 
 
37 
--
38 
-- Дамп данных таблицы `apt_mirrors`
39 
--
40 
 
18 diffor 41 
INSERT INTO `apt_mirrors` (`id`, `src_name`, `src_url`, `description`) VALUES
42 
(1, 'debian', 'ftp://ftp.us.debian.org/debian', 'Официальный репозиторий Debain'),
43 
(2, 'debian-security', 'ftp://security.debian.org/debian-security', 'Официальный репозиторий обновлений безопасности Debian'),
44 
(3, 'debian-multimedia', 'http://www.debian-multimedia.org', 'Неофициальные репозиторий мультимедийных пакетов Debian'),
45 
(4, 'ubuntu', 'http://archive.ubuntu.com/ubuntu', 'Официальный репозиторий Ubuntu'),
46 
(5, 'ubuntu-security', 'http://security.ubuntu.com/ubuntu', 'Официальный репозиторий обновлений безопасности Ubuntu'),
10 diffor 47 
(6, 'ubuntu-canonical', 'http://archive.canonical.com', ''),
11 diffor 48 
(7, 'medibuntu', 'http://packages.medibuntu.org/', ''),
49 
(8, 'infralinux', 'http://archive.infralinux.org/infralinux/', ''),
50 
(9, '2gis', 'http://packages.redsolution.ru/2gis', ''),
51 
(10, 'opera', 'http://deb.opera.com/opera/', ''),
52 
(11, 'virtualbox', 'http://download.virtualbox.org/virtualbox/debian', ''),
53 
(12, 'opera-beta', 'http://deb.opera.com/opera-beta/', ''),
54 
(13, 'playonlinux', '', ''),
55 
(14, 'freenx', '', ''),
56 
(15, 'wesnoth', '', ''),
57 
(16, 'xneur', '', '');
10 diffor 58 
 
59 
-- --------------------------------------------------------
60 
 
61 
--
2 diffor 62 
-- Структура таблицы `categories`
5 diffor 63 
--
2 diffor 64 
 
3 diffor 65 
DROP TABLE IF EXISTS `categories`;
2 diffor 66 
CREATE TABLE IF NOT EXISTS `categories` (
17 diffor 67 
  `id` INT(2) NOT NULL AUTO_INCREMENT,
68 
  `category` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
69 
  PRIMARY KEY (`id`)
7 diffor 70 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
2 diffor 71 
 
5 diffor 72 
--
2 diffor 73 
-- Дамп данных таблицы `categories`
5 diffor 74 
--
2 diffor 75 
 
5 diffor 76 
INSERT INTO `categories` (`id`, `category`) VALUES
2 diffor 77 
(1, 'file'),
78 
(2, 'repo'),
7 diffor 79 
(3, 'info'),
80 
(4, 'misc');
2 diffor 81 
 
82 
-- --------------------------------------------------------
83 
 
5 diffor 84 
--
2 diffor 85 
-- Структура таблицы `members`
5 diffor 86 
--
2 diffor 87 
 
3 diffor 88 
DROP TABLE IF EXISTS `members`;
2 diffor 89 
CREATE TABLE IF NOT EXISTS `members` (
17 diffor 90 
  `id` INT(2) NOT NULL AUTO_INCREMENT,
91 
  `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
92 
  `avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
93 
  `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
4 diffor 94 
  `icq` INT(15) NOT NULL,
17 diffor 95 
  PRIMARY KEY (`id`)
7 diffor 96 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
2 diffor 97 
 
5 diffor 98 
--
2 diffor 99 
-- Дамп данных таблицы `members`
5 diffor 100 
--
2 diffor 101 
 
5 diffor 102 
INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES
4 diffor 103 
(1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0),
7 diffor 104 
(2, 'firstleon', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
105 
(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0),
106 
(4, 'mistiman', './img/avatar/mistiman.png', '', 0),
107 
(5, 'IK', './img/avatar/ik.jpg', '', 0),
108 
(7, 'SP|Scream', './img/avatar/spscream.png', '', 0),
109 
(8, 'Yamah', './img/avatar/yamah.png', '', 0);
2 diffor 110 
 
111 
-- --------------------------------------------------------
112 
 
5 diffor 113 
--
2 diffor 114 
-- Структура таблицы `networks`
5 diffor 115 
--
2 diffor 116 
 
3 diffor 117 
DROP TABLE IF EXISTS `networks`;
2 diffor 118 
CREATE TABLE IF NOT EXISTS `networks` (
17 diffor 119 
  `id` INT(2) NOT NULL AUTO_INCREMENT,
120 
  `network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
121 
  `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
122