WebSVN - ant - Различия - Редакция 78 и 86 - /branches/ant/0.2.x/sql/ant-scheme.sql


-- phpMyAdmin SQL Dump
-- version 3.0.0-alpha
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Мар 24 2009 г., 10:52
-- Версия сервера: 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,
  `distua` VARCHAR(50) NOT NULL,
  `disttype` INT(1) NOT NULL,
  `distlogo` enum('0','1') NOT NULL,
  PRIMARY KEY  (`dist_id`),
  KEY `disttype` (`disttype`),
  KEY `distlogo` (`distlogo`)
) 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 ;

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

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

CREATE TABLE IF NOT EXISTS `interfaces` (
  `if_id` INT(2) NOT NULL AUTO_INCREMENT,
  `interface` VARCHAR(25) NOT NULL,
  `interfaceinfo` VARCHAR(100) NOT NULL,
  PRIMARY KEY  (`if_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

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

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

--
-- Структура таблицы `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)/branches/ant/0.2.x/sql/ant-scheme.sql @ 458 - Редакция 78 → 86

Редакция 78		Редакция 86
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	-- Время создания: Мар 23 2009 г., 15:14	6	-- Время создания: Мар 24 2009 г., 10:52
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	`distua` VARCHAR(50) NOT NULL,	58	`distua` VARCHAR(50) NOT NULL,
59	`disttype` INT(1) NOT NULL,	59	`disttype` INT(1) NOT NULL,
-		60	`distlogo` enum('0','1') NOT NULL,
60	PRIMARY KEY (`dist_id`),	61	PRIMARY KEY (`dist_id`),
61	KEY `disttype` (`disttype`)	62	KEY `disttype` (`disttype`),
-		63	KEY `distlogo` (`distlogo`)
62	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;	64	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
63		65
64	-- --------------------------------------------------------	66	-- --------------------------------------------------------
65		67
66	--	68	--
67	-- Структура таблицы `dtype`	69	-- Структура таблицы `dtype`
68	--	70	--
69		71
70	CREATE TABLE IF NOT EXISTS `dtype` (	72	CREATE TABLE IF NOT EXISTS `dtype` (
71	`type_id` INT(1) NOT NULL AUTO_INCREMENT,	73	`type_id` INT(1) NOT NULL AUTO_INCREMENT,
72	`type` CHAR(3) CHARACTER SET utf8 NOT NULL,	74	`type` CHAR(3) CHARACTER SET utf8 NOT NULL,
73	PRIMARY KEY (`type_id`)	75	PRIMARY KEY (`type_id`)
74	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;	76	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
75		77
76	-- --------------------------------------------------------	78	-- --------------------------------------------------------
77		79
78	--	80	--
79	-- Структура таблицы `interfaces`	81	-- Структура таблицы `interfaces`
80	--	82	--
81		83
82	CREATE TABLE IF NOT EXISTS `interfaces` (	84	CREATE TABLE IF NOT EXISTS `interfaces` (
83	`if_id` INT(2) NOT NULL AUTO_INCREMENT,	85	`if_id` INT(2) NOT NULL AUTO_INCREMENT,
84	`interface` VARCHAR(25) NOT NULL,	86	`interface` VARCHAR(25) NOT NULL,
85	`interfaceinfo` VARCHAR(100) NOT NULL,	87	`interfaceinfo` VARCHAR(100) NOT NULL,
86	PRIMARY KEY (`if_id`)	88	PRIMARY KEY (`if_id`)
87	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;	89	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
88		90
89	-- --------------------------------------------------------	91	-- --------------------------------------------------------
90		92
91	--	93	--
92	-- Структура таблицы `owner`	94	-- Структура таблицы `owner`
93	--	95	--
94		96
95	CREATE TABLE IF NOT EXISTS `owner` (	97	CREATE TABLE IF NOT EXISTS `owner` (
96	`id` INT(11) NOT NULL AUTO_INCREMENT,	98	`id` INT(11) NOT NULL AUTO_INCREMENT,
97	`login` CHAR(32) DEFAULT NULL,	99	`login` CHAR(32) DEFAULT NULL,
98	`passwd` CHAR(32) DEFAULT NULL,	100	`passwd` CHAR(32) DEFAULT NULL,
99	PRIMARY KEY (`id`)	101	PRIMARY KEY (`id`)
100	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;	102	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
101		103
102	-- --------------------------------------------------------	104	-- --------------------------------------------------------
103		105
104	--	106	--
105	-- Структура таблицы `repository`	107	-- Структура таблицы `repository`
106	--	108	--
107		109
108	CREATE TABLE IF NOT EXISTS `repository` (	110	CREATE TABLE IF NOT EXISTS `repository` (
109	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,	111	`rep_id` INT(5) NOT NULL AUTO_INCREMENT,
110	`repname` VARCHAR(20) DEFAULT NULL,	112	`repname` VARCHAR(20) DEFAULT NULL,
111	`repdescribe` text,	113	`repdescribe` text,
112	`scheme_id` INT(2) NOT NULL,	114	`scheme_id` INT(2) NOT NULL,
113	`rtype_id` INT(2) NOT NULL,	115	`rtype_id` INT(2) NOT NULL,
114	PRIMARY KEY (`rep_id`),	116	PRIMARY KEY (`rep_id`),
115	KEY `scheme` (`scheme_id`),	117	KEY `scheme` (`scheme_id`),
116	KEY `rtype_id` (`rtype_id`)	118	KEY `rtype_id` (`rtype_id`)
117	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;	119	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;
118		120
119	-- --------------------------------------------------------	121	-- --------------------------------------------------------
120		122
121	--	123	--
122	-- Структура таблицы `rtype`	124	-- Структура таблицы `rtype`
123	--	125	--
124		126
125	CREATE TABLE IF NOT EXISTS `rtype` (	127	CREATE TABLE IF NOT EXISTS `rtype` (
126	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,	128	`rtype_id` INT(2) NOT NULL AUTO_INCREMENT,
127	`rtype` VARCHAR(25) NOT NULL,	129	`rtype` VARCHAR(25) NOT NULL,
128	PRIMARY KEY (`rtype_id`)	130	PRIMARY KEY (`rtype_id`)
129	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;	131	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
130		132
131	-- --------------------------------------------------------	133	-- --------------------------------------------------------
132		134
133	--	135	--
134	-- Структура таблицы `scheme`	136	-- Структура таблицы `scheme`
135	--	137	--
136		138
137	CREATE TABLE IF NOT EXISTS `scheme` (	139	CREATE TABLE IF NOT EXISTS `scheme` (
138	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,	140	`scheme_id` INT(2) NOT NULL AUTO_INCREMENT,
139	`scheme` VARCHAR(200) NOT NULL,	141	`scheme` VARCHAR(200) NOT NULL,
140	PRIMARY KEY (`scheme_id`)	142	PRIMARY KEY (`scheme_id`)
141	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;	143	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
142		144
143	-- --------------------------------------------------------	145	-- --------------------------------------------------------
144		146
145	--	147	--
146	-- Структура таблицы `sect2dist`	148	-- Структура таблицы `sect2dist`
147	--	149	--
148		150
149	CREATE TABLE IF NOT EXISTS `sect2dist` (	151	CREATE TABLE IF NOT EXISTS `sect2dist` (
150	`id` INT(10) NOT NULL AUTO_INCREMENT,	152	`id` INT(10) NOT NULL AUTO_INCREMENT,
151	`sect_id` INT(3) NOT NULL,	153	`sect_id` INT(3) NOT NULL,
152	`dist_id` INT(5) NOT NULL,	154	`dist_id` INT(5) NOT NULL,
153	PRIMARY KEY (`id`),	155	PRIMARY KEY (`id`),
154	KEY `sect_id` (`sect_id`,`dist_id`)	156	KEY `sect_id` (`sect_id`,`dist_id`)
155	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;	157	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
156		158
157	-- --------------------------------------------------------	159	-- --------------------------------------------------------
158		160
159	--	161	--
160	-- Структура таблицы `sect2rep`	162	-- Структура таблицы `sect2rep`
161	--	163	--
162		164
163	CREATE TABLE IF NOT EXISTS `sect2rep` (	165	CREATE TABLE IF NOT EXISTS `sect2rep` (
164	`id` INT(10) NOT NULL AUTO_INCREMENT,	166	`id` INT(10) NOT NULL AUTO_INCREMENT,
165	`sect_id` INT(3) NOT NULL,	167	`sect_id` INT(3) NOT NULL,
166	`rep_id` INT(5) NOT NULL,	168	`rep_id` INT(5) NOT NULL,
167	PRIMARY KEY (`id`),	169	PRIMARY KEY (`id`),
168	KEY `sect_id` (`sect_id`,`rep_id`)	170	KEY `sect_id` (`sect_id`,`rep_id`)
169	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=529 ;	171	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=529 ;
170		172
171	-- --------------------------------------------------------	173	-- --------------------------------------------------------
172		174
173	--	175	--
174	-- Структура таблицы `section`	176	-- Структура таблицы `section`
175	--	177	--
176		178
177	CREATE TABLE IF NOT EXISTS `section` (	179	CREATE TABLE IF NOT EXISTS `section` (
178	`sect_id` INT(3) NOT NULL AUTO_INCREMENT,	180	`sect_id` INT(3) NOT NULL AUTO_INCREMENT,
179	`sectname` VARCHAR(25) NOT NULL,	181	`sectname` VARCHAR(25) NOT NULL,
180	`sectinfo` text NOT NULL,	182	`sectinfo` text NOT NULL,
181	PRIMARY KEY (`sect_id`)	183	PRIMARY KEY (`sect_id`)
182	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;	184	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
183		185
184	-- --------------------------------------------------------	186	-- --------------------------------------------------------
185		187
186	--	188	--
187	-- Структура таблицы `settings`	189	-- Структура таблицы `settings`
188	--	190	--
189		191
190	CREATE TABLE IF NOT EXISTS `settings` (	192	CREATE TABLE IF NOT EXISTS `settings` (
191	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,	193	`opt_id` INT(2) NOT NULL AUTO_INCREMENT,
192	`opt` VARCHAR(50) NOT NULL,	194	`opt` VARCHAR(50) NOT NULL,
193	`optvalue` VARCHAR(200) NOT NULL,	195	`optvalue` VARCHAR(200) NOT NULL,
194	PRIMARY KEY (`opt_id`)	196	PRIMARY KEY (`opt_id`)
195	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;	197	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
196		198
197	-- --------------------------------------------------------	199	-- --------------------------------------------------------
198		200
199	--	201	--
200	-- Структура таблицы `ver2rep`	202	-- Структура таблицы `ver2rep`
201	--	203	--
202		204
203	CREATE TABLE IF NOT EXISTS `ver2rep` (	205	CREATE TABLE IF NOT EXISTS `ver2rep` (
204	`id` INT(11) NOT NULL AUTO_INCREMENT,	206	`id` INT(11) NOT NULL AUTO_INCREMENT,
205	`ver_id` INT(5) DEFAULT NULL,	207	`ver_id` INT(5) DEFAULT NULL,
206	`rep_id` INT(5) DEFAULT NULL,	208	`rep_id` INT(5) DEFAULT NULL,
207	PRIMARY KEY (`id`),	209	PRIMARY KEY (`id`),
208	KEY `ver_id` (`ver_id`),	210	KEY `ver_id` (`ver_id`),
209	KEY `rep_id` (`rep_id`)	211	KEY `rep_id` (`rep_id`)
210	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;	212	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;
211		213
212	-- --------------------------------------------------------	214	-- --------------------------------------------------------
213		215
214	--	216	--
215	-- Структура таблицы `version`	217	-- Структура таблицы `version`
216	--	218	--
217		219
218	CREATE TABLE IF NOT EXISTS `version` (	220	CREATE TABLE IF NOT EXISTS `version` (
219	`version_id` INT(5) NOT NULL AUTO_INCREMENT,	221	`version_id` INT(5) NOT NULL AUTO_INCREMENT,
220	`dist_id` INT(5) DEFAULT NULL,	222	`dist_id` INT(5) DEFAULT NULL,
221	`vname` VARCHAR(25) DEFAULT NULL,	223	`vname` VARCHAR(25) DEFAULT NULL,
222	`version` VARCHAR(10) NOT NULL,	224	`version` VARCHAR(10) NOT NULL,
223	`vcodename` VARCHAR(10) DEFAULT NULL,	225	`vcodename` VARCHAR(10) DEFAULT NULL,
224	PRIMARY KEY (`version_id`),	226	PRIMARY KEY (`version_id`),
225	KEY `dist_id` (`dist_id`)	227	KEY `dist_id` (`dist_id`)
226	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;	228	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
227		229