Редакция 79 | Редакция 84 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 79 | Редакция 83 | ||
|---|---|---|---|
| Строка 137... | Строка 137... | ||
| 137 | 137 | ||
| 138 | DROP TABLE IF EXISTS `members`; |
138 | DROP TABLE IF EXISTS `members`; |
| 139 | CREATE TABLE IF NOT EXISTS `members` ( |
139 | CREATE TABLE IF NOT EXISTS `members` ( |
| 140 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
140 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
| 141 | `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
141 | `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| - | 142 | `fio` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 142 | `avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
143 | `avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| 143 | `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
144 | `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| 144 | `icq` INT(15) NOT NULL, |
145 | `icq` INT(15) NOT NULL, |
| 145 | PRIMARY KEY (`id`) |
146 | PRIMARY KEY (`id`) |
| 146 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ; |
147 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ; |
| Строка 148... | Строка 149... | ||
| 148 | --
|
149 | --
|
| 149 | -- Дамп данных таблицы `members`
|
150 | -- Дамп данных таблицы `members`
|
| 150 | --
|
151 | --
|
| 151 | 152 | ||
| 152 | INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES |
153 | INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES |
| 153 | (1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0), |
154 | (1, 'Diffor', 'Функ Дмитрий','./img/avatar/diffor.jpg', 'diffor@jabber.ru', 0), |
| 154 | (2, 'firstleon', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0), |
155 | (2, 'firstleon', '', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0), |
| 155 | (3, 'SlipKnoT8', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0), |
156 | (3, 'SlipKnoT8', '', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0), |
| 156 | (4, 'mistiman', './img/avatar/mistiman.png', 'mistiman@jabber.ru', 0), |
157 | (4, 'mistiman', '', './img/avatar/mistiman.png', 'mistiman@jabber.ru', 0), |
| 157 | (5, 'IK', './img/avatar/ik.jpg', 'ik00@jabber.ru', 0), |
158 | (5, 'IK', '', './img/avatar/ik.jpg', 'ik00@jabber.ru', 0), |
| 158 | (7, 'SP|Scream', './img/avatar/spscream.png', 'xelnag@jabber.ru', 0), |
159 | (7, 'SP|Scream', '', './img/avatar/spscream.png', 'xelnag@jabber.ru', 0), |
| 159 | (8, 'Yamah', './img/avatar/yamah.png', '—', 0); |
160 | (8, 'Yamah', '', './img/avatar/yamah.png', '—', 0); |
| 160 | 161 | ||
| 161 | -- --------------------------------------------------------
|
162 | -- --------------------------------------------------------
|
| 162 | 163 | ||
| 163 | --
|
164 | --
|
| 164 | -- Структура таблицы `netcats`
|
165 | -- Структура таблицы `netcats`
|