WebSVN - ant - Различия - Редакция 158 и 206


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

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

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

CREATE TABLE IF NOT EXISTS `origin` (
  `orig_id` INT(5) NOT NULL AUTO_INCREMENT,
  `origin` VARCHAR(30) DEFAULT NULL,
  `desk` text NOT NULL,
  `basedir` VARCHAR(50) NOT NULL,
  `homeurl` VARCHAR(50) NOT NULL,
  `keyurl` VARCHAR(50) NOT NULL,
  PRIMARY KEY  (`orig_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

--
-- Структура таблицы `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,
  `orig_id` INT(5) NOT NULL,
  `default` tinyint(1) NOT NULL,
  PRIMARY KEY  (`rep_id`),
  KEY `scheme` (`scheme_id`),
  KEY `rtype_id` (`rtype_id`),
  KEY `root_id` (`root_id`),
  KEY `orig_id` (`orig_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=671 ;

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

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

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

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

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

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

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

Хранилища Subversion ant

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