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


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

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

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

CREATE TABLE IF NOT EXISTS `changelog` (
  `log_id` INT(5) NOT NULL AUTO_INCREMENT,
  `log_record` datetime NOT NULL,
  `log_title` VARCHAR(35) NOT NULL,
  `log_desc` text NOT NULL,
  PRIMARY KEY  (`log_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

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

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

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

Хранилища Subversion ant

(root)/trunk/sql/ant-scheme.sql @ 158 - Редакция 90 → 92

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