WebSVN - ant - Различия - Редакция 86 и 90


-- phpMyAdmin SQL Dump
-- version 3.0.0-alpha
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Мар 25 2009 г., 08:47
-- Версия сервера: 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,
  `root_id` INT(2) NOT NULL,
  PRIMARY KEY  (`rep_id`),
  KEY `scheme` (`scheme_id`),
  KEY `rtype_id` (`rtype_id`),
  KEY `root_id` (`root_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;

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

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

CREATE TABLE IF NOT EXISTS `root` (
  `root_id` INT(2) NOT NULL AUTO_INCREMENT,
  `root_folder` VARCHAR(50) NOT NULL,
  PRIMARY KEY  (`root_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

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

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