Редакция 692 | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 692 | Редакция 697 | ||
---|---|---|---|
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 | -- Время создания: Ноя 30 2009 г., 17:25
|
6 | -- Время создания: Ноя 30 2009 г., 17:25
|
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 | ||
12 | 12 | ||
13 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
13 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
14 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
14 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
15 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
15 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
16 | /*!40101 SET NAMES utf8 */;
|
16 | /*!40101 SET NAMES utf8 */;
|
17 | 17 | ||
18 | --
|
18 | --
|
19 | -- База данных: `generator`
|
19 | -- База данных: `generator`
|
20 | --
|
20 | --
|
21 | 21 | ||
22 | -- --------------------------------------------------------
|
22 | -- --------------------------------------------------------
|
23 | 23 | ||
24 | --
|
24 | --
|
25 | -- Структура таблицы `g_arch`
|
25 | -- Структура таблицы `g_arch`
|
26 | --
|
26 | --
|
27 | 27 | ||
28 | DROP TABLE IF EXISTS `g_arch`; |
28 | DROP TABLE IF EXISTS `g_arch`; |
29 | CREATE TABLE IF NOT EXISTS `g_arch` ( |
29 | CREATE TABLE IF NOT EXISTS `g_arch` ( |
30 | `arch_id` INT(2) NOT NULL AUTO_INCREMENT, |
30 | `arch_id` INT(2) NOT NULL AUTO_INCREMENT, |
31 | `arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
31 | `arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
32 | PRIMARY KEY (`arch_id`), |
32 | PRIMARY KEY (`arch_id`), |
33 | KEY `arch` (`arch`) |
33 | KEY `arch` (`arch`) |
34 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ; |
34 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ; |
35 | 35 | ||
36 | --
|
36 | --
|
37 | -- Дамп данных таблицы `g_arch`
|
37 | -- Дамп данных таблицы `g_arch`
|
38 | --
|
38 | --
|
39 | 39 | ||
40 | INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES |
40 | INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES |
41 | (1, 'i386'), |
41 | (1, 'i386'), |
42 | (2, 'amd64'); |
42 | (2, 'amd64'); |
43 | 43 | ||
44 | -- --------------------------------------------------------
|
44 | -- --------------------------------------------------------
|
45 | 45 | ||
46 | --
|
46 | --
|
47 | -- Структура таблицы `g_arch2rep`
|
47 | -- Структура таблицы `g_arch2rep`
|
48 | --
|
48 | --
|
49 | 49 | ||
50 | DROP TABLE IF EXISTS `g_arch2rep`; |
50 | DROP TABLE IF EXISTS `g_arch2rep`; |
51 | CREATE TABLE IF NOT EXISTS `g_arch2rep` ( |
51 | CREATE TABLE IF NOT EXISTS `g_arch2rep` ( |
52 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
52 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
53 | `arch_id` INT(2) NOT NULL, |
53 | `arch_id` INT(2) NOT NULL, |
54 | `rep_id` INT(5) NOT NULL, |
54 | `rep_id` INT(5) NOT NULL, |
55 | PRIMARY KEY (`id`), |
55 | PRIMARY KEY (`id`), |
56 | KEY `arch_id` (`arch_id`,`rep_id`) |
56 | KEY `arch_id` (`arch_id`,`rep_id`) |
57 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=103 ; |
57 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=103 ; |
58 | 58 | ||
59 | --
|
59 | --
|
60 | -- Дамп данных таблицы `g_arch2rep`
|
60 | -- Дамп данных таблицы `g_arch2rep`
|
61 | --
|
61 | --
|
62 | 62 | ||
63 | INSERT INTO `g_arch2rep` (`id`, `arch_id`, `rep_id`) VALUES |
63 | INSERT INTO `g_arch2rep` (`id`, `arch_id`, `rep_id`) VALUES |
64 | (82, 2, 8), |
64 | (82, 2, 8), |
65 | (81, 1, 8), |
65 | (81, 1, 8), |
66 | (30, 2, 7), |
66 | (30, 2, 7), |
67 | (29, 1, 7), |
67 | (29, 1, 7), |
68 | (28, 2, 6), |
68 | (28, 2, 6), |
69 | (27, 1, 6), |
69 | (27, 1, 6), |
70 | (62, 2, 5), |
70 | (62, 2, 5), |
71 | (61, 1, 5), |
71 | (61, 1, 5), |
72 | (9, 1, 2), |
72 | (9, 1, 2), |
73 | (10, 2, 2), |
73 | (10, 2, 2), |
74 | (11, 1, 3), |
74 | (11, 1, 3), |
75 | (12, 2, 3), |
75 | (12, 2, 3), |
76 | (13, 1, 4), |
76 | (13, 1, 4), |
77 | (14, 2, 4), |
77 | (14, 2, 4), |
78 | (84, 2, 9), |
78 | (84, 2, 9), |
79 | (83, 1, 9), |
79 | (83, 1, 9), |
80 | (92, 2, 10), |
80 | (92, 2, 10), |
81 | (91, 1, 10), |
81 | (91, 1, 10), |
82 | (86, 2, 11), |
82 | (86, 2, 11), |
83 | (85, 1, 11), |
83 | (85, 1, 11), |
84 | (43, 1, 12), |
84 | (43, 1, 12), |
85 | (44, 2, 12), |
85 | (44, 2, 12), |
86 | (45, 1, 13), |
86 | (45, 1, 13), |
87 | (46, 2, 13), |
87 | (46, 2, 13), |
88 | (88, 2, 14), |
88 | (88, 2, 14), |
89 | (87, 1, 14), |
89 | (87, 1, 14), |
90 | (49, 1, 15), |
90 | (49, 1, 15), |
91 | (50, 2, 15), |
91 | (50, 2, 15), |
92 | (90, 2, 16), |
92 | (90, 2, 16), |
93 | (89, 1, 16), |
93 | (89, 1, 16), |
94 | (53, 1, 17), |
94 | (53, 1, 17), |
95 | (54, 2, 17), |
95 | (54, 2, 17), |
96 | (94, 2, 18), |
96 | (94, 2, 18), |
97 | (93, 1, 18), |
97 | (93, 1, 18), |
98 | (96, 2, 19), |
98 | (96, 2, 19), |
99 | (95, 1, 19), |
99 | (95, 1, 19), |
100 | (59, 1, 20), |
100 | (59, 1, 20), |
101 | (60, 2, 20), |
101 | (60, 2, 20), |
102 | (63, 1, 21), |
102 | (63, 1, 21), |
103 | (64, 2, 21), |
103 | (64, 2, 21), |
104 | (69, 1, 22), |
104 | (69, 1, 22), |
105 | (70, 2, 22), |
105 | (70, 2, 22), |
106 | (78, 2, 23), |
106 | (78, 2, 23), |
107 | (77, 1, 23), |
107 | (77, 1, 23), |
108 | (73, 1, 24), |
108 | (73, 1, 24), |
109 | (74, 2, 24), |
109 | (74, 2, 24), |
110 | (75, 1, 25), |
110 | (75, 1, 25), |
111 | (76, 2, 25), |
111 | (76, 2, 25), |
112 | (79, 1, 26), |
112 | (79, 1, 26), |
113 | (80, 2, 26), |
113 | (80, 2, 26), |
114 | (97, 1, 27), |
114 | (97, 1, 27), |
115 | (98, 2, 27), |
115 | (98, 2, 27), |
116 | (102, 2, 28), |
116 | (102, 2, 28), |
117 | (101, 1, 28); |
117 | (101, 1, 28); |
118 | 118 | ||
119 | -- --------------------------------------------------------
|
119 | -- --------------------------------------------------------
|
120 | 120 | ||
121 | --
|
121 | --
|
122 | -- Структура таблицы `g_distribution`
|
122 | -- Структура таблицы `g_distribution`
|
123 | --
|
123 | --
|
124 | 124 | ||
125 | DROP TABLE IF EXISTS `g_distribution`; |
125 | DROP TABLE IF EXISTS `g_distribution`; |
126 | CREATE TABLE IF NOT EXISTS `g_distribution` ( |
126 | CREATE TABLE IF NOT EXISTS `g_distribution` ( |
127 | `dist_id` INT(5) NOT NULL AUTO_INCREMENT, |
127 | `dist_id` INT(5) NOT NULL AUTO_INCREMENT, |
128 | `distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
128 | `distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
129 | `distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
129 | `distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
130 | `disttype` INT(1) NOT NULL, |
130 | `disttype` INT(1) NOT NULL, |
131 | `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, |
131 | `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, |
132 | PRIMARY KEY (`dist_id`), |
132 | PRIMARY KEY (`dist_id`), |
133 | KEY `disttype` (`disttype`,`distlogo`) |
133 | KEY `disttype` (`disttype`,`distlogo`) |
134 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=7 ; |
134 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=7 ; |
135 | 135 | ||
136 | --
|
136 | --
|
137 | -- Дамп данных таблицы `g_distribution`
|
137 | -- Дамп данных таблицы `g_distribution`
|
138 | --
|
138 | --
|
139 | 139 | ||
140 | INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES |
140 | INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES |
141 | (1, 'Debian GNU/Linux', 'debian', 1, '1'), |
141 | (1, 'Debian GNU/Linux', 'debian', 1, '1'), |
142 | (2, 'Ubuntu Linux', 'ubuntu', 1, '0'), |
142 | (2, 'Ubuntu Linux', 'ubuntu', 1, '0'), |
143 | (5, 'ALTLinux', 'altlinux', 2, '0'), |
143 | (5, 'ALTLinux', 'altlinux', 2, '0'), |
144 | (6, 'InfraLinux', 'infralinux', 1, '0'); |
144 | (6, 'InfraLinux', 'infralinux', 1, '0'); |
145 | 145 | ||
146 | -- --------------------------------------------------------
|
146 | -- --------------------------------------------------------
|
147 | 147 | ||
148 | --
|
148 | --
|
149 | -- Структура таблицы `g_dtype`
|
149 | -- Структура таблицы `g_dtype`
|
150 | --
|
150 | --
|
151 | 151 | ||
152 | DROP TABLE IF EXISTS `g_dtype`; |
152 | DROP TABLE IF EXISTS `g_dtype`; |
153 | CREATE TABLE IF NOT EXISTS `g_dtype` ( |
153 | CREATE TABLE IF NOT EXISTS `g_dtype` ( |
154 | `type_id` INT(1) NOT NULL AUTO_INCREMENT, |
154 | `type_id` INT(1) NOT NULL AUTO_INCREMENT, |
155 | `type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL, |
155 | `type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL, |
156 | PRIMARY KEY (`type_id`), |
156 | PRIMARY KEY (`type_id`), |
157 | KEY `type` (`type`) |
157 | KEY `type` (`type`) |
158 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
158 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
159 | 159 | ||
160 | --
|
160 | --
|
161 | -- Дамп данных таблицы `g_dtype`
|
161 | -- Дамп данных таблицы `g_dtype`
|
162 | --
|
162 | --
|
163 | 163 | ||
164 | INSERT INTO `g_dtype` (`type_id`, `type`) VALUES |
164 | INSERT INTO `g_dtype` (`type_id`, `type`) VALUES |
165 | (1, 'deb'), |
165 | (1, 'deb'), |
166 | (2, 'rpm'); |
166 | (2, 'rpm'); |
167 | 167 | ||
168 | -- --------------------------------------------------------
|
168 | -- --------------------------------------------------------
|
169 | 169 | ||
170 | --
|
170 | --
|
171 | -- Структура таблицы `g_protos`
|
171 | -- Структура таблицы `g_protos`
|
172 | --
|
172 | --
|
173 | 173 | ||
174 | DROP TABLE IF EXISTS `g_protos`; |
174 | DROP TABLE IF EXISTS `g_protos`; |
175 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
175 | CREATE TABLE IF NOT EXISTS `g_protos` ( |
176 | `proto_id` INT(1) NOT NULL AUTO_INCREMENT, |
176 | `proto_id` INT(1) NOT NULL AUTO_INCREMENT, |
177 | `proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
177 | `proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
178 | PRIMARY KEY (`proto_id`), |
178 | PRIMARY KEY (`proto_id`), |
179 | KEY `proto` (`proto`) |
179 | KEY `proto` (`proto`) |
180 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ; |
180 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ; |
181 | 181 | ||
182 | --
|
182 | --
|
183 | -- Дамп данных таблицы `g_protos`
|
183 | -- Дамп данных таблицы `g_protos`
|
184 | --
|
184 | --
|
185 | 185 | ||
186 | INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES |
186 | INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES |
187 | (1, 'http://'); |
187 | (1, 'http://'); |
188 | 188 | ||
189 | -- --------------------------------------------------------
|
189 | -- --------------------------------------------------------
|
190 | 190 | ||
191 | --
|
191 | --
|
192 | -- Структура таблицы `g_repfolder`
|
192 | -- Структура таблицы `g_repfolder`
|
193 | --
|
193 | --
|
194 | 194 | ||
195 | DROP TABLE IF EXISTS `g_repfolder`; |
195 | DROP TABLE IF EXISTS `g_repfolder`; |
196 | CREATE TABLE IF NOT EXISTS `g_repfolder` ( |
196 | CREATE TABLE IF NOT EXISTS `g_repfolder` ( |
197 | `rfolder_id` INT(5) NOT NULL AUTO_INCREMENT, |
197 | `rfolder_id` INT(5) NOT NULL AUTO_INCREMENT, |
198 | `rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
198 | `rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
199 | PRIMARY KEY (`rfolder_id`), |
199 | PRIMARY KEY (`rfolder_id`), |
200 | KEY `rhost_id` (`rfolder`) |
200 | KEY `rhost_id` (`rfolder`) |
201 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=23 ; |
201 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=23 ; |
202 | 202 | ||
203 | --
|
203 | --
|
204 | -- Дамп данных таблицы `g_repfolder`
|
204 | -- Дамп данных таблицы `g_repfolder`
|
205 | --
|
205 | --
|
206 | 206 | ||
207 | INSERT INTO `g_repfolder` (`rfolder_id`, `rfolder`) VALUES |
207 | INSERT INTO `g_repfolder` (`rfolder_id`, `rfolder`) VALUES |
208 | (1, '/debian'), |
208 | (1, '/debian'), |
209 | (2, '/debian-backports'), |
209 | (2, '/debian-backports'), |
210 | (3, '/debian-multimedia'), |
210 | (3, '/debian-multimedia'), |
211 | (4, '/opera-beta'), |
211 | (4, '/opera-beta'), |
212 | (5, '/opera'), |
212 | (5, '/opera'), |
213 | (6, '/debian-security'), |
213 | (6, '/debian-security'), |
214 | (7, '/debian-volatile'), |
214 | (7, '/debian-volatile'), |
215 | (8, '/debian-winehq'), |
215 | (8, '/debian-winehq'), |
216 | (9, '/gfoss'), |
216 | (9, '/gfoss'), |
217 | (10, '/2gis'), |
217 | (10, '/2gis'), |
218 | (11, '/freenx'), |
218 | (11, '/freenx'), |
219 | (12, '/virtualbox'), |
219 | (12, '/virtualbox'), |
220 | (13, '/ubuntu'), |
220 | (13, '/ubuntu'), |
221 | (14, '/playonlinux'), |
221 | (14, '/playonlinux'), |
222 | (15, '/xneur'), |
222 | (15, '/xneur'), |
223 | (16, '/ubuntu-winehq'), |
223 | (16, '/ubuntu-winehq'), |
224 | (17, '/ubuntu-commercial'), |
224 | (17, '/ubuntu-commercial'), |
225 | (18, '/infralinux'), |
225 | (18, '/infralinux'), |
226 | (19, '/sarge-backports'), |
226 | (19, '/sarge-backports'), |
227 | (20, '/sarge-proposed-updates'), |
227 | (20, '/sarge-proposed-updates'), |
228 | (21, '/sarge'), |
228 | (21, '/sarge'), |
229 | (22, '/p5/branch'); |
229 | (22, '/p5/branch'); |
230 | 230 | ||
231 | -- --------------------------------------------------------
|
231 | -- --------------------------------------------------------
|
232 | 232 | ||
233 | --
|
233 | --
|
234 | -- Структура таблицы `g_rephost`
|
234 | -- Структура таблицы `g_rephost`
|
235 | --
|
235 | --
|
236 | 236 | ||
237 | DROP TABLE IF EXISTS `g_rephost`; |
237 | DROP TABLE IF EXISTS `g_rephost`; |
238 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
238 | CREATE TABLE IF NOT EXISTS `g_rephost` ( |
239 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
239 | `rhost_id` INT(3) NOT NULL AUTO_INCREMENT, |
240 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
240 | `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL, |
241 | PRIMARY KEY (`rhost_id`), |
241 | PRIMARY KEY (`rhost_id`), |
242 | KEY `proto_id` (`rhost`) |
242 | KEY `proto_id` (`rhost`) |
243 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=8 ; |
243 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=8 ; |
244 | 244 | ||
245 | --
|
245 | --
|
246 | -- Дамп данных таблицы `g_rephost`
|
246 | -- Дамп данных таблицы `g_rephost`
|
247 | --
|
247 | --
|
248 | 248 | ||
249 | INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
249 | INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
250 | (1, 'apt.nix-files.org.ru'), |
250 | (1, 'apt.nix-files.org.ru'), |
251 | (2, 'hyperion.uni-altai.ru'), |
251 | (2, 'hyperion.uni-altai.ru'), |
252 | (3, 'apt.nix-files.uni-altai.ru'), |
252 | (3, 'apt.nix-files.uni-altai.ru'), |
253 | (7, 'alt.nix-files.org.ru'); |
253 | (7, 'alt.nix-files.org.ru'); |
254 | 254 | ||
255 | -- --------------------------------------------------------
|
255 | -- --------------------------------------------------------
|
256 | 256 | ||
257 | --
|
257 | --
|
258 | -- Структура таблицы `g_repository`
|
258 | -- Структура таблицы `g_repository`
|
259 | --
|
259 | --
|
260 | 260 | ||
261 | DROP TABLE IF EXISTS `g_repository`; |
261 | DROP TABLE IF EXISTS `g_repository`; |
262 | CREATE TABLE IF NOT EXISTS `g_repository` ( |
262 | CREATE TABLE IF NOT EXISTS `g_repository` ( |
263 | `rep_id` INT(5) NOT NULL AUTO_INCREMENT, |
263 | `rep_id` INT(5) NOT NULL AUTO_INCREMENT, |
264 | `proto_id` INT(1) NOT NULL, |
264 | `proto_id` INT(1) NOT NULL, |
265 | `rhost_id` INT(3) NOT NULL, |
265 | `rhost_id` INT(3) NOT NULL, |
266 | `rfolder_id` INT(5) NOT NULL, |
266 | `rfolder_id` INT(5) NOT NULL, |
267 | `version` INT(5) NOT NULL, |
267 | `version` INT(5) NOT NULL, |
268 | `rtype_id` INT(2) NOT NULL, |
268 | `rtype_id` INT(2) NOT NULL, |
269 | `scheme_id` INT(2) NOT NULL, |
269 | `scheme_id` INT(2) NOT NULL, |
270 | `sign_id` INT(3) NOT NULL, |
270 | `sign_id` INT(3) NOT NULL, |
271 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
271 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
272 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
272 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
273 | `repkey` VARCHAR(200) COLLATE utf8_unicode_ci NOT NULL, |
273 | `repkey` VARCHAR(200) COLLATE utf8_unicode_ci NOT NULL, |
274 | PRIMARY KEY (`rep_id`), |
274 | PRIMARY KEY (`rep_id`), |
275 | KEY `proto_id` (`proto_id`), |
275 | KEY `proto_id` (`proto_id`), |
276 | KEY `rhost_id` (`rhost_id`), |
276 | KEY `rhost_id` (`rhost_id`), |
277 | KEY `rfolder_id` (`rfolder_id`), |
277 | KEY `rfolder_id` (`rfolder_id`), |
278 | KEY `version` (`version`), |
278 | KEY `version` (`version`), |
279 | KEY `rtype_id` (`rtype_id`), |
279 | KEY `rtype_id` (`rtype_id`), |
280 | KEY `scheme_id` (`scheme_id`), |
280 | KEY `scheme_id` (`scheme_id`), |
281 | KEY `sign_id` (`sign_id`) |
281 | KEY `sign_id` (`sign_id`) |
282 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ; |
282 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ; |
283 | 283 | ||
284 | --
|
284 | --
|
285 | -- Дамп данных таблицы `g_repository`
|
285 | -- Дамп данных таблицы `g_repository`
|
286 | --
|
286 | --
|
287 | 287 | ||
288 | INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `sign_id`, `repname`, `repinfo`, `repkey`) VALUES |
288 | INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `sign_id`, `repname`, `repinfo`, `repkey`) VALUES |
289 | (5, 1, 1, 21, 1, 1, 1, 0, 'Sarge Base', 'Базовый репозиторий для sarge', ''), |
289 | (5, 1, 1, 21, 1, 1, 1, 0, 'Sarge Base', 'Базовый репозиторий для sarge', ''), |
290 | (2, 1, 1, 1, 2, 1, 1, 0, 'Etch Base', 'Основной репозиторий для etch', ''), |
290 | (2, 1, 1, 1, 2, 1, 1, 0, 'Etch Base', 'Основной репозиторий для etch', ''), |
291 | (3, 1, 1, 2, 2, 2, 6, 0, 'Etch Backports', 'Бэкпортированный софт для etch', ''), |
291 | (3, 1, 1, 2, 2, 2, 6, 0, 'Etch Backports', 'Бэкпортированный софт для etch', ''), |
292 | (4, 1, 1, 12, 2, 3, 1, 0, 'VirtualBox', 'Sun VirtualBox', ''), |
292 | (4, 1, 1, 12, 2, 3, 1, 0, 'VirtualBox', 'Sun VirtualBox', ''), |
293 | (6, 1, 2, 1, 3, 3, 1, 0, 'Hyperion', 'Неофициальный репозиторий АлтГПА и AltLUG\\''а', 'wget -O - http://hyperion.uni-altai.ru/hyperion.key | apt-key add -'), |
293 | (6, 1, 2, 1, 3, 3, 1, 0, 'Hyperion', 'Неофициальный репозиторий АлтГПА и AltLUG\\''а', 'wget -O - http://hyperion.uni-altai.ru/hyperion.key | apt-key add -'), |
294 | (7, 1, 2, 1, 4, 3, 1, 0, 'Hyperion', 'Неофициальный репозиторий АлтГПА и AltLUG\\''а', 'wget -O - http://hyperion.uni-altai.ru/hyperion.key | apt-key add -'), |
294 | (7, 1, 2, 1, 4, 3, 1, 0, 'Hyperion', 'Неофициальный репозиторий АлтГПА и AltLUG\\''а', 'wget -O - http://hyperion.uni-altai.ru/hyperion.key | apt-key add -'), |
295 | (8, 1, 1, 1, 3, 1, 1, 0, 'Lenny Base', 'Базовый репозиторий Lenny', 'apt-get install debian-keyring'), |
295 | (8, 1, 1, 1, 3, 1, 1, 0, 'Lenny Base', 'Базовый репозиторий Lenny', 'apt-get install debian-keyring'), |
296 | (9, 1, 1, 6, 3, 2, 3, 0, 'Security', 'Обновления безопасности', 'apt-get install debian-keyring'), |
296 | (9, 1, 1, 6, 3, 2, 3, 0, 'Security', 'Обновления безопасности', 'apt-get install debian-keyring'), |
297 | (10, 1, 1, 2, 3, 2, 6, 0, 'Backports', 'Бэкпортированное ПО для Lenny', 'apt-get install debian-backports-keyring'), |
297 | (10, 1, 1, 2, 3, 2, 6, 0, 'Backports', 'Бэкпортированное ПО для Lenny', 'apt-get install debian-backports-keyring'), |
298 | (11, 1, 1, 7, 3, 2, 4, 0, 'Volatile', 'Непостоянные обновления для Lenny', 'apt-get install debian-keyring'), |
298 | (11, 1, 1, 7, 3, 2, 4, 0, 'Volatile', 'Непостоянные обновления для Lenny', 'apt-get install debian-keyring'), |
299 | (12, 1, 1, 13, 7, 1, 1, 0, 'Jaunty Base', 'Базовый репозиторий Jaunty Jackalope', ''), |
299 | (12, 1, 1, 13, 7, 1, 1, 0, 'Jaunty Base', 'Базовый репозиторий Jaunty Jackalope', ''), |
300 | (13, 1, 1, 1, 13, 1, 1, 0, 'Sid Base', 'Базовый репозиторий', ''), |
300 | (13, 1, 1, 1, 13, 1, 1, 0, 'Sid Base', 'Базовый репозиторий', ''), |
301 | (14, 1, 1, 1, 3, 2, 2, 0, 'Updates', 'Предлагаемые обновления', 'apt-get install debian-keyring'), |
301 | (14, 1, 1, 1, 3, 2, 2, 0, 'Updates', 'Предлагаемые обновления', 'apt-get install debian-keyring'), |
302 | (15, 1, 1, 3, 3, 3, 1, 0, 'Multimedia', 'Мультимедийное ПО и набор кодеков', ''), |
302 | (15, 1, 1, 3, 3, 3, 1, 0, 'Multimedia', 'Мультимедийное ПО и набор кодеков', ''), |
303 | (16, 1, 1, 7, 3, 2, 5, 0, 'Volatile-sloppy', 'Непостоянные обновления для Lenny', 'apt-get install debian-keyring'), |
303 | (16, 1, 1, 7, 3, 2, 5, 0, 'Volatile-sloppy', 'Непостоянные обновления для Lenny', 'apt-get install debian-keyring'), |
304 | (17, 1, 1, 8, 3, 3, 1, 0, 'WineHQ', 'Репозиторий с WineHQ', ''), |
304 | (17, 1, 1, 8, 3, 3, 1, 0, 'WineHQ', 'Репозиторий с WineHQ', ''), |
305 | (18, 1, 1, 5, 3, 3, 1, 0, 'Opera', 'Репозиторий с браузером Opera', 'wget -O - http://deb.opera.com/archive.key | apt-key add -'), |
305 | (18, 1, 1, 5, 3, 3, 1, 0, 'Opera', 'Репозиторий с браузером Opera', 'wget -O - http://deb.opera.com/archive.key | apt-key add -'), |
306 | (19, 1, 1, 4, 3, 3, 1, 0, 'Opera Beta', 'Репозиторий с бета-версиями браузера Opera', 'wget -O - http://deb.opera.com/archive.key | apt-key add -'), |
306 | (19, 1, 1, 4, 3, 3, 1, 0, 'Opera Beta', 'Репозиторий с бета-версиями браузера Opera', 'wget -O - http://deb.opera.com/archive.key | apt-key add -'), |
307 | (20, 1, 1, 9, 3, 3, 1, 0, 'gfoss', 'Репозиторий с ГИС', ''), |
307 | (20, 1, 1, 9, 3, 3, 1, 0, 'gfoss', 'Репозиторий с ГИС', ''), |
308 | (21, 1, 1, 10, 3, 3, 1, 0, '2GIS', 'Репозиторий с 2GIS', ''), |
308 | (21, 1, 1, 10, 3, 3, 1, 0, '2GIS', 'Репозиторий с 2GIS', ''), |
309 | (22, 1, 1, 18, 14, 1, 1, 0, 'InfraLinux 8.10 Base', 'базовый репозиторий', ''), |
309 | (22, 1, 1, 18, 14, 1, 1, 0, 'InfraLinux 8.10 Base', 'базовый репозиторий', ''), |
310 | (23, 1, 1, 18, 14, 2, 8, 0, 'Security', 'Обновления безопасности', ''), |
310 | (23, 1, 1, 18, 14, 2, 8, 0, 'Security', 'Обновления безопасности', ''), |
311 | (24, 1, 1, 18, 14, 2, 7, 0, 'Updates', 'Предлагаемые обновления', ''), |
311 | (24, 1, 1, 18, 14, 2, 7, 0, 'Updates', 'Предлагаемые обновления', ''), |
312 | (25, 1, 1, 18, 14, 2, 6, 0, 'Backports', 'Официально неподдерживаемые обновления', ''), |
312 | (25, 1, 1, 18, 14, 2, 6, 0, 'Backports', 'Официально неподдерживаемые обновления', ''), |
313 | (26, 1, 1, 12, 3, 3, 1, 0, 'VirtualBox', 'Репозиторий с Sun Microsystems VirtualBox', ''), |
313 | (26, 1, 1, 12, 3, 3, 1, 0, 'VirtualBox', 'Репозиторий с Sun Microsystems VirtualBox', ''), |
314 | (27, 1, 7, 22, 12, 1, 11, 2, 'Master Base', 'Базовый репозиторий', ''), |
314 | (27, 1, 7, 22, 12, 1, 11, 2, 'Master Base', 'Базовый репозиторий', ''), |
315 | (28, 1, 7, 22, 12, 2, 11, 3, 'Security', 'Обновления безопасности', ''); |
315 | (28, 1, 7, 22, 12, 2, 11, 3, 'Security', 'Обновления безопасности', ''); |
316 | 316 | ||
317 | -- --------------------------------------------------------
|
317 | -- --------------------------------------------------------
|
318 | 318 | ||
319 | --
|
319 | --
|
320 | -- Структура таблицы `g_repscheme`
|
320 | -- Структура таблицы `g_repscheme`
|
321 | --
|
321 | --
|
322 | 322 | ||
323 | DROP TABLE IF EXISTS `g_repscheme`; |
323 | DROP TABLE IF EXISTS `g_repscheme`; |
324 | CREATE TABLE IF NOT EXISTS `g_repscheme` ( |
324 | CREATE TABLE IF NOT EXISTS `g_repscheme` ( |
325 | `scheme_id` INT(2) NOT NULL AUTO_INCREMENT, |
325 | `scheme_id` INT(2) NOT NULL AUTO_INCREMENT, |
326 | `scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
326 | `scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
327 | PRIMARY KEY (`scheme_id`), |
327 | PRIMARY KEY (`scheme_id`), |
328 | KEY `scheme` (`scheme`) |
328 | KEY `scheme` (`scheme`) |
329 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ; |
329 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ; |
330 | 330 | ||
331 | --
|
331 | --
|
332 | -- Дамп данных таблицы `g_repscheme`
|
332 | -- Дамп данных таблицы `g_repscheme`
|
333 | --
|
333 | --
|
334 | 334 | ||
335 | INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES |
335 | INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES |
336 | (1, '{DIST}'), |
336 | (1, '{DIST}'), |
337 | (2, '{DIST}-proposed-updates'), |
337 | (2, '{DIST}-proposed-updates'), |
338 | (3, '{DIST}/updates'), |
338 | (3, '{DIST}/updates'), |
339 | (4, '{DIST}/volatile'), |
339 | (4, '{DIST}/volatile'), |
340 | (5, '{DIST}/volatile-sloppy'), |
340 | (5, '{DIST}/volatile-sloppy'), |
341 | (6, '{DIST}-backports'), |
341 | (6, '{DIST}-backports'), |
342 | (7, '{DIST}-updates'), |
342 | (7, '{DIST}-updates'), |
343 | (8, '{DIST}-security'), |
343 | (8, '{DIST}-security'), |
344 | (9, 'noarch'), |
344 | (9, 'noarch'), |
345 | (10, 'x86_64'), |
345 | (10, 'x86_64'), |
346 | (11, 'i586'), |
346 | (11, 'i586'), |
347 | (12, 'x86_32'); |
347 | (12, 'x86_32'); |
348 | 348 | ||
349 | -- --------------------------------------------------------
|
349 | -- --------------------------------------------------------
|
350 | 350 | ||
351 | --
|
351 | --
|
352 | -- Структура таблицы `g_rtype`
|
352 | -- Структура таблицы `g_rtype`
|
353 | --
|
353 | --
|
354 | 354 | ||
355 | DROP TABLE IF EXISTS `g_rtype`; |
355 | DROP TABLE IF EXISTS `g_rtype`; |
356 | CREATE TABLE IF NOT EXISTS `g_rtype` ( |
356 | CREATE TABLE IF NOT EXISTS `g_rtype` ( |
357 | `rtype_id` INT(2) NOT NULL AUTO_INCREMENT, |
357 | `rtype_id` INT(2) NOT NULL AUTO_INCREMENT, |
358 | `rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
358 | `rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
359 | PRIMARY KEY (`rtype_id`) |
359 | PRIMARY KEY (`rtype_id`) |
360 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ; |
360 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ; |
361 | 361 | ||
362 | --
|
362 | --
|
363 | -- Дамп данных таблицы `g_rtype`
|
363 | -- Дамп данных таблицы `g_rtype`
|
364 | --
|
364 | --
|
365 | 365 | ||
366 | INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES |
366 | INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES |
367 | (1, 'Базовый репозиторий'), |
367 | (1, 'Базовый репозиторий'), |
368 | (2, 'Обновления'), |
368 | (2, 'Обновления'), |
369 | (3, 'Репозитории 3-х лиц'), |
369 | (3, 'Репозитории 3-х лиц'), |
370 | (4, 'Репозитории партнеров'); |
370 | (4, 'Репозитории партнеров'); |
371 | 371 | ||
372 | -- --------------------------------------------------------
|
372 | -- --------------------------------------------------------
|
373 | 373 | ||
374 | --
|
374 | --
|
375 | -- Структура таблицы `g_sect2rep`
|
375 | -- Структура таблицы `g_sect2rep`
|
376 | --
|
376 | --
|
377 | 377 | ||
378 | DROP TABLE IF EXISTS `g_sect2rep`; |
378 | DROP TABLE IF EXISTS `g_sect2rep`; |
379 | CREATE TABLE IF NOT EXISTS `g_sect2rep` ( |
379 | CREATE TABLE IF NOT EXISTS `g_sect2rep` ( |
380 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
380 | `id` INT(5) NOT NULL AUTO_INCREMENT, |
381 | `sect_id` INT(2) NOT NULL, |
381 | `sect_id` INT(2) NOT NULL, |
382 | `rep_id` INT(5) NOT NULL, |
382 | `rep_id` INT(5) NOT NULL, |
383 | PRIMARY KEY (`id`), |
383 | PRIMARY KEY (`id`), |
384 | KEY `sect_id` (`sect_id`,`rep_id`) |
384 | KEY `sect_id` (`sect_id`,`rep_id`) |
385 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ; |
385 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ; |
386 | 386 | ||
387 | --
|
387 | --
|
388 | -- Дамп данных таблицы `g_sect2rep`
|
388 | -- Дамп данных таблицы `g_sect2rep`
|
389 | --
|
389 | --
|
390 | 390 | ||
391 | INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES |
391 | INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES |
392 | (119, 3, 9), |
392 | (119, 3, 9), |
393 | (118, 2, 9), |
393 | (118, 2, 9), |
394 | (117, 1, 9), |
394 | (117, 1, 9), |
395 | (116, 3, 8), |
395 | (116, 3, 8), |
396 | (115, 2, 8), |
396 | (115, 2, 8), |
397 | (114, 1, 8), |
397 | (114, 1, 8), |
398 | (46, 10, 7), |
398 | (46, 10, 7), |
399 | (45, 9, 7), |
399 | (45, 9, 7), |
400 | (44, 8, 7), |
400 | (44, 8, 7), |
401 | (43, 8, 6), |
401 | (43, 8, 6), |
402 | (42, 9, 6), |
402 | (42, 9, 6), |
403 | (41, 10, 6), |
403 | (41, 10, 6), |
404 | (85, 3, 5), |
404 | (85, 3, 5), |
405 | (84, 2, 5), |
405 | (84, 2, 5), |
406 | (83, 1, 5), |
406 | (83, 1, 5), |
407 | (16, 1, 2), |
407 | (16, 1, 2), |
408 | (17, 2, 2), |
408 | (17, 2, 2), |
409 | (18, 3, 2), |
409 | (18, 3, 2), |
410 | (19, 1, 3), |
410 | (19, 1, 3), |
411 | (20, 2, 3), |
411 | (20, 2, 3), |
412 | (21, 3, 3), |
412 | (21, 3, 3), |
413 | (22, 3, 4), |
413 | (22, 3, 4), |
414 | (131, 3, 10), |
414 | (131, 3, 10), |
415 | (130, 2, 10), |
415 | (130, 2, 10), |
416 | (129, 1, 10), |
416 | (129, 1, 10), |
417 | (122, 3, 11), |
417 | (122, 3, 11), |
418 | (121, 2, 11), |
418 | (121, 2, 11), |
419 | (120, 1, 11), |
419 | (120, 1, 11), |
420 | (65, 1, 12), |
420 | (65, 1, 12), |
421 | (66, 4, 12), |
421 | (66, 4, 12), |
422 | (67, 5, 12), |
422 | (67, 5, 12), |
423 | (68, 6, 12), |
423 | (68, 6, 12), |
424 | (69, 1, 13), |
424 | (69, 1, 13), |
425 | (70, 2, 13), |
425 | (70, 2, 13), |
426 | (71, 3, 13), |
426 | (71, 3, 13), |
427 | (125, 3, 14), |
427 | (125, 3, 14), |
428 | (124, 2, 14), |
428 | (124, 2, 14), |
429 | (123, 1, 14), |
429 | (123, 1, 14), |
430 | (75, 1, 15), |
430 | (75, 1, 15), |
431 | (128, 3, 16), |
431 | (128, 3, 16), |
432 | (127, 2, 16), |
432 | (127, 2, 16), |
433 | (126, 1, 16), |
433 | (126, 1, 16), |
434 | (79, 1, 17), |
434 | (79, 1, 17), |
435 | (132, 3, 18), |
435 | (132, 3, 18), |
436 | (133, 3, 19), |
436 | (133, 3, 19), |
437 | (82, 1, 20), |
437 | (82, 1, 20), |
438 | (86, 3, 21), |
438 | (86, 3, 21), |
439 | (93, 1, 22), |
439 | (93, 1, 22), |
440 | (94, 4, 22), |
440 | (94, 4, 22), |
441 | (95, 5, 22), |
441 | (95, 5, 22), |
442 | (96, 6, 22), |
442 | (96, 6, 22), |
443 | (112, 6, 23), |
443 | (112, 6, 23), |
444 | (111, 5, 23), |
444 | (111, 5, 23), |
445 | (110, 4, 23), |
445 | (110, 4, 23), |
446 | (109, 1, 23), |
446 | (109, 1, 23), |
447 | (101, 1, 24), |
447 | (101, 1, 24), |
448 | (102, 4, 24), |
448 | (102, 4, 24), |
449 | (103, 5, 24), |
449 | (103, 5, 24), |
450 | (104, 6, 24), |
450 | (104, 6, 24), |
451 | (105, 1, 25), |
451 | (105, 1, 25), |
452 | (106, 4, 25), |
452 | (106, 4, 25), |
453 | (107, 5, 25), |
453 | (107, 5, 25), |
454 | (108, 6, 25), |
454 | (108, 6, 25), |
455 | (113, 1, 26), |
455 | (113, 1, 26), |
456 | (134, 11, 27), |
456 | (134, 11, 27), |
457 | (136, 13, 28); |
457 | (136, 13, 28); |
458 | 458 | ||
459 | -- --------------------------------------------------------
|
459 | -- --------------------------------------------------------
|
460 | 460 | ||
461 | --
|
461 | --
|
462 | -- Структура таблицы `g_section`
|
462 | -- Структура таблицы `g_section`
|
463 | --
|
463 | --
|
464 | 464 | ||
465 | DROP TABLE IF EXISTS `g_section`; |
465 | DROP TABLE IF EXISTS `g_section`; |
466 | CREATE TABLE IF NOT EXISTS `g_section` ( |
466 | CREATE TABLE IF NOT EXISTS `g_section` ( |
467 | `sect_id` INT(2) NOT NULL AUTO_INCREMENT, |
467 | `sect_id` INT(2) NOT NULL AUTO_INCREMENT, |
468 | `secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
468 | `secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
469 | `sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL, |
469 | `sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL, |
470 | PRIMARY KEY (`sect_id`), |
470 | PRIMARY KEY (`sect_id`), |
471 | KEY `secname` (`secname`) |
471 | KEY `secname` (`secname`) |
472 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=15 ; |
472 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=15 ; |
473 | 473 | ||
474 | --
|
474 | --
|
475 | -- Дамп данных таблицы `g_section`
|
475 | -- Дамп данных таблицы `g_section`
|
476 | --
|
476 | --
|
477 | 477 | ||
478 | INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES |
478 | INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES |
479 | (1, 'main', 'раздел со свободными пакетами'), |
479 | (1, 'main', 'раздел со свободными пакетами'), |
480 | (2, 'contrib', 'раздел со свободными пакетами, зависимыми от несвободных'), |
480 | (2, 'contrib', 'раздел со свободными пакетами, зависимыми от несвободных'), |
481 | (3, 'non-free', 'раздел с несвободными пакетами'), |
481 | (3, 'non-free', 'раздел с несвободными пакетами'), |
482 | (4, 'restricted', 'поддерживаемое ПО доступное под не полностью свободными лицензиями'), |
482 | (4, 'restricted', 'поддерживаемое ПО доступное под не полностью свободными лицензиями'), |
483 | (5, 'universe', 'поддерживемое сообществом ПО'), |
483 | (5, 'universe', 'поддерживемое сообществом ПО'), |
484 | (6, 'multiverse', 'несвободное ПО'), |
484 | (6, 'multiverse', 'несвободное ПО'), |
485 | (7, 'partner', ''), |
485 | (7, 'partner', ''), |
486 | (8, 'unofficial', 'раздел с неофициальными пакетами'), |
486 | (8, 'unofficial', 'раздел с неофициальными пакетами'), |
487 | (9, 'astro', 'раздел с пакетами астрономических программ'), |
487 | (9, 'astro', 'раздел с пакетами астрономических программ'), |
488 | (10, 'altspa', 'раздел пакетов для АлтГПА'), |
488 | (10, 'altspa', 'раздел пакетов для АлтГПА'), |
489 | (11, 'classic', ''), |
489 | (11, 'classic', ''), |
490 | (12, 'daedalus', ''), |
490 | (12, 'daedalus', ''), |
491 | (13, 'updates', ''), |
491 | (13, 'updates', ''), |
492 | (14, 'backports', ''); |
492 | (14, 'backports', ''); |
493 | 493 | ||
494 | -- --------------------------------------------------------
|
494 | -- --------------------------------------------------------
|
495 | 495 | ||
496 | --
|
496 | --
|
497 | -- Структура таблицы `g_settings`
|
497 | -- Структура таблицы `g_settings`
|
498 | --
|
498 | --
|
499 | 499 | ||
500 | DROP TABLE IF EXISTS `g_settings`; |
500 | DROP TABLE IF EXISTS `g_settings`; |
501 | CREATE TABLE IF NOT EXISTS `g_settings` ( |
501 | CREATE TABLE IF NOT EXISTS `g_settings` ( |
502 | `opt_id` INT(2) NOT NULL AUTO_INCREMENT, |
502 | `opt_id` INT(2) NOT NULL AUTO_INCREMENT, |
503 | `opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
503 | `opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
504 | `optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
504 | `optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL, |
505 | PRIMARY KEY (`opt_id`), |
505 | PRIMARY KEY (`opt_id`), |
506 | KEY `opt` (`opt`) |
506 | KEY `opt` (`opt`) |
507 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=6 ; |
507 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=6 ; |
508 | 508 | ||
509 | --
|
509 | --
|
510 | -- Дамп данных таблицы `g_settings`
|
510 | -- Дамп данных таблицы `g_settings`
|
511 | --
|
511 | --
|
512 | 512 | ||
513 | INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES |
513 | INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES |
514 | (1, 'codename', 'ant'), |
514 | (1, 'codename', 'ant-ng'), |
515 | (2, 'version', '0.9.1'), |
515 | (2, 'version', '0.9.1'), |
516 | (5, 'description', 'Генератор sources.list для apt-дистрибутивов Linux'), |
516 | (5, 'description', 'Генератор sources.list для apt-дистрибутивов Linux'), |
517 | (4, 'passwd', 'b5c5bd7428b6509b5235953ad7aaae12'); |
517 | (4, 'passwd', 'b5c5bd7428b6509b5235953ad7aaae12'); |
518 | 518 | ||
519 | -- --------------------------------------------------------
|
519 | -- --------------------------------------------------------
|
520 | 520 | ||
521 | --
|
521 | --
|
522 | -- Структура таблицы `g_signs`
|
522 | -- Структура таблицы `g_signs`
|
523 | --
|
523 | --
|
524 | 524 | ||
525 | DROP TABLE IF EXISTS `g_signs`; |
525 | DROP TABLE IF EXISTS `g_signs`; |
526 | CREATE TABLE IF NOT EXISTS `g_signs` ( |
526 | CREATE TABLE IF NOT EXISTS `g_signs` ( |
527 | `sign_id` INT(3) NOT NULL AUTO_INCREMENT, |
527 | `sign_id` INT(3) NOT NULL AUTO_INCREMENT, |
528 | `sname` VARCHAR(25) NOT NULL, |
528 | `sname` VARCHAR(25) NOT NULL, |
529 | `sinfo` VARCHAR(150) NOT NULL, |
529 | `sinfo` VARCHAR(150) NOT NULL, |
530 | PRIMARY KEY (`sign_id`) |
530 | PRIMARY KEY (`sign_id`) |
531 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ; |
531 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ; |
532 | 532 | ||
533 | --
|
533 | --
|
534 | -- Дамп данных таблицы `g_signs`
|
534 | -- Дамп данных таблицы `g_signs`
|
535 | --
|
535 | --
|
536 | 536 | ||
537 | INSERT INTO `g_signs` (`sign_id`, `sname`, `sinfo`) VALUES |
537 | INSERT INTO `g_signs` (`sign_id`, `sname`, `sinfo`) VALUES |
538 | (1, 'alt', ''), |
538 | (1, 'alt', ''), |
539 | (2, 'p5', 'Пятая платформа'), |
539 | (2, 'p5', 'Пятая платформа'), |
540 | (3, 'updates', 'Обновления'), |
540 | (3, 'updates', 'Обновления'), |
541 | (4, 'backports', 'Бэкпортированые пакеты'), |
541 | (4, 'backports', 'Бэкпортированые пакеты'), |
542 | (5, 'school', 'Школьные'); |
542 | (5, 'school', 'Школьные'); |
543 | 543 | ||
544 | -- --------------------------------------------------------
|
544 | -- --------------------------------------------------------
|
545 | 545 | ||
546 | --
|
546 | --
|
547 | -- Структура таблицы `g_version`
|
547 | -- Структура таблицы `g_version`
|
548 | --
|
548 | --
|
549 | 549 | ||
550 | DROP TABLE IF EXISTS `g_version`; |
550 | DROP TABLE IF EXISTS `g_version`; |
551 | CREATE TABLE IF NOT EXISTS `g_version` ( |
551 | CREATE TABLE IF NOT EXISTS `g_version` ( |
552 | `version_id` INT(5) NOT NULL AUTO_INCREMENT, |
552 | `version_id` INT(5) NOT NULL AUTO_INCREMENT, |
553 | `dist_id` INT(5) NOT NULL, |
553 | `dist_id` INT(5) NOT NULL, |
554 | `vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
554 | `vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
555 | `version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
555 | `version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
556 | `vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
556 | `vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL, |
557 | PRIMARY KEY (`version_id`), |
557 | PRIMARY KEY (`version_id`), |
558 | KEY `dist_id` (`dist_id`) |
558 | KEY `dist_id` (`dist_id`) |
559 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ; |
559 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ; |
560 | 560 | ||
561 | --
|
561 | --
|
562 | -- Дамп данных таблицы `g_version`
|
562 | -- Дамп данных таблицы `g_version`
|
563 | --
|
563 | --
|
564 | 564 | ||
565 | INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES |
565 | INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES |
566 | (1, 1, 'Sarge', '3.1', 'sarge'), |
566 | (1, 1, 'Sarge', '3.1', 'sarge'), |
567 | (2, 1, 'Etch', '4.0', 'etch'), |
567 | (2, 1, 'Etch', '4.0', 'etch'), |
568 | (3, 1, 'Lenny', '5.0', 'lenny'), |
568 | (3, 1, 'Lenny', '5.0', 'lenny'), |
569 | (4, 1, 'Squeeze', '6.0', 'squeeze'), |
569 | (4, 1, 'Squeeze', '6.0', 'squeeze'), |
570 | (5, 2, 'Hardy Heron', '8.04', 'hardy'), |
570 | (5, 2, 'Hardy Heron', '8.04', 'hardy'), |
571 | (6, 2, 'Intrepid Ibex', '8.10', 'intrepid'), |
571 | (6, 2, 'Intrepid Ibex', '8.10', 'intrepid'), |
572 | (7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'), |
572 | (7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'), |
573 | (8, 2, 'Karmic Koala', '9.10', 'karmic'), |
573 | (8, 2, 'Karmic Koala', '9.10', 'karmic'), |
574 | (12, 5, 'Школьный Мастер', '5.0', 'master'), |
574 | (12, 5, 'Школьный Мастер', '5.0', 'master'), |
575 | (11, 5, 'Ark', '5.0', 'ark'), |
575 | (11, 5, 'Ark', '5.0', 'ark'), |
576 | (13, 1, 'Sid', '', 'sid'), |
576 | (13, 1, 'Sid', '', 'sid'), |
577 | (14, 6, 'Intrepid Ibex', '8.10', 'intrepid'), |
577 | (14, 6, 'Intrepid Ibex', '8.10', 'intrepid'), |
578 | (15, 6, 'Jaunty Jackalope', '9.04', 'jaunty'), |
578 | (15, 6, 'Jaunty Jackalope', '9.04', 'jaunty'), |
579 | (16, 6, 'Karmic Koala', '9.10', 'karmic'); |
579 | (16, 6, 'Karmic Koala', '9.10', 'karmic'); |
580 | 580 |