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


-- 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_arch`
--

INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES
(1, 'i386'),
(2, 'amd64');

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

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


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

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

INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES
(1, 'Debian GNU/Linux', 'debian', 1, '0'),
(2, 'Ubuntu Linux', 'ubuntu', 1, '0');

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

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

INSERT INTO `g_dtype` (`type_id`, `type`) VALUES
(1, 'deb'),
(2, 'rpm');

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

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

INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES
(1, 'http://');

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

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


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

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

INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES
(1, 'apt.nix-files.org.ru'),
(2, 'hyperion.uni-altai.ru'),
(3, 'apt.nix-files.uni-altai.ru');

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

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

INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `repname`, `repinfo`, `repkey`) VALUES
(1, 1, 1, 1, 1, 1, 1, 'Sarge Base', 'eeee', '');

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

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

INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES
(1, '{DIST}'),
(2, '{DIST}-proposed-updates'),
(3, '{DIST}/updates'),
(4, '{DIST}/volatile'),
(5, '{DIST}/volatile-sloppy'),
(6, '{DIST}-backports'),
(7, '{DIST}-updates'),
(8, '{DIST}-security');

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

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

INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES
(1, 'Базовый репозиторий'),
(2, 'Обновления'),
(3, 'Репозитории 3-х лиц'),
(4, 'Репозитории партнеров');

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

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

INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES
(1, 1, 1),
(2, 2, 1),
(3, 3, 1);

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

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

INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES
(1, 'main', ''),
(2, 'contrib', ''),
(3, 'non-free', ''),
(4, 'restricted', ''),
(5, 'universe', ''),
(6, 'multiverse', ''),
(7, 'partner', ''),
(8, 'unofficial', '');

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

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

INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES
(1, 'codename', 'ant-ng'),
(2, 'version', '0.1'),
(3, 'owner', 'admin'),
(4, 'passwd', '1');

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

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

--
-- Дамп данных таблицы `g_version`
--

INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES
(1, 1, 'Sarge', '3.1', 'sarge'),
(2, 1, 'Etch', '4.0', 'etch'),
(3, 1, 'Lenny', '5.0', 'lenny'),
(4, 1, 'Squeeze', '6.0', 'squeeze'),
(5, 2, 'Hardy Heron', '8.04', 'hardy'),
(6, 2, 'Intrepid Ibex', '8.10', 'intrepid'),
(7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'),
(8, 2, 'Karmic Koala', '9.10', 'karmic');
 

Редакция 306	Редакция 328
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:09	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	-- Дамп данных таблицы `g_arch`	37	-- Дамп данных таблицы `g_arch`
38	--	38	--
39		39
40	INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES	40	INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES
41	(1, 'i386'),	41	(1, 'i386'),
42	(2, 'amd64');	42	(2, 'amd64');
43		43
44	-- --------------------------------------------------------	44	-- --------------------------------------------------------
45		45
46	--	46	--
47	-- Структура таблицы `g_arch2rep`	47	-- Структура таблицы `g_arch2rep`
48	--	48	--
49		49
50	DROP TABLE IF EXISTS `g_arch2rep`;	50	DROP TABLE IF EXISTS `g_arch2rep`;
51	CREATE TABLE IF NOT EXISTS `g_arch2rep` (	51	CREATE TABLE IF NOT EXISTS `g_arch2rep` (
52	`id` INT(5) NOT NULL AUTO_INCREMENT,	52	`id` INT(5) NOT NULL AUTO_INCREMENT,
53	`arch_id` INT(2) NOT NULL,	53	`arch_id` INT(2) NOT NULL,
54	`rep_id` INT(5) NOT NULL,	54	`rep_id` INT(5) NOT NULL,
55	PRIMARY KEY (`id`),	55	PRIMARY KEY (`id`),
56	KEY `arch_id` (`arch_id`,`rep_id`)	56	KEY `arch_id` (`arch_id`,`rep_id`)
57	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ;	57	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ;
58		58
59	--	59	--
60	-- Дамп данных таблицы `g_arch2rep`	60	-- Дамп данных таблицы `g_arch2rep`
61	--	61	--
62		62
63		63
64	-- --------------------------------------------------------	64	-- --------------------------------------------------------
65		65
66	--	66	--
67	-- Структура таблицы `g_distribution`	67	-- Структура таблицы `g_distribution`
68	--	68	--
69		69
70	DROP TABLE IF EXISTS `g_distribution`;	70	DROP TABLE IF EXISTS `g_distribution`;
71	CREATE TABLE IF NOT EXISTS `g_distribution` (	71	CREATE TABLE IF NOT EXISTS `g_distribution` (
72	`dist_id` INT(5) NOT NULL AUTO_INCREMENT,	72	`dist_id` INT(5) NOT NULL AUTO_INCREMENT,
73	`distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	73	`distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
74	`distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	74	`distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
75	`disttype` INT(1) NOT NULL,	75	`disttype` INT(1) NOT NULL,
76	`distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL,	76	`distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL,
77	PRIMARY KEY (`dist_id`),	77	PRIMARY KEY (`dist_id`),
78	KEY `disttype` (`disttype`,`distlogo`)	78	KEY `disttype` (`disttype`,`distlogo`)
79	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=3 ;	79	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=3 ;
80		80
81	--	81	--
82	-- Дамп данных таблицы `g_distribution`	82	-- Дамп данных таблицы `g_distribution`
83	--	83	--
84		84
85	INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES	85	INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES
86	(1, 'Debian GNU/Linux', 'debian', 1, '0'),	86	(1, 'Debian GNU/Linux', 'debian', 1, '0'),
87	(2, 'Ubuntu Linux', 'ubuntu', 1, '0');	87	(2, 'Ubuntu Linux', 'ubuntu', 1, '0');
88		88
89	-- --------------------------------------------------------	89	-- --------------------------------------------------------
90		90
91	--	91	--
92	-- Структура таблицы `g_dtype`	92	-- Структура таблицы `g_dtype`
93	--	93	--
94		94
95	DROP TABLE IF EXISTS `g_dtype`;	95	DROP TABLE IF EXISTS `g_dtype`;
96	CREATE TABLE IF NOT EXISTS `g_dtype` (	96	CREATE TABLE IF NOT EXISTS `g_dtype` (
97	`type_id` INT(1) NOT NULL AUTO_INCREMENT,	97	`type_id` INT(1) NOT NULL AUTO_INCREMENT,
98	`type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL,	98	`type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL,
99	PRIMARY KEY (`type_id`),	99	PRIMARY KEY (`type_id`),
100	KEY `type` (`type`)	100	KEY `type` (`type`)
101	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ;	101	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ;
102		102
103	--	103	--
104	-- Дамп данных таблицы `g_dtype`	104	-- Дамп данных таблицы `g_dtype`
105	--	105	--
106		106
107	INSERT INTO `g_dtype` (`type_id`, `type`) VALUES	107	INSERT INTO `g_dtype` (`type_id`, `type`) VALUES
108	(1, 'deb'),	108	(1, 'deb'),
109	(2, 'rpm');	109	(2, 'rpm');
110		110
111	-- --------------------------------------------------------	111	-- --------------------------------------------------------
112		112
113	--	113	--
114	-- Структура таблицы `g_host2net`	-
115	--	-
116		-
117	DROP TABLE IF EXISTS `g_host2net`;	-
118	CREATE TABLE IF NOT EXISTS `g_host2net` (	-
119	`id` INT(5) NOT NULL AUTO_INCREMENT,	-
120	`rhost_id` INT(3) NOT NULL,	-
121	`nb_id` INT(2) NOT NULL,	-
122	PRIMARY KEY (`id`),	-
123	KEY `rhost_id` (`rhost_id`)	-
124	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts into network block' AUTO_INCREMENT=3 ;	-
125		-
126	--	-
127	-- Дамп данных таблицы `g_host2net`	-
128	--	-
129		-
130	INSERT INTO `g_host2net` (`id`, `rhost_id`, `nb_id`) VALUES	-
131	(1, 1, 1),	-
132	(2, 2, 1);	-
133		-
134	-- --------------------------------------------------------	-
135		-
136	--	-
137	-- Структура таблицы `g_netblock`	-
138	--	-
139		-
140	DROP TABLE IF EXISTS `g_netblock`;	-
141	CREATE TABLE IF NOT EXISTS `g_netblock` (	-
142	`nb_id` INT(2) NOT NULL AUTO_INCREMENT,	-
143	`netblock` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	-
144	PRIMARY KEY (`nb_id`)	-
145	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Network blocks' AUTO_INCREMENT=3 ;	-
146		-
147	--	-
148	-- Дамп данных таблицы `g_netblock`	-
149	--	-
150		-
151	INSERT INTO `g_netblock` (`nb_id`, `netblock`) VALUES	-
152	(1, 'AltLUG'),	-
153	(2, 'SibNET');	-
154		-
155	-- --------------------------------------------------------	-
156		-
157	--	-
158	-- Структура таблицы `g_protos`	114	-- Структура таблицы `g_protos`
159	--	115	--
160		116
161	DROP TABLE IF EXISTS `g_protos`;	117	DROP TABLE IF EXISTS `g_protos`;
162	CREATE TABLE IF NOT EXISTS `g_protos` (	118	CREATE TABLE IF NOT EXISTS `g_protos` (
163	`proto_id` INT(1) NOT NULL AUTO_INCREMENT,	119	`proto_id` INT(1) NOT NULL AUTO_INCREMENT,
164	`proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	120	`proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
165	PRIMARY KEY (`proto_id`),	121	PRIMARY KEY (`proto_id`),
166	KEY `proto` (`proto`)	122	KEY `proto` (`proto`)
167	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ;	123	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ;
168		124
169	--	125	--
170	-- Дамп данных таблицы `g_protos`	126	-- Дамп данных таблицы `g_protos`
171	--	127	--
172		128
173	INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES	129	INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES
174	(1, 'http://');	130	(1, 'http://');
175		131
176	-- --------------------------------------------------------	132	-- --------------------------------------------------------
177		133
178	--	134	--
179	-- Структура таблицы `g_repfolder`	135	-- Структура таблицы `g_repfolder`
180	--	136	--
181		137
182	DROP TABLE IF EXISTS `g_repfolder`;	138	DROP TABLE IF EXISTS `g_repfolder`;
183	CREATE TABLE IF NOT EXISTS `g_repfolder` (	139	CREATE TABLE IF NOT EXISTS `g_repfolder` (
184	`rfolder_id` INT(5) NOT NULL AUTO_INCREMENT,	140	`rfolder_id` INT(5) NOT NULL AUTO_INCREMENT,
185	`rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,	141	`rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
186	PRIMARY KEY (`rfolder_id`),	142	PRIMARY KEY (`rfolder_id`),
187	KEY `rhost_id` (`rfolder`)	143	KEY `rhost_id` (`rfolder`)
188	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ;	144	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ;
189		145
190	--	146	--
191	-- Дамп данных таблицы `g_repfolder`	147	-- Дамп данных таблицы `g_repfolder`
192	--	148	--
193		149
194		150
195	-- --------------------------------------------------------	151	-- --------------------------------------------------------
196		152
197	--	153	--
198	-- Структура таблицы `g_rephost`	154	-- Структура таблицы `g_rephost`
199	--	155	--
200		156
201	DROP TABLE IF EXISTS `g_rephost`;	157	DROP TABLE IF EXISTS `g_rephost`;
202	CREATE TABLE IF NOT EXISTS `g_rephost` (	158	CREATE TABLE IF NOT EXISTS `g_rephost` (
203	`rhost_id` INT(3) NOT NULL AUTO_INCREMENT,	159	`rhost_id` INT(3) NOT NULL AUTO_INCREMENT,
204	`rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,	160	`rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
205	PRIMARY KEY (`rhost_id`),	161	PRIMARY KEY (`rhost_id`),
206	KEY `proto_id` (`rhost`)	162	KEY `proto_id` (`rhost`)
207	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=3 ;	163	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ;
208		164
209	--	165	--
210	-- Дамп данных таблицы `g_rephost`	166	-- Дамп данных таблицы `g_rephost`
211	--	167	--
212		168
213	INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES	169	INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES
214	(1, 'apt.nix-files.org.ru'),	170	(1, 'apt.nix-files.org.ru'),
215	(2, 'hyperion.uni-altai.ru');	171	(2, 'hyperion.uni-altai.ru'),
-		172	(3, 'apt.nix-files.uni-altai.ru');
216		173
217	-- --------------------------------------------------------	174	-- --------------------------------------------------------
218		175
219	--	176	--
220	-- Структура таблицы `g_repository`	177	-- Структура таблицы `g_repository`
221	--	178	--
222		179
223	DROP TABLE IF EXISTS `g_repository`;	180	DROP TABLE IF EXISTS `g_repository`;
224	CREATE TABLE IF NOT EXISTS `g_repository` (	181	CREATE TABLE IF NOT EXISTS `g_repository` (
225	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,	182	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,
226	`proto_id` INT(1) NOT NULL,	183	`proto_id` INT(1) NOT NULL,
227	`rhost_id` INT(3) NOT NULL,	184	`rhost_id` INT(3) NOT NULL,
228	`rfolder_id` INT(5) NOT NULL,	185	`rfolder_id` INT(5) NOT NULL,
229	`version` INT(5) NOT NULL,	186	`version` INT(5) NOT NULL,
230	`rtype_id` INT(2) NOT NULL,	187	`rtype_id` INT(2) NOT NULL,
231	`scheme_id` INT(2) NOT NULL,	188	`scheme_id` INT(2) NOT NULL,
-		189	`repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
232	`repinfo` text COLLATE utf8_unicode_ci NOT NULL,	190	`repinfo` text COLLATE utf8_unicode_ci NOT NULL,
233	`repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,	191	`repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
234	PRIMARY KEY (`rep_id`),	192	PRIMARY KEY (`rep_id`),
235	KEY `proto_id` (`proto_id`),	193	KEY `proto_id` (`proto_id`),
236	KEY `rhost_id` (`rhost_id`),	194	KEY `rhost_id` (`rhost_id`),
237	KEY `rfolder_id` (`rfolder_id`),	195	KEY `rfolder_id` (`rfolder_id`),
238	KEY `version` (`version`),	196	KEY `version` (`version`),
239	KEY `rtype_id` (`rtype_id`),	197	KEY `rtype_id` (`rtype_id`),
240	KEY `scheme_id` (`scheme_id`)	198	KEY `scheme_id` (`scheme_id`)
241	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=1 ;	199	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ;
242		200
243	--	201	--
244	-- Дамп данных таблицы `g_repository`	202	-- Дамп данных таблицы `g_repository`
245	--	203	--
246		204
-		205	INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `repname`, `repinfo`, `repkey`) VALUES
-		206	(1, 1, 1, 1, 1, 1, 1, 'Sarge Base', 'eeee', '');
247		207
248	-- --------------------------------------------------------	208	-- --------------------------------------------------------
249		209
250	--	210	--
251	-- Структура таблицы `g_repscheme`	211	-- Структура таблицы `g_repscheme`
252	--	212	--
253		213
254	DROP TABLE IF EXISTS `g_repscheme`;	214	DROP TABLE IF EXISTS `g_repscheme`;
255	CREATE TABLE IF NOT EXISTS `g_repscheme` (	215	CREATE TABLE IF NOT EXISTS `g_repscheme` (
256	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,	216	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,
257	`scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	217	`scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
258	PRIMARY KEY (`scheme_id`),	218	PRIMARY KEY (`scheme_id`),
259	KEY `scheme` (`scheme`)	219	KEY `scheme` (`scheme`)
260	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ;	220	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ;
261		221
262	--	222	--
263	-- Дамп данных таблицы `g_repscheme`	223	-- Дамп данных таблицы `g_repscheme`
264	--	224	--
265		225
266	INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES	226	INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES
267	(1, '{DIST}'),	227	(1, '{DIST}'),
268	(2, '{DIST}-proposed-updates'),	228	(2, '{DIST}-proposed-updates'),
269	(3, '{DIST}/updates'),	229	(3, '{DIST}/updates'),
270	(4, '{DIST}/volatile'),	230	(4, '{DIST}/volatile'),
271	(5, '{DIST}/volatile-sloppy'),	231	(5, '{DIST}/volatile-sloppy'),
272	(6, '{DIST}-backports'),	232	(6, '{DIST}-backports'),
273	(7, '{DIST}-updates'),	233	(7, '{DIST}-updates'),
274	(8, '{DIST}-security');	234	(8, '{DIST}-security');
275		235
276	-- --------------------------------------------------------	236	-- --------------------------------------------------------
277		237
278	--	238	--
279	-- Структура таблицы `g_rtype`	239	-- Структура таблицы `g_rtype`
280	--	240	--
281		241
282	DROP TABLE IF EXISTS `g_rtype`;	242	DROP TABLE IF EXISTS `g_rtype`;
283	CREATE TABLE IF NOT EXISTS `g_rtype` (	243	CREATE TABLE IF NOT EXISTS `g_rtype` (
284	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,	244	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,
285	`rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	245	`rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
286	PRIMARY KEY (`rtype_id`)	246	PRIMARY KEY (`rtype_id`)
287	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ;	247	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ;
288		248
289	--	249	--
290	-- Дамп данных таблицы `g_rtype`	250	-- Дамп данных таблицы `g_rtype`
291	--	251	--
292		252
293	INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES	253	INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES
294	(1, 'Базовый репозиторий'),	254	(1, 'Базовый репозиторий'),
295	(2, 'Обновления'),	255	(2, 'Обновления'),
296	(3, 'Репозитории 3-х лиц'),	256	(3, 'Репозитории 3-х лиц'),
297	(4, 'Репозитории партнеров');	257	(4, 'Репозитории партнеров');
298		258
299	-- --------------------------------------------------------	259	-- --------------------------------------------------------
300		260
301	--	261	--
302	-- Структура таблицы `g_sect2rep`	262	-- Структура таблицы `g_sect2rep`
303	--	263	--
304		264
305	DROP TABLE IF EXISTS `g_sect2rep`;	265	DROP TABLE IF EXISTS `g_sect2rep`;
306	CREATE TABLE IF NOT EXISTS `g_sect2rep` (	266	CREATE TABLE IF NOT EXISTS `g_sect2rep` (
307	`id` INT(5) NOT NULL AUTO_INCREMENT,	267	`id` INT(5) NOT NULL AUTO_INCREMENT,
308	`sect_id` INT(2) NOT NULL,	268	`sect_id` INT(2) NOT NULL,
309	`rep_id` INT(5) NOT NULL,	269	`rep_id` INT(5) NOT NULL,
310	PRIMARY KEY (`id`),	270	PRIMARY KEY (`id`),
311	KEY `sect_id` (`sect_id`,`rep_id`)	271	KEY `sect_id` (`sect_id`,`rep_id`)
312	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=1 ;	272	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ;
313		273
314	--	274	--
315	-- Дамп данных таблицы `g_sect2rep`	275	-- Дамп данных таблицы `g_sect2rep`
316	--	276	--
317		277
-		278	INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES
-		279	(1, 1, 1),
-		280	(2, 2, 1),
-		281	(3, 3, 1);
318		282
319	-- --------------------------------------------------------	283	-- --------------------------------------------------------
320		284
321	--	285	--
322	-- Структура таблицы `g_section`	286	-- Структура таблицы `g_section`
323	--	287	--
324		288
325	DROP TABLE IF EXISTS `g_section`;	289	DROP TABLE IF EXISTS `g_section`;
326	CREATE TABLE IF NOT EXISTS `g_section` (	290	CREATE TABLE IF NOT EXISTS `g_section` (
327	`sect_id` INT(2) NOT NULL AUTO_INCREMENT,	291	`sect_id` INT(2) NOT NULL AUTO_INCREMENT,
328	`secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	292	`secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
329	`sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,	293	`sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,
330	PRIMARY KEY (`sect_id`),	294	PRIMARY KEY (`sect_id`),
331	KEY `secname` (`secname`)	295	KEY `secname` (`secname`)
332	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=9 ;	296	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=9 ;
333		297
334	--	298	--
335	-- Дамп данных таблицы `g_section`	299	-- Дамп данных таблицы `g_section`
336	--	300	--
337		301
338	INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES	302	INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES
339	(1, 'main', ''),	303	(1, 'main', ''),
340	(2, 'contrib', ''),	304	(2, 'contrib', ''),
341	(3, 'non-free', ''),	305	(3, 'non-free', ''),
342	(4, 'restricted', ''),	306	(4, 'restricted', ''),
343	(5, 'universe', ''),	307	(5, 'universe', ''),
344	(6, 'multiverse', ''),	308	(6, 'multiverse', ''),
345	(7, 'partner', ''),	309	(7, 'partner', ''),
346	(8, 'unofficial', '');	310	(8, 'unofficial', '');
347		311
348	-- --------------------------------------------------------	312	-- --------------------------------------------------------
349		313
350	--	314	--
351	-- Структура таблицы `g_settings`	315	-- Структура таблицы `g_settings`
352	--	316	--
353		317
354	DROP TABLE IF EXISTS `g_settings`;	318	DROP TABLE IF EXISTS `g_settings`;
355	CREATE TABLE IF NOT EXISTS `g_settings` (	319	CREATE TABLE IF NOT EXISTS `g_settings` (
356	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,	320	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,
357	`opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	321	`opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
358	`optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,	322	`optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
359	PRIMARY KEY (`opt_id`),	323	PRIMARY KEY (`opt_id`),
360	KEY `opt` (`opt`)	324	KEY `opt` (`opt`)
361	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=5 ;	325	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=5 ;
362		326
363	--	327	--
364	-- Дамп данных таблицы `g_settings`	328	-- Дамп данных таблицы `g_settings`
365	--	329	--
366		330
367	INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES	331	INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES
368	(1, 'codename', 'ant-ng'),	332	(1, 'codename', 'ant-ng'),
369	(2, 'version', '0.1'),	333	(2, 'version', '0.1'),
370	(3, 'owner', 'admin'),	334	(3, 'owner', 'admin'),
371	(4, 'passwd', '1');	335	(4, 'passwd', '1');
372		336
373	-- --------------------------------------------------------	337	-- --------------------------------------------------------
374		338
375	--	339	--
376	-- Структура таблицы `g_version`	340	-- Структура таблицы `g_version`
377	--	341	--
378		342
379	DROP TABLE IF EXISTS `g_version`;	343	DROP TABLE IF EXISTS `g_version`;
380	CREATE TABLE IF NOT EXISTS `g_version` (	344	CREATE TABLE IF NOT EXISTS `g_version` (
381	`version_id` INT(5) NOT NULL AUTO_INCREMENT,	345	`version_id` INT(5) NOT NULL AUTO_INCREMENT,
382	`dist_id` INT(5) NOT NULL,	346	`dist_id` INT(5) NOT NULL,
383	`vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	347	`vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
384	`version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	348	`version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
385	`vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	349	`vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
386	PRIMARY KEY (`version_id`),	350	PRIMARY KEY (`version_id`),
387	KEY `dist_id` (`dist_id`)	351	KEY `dist_id` (`dist_id`)
388	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=9 ;	352	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=9 ;
389		353
390	--	354	--
391	-- Дамп данных таблицы `g_version`	355	-- Дамп данных таблицы `g_version`
392	--	356	--
393		357
394	INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES	358	INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES
395	(1, 1, 'Sarge', '3.1', 'sarge'),	359	(1, 1, 'Sarge', '3.1', 'sarge'),
396	(2, 1, 'Etch', '4.0', 'etch'),	360	(2, 1, 'Etch', '4.0', 'etch'),
397	(3, 1, 'Lenny', '5.0', 'lenny'),	361	(3, 1, 'Lenny', '5.0', 'lenny'),
398	(4, 1, 'Squeeze', '6.0', 'squeeze'),	362	(4, 1, 'Squeeze', '6.0', 'squeeze'),
399	(5, 2, 'Hardy Heron', '8.04', 'hardy'),	363	(5, 2, 'Hardy Heron', '8.04', 'hardy'),
400	(6, 2, 'Intrepid Ibex', '8.10', 'intrepid'),	364	(6, 2, 'Intrepid Ibex', '8.10', 'intrepid'),
401	(7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'),	365	(7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'),
402	(8, 2, 'Karmic Koala', '9.10', 'karmic');	366	(8, 2, 'Karmic Koala', '9.10', 'karmic');
403		367

Хранилища Subversion ant

(root)/branches/ant-ng/sql/generator.sql - Редакция 306 → 328