Редакция 161 | Редакция 163 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
| Редакция | Автор | № строки | Строка |
|---|---|---|---|
| 2 | diffor | 1 | PRIMARY KEY (`id`), |
| 49 | diffor | 2 | KEY `network_id` (`network_id`) |
| 2 | diffor | 3 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; |
| 5 | diffor | 4 | |
| 2 | diffor | 5 | -- |
| 58 | diffor | 6 | -- Дамп данных таблицы `ips` |
| 36 | diffor | 7 | -- |
| 41 | diffor | 8 | |
| 5 | diffor | 9 | |
| 10 | (1, '83.246.143.111', 2, 1), |
||
| 11 | |||
| 12 | |||
| 13 | (4, '172.16.178.102', 3, 3), |
||
| 14 | (5, '78.110.54.204', 1, 4); |
||
| 15 | |||
| 16 | -- -------------------------------------------------------- |
||
| 17 | |||
| 18 | -- |
||
| 2 | diffor | 19 | -- Структура таблицы `members` |
| 5 | diffor | 20 | -- |
| 2 | diffor | 21 | |
| 22 | DROP TABLE IF EXISTS `members`; |
||
| 23 | |||
| 5 | diffor | 24 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
| 10 | diffor | 25 | `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| 26 | `fio` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
||
| 27 | |||
| 38 | diffor | 28 | `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| 10 | diffor | 29 | `icq` INT(15) NOT NULL, |
| 36 | diffor | 30 | PRIMARY KEY (`id`) |
| 31 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ; |
||
| 32 | |||
| 33 | -- |
||
| 34 | -- Дамп данных таблицы `members` |
||
| 40 | diffor | 35 | -- |
| 10 | diffor | 36 | |
| 37 | INSERT INTO `members` (`id`, `nick`, `fio`, `avatar`, `jabber`, `icq`) VALUES |
||
| 38 | (1, 'Diffor', 'Функ Дмитрий', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0), |
||
| 39 | (2, 'firstleon', 'Малютин Владимир', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0), |
||
| 40 | |||
| 18 | diffor | 41 | (4, 'mistiman', 'Кем Станислав', './img/avatar/mistiman.png', 'mistiman@jabber.ru', 0), |
| 39 | diffor | 42 | (5, 'IK', 'Климентьев Илья', './img/avatar/ik.jpg', 'ik00@jabber.ru', 0), |
| 43 | (7, 'SP|Scream', '', './img/avatar/spscream.png', 'xelnag@jabber.ru', 0), |
||
| 44 | (8, 'Yamah', '', './img/avatar/yamah.png', '—', 0); |
||
| 45 | |||
| 46 | -- -------------------------------------------------------- |
||
| 47 | |||
| 48 | -- |
||
| 49 | -- Структура таблицы `netcats` |
||
| 50 | -- |
||
| 51 | |||
| 52 | DROP TABLE IF EXISTS `netcats`; |
||
| 53 | CREATE TABLE IF NOT EXISTS `netcats` ( |
||
| 54 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
||
| 40 | diffor | 55 | `netcat` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, |
| 56 | PRIMARY KEY (`id`) |
||
| 57 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ; |
||
| 58 | |||
| 10 | diffor | 59 | |
| 60 | -- Дамп данных таблицы `netcats` |
||
| 61 | |||
| 62 | |||
| 2 | diffor | 63 | INSERT INTO `netcats` (`id`, `netcat`) VALUES |
| 5 | diffor | 64 | (1, 'Глоб'), |
| 2 | diffor | 65 | |
| 38 | diffor | 66 | (3, 'Университеты'), |
| 2 | diffor | 67 | (4, 'Пиринг'); |
| 36 | diffor | 68 | |
| 69 | -- -------------------------------------------------------- |
||
| 70 | |||
| 7 | diffor | 71 | -- |
| 2 | diffor | 72 | |
| 5 | diffor | 73 | -- |
| 2 | diffor | 74 | |
| 5 | diffor | 75 | DROP TABLE IF EXISTS `networks`; |
| 2 | diffor | 76 | |
| 5 | diffor | 77 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
| 2 | diffor | 78 | `netcat_id` INT(2) NOT NULL, |
| 79 | `network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, |
||
| 7 | diffor | 80 | `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| 81 | PRIMARY KEY (`id`), |
||
| 2 | diffor | 82 | |
| 83 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ; |
||
| 84 | |||
| 5 | diffor | 85 | -- |
| 31 | diffor | 86 | -- Дамп данных таблицы `networks` |
| 87 | -- |
||
| 88 | |||
| 38 | diffor | 89 | INSERT INTO `networks` (`id`, `netcat_id`, `network`, `link`) VALUES |
| 31 | diffor | 90 | (1, 1, 'Глоб', ''), |
| 36 | diffor | 91 | (2, 2, 'Интелби', 'http://www.intelbi.ru/'), |
| 92 | (3, 2, 'Интелека', 'http://www.inteleca.ru/'), |
||
| 93 | (4, 3, 'АГУ', 'http://www.asu.ru/'), |
||
| 94 | (5, 3, 'АлтГПА', 'http://www.uni-altai.ru/'), |
||
| 95 | (6, 3, 'АлтГТУ', 'http://www.altstu.ru/'), |
||
| 96 | (7, 4, 'Webstream', 'http://www.wstream.ru/'), |
||
| 31 | diffor | 97 | (8, 4, 'Дианет', 'http://www.dianet.info/'), |
| 98 | (9, 4, 'Диалог', 'http://www.dialog-it.ru'), |
||
| 99 | |||
| 100 | (11, 4, 'Рубцовск', 'http://www.rubtsovsk.ru/'), |
||
| 101 | (12, 4, 'Алтайгриф', 'http://www.altaigrif.ru'); |
||
| 102 | |||
| 103 | |||
| 104 | |||
| 105 | -- |
||
| 106 | |||
| 107 | -- |
||
| 108 | |||
| 109 | DROP TABLE IF EXISTS `resources`; |
||
| 49 | diffor | 110 | CREATE TABLE IF NOT EXISTS `resources` ( |
| 111 | `id` INT(2) NOT NULL AUTO_INCREMENT, |
||
| 112 | |||
| 113 | `resource` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, |
||
| 114 | `picture` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
||
| 115 | `member_id` INT(2) NOT NULL, |
||
| 116 | `link_talk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
||
| 162 | diffor | 117 | `link_res` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL, |
| 49 | diffor | 118 | `description` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
| 162 | diffor | 119 | `custom` VARCHAR(50 |