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


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

Редакция 306		Редакция 327
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	-- Время создания: Окт 14 2009 г., 17:08	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_host2net`	-
86	--	-
87		-
88	DROP TABLE IF EXISTS `g_host2net`;	-
89	CREATE TABLE IF NOT EXISTS `g_host2net` (	-
90	`id` INT(5) NOT NULL AUTO_INCREMENT,	-
91	`rhost_id` INT(3) NOT NULL,	-
92	`nb_id` INT(2) NOT NULL,	-
93	PRIMARY KEY (`id`),	-
94	KEY `rhost_id` (`rhost_id`)	-
95	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts into network block' AUTO_INCREMENT=3 ;	-
96		-
97	-- --------------------------------------------------------	-
98		-
99	--	-
100	-- Структура таблицы `g_netblock`	-
101	--	-
102		-
103	DROP TABLE IF EXISTS `g_netblock`;	-
104	CREATE TABLE IF NOT EXISTS `g_netblock` (	-
105	`nb_id` INT(2) NOT NULL AUTO_INCREMENT,	-
106	`netblock` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	-
107	PRIMARY KEY (`nb_id`)	-
108	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Network blocks' AUTO_INCREMENT=3 ;	-
109		-
110	-- --------------------------------------------------------	-
111		-
112	--	-
113	-- Структура таблицы `g_protos`	85	-- Структура таблицы `g_protos`
114	--	86	--
115		87
116	DROP TABLE IF EXISTS `g_protos`;	88	DROP TABLE IF EXISTS `g_protos`;
117	CREATE TABLE IF NOT EXISTS `g_protos` (	89	CREATE TABLE IF NOT EXISTS `g_protos` (
118	`proto_id` INT(1) NOT NULL AUTO_INCREMENT,	90	`proto_id` INT(1) NOT NULL AUTO_INCREMENT,
119	`proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	91	`proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
120	PRIMARY KEY (`proto_id`),	92	PRIMARY KEY (`proto_id`),
121	KEY `proto` (`proto`)	93	KEY `proto` (`proto`)
122	) 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 ;
123		95
124	-- --------------------------------------------------------	96	-- --------------------------------------------------------
125		97
126	--	98	--
127	-- Структура таблицы `g_repfolder`	99	-- Структура таблицы `g_repfolder`
128	--	100	--
129		101
130	DROP TABLE IF EXISTS `g_repfolder`;	102	DROP TABLE IF EXISTS `g_repfolder`;
131	CREATE TABLE IF NOT EXISTS `g_repfolder` (	103	CREATE TABLE IF NOT EXISTS `g_repfolder` (
132	`rfolder_id` INT(5) NOT NULL AUTO_INCREMENT,	104	`rfolder_id` INT(5) NOT NULL AUTO_INCREMENT,
133	`rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,	105	`rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
134	PRIMARY KEY (`rfolder_id`),	106	PRIMARY KEY (`rfolder_id`),
135	KEY `rhost_id` (`rfolder`)	107	KEY `rhost_id` (`rfolder`)
136	) 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 ;
137		109
138	-- --------------------------------------------------------	110	-- --------------------------------------------------------
139		111
140	--	112	--
141	-- Структура таблицы `g_rephost`	113	-- Структура таблицы `g_rephost`
142	--	114	--
143		115
144	DROP TABLE IF EXISTS `g_rephost`;	116	DROP TABLE IF EXISTS `g_rephost`;
145	CREATE TABLE IF NOT EXISTS `g_rephost` (	117	CREATE TABLE IF NOT EXISTS `g_rephost` (
146	`rhost_id` INT(3) NOT NULL AUTO_INCREMENT,	118	`rhost_id` INT(3) NOT NULL AUTO_INCREMENT,
147	`rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,	119	`rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
148	PRIMARY KEY (`rhost_id`),	120	PRIMARY KEY (`rhost_id`),
149	KEY `proto_id` (`rhost`)	121	KEY `proto_id` (`rhost`)
150	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=3 ;	122	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ;
151		123
152	-- --------------------------------------------------------	124	-- --------------------------------------------------------
153		125
154	--	126	--
155	-- Структура таблицы `g_repository`	127	-- Структура таблицы `g_repository`
156	--	128	--
157		129
158	DROP TABLE IF EXISTS `g_repository`;	130	DROP TABLE IF EXISTS `g_repository`;
159	CREATE TABLE IF NOT EXISTS `g_repository` (	131	CREATE TABLE IF NOT EXISTS `g_repository` (
160	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,	132	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,
161	`proto_id` INT(1) NOT NULL,	133	`proto_id` INT(1) NOT NULL,
162	`rhost_id` INT(3) NOT NULL,	134	`rhost_id` INT(3) NOT NULL,
163	`rfolder_id` INT(5) NOT NULL,	135	`rfolder_id` INT(5) NOT NULL,
164	`version` INT(5) NOT NULL,	136	`version` INT(5) NOT NULL,
165	`rtype_id` INT(2) NOT NULL,	137	`rtype_id` INT(2) NOT NULL,
166	`scheme_id` INT(2) NOT NULL,	138	`scheme_id` INT(2) NOT NULL,
-		139	`repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
167	`repinfo` text COLLATE utf8_unicode_ci NOT NULL,	140	`repinfo` text COLLATE utf8_unicode_ci NOT NULL,
168	`repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,	141	`repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
169	PRIMARY KEY (`rep_id`),	142	PRIMARY KEY (`rep_id`),
170	KEY `proto_id` (`proto_id`),	143	KEY `proto_id` (`proto_id`),
171	KEY `rhost_id` (`rhost_id`),	144	KEY `rhost_id` (`rhost_id`),
172	KEY `rfolder_id` (`rfolder_id`),	145	KEY `rfolder_id` (`rfolder_id`),
173	KEY `version` (`version`),	146	KEY `version` (`version`),
174	KEY `rtype_id` (`rtype_id`),	147	KEY `rtype_id` (`rtype_id`),
175	KEY `scheme_id` (`scheme_id`)	148	KEY `scheme_id` (`scheme_id`)
176	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=1 ;	149	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ;
177		150
178	-- --------------------------------------------------------	151	-- --------------------------------------------------------
179		152
180	--	153	--
181	-- Структура таблицы `g_repscheme`	154	-- Структура таблицы `g_repscheme`
182	--	155	--
183		156
184	DROP TABLE IF EXISTS `g_repscheme`;	157	DROP TABLE IF EXISTS `g_repscheme`;
185	CREATE TABLE IF NOT EXISTS `g_repscheme` (	158	CREATE TABLE IF NOT EXISTS `g_repscheme` (
186	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,	159	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,
187	`scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	160	`scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
188	PRIMARY KEY (`scheme_id`),	161	PRIMARY KEY (`scheme_id`),
189	KEY `scheme` (`scheme`)	162	KEY `scheme` (`scheme`)
190	) 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 ;
191		164
192	-- --------------------------------------------------------	165	-- --------------------------------------------------------
193		166
194	--	167	--
195	-- Структура таблицы `g_rtype`	168	-- Структура таблицы `g_rtype`
196	--	169	--
197		170
198	DROP TABLE IF EXISTS `g_rtype`;	171	DROP TABLE IF EXISTS `g_rtype`;
199	CREATE TABLE IF NOT EXISTS `g_rtype` (	172	CREATE TABLE IF NOT EXISTS `g_rtype` (
200	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,	173	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,
201	`rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	174	`rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
202	PRIMARY KEY (`rtype_id`)	175	PRIMARY KEY (`rtype_id`)
203	) 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 ;
204		177
205	-- --------------------------------------------------------	178	-- --------------------------------------------------------
206		179
207	--	180	--
208	-- Структура таблицы `g_sect2rep`	181	-- Структура таблицы `g_sect2rep`
209	--	182	--
210		183
211	DROP TABLE IF EXISTS `g_sect2rep`;	184	DROP TABLE IF EXISTS `g_sect2rep`;
212	CREATE TABLE IF NOT EXISTS `g_sect2rep` (	185	CREATE TABLE IF NOT EXISTS `g_sect2rep` (
213	`id` INT(5) NOT NULL AUTO_INCREMENT,	186	`id` INT(5) NOT NULL AUTO_INCREMENT,
214	`sect_id` INT(2) NOT NULL,	187	`sect_id` INT(2) NOT NULL,
215	`rep_id` INT(5) NOT NULL,	188	`rep_id` INT(5) NOT NULL,
216	PRIMARY KEY (`id`),	189	PRIMARY KEY (`id`),
217	KEY `sect_id` (`sect_id`,`rep_id`)	190	KEY `sect_id` (`sect_id`,`rep_id`)
218	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=1 ;	191	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ;
219		192
220	-- --------------------------------------------------------	193	-- --------------------------------------------------------
221		194
222	--	195	--
223	-- Структура таблицы `g_section`	196	-- Структура таблицы `g_section`
224	--	197	--
225		198
226	DROP TABLE IF EXISTS `g_section`;	199	DROP TABLE IF EXISTS `g_section`;
227	CREATE TABLE IF NOT EXISTS `g_section` (	200	CREATE TABLE IF NOT EXISTS `g_section` (
228	`sect_id` INT(2) NOT NULL AUTO_INCREMENT,	201	`sect_id` INT(2) NOT NULL AUTO_INCREMENT,
229	`secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	202	`secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
230	`sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,	203	`sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,
231	PRIMARY KEY (`sect_id`),	204	PRIMARY KEY (`sect_id`),
232	KEY `secname` (`secname`)	205	KEY `secname` (`secname`)
233	) 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 ;
234		207
235	-- --------------------------------------------------------	208	-- --------------------------------------------------------
236		209
237	--	210	--
238	-- Структура таблицы `g_settings`	211	-- Структура таблицы `g_settings`
239	--	212	--
240		213
241	DROP TABLE IF EXISTS `g_settings`;	214	DROP TABLE IF EXISTS `g_settings`;
242	CREATE TABLE IF NOT EXISTS `g_settings` (	215	CREATE TABLE IF NOT EXISTS `g_settings` (
243	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,	216	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,
244	`opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	217	`opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
245	`optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,	218	`optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
246	PRIMARY KEY (`opt_id`),	219	PRIMARY KEY (`opt_id`),
247	KEY `opt` (`opt`)	220	KEY `opt` (`opt`)
248	) 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 ;
249		222
250	-- --------------------------------------------------------	223	-- --------------------------------------------------------
251		224
252	--	225	--
253	-- Структура таблицы `g_version`	226	-- Структура таблицы `g_version`
254	--	227	--
255		228
256	DROP TABLE IF EXISTS `g_version`;	229	DROP TABLE IF EXISTS `g_version`;
257	CREATE TABLE IF NOT EXISTS `g_version` (	230	CREATE TABLE IF NOT EXISTS `g_version` (
258	`version_id` INT(5) NOT NULL AUTO_INCREMENT,	231	`version_id` INT(5) NOT NULL AUTO_INCREMENT,
259	`dist_id` INT(5) NOT NULL,	232	`dist_id` INT(5) NOT NULL,
260	`vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	233	`vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
261	`version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	234	`version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
262	`vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	235	`vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
263	PRIMARY KEY (`version_id`),	236	PRIMARY KEY (`version_id`),
264	KEY `dist_id` (`dist_id`)	237	KEY `dist_id` (`dist_id`)
265	) 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 ;
266		239