Редакция 306 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 306 | Редакция 327 | ||
|---|---|---|---|
| Строка 1... | Строка 1... | ||
| 1 | -- phpMyAdmin SQL Dump
|
1 | -- phpMyAdmin SQL Dump
|
| 2 | -- version 3.0.0-alpha
|
2 | -- version 3.0.0-alpha
|
| 3 | -- http://www.phpmyadmin.net
|
3 | -- http://www.phpmyadmin.net
|
| 4 | --
|
4 | --
|
| 5 | -- Хост: localhost
|
5 | -- Хост: localhost
|
| 6 | -- Время создания: Окт 14 2009 г., 17:08
|
6 | -- Время создания: Окт 16 2009 г., 19:12
|
| 7 | -- Версия сервера: 5.1.37
|
7 | -- Версия сервера: 5.1.37
|
| 8 | -- Версия PHP: 5.2.11-1
|
8 | -- Версия PHP: 5.2.11-1
|
| 9 | 9 | ||
| 10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| 11 | 11 | ||
| Строка 80... | Строка 80... | ||
| 80 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
80 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
| 81 | 81 | ||
| 82 | -- --------------------------------------------------------
|
82 | -- --------------------------------------------------------
|
| 83 | 83 | ||
| 84 | --
|
84 | --
|
| 85 | -- Структура таблицы `g_host2net`
|
- | |
| 86 | --
|
- | |
| 87 | - | ||
| 88 | DROP TABLE IF EXISTS `g_host2net`; |
- | |
| 89 | CREATE TABLE IF NOT EXISTS `g_host2net` ( |
- | |
| 90 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
- | |
| 91 | `rhost_id` INT(3) NOT NULL, |
- | |
| 92 | `nb_id` INT(2) NOT NULL, |
- | |
| 93 | PRIMARY KEY (`id`), |
- | |
| 94 | KEY `rhost_id` (`rhost_id`) |
- | |
| 95 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts into network block' AUTO_INCREMENT=3 ; |
- | |
| 96 | - | ||
| 97 | -- --------------------------------------------------------
|
- | |
| 98 | - | ||
| 99 | --
|
- | |
| 100 | -- Структура таблицы `g_netblock`
|
- | |
| 101 | --
|
- | |
| 102 | - | ||
| 103 | DROP TABLE IF EXISTS `g_netblock`; |
- | |
| 104 | CREATE TABLE IF NOT EXISTS `g_netblock` ( |
- | |
| 105 | `nb_id` INT(2) NOT NULL AUTO_INCREMENT, |
- | |
| 106 | `netblock` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
- | |
| 107 | PRIMARY KEY (`nb_id`) |
- | |
| 108 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Network blocks' AUTO_INCREMENT=3 ; |
- | |
| 109 | - | ||
| 110 | -- --------------------------------------------------------
|
- | |
| 111 | - | ||
| 112 | --
|
- | |
| 113 | -- Структура таблицы `g_protos`
|
85 | -- Структура таблицы `g_protos`
|
| 114 | --
|
86 | --
|
| 115 | 87 | ||
| 116 | DROP TABLE IF EXISTS `g_protos`; |
88 | DROP TABLE IF EXISTS `g_protos`; |
| 117 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
89 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
| Строка 145... | Строка 117... | ||
| 145 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
117 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
| 146 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
118 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
| 147 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
119 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
| 148 | PRIMARY KEY (`rhost_id`), |
120 | PRIMARY KEY (`rhost_id`), |
| 149 | KEY `proto_id` (`rhost`) |
121 | KEY `proto_id` (`rhost`) |
| 150 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=3 ; |
122 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ; |
| 151 | 123 | ||
| 152 | -- --------------------------------------------------------
|
124 | -- --------------------------------------------------------
|
| 153 | 125 | ||
| 154 | --
|
126 | --
|
| 155 | -- Структура таблицы `g_repository`
|
127 | -- Структура таблицы `g_repository`
|
| Строка 162... | Строка 134... | ||
| 162 | `rhost_id` INT(3) NOT NULL, |
134 | `rhost_id` INT(3) NOT NULL, |
| 163 | `rfolder_id` INT(5) NOT NULL, |
135 | `rfolder_id` INT(5) NOT NULL, |
| 164 | `version` INT(5) NOT NULL, |
136 | `version` INT(5) NOT NULL, |
| 165 | `rtype_id` INT(2) NOT NULL, |
137 | `rtype_id` INT(2) NOT NULL, |
| 166 | `scheme_id` INT(2) NOT NULL, |
138 | `scheme_id` INT(2) NOT NULL, |
| - | 139 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
|
| 167 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
140 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
| 168 | `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL, |
141 | `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL, |
| 169 | PRIMARY KEY (`rep_id`), |
142 | PRIMARY KEY (`rep_id`), |
| 170 | KEY `proto_id` (`proto_id`), |
143 | KEY `proto_id` (`proto_id`), |
| 171 | KEY `rhost_id` (`rhost_id`), |
144 | KEY `rhost_id` (`rhost_id`), |
| 172 | KEY `rfolder_id` (`rfolder_id`), |
145 | KEY `rfolder_id` (`rfolder_id`), |
| 173 | KEY `version` (`version`), |
146 | KEY `version` (`version`), |
| 174 | KEY `rtype_id` (`rtype_id`), |
147 | KEY `rtype_id` (`rtype_id`), |
| 175 | KEY `scheme_id` (`scheme_id`) |
148 | KEY `scheme_id` (`scheme_id`) |
| 176 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=1 ; |
149 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ; |
| 177 | 150 | ||
| 178 | -- --------------------------------------------------------
|
151 | -- --------------------------------------------------------
|
| 179 | 152 | ||
| 180 | --
|
153 | --
|
| 181 | -- Структура таблицы `g_repscheme`
|
154 | -- Структура таблицы `g_repscheme`
|
| Строка 213... | Строка 186... | ||
| 213 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
186 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
| 214 | `sect_id` INT(2) NOT NULL, |
187 | `sect_id` INT(2) NOT NULL, |
| 215 | `rep_id` INT(5) NOT NULL, |
188 | `rep_id` INT(5) NOT NULL, |
| 216 | PRIMARY KEY (`id`), |
189 | PRIMARY KEY (`id`), |
| 217 | KEY `sect_id` (`sect_id`,`rep_id`) |
190 | KEY `sect_id` (`sect_id`,`rep_id`) |
| 218 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=1 ; |
191 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
| 219 | 192 | ||
| 220 | -- --------------------------------------------------------
|
193 | -- --------------------------------------------------------
|
| 221 | 194 | ||
| 222 | --
|
195 | --
|
| 223 | -- Структура таблицы `g_section`
|
196 | -- Структура таблицы `g_section`
|