WebSVN - ant - Различия - Редакция 475 и 555


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

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

INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES
(1, 'Debian GNU/Linux', 'debian', 1, '1'),
(2, 'Ubuntu Linux', 'ubuntu', 1, '0'),
(5, 'ALTLinux', 'altlinux', 2, '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=15 ;

--
-- Дамп данных таблицы `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', 'раздел с неофициальными пакетами'),
(9, 'astro', 'раздел с пакетами астрономических программ'),
(10, 'altspa', 'раздел пакетов для АлтГПА'),
(11, 'classic', ''),
(12, 'daedalus', ''),
(13, 'updates', ''),
(14, 'backports', '');

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

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

INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES
(1, 'codename', 'ant-ng'),
(2, 'version', '0.1'),
(5, 'description', 'Генератор sources.list для apt-дистрибутивов Linux'),
(4, 'passwd', 'b5c5bd7428b6509b5235953ad7aaae12');

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

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

INSERT INTO `g_signs` (`sign_id`, `sname`, `sinfo`) VALUES
(1, 'alt', ''),
(2, 'p5', 'Пятая платформа'),
(3, 'updates', 'Обновления'),
(4, 'backports', 'Бэкпортированые пакеты'),
(5, 'school', 'Школьные');

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

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

--
-- Дамп данных таблицы `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'),
(12, 5, 'Школьный Мастер', '5.0', 'master'),
(11, 5, 'Ark', '5.0', 'ark');
 

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

Хранилища Subversion ant

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