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