Context Navigation

sqldumpempty.sql @ 752

Revision 752, 66.3 KB checked in by r2, 14 months ago (diff)
installer 1.8
Property svn:executable set to ``*

Line
1	DROP TABLE IF EXISTS `#__actions`;
2	CREATE TABLE `#__actions` (
3	`id` int(11) NOT NULL AUTO_INCREMENT,
4	`component` varchar(20) NOT NULL,
5	`name` varchar(20) NOT NULL,
6	`title` varchar(100) NOT NULL,
7	`message` varchar(255) NOT NULL,
8	`is_tracked` tinyint(4) NOT NULL,
9	`is_visible` tinyint(4) NOT NULL,
10	PRIMARY KEY (`id`),
11	KEY `name` (`name`,`is_visible`)
12	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
13
14	INSERT INTO `#__actions` (`id`, `component`, `name`, `title`, `message`, `is_tracked`, `is_visible`) VALUES
15	(2, 'comments', 'add_comment', 'Äîáàâëåíèå êîììåíòàðèÿ', 'äîáàâëÿåò %s\| íà ñòðàíèöå %s', 1, 1),
16	(7, 'photos', 'add_photo', 'Äîáàâëåíèå ôîòî', 'äîáàâëÿåò ôîòî %s\| â àëüáîì %s', 1, 1),
17	(8, 'content', 'add_article', 'Äîáàâëåíèå ñòàòüè', 'äîáàâëÿåò ñòàòüþ %s\| â ðàçäåë %s', 1, 1),
18	(9, 'blogs', 'add_blog', 'Ñîçäàíèå áëîãà ïîëüçîâàòåëåì', 'ñîçäàåò áëîã %s\|', 1, 1),
19	(10, 'blogs', 'add_post', 'Äîáàâëåíèå çàïèñè â áëîã', 'ïèøåò ïîñò %s\| â áëîãå %s', 1, 1),
20	(11, 'users', 'set_status', 'Èçìåíåíèå ñòàòóñà ïîëüçîâàòåëÿ', '', 1, 1),
21	(12, 'board', 'add_board', 'Äîáàâëåíèå îáúÿâëåíèÿ', 'äîáàâëÿåò îáúÿâëåíèå %s\| â ðóáðèêó %s', 1, 1),
22	(13, 'catalog', 'add_catalog', 'Äîáàâëåíèå çàïèñè â êàòàëîã', 'äîáàâëÿåò çàïèñü %s\| â ðóáðèêó êàòàëîãà %s', 1, 1),
23	(14, 'clubs', 'add_club', 'Ñîçäàíèå êëóáà', 'ñîçäàåò êëóá %s\|', 1, 1),
24	(15, 'clubs', 'add_club_user', 'Âñòóïëåíèå â êëóá', 'âñòóïàåò â êëóá %s\|', 1, 1),
25	(16, 'faq', 'add_quest', 'Âîïðîñ', 'çàäàåò %s\| â êàòåãîðèè %s', 1, 1),
26	(17, 'forum', 'add_fpost', 'Äîáàâëåíèå ïîñòà â ôîðóìå', 'äîáàâëÿåò %s\| â òåìå %s', 1, 1),
27	(18, 'forum', 'add_thread', 'Äîáàâëåíèå òåìû íà ôîðóìå', 'ñîçäàåò òåìó %s\| íà ôîðóìå %s', 1, 1),
28	(19, 'users', 'add_avatar', 'Çàãðóçêà èëè ñìåíà àâàòàðà ïîëüçîâàòåëåì', 'èçìåíÿåò àâàòàð\|', 1, 1),
29	(20, 'users', 'add_friend', 'Äîáàâëåíèå äðóãà', 'è %s ñòàëè äðóçüÿìè\|', 1, 1),
30	(21, 'users', 'add_award', 'Ïîëó÷åíèå íàãðàäû ïîëüçîâàòåëåì', 'ïîëó÷àåò íàãðàäó %s\|', 1, 1),
31	(22, 'users', 'add_file', 'Çàãðóçêà ôàéëà ïîëüçîâàòåëåì', 'çàãðóæàåò ôàéë %s\|', 1, 1),
32	(23, 'users', 'add_wall', 'Äîáàâëåíèå çàïèñè íà ñòåíó', 'äîáàâëÿåò çàïèñü íà ñòåíå ïîëüçîâàòåëÿ %s\|', 1, 1),
33	(24, 'clubs', 'add_wall_club', 'Äîáàâëåíèå çàïèñè íà ñòåíó êëóáà', 'äîáàâëÿåò çàïèñü íà ñòåíå êëóáà %s\|', 1, 1),
34	(25, 'clubs', 'add_post_club', 'Äîáàâëåíèå çàïèñè â áëîã êëóáà', 'ïèøåò ïîñò %s\| â êëóáå %s', 1, 1),
35	(26, 'users', 'add_user_photo', 'Äîáàâëåíèå ôîòî â ëè÷íûé àëüáîì', 'äîáàâëÿåò ôîòî %s\| â àëüáîì %s', 1, 1),
36	(27, 'users', 'add_user_photo_multi', 'Äîáàâëåíèå ìíîãî ôîòîê â ëè÷íûé àëüáîì', 'äîáàâëÿåò %s ôîòî\| â àëüáîì %s', 1, 1),
37	(28, 'registration', 'add_user', 'Ðåãèñòðàöèÿ íîâîãî ïîëüçîâàòåëÿ', 'ðåãèñòðèðóåòñÿ. Ïðèâåòñòâóåì!\|', 1, 1),
38	(29, 'users', 'add_wall_my', 'Äîáàâëåíèå çàïèñè íà ñâîþ ñòåíó', 'ïèøåò íà ñâîåé ñòåíå\| ', 1, 1);
39
40	DROP TABLE IF EXISTS `#__actions_log`;
41	CREATE TABLE `#__actions_log` (
42	`id` int(11) NOT NULL AUTO_INCREMENT,
43	`action_id` int(11) NOT NULL,
44	`pubdate` datetime NOT NULL,
45	`user_id` int(11) NOT NULL,
46	`object` varchar(100) NOT NULL,
47	`object_url` varchar(255) NOT NULL,
48	`object_id` int(11) NOT NULL,
49	`target` varchar(100) NOT NULL,
50	`target_url` varchar(255) NOT NULL,
51	`target_id` int(11) NOT NULL,
52	`description` varchar(650) DEFAULT NULL,
53	`is_friends_only` tinyint(4) NOT NULL DEFAULT '0',
54	`is_users_only` tinyint(4) NOT NULL DEFAULT '0',
55	PRIMARY KEY (`id`),
56	KEY `action_id` (`action_id`,`user_id`),
57	KEY `object_id` (`object_id`),
58	KEY `target_id` (`target_id`)
59	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
60
61
62	DROP TABLE IF EXISTS `#__banlist`;
63	CREATE TABLE `#__banlist` (
64	`id` int(11) NOT NULL AUTO_INCREMENT,
65	`user_id` int(11) NOT NULL,
66	`ip` varchar(15) NOT NULL,
67	`bandate` datetime NOT NULL,
68	`int_num` int(11) NOT NULL,
69	`int_period` varchar(20) NOT NULL,
70	`status` int(11) NOT NULL DEFAULT '1',
71	`autodelete` int(11) NOT NULL,
72	PRIMARY KEY (`id`)
73	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
74
75
76	DROP TABLE IF EXISTS `#__banners`;
77	CREATE TABLE `#__banners` (
78	`id` int(11) NOT NULL AUTO_INCREMENT,
79	`position` varchar(100) NOT NULL DEFAULT 'banner_top',
80	`typeimg` varchar(10) NOT NULL DEFAULT 'image',
81	`fileurl` varchar(250) DEFAULT NULL,
82	`hits` int(11) NOT NULL,
83	`clicks` int(11) NOT NULL,
84	`maxhits` int(11) NOT NULL,
85	`maxuser` int(11) NOT NULL,
86	`user_id` int(11) NOT NULL DEFAULT '1',
87	`pubdate` datetime DEFAULT NULL,
88	`title` varchar(250) DEFAULT NULL,
89	`link` varchar(250) DEFAULT NULL,
90	`published` int(11) NOT NULL DEFAULT '1',
91	PRIMARY KEY (`id`)
92	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
93
94	INSERT INTO `#__banners` (`id`, `position`, `typeimg`, `fileurl`, `hits`, `clicks`, `maxhits`, `maxuser`, `user_id`, `pubdate`, `title`, `link`, `published`) VALUES
95	(4, 'banner1', 'image', 'banner468x60v1.gif', 0, 0, 0, 0, 1, '2009-04-04 19:43:53', 'InstantCMS - Áåñïëàòíàÿ ñèñòåìà óïðàâëåíèÿ ñàéòîì', 'http://www.instantcms.ru/', 1);
96
97	DROP TABLE IF EXISTS `#__banner_hits`;
98	CREATE TABLE `#__banner_hits` (
99	`id` int(11) NOT NULL AUTO_INCREMENT,
100	`banner_id` int(11) DEFAULT NULL,
101	`ip` varchar(16) DEFAULT NULL,
102	`pubdate` datetime DEFAULT NULL,
103	PRIMARY KEY (`id`)
104	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
105
106
107	DROP TABLE IF EXISTS `#__blogs`;
108	CREATE TABLE `#__blogs` (
109	`id` int(11) NOT NULL AUTO_INCREMENT,
110	`user_id` int(11) NOT NULL,
111	`title` varchar(250) NOT NULL,
112	`pubdate` datetime NOT NULL,
113	`allow_who` varchar(15) NOT NULL,
114	`view_type` varchar(15) NOT NULL DEFAULT 'list',
115	`showcats` int(11) NOT NULL DEFAULT '1',
116	`ownertype` varchar(15) NOT NULL DEFAULT 'single',
117	`premod` int(11) NOT NULL,
118	`forall` int(11) NOT NULL DEFAULT '1',
119	`owner` varchar(10) NOT NULL DEFAULT 'user',
120	`seolink` varchar(255) NOT NULL,
121	`rating` int(11) NOT NULL,
122	PRIMARY KEY (`id`),
123	KEY `seolink` (`seolink`),
124	KEY `user_id` (`user_id`),
125	KEY `pubdate` (`pubdate`)
126	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
127
128
129	DROP TABLE IF EXISTS `#__blog_authors`;
130	CREATE TABLE `#__blog_authors` (
131	`id` int(11) NOT NULL AUTO_INCREMENT,
132	`user_id` int(11) NOT NULL,
133	`blog_id` int(11) NOT NULL,
134	`description` varchar(100) NOT NULL,
135	`startdate` datetime NOT NULL,
136	PRIMARY KEY (`id`),
137	KEY `user_id` (`user_id`),
138	KEY `blog_id` (`blog_id`)
139	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
140
141
142	DROP TABLE IF EXISTS `#__blog_cats`;
143	CREATE TABLE `#__blog_cats` (
144	`id` int(11) NOT NULL AUTO_INCREMENT,
145	`blog_id` int(11) NOT NULL,
146	`title` varchar(250) NOT NULL,
147	PRIMARY KEY (`id`),
148	KEY `blog_id` (`blog_id`)
149	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
150
151
152	DROP TABLE IF EXISTS `#__blog_files`;
153	CREATE TABLE `#__blog_files` (
154	`id` int(11) NOT NULL AUTO_INCREMENT,
155	`post_id` int(11) NOT NULL,
156	`filename` varchar(200) NOT NULL,
157	`filesize` int(11) NOT NULL,
158	`hits` int(11) NOT NULL,
159	`pubdate` datetime NOT NULL,
160	PRIMARY KEY (`id`)
161	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
162
163
164	DROP TABLE IF EXISTS `#__blog_posts`;
165	CREATE TABLE `#__blog_posts` (
166	`id` int(11) NOT NULL AUTO_INCREMENT,
167	`user_id` int(11) NOT NULL,
168	`cat_id` int(11) NOT NULL,
169	`blog_id` int(11) NOT NULL,
170	`pubdate` datetime NOT NULL,
171	`title` varchar(250) NOT NULL,
172	`feel` varchar(100) NOT NULL,
173	`music` varchar(100) NOT NULL,
174	`content` text NOT NULL,
175	`content_html` text NOT NULL,
176	`allow_who` varchar(20) NOT NULL,
177	`edit_times` int(11) NOT NULL,
178	`edit_date` datetime NOT NULL,
179	`published` int(11) NOT NULL DEFAULT '1',
180	`seolink` varchar(255) NOT NULL,
181	`comments` tinyint(4) NOT NULL DEFAULT '1',
182	PRIMARY KEY (`id`),
183	KEY `seolink` (`seolink`),
184	KEY `blog_id` (`blog_id`),
185	KEY `user_id` (`user_id`),
186	FULLTEXT KEY `content` (`content`)
187	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
188
189
190	DROP TABLE IF EXISTS `#__board_cats`;
191	CREATE TABLE `#__board_cats` (
192	`id` int(11) NOT NULL AUTO_INCREMENT,
193	`parent_id` int(11) NOT NULL,
194	`ordering` int(11) NOT NULL DEFAULT '1',
195	`NSLeft` int(11) NOT NULL,
196	`NSRight` int(11) NOT NULL,
197	`NSDiffer` varchar(15) NOT NULL,
198	`NSIgnore` int(11) NOT NULL,
199	`NSLevel` int(11) NOT NULL,
200	`title` varchar(100) NOT NULL,
201	`description` varchar(100) NOT NULL,
202	`published` int(11) NOT NULL,
203	`orderform` int(11) DEFAULT '1',
204	`showdate` int(11) NOT NULL DEFAULT '1',
205	`pubdate` datetime NOT NULL,
206	`orderby` varchar(20) NOT NULL DEFAULT 'title',
207	`orderto` varchar(4) NOT NULL DEFAULT 'asc',
208	`public` int(11) NOT NULL,
209	`perpage` int(11) NOT NULL DEFAULT '15',
210	`maxcols` int(11) NOT NULL DEFAULT '1',
211	`thumb1` int(11) NOT NULL DEFAULT '64',
212	`thumb2` int(11) NOT NULL DEFAULT '400',
213	`thumbsqr` int(11) NOT NULL,
214	`uplimit` int(11) NOT NULL DEFAULT '10',
215	`is_photos` int(11) NOT NULL DEFAULT '1',
216	`icon` varchar(25) DEFAULT 'folder_grey.png',
217	`obtypes` text NOT NULL,
218	PRIMARY KEY (`id`)
219	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
220
221	INSERT INTO `#__board_cats` (`id`, `parent_id`, `ordering`, `NSLeft`, `NSRight`, `NSDiffer`, `NSIgnore`, `NSLevel`, `title`, `description`, `published`, `orderform`, `showdate`, `pubdate`, `orderby`, `orderto`, `public`, `perpage`, `maxcols`, `thumb1`, `thumb2`, `thumbsqr`, `uplimit`, `is_photos`, `icon`, `obtypes`) VALUES
222	(1, 0, 1, 1, 8, '', 0, 0, '-- Êîðíåâàÿ ðóáðèêà --', '', 1, 1, 1, '2008-09-22 13:39:32', 'pubdate', 'desc', 0, 15, 1, 64, 400, 0, 10, 1, 'folder_grey.png', ''),
223	(10, 1, 21, 2, 3, '', 0, 1, 'Óñëóãè', '', 1, 1, 1, '2008-09-22 14:30:29', 'pubdate', 'desc', -1, 20, 1, 64, 400, 0, 10, 1, 'folder_grey.png', 'Ïðåäëàãàþ\r\nÒðåáóåòñÿ'),
224	(9, 1, 23, 6, 7, '', 0, 1, 'Àâòîìîáèëè', '', 1, 1, 1, '2008-09-22 14:30:23', 'pubdate', 'desc', -1, 20, 1, 64, 400, 0, 10, 1, 'folder_grey.png', 'Êóïëþ\r\nÏðîäàì\r\nÎáìåíÿþ'),
225	(8, 1, 22, 4, 5, '', 0, 1, 'Íåäâèæèìîñòü', '', 1, 1, 1, '2008-09-22 14:30:00', 'pubdate', 'desc', -1, 20, 1, 64, 400, 0, 10, 1, 'folder_grey.png', 'Ïðîäàì\r\nÊóïëþ\r\nÎáìåíÿþ\r\nÑäàì\r\nÑíèìó');
226
227	DROP TABLE IF EXISTS `#__board_items`;
228	CREATE TABLE `#__board_items` (
229	`id` int(11) NOT NULL AUTO_INCREMENT,
230	`category_id` int(11) NOT NULL,
231	`user_id` int(11) NOT NULL,
232	`obtype` varchar(50) NOT NULL,
233	`title` varchar(250) NOT NULL,
234	`content` text NOT NULL,
235	`city` varchar(100) NOT NULL,
236	`pubdate` datetime DEFAULT NULL,
237	`pubdays` int(11) NOT NULL,
238	`published` int(11) NOT NULL,
239	`file` varchar(250) NOT NULL,
240	`hits` int(11) NOT NULL,
241	`is_vip` tinyint(4) NOT NULL DEFAULT '0',
242	`vipdate` datetime NOT NULL,
243	PRIMARY KEY (`id`),
244	KEY `category_id` (`category_id`),
245	KEY `user_id` (`user_id`),
246	KEY `obtype` (`obtype`),
247	KEY `city` (`city`),
248	FULLTEXT KEY `content` (`content`)
249	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
250
251
252	DROP TABLE IF EXISTS `#__cache`;
253	CREATE TABLE `#__cache` (
254	`id` int(11) NOT NULL AUTO_INCREMENT,
255	`target` varchar(10) NOT NULL,
256	`target_id` varchar(255) NOT NULL,
257	`cachedate` datetime NOT NULL,
258	`cachefile` varchar(80) NOT NULL,
259	PRIMARY KEY (`id`)
260	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
261
262
263	DROP TABLE IF EXISTS `#__category`;
264	CREATE TABLE `#__category` (
265	`id` int(11) NOT NULL AUTO_INCREMENT,
266	`parent_id` int(11) DEFAULT NULL,
267	`title` varchar(200) NOT NULL,
268	`description` text NOT NULL,
269	`published` int(11) NOT NULL,
270	`showdate` int(11) NOT NULL DEFAULT '1',
271	`showcomm` int(11) NOT NULL DEFAULT '1',
272	`orderby` varchar(30) NOT NULL DEFAULT 'date',
273	`orderto` varchar(4) NOT NULL DEFAULT 'asc',
274	`modgrp_id` int(11) NOT NULL,
275	`NSLeft` int(11) NOT NULL,
276	`NSRight` int(11) NOT NULL,
277	`NSLevel` int(11) NOT NULL,
278	`NSDiffer` varchar(11) NOT NULL,
279	`NSIgnore` int(11) NOT NULL,
280	`ordering` int(11) NOT NULL,
281	`maxcols` int(11) NOT NULL DEFAULT '1',
282	`showtags` int(11) NOT NULL DEFAULT '1',
283	`showrss` int(11) NOT NULL DEFAULT '1',
284	`showdesc` int(11) NOT NULL,
285	`is_public` int(11) NOT NULL,
286	`photoalbum` text NOT NULL,
287	`seolink` varchar(200) NOT NULL,
288	`url` varchar(100) NOT NULL,
289	`tpl` varchar(50) NOT NULL DEFAULT 'com_content_view.tpl',
290	`cost` varchar(5) NOT NULL,
291	PRIMARY KEY (`id`),
292	UNIQUE KEY `seolink` (`seolink`),
293	KEY `parent_id` (`parent_id`)
294	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
295
296	INSERT INTO `#__category` (`id`, `parent_id`, `title`, `description`, `published`, `showdate`, `showcomm`, `orderby`, `orderto`, `modgrp_id`, `NSLeft`, `NSRight`, `NSLevel`, `NSDiffer`, `NSIgnore`, `ordering`, `maxcols`, `showtags`, `showrss`, `showdesc`, `is_public`, `photoalbum`, `seolink`, `url`, `tpl`, `cost`) VALUES
297	(1, 0, '--Êîðíåâîé ðàçäåë--', 'Êîðíåâîé ðàçäåë ñàéòà', 1, 1, 1, 'pubdate', 'asc', 0, 1, 2, 0, '', 0, 1, 1, 1, 1, 0, 0, '', '--kornevoi-razdel--', '', 'com_content_view.tpl', '');
298
299	DROP TABLE IF EXISTS `#__clubs`;
300	CREATE TABLE `#__clubs` (
301	`id` int(11) NOT NULL AUTO_INCREMENT,
302	`admin_id` int(11) NOT NULL DEFAULT '1',
303	`title` text NOT NULL,
304	`description` longtext NOT NULL,
305	`imageurl` varchar(100) NOT NULL,
306	`pubdate` datetime NOT NULL,
307	`clubtype` varchar(15) NOT NULL DEFAULT 'public',
308	`published` int(11) NOT NULL DEFAULT '1',
309	`maxsize` int(11) NOT NULL,
310	`enabled_blogs` int(11) DEFAULT '1',
311	`enabled_photos` int(11) DEFAULT '1',
312	`rating` int(11) NOT NULL,
313	`photo_premod` int(11) NOT NULL,
314	`blog_premod` int(11) NOT NULL,
315	`blog_min_karma` int(11) NOT NULL,
316	`photo_min_karma` int(11) NOT NULL,
317	`album_min_karma` int(11) NOT NULL DEFAULT '25',
318	`join_min_karma` int(11) NOT NULL,
319	`join_karma_limit` int(11) NOT NULL,
320	`create_karma` int(11) NOT NULL,
321	`is_vip` tinyint(4) NOT NULL DEFAULT '0',
322	`join_cost` float NOT NULL,
323	PRIMARY KEY (`id`),
324	KEY `pubdate` (`pubdate`),
325	KEY `admin_id` (`admin_id`)
326	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
327
328
329	DROP TABLE IF EXISTS `#__codecheck`;
330	CREATE TABLE `#__codecheck` (
331	`id` int(11) NOT NULL AUTO_INCREMENT,
332	`place` varchar(200) NOT NULL,
333	`code` varchar(40) NOT NULL,
334	`session_id` varchar(200) NOT NULL,
335	PRIMARY KEY (`id`)
336	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
337
338
339	DROP TABLE IF EXISTS `#__comments`;
340	CREATE TABLE `#__comments` (
341	`id` int(11) NOT NULL AUTO_INCREMENT,
342	`parent_id` int(11) NOT NULL,
343	`pid` int(11) NOT NULL,
344	`user_id` int(11) NOT NULL,
345	`target` varchar(20) NOT NULL,
346	`target_id` int(11) NOT NULL,
347	`guestname` varchar(200) NOT NULL,
348	`content` text NOT NULL,
349	`content_bbcode` text NOT NULL,
350	`pubdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
351	`published` int(11) NOT NULL DEFAULT '1',
352	`is_new` int(11) NOT NULL DEFAULT '1',
353	`target_title` varchar(150) NOT NULL,
354	`target_link` varchar(200) NOT NULL,
355	`ip` varchar(15) NOT NULL,
356	PRIMARY KEY (`id`),
357	KEY `user_id` (`user_id`),
358	KEY `target_id` (`target_id`)
359	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
360
361
362	DROP TABLE IF EXISTS `#__comments_votes`;
363	CREATE TABLE `#__comments_votes` (
364	`comment_id` int(11) NOT NULL,
365	`comment_type` varchar(3) NOT NULL,
366	`vote` smallint(6) NOT NULL,
367	`user_id` int(11) NOT NULL,
368	KEY `comment_id` (`comment_id`,`comment_type`)
369	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
370
371
372	DROP TABLE IF EXISTS `#__comment_targets`;
373	CREATE TABLE `#__comment_targets` (
374	`id` int(11) NOT NULL AUTO_INCREMENT,
375	`target` varchar(32) NOT NULL,
376	`component` varchar(32) NOT NULL,
377	`title` varchar(100) NOT NULL,
378	PRIMARY KEY (`id`),
379	KEY `target` (`target`,`component`)
380	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
381
382	INSERT INTO `#__comment_targets` (`id`, `target`, `component`, `title`) VALUES
383	(1, 'article', 'content', 'Ñòàòüè'),
384	(2, 'blog', 'blogs', 'Ïîñòû áëîãîâ'),
385	(3, 'palbum', 'photos', 'Ôîòîàëüáîìû'),
386	(4, 'photo', 'photos', 'Ôîòîãðàôèè ãàëåðåè'),
387	(5, 'userphoto', 'users', 'Ôîòîãðàôèè ïîëüçîâàòåëåé'),
388	(6, 'catalog', 'catalog', 'Çàïèñè êàòàëîãà'),
389	(7, 'boarditem', 'board', 'Îáúÿâëåíèÿ'),
390	(8, 'faq', 'faq', 'Âîïðîñû FAQ');
391
392	DROP TABLE IF EXISTS `#__components`;
393	CREATE TABLE `#__components` (
394	`id` int(11) NOT NULL AUTO_INCREMENT,
395	`title` varchar(200) NOT NULL,
396	`link` varchar(200) NOT NULL,
397	`config` text NOT NULL,
398	`internal` int(11) NOT NULL,
399	`author` varchar(200) NOT NULL DEFAULT 'InstantCMS team',
400	`published` int(11) NOT NULL DEFAULT '1',
401	`version` varchar(6) NOT NULL DEFAULT '1.5',
402	`system` int(11) NOT NULL DEFAULT '1',
403	PRIMARY KEY (`id`)
404	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
405
406	INSERT INTO `#__components` (`id`, `title`, `link`, `config`, `internal`, `author`, `published`, `version`, `system`) VALUES
407	(1, 'Êàòàëîã ñòàòåé', 'content', '---\nreaddesc: 0\nrating: 1\nperpage: 15\npt_show: 1\npt_disp: 1\npt_hide: 1\nautokeys: 1\nimg_small_w: 100\nimg_big_w: 200\nimg_sqr: 1\nimg_users: 1\nwatermark: 1\nwatermark_only_big: 1\naf_on: 0\naf_delete: 1\naf_showlink: 1\naf_forum_id: 1\naf_hidecat_id: 2\n', 0, 'InstantCMS team', 1, '1.5', 1),
408	(2, 'Ðåãèñòðàöèÿ', 'registration', '---\nreg_type: open\ninv_count: 3\ninv_karma: 1\ninv_period: WEEK\nis_on: 1\nact: 0\nsend: false\noffmsg: >\n Ðåãèñòðàöèÿ ïðèîñòàíîâëåíà ïî\n òåõíè÷åñêèì ïðè÷èíàì.\nfirst_auth_redirect: profile\nauth_redirect: profile\nname_mode: nickname\nbadnickname: \|\n àäìèíèñòðàòîð\n àäìèí\n qwert\n qwerty\n 123\n admin\n âàñÿ ïóïêèí\nask_icq: 1\nask_birthdate: 1\nsend_greetmsg: 0\ngreetmsg: \|\n <span style="font-size: medium;"><br />\n </span>\n <p> </p>\n', 0, 'InstantCMS team', 1, '1.5', 1),
409	(3, 'Ôîòîãàëåðåÿ', 'photos', '---\nlink: 0\nsaveorig: 0\nmaxcols: 2\norderby: title\norderto: desc\nshowlat: 1\nwatermark: 1\ntumb_view: 2\ntumb_from: 1\ntumb_club: \nis_today: 1\n', 0, 'InstantCMS team', 1, '1.5', 1),
410	(4, 'Ïðàéñ-ëèñò', 'price', '---\n', 0, 'InstantCMS team', 1, '1.5', 1),
411	(5, 'Ïîèñê', 'search', '---\nperpage: 10\ncomp: \n - content\n - photos\n - price\n - catalog\n - forum\n - blogs\n - board\n', 0, 'InstantCMS team', 1, '1.5', 1),
412	(6, 'Êîíñòðóêòîð ôîðì', 'forms', '---\n', 0, 'InstantCMS team', 1, '1.5', 1),
413	(7, 'Êîììåíòàðèè ïîëüçîâàòåëåé', 'comments', '---\nemail: \ncanguests: 1\nregcap: 0\npublish: 1\nsmiles: 1\nbbcode: 1\nselfdel: 0\nsubscribe: 1\nanchors: 0\nrecode: 0\nmin_karma: 0\nmin_karma_show: 0\nmin_karma_add: 0\nperpage: 20\nj_code: 1\ncmm_ajax: 0\ncmm_ip: 1\n', 1, 'InstantCMS team', 1, '1.5', 1),
414	(8, 'Àðõèâ ìàòåðèàëîâ', 'arhive', '---\n', 0, 'InstantCMS team', 1, '1.5', 1),
415	(9, 'Óíèâåðñàëüíûé êàòàëîã', 'catalog', '---\nemail: shop@site.ru\ndelivery: \|\n Ñâåäåíèÿ î äîñòàâêå.\n Ýòîò òåêñò ìîæíî èçìåíèòü â íàñòðîéêàõ êîìïîíåíòà "Óíèâåðñàëüíûé êàòàëîã".\nnotice: 1\npremod: 1\npremod_msg: 1\nis_comments: 1\nis_rss: 1\nwatermark: 1\n', 0, 'InstantCMS team', 1, '1.5', 1),
416	(10, 'Ïðîôèëè ïîëüçîâàòåëåé', 'users', '---\nshowgroup: 1\nsw_stats: \nsw_comm: 1\nsw_search: 1\nsw_forum: 1\nsw_photo: 1\nsw_wall: 1\nsw_friends: 1\nsw_blogs: 1\nsw_clubs: 1\nsw_feed: 1\nsw_content: 1\nsw_awards: 1\nsw_board: 1\nsw_msg: 1\nsw_guest: 1\nkarmatime: 1\nkarmaint: DAY\nphotosize: 0\nwatermark: 1\nsmallw: 64\nmedw: 200\nmedh: 500\nsw_files: 1\nfilessize: 100\nfilestype: jpeg,gif,png,jpg,bmp,zip,rar,tar\nprivforms: \n - 3\nj_code: 1\ndeltime: 6\n', 0, 'InstantCMS team', 1, '1.5', 1),
417	(12, 'Ôîðóì', 'forum', '---\nis_on: 1\nkarma: 1\nis_rss: 1\npp_thread: 15\npp_forum: 15\nshowimg: 1\nimg_on: 1\nimg_max: 5\nfast_on: 1\nfast_bb: 1\nfa_on: 1\nfa_allow: -1\nfa_max: 25\nfa_ext: txt doc zip rar arj png gif jpg jpeg bmp\nfa_size: 1024\n', 0, 'InstantCMS team', 1, '1.5', 1),
418	(13, 'Ñòàòèñòèêà ñàéòà', 'statistics', '---\n', 1, 'InstantCMS team', 1, '1.5', 1),
419	(15, 'Áëîãè', 'blogs', '---\nperpage: 10\nperpage_blog: 15\nupdate_date: 0\nupdate_seo_link: 0\nmin_karma_private: 0\nmin_karma_public: 5\nmin_karma: 1\nwatermark: 1\nimg_on: 1\nrss_all: 1\nrss_one: 1\nj_code: 1\n', 0, 'InstantCMS team', 1, '1.5', 1),
420	(16, 'Âîïðîñû è îòâåòû', 'faq', '---\n', 0, 'InstantCMS team', 1, '1.5', 1),
421	(17, 'Áàííåðû', 'banners', '---\n', 1, 'InstantCMS team', 1, '1.5', 1),
422	(19, 'RSS ãåíåðàòîð', 'rssfeed', '---\naddsite: 1\nmaxitems: 50\nicon_on: 1\nicon_url: http://icms/images/rss.png\nicon_title: InstantCMS\nicon_link: http://icms/images/rss.png\n', 1, 'InstantCMS team', 1, '1.5', 1),
423	(21, 'Íàãðàæäåíèå ïîëüçîâàòåëåé', 'autoawards', '---\n', 1, 'InstantCMS team', 1, '1.5', 1),
424	(22, 'Äîñêà îáúÿâëåíèé', 'board', '---\nmaxcols: 3\nobtypes: \|\n Ïðîäàì\n Êóïëþ\n Îáìåíÿþ\n Ïîäàðþ\nshowlat: \npublic: 2\nphotos: 1\nsrok: 1\npubdays: 10\nwatermark: 0\naftertime: \ncomments: 1\n', 0, 'InstantCMS team', 1, '1.5', 1),
425	(23, 'Êëóáû ïîëüçîâàòåëåé', 'clubs', '---\nseo_club: title\nenabled_blogs: 1\nenabled_photos: 1\nthumb1: 48\nthumb2: 200\nthumbsqr: 1\ncancreate: 1\nperpage: 10\ncreate_min_karma: 0\ncreate_min_rating: 0\n', 0, 'InstantCMS team', 1, '1.5', 1);
426
427	DROP TABLE IF EXISTS `#__content`;
428	CREATE TABLE `#__content` (
429	`id` int(11) NOT NULL AUTO_INCREMENT,
430	`category_id` int(11) NOT NULL,
431	`user_id` int(11) NOT NULL DEFAULT '1',
432	`pubdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
433	`enddate` date NOT NULL,
434	`is_end` int(11) NOT NULL,
435	`title` varchar(200) NOT NULL,
436	`description` text NOT NULL,
437	`content` longtext,
438	`published` int(11) NOT NULL DEFAULT '1',
439	`hits` int(11) NOT NULL,
440	`meta_desc` text NOT NULL,
441	`meta_keys` text NOT NULL,
442	`showtitle` int(11) NOT NULL DEFAULT '1',
443	`showdate` int(11) NOT NULL DEFAULT '1',
444	`showlatest` int(11) NOT NULL DEFAULT '1',
445	`showpath` int(11) NOT NULL DEFAULT '1',
446	`ordering` int(1) NOT NULL,
447	`comments` int(11) NOT NULL DEFAULT '1',
448	`is_arhive` int(11) NOT NULL,
449	`seolink` varchar(200) NOT NULL,
450	`canrate` int(11) NOT NULL DEFAULT '1',
451	`pagetitle` varchar(255) NOT NULL,
452	`url` varchar(100) NOT NULL,
453	`tpl` varchar(50) NOT NULL DEFAULT 'com_content_read.tpl',
454	PRIMARY KEY (`id`),
455	UNIQUE KEY `seolink` (`seolink`),
456	KEY `category_id` (`category_id`),
457	KEY `user_id` (`user_id`),
458	FULLTEXT KEY `title` (`title`),
459	FULLTEXT KEY `content` (`content`)
460	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
461
462
463	DROP TABLE IF EXISTS `#__content_access`;
464	CREATE TABLE `#__content_access` (
465	`id` int(11) NOT NULL AUTO_INCREMENT,
466	`content_id` int(11) NOT NULL,
467	`content_type` varchar(100) NOT NULL,
468	`group_id` int(11) NOT NULL,
469	PRIMARY KEY (`id`),
470	KEY `content_id` (`content_id`)
471	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
472
473
474	DROP TABLE IF EXISTS `#__cron_jobs`;
475	CREATE TABLE `#__cron_jobs` (
476	`id` int(11) NOT NULL AUTO_INCREMENT,
477	`job_name` varchar(50) NOT NULL,
478	`job_interval` smallint(6) NOT NULL DEFAULT '1',
479	`job_run_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
480	`component` varchar(20) NOT NULL,
481	`model_method` varchar(100) NOT NULL,
482	`custom_file` varchar(250) NOT NULL,
483	`is_enabled` tinyint(4) NOT NULL DEFAULT '1',
484	`is_new` smallint(6) NOT NULL DEFAULT '1',
485	`comment` varchar(200) NOT NULL,
486	`class_name` varchar(50) NOT NULL,
487	`class_method` varchar(50) NOT NULL,
488	PRIMARY KEY (`id`),
489	KEY `job_name` (`job_name`,`is_enabled`)
490	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
491
492	INSERT INTO `#__cron_jobs` (`id`, `job_name`, `job_interval`, `job_run_date`, `component`, `model_method`, `custom_file`, `is_enabled`, `is_new`, `comment`, `class_name`, `class_method`) VALUES
493	(1, 'photos_clear', 24, '2010-12-06 21:11:26', 'users', 'clearUploadedPhotos', '', 1, 1, 'Óäàëåíèå íåèñïîëüçóåìûõ ëè÷íûõ ôîòîãðàôèé', '', ''),
494	(2, 'optimize_tables', 24, '2010-12-06 21:11:26', '', '', '', 1, 1, 'Îïòèìèçàöèÿ òàáëèö ÁÄ', 'db\|cmsDatabase', 'optimizeTables'),
495	(3, 'drop_inactive_users', 48, '2010-12-06 21:11:26', 'users', 'deleteInactiveUsers', '', 1, 1, 'Óäàëåíèå íåàêòèâíûõ ïîëüçîâàòåëåé (ñì. íàñòðîéêè êîìïîíåíòà "Ïðîôèëè ïîëüçîâàòåëåé")', '', ''),
496	(4, 'remove_old_log', 48, '2010-12-06 21:11:26', '', '', '', 1, 1, 'Óäàëÿåò ñòàðûå çàïèñè ëåíòû ñîáûòèé', 'actions\|cmsActions', 'removeOldLog'),
497	(5, 'give_invites', 24, '2010-12-06 21:11:26', 'users', 'giveInvitesCron', '', 1, 1, 'Âûäà÷à èíâàéòîâ ïîëüçîâàòåëÿì', '', ''),
498	(6, 'clear_invites', 24, '2010-12-06 21:11:26', 'users', 'clearInvites', '', 1, 1, 'Óäàëåíèå èñïîëüçîâàííûõ èíâàéòîâ', '', '');
499
500	DROP TABLE IF EXISTS `#__downloads`;
501	CREATE TABLE `#__downloads` (
502	`id` int(11) NOT NULL AUTO_INCREMENT,
503	`fileurl` varchar(250) NOT NULL,
504	`hits` int(11) NOT NULL,
505	PRIMARY KEY (`id`)
506	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
507
508
509	DROP TABLE IF EXISTS `#__event_hooks`;
510	CREATE TABLE `#__event_hooks` (
511	`id` int(11) NOT NULL AUTO_INCREMENT,
512	`event` varchar(50) NOT NULL,
513	`plugin_id` varchar(30) NOT NULL,
514	PRIMARY KEY (`id`),
515	KEY `event` (`event`,`plugin_id`)
516	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
517
518	INSERT INTO `#__event_hooks` (`id`, `event`, `plugin_id`) VALUES
519	(6, 'GET_ARTICLE', '5'),
520	(3, 'INSERT_WYSIWYG', '3'),
521	(7, 'USER_PROFILE', '6'),
522	(11, 'ADD_ARTICLE_DONE', '8'),
523	(10, 'ADD_POST_DONE', '8'),
524	(34, 'GET_FORUM_POSTS', '14'),
525	(33, 'GET_COMMENTS', '14'),
526	(32, 'GET_BEST_POSTS', '14'),
527	(31, 'GET_LATEST_POSTS', '14'),
528	(30, 'GET_POST', '14'),
529	(29, 'GET_POSTS', '14'),
530	(35, 'GET_WALL_POSTS', '14'),
531	(36, 'GET_ARTICLE', '15');
532
533	DROP TABLE IF EXISTS `#__faq_cats`;
534	CREATE TABLE `#__faq_cats` (
535	`id` int(11) NOT NULL AUTO_INCREMENT,
536	`parent_id` int(11) NOT NULL,
537	`title` varchar(250) NOT NULL,
538	`description` text NOT NULL,
539	`published` int(11) NOT NULL DEFAULT '1',
540	PRIMARY KEY (`id`)
541	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
542
543
544	DROP TABLE IF EXISTS `#__faq_quests`;
545	CREATE TABLE `#__faq_quests` (
546	`id` int(11) NOT NULL AUTO_INCREMENT,
547	`category_id` int(11) NOT NULL,
548	`pubdate` datetime NOT NULL,
549	`published` int(11) NOT NULL,
550	`quest` text NOT NULL,
551	`answer` text NOT NULL,
552	`user_id` int(11) NOT NULL,
553	`answeruser_id` int(11) NOT NULL,
554	`answerdate` datetime NOT NULL,
555	`hits` int(11) NOT NULL,
556	PRIMARY KEY (`id`),
557	KEY `category_id` (`category_id`)
558	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
559
560
561	DROP TABLE IF EXISTS `#__filters`;
562	CREATE TABLE `#__filters` (
563	`id` int(11) NOT NULL AUTO_INCREMENT,
564	`title` varchar(100) NOT NULL,
565	`description` text NOT NULL,
566	`link` varchar(100) NOT NULL,
567	`published` int(11) NOT NULL,
568	PRIMARY KEY (`id`)
569	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
570
571	INSERT INTO `#__filters` (`id`, `title`, `description`, `link`, `published`) VALUES
572	(1, 'Àâòîçàìåíà / Ôèëüòð ññûëîê', 'Ôèëüòð âûïîëíÿåò çàìåíó âûðàæåíèé ïî ñîçäàííûì âàìè ïðàâèëàì, à òàê æå ñëóæèò äëÿ ñîçäàíèÿ ññûëîê â êàòåãîðèè ïðàéñëèñòà, ôîòîàëüáîìû è ôîòîãðàôèè.<br/><br/>{ÏÐÀÉÑ=Íàçâàíèå êàòåãîðèè}, <br/>{ÔÎÒÎ=Íàçâàíèå ôîòîãðàôèè}, <br/>{ÀËÜÁÎÌ=Íàçâàíèå ôîòîàëüáîìà}, <br/>{ÌÀÒÅÐÈÀË=Íàçâàíèå ìàòåðèàëà}<br/>{ÔÎÐÌÀ=Íàçâàíèå ôîðìû} - ôîðìà ñ çàãîëîâêîì<br/>\r\n{ÁËÀÍÊ=Íàçâàíèå ôîðìû} - ôîðìà áåç çàãîëîâêà', 'f_replace', 1),
573	(4, 'Ïîñòðàíè÷íûé âûâîä', 'Ôèëüòð ðàçáèâàåò òåêñò ìàòåðèàëà íà íåñêîëüêî ñòðàíèö â òåõ ìåñòàõ ãäå áóäåò íàéäåí òýã {pagebreak}.', 'f_pages', 1),
574	(2, 'Ñîäåðæàíèå ñòàòüè', 'Ôèëüòð èùåò òýãè {ÑÒÐÀÍÈÖÀ=Íàçâàíèå ñòðàíèöû} â òåêñòàõ ñòàòåé, è çàìåíÿåò èõ íà ãëàâû â ñîäåðæàíèè ñòàòüè.', 'f_contents', 1),
575	(5, 'Âíåøíèå ñêðèïòû', 'Ôèëüòð íàõîäèò â òåêñòàõ ñòàòåé è ìîäóëåé âûðàæåíèÿ "{ÔÀÉË=script.php}" è çàìåíÿåò èõ ðåçóëüòàòàìè âûïîëíåíèÿ ñîîòâåòñòâóþùèõ ñêðèïòîâ èç ïàïêè "/includes/myphp/".', 'f_includes', 1),
576	(6, 'Ñ÷åò÷èê ñêà÷èâàíèé', 'Ôèëüòð íàõîäèò â òåêñòàõ ñòàòåé è ìîäóëåé âûðàæåíèÿ "{ÑÊÀ×ÀÒÜ=/path/file.zip}" è çàìåíÿåò èõ ññûëêîé äëÿ çàãðóçêè óêàçàííîãî ôàéëà, ñíàáæåííîé ñ÷åò÷èêîì ñêà÷èâàíèé.', 'f_filelink', 1),
577	(7, 'Âñòàâêà áàííåðà', 'Ôèëüòð çàìåíÿåò âûðàæåíèÿ âèäà {ÁÀÍÍÅÐ=Èìÿ_ïîçèöèè} íà áàííåðû, íàçíà÷åííûå íà óêàçàííóþ ïîçèöèþ. Ðàáîòàåò â ñòàòüÿõ è ìîäóëÿõ.', 'f_banners', 1);
578
579	DROP TABLE IF EXISTS `#__filter_rules`;
580	CREATE TABLE `#__filter_rules` (
581	`id` int(11) NOT NULL AUTO_INCREMENT,
582	`title` varchar(200) NOT NULL,
583	`find` varchar(200) NOT NULL,
584	`replace` text NOT NULL,
585	`published` int(11) NOT NULL DEFAULT '1',
586	PRIMARY KEY (`id`)
587	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
588
589
590	DROP TABLE IF EXISTS `#__forms`;
591	CREATE TABLE `#__forms` (
592	`id` int(11) NOT NULL AUTO_INCREMENT,
593	`title` varchar(200) NOT NULL,
594	`description` text NOT NULL,
595	`email` varchar(200) NOT NULL,
596	`sendto` varchar(4) NOT NULL DEFAULT 'mail',
597	`user_id` int(11) NOT NULL DEFAULT '1',
598	PRIMARY KEY (`id`)
599	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
600
601
602	DROP TABLE IF EXISTS `#__form_fields`;
603	CREATE TABLE `#__form_fields` (
604	`id` int(11) NOT NULL AUTO_INCREMENT,
605	`form_id` int(11) NOT NULL,
606	`title` varchar(200) NOT NULL,
607	`ordering` int(11) NOT NULL,
608	`kind` varchar(30) NOT NULL,
609	`mustbe` int(11) NOT NULL,
610	`config` text NOT NULL,
611	PRIMARY KEY (`id`)
612	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
613
614
615	DROP TABLE IF EXISTS `#__forums`;
616	CREATE TABLE `#__forums` (
617	`id` int(11) NOT NULL AUTO_INCREMENT,
618	`category_id` int(11) NOT NULL,
619	`title` varchar(250) NOT NULL,
620	`description` varchar(250) NOT NULL,
621	`auth_group` int(11) NOT NULL DEFAULT '-1',
622	`ordering` int(11) NOT NULL,
623	`published` int(11) NOT NULL DEFAULT '1',
624	`parent_id` int(11) NOT NULL,
625	`NSLeft` int(11) NOT NULL,
626	`NSRight` int(11) NOT NULL,
627	`NSDiffer` varchar(15) NOT NULL,
628	`NSIgnore` int(11) NOT NULL,
629	`NSLevel` int(11) NOT NULL,
630	`topic_cost` float NOT NULL DEFAULT '0',
631	PRIMARY KEY (`id`),
632	KEY `category_id` (`category_id`),
633	KEY `parent_id` (`parent_id`)
634	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
635
636	INSERT INTO `#__forums` (`id`, `category_id`, `title`, `description`, `auth_group`, `ordering`, `published`, `parent_id`, `NSLeft`, `NSRight`, `NSDiffer`, `NSIgnore`, `NSLevel`, `topic_cost`) VALUES
637	(1000, 0, '-- Êîðåíü ôîðóìîâ --', '', 0, 1, 0, 0, 1, 8, '', 0, 1, 0);
638
639	DROP TABLE IF EXISTS `#__forum_cats`;
640	CREATE TABLE `#__forum_cats` (
641	`id` int(11) NOT NULL AUTO_INCREMENT,
642	`title` varchar(250) NOT NULL,
643	`published` int(11) NOT NULL DEFAULT '1',
644	`auth_group` int(11) NOT NULL,
645	`ordering` int(11) NOT NULL,
646	PRIMARY KEY (`id`),
647	KEY `auth_group` (`auth_group`)
648	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
649
650
651	DROP TABLE IF EXISTS `#__forum_files`;
652	CREATE TABLE `#__forum_files` (
653	`id` int(11) NOT NULL AUTO_INCREMENT,
654	`post_id` int(11) NOT NULL,
655	`filename` varchar(200) NOT NULL,
656	`filesize` int(11) NOT NULL,
657	`hits` int(11) NOT NULL,
658	`pubdate` datetime NOT NULL,
659	PRIMARY KEY (`id`)
660	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
661
662
663	DROP TABLE IF EXISTS `#__forum_images`;
664	CREATE TABLE `#__forum_images` (
665	`id` int(11) NOT NULL AUTO_INCREMENT,
666	`post_id` int(11) NOT NULL,
667	`session_id` varchar(50) NOT NULL,
668	`fileurl` varchar(250) NOT NULL,
669	PRIMARY KEY (`id`)
670	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
671
672
673	DROP TABLE IF EXISTS `#__forum_polls`;
674	CREATE TABLE `#__forum_polls` (
675	`id` int(11) NOT NULL AUTO_INCREMENT,
676	`thread_id` int(11) NOT NULL,
677	`title` varchar(200) NOT NULL,
678	`description` text NOT NULL,
679	`answers` text NOT NULL,
680	`options` varchar(250) NOT NULL,
681	`enddate` datetime NOT NULL,
682	PRIMARY KEY (`id`)
683	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
684
685
686	DROP TABLE IF EXISTS `#__forum_posts`;
687	CREATE TABLE `#__forum_posts` (
688	`id` int(11) NOT NULL AUTO_INCREMENT,
689	`thread_id` int(11) NOT NULL,
690	`user_id` int(11) NOT NULL,
691	`pubdate` datetime NOT NULL,
692	`editdate` datetime NOT NULL,
693	`edittimes` int(11) NOT NULL,
694	`content` text NOT NULL,
695	PRIMARY KEY (`id`),
696	KEY `thread_id` (`thread_id`),
697	KEY `user_id` (`user_id`),
698	FULLTEXT KEY `content` (`content`)
699	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
700
701
702	DROP TABLE IF EXISTS `#__forum_threads`;
703	CREATE TABLE `#__forum_threads` (
704	`id` int(11) NOT NULL AUTO_INCREMENT,
705	`forum_id` int(11) NOT NULL,
706	`user_id` int(11) NOT NULL,
707	`title` varchar(250) NOT NULL,
708	`description` varchar(250) NOT NULL,
709	`icon` varchar(100) NOT NULL,
710	`pubdate` datetime NOT NULL,
711	`hits` int(11) NOT NULL,
712	`closed` int(11) NOT NULL,
713	`pinned` int(11) NOT NULL,
714	`is_hidden` int(11) NOT NULL DEFAULT '0',
715	`rel_to` varchar(15) NOT NULL,
716	`rel_id` int(11) NOT NULL,
717	PRIMARY KEY (`id`),
718	KEY `user_id` (`user_id`),
719	KEY `forum_id` (`forum_id`),
720	FULLTEXT KEY `title` (`title`)
721	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
722
723
724	DROP TABLE IF EXISTS `#__forum_votes`;
725	CREATE TABLE `#__forum_votes` (
726	`id` int(11) NOT NULL AUTO_INCREMENT,
727	`poll_id` int(11) NOT NULL,
728	`answer_id` int(11) NOT NULL,
729	`user_id` int(11) NOT NULL,
730	`pubdate` datetime NOT NULL,
731	PRIMARY KEY (`id`)
732	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
733
734
735	DROP TABLE IF EXISTS `#__menu`;
736	CREATE TABLE `#__menu` (
737	`id` int(11) NOT NULL AUTO_INCREMENT,
738	`menu` varchar(200) NOT NULL,
739	`title` varchar(200) NOT NULL,
740	`link` varchar(200) NOT NULL,
741	`linktype` varchar(12) NOT NULL DEFAULT 'link',
742	`linkid` varchar(25) DEFAULT '-1',
743	`target` varchar(8) NOT NULL DEFAULT '_self',
744	`component` varchar(100) NOT NULL,
745	`ordering` int(11) NOT NULL DEFAULT '1',
746	`published` int(11) NOT NULL,
747	`template` varchar(30) NOT NULL,
748	`access_list` tinytext NOT NULL,
749	`iconurl` varchar(100) NOT NULL,
750	`NSLeft` int(11) NOT NULL,
751	`NSRight` int(11) NOT NULL,
752	`NSLevel` int(11) NOT NULL,
753	`NSDiffer` varchar(40) DEFAULT NULL,
754	`NSIgnore` int(11) NOT NULL,
755	`parent_id` int(11) NOT NULL,
756	PRIMARY KEY (`id`)
757	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
758
759	INSERT INTO `#__menu` (`id`, `menu`, `title`, `link`, `linktype`, `linkid`, `target`, `component`, `ordering`, `published`, `template`, `access_list`, `iconurl`, `NSLeft`, `NSRight`, `NSLevel`, `NSDiffer`, `NSIgnore`, `parent_id`) VALUES
760	(1, 'root', '-- Ãëàâíàÿ ñòðàíèöà --', '-1', 'link', '-1', '_self', '', 1, 0, '0', '', '', 1, 2, 0, '', 0, 0);
761
762	DROP TABLE IF EXISTS `#__modules`;
763	CREATE TABLE `#__modules` (
764	`id` int(11) NOT NULL AUTO_INCREMENT,
765	`position` varchar(10) NOT NULL,
766	`name` varchar(200) NOT NULL,
767	`title` varchar(200) NOT NULL,
768	`is_external` int(11) NOT NULL,
769	`content` text NOT NULL,
770	`ordering` int(11) NOT NULL,
771	`showtitle` int(11) NOT NULL DEFAULT '1',
772	`published` int(11) NOT NULL DEFAULT '1',
773	`user` int(11) NOT NULL DEFAULT '1',
774	`config` text NOT NULL,
775	`original` int(11) NOT NULL,
776	`css_prefix` varchar(30) NOT NULL,
777	`access_list` tinytext NOT NULL,
778	`cache` int(11) NOT NULL,
779	`cachetime` int(11) NOT NULL DEFAULT '1',
780	`cacheint` varchar(15) NOT NULL DEFAULT 'HOUR',
781	`template` varchar(35) NOT NULL DEFAULT 'module.tpl',
782	`is_strict_bind` tinyint(4) NOT NULL DEFAULT '0',
783	`version` varchar(6) NOT NULL DEFAULT '1.0',
784	PRIMARY KEY (`id`)
785	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
786
787	INSERT INTO `#__modules` (`id`, `position`, `name`, `title`, `is_external`, `content`, `ordering`, `showtitle`, `published`, `user`, `config`, `original`, `css_prefix`, `access_list`, `cache`, `cachetime`, `cacheint`, `template`, `is_strict_bind`, `version`) VALUES
788	(1, 'topmenu', 'Ìåíþ', 'Ìåíþ', 1, 'mod_menu', 6, 0, 1, 0, '---\nmenu: mainmenu\njtree: 1\n', 1, '', '', 0, 1, 'HOUR', 'module_simple.tpl', 0, '1.0'),
789	(17, 'top', 'Ãëàâíàÿ ñòðàíèöà', 'Äîáðî ïîæàëîâàòü!', 0, '<table cellspacing="0" cellpadding="0" border="0" width="100%">\r\n <tbody>\r\n <tr>\r\n <td width="100" valign="top"><a target="_blank" href="http://www.instantcms.ru"><img border="0" alt="" src="/images/content/community.png" /></a></td>\r\n <td>\r\n <p class="moduletitle">Äîáðî ïîæàëîâàòü!</p>\r\n <p>Ìû ðàäû ïðèâåòñòâîâàòü Âàñ â íàøåé ñîöèàëüíîé ñåòè. Ïîñëå ðåãèñòðàöèè Âàì ñòàíóò äîñòóïíû âñå ôóíêöèè ñàéòà.</p>\r\n <p>Âû ñìîæåòå çàâåñòè áëîã, çàãðóæàòü ôîòîãðàôèè è îáùàòüñÿ ñ äðóçüÿìè.</p>\r\n <div>\r\n <div>×òîáû èçìåíèòü ýòîò òåêñò, <a href="/admin/index.php?view=modules&do=edit&id=17">îòðåäàêòèðóéòå ìîäóëü "Ãëàâíàÿ ñòðàíèöà"</a>.</div>\r\n </div>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>', 0, 0, 1, 1, '---\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
790	(44, 'sidebar', 'Îáëàêî òåãîâ', 'Îáëàêî òåãîâ', 1, 'mod_tags', 18, 0, 0, 0, '---\ncat_id: \nsortby: tag\nmenuid: \nminfreq: 0\nminlen: 3\ntargets: \n content: content\n photo: photo\n blogpost: blog\n catalog: catalog\n userphoto: userphoto\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
791	(46, 'mainbottom', 'Íîâèíêè êàòàëîãà', 'Íîâèíêè êàòàëîãà', 1, 'mod_uc_latest', 30, 1, 0, 0, '---\nnewscount: 6\nshowtype: list\nshowf: 2\ncat_id: \nsubs: 1\nfulllink: 0\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
792	(26, 'sidebar', 'Êîðçèíà ïîêóïàòåëÿ', 'Êîðçèíà', 1, 'mod_cart', 19, 1, 0, 0, '---\nshowtype: list\nshowqty: 1\nmenuid: 23\nsource: catalog\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
793	(25, 'sidebar', 'Ãîëîñîâàíèÿ', 'Ãîëîñîâàíèÿ', 1, 'mod_polls', 2, 1, 1, 0, '---\nshownum: 0\npoll_id: 2\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
794	(27, 'sidebar', 'Ïîèñê', 'Ïîèñê', 1, 'mod_search', 1, 0, 0, 0, '---\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
795	(19, 'maintop', 'Ïîñëåäíèå ìàòåðèàëû', 'Íîâûå ñòàòüè', 1, 'mod_latest', 2, 1, 1, 0, '---\nnewscount: 4\nshowdesc: 0\nshowdate: 1\nshowcom: 1\nshowrss: 1\ncat_id: 6\nsubs: 1\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0'),
796	(20, 'topmenu', 'Àâòîðèçàöèÿ', 'Àâòîðèçàöèÿ', 1, 'mod_auth', 0, 1, 1, 0, '---\nautolog: 1\npassrem: 1\n', 1, '', '', 0, 1, 'MINUTE', 'module.tpl', 0, '1.0'),
797	(22, 'topmenu', 'Ïîñëåäíèå ðåãèñòðàöèè', 'Íîâûå ïîëüçîâàòåëè', 1, 'mod_lastreg', 2, 1, 1, 0, '---\nnewscount: 5\nview_type: hr_table\nmaxcool: 2\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0'),
798	(23, 'sidebar', 'Ñëó÷àéíîå èçîáðàæåíèå', 'Ñëó÷àéíàÿ êàðòèíêà', 1, 'mod_random_image', 21, 1, 0, 0, '---\nshowtitle: 1\nalbum_id: 0\nmenuid: 20\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
799	(24, 'sidebar', '×àñû', '×àñû', 1, 'mod_clock', 17, 1, 0, 0, '---\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
800	(37, 'sidebar', 'Êàòåãîðèè ïðàéñà', 'Êàòåãîðèè ïðàéñà', 1, 'mod_pricecat', 14, 1, 0, 0, '---\nshowdesc: 0\nicon: /images/markers/pricelist.png\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
801	(36, 'sidebar', 'Ðàçäåëû ñàéòà', 'Ñòàòüè', 1, 'mod_category', 13, 1, 0, 0, '---\nshowdesc: 0\ncategory_id: 6\nicon: /images/markers/folder.png\nmenuid: 21\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
802	(39, 'sidebar', 'Âûáîð øàáëîíà', 'Âûáîð øàáëîíà', 1, 'mod_template', 12, 1, 0, 0, '---\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
803	(47, 'mainbottom', 'Ïîïóëÿðíîå â êàòàëîãå', 'Ïîïóëÿðíîå â êàòàëîãå', 1, 'mod_uc_popular', 23, 1, 0, 0, '---\nnum: 10\ncat_id: 0\nmenuid: 23\nshowf: 2\nshowtype: thumb\nfulllink: 1\nsort: rating\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
804	(49, 'sidebar', 'Êòî îíëàéí?', 'Êòî îíëàéí?', 1, 'mod_whoonline', 24, 1, 1, 0, '---\nshow_today: 1\nadmin_editor: 1\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0'),
805	(50, 'topmenu', 'Òåìû íà ôîðóìå', 'Íîâîñòè ôîðóìà', 1, 'mod_forum', 31, 1, 1, 0, '---\nshownum: 2\nshowtype: web2\nshowforum: 0\nshowlink: 0\nshowtext: 0\nmenuid: 18\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
806	(51, 'sidebar', 'Ñëó÷àéíîå ôîòî', 'Ñëó÷àéíîå ôîòî', 1, 'mod_user_image', 25, 1, 0, 0, '---\nshowtitle: 1\nmenuid: 15\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
807	(52, 'sidebar', 'Âíåøíèé ôàéë', 'Âíåøíèé ôàéë', 0, '<p>{ÔÀÉË=test.php}</p>', 11, 1, 0, 1, '---\n', 0, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
808	(56, 'sidebar', 'Àðõèâ ñòàòåé', 'Àðõèâ íîâîñòåé', 1, 'mod_arhive', 27, 1, 0, 0, '---\nsource: both\ncat_id: 6\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
809	(54, 'sidebar', 'Ñëó÷àéíîå â êàòàëîãå', 'Ñëó÷àéíîå â êàòàëîãå', 1, 'mod_uc_random', 26, 1, 0, 0, '---\ncat_id: 1\ncount: 2\nshowtitle: 1\nshowcat: 0\nmenuid: 23\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
810	(60, 'maintop', 'Ëåíòà RSS ', 'Ëåíòà íîâîñòåé', 1, 'mod_rss', 9, 1, 0, 0, '---\nshowdesc: 0\nshowicon: 1\nitemslimit: 6\nrssurl: http://portal.novator.ru/ngnews.rss\ncols: 2\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
811	(61, 'sidebar', 'Ïîñëåäíèå êîììåíòàðèè', 'Ïîñëåäíèå êîììåíòàðèè', 1, 'mod_comments', 4, 1, 1, 0, '---\nshownum: 10\nminrate: 0\nshowdesc: 1\nshowrss: 1\nshowtarg: 0\ntargets: \n faq: faq\n catalog: catalog\n boarditem: boarditem\n blog: blog\n article: article\n palbum: palbum\n photo: photo\n userphoto: userphoto\n', 1, '', '', 0, 1, 'MINUTE', 'module.tpl', 0, '1.0'),
812	(62, 'maintop', 'Íîâèíêè ôîòîãàëåðåè', 'Íîâèíêè ôîòîãàëåðåè', 1, 'mod_latestphoto', 32, 1, 1, 0, '---\nshownum: 6\nmaxcols: 2\nshowclubs: 1\nshowalbum: 0\nshowdate: 0\nshowcom: 0\nalbum_id: 100\nshowtype: short\nshowmore: 0\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0'),
813	(63, 'sidebar', 'Ïîïóëÿðíûå ôîòîãðàôèè', 'Ïîïóëÿðíûå ôîòîãðàôèè', 1, 'mod_bestphoto', 10, 1, 0, 0, '---\nshownum: 2\nmaxcols: 2\nshowalbum: 0\nshowdate: 1\nshowcom: 1\nalbum_id: 0\nsort: rating\nmenuid: 20\nshowtype: full\nshowmore: 1\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
814	(64, 'maintop', 'Íîâîå â áëîãàõ', 'Íîâîå â áëîãàõ', 1, 'mod_latestblogs', 2, 1, 1, 0, '---\nnamemode: blog\nshownum: 10\nminrate: 0\nshowrss: 1\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
815	(65, 'sidebar', 'Ïîïóëÿðíîå â áëîãàõ', 'Ïîïóëÿðíîå â áëîãàõ', 1, 'mod_bestblogs', 3, 1, 1, 0, '---\nnamemode: blog\nshownum: 10\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0'),
816	(66, 'header', 'Ìåíþ ïîëüçîâàòåëÿ', 'Ìåíþ ïîëüçîâàòåëÿ', 1, 'mod_usermenu', 1, 0, 1, 0, '---\navatar: 1\nshowtype: text\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
817	(67, 'mainbottom', 'Ïîñëåäíèå âîïðîñû FAQ', 'Ïîñëåäíèå âîïðîñû FAQ', 1, 'mod_latest_faq', 33, 1, 0, 0, '---\nnewscount: 5\nmaxlen: 140\ncat_id: \n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
818	(69, 'maintop', 'Ïîïóëÿðíûå ñòàòüè', 'Ïîïóëÿðíûå ñòàòüè', 1, 'mod_bestcontent', 3, 1, 0, 0, '---\nshownum: 4\nmenuid: 21\nshowlink: 1\nshowdesc: 1\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
819	(70, 'sidebar', 'Ïîèñê ïîëüçîâàòåëåé', 'Ïîèñê ïîëüçîâàòåëåé', 1, 'mod_usersearch', 4, 1, 0, 0, '---\ncat_id: \nsource: \nmenuid: 15\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0'),
820	(71, 'maintop', 'Íîâûå îáúÿâëåíèÿ', 'Íîâûå îáúÿâëåíèÿ', 1, 'mod_latestboard', 1, 1, 1, 0, '---\nshownum: 10\nshowcity: 1\ncat_id: -1\nsubs: 1\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
821	(72, 'maintop', 'Ðåéòèíã ïîëüçîâàòåëåé', 'Ðåéòèíã ïîëüçîâàòåëåé', 1, 'mod_user_rating', 1, 1, 0, 0, '---\ncount: 20\nmenuid: 15\nview_type: rating\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
822	(73, 'maintop', 'Íîâûå êëóáû', 'Íîâûå êëóáû', 1, 'mod_latestclubs', 3, 1, 0, 0, '---\ncount: 2\nmenuid: 38\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
823	(74, 'maintop', 'Ïîïóëÿðíûå êëóáû', 'Ïîïóëÿðíûå êëóáû', 1, 'mod_bestclubs', 4, 1, 0, 0, '---\ncount: 2\nmenuid: 38\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
824	(75, 'sidebar', 'Äîñêà ïî÷åòà', 'Äîñêà ïî÷åòà', 1, 'mod_respect', 1, 1, 1, 0, '---\nview: all\nshow_awards: 1\norder: desc\nlimit: 5\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0'),
825	(76, 'sidebar', 'Ôàéëû ïîëüçîâàòåëåé', 'Ôàéëû ïîëüçîâàòåëåé', 1, 'mod_userfiles', 1, 1, 0, 0, '---\nmenuid: 0\nsw_stats: 1\nsw_latest: 1\nsw_popular: 1\nnum_latest: 5\nnum_popular: 5\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 0, '1.0'),
826	(87, 'maintop', 'Ëåíòà àêòèâíîñòè', 'Ëåíòà àêòèâíîñòè', 1, 'mod_actions', 1, 1, 1, 0, '---\nlimit: 15\nshow_target: 0\naction_types: \n 16: 16\n 15: 15\n 20: 20\n 13: 13\n 29: 29\n 24: 24\n 23: 23\n 2: 2\n 27: 27\n 12: 12\n 10: 10\n 25: 25\n 17: 17\n 8: 8\n 18: 18\n 7: 7\n 26: 26\n 19: 19\n 22: 22\n 11: 11\n 21: 21\n 28: 28\n 9: 9\n 14: 14\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.7'),
827	(82, 'sidebar', 'Ïðèâåòñòâèå', 'Óíèâåðñàëüíûé êàòàëîã', 0, '<p>Ñ ïîìîùüþ êîìïîíåíòà «Óíèâåðñàëüíûé êàòàëîã», â êîòîðîì Âû ñåé÷àñ íàõîäèòåñü, ìîæíî îðãàíèçîâàòü õðàíåíèå ëþáûõ äàííûõ. Îò êàðàíäàøåé äî àâòîìîáèëåé.</p>\r\n<p>Êàæäàÿ ðóáðèêà êàòàëîãà èìååò ñîáñòâåííûé íàáîð õàðàêòåðèñòèê, êîòîðûé ìîæíî èçìåíèòü â ïàíåëè óïðàâëåíèÿ. Ïîëüçîâàòåëè ìîãóò ôèëüòðîâàòü çàïèñè êàòàëîãà ïî õàðàêòåðèñòèêàì îäíèì ùåë÷êîì ìûøè. </p>\r\n<p>Ëþáîé ïîëüçîâàòåëü ìîæåò äîáàâëÿòü ñîáñòâåííûå çàïèñè â òå ðóáðèêè êàòàëîãà, äëÿ êîòîðûõ ýòî ðàçðåøåíî â íàñòðîéêàõ.</p>', 14, 1, 1, 1, '', 1, '', '', 0, 24, 'HOUR', 'module.tpl', 1, '1.0'),
828	(83, 'sidebar', 'Ñòàòèñòèêà ïîëüçîâàòåëåé', 'Ñòàòèñòèêà ïîëüçîâàòåëåé', 1, 'mod_user_stats', 1, 1, 1, 0, '---\nshow_total: 1\nshow_online: 1\nshow_gender: 1\nshow_city: 1\nshow_bday: 1\n', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0'),
829	(84, 'sidebar', 'Äðóçüÿ îíëàéí', 'Äðóçüÿ îíëàéí', 1, 'mod_user_friend', 5, 1, 0, 0, '---\r\nlimit: 5\r\nview_type: table', 1, '', '', 0, 1, 'HOUR', 'module_simple.tpl', 0, '1.0'),
830	(85, 'sidebar', 'Ïðèãëàñèòü äðóãà', 'Ïðèãëàñèòü äðóãà', 1, 'mod_invite', 1, 1, 0, 0, '', 1, '', '', 0, 1, 'HOUR', 'module.tpl', 1, '1.0');
831
832	DROP TABLE IF EXISTS `#__modules_bind`;
833	CREATE TABLE `#__modules_bind` (
834	`id` int(11) NOT NULL AUTO_INCREMENT,
835	`module_id` int(11) NOT NULL,
836	`menu_id` int(11) NOT NULL,
837	`position` varchar(20) NOT NULL,
838	PRIMARY KEY (`id`),
839	KEY `position` (`position`)
840	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
841
842	INSERT INTO `#__modules_bind` (`id`, `module_id`, `menu_id`, `position`) VALUES
843	(329, 42, 0, ''),
844	(249, 31, 0, ''),
845	(568, 17, 1, 'top'),
846	(347, 41, 18, ''),
847	(498, 39, 1, 'sidebar'),
848	(417, 54, 24, 'sidebar'),
849	(416, 54, 21, 'sidebar'),
850	(264, 32, 5, ''),
851	(328, 2, 0, ''),
852	(263, 32, 8, ''),
853	(262, 32, 1, ''),
854	(596, 66, 0, 'header'),
855	(346, 41, 24, ''),
856	(588, 20, 1, 'sidebar'),
857	(412, 37, 22, 'sidebar'),
858	(433, 36, 19, 'sidebar'),
859	(381, 24, 1, 'sidebar'),
860	(492, 26, 22, 'sidebar'),
861	(314, 38, 8, ''),
862	(556, 1, 0, 'topmenu'),
863	(497, 27, 1, 'sidebar'),
864	(332, 43, 0, ''),
865	(413, 45, 1, ''),
866	(478, 46, 1, 'mainbottom'),
867	(458, 44, 1, 'sidebar'),
868	(491, 47, 1, 'mainbottom'),
869	(350, 48, 37, ''),
870	(595, 50, 1, 'maintop'),
871	(434, 51, 1, 'sidebar'),
872	(358, 52, 1, 'sidebar'),
873	(359, 52, 42, 'sidebar'),
874	(360, 52, 41, 'sidebar'),
875	(361, 52, 43, 'sidebar'),
876	(364, 53, 1, ''),
877	(415, 54, 19, 'sidebar'),
878	(422, 60, 1, 'maintop'),
879	(401, 55, 0, ''),
880	(609, 56, 0, 'sidebar'),
881	(403, 58, 63, ''),
882	(406, 59, 0, ''),
883	(435, 23, 1, 'sidebar'),
884	(572, 61, 1, 'sidebar'),
885	(465, 63, 1, 'sidebar'),
886	(587, 64, 1, 'maintop'),
887	(482, 67, 1, 'mainbottom'),
888	(496, 68, 0, 'maintop'),
889	(486, 69, 1, 'maintop'),
890	(617, 22, 1, 'sidebar'),
891	(493, 26, 23, 'sidebar'),
892	(604, 70, 15, 'sidebar'),
893	(591, 71, 1, 'mainbottom'),
894	(515, 72, 1, 'maintop'),
895	(516, 73, 1, 'maintop'),
896	(520, 74, 1, 'maintop'),
897	(575, 25, 1, 'sidebar'),
898	(531, 76, 1, 'sidebar'),
899	(541, 77, 1, ''),
900	(598, 19, 21, 'sidebar'),
901	(597, 19, 1, 'maintop'),
902	(582, 65, 17, 'sidebar'),
903	(592, 79, 1, 'maintop'),
904	(586, 62, 20, 'sidebar'),
905	(599, 82, 23, 'sidebar'),
906	(608, 49, 1, 'sidebar'),
907	(607, 83, 15, 'sidebar'),
908	(616, 75, 1, 'sidebar'),
909	(615, 87, 1, 'maintop');
910
911	DROP TABLE IF EXISTS `#__ns_transactions`;
912	CREATE TABLE `#__ns_transactions` (
913	`IDTransaction` int(10) unsigned NOT NULL AUTO_INCREMENT,
914	`TableName` tinytext,
915	`Differ` tinytext,
916	`InTransaction` bit(1) DEFAULT NULL,
917	`TStamp` timestamp NULL DEFAULT NULL,
918	PRIMARY KEY (`IDTransaction`)
919	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
920
921
922	DROP TABLE IF EXISTS `#__online`;
923	CREATE TABLE `#__online` (
924	`id` int(11) NOT NULL AUTO_INCREMENT,
925	`ip` varchar(15) NOT NULL,
926	`sess_id` varchar(100) NOT NULL,
927	`lastdate` datetime NOT NULL,
928	`user_id` int(11) NOT NULL,
929	`agent` varchar(250) NOT NULL,
930	`viewurl` varchar(250) NOT NULL,
931	PRIMARY KEY (`id`),
932	KEY `user_id` (`user_id`),
933	KEY `sess_id` (`sess_id`)
934	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
935
936
937	DROP TABLE IF EXISTS `#__photo_albums`;
938	CREATE TABLE `#__photo_albums` (
939	`id` int(11) NOT NULL AUTO_INCREMENT,
940	`parent_id` int(11) NOT NULL,
941	`ordering` int(11) NOT NULL DEFAULT '1',
942	`NSLeft` int(11) NOT NULL,
943	`NSRight` int(11) NOT NULL,
944	`NSDiffer` varchar(15) NOT NULL,
945	`NSIgnore` int(11) NOT NULL,
946	`NSLevel` int(11) NOT NULL,
947	`title` varchar(100) NOT NULL,
948	`description` varchar(100) NOT NULL,
949	`published` int(11) NOT NULL,
950	`showdate` int(11) NOT NULL DEFAULT '1',
951	`iconurl` varchar(100) NOT NULL,
952	`pubdate` datetime NOT NULL,
953	`orderby` varchar(20) NOT NULL DEFAULT 'title',
954	`orderto` varchar(4) NOT NULL DEFAULT 'asc',
955	`public` int(11) NOT NULL,
956	`perpage` int(11) NOT NULL DEFAULT '15',
957	`cssprefix` varchar(20) NOT NULL,
958	`thumb1` int(11) NOT NULL DEFAULT '96',
959	`thumb2` int(11) NOT NULL DEFAULT '480',
960	`thumbsqr` int(11) NOT NULL DEFAULT '1',
961	`showtype` varchar(10) NOT NULL DEFAULT 'list',
962	`nav` int(11) NOT NULL DEFAULT '1',
963	`uplimit` int(11) NOT NULL,
964	`maxcols` int(11) NOT NULL DEFAULT '4',
965	`orderform` int(11) NOT NULL DEFAULT '1',
966	`showtags` int(11) NOT NULL DEFAULT '1',
967	`bbcode` int(11) NOT NULL DEFAULT '1',
968	`user_id` int(11) NOT NULL DEFAULT '1',
969	`is_comments` int(11) NOT NULL,
970	PRIMARY KEY (`id`),
971	KEY `user_id` (`user_id`),
972	KEY `parent_id` (`parent_id`)
973	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
974
975	INSERT INTO `#__photo_albums` (`id`, `parent_id`, `ordering`, `NSLeft`, `NSRight`, `NSDiffer`, `NSIgnore`, `NSLevel`, `title`, `description`, `published`, `showdate`, `iconurl`, `pubdate`, `orderby`, `orderto`, `public`, `perpage`, `cssprefix`, `thumb1`, `thumb2`, `thumbsqr`, `showtype`, `nav`, `uplimit`, `maxcols`, `orderform`, `showtags`, `bbcode`, `user_id`, `is_comments`) VALUES
976	(100, 0, 1, 1, 2, '', 0, 0, '-- Êîðíåâîé àëüáîì --', '', 1, 1, '', '2008-05-30 12:03:07', 'title', 'asc', 0, 15, '', 96, 480, 1, 'list', 1, 0, 4, 1, 1, 1, 1, 0);
977
978	DROP TABLE IF EXISTS `#__photo_files`;
979	CREATE TABLE `#__photo_files` (
980	`id` int(11) NOT NULL AUTO_INCREMENT,
981	`album_id` int(11) NOT NULL,
982	`title` varchar(200) NOT NULL,
983	`description` text NOT NULL,
984	`pubdate` datetime DEFAULT '0000-00-00 00:00:00',
985	`file` varchar(200) NOT NULL,
986	`published` int(11) NOT NULL,
987	`hits` int(11) NOT NULL,
988	`showdate` int(11) NOT NULL DEFAULT '1',
989	`comments` int(11) NOT NULL DEFAULT '1',
990	`user_id` int(11) NOT NULL DEFAULT '1',
991	`owner` varchar(10) DEFAULT 'photos',
992	PRIMARY KEY (`id`),
993	KEY `album_id` (`album_id`),
994	KEY `user_id` (`user_id`),
995	FULLTEXT KEY `title` (`title`,`description`)
996	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
997
998
999	DROP TABLE IF EXISTS `#__plugins`;
1000	CREATE TABLE `#__plugins` (
1001	`id` int(11) NOT NULL AUTO_INCREMENT,
1002	`plugin` varchar(30) NOT NULL,
1003	`title` varchar(255) NOT NULL,
1004	`description` text NOT NULL,
1005	`author` varchar(255) NOT NULL,
1006	`version` varchar(15) NOT NULL,
1007	`plugin_type` varchar(10) NOT NULL,
1008	`published` int(11) NOT NULL,
1009	`config` text NOT NULL,
1010	PRIMARY KEY (`id`)
1011	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1012
1013	INSERT INTO `#__plugins` (`id`, `plugin`, `title`, `description`, `author`, `version`, `plugin_type`, `published`, `config`) VALUES
1014	(6, 'p_usertab', 'Demo Profile Plugin', 'Ïðèìåð ïëàãèíà - Äîáàâëÿåò âêëàäêó "Ñòàòüè" â ïðîôèëè âñåõ ïîëüçîâàòåëåé', 'InstantCMS Team', '1.0', 'plugin', 0, '---\nÊîëè÷åñòâî ñòàòåé: 10\n'),
1015	(3, 'p_fckeditor', 'FCKEditor', 'Âèçóàëüíûé ðåäàêòîð', 'F. C. Knabben', '2.63', 'wysiwyg', 1, '---\n'),
1016	(5, 'p_demo', 'Demo Plugin', 'Ïðèìåð ïëàãèíà - Äîáàâëÿåò òåêñò â êîíåö êàæäîé ñòàòüè íà ñàéòå', 'InstantCMS Team', '1.0', 'plugin', 0, '---\ntext: Added By Plugin From Parameter\ncolor: blue\ncounter: 1\n'),
1017	(8, 'p_ping', 'Ïèíã ïîèñêîâûõ ñèñòåì', 'Ïèíãóåò ßíäåêñ è Ãóãë ïðè äîáàâëåíèè ñòàòåé è ïîñòîâ â áëîãè', 'InstantCMS Team', '1.0', 'plugin', 0, '---\nYandex HOST: ping.blogs.yandex.ru\nYandex PATH: /RPC2\nGoogle HOST: blogsearch.google.com\nGoogle PATH: /ping/RPC2\n'),
1018	(15, 'p_morecontent', 'Ïîõîæèå ñòàòüè', 'Äîáàâëÿåò â êîíåö êàæäîé ñòàòüè ñïèñîê ïîõîæèõ ñòàòåé.', 'Maximov & InstantCMS Team', '1.0', 'plugin', 0, '---\nlimit: 5\nunsort: 1\n'),
1019	(14, 'p_hidetext', 'Ñêðûòûé òåêñò', 'Ñêðûâàåò ñîäåðæèìîå òåãà [hide] îò íåçàðåãèñòðèðîâàííûõ', 'InstantCMS Team', '1.0', 'plugin', 1, '---\n');
1020
1021	DROP TABLE IF EXISTS `#__polls`;
1022	CREATE TABLE `#__polls` (
1023	`id` int(11) NOT NULL AUTO_INCREMENT,
1024	`title` varchar(200) NOT NULL,
1025	`pubdate` date NOT NULL DEFAULT '0000-00-00',
1026	`answers` text NOT NULL,
1027	PRIMARY KEY (`id`)
1028	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1029
1030
1031	DROP TABLE IF EXISTS `#__polls_log`;
1032	CREATE TABLE `#__polls_log` (
1033	`id` int(11) NOT NULL AUTO_INCREMENT,
1034	`poll_id` int(11) NOT NULL,
1035	`answer_id` int(11) NOT NULL,
1036	`user_id` int(11) NOT NULL,
1037	`ip` varchar(15) NOT NULL,
1038	PRIMARY KEY (`id`)
1039	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1040
1041
1042	DROP TABLE IF EXISTS `#__price_cats`;
1043	CREATE TABLE `#__price_cats` (
1044	`id` int(11) NOT NULL AUTO_INCREMENT,
1045	`title` varchar(200) NOT NULL,
1046	`description` text NOT NULL,
1047	`published` int(11) NOT NULL DEFAULT '1',
1048	PRIMARY KEY (`id`)
1049	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1050
1051
1052	DROP TABLE IF EXISTS `#__price_items`;
1053	CREATE TABLE `#__price_items` (
1054	`id` int(11) NOT NULL AUTO_INCREMENT,
1055	`category_id` int(11) NOT NULL,
1056	`title` varchar(230) NOT NULL,
1057	`price` float NOT NULL,
1058	`published` int(11) NOT NULL DEFAULT '1',
1059	`canmany` int(11) NOT NULL DEFAULT '1',
1060	PRIMARY KEY (`id`),
1061	FULLTEXT KEY `title` (`title`)
1062	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1063
1064
1065	DROP TABLE IF EXISTS `#__ratings`;
1066	CREATE TABLE `#__ratings` (
1067	`id` int(11) NOT NULL AUTO_INCREMENT,
1068	`item_id` int(11) NOT NULL,
1069	`points` int(11) NOT NULL,
1070	`ip` varchar(20) NOT NULL,
1071	`target` varchar(20) NOT NULL,
1072	`user_id` int(11) NOT NULL DEFAULT '1',
1073	`pubdate` datetime NOT NULL,
1074	PRIMARY KEY (`id`),
1075	KEY `user_id` (`user_id`),
1076	KEY `item_id` (`item_id`)
1077	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1078
1079
1080	DROP TABLE IF EXISTS `#__ratings_total`;
1081	CREATE TABLE `#__ratings_total` (
1082	`id` int(11) NOT NULL AUTO_INCREMENT,
1083	`target` varchar(32) NOT NULL,
1084	`item_id` mediumint(9) NOT NULL,
1085	`total_rating` int(11) NOT NULL,
1086	`total_votes` int(11) NOT NULL,
1087	PRIMARY KEY (`id`),
1088	KEY `item_id` (`item_id`),
1089	KEY `target` (`target`,`item_id`)
1090	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1091
1092
1093	DROP TABLE IF EXISTS `#__rating_targets`;
1094	CREATE TABLE `#__rating_targets` (
1095	`id` int(11) NOT NULL AUTO_INCREMENT,
1096	`target` varchar(32) NOT NULL,
1097	`component` varchar(32) NOT NULL,
1098	`is_user_affect` tinyint(4) NOT NULL,
1099	`user_weight` smallint(6) NOT NULL,
1100	`target_table` varchar(32) NOT NULL,
1101	`target_title` varchar(70) NOT NULL,
1102	PRIMARY KEY (`id`),
1103	KEY `target` (`target`)
1104	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1105
1106	INSERT INTO `#__rating_targets` (`id`, `target`, `component`, `is_user_affect`, `user_weight`, `target_table`, `target_title`) VALUES
1107	(1, 'content', 'content', 1, 5, 'cms_content', 'Ñòàòüÿ'),
1108	(2, 'photo', 'photos', 1, 5, 'cms_photo_files', 'Ôîòî â ãàëåðåå'),
1109	(3, 'blogpost', 'blogs', 1, 5, 'cms_blog_posts', 'Ïîñò â áëîãå'),
1110	(4, 'comment', 'comments', 1, 2, 'cms_comments', 'Êîììåíòàðèé');
1111
1112	DROP TABLE IF EXISTS `#__search`;
1113	CREATE TABLE `#__search` (
1114	`id` int(11) NOT NULL,
1115	`session_id` varchar(100) NOT NULL,
1116	`title` varchar(250) NOT NULL,
1117	`link` varchar(200) NOT NULL,
1118	`place` varchar(100) NOT NULL,
1119	`placelink` varchar(100) NOT NULL
1120	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1121
1122
1123	DROP TABLE IF EXISTS `#__stats`;
1124	CREATE TABLE `#__stats` (
1125	`id` int(11) NOT NULL AUTO_INCREMENT,
1126	`ip` varchar(20) NOT NULL,
1127	`logdate` datetime NOT NULL,
1128	`page` varchar(200) NOT NULL,
1129	`agent` varchar(60) DEFAULT 'unknown',
1130	`refer` varchar(200) NOT NULL,
1131	PRIMARY KEY (`id`)
1132	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1133
1134
1135	DROP TABLE IF EXISTS `#__subscribe`;
1136	CREATE TABLE `#__subscribe` (
1137	`id` int(11) NOT NULL AUTO_INCREMENT,
1138	`user_id` int(11) NOT NULL,
1139	`target` varchar(20) NOT NULL,
1140	`target_id` int(11) NOT NULL,
1141	`pubdate` datetime NOT NULL,
1142	PRIMARY KEY (`id`),
1143	KEY `user_id` (`user_id`),
1144	KEY `target_id` (`target_id`)
1145	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1146
1147
1148	DROP TABLE IF EXISTS `#__tags`;
1149	CREATE TABLE `#__tags` (
1150	`id` int(11) NOT NULL AUTO_INCREMENT,
1151	`tag` varchar(250) NOT NULL,
1152	`target` varchar(25) NOT NULL,
1153	`item_id` int(11) NOT NULL,
1154	PRIMARY KEY (`id`),
1155	KEY `tag` (`tag`),
1156	KEY `item_id` (`item_id`)
1157	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1158
1159
1160	DROP TABLE IF EXISTS `#__uc_cart`;
1161	CREATE TABLE `#__uc_cart` (
1162	`id` int(11) NOT NULL AUTO_INCREMENT,
1163	`user_id` int(11) NOT NULL,
1164	`session_id` varchar(50) NOT NULL,
1165	`item_id` int(11) NOT NULL,
1166	`pubdate` datetime NOT NULL,
1167	`itemscount` int(11) NOT NULL,
1168	PRIMARY KEY (`id`)
1169	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1170
1171
1172	DROP TABLE IF EXISTS `#__uc_cats`;
1173	CREATE TABLE `#__uc_cats` (
1174	`id` int(11) NOT NULL AUTO_INCREMENT,
1175	`parent_id` int(11) NOT NULL,
1176	`title` varchar(200) NOT NULL,
1177	`description` text NOT NULL,
1178	`published` int(11) NOT NULL DEFAULT '1',
1179	`fieldsstruct` text,
1180	`view_type` varchar(20) NOT NULL DEFAULT 'list',
1181	`fields_show` int(11) NOT NULL DEFAULT '10',
1182	`showmore` int(11) NOT NULL DEFAULT '1',
1183	`perpage` int(11) NOT NULL DEFAULT '20',
1184	`showtags` int(11) NOT NULL DEFAULT '1',
1185	`showsort` int(11) NOT NULL DEFAULT '1',
1186	`is_ratings` int(11) NOT NULL,
1187	`orderby` varchar(12) NOT NULL DEFAULT 'pubdate',
1188	`orderto` varchar(10) DEFAULT 'desc',
1189	`showabc` int(11) NOT NULL DEFAULT '1',
1190	`shownew` int(11) NOT NULL,
1191	`newint` varchar(100) NOT NULL,
1192	`filters` int(11) NOT NULL,
1193	`is_shop` int(11) NOT NULL,
1194	`NSLeft` int(11) NOT NULL,
1195	`NSRight` int(11) NOT NULL,
1196	`NSLevel` int(11) NOT NULL,
1197	`NSDiffer` int(11) NOT NULL,
1198	`NSIgnore` int(11) NOT NULL,
1199	`ordering` int(11) NOT NULL,
1200	`is_public` int(11) NOT NULL,
1201	`can_edit` int(11) NOT NULL DEFAULT '0',
1202	`cost` varchar(5) NOT NULL,
1203	PRIMARY KEY (`id`)
1204	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1205
1206	INSERT INTO `#__uc_cats` (`id`, `parent_id`, `title`, `description`, `published`, `fieldsstruct`, `view_type`, `fields_show`, `showmore`, `perpage`, `showtags`, `showsort`, `is_ratings`, `orderby`, `orderto`, `showabc`, `shownew`, `newint`, `filters`, `is_shop`, `NSLeft`, `NSRight`, `NSLevel`, `NSDiffer`, `NSIgnore`, `ordering`, `is_public`, `can_edit`, `cost`) VALUES
1207	(1000, 0, '-- Êîðíåâàÿ ðóáðèêà --', '', 1, '', 'list', 10, 1, 20, 1, 1, 0, 'pubdate', 'desc', 1, 0, '', 0, 0, 1, 2, 0, 0, 0, 1, 0, 0, '');
1208
1209	DROP TABLE IF EXISTS `#__uc_cats_access`;
1210	CREATE TABLE `#__uc_cats_access` (
1211	`cat_id` int(11) NOT NULL,
1212	`group_id` int(11) NOT NULL,
1213	KEY `cat_id` (`cat_id`,`group_id`)
1214	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1215
1216
1217	DROP TABLE IF EXISTS `#__uc_discount`;
1218	CREATE TABLE `#__uc_discount` (
1219	`id` int(11) NOT NULL AUTO_INCREMENT,
1220	`title` varchar(150) NOT NULL,
1221	`cat_id` int(11) NOT NULL,
1222	`sign` tinyint(4) NOT NULL,
1223	`value` float NOT NULL,
1224	`unit` varchar(10) NOT NULL,
1225	`if_limit` int(11) NOT NULL,
1226	PRIMARY KEY (`id`),
1227	KEY `cat_id` (`cat_id`)
1228	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1229
1230
1231	DROP TABLE IF EXISTS `#__uc_items`;
1232	CREATE TABLE `#__uc_items` (
1233	`id` int(11) NOT NULL AUTO_INCREMENT,
1234	`category_id` int(11) NOT NULL,
1235	`title` varchar(200) NOT NULL,
1236	`pubdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1237	`published` int(11) NOT NULL DEFAULT '1',
1238	`imageurl` varchar(200) NOT NULL,
1239	`fieldsdata` text NOT NULL,
1240	`hits` int(11) NOT NULL,
1241	`is_comments` int(11) NOT NULL,
1242	`tags` varchar(200) NOT NULL,
1243	`rating` float NOT NULL,
1244	`meta_desc` varchar(250) NOT NULL,
1245	`meta_keys` varchar(250) NOT NULL,
1246	`price` float NOT NULL,
1247	`canmany` int(11) NOT NULL DEFAULT '1',
1248	`user_id` int(11) NOT NULL,
1249	`on_moderate` int(11) NOT NULL,
1250	PRIMARY KEY (`id`),
1251	KEY `category_id` (`category_id`),
1252	FULLTEXT KEY `title` (`title`,`fieldsdata`)
1253	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1254
1255
1256	DROP TABLE IF EXISTS `#__uc_ratings`;
1257	CREATE TABLE `#__uc_ratings` (
1258	`id` int(11) NOT NULL AUTO_INCREMENT,
1259	`item_id` int(11) NOT NULL,
1260	`points` int(11) NOT NULL,
1261	`ip` varchar(16) NOT NULL,
1262	PRIMARY KEY (`id`)
1263	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1264
1265
1266	DROP TABLE IF EXISTS `#__uc_tags`;
1267	CREATE TABLE `#__uc_tags` (
1268	`id` int(11) NOT NULL AUTO_INCREMENT,
1269	`tag` varchar(200) NOT NULL,
1270	`item_id` int(11) NOT NULL,
1271	PRIMARY KEY (`id`)
1272	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1273
1274
1275	DROP TABLE IF EXISTS `#__upload_images`;
1276	CREATE TABLE `#__upload_images` (
1277	`id` int(11) NOT NULL AUTO_INCREMENT,
1278	`post_id` int(11) NOT NULL,
1279	`session_id` varchar(50) NOT NULL,
1280	`fileurl` varchar(250) NOT NULL,
1281	`target` varchar(25) NOT NULL DEFAULT 'forum',
1282	PRIMARY KEY (`id`)
1283	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1284
1285
1286	DROP TABLE IF EXISTS `#__users`;
1287	CREATE TABLE `#__users` (
1288	`id` int(11) NOT NULL AUTO_INCREMENT,
1289	`group_id` int(11) NOT NULL DEFAULT '1',
1290	`login` varchar(100) NOT NULL,
1291	`nickname` varchar(100) NOT NULL,
1292	`password` varchar(100) NOT NULL,
1293	`email` varchar(100) NOT NULL,
1294	`icq` varchar(15) NOT NULL,
1295	`regdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1296	`logdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1297	`birthdate` date NOT NULL DEFAULT '0000-00-00',
1298	`is_locked` int(11) NOT NULL,
1299	`is_deleted` int(11) NOT NULL,
1300	`rating` int(11) NOT NULL,
1301	`points` int(11) NOT NULL,
1302	`last_ip` varchar(15) NOT NULL,
1303	`status` varchar(255) NOT NULL,
1304	`status_date` datetime NOT NULL,
1305	`invited_by` int(11) DEFAULT NULL,
1306	`invdate` datetime DEFAULT NULL,
1307	PRIMARY KEY (`id`),
1308	KEY `login` (`login`)
1309	) ENGINE=MyISAM DEFAULT CHARSET=cp1251 ROW_FORMAT=DYNAMIC;
1310
1311	INSERT INTO `#__users` (`id`, `group_id`, `login`, `nickname`, `password`, `email`, `icq`, `regdate`, `logdate`, `birthdate`, `is_locked`, `is_deleted`, `rating`, `points`, `last_ip`, `status`, `status_date`, `invited_by`, `invdate`) VALUES
1312	(1, 2, 'admin', 'Àäìèíèñòðàòîð', '2ca41752ccf4dbdb76d8fe88c488fd44', 'admin@cms.ru', '100200300', '2007-11-23 12:41:57', '2010-12-06 21:16:56', '1980-10-23', 0, 0, 32, 0, '127.0.0.1', 'Ñàìûé äëèííûé ñòàòóñ èç âñåõ ÷òî ñóùåñòâóþò â ýòîì ïðåêðàñíîì ìèðå', '2010-10-21 02:06:53', 0, '2010-11-09 23:25:59');
1313
1314	DROP TABLE IF EXISTS `#__users_activate`;
1315	CREATE TABLE `#__users_activate` (
1316	`id` int(11) NOT NULL AUTO_INCREMENT,
1317	`pubdate` datetime NOT NULL,
1318	`user_id` int(11) NOT NULL,
1319	`code` varchar(50) NOT NULL,
1320	PRIMARY KEY (`id`)
1321	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1322
1323
1324	DROP TABLE IF EXISTS `#__user_albums`;
1325	CREATE TABLE `#__user_albums` (
1326	`id` int(11) NOT NULL AUTO_INCREMENT,
1327	`user_id` int(11) NOT NULL,
1328	`title` varchar(100) NOT NULL,
1329	`pubdate` datetime NOT NULL,
1330	`allow_who` varchar(10) NOT NULL,
1331	`description` varchar(200) NOT NULL DEFAULT '',
1332	PRIMARY KEY (`id`),
1333	KEY `user_id` (`user_id`),
1334	KEY `allow_who` (`allow_who`)
1335	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1336
1337
1338	DROP TABLE IF EXISTS `#__user_autoawards`;
1339	CREATE TABLE `#__user_autoawards` (
1340	`id` int(11) NOT NULL AUTO_INCREMENT,
1341	`title` varchar(200) NOT NULL,
1342	`description` varchar(200) NOT NULL,
1343	`imageurl` varchar(200) NOT NULL,
1344	`p_comment` int(11) NOT NULL,
1345	`p_blog` int(11) NOT NULL,
1346	`p_forum` int(11) NOT NULL,
1347	`p_photo` int(11) NOT NULL,
1348	`p_privphoto` int(11) DEFAULT NULL,
1349	`p_content` int(11) NOT NULL,
1350	`p_karma` int(11) NOT NULL,
1351	`published` int(11) NOT NULL DEFAULT '1',
1352	PRIMARY KEY (`id`)
1353	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1354
1355
1356	DROP TABLE IF EXISTS `#__user_awards`;
1357	CREATE TABLE `#__user_awards` (
1358	`id` int(11) NOT NULL AUTO_INCREMENT,
1359	`user_id` int(11) NOT NULL,
1360	`pubdate` datetime NOT NULL,
1361	`title` varchar(250) NOT NULL,
1362	`description` text NOT NULL,
1363	`imageurl` varchar(100) NOT NULL,
1364	`from_id` int(11) NOT NULL,
1365	`award_id` int(11) NOT NULL,
1366	PRIMARY KEY (`id`),
1367	KEY `user_id` (`user_id`)
1368	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1369
1370	DROP TABLE IF EXISTS `#__user_clubs`;
1371	CREATE TABLE `#__user_clubs` (
1372	`user_id` int(11) NOT NULL,
1373	`club_id` int(11) NOT NULL,
1374	`role` varchar(20) NOT NULL DEFAULT 'guest',
1375	`pubdate` datetime NOT NULL
1376	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1377
1378
1379	DROP TABLE IF EXISTS `#__user_files`;
1380	CREATE TABLE `#__user_files` (
1381	`id` int(11) NOT NULL AUTO_INCREMENT,
1382	`user_id` int(11) NOT NULL,
1383	`filename` varchar(250) NOT NULL,
1384	`pubdate` datetime NOT NULL,
1385	`allow_who` varchar(50) NOT NULL,
1386	`filesize` int(11) NOT NULL,
1387	`hits` int(11) NOT NULL,
1388	PRIMARY KEY (`id`)
1389	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1390
1391
1392	DROP TABLE IF EXISTS `#__user_friends`;
1393	CREATE TABLE `#__user_friends` (
1394	`id` int(11) NOT NULL AUTO_INCREMENT,
1395	`to_id` int(11) NOT NULL,
1396	`from_id` int(11) NOT NULL,
1397	`logdate` datetime NOT NULL,
1398	`is_accepted` int(11) NOT NULL,
1399	PRIMARY KEY (`id`),
1400	KEY `to_id` (`to_id`),
1401	KEY `from_id` (`from_id`)
1402	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1403
1404
1405	DROP TABLE IF EXISTS `#__user_groups`;
1406	CREATE TABLE `#__user_groups` (
1407	`id` int(11) NOT NULL AUTO_INCREMENT,
1408	`title` varchar(200) NOT NULL,
1409	`alias` varchar(100) NOT NULL,
1410	`is_admin` int(11) NOT NULL,
1411	`access` text NOT NULL,
1412	PRIMARY KEY (`id`)
1413	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1414
1415	INSERT INTO `#__user_groups` (`id`, `title`, `alias`, `is_admin`, `access`) VALUES
1416	(1, 'Ïîëüçîâàòåëè', 'registered', 0, 'comments/add, comments/bbcode, comments/delete, content/add, board/autoadd'),
1417	(2, 'Àäìèíèñòðàòîðû', 'admin', 1, 'admin/content, admin/com_rssfeed, admin/com_arhive, admin/com_banners, admin/com_blog, admin/com_faq, admin/com_board, admin/com_content, admin/com_clubs, admin/com_comments, admin/com_forms, admin/com_photos'),
1418	(8, 'Ãîñòè', 'guest', 0, 'comments/add'),
1419	(7, 'Ðåäàêòîðû', 'editors', 0, 'comments/add, comments/delete, content/add, content/autoadd, content/delete'),
1420	(9, 'Ìîäåðàòîðû', 'moderators', 0, 'comments/add, comments/delete, comments/moderate, forum/moderate, content/add');
1421
1422	DROP TABLE IF EXISTS `#__user_invites`;
1423	CREATE TABLE `#__user_invites` (
1424	`id` int(11) NOT NULL AUTO_INCREMENT,
1425	`code` varchar(32) NOT NULL,
1426	`owner_id` int(11) NOT NULL,
1427	`createdate` datetime NOT NULL,
1428	`is_used` tinyint(4) NOT NULL DEFAULT '0',
1429	`is_sended` tinyint(4) NOT NULL DEFAULT '0',
1430	PRIMARY KEY (`id`),
1431	KEY `code` (`code`,`owner_id`,`is_used`)
1432	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1433
1434
1435	DROP TABLE IF EXISTS `#__user_karma`;
1436	CREATE TABLE `#__user_karma` (
1437	`id` int(11) NOT NULL AUTO_INCREMENT,
1438	`user_id` int(11) NOT NULL,
1439	`sender_id` int(11) NOT NULL,
1440	`points` smallint(6) NOT NULL,
1441	`senddate` datetime NOT NULL,
1442	PRIMARY KEY (`id`),
1443	KEY `user_id` (`user_id`)
1444	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1445
1446
1447	DROP TABLE IF EXISTS `#__user_msg`;
1448	CREATE TABLE `#__user_msg` (
1449	`id` int(11) NOT NULL AUTO_INCREMENT,
1450	`to_id` int(11) NOT NULL,
1451	`from_id` int(11) NOT NULL,
1452	`senddate` datetime NOT NULL,
1453	`is_new` int(11) NOT NULL DEFAULT '1',
1454	`message` text NOT NULL,
1455	`to_del` tinyint(4) NOT NULL DEFAULT '0',
1456	`from_del` tinyint(4) NOT NULL DEFAULT '0',
1457	PRIMARY KEY (`id`),
1458	KEY `to_id` (`to_id`),
1459	KEY `from_id` (`from_id`),
1460	KEY `to_del` (`to_del`),
1461	KEY `from_del` (`from_del`)
1462	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1463
1464
1465	DROP TABLE IF EXISTS `#__user_photos`;
1466	CREATE TABLE `#__user_photos` (
1467	`id` int(11) NOT NULL AUTO_INCREMENT,
1468	`user_id` int(11) NOT NULL,
1469	`album_id` int(11) NOT NULL,
1470	`pubdate` datetime NOT NULL,
1471	`title` varchar(250) NOT NULL,
1472	`description` text NOT NULL,
1473	`allow_who` varchar(15) NOT NULL DEFAULT 'all',
1474	`hits` int(11) NOT NULL,
1475	`imageurl` varchar(250) NOT NULL,
1476	PRIMARY KEY (`id`),
1477	KEY `user_id` (`user_id`),
1478	KEY `album_id` (`album_id`)
1479	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
1480
1481
1482	DROP TABLE IF EXISTS `#__user_profiles`;
1483	CREATE TABLE `#__user_profiles` (
1484	`id` int(11) NOT NULL AUTO_INCREMENT,
1485	`user_id` int(11) NOT NULL,
1486	`city` varchar(250) NOT NULL,
1487	`description` text NOT NULL,
1488	`showmail` int(11) NOT NULL,
1489	`showbirth` int(11) NOT NULL DEFAULT '1',
1490	`showicq` int(11) NOT NULL DEFAULT '1',
1491	`karma` int(11) NOT NULL,
1492	`imageurl` varchar(250) NOT NULL,
1493	`allow_who` varchar(35) NOT NULL DEFAULT 'all',
1494	`signature` varchar(240) NOT NULL,
1495	`gender` varchar(1) NOT NULL,
1496	`formsdata` text NOT NULL,
1497	`email_newmsg` int(11) NOT NULL DEFAULT '1',
1498	`cm_subscribe` varchar(4) NOT NULL,
1499	`stats` text NOT NULL,
1500	PRIMARY KEY (`id`),
1501	KEY `user_id` (`user_id`),
1502	KEY `city` (`city`)
1503	) ENGINE=MyISAM DEFAULT CHARSET=cp1251 ROW_FORMAT=DYNAMIC;
1504
1505	INSERT INTO `#__user_profiles` (`id`, `user_id`, `city`, `description`, `showmail`, `showbirth`, `showicq`, `karma`, `imageurl`, `allow_who`, `signature`, `gender`, `formsdata`, `email_newmsg`, `cm_subscribe`, `stats`) VALUES
1506	(1, 1, 'Ìîñêâà', 'Ð.Õàéíëàéí, À.Àçèìîâ, À.Êëàðê', 1, 1, 1, 0, '', 'all', '', 'm', '---\n22: Ð.Õàéíëàéí, À.Àçèìîâ, À.Êëàðê\n24: Âûñøåå\n', 1, 'none', '---\ncount: \n comments: 1\n forum: 1\n photos: 2\n board: 2\n files_public: 0\n files_private: 0\nrating: 0\n');
1507
1508	DROP TABLE IF EXISTS `#__user_wall`;
1509	CREATE TABLE `#__user_wall` (
1510	`id` int(11) NOT NULL AUTO_INCREMENT,
1511	`user_id` int(11) NOT NULL,
1512	`author_id` int(11) NOT NULL,
1513	`pubdate` datetime NOT NULL,
1514	`content` text NOT NULL,
1515	`usertype` varchar(8) NOT NULL DEFAULT 'user',
1516	PRIMARY KEY (`id`),
1517	KEY `user_id` (`user_id`)
1518	) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

Note: See TracBrowser for help on using the repository browser.

Context Navigation

source: trunk/install/sqldumpempty.sql @ 752

Download in other formats: