Редакция 555 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 555 | Редакция 673 | ||
---|---|---|---|
Строка 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 | -- Время создания: Ноя 26 2009 г., 13:46
|
6 | -- Время создания: Ноя 30 2009 г., 14:09
|
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 | ||
Строка 23... | Строка 23... | ||
23 | 23 | ||
24 | --
|
24 | --
|
25 | -- Структура таблицы `g_arch`
|
25 | -- Структура таблицы `g_arch`
|
26 | --
|
26 | --
|
27 | 27 | ||
- | 28 | DROP TABLE IF EXISTS `g_arch`; |
|
28 | CREATE TABLE IF NOT EXISTS `g_arch` ( |
29 | CREATE TABLE IF NOT EXISTS `g_arch` ( |
29 | `arch_id` INT(2) NOT NULL AUTO_INCREMENT, |
30 | `arch_id` INT(2) NOT NULL AUTO_INCREMENT, |
30 | `arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
31 | `arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
31 | PRIMARY KEY (`arch_id`), |
32 | PRIMARY KEY (`arch_id`), |
32 | KEY `arch` (`arch`) |
33 | KEY `arch` (`arch`) |
Строка 36... | Строка 37... | ||
36 | 37 | ||
37 | --
|
38 | --
|
38 | -- Структура таблицы `g_arch2rep`
|
39 | -- Структура таблицы `g_arch2rep`
|
39 | --
|
40 | --
|
40 | 41 | ||
- | 42 | DROP TABLE IF EXISTS `g_arch2rep`; |
|
41 | CREATE TABLE IF NOT EXISTS `g_arch2rep` ( |
43 | CREATE TABLE IF NOT EXISTS `g_arch2rep` ( |
42 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
44 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
43 | `arch_id` INT(2) NOT NULL, |
45 | `arch_id` INT(2) NOT NULL, |
44 | `rep_id` INT(5) NOT NULL, |
46 | `rep_id` INT(5) NOT NULL, |
45 | PRIMARY KEY (`id`), |
47 | PRIMARY KEY (`id`), |
46 | KEY `arch_id` (`arch_id`,`rep_id`) |
48 | KEY `arch_id` (`arch_id`,`rep_id`) |
47 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ; |
49 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=103 ; |
48 | 50 | ||
49 | -- --------------------------------------------------------
|
51 | -- --------------------------------------------------------
|
50 | 52 | ||
51 | --
|
53 | --
|
52 | -- Структура таблицы `g_distribution`
|
54 | -- Структура таблицы `g_distribution`
|
53 | --
|
55 | --
|
54 | 56 | ||
- | 57 | DROP TABLE IF EXISTS `g_distribution`; |
|
55 | CREATE TABLE IF NOT EXISTS `g_distribution` ( |
58 | CREATE TABLE IF NOT EXISTS `g_distribution` ( |
56 | `dist_id` INT(5) NOT NULL AUTO_INCREMENT, |
59 | `dist_id` INT(5) NOT NULL AUTO_INCREMENT, |
57 | `distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
60 | `distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
58 | `distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
61 | `distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
59 | `disttype` INT(1) NOT NULL, |
62 | `disttype` INT(1) NOT NULL, |
60 | `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, |
63 | `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, |
61 | PRIMARY KEY (`dist_id`), |
64 | PRIMARY KEY (`dist_id`), |
62 | KEY `disttype` (`disttype`,`distlogo`) |
65 | KEY `disttype` (`disttype`,`distlogo`) |
63 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=6 ; |
66 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=7 ; |
64 | 67 | ||
65 | -- --------------------------------------------------------
|
68 | -- --------------------------------------------------------
|
66 | 69 | ||
67 | --
|
70 | --
|
68 | -- Структура таблицы `g_dtype`
|
71 | -- Структура таблицы `g_dtype`
|
69 | --
|
72 | --
|
70 | 73 | ||
- | 74 | DROP TABLE IF EXISTS `g_dtype`; |
|
71 | CREATE TABLE IF NOT EXISTS `g_dtype` ( |
75 | CREATE TABLE IF NOT EXISTS `g_dtype` ( |
72 | `type_id` INT(1) NOT NULL AUTO_INCREMENT, |
76 | `type_id` INT(1) NOT NULL AUTO_INCREMENT, |
73 | `type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL, |
77 | `type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL, |
74 | PRIMARY KEY (`type_id`), |
78 | PRIMARY KEY (`type_id`), |
75 | KEY `type` (`type`) |
79 | KEY `type` (`type`) |
Строка 79... | Строка 83... | ||
79 | 83 | ||
80 | --
|
84 | --
|
81 | -- Структура таблицы `g_protos`
|
85 | -- Структура таблицы `g_protos`
|
82 | --
|
86 | --
|
83 | 87 | ||
- | 88 | DROP TABLE IF EXISTS `g_protos`; |
|
84 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
89 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
85 | `proto_id` INT(1) NOT NULL AUTO_INCREMENT, |
90 | `proto_id` INT(1) NOT NULL AUTO_INCREMENT, |
86 | `proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
91 | `proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
87 | PRIMARY KEY (`proto_id`), |
92 | PRIMARY KEY (`proto_id`), |
88 | KEY `proto` (`proto`) |
93 | KEY `proto` (`proto`) |
Строка 92... | Строка 97... | ||
92 | 97 | ||
93 | --
|
98 | --
|
94 | -- Структура таблицы `g_repfolder`
|
99 | -- Структура таблицы `g_repfolder`
|
95 | --
|
100 | --
|
96 | 101 | ||
- | 102 | DROP TABLE IF EXISTS `g_repfolder`; |
|
97 | CREATE TABLE IF NOT EXISTS `g_repfolder` ( |
103 | CREATE TABLE IF NOT EXISTS `g_repfolder` ( |
98 | `rfolder_id` INT(5) NOT NULL AUTO_INCREMENT, |
104 | `rfolder_id` INT(5) NOT NULL AUTO_INCREMENT, |
99 | `rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
105 | `rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
100 | PRIMARY KEY (`rfolder_id`), |
106 | PRIMARY KEY (`rfolder_id`), |
101 | KEY `rhost_id` (`rfolder`) |
107 | KEY `rhost_id` (`rfolder`) |
102 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ; |
108 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=23 ; |
103 | 109 | ||
104 | -- --------------------------------------------------------
|
110 | -- --------------------------------------------------------
|
105 | 111 | ||
106 | --
|
112 | --
|
107 | -- Структура таблицы `g_rephost`
|
113 | -- Структура таблицы `g_rephost`
|
108 | --
|
114 | --
|
109 | 115 | ||
- | 116 | DROP TABLE IF EXISTS `g_rephost`; |
|
110 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
117 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
111 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
118 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
112 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
119 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
113 | PRIMARY KEY (`rhost_id`), |
120 | PRIMARY KEY (`rhost_id`), |
114 | KEY `proto_id` (`rhost`) |
121 | KEY `proto_id` (`rhost`) |
115 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ; |
122 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=8 ; |
116 | 123 | ||
117 | -- --------------------------------------------------------
|
124 | -- --------------------------------------------------------
|
118 | 125 | ||
119 | --
|
126 | --
|
120 | -- Структура таблицы `g_repository`
|
127 | -- Структура таблицы `g_repository`
|
121 | --
|
128 | --
|
122 | 129 | ||
- | 130 | DROP TABLE IF EXISTS `g_repository`; |
|
123 | CREATE TABLE IF NOT EXISTS `g_repository` ( |
131 | CREATE TABLE IF NOT EXISTS `g_repository` ( |
124 | `rep_id` INT(5) NOT NULL AUTO_INCREMENT, |
132 | `rep_id` INT(5) NOT NULL AUTO_INCREMENT, |
125 | `proto_id` INT(1) NOT NULL, |
133 | `proto_id` INT(1) NOT NULL, |
126 | `rhost_id` INT(3) NOT NULL, |
134 | `rhost_id` INT(3) NOT NULL, |
127 | `rfolder_id` INT(5) NOT NULL, |
135 | `rfolder_id` INT(5) NOT NULL, |
128 | `version` INT(5) NOT NULL, |
136 | `version` INT(5) NOT NULL, |
129 | `rtype_id` INT(2) NOT NULL, |
137 | `rtype_id` INT(2) NOT NULL, |
130 | `scheme_id` INT(2) NOT NULL, |
138 | `scheme_id` INT(2) NOT NULL, |
- | 139 | `sign_id` INT(3) NOT NULL, |
|
131 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
140 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
132 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
141 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
133 | `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL, |
142 | `repkey` VARCHAR(200) COLLATE utf8_unicode_ci NOT NULL, |
134 | PRIMARY KEY (`rep_id`), |
143 | PRIMARY KEY (`rep_id`), |
135 | KEY `proto_id` (`proto_id`), |
144 | KEY `proto_id` (`proto_id`), |
136 | KEY `rhost_id` (`rhost_id`), |
145 | KEY `rhost_id` (`rhost_id`), |
137 | KEY `rfolder_id` (`rfolder_id`), |
146 | KEY `rfolder_id` (`rfolder_id`), |
138 | KEY `version` (`version`), |
147 | KEY `version` (`version`), |
139 | KEY `rtype_id` (`rtype_id`), |
148 | KEY `rtype_id` (`rtype_id`), |
140 | KEY `scheme_id` (`scheme_id`) |
149 | KEY `scheme_id` (`scheme_id`), |
- | 150 | KEY `sign_id` (`sign_id`) |
|
141 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ; |
151 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ; |
142 | 152 | ||
143 | -- --------------------------------------------------------
|
153 | -- --------------------------------------------------------
|
144 | 154 | ||
145 | --
|
155 | --
|
146 | -- Структура таблицы `g_repscheme`
|
156 | -- Структура таблицы `g_repscheme`
|
147 | --
|
157 | --
|
148 | 158 | ||
- | 159 | DROP TABLE IF EXISTS `g_repscheme`; |
|
149 | CREATE TABLE IF NOT EXISTS `g_repscheme` ( |
160 | CREATE TABLE IF NOT EXISTS `g_repscheme` ( |
150 | `scheme_id` INT(2) NOT NULL AUTO_INCREMENT, |
161 | `scheme_id` INT(2) NOT NULL AUTO_INCREMENT, |
151 | `scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
162 | `scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
152 | PRIMARY KEY (`scheme_id`), |
163 | PRIMARY KEY (`scheme_id`), |
153 | KEY `scheme` (`scheme`) |
164 | KEY `scheme` (`scheme`) |
154 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ; |
165 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ; |
155 | 166 | ||
156 | -- --------------------------------------------------------
|
167 | -- --------------------------------------------------------
|
157 | 168 | ||
158 | --
|
169 | --
|
159 | -- Структура таблицы `g_rtype`
|
170 | -- Структура таблицы `g_rtype`
|
160 | --
|
171 | --
|
161 | 172 | ||
- | 173 | DROP TABLE IF EXISTS `g_rtype`; |
|
162 | CREATE TABLE IF NOT EXISTS `g_rtype` ( |
174 | CREATE TABLE IF NOT EXISTS `g_rtype` ( |
163 | `rtype_id` INT(2) NOT NULL AUTO_INCREMENT, |
175 | `rtype_id` INT(2) NOT NULL AUTO_INCREMENT, |
164 | `rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
176 | `rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
165 | PRIMARY KEY (`rtype_id`) |
177 | PRIMARY KEY (`rtype_id`) |
166 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ; |
178 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ; |
Строка 169... | Строка 181... | ||
169 | 181 | ||
170 | --
|
182 | --
|
171 | -- Структура таблицы `g_sect2rep`
|
183 | -- Структура таблицы `g_sect2rep`
|
172 | --
|
184 | --
|
173 | 185 | ||
- | 186 | DROP TABLE IF EXISTS `g_sect2rep`; |
|
174 | CREATE TABLE IF NOT EXISTS `g_sect2rep` ( |
187 | CREATE TABLE IF NOT EXISTS `g_sect2rep` ( |
175 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
188 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
176 | `sect_id` INT(2) NOT NULL, |
189 | `sect_id` INT(2) NOT NULL, |
177 | `rep_id` INT(5) NOT NULL, |
190 | `rep_id` INT(5) NOT NULL, |
178 | PRIMARY KEY (`id`), |
191 | PRIMARY KEY (`id`), |
179 | KEY `sect_id` (`sect_id`,`rep_id`) |
192 | KEY `sect_id` (`sect_id`,`rep_id`) |
180 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
193 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ; |
181 | 194 | ||
182 | -- --------------------------------------------------------
|
195 | -- --------------------------------------------------------
|
183 | 196 | ||
184 | --
|
197 | --
|
185 | -- Структура таблицы `g_section`
|
198 | -- Структура таблицы `g_section`
|
186 | --
|
199 | --
|
187 | 200 | ||
- | 201 | DROP TABLE IF EXISTS `g_section`; |
|
188 | CREATE TABLE IF NOT EXISTS `g_section` ( |
202 | CREATE TABLE IF NOT EXISTS `g_section` ( |
189 | `sect_id` INT(2) NOT NULL AUTO_INCREMENT, |
203 | `sect_id` INT(2) NOT NULL AUTO_INCREMENT, |
190 | `secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
204 | `secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
191 | `sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL, |
205 | `sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL, |
192 | PRIMARY KEY (`sect_id`), |
206 | PRIMARY KEY (`sect_id`), |
Строка 197... | Строка 211... | ||
197 | 211 | ||
198 | --
|
212 | --
|
199 | -- Структура таблицы `g_settings`
|
213 | -- Структура таблицы `g_settings`
|
200 | --
|
214 | --
|
201 | 215 | ||
- | 216 | DROP TABLE IF EXISTS `g_settings`; |
|
202 | CREATE TABLE IF NOT EXISTS `g_settings` ( |
217 | CREATE TABLE IF NOT EXISTS `g_settings` ( |
203 | `opt_id` INT(2) NOT NULL AUTO_INCREMENT, |
218 | `opt_id` INT(2) NOT NULL AUTO_INCREMENT, |
204 | `opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
219 | `opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
205 | `optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
220 | `optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
206 | PRIMARY KEY (`opt_id`), |
221 | PRIMARY KEY (`opt_id`), |
Строка 211... | Строка 226... | ||
211 | 226 | ||
212 | --
|
227 | --
|
213 | -- Структура таблицы `g_signs`
|
228 | -- Структура таблицы `g_signs`
|
214 | --
|
229 | --
|
215 | 230 | ||
- | 231 | DROP TABLE IF EXISTS `g_signs`; |
|
216 | CREATE TABLE IF NOT EXISTS `g_signs` ( |
232 | CREATE TABLE IF NOT EXISTS `g_signs` ( |
217 | `sign_id` INT(3) NOT NULL AUTO_INCREMENT, |
233 | `sign_id` INT(3) NOT NULL AUTO_INCREMENT, |
218 | `sname` VARCHAR(25) NOT NULL, |
234 | `sname` VARCHAR(25) NOT NULL, |
219 | `sinfo` VARCHAR(150) NOT NULL, |
235 | `sinfo` VARCHAR(150) NOT NULL, |
220 | PRIMARY KEY (`sign_id`) |
236 | PRIMARY KEY (`sign_id`) |
Строка 224... | Строка 240... | ||
224 | 240 | ||
225 | --
|
241 | --
|
226 | -- Структура таблицы `g_version`
|
242 | -- Структура таблицы `g_version`
|
227 | --
|
243 | --
|
228 | 244 | ||
- | 245 | DROP TABLE IF EXISTS `g_version`; |
|
229 | CREATE TABLE IF NOT EXISTS `g_version` ( |
246 | CREATE TABLE IF NOT EXISTS `g_version` ( |
230 | `version_id` INT(5) NOT NULL AUTO_INCREMENT, |
247 | `version_id` INT(5) NOT NULL AUTO_INCREMENT, |
231 | `dist_id` INT(5) NOT NULL, |
248 | `dist_id` INT(5) NOT NULL, |
232 | `vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
249 | `vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
233 | `version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
250 | `version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
234 | `vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
251 | `vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
235 | PRIMARY KEY (`version_id`), |
252 | PRIMARY KEY (`version_id`), |
236 | KEY `dist_id` (`dist_id`) |
253 | KEY `dist_id` (`dist_id`) |
237 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=13 ; |
254 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ; |