WebSVN - ant - Различия - Редакция 56 и 66


-- phpMyAdmin SQL Dump
-- version 3.0.0-alpha
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Мар 19 2009 г., 16:53
-- Версия сервера: 5.0.51
-- Версия PHP: 5.2.6-1+lenny2

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 */;

--
-- База данных: `ant`
--

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

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

CREATE TABLE IF NOT EXISTS `arch` (
  `arch_id` INT(2) NOT NULL AUTO_INCREMENT,
  `arch` VARCHAR(10) DEFAULT NULL,
  PRIMARY KEY  (`arch_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

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

CREATE TABLE IF NOT EXISTS `arch2rep` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `arch_id` INT(2) DEFAULT NULL,
  `rep_id` INT(5) DEFAULT NULL,
  PRIMARY KEY  (`id`),
  KEY `arch_id` (`arch_id`),
  KEY `rep_id` (`rep_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

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

CREATE TABLE IF NOT EXISTS `distribution` (
  `dist_id` INT(5) NOT NULL AUTO_INCREMENT,
  `distname` VARCHAR(25) DEFAULT NULL,
  `disttype` INT(1) NOT NULL,
  PRIMARY KEY  (`dist_id`),
  KEY `disttype` (`disttype`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

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

CREATE TABLE IF NOT EXISTS `dtype` (
  `type_id` INT(1) NOT NULL AUTO_INCREMENT,
  `type` CHAR(3) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY  (`type_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

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

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

CREATE TABLE IF NOT EXISTS `owner` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `login` CHAR(32) DEFAULT NULL,
  `passwd` CHAR(32) DEFAULT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

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

CREATE TABLE IF NOT EXISTS `repository` (
  `rep_id` INT(5) NOT NULL AUTO_INCREMENT,
  `repname` VARCHAR(20) DEFAULT NULL,
  `repdescribe` text,
  `scheme_id` INT(2) NOT NULL,
  `rtype_id` INT(2) NOT NULL,
  PRIMARY KEY  (`rep_id`),
  KEY `scheme` (`scheme_id`),
  KEY `rtype_id` (`rtype_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;

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

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

CREATE TABLE IF NOT EXISTS `rtype` (
  `rtype_id` INT(2) NOT NULL AUTO_INCREMENT,
  `rtype` VARCHAR(25) NOT NULL,
  PRIMARY KEY  (`rtype_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

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

CREATE TABLE IF NOT EXISTS `scheme` (
  `scheme_id` INT(2) NOT NULL AUTO_INCREMENT,
  `scheme` VARCHAR(200) NOT NULL,
  PRIMARY KEY  (`scheme_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

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

CREATE TABLE IF NOT EXISTS `sect2dist` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `sect_id` INT(3) NOT NULL,
  `dist_id` INT(5) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `sect_id` (`sect_id`,`dist_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;

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

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

CREATE TABLE IF NOT EXISTS `sect2rep` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `sect_id` INT(3) NOT NULL,
  `rep_id` INT(5) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `sect_id` (`sect_id`,`rep_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=529 ;

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

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

CREATE TABLE IF NOT EXISTS `section` (
  `sect_id` INT(3) NOT NULL AUTO_INCREMENT,
  `sectname` VARCHAR(25) NOT NULL,
  `sectinfo` text NOT NULL,
  PRIMARY KEY  (`sect_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

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

CREATE TABLE IF NOT EXISTS `settings` (
  `opt_id` INT(2) NOT NULL AUTO_INCREMENT,
  `opt` VARCHAR(50) NOT NULL,
  `optvalue` VARCHAR(200) NOT NULL,
  PRIMARY KEY  (`opt_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

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

CREATE TABLE IF NOT EXISTS `ver2rep` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `ver_id` INT(5) DEFAULT NULL,
  `rep_id` INT(5) DEFAULT NULL,
  PRIMARY KEY  (`id`),
  KEY `ver_id` (`ver_id`),
  KEY `rep_id` (`rep_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;

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

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

CREATE TABLE IF NOT EXISTS `version` (
  `version_id` INT(5) NOT NULL AUTO_INCREMENT,
  `dist_id` INT(5) DEFAULT NULL,
  `vname` VARCHAR(25) DEFAULT NULL,
  `version` VARCHAR(10) NOT NULL,
  `vcodename` VARCHAR(10) DEFAULT NULL,
  PRIMARY KEY  (`version_id`),
  KEY `dist_id` (`dist_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
 

Хранилища Subversion ant

(root)/tags/0.2RC3/sql/ant-scheme.sql @ 701 - Редакция 56 → 66

Редакция 56		Редакция 66
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	-- Время создания: Мар 19 2009 г., 16:53	6	-- Время создания: Мар 19 2009 г., 16:53
7	-- Версия сервера: 5.0.51	7	-- Версия сервера: 5.0.51
8	-- Версия PHP: 5.2.6-1+lenny2	8	-- Версия PHP: 5.2.6-1+lenny2
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	-- База данных: `ant`	19	-- База данных: `ant`
20	--	20	--
21		21
22	-- --------------------------------------------------------	22	-- --------------------------------------------------------
23		23
24	--	24	--
25	-- Структура таблицы `arch`	25	-- Структура таблицы `arch`
26	--	26	--
27		27
28	CREATE TABLE IF NOT EXISTS `arch` (	28	CREATE TABLE IF NOT EXISTS `arch` (
29	`arch_id` INT(2) NOT NULL AUTO_INCREMENT,	29	`arch_id` INT(2) NOT NULL AUTO_INCREMENT,
30	`arch` VARCHAR(10) DEFAULT NULL,	30	`arch` VARCHAR(10) DEFAULT NULL,
31	PRIMARY KEY (`arch_id`)	31	PRIMARY KEY (`arch_id`)
32	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;	32	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
33		33
34	-- --------------------------------------------------------	34	-- --------------------------------------------------------
35		35
36	--	36	--
37	-- Структура таблицы `arch2rep`	37	-- Структура таблицы `arch2rep`
38	--	38	--
39		39
40	CREATE TABLE IF NOT EXISTS `arch2rep` (	40	CREATE TABLE IF NOT EXISTS `arch2rep` (
41	`id` INT(11) NOT NULL AUTO_INCREMENT,	41	`id` INT(11) NOT NULL AUTO_INCREMENT,
42	`arch_id` INT(2) DEFAULT NULL,	42	`arch_id` INT(2) DEFAULT NULL,
43	`rep_id` INT(5) DEFAULT NULL,	43	`rep_id` INT(5) DEFAULT NULL,
44	PRIMARY KEY (`id`),	44	PRIMARY KEY (`id`),
45	KEY `arch_id` (`arch_id`),	45	KEY `arch_id` (`arch_id`),
46	KEY `rep_id` (`rep_id`)	46	KEY `rep_id` (`rep_id`)
47	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;	47	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
48		48
49	-- --------------------------------------------------------	49	-- --------------------------------------------------------
50		50
51	--	51	--
52	-- Структура таблицы `distribution`	52	-- Структура таблицы `distribution`
53	--	53	--
54		54
55	CREATE TABLE IF NOT EXISTS `distribution` (	55	CREATE TABLE IF NOT EXISTS `distribution` (
56	`dist_id` INT(5) NOT NULL AUTO_INCREMENT,	56	`dist_id` INT(5) NOT NULL AUTO_INCREMENT,
57	`distname` VARCHAR(25) DEFAULT NULL,	57	`distname` VARCHAR(25) DEFAULT NULL,
58	`disttype` INT(1) NOT NULL,	58	`disttype` INT(1) NOT NULL,
59	PRIMARY KEY (`dist_id`),	59	PRIMARY KEY (`dist_id`),
60	KEY `disttype` (`disttype`)	60	KEY `disttype` (`disttype`)
61	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;	61	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
62		62
63	-- --------------------------------------------------------	63	-- --------------------------------------------------------
64		64
65	--	65	--
66	-- Структура таблицы `dtype`	66	-- Структура таблицы `dtype`
67	--	67	--
68		68
69	CREATE TABLE IF NOT EXISTS `dtype` (	69	CREATE TABLE IF NOT EXISTS `dtype` (
70	`type_id` INT(1) NOT NULL AUTO_INCREMENT,	70	`type_id` INT(1) NOT NULL AUTO_INCREMENT,
71	`type` CHAR(3) CHARACTER SET utf8 NOT NULL,	71	`type` CHAR(3) CHARACTER SET utf8 NOT NULL,
72	PRIMARY KEY (`type_id`)	72	PRIMARY KEY (`type_id`)
73	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;	73	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
74		74
75	-- --------------------------------------------------------	75	-- --------------------------------------------------------
76		76
77	--	77	--
78	-- Структура таблицы `owner`	78	-- Структура таблицы `owner`
79	--	79	--
80		80
81	CREATE TABLE IF NOT EXISTS `owner` (	81	CREATE TABLE IF NOT EXISTS `owner` (
82	`id` INT(11) NOT NULL AUTO_INCREMENT,	82	`id` INT(11) NOT NULL AUTO_INCREMENT,
83	`login` CHAR(32) DEFAULT NULL,	83	`login` CHAR(32) DEFAULT NULL,
84	`passwd` CHAR(32) DEFAULT NULL,	84	`passwd` CHAR(32) DEFAULT NULL,
85	PRIMARY KEY (`id`)	85	PRIMARY KEY (`id`)
86	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;	86	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
87		87
88	-- --------------------------------------------------------	88	-- --------------------------------------------------------
89		89
90	--	90	--
91	-- Структура таблицы `repository`	91	-- Структура таблицы `repository`
92	--	92	--
93		93
94	CREATE TABLE IF NOT EXISTS `repository` (	94	CREATE TABLE IF NOT EXISTS `repository` (
95	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,	95	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,
96	`repname` VARCHAR(20) DEFAULT NULL,	96	`repname` VARCHAR(20) DEFAULT NULL,
97	`repdescribe` text,	97	`repdescribe` text,
98	`scheme_id` INT(2) NOT NULL,	98	`scheme_id` INT(2) NOT NULL,
99	`rtype_id` INT(2) NOT NULL,	99	`rtype_id` INT(2) NOT NULL,
100	PRIMARY KEY (`rep_id`),	100	PRIMARY KEY (`rep_id`),
101	KEY `scheme` (`scheme_id`),	101	KEY `scheme` (`scheme_id`),
102	KEY `rtype_id` (`rtype_id`)	102	KEY `rtype_id` (`rtype_id`)
103	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;	103	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;
104		104
105	-- --------------------------------------------------------	105	-- --------------------------------------------------------
106		106
107	--	107	--
108	-- Структура таблицы `rtype`	108	-- Структура таблицы `rtype`
109	--	109	--
110		110
111	CREATE TABLE IF NOT EXISTS `rtype` (	111	CREATE TABLE IF NOT EXISTS `rtype` (
112	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,	112	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,
113	`rtype` VARCHAR(25) NOT NULL,	113	`rtype` VARCHAR(25) NOT NULL,
114	PRIMARY KEY (`rtype_id`)	114	PRIMARY KEY (`rtype_id`)
115	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;	115	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
116		116
117	-- --------------------------------------------------------	117	-- --------------------------------------------------------
118		118
119	--	119	--
120	-- Структура таблицы `scheme`	120	-- Структура таблицы `scheme`
121	--	121	--
122		122
123	CREATE TABLE IF NOT EXISTS `scheme` (	123	CREATE TABLE IF NOT EXISTS `scheme` (
124	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,	124	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,
125	`scheme` VARCHAR(200) NOT NULL,	125	`scheme` VARCHAR(200) NOT NULL,
126	PRIMARY KEY (`scheme_id`)	126	PRIMARY KEY (`scheme_id`)
127	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;	127	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
128		128
129	-- --------------------------------------------------------	129	-- --------------------------------------------------------
130		130
131	--	131	--
132	-- Структура таблицы `sect2dist`	132	-- Структура таблицы `sect2dist`
133	--	133	--
134		134
135	CREATE TABLE IF NOT EXISTS `sect2dist` (	135	CREATE TABLE IF NOT EXISTS `sect2dist` (
136	`id` INT(10) NOT NULL AUTO_INCREMENT,	136	`id` INT(10) NOT NULL AUTO_INCREMENT,
137	`sect_id` INT(3) NOT NULL,	137	`sect_id` INT(3) NOT NULL,
138	`dist_id` INT(5) NOT NULL,	138	`dist_id` INT(5) NOT NULL,
139	PRIMARY KEY (`id`),	139	PRIMARY KEY (`id`),
140	KEY `sect_id` (`sect_id`,`dist_id`)	140	KEY `sect_id` (`sect_id`,`dist_id`)
141	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;	141	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
142		142
143	-- --------------------------------------------------------	143	-- --------------------------------------------------------
144		144
145	--	145	--
146	-- Структура таблицы `sect2rep`	146	-- Структура таблицы `sect2rep`
147	--	147	--
148		148
149	CREATE TABLE IF NOT EXISTS `sect2rep` (	149	CREATE TABLE IF NOT EXISTS `sect2rep` (
150	`id` INT(10) NOT NULL AUTO_INCREMENT,	150	`id` INT(10) NOT NULL AUTO_INCREMENT,
151	`sect_id` INT(3) NOT NULL,	151	`sect_id` INT(3) NOT NULL,
152	`rep_id` INT(5) NOT NULL,	152	`rep_id` INT(5) NOT NULL,
153	PRIMARY KEY (`id`),	153	PRIMARY KEY (`id`),
154	KEY `sect_id` (`sect_id`,`rep_id`)	154	KEY `sect_id` (`sect_id`,`rep_id`)
155	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=529 ;	155	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=529 ;
156		156
157	-- --------------------------------------------------------	157	-- --------------------------------------------------------
158		158
159	--	159	--
160	-- Структура таблицы `section`	160	-- Структура таблицы `section`
161	--	161	--
162		162
163	CREATE TABLE IF NOT EXISTS `section` (	163	CREATE TABLE IF NOT EXISTS `section` (
164	`sect_id` INT(3) NOT NULL AUTO_INCREMENT,	164	`sect_id` INT(3) NOT NULL AUTO_INCREMENT,
165	`sectname` VARCHAR(25) NOT NULL,	165	`sectname` VARCHAR(25) NOT NULL,
166	`sectinfo` text NOT NULL,	166	`sectinfo` text NOT NULL,
167	PRIMARY KEY (`sect_id`)	167	PRIMARY KEY (`sect_id`)
168	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;	168	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
169		169
170	-- --------------------------------------------------------	170	-- --------------------------------------------------------
171		171
172	--	172	--
173	-- Структура таблицы `settings`	173	-- Структура таблицы `settings`
174	--	174	--
175		175
176	CREATE TABLE IF NOT EXISTS `settings` (	176	CREATE TABLE IF NOT EXISTS `settings` (
177	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,	177	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,
178	`opt` VARCHAR(50) NOT NULL,	178	`opt` VARCHAR(50) NOT NULL,
179	`optvalue` VARCHAR(200) NOT NULL,	179	`optvalue` VARCHAR(200) NOT NULL,
180	PRIMARY KEY (`opt_id`)	180	PRIMARY KEY (`opt_id`)
181	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;	181	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
182		182
183	-- --------------------------------------------------------	183	-- --------------------------------------------------------
184		184
185	--	185	--
186	-- Структура таблицы `ver2rep`	186	-- Структура таблицы `ver2rep`
187	--	187	--
188		188
189	CREATE TABLE IF NOT EXISTS `ver2rep` (	189	CREATE TABLE IF NOT EXISTS `ver2rep` (
190	`id` INT(11) NOT NULL AUTO_INCREMENT,	190	`id` INT(11) NOT NULL AUTO_INCREMENT,
191	`ver_id` INT(5) DEFAULT NULL,	191	`ver_id` INT(5) DEFAULT NULL,
192	`rep_id` INT(5) DEFAULT NULL,	192	`rep_id` INT(5) DEFAULT NULL,
193	PRIMARY KEY (`id`),	193	PRIMARY KEY (`id`),
194	KEY `ver_id` (`ver_id`),	194	KEY `ver_id` (`ver_id`),
195	KEY `rep_id` (`rep_id`)	195	KEY `rep_id` (`rep_id`)
196	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;	196	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;
197		197
198	-- --------------------------------------------------------	198	-- --------------------------------------------------------
199		199
200	--	200	--
201	-- Структура таблицы `version`	201	-- Структура таблицы `version`
202	--	202	--
203		203
204	CREATE TABLE IF NOT EXISTS `version` (	204	CREATE TABLE IF NOT EXISTS `version` (
205	`version_id` INT(5) NOT NULL AUTO_INCREMENT,	205	`version_id` INT(5) NOT NULL AUTO_INCREMENT,
206	`dist_id` INT(5) DEFAULT NULL,	206	`dist_id` INT(5) DEFAULT NULL,
207	`vname` VARCHAR(25) DEFAULT NULL,	207	`vname` VARCHAR(25) DEFAULT NULL,
208	`version` VARCHAR(10) NOT NULL,	208	`version` VARCHAR(10) NOT NULL,
209	`vcodename` VARCHAR(10) DEFAULT NULL,	209	`vcodename` VARCHAR(10) DEFAULT NULL,
210	PRIMARY KEY (`version_id`),	210	PRIMARY KEY (`version_id`),
211	KEY `dist_id` (`dist_id`)	211	KEY `dist_id` (`dist_id`)
212	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;	212	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
213		213