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