Редакция 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`
|