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


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

Редакция 555	Редакция 673
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	-- Время создания: Ноя 26 2009 г., 13:46	6	-- Время создания: Ноя 30 2009 г., 14:09
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	CREATE TABLE IF NOT EXISTS `g_arch` (	29	CREATE TABLE IF NOT EXISTS `g_arch` (
29	`arch_id` INT(2) NOT NULL AUTO_INCREMENT,	30	`arch_id` INT(2) NOT NULL AUTO_INCREMENT,
30	`arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	31	`arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
31	PRIMARY KEY (`arch_id`),	32	PRIMARY KEY (`arch_id`),
32	KEY `arch` (`arch`)	33	KEY `arch` (`arch`)
33	) 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 ;
34		35
35	-- --------------------------------------------------------	36	-- --------------------------------------------------------
36		37
37	--	38	--
38	-- Структура таблицы `g_arch2rep`	39	-- Структура таблицы `g_arch2rep`
39	--	40	--
40		41
-		42	DROP TABLE IF EXISTS `g_arch2rep`;
41	CREATE TABLE IF NOT EXISTS `g_arch2rep` (	43	CREATE TABLE IF NOT EXISTS `g_arch2rep` (
42	`id` INT(5) NOT NULL AUTO_INCREMENT,	44	`id` INT(5) NOT NULL AUTO_INCREMENT,
43	`arch_id` INT(2) NOT NULL,	45	`arch_id` INT(2) NOT NULL,
44	`rep_id` INT(5) NOT NULL,	46	`rep_id` INT(5) NOT NULL,
45	PRIMARY KEY (`id`),	47	PRIMARY KEY (`id`),
46	KEY `arch_id` (`arch_id`,`rep_id`)	48	KEY `arch_id` (`arch_id`,`rep_id`)
47	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ;	49	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=103 ;
48		50
49	-- --------------------------------------------------------	51	-- --------------------------------------------------------
50		52
51	--	53	--
52	-- Структура таблицы `g_distribution`	54	-- Структура таблицы `g_distribution`
53	--	55	--
54		56
-		57	DROP TABLE IF EXISTS `g_distribution`;
55	CREATE TABLE IF NOT EXISTS `g_distribution` (	58	CREATE TABLE IF NOT EXISTS `g_distribution` (
56	`dist_id` INT(5) NOT NULL AUTO_INCREMENT,	59	`dist_id` INT(5) NOT NULL AUTO_INCREMENT,
57	`distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	60	`distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
58	`distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	61	`distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
59	`disttype` INT(1) NOT NULL,	62	`disttype` INT(1) NOT NULL,
60	`distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL,	63	`distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL,
61	PRIMARY KEY (`dist_id`),	64	PRIMARY KEY (`dist_id`),
62	KEY `disttype` (`disttype`,`distlogo`)	65	KEY `disttype` (`disttype`,`distlogo`)
63	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=6 ;	66	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=7 ;
64		67
65	-- --------------------------------------------------------	68	-- --------------------------------------------------------
66		69
67	--	70	--
68	-- Структура таблицы `g_dtype`	71	-- Структура таблицы `g_dtype`
69	--	72	--
70		73
-		74	DROP TABLE IF EXISTS `g_dtype`;
71	CREATE TABLE IF NOT EXISTS `g_dtype` (	75	CREATE TABLE IF NOT EXISTS `g_dtype` (
72	`type_id` INT(1) NOT NULL AUTO_INCREMENT,	76	`type_id` INT(1) NOT NULL AUTO_INCREMENT,
73	`type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL,	77	`type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL,
74	PRIMARY KEY (`type_id`),	78	PRIMARY KEY (`type_id`),
75	KEY `type` (`type`)	79	KEY `type` (`type`)
76	) 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 ;
77		81
78	-- --------------------------------------------------------	82	-- --------------------------------------------------------
79		83
80	--	84	--
81	-- Структура таблицы `g_protos`	85	-- Структура таблицы `g_protos`
82	--	86	--
83		87
-		88	DROP TABLE IF EXISTS `g_protos`;
84	CREATE TABLE IF NOT EXISTS `g_protos` (	89	CREATE TABLE IF NOT EXISTS `g_protos` (
85	`proto_id` INT(1) NOT NULL AUTO_INCREMENT,	90	`proto_id` INT(1) NOT NULL AUTO_INCREMENT,
86	`proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	91	`proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
87	PRIMARY KEY (`proto_id`),	92	PRIMARY KEY (`proto_id`),
88	KEY `proto` (`proto`)	93	KEY `proto` (`proto`)
89	) 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 ;
90		95
91	-- --------------------------------------------------------	96	-- --------------------------------------------------------
92		97
93	--	98	--
94	-- Структура таблицы `g_repfolder`	99	-- Структура таблицы `g_repfolder`
95	--	100	--
96		101
-		102	DROP TABLE IF EXISTS `g_repfolder`;
97	CREATE TABLE IF NOT EXISTS `g_repfolder` (	103	CREATE TABLE IF NOT EXISTS `g_repfolder` (
98	`rfolder_id` INT(5) NOT NULL AUTO_INCREMENT,	104	`rfolder_id` INT(5) NOT NULL AUTO_INCREMENT,
99	`rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,	105	`rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
100	PRIMARY KEY (`rfolder_id`),	106	PRIMARY KEY (`rfolder_id`),
101	KEY `rhost_id` (`rfolder`)	107	KEY `rhost_id` (`rfolder`)
102	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ;	108	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=23 ;
103		109
104	-- --------------------------------------------------------	110	-- --------------------------------------------------------
105		111
106	--	112	--
107	-- Структура таблицы `g_rephost`	113	-- Структура таблицы `g_rephost`
108	--	114	--
109		115
-		116	DROP TABLE IF EXISTS `g_rephost`;
110	CREATE TABLE IF NOT EXISTS `g_rephost` (	117	CREATE TABLE IF NOT EXISTS `g_rephost` (
111	`rhost_id` INT(3) NOT NULL AUTO_INCREMENT,	118	`rhost_id` INT(3) NOT NULL AUTO_INCREMENT,
112	`rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,	119	`rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
113	PRIMARY KEY (`rhost_id`),	120	PRIMARY KEY (`rhost_id`),
114	KEY `proto_id` (`rhost`)	121	KEY `proto_id` (`rhost`)
115	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ;	122	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=8 ;
116		123
117	-- --------------------------------------------------------	124	-- --------------------------------------------------------
118		125
119	--	126	--
120	-- Структура таблицы `g_repository`	127	-- Структура таблицы `g_repository`
121	--	128	--
122		129
-		130	DROP TABLE IF EXISTS `g_repository`;
123	CREATE TABLE IF NOT EXISTS `g_repository` (	131	CREATE TABLE IF NOT EXISTS `g_repository` (
124	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,	132	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,
125	`proto_id` INT(1) NOT NULL,	133	`proto_id` INT(1) NOT NULL,
126	`rhost_id` INT(3) NOT NULL,	134	`rhost_id` INT(3) NOT NULL,
127	`rfolder_id` INT(5) NOT NULL,	135	`rfolder_id` INT(5) NOT NULL,
128	`version` INT(5) NOT NULL,	136	`version` INT(5) NOT NULL,
129	`rtype_id` INT(2) NOT NULL,	137	`rtype_id` INT(2) NOT NULL,
130	`scheme_id` INT(2) NOT NULL,	138	`scheme_id` INT(2) NOT NULL,
-		139	`sign_id` INT(3) NOT NULL,
131	`repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	140	`repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
132	`repinfo` text COLLATE utf8_unicode_ci NOT NULL,	141	`repinfo` text COLLATE utf8_unicode_ci NOT NULL,
133	`repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,	142	`repkey` VARCHAR(200) COLLATE utf8_unicode_ci NOT NULL,
134	PRIMARY KEY (`rep_id`),	143	PRIMARY KEY (`rep_id`),
135	KEY `proto_id` (`proto_id`),	144	KEY `proto_id` (`proto_id`),
136	KEY `rhost_id` (`rhost_id`),	145	KEY `rhost_id` (`rhost_id`),
137	KEY `rfolder_id` (`rfolder_id`),	146	KEY `rfolder_id` (`rfolder_id`),
138	KEY `version` (`version`),	147	KEY `version` (`version`),
139	KEY `rtype_id` (`rtype_id`),	148	KEY `rtype_id` (`rtype_id`),
140	KEY `scheme_id` (`scheme_id`)	149	KEY `scheme_id` (`scheme_id`),
-		150	KEY `sign_id` (`sign_id`)
141	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ;	151	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ;
142		152
143	-- --------------------------------------------------------	153	-- --------------------------------------------------------
144		154
145	--	155	--
146	-- Структура таблицы `g_repscheme`	156	-- Структура таблицы `g_repscheme`
147	--	157	--
148		158
-		159	DROP TABLE IF EXISTS `g_repscheme`;
149	CREATE TABLE IF NOT EXISTS `g_repscheme` (	160	CREATE TABLE IF NOT EXISTS `g_repscheme` (
150	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,	161	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,
151	`scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	162	`scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
152	PRIMARY KEY (`scheme_id`),	163	PRIMARY KEY (`scheme_id`),
153	KEY `scheme` (`scheme`)	164	KEY `scheme` (`scheme`)
154	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ;	165	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ;
155		166
156	-- --------------------------------------------------------	167	-- --------------------------------------------------------
157		168
158	--	169	--
159	-- Структура таблицы `g_rtype`	170	-- Структура таблицы `g_rtype`
160	--	171	--
161		172
-		173	DROP TABLE IF EXISTS `g_rtype`;
162	CREATE TABLE IF NOT EXISTS `g_rtype` (	174	CREATE TABLE IF NOT EXISTS `g_rtype` (
163	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,	175	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,
164	`rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	176	`rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
165	PRIMARY KEY (`rtype_id`)	177	PRIMARY KEY (`rtype_id`)
166	) 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 ;
167		179
168	-- --------------------------------------------------------	180	-- --------------------------------------------------------
169		181
170	--	182	--
171	-- Структура таблицы `g_sect2rep`	183	-- Структура таблицы `g_sect2rep`
172	--	184	--
173		185
-		186	DROP TABLE IF EXISTS `g_sect2rep`;
174	CREATE TABLE IF NOT EXISTS `g_sect2rep` (	187	CREATE TABLE IF NOT EXISTS `g_sect2rep` (
175	`id` INT(5) NOT NULL AUTO_INCREMENT,	188	`id` INT(5) NOT NULL AUTO_INCREMENT,
176	`sect_id` INT(2) NOT NULL,	189	`sect_id` INT(2) NOT NULL,
177	`rep_id` INT(5) NOT NULL,	190	`rep_id` INT(5) NOT NULL,
178	PRIMARY KEY (`id`),	191	PRIMARY KEY (`id`),
179	KEY `sect_id` (`sect_id`,`rep_id`)	192	KEY `sect_id` (`sect_id`,`rep_id`)
180	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ;	193	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ;
181		194
182	-- --------------------------------------------------------	195	-- --------------------------------------------------------
183		196
184	--	197	--
185	-- Структура таблицы `g_section`	198	-- Структура таблицы `g_section`
186	--	199	--
187		200
-		201	DROP TABLE IF EXISTS `g_section`;
188	CREATE TABLE IF NOT EXISTS `g_section` (	202	CREATE TABLE IF NOT EXISTS `g_section` (
189	`sect_id` INT(2) NOT NULL AUTO_INCREMENT,	203	`sect_id` INT(2) NOT NULL AUTO_INCREMENT,
190	`secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	204	`secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
191	`sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,	205	`sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,
192	PRIMARY KEY (`sect_id`),	206	PRIMARY KEY (`sect_id`),
193	KEY `secname` (`secname`)	207	KEY `secname` (`secname`)
194	) 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 ;
195		209
196	-- --------------------------------------------------------	210	-- --------------------------------------------------------
197		211
198	--	212	--
199	-- Структура таблицы `g_settings`	213	-- Структура таблицы `g_settings`
200	--	214	--
201		215
-		216	DROP TABLE IF EXISTS `g_settings`;
202	CREATE TABLE IF NOT EXISTS `g_settings` (	217	CREATE TABLE IF NOT EXISTS `g_settings` (
203	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,	218	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,
204	`opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	219	`opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
205	`optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,	220	`optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
206	PRIMARY KEY (`opt_id`),	221	PRIMARY KEY (`opt_id`),
207	KEY `opt` (`opt`)	222	KEY `opt` (`opt`)
208	) 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 ;
209		224
210	-- --------------------------------------------------------	225	-- --------------------------------------------------------
211		226
212	--	227	--
213	-- Структура таблицы `g_signs`	228	-- Структура таблицы `g_signs`
214	--	229	--
215		230
-		231	DROP TABLE IF EXISTS `g_signs`;
216	CREATE TABLE IF NOT EXISTS `g_signs` (	232	CREATE TABLE IF NOT EXISTS `g_signs` (
217	`sign_id` INT(3) NOT NULL AUTO_INCREMENT,	233	`sign_id` INT(3) NOT NULL AUTO_INCREMENT,
218	`sname` VARCHAR(25) NOT NULL,	234	`sname` VARCHAR(25) NOT NULL,
219	`sinfo` VARCHAR(150) NOT NULL,	235	`sinfo` VARCHAR(150) NOT NULL,
220	PRIMARY KEY (`sign_id`)	236	PRIMARY KEY (`sign_id`)
221	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ;	237	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ;
222		238
223	-- --------------------------------------------------------	239	-- --------------------------------------------------------
224		240
225	--	241	--
226	-- Структура таблицы `g_version`	242	-- Структура таблицы `g_version`
227	--	243	--
228		244
-		245	DROP TABLE IF EXISTS `g_version`;
229	CREATE TABLE IF NOT EXISTS `g_version` (	246	CREATE TABLE IF NOT EXISTS `g_version` (
230	`version_id` INT(5) NOT NULL AUTO_INCREMENT,	247	`version_id` INT(5) NOT NULL AUTO_INCREMENT,
231	`dist_id` INT(5) NOT NULL,	248	`dist_id` INT(5) NOT NULL,
232	`vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,	249	`vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
233	`version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	250	`version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
234	`vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,	251	`vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
235	PRIMARY KEY (`version_id`),	252	PRIMARY KEY (`version_id`),
236	KEY `dist_id` (`dist_id`)	253	KEY `dist_id` (`dist_id`)
237	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=13 ;	254	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ;
238		255

Хранилища Subversion ant

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