Редакция 11 | Редакция 14 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 11 | Редакция 12 | ||
|---|---|---|---|
| Строка 1... | Строка 1... | ||
| 1 | -- phpMyAdmin SQL Dump
|
1 | -- phpMyAdmin SQL Dump
|
| 2 | -- version 3.2.1deb1
|
2 | -- version 2.11.8.1deb5+lenny1
|
| 3 | -- http://www.phpmyadmin.net
|
3 | -- http://www.phpmyadmin.net
|
| 4 | --
|
4 | --
|
| 5 | -- Хост: localhost
|
5 | -- Хост: localhost
|
| 6 | -- Время создания: Авг 31 2009 г., 23:53
|
6 | -- Время создания: Сен 08 2009 г., 14:49
|
| 7 | -- Версия сервера: 5.1.37
|
7 | -- Версия сервера: 5.0.51
|
| 8 | -- Версия PHP: 5.2.10-2ubuntu2
|
8 | -- Версия PHP: 5.2.6-1+lenny3
|
| 9 | 9 | ||
| 10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| 11 | 11 | ||
| 12 | 12 | ||
| 13 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
13 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
| Строка 25... | Строка 25... | ||
| 25 | -- Структура таблицы `apt_mirrors`
|
25 | -- Структура таблицы `apt_mirrors`
|
| 26 | --
|
26 | --
|
| 27 | 27 | ||
| 28 | DROP TABLE IF EXISTS `apt_mirrors`; |
28 | DROP TABLE IF EXISTS `apt_mirrors`; |
| 29 | CREATE TABLE IF NOT EXISTS `apt_mirrors` ( |
29 | CREATE TABLE IF NOT EXISTS `apt_mirrors` ( |
| 30 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
30 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
| 31 | `src_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
31 | `src_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| 32 | `src_url` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
32 | `src_url` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| 33 | `desk` 33 |
`desk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 34 | 34 | PRIMARY KEY (`id`) |
|
| 35 | 35 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ; |
|
| 36 | 36 | ||
| 37 | 37 | --
|
|
| 38 | 38 | -- Дамп данных таблицы `apt_mirrors`
|
|
| 39 | 39 | --
|
|
| Строка 62... | Строка 62... | ||
| 62 | 62 | -- Структура таблицы `categories`
|
|
| 63 | 63 | --
|
|
| 64 | 64 | ||
| 65 | 65 | DROP TABLE IF EXISTS `categories`; |
|
| 66 | 66 | CREATE TABLE IF NOT EXISTS `categories` ( |
|
| 67 | 67 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
| 68 | 68 | `category` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, |
|
| 69 | 69 | PRIMARY KEY (`id`) |
|
| 70 | 70 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ; |
|
| 71 | 71 | ||
| 72 | 72 | --
|
|
| 73 | 73 | -- Дамп данных таблицы `categories`
|
|
| 74 | 74 | --
|
|
| Строка 85... | Строка 85... | ||
| 85 | 85 | -- Структура таблицы `details`
|
|
| 86 | 86 | --
|
|
| 87 | 87 | ||
| 88 | 88 | DROP TABLE IF EXISTS `details`; |
|
| 89 | 89 | CREATE TABLE IF NOT EXISTS `details` ( |
|
| 90 | 90 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
| 91 | 91 | `title` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 92 | 92 | `description` text COLLATE utf8_unicode_ci NOT NULL, |
|
| 93 | 93 | `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 94 | 94 | `talklink` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 95 | 95 | PRIMARY KEY (`id`), |
|
| 96 | 96 | KEY `resource_id` (`title`) |
|
| 97 | 97 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; |
|
| 98 | 98 | ||
| 99 | 99 | --
|
|
| 100 | 100 | -- Дамп данных таблицы `details`
|
|
| Строка 109... | Строка 109... | ||
| 109 | 109 | -- Структура таблицы `members`
|
|
| 110 | 110 | --
|
|
| 111 | 111 | ||
| 112 | 112 | DROP TABLE IF EXISTS `members`; |
|
| 113 | 113 | CREATE TABLE IF NOT EXISTS `members` ( |
|
| 114 | 114 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
| 115 | 115 | `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 116 | 116 | `avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 117 | 117 | `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 118 | 118 | `icq` INT(15) NOT NULL, |
|
| 119 | 119 | PRIMARY KEY (`id`) |
|
| 120 | 120 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ; |
|
| 121 | 121 | ||
| 122 | 122 | --
|
|
| 123 | 123 | -- Дамп данных таблицы `members`
|
|
| 124 | 124 | --
|
|
| Строка 138... | Строка 138... | ||
| 138 | 138 | -- Структура таблицы `networks`
|
|
| 139 | 139 | --
|
|
| 140 | 140 | ||
| 141 | 141 | DROP TABLE IF EXISTS `networks`; |
|
| 142 | 142 | CREATE TABLE IF NOT EXISTS `networks` ( |
|
| 143 | 143 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
| 144 | 144 | `network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, |
|
| 145 | 145 | `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 146 | 146 | PRIMARY KEY (`id`) |
|
| 147 | 147 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; |
|
| 148 | 148 | ||
| 149 | 149 | --
|
|
| 150 | 150 | -- Дамп данных таблицы `networks`
|
|
| 151 | 151 | --
|
|
| Строка 163... | Строка 163... | ||
| 163 | 163 | -- Структура таблицы `resources`
|
|
| 164 | 164 | --
|
|
| 165 | 165 | ||
| 166 | 166 | DROP TABLE IF EXISTS `resources`; |
|
| 167 | 167 | CREATE TABLE IF NOT EXISTS `resources` ( |
|
| 168 | 168 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
|
| 169 | 169 | `category_id` INT(2) NOT NULL, |
|
| 170 | 170 | `resource` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, |
|
| 171 | 171 | `picture` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 172 | 172 | `link_talk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 173 | 173 | `link_res` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 174 | 174 | PRIMARY KEY (`id`), |
|
| 175 | 175 | KEY `category_id` (`category_id`) |
|
| 176 | 176 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ; |
|
| 177 | 177 | ||
| 178 | 178 | --
|
|
| 179 | 179 | -- Дамп данных таблицы `resources`
|
|
| Строка 198... | Строка 198... | ||
| 198 | 198 | ||
| 199 | 199 | ||
| 200 | 200 | ||
| 201 | 201 | ||
| 202 | 202 | ||
| 203 | 203 | ||
| 204 | 204 | ||
| 205 | 205 | ||
| 206 | 206 | ||
| 207 | 207 | ||
| 208 | 208 | ||
| 209 | 209 | ||
| 210 | 210 | ||
| 211 | 211 | ||
| 212 | 212 | ||
| 213 | 213 | ||
| - | 214 | ||
| - | 215 | ||
| - | 216 | ||
| - | 217 | ||
| - | 218 | ||
| - | 219 | ||
| - | 220 | ||
| - | 221 | ||
| - | 222 | ||
| - | 223 | ||
| - | 224 | ||
| - | 225 | ||
| - | 226 | ||
| - | 227 | ||
| - | 228 | ||
| - | 229 | ||
| - | 230 | ||
| - | 231 | ||
| - | 232 | ||
| - | 233 | ||
| - | 234 | ||
| - | 235 | ||
| - | 236 | ||
| - | 237 | ||
| - | 238 | ||
| - | 239 | ||
| - | 240 | ||
| - | 241 | ||
| - | 242 | ||
| - | 243 | ||
| - | 244 | ||
| - | 245 | ||
| - | 246 | ||
| - | 247 | ||
| - | 248 | ||
| - | 249 | ||
| - | 250 | ||
| - | 251 | ||
| - | 252 | ||
| - | 253 | ||
| - | 254 | ||
| - | 255 | ||
| - | 256 | ||
| - | 257 | ||
| - | 258 | ||
| - | 259 | ||
| - | 260 | ||
| - | 261 | ||
| - | 262 | ||
| - | 263 | ||
| - | 264 | ||
| - | 265 | ||
| - | 266 | ||
| - | 267 | ||
| - | 268 | ||
| - | 269 | ||
| - | 270 | ||
| - | 271 | ||
| - | 272 | ||
| - | 273 | ||
| - | 274 | ||
| - | 275 | ||
| - | 276 | ||