Редакция 4 | Редакция 7 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 4 | Редакция 5 | ||
---|---|---|---|
Строка 1... | Строка 1... | ||
1 | 1 | -- phpMyAdmin SQL Dump
|
|
2 | 2 | -- version 3.2.0.1deb1
|
|
3 | 3 | -- http://www.phpmyadmin.net
|
|
4 | 4 | --
|
|
5 | 5 | -- Хост: localhost
|
|
6 | 6 | -- Время создания: Авг 03 2009 г., 22:02
|
|
7 | 7 | -- Версия сервера: 5.0.83
|
|
8 | 8 | -- Версия PHP: 5.2.10-1ubuntu1
|
|
- | 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 | ||
9 | 18 | --
|
|
10 | 19 | -- База данных: `nix-files`
|
|
11 | 20 | --
|
|
12 | 21 | ||
13 | 22 | -- --------------------------------------------------------
|
|
14 | 23 | ||
15 | 24 | --
|
|
16 | 25 | -- Структура таблицы `categories`
|
|
17 | 26 | --
|
|
18 | 27 | ||
19 | 28 | DROP TABLE IF EXISTS `categories`; |
|
20 | 29 | CREATE TABLE IF NOT EXISTS `categories` ( |
|
21 | 30 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
22 | 31 | `category` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, |
|
23 | 32 | PRIMARY KEY (`id`) |
|
24 | 33 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; |
|
25 | 34 | ||
26 | 35 | --
|
|
27 | 36 | -- Дамп данных таблицы `categories`
|
|
28 | 37 | --
|
|
29 | 38 | ||
30 | 39 | INSERT INTO `categories` (`id`, `category`) VALUES |
|
31 | 40 | (1, 'file'), |
|
32 | 41 | (2, 'repo'), |
|
33 | 42 | (3, 'info'); |
|
34 | 43 | ||
35 | 44 | -- --------------------------------------------------------
|
|
36 | 45 | ||
37 | 46 | --
|
|
- | 47 | -- Структура таблицы `details`
|
|
- | 48 | --
|
|
- | 49 | ||
- | 50 | DROP TABLE IF EXISTS `details`; |
|
- | 51 | CREATE TABLE IF NOT EXISTS `details` ( |
|
- | 52 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
- | 53 | `title` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
- | 54 | `description` text COLLATE utf8_unicode_ci NOT NULL, |
|
- | 55 | `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
- | 56 | `talklink` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
- | 57 | PRIMARY KEY (`id`), |
|
- | 58 | KEY `resource_id` (`title`) |
|
- | 59 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; |
|
- | 60 | ||
- | 61 | --
|
|
- | 62 | -- Дамп данных таблицы `details`
|
|
- | 63 | --
|
|
- | 64 | ||
- | 65 | INSERT INTO `details` (`id`, `title`, `description`, `link`, `talklink`) VALUES |
|
- | 66 | (1, 'ftp.niX-FILES', 'Файлопомойко', 'ftp://ftp.nix-files.org.ru', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846'); |
|
- | 67 | ||
- | 68 | -- --------------------------------------------------------
|
|
- | 69 | ||
- | 70 | --
|
|
38 | 71 | -- Структура таблицы `members`
|
|
39 | 72 | --
|
|
40 | 73 | ||
41 | 74 | DROP TABLE IF EXISTS `members`; |
|
42 | 75 | CREATE TABLE IF NOT EXISTS `members` ( |
|
43 | 76 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
44 | 77 | `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
Строка 46... | Строка 79... | ||
46 | 79 | `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
47 | 80 | `icq` INT(15) NOT NULL, |
|
48 | 81 | PRIMARY KEY (`id`) |
|
49 | 82 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; |
|
50 | 83 | ||
51 | 84 | --
|
|
52 | 85 | -- Дамп данных таблицы `members`
|
|
53 | 86 | --
|
|
54 | 87 | ||
55 | 88 | INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES |
|
56 | 89 | (1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0), |
|
57 | 90 | (2, 'firstleon', './img/avatar/firstleon.jpg', '—', 0), |
|
58 | 91 | (3, 'SlipKnoT8', './img/avatar/slipknot8.gif', '—', 0); |
|
59 | 92 | ||
60 | 93 | -- --------------------------------------------------------
|
|
61 | 94 | ||
62 | 95 | --
|
|
63 | 96 | -- Структура таблицы `networks`
|
|
64 | 97 | --
|
|
65 | 98 | ||
66 | 99 | DROP TABLE IF EXISTS `networks`; |
|
67 | 100 | CREATE TABLE IF NOT EXISTS `networks` ( |
|
68 | 101 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
69 | 102 | `network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, |
|
70 | 103 | `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
71 | 104 | PRIMARY KEY < |
|
72 | 105 | ||
73 | 106 | ||
74 | 107 | ||
75 | 108 | ||
76 | 109 | ||
77 | 110 | ||
78 | 111 | ||
79 | 112 | ||
80 | 113 | ||
81 | 114 | ||
82 | 115 | ||
83 | 116 | ||
84 | 117 | ||
85 | 118 | ||
86 | 119 | ||
87 | 120 | ||
- | 121 | ||
- | 122 | ||
- | 123 | ||
- | 124 | ||
- | 125 | ||
- | 126 | ||
- | 127 | ||
- | 128 | ||
- | 129 | ||
- | 130 | ||
- | 131 | ||
- | 132 | ||
- | 133 | ||
- | 134 | ||
- | 135 | ||
- | 136 | ||
- | 137 | ||
- | 138 | ||
- | 139 | ||
- | 140 | ||
- | 141 | ||
- | 142 | ||
- | 143 | ||
- | 144 | ||
- | 145 | ||
- | 146 | ||
- | 147 | ||
- | 148 | ||
- | 149 | ||
- | 150 | ||
- | 151 | ||
- | 152 | ||
- | 153 | ||
88 | 154 | ||
89 | 155 | ||
90 | 156 | ||
91 | 157 | ||
92 | 158 | ||
93 | 159 | ||
- | 160 | ||
- | 161 | ||
94 | 162 | ||
95 | - | ||
96 | 163 | ||
97 | 164 | ||
98 | 165 | ||
99 | 166 | ||
- | 167 | ||
- | 168 | ||
100 | 169 | ||
101 | 170 | ||
102 | 171 | ||
103 | 172 | ||
104 | 173 | ||
105 | 174 | ||
106 | 175 | ||
107 | 176 | ||
108 | 177 | ||
- | 178 | ||
109 | 179 | ||
110 | 180 | ||
111 | 181 | ||
112 | 182 | ||
113 | 183 | ||
114 | 184 | ||
115 | 185 | ||
116 | 186 | ||
117 | 187 | ||
118 | 188 | ||
119 | 189 | ||
Строка 121... | Строка 191... | ||
121 | 191 | ||
122 | 192 | ||
123 | 193 | ||
124 | 194 | ||
125 | 195 | ||
126 | 196 | ||
127 | 197 | ||
128 | 198 | ||
129 | 199 | ||
130 | 200 | ||
131 | 201 | ||
132 | 202 | ||
133 | 203 | ||
134 | 204 | ||
135 | 205 | ||
Строка 157... | Строка 227... | ||
157 | 227 | ||
158 | 228 | ||
159 | 229 | ||
160 | 230 | ||
161 | 231 | ||
162 | - | ||
163 | - | ||
164 | - | ||
165 | - | ||
166 | - | ||
167 | - | ||
168 | - | ||
169 | - | ||
170 | - | ||
171 | - | ||
172 | - | ||
173 | - | ||
174 | - | ||
175 | - | ||
176 | - | ||
177 | - | ||
178 | - | ||
179 | - | ||
180 | - | ||
181 | - | ||
182 | - | ||
183 | - | ||
184 | - | ||
185 | - | ||
186 | - | ||
187 | - | ||
188 | - | ||
189 | - | ||
190 | - | ||
191 | - | ||
192 | - | ||
193 | - | ||
194 | - |