Редакция 475 | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 475 | Редакция 555 | ||
---|---|---|---|
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 | ||
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`; |
- | |
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`) |
34 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ; |
33 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ; |
35 | 34 | ||
36 | -- --------------------------------------------------------
|
35 | -- --------------------------------------------------------
|
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`), |
48 | KEY `arch_id` (`arch_id`,`rep_id`) |
46 | KEY `arch_id` (`arch_id`,`rep_id`) |
49 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ; |
47 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ; |
50 | 48 | ||
51 | -- --------------------------------------------------------
|
49 | -- --------------------------------------------------------
|
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`) |
80 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
76 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ; |
81 | 77 | ||
82 | -- --------------------------------------------------------
|
78 | -- --------------------------------------------------------
|
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`) |
94 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ; |
89 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ; |
95 | 90 | ||
96 | -- --------------------------------------------------------
|
91 | -- --------------------------------------------------------
|
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`) |
108 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ; |
102 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ; |
109 | 103 | ||
110 | -- --------------------------------------------------------
|
104 | -- --------------------------------------------------------
|
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`) |
122 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ; |
115 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ; |
123 | 116 | ||
124 | -- --------------------------------------------------------
|
117 | -- --------------------------------------------------------
|
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, |
136 | `version` INT(5) NOT NULL, |
128 | `version` INT(5) NOT NULL, |
137 | `rtype_id` INT(2) NOT NULL, |
129 | `rtype_id` INT(2) NOT NULL, |
138 | `scheme_id` INT(2) NOT NULL, |
130 | `scheme_id` INT(2) NOT NULL, |
139 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
131 | `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL, |
140 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
132 | `repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
141 | `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL, |
133 | `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL, |
142 | PRIMARY KEY (`rep_id`), |
134 | PRIMARY KEY (`rep_id`), |
143 | KEY `proto_id` (`proto_id`), |
135 | KEY `proto_id` (`proto_id`), |
144 | KEY `rhost_id` (`rhost_id`), |
136 | KEY `rhost_id` (`rhost_id`), |
145 | KEY `rfolder_id` (`rfolder_id`), |
137 | KEY `rfolder_id` (`rfolder_id`), |
146 | KEY `version` (`version`), |
138 | KEY `version` (`version`), |
147 | KEY `rtype_id` (`rtype_id`), |
139 | KEY `rtype_id` (`rtype_id`), |
148 | KEY `scheme_id` (`scheme_id`) |
140 | KEY `scheme_id` (`scheme_id`) |
149 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ; |
141 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ; |
150 | 142 | ||
151 | -- --------------------------------------------------------
|
143 | -- --------------------------------------------------------
|
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`) |
163 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ; |
154 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ; |
164 | 155 | ||
165 | -- --------------------------------------------------------
|
156 | -- --------------------------------------------------------
|
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 ; |
177 | 167 | ||
178 | -- --------------------------------------------------------
|
168 | -- --------------------------------------------------------
|
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`), |
190 | KEY `sect_id` (`sect_id`,`rep_id`) |
179 | KEY `sect_id` (`sect_id`,`rep_id`) |
191 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
180 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
192 | 181 | ||
193 | -- --------------------------------------------------------
|
182 | -- --------------------------------------------------------
|
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 ; |
239 | 238 |