WebSVN - ant - Различия - Редакция 673 и 692 - /branches/ant/0.9.x/sql/generator-structure.sql


-- phpMyAdmin SQL Dump
-- version 3.0.0-alpha
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Ноя 30 2009 г., 17:25
-- Версия сервера: 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=103 ;

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

--
-- Структура таблицы `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=7 ;

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

--
-- Структура таблицы `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=23 ;

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

--
-- Структура таблицы `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=8 ;

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

--
-- Структура таблицы `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,
  `sign_id` INT(3) NOT NULL,
  `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  `repinfo` text COLLATE utf8_unicode_ci NOT NULL,
  `repkey` VARCHAR(200) 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`),
  KEY `sign_id` (`sign_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ;

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

--
-- Структура таблицы `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=13 ;

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

--
-- Структура таблицы `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=137 ;

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

--
-- Структура таблицы `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=15 ;

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

--
-- Структура таблицы `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=6 ;

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

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

DROP TABLE IF EXISTS `g_signs`;
CREATE TABLE IF NOT EXISTS `g_signs` (
  `sign_id` INT(3) NOT NULL AUTO_INCREMENT,
  `sname` VARCHAR(25) NOT NULL,
  `sinfo` VARCHAR(150) NOT NULL,
  PRIMARY KEY (`sign_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ;

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

--
-- Структура таблицы `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=17 ;
 

Хранилища Subversion ant

(root)/branches/ant/0.9.x/sql/generator-structure.sql - Редакция 673 → 692

Редакция 673		Редакция 692
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 г., 14:09	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		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=103 ;	49	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=103 ;
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=7 ;	66	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=7 ;
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=23 ;	108	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=23 ;
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=8 ;	122	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=8 ;
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	`sign_id` INT(3) NOT NULL,	139	`sign_id` INT(3) NOT NULL,
140	`repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	140	`repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
141	`repinfo` text COLLATE utf8_unicode_ci NOT NULL,	141	`repinfo` text COLLATE utf8_unicode_ci NOT NULL,
142	`repkey` VARCHAR(200) COLLATE utf8_unicode_ci NOT NULL,	142	`repkey` VARCHAR(200) COLLATE utf8_unicode_ci NOT NULL,
143	PRIMARY KEY (`rep_id`),	143	PRIMARY KEY (`rep_id`),
144	KEY `proto_id` (`proto_id`),	144	KEY `proto_id` (`proto_id`),
145	KEY `rhost_id` (`rhost_id`),	145	KEY `rhost_id` (`rhost_id`),
146	KEY `rfolder_id` (`rfolder_id`),	146	KEY `rfolder_id` (`rfolder_id`),
147	KEY `version` (`version`),	147	KEY `version` (`version`),
148	KEY `rtype_id` (`rtype_id`),	148	KEY `rtype_id` (`rtype_id`),
149	KEY `scheme_id` (`scheme_id`),	149	KEY `scheme_id` (`scheme_id`),
150	KEY `sign_id` (`sign_id`)	150	KEY `sign_id` (`sign_id`)
151	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ;	151	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ;
152		152
153	-- --------------------------------------------------------	153	-- --------------------------------------------------------
154		154
155	--	155	--
156	-- Структура таблицы `g_repscheme`	156	-- Структура таблицы `g_repscheme`
157	--	157	--
158		158
159	DROP TABLE IF EXISTS `g_repscheme`;	159	DROP TABLE IF EXISTS `g_repscheme`;
160	CREATE TABLE IF NOT EXISTS `g_repscheme` (	160	CREATE TABLE IF NOT EXISTS `g_repscheme` (
161	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,	161	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,
162	`scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	162	`scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
163	PRIMARY KEY (`scheme_id`),	163	PRIMARY KEY (`scheme_id`),
164	KEY `scheme` (`scheme`)	164	KEY `scheme` (`scheme`)
165	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ;	165	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ;
166		166
167	-- --------------------------------------------------------	167	-- --------------------------------------------------------
168		168
169	--	169	--
170	-- Структура таблицы `g_rtype`	170	-- Структура таблицы `g_rtype`
171	--	171	--
172		172
173	DROP TABLE IF EXISTS `g_rtype`;	173	DROP TABLE IF EXISTS `g_rtype`;
174	CREATE TABLE IF NOT EXISTS `g_rtype` (	174	CREATE TABLE IF NOT EXISTS `g_rtype` (
175	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,	175	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,
176	`rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	176	`rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
177	PRIMARY KEY (`rtype_id`)	177	PRIMARY KEY (`rtype_id`)
178	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ;	178	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ;
179		179
180	-- --------------------------------------------------------	180	-- --------------------------------------------------------
181		181
182	--	182	--
183	-- Структура таблицы `g_sect2rep`	183	-- Структура таблицы `g_sect2rep`
184	--	184	--
185		185
186	DROP TABLE IF EXISTS `g_sect2rep`;	186	DROP TABLE IF EXISTS `g_sect2rep`;
187	CREATE TABLE IF NOT EXISTS `g_sect2rep` (	187	CREATE TABLE IF NOT EXISTS `g_sect2rep` (
188	`id` INT(5) NOT NULL AUTO_INCREMENT,	188	`id` INT(5) NOT NULL AUTO_INCREMENT,
189	`sect_id` INT(2) NOT NULL,	189	`sect_id` INT(2) NOT NULL,
190	`rep_id` INT(5) NOT NULL,	190	`rep_id` INT(5) NOT NULL,
191	PRIMARY KEY (`id`),	191	PRIMARY KEY (`id`),
192	KEY `sect_id` (`sect_id`,`rep_id`)	192	KEY `sect_id` (`sect_id`,`rep_id`)
193	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ;	193	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ;
194		194
195	-- --------------------------------------------------------	195	-- --------------------------------------------------------
196		196
197	--	197	--
198	-- Структура таблицы `g_section`	198	-- Структура таблицы `g_section`
199	--	199	--
200		200
201	DROP TABLE IF EXISTS `g_section`;	201	DROP TABLE IF EXISTS `g_section`;
202	CREATE TABLE IF NOT EXISTS `g_section` (	202	CREATE TABLE IF NOT EXISTS `g_section` (
203	`sect_id` INT(2) NOT NULL AUTO_INCREMENT,	203	`sect_id` INT(2) NOT NULL AUTO_INCREMENT,
204	`secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	204	`secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
205	`sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,	205	`sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,
206	PRIMARY KEY (`sect_id`),	206	PRIMARY KEY (`sect_id`),
207	KEY `secname` (`secname`)	207	KEY `secname` (`secname`)
208	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=15 ;	208	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=15 ;
209		209
210	-- --------------------------------------------------------	210	-- --------------------------------------------------------
211		211
212	--	212	--
213	-- Структура таблицы `g_settings`	213	-- Структура таблицы `g_settings`
214	--	214	--
215		215
216	DROP TABLE IF EXISTS `g_settings`;	216	DROP TABLE IF EXISTS `g_settings`;
217	CREATE TABLE IF NOT EXISTS `g_settings` (	217	CREATE TABLE IF NOT EXISTS `g_settings` (
218	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,	218	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,
219	`opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	219	`opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
220	`optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,	220	`optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
221	PRIMARY KEY (`opt_id`),	221	PRIMARY KEY (`opt_id`),
222	KEY `opt` (`opt`)	222	KEY `opt` (`opt`)
223	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=6 ;	223	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=6 ;
224		224
225	-- --------------------------------------------------------	225	-- --------------------------------------------------------
226		226
227	--	227	--
228	-- Структура таблицы `g_signs`	228	-- Структура таблицы `g_signs`
229	--	229	--
230		230
231	DROP TABLE IF EXISTS `g_signs`;	231	DROP TABLE IF EXISTS `g_signs`;
232	CREATE TABLE IF NOT EXISTS `g_signs` (	232	CREATE TABLE IF NOT EXISTS `g_signs` (
233	`sign_id` INT(3) NOT NULL AUTO_INCREMENT,	233	`sign_id` INT(3) NOT NULL AUTO_INCREMENT,
234	`sname` VARCHAR(25) NOT NULL,	234	`sname` VARCHAR(25) NOT NULL,
235	`sinfo` VARCHAR(150) NOT NULL,	235	`sinfo` VARCHAR(150) NOT NULL,
236	PRIMARY KEY (`sign_id`)	236	PRIMARY KEY (`sign_id`)
237	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ;	237	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ;
238		238
239	-- --------------------------------------------------------	239	-- --------------------------------------------------------
240		240
241	--	241	--
242	-- Структура таблицы `g_version`	242	-- Структура таблицы `g_version`
243	--	243	--
244		244
245	DROP TABLE IF EXISTS `g_version`;	245	DROP TABLE IF EXISTS `g_version`;
246	CREATE TABLE IF NOT EXISTS `g_version` (	246	CREATE TABLE IF NOT EXISTS `g_version` (
247	`version_id` INT(5) NOT NULL AUTO_INCREMENT,	247	`version_id` INT(5) NOT NULL AUTO_INCREMENT,
248	`dist_id` INT(5) NOT NULL,	248	`dist_id` INT(5) NOT NULL,
249	`vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	249	`vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
250	`version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	250	`version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
251	`vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	251	`vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
252	PRIMARY KEY (`version_id`),	252	PRIMARY KEY (`version_id`),
253	KEY `dist_id` (`dist_id`)	253	KEY `dist_id` (`dist_id`)
254	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ;	254	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ;
255		255