WebSVN - ant - Различия - Редакция 327 и 459


-- phpMyAdmin SQL Dump
-- version 3.0.0-alpha
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Окт 16 2009 г., 19:12
-- Версия сервера: 5.1.37
-- Версия PHP: 5.2.11-1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- База данных: `generator`
--

-- --------------------------------------------------------

--
-- Структура таблицы `g_arch`
--

DROP TABLE IF EXISTS `g_arch`;
CREATE TABLE IF NOT EXISTS `g_arch` (
  `arch_id` INT(2) NOT NULL AUTO_INCREMENT,
  `arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`arch_id`),
  KEY `arch` (`arch`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_arch2rep`
--

DROP TABLE IF EXISTS `g_arch2rep`;
CREATE TABLE IF NOT EXISTS `g_arch2rep` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  `arch_id` INT(2) NOT NULL,
  `rep_id` INT(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `arch_id` (`arch_id`,`rep_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_distribution`
--

DROP TABLE IF EXISTS `g_distribution`;
CREATE TABLE IF NOT EXISTS `g_distribution` (
  `dist_id` INT(5) NOT NULL AUTO_INCREMENT,
  `distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  `distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
  `disttype` INT(1) NOT NULL,
  `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`dist_id`),
  KEY `disttype` (`disttype`,`distlogo`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_dtype`
--

DROP TABLE IF EXISTS `g_dtype`;
CREATE TABLE IF NOT EXISTS `g_dtype` (
  `type_id` INT(1) NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`type_id`),
  KEY `type` (`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_protos`
--

DROP TABLE IF EXISTS `g_protos`;
CREATE TABLE IF NOT EXISTS `g_protos` (
  `proto_id` INT(1) NOT NULL AUTO_INCREMENT,
  `proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`proto_id`),
  KEY `proto` (`proto`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_repfolder`
--

DROP TABLE IF EXISTS `g_repfolder`;
CREATE TABLE IF NOT EXISTS `g_repfolder` (
  `rfolder_id` INT(5) NOT NULL AUTO_INCREMENT,
  `rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`rfolder_id`),
  KEY `rhost_id` (`rfolder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_rephost`
--

DROP TABLE IF EXISTS `g_rephost`;
CREATE TABLE IF NOT EXISTS `g_rephost` (
  `rhost_id` INT(3) NOT NULL AUTO_INCREMENT,
  `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`rhost_id`),
  KEY `proto_id` (`rhost`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_repository`
--

DROP TABLE IF EXISTS `g_repository`;
CREATE TABLE IF NOT EXISTS `g_repository` (
  `rep_id` INT(5) NOT NULL AUTO_INCREMENT,
  `proto_id` INT(1) NOT NULL,
  `rhost_id` INT(3) NOT NULL,
  `rfolder_id` INT(5) NOT NULL,
  `version` INT(5) NOT NULL,
  `rtype_id` INT(2) NOT NULL,
  `scheme_id` INT(2) NOT NULL,
  `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  `repinfo` text COLLATE utf8_unicode_ci NOT NULL,
  `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`rep_id`),
  KEY `proto_id` (`proto_id`),
  KEY `rhost_id` (`rhost_id`),
  KEY `rfolder_id` (`rfolder_id`),
  KEY `version` (`version`),
  KEY `rtype_id` (`rtype_id`),
  KEY `scheme_id` (`scheme_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_repscheme`
--

DROP TABLE IF EXISTS `g_repscheme`;
CREATE TABLE IF NOT EXISTS `g_repscheme` (
  `scheme_id` INT(2) NOT NULL AUTO_INCREMENT,
  `scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`scheme_id`),
  KEY `scheme` (`scheme`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_rtype`
--

DROP TABLE IF EXISTS `g_rtype`;
CREATE TABLE IF NOT EXISTS `g_rtype` (
  `rtype_id` INT(2) NOT NULL AUTO_INCREMENT,
  `rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`rtype_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_sect2rep`
--

DROP TABLE IF EXISTS `g_sect2rep`;
CREATE TABLE IF NOT EXISTS `g_sect2rep` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  `sect_id` INT(2) NOT NULL,
  `rep_id` INT(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sect_id` (`sect_id`,`rep_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_section`
--

DROP TABLE IF EXISTS `g_section`;
CREATE TABLE IF NOT EXISTS `g_section` (
  `sect_id` INT(2) NOT NULL AUTO_INCREMENT,
  `secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  `sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`sect_id`),
  KEY `secname` (`secname`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_settings`
--

DROP TABLE IF EXISTS `g_settings`;
CREATE TABLE IF NOT EXISTS `g_settings` (
  `opt_id` INT(2) NOT NULL AUTO_INCREMENT,
  `opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  `optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`opt_id`),
  KEY `opt` (`opt`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Структура таблицы `g_version`
--

DROP TABLE IF EXISTS `g_version`;
CREATE TABLE IF NOT EXISTS `g_version` (
  `version_id` INT(5) NOT NULL AUTO_INCREMENT,
  `dist_id` INT(5) NOT NULL,
  `vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  `version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
  `vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`version_id`),
  KEY `dist_id` (`dist_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=9 ;
 

Хранилища Subversion ant

(root)/trunk/sql/generator-structure.sql @ 472 - Редакция 327 → 459

Редакция 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