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