ticket:3190: v71.sql

File v71.sql, 216.0 KB (added by Nathan Paton, 9 years ago)

Fixed text

Line 
1--
2-- Database: v 7.1.2
3--
4
5-- --------------------------------------------------------
6
7SET NAMES 'utf8';
8DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_menu_admin`, `sys_menu_admin_top`, `sys_menu_bottom`, `sys_menu_service`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_cmts_profile`, `sys_cmts_track`, `sys_color_base`, `sys_countries`, `sys_email_templates`, `sys_menu_member`, `sys_friend_list`, `sys_options`, `sys_options_cats`, `sys_fave_list`, `sys_ip_list`, `sys_ip_members_visits`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `sys_messages`, `sys_page_compose`, `sys_page_compose_pages`, `sys_page_compose_privacy`, `sys_sessions`, `sys_stat_member`, `sys_pre_values`, `sys_profile_fields`, `sys_acl_levels_members`, `Profiles`, `sys_profile_views_track`, `sys_profiles_match`, `sys_profile_rating`, `sys_profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayChatMembershipsSettings`, `RayChatMemberships`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayMp3Tokens`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideoTokens`, `RayVideo_commentsFiles`, `RayVideo_commentsTokens`, `sys_objects_search`, `sys_shared_sites`, `sys_stat_site`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `sys_privacy_actions`, `sys_privacy_defaults`, `sys_privacy_groups`, `sys_privacy_members`, `sys_tags`, `sys_objects_tag`, `sys_menu_top`, `sys_objects_actions`, `sys_objects_auths`, `sys_greetings`, `sys_objects_vote`, `sys_objects_views`, `sys_box_download`, `sys_cron_jobs`, `sys_sbs_users`, `sys_sbs_entries`, `sys_sbs_types`, `sys_sbs_queue`, `sys_sbs_messages`, `sys_profiles_match_mails`, `sys_dnsbl_rules`, `sys_dnsbl_block_log`, `sys_dnsbluri_zones`, `sys_antispam_block_log`, `sys_menu_mobile`, `sys_menu_mobile_pages`, `sys_objects_social_sharing`, `sys_objects_site_maps`, `sys_objects_charts`, `sys_objects_captcha`, `sys_objects_editor`;
9ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci';
10
11-- --------------------------------------------------------
12
13--
14-- Table structure for table `sys_account_custom_stat_elements`
15--
16
17CREATE TABLE `sys_account_custom_stat_elements` (
18  `ID` int(2) NOT NULL auto_increment,
19  `Label` varchar(128) NOT NULL,
20  `Value` varchar(255) NOT NULL,
21  PRIMARY KEY  (`ID`)
22) ENGINE=MyISAM DEFAULT CHARSET=utf8;
23
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `sys_admin_ban_list`
29--
30
31CREATE TABLE `sys_admin_ban_list` (
32  `ProfID` int(10) unsigned NOT NULL default '0',
33  `Time` int(10) unsigned NOT NULL default '0',
34  `DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
35  PRIMARY KEY (`ProfID`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `sys_menu_admin`
42--
43
44CREATE TABLE `sys_menu_admin` (
45  `id` int(11) unsigned NOT NULL auto_increment,
46  `parent_id` int(11) NOT NULL default '0',
47  `name` varchar(32) NOT NULL default '',
48  `title` varchar(64) NOT NULL default '',
49  `url` varchar(255) NOT NULL default '',
50  `description` text NOT NULL default '', 
51  `icon` varchar(128) NOT NULL default '',
52  `icon_large` varchar(128) NOT NULL default '',
53  `check` varchar(255) NOT NULL default '',
54  `order` tinyint(4) unsigned NOT NULL default '0',
55  PRIMARY KEY  (`id`)
56) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
57
58--
59-- Dumping data for table `sys_menu_admin`
60--
61
62-- Users menu item
63INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
64(0, 'users', '_adm_mmi_users', '{siteAdminUrl}profiles.php', '', 'group col-green1', 'group', '', 2);
65SET @iParentId = LAST_INSERT_ID();
66
67-- Extensions menu item
68INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
69(0, 'modules', '_adm_mmi_modules', '', '', 'th-large col-red1', 'th-large', '', 3);
70SET @iParentId = LAST_INSERT_ID();
71
72INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
73(@iParentId, 'manage_modules', '_adm_mmi_manage_modules', '{siteAdminUrl}modules.php', 'Manage and configure integration modules for 3d party scripts', 'plus col-red1', '', '', 1),
74(@iParentId, 'flash_apps', '_adm_mmi_flash_apps', '{siteAdminUrl}flash.php', 'Flash Apps administration panel is available here', 'bolt col-red1', '', '', 2);
75
76-- Tools menu item
77INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
78(0, 'tools', '_adm_mmi_tools', '', '', 'wrench col-green3', 'wrench', '', 4);
79SET @iParentId = LAST_INSERT_ID();
80
81INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
82(@iParentId, 'mass_mailer', '_adm_mmi_mass_mailer', '{siteAdminUrl}notifies.php', 'Using this function you are able to send a newsletter to your site members', 'envelope col-green3', '', '', 1),
83(@iParentId, 'banners', '_adm_mmi_banners', '{siteAdminUrl}banners.php', 'Provides you with the ability to manage banners on your web site', 'flag col-green3', '', '', 4),
84(@iParentId, 'ip_blacklist', '_adm_mmi_ip_blacklist', '{siteAdminUrl}ip_blacklist.php', 'IP Blacklist system', 'ban-circle col-green3', '', '', 6),
85(@iParentId, 'database_backup', '_adm_mmi_database_backup', '{siteAdminUrl}db.php', 'Make a backup of your site database with this utility', 'download-alt col-green3', '', '', 7),
86(@iParentId, 'host_tools', '_adm_mmi_host_tools', '{siteAdminUrl}host_tools.php', 'Admin Host Tools', 'hdd col-green3', '', '', 8),
87(@iParentId, 'antispam', '_adm_mmi_antispam', '{siteAdminUrl}antispam.php', 'Antispam Tools', 'legal col-green3', '', '', 9),
88(@iParentId, 'sitemap', '_adm_mmi_sitemap', '{siteAdminUrl}sitemap.php', 'Sitemap', 'sitemap col-green3', '', '', 10),
89(@iParentId, 'cache', '_adm_mmi_cache', '{siteAdminUrl}cache.php', 'Cache', 'bolt col-green3', '', '', 11);
90
91-- Builders menu item
92INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
93(0, 'builders', '_adm_mmi_builders', '', '', 'reorder col-red2', 'reorder', '', 5);
94SET @iParentId = LAST_INSERT_ID();
95
96INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
97(@iParentId, 'navigation_menu', '_adm_mmi_navigation_menu', '{siteAdminUrl}nav_menu_compose.php', 'For top menu items management', 'list col-red2', '', '', 1),
98(@iParentId, 'service_menu', '_adm_mmi_service_menu', '{siteAdminUrl}service_menu_compose.php', 'For top service''s menu items management', 'list col-red2', '', '', 2),
99(@iParentId, 'bottom_menu', '_adm_mmi_bottom_menu', '{siteAdminUrl}bottom_menu_compose.php', 'For top bottom''s menu items management', 'list col-red2', '', '', 3),
100(@iParentId, 'member_menu', '_adm_mmi_member_menu', '{siteAdminUrl}member_menu_compose.php', 'For top member''s menu items management', 'list col-red2', '', '', 4),
101(@iParentId, 'admin_menu', '_adm_mmi_admin_menu', '{siteAdminUrl}menu_compose_admin.php', 'For top admin''s menu items management', 'list col-red2', '', '', 5),
102(@iParentId, 'profile_fields', '_adm_mmi_profile_fields', '{siteAdminUrl}fields.php', 'For member profile fields management', 'list-alt col-red2', '', '', 10),
103(@iParentId, 'pages_blocks', '_adm_mmi_pages_blocks', '{siteAdminUrl}pageBuilder.php', 'Compose blocks for the site pages here', 'th-large col-red2', '', '', 20),
104(@iParentId, 'mobile_pages', '_adm_mmi_mobile_pages', '{siteAdminUrl}mobileBuilder.php', 'Mobile pages builder', 'th col-red2', '', '', 21),
105(@iParentId, 'predefined_values', '_adm_mmi_predefined_values', '{siteAdminUrl}preValues.php', '', 'list-ol col-red2', '', '', 30);
106
107-- Settings menu item
108INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
109(0, 'settings', '_adm_mmi_settings', '', '', 'cogs col-blue2', 'cogs', '', 6);
110SET @iParentId = LAST_INSERT_ID();
111
112INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
113(@iParentId, 'admin_password', '_adm_mmi_admin_password', '{siteAdminUrl}settings.php?cat=ap', 'Change a password for access to administration panel here', 'asterisk col-blue2', '', '', 1),
114(@iParentId, 'basic_settings', '_adm_mmi_basic_settings', '{siteAdminUrl}basic_settings.php', 'For managing site system settings', 'cog col-blue2', '', '', 2),
115(@iParentId, 'advanced_settings', '_adm_mmi_advanced_settings', '{siteAdminUrl}advanced_settings.php', 'More enhanced settings for your site features', 'cogs col-blue2', '', '', 3),
116(@iParentId, 'languages_settings', '_adm_mmi_languages_settings', '{siteAdminUrl}lang_file.php', 'For languages management your website is using and making changes in your website content', 'globe col-blue2', '', '', 4),
117(@iParentId, 'membership_levels', '_adm_mmi_membership_levels', '{siteAdminUrl}memb_levels.php', 'For setting up different membership levels, different actions for each membership level and action limits', 'star col-blue2', '', '', 5),
118(@iParentId, 'email_templates', '_adm_mmi_email_templates', '{siteAdminUrl}email_templates.php', 'For setting up email texts which are sent from your website to members automatically', 'paste col-blue2', '', '', 6),
119(@iParentId, 'templates', '_adm_mmi_templates', '{siteAdminUrl}templates.php', 'Templates management', 'eye-open col-blue2', '', '', 7),
120(@iParentId, 'categories_settings', '_adm_mmi_categories_settings', '{siteAdminUrl}categories.php', 'Categories settings', 'folder-close col-blue2', '', '', 15),
121(@iParentId, 'watermark', '_adm_mmi_watermark', '{siteAdminUrl}settings.php?cat=16', 'Setting up watermark for media content', 'certificate col-blue2', '', '', 16);
122
123-- Dashboard menu item
124INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
125(0, 'dashboard', '_adm_mmi_dashboard', '{siteAdminUrl}index.php', '', 'dashboard col-blue3', 'dashboard', '', 1);
126SET @iParentId = LAST_INSERT_ID();
127
128-- License menu item
129INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
130(0, 'license', '_adm_mmi_license', '{siteAdminUrl}license.php', '', 'key col-red3', 'key', '', 7);
131SET @iParentId = LAST_INSERT_ID();
132
133-- --------------------------------------------------------
134
135--
136-- Table structure for table `sys_menu_admin_top`
137--
138
139CREATE TABLE `sys_menu_admin_top` (
140  `id` int(11) unsigned NOT NULL auto_increment,
141  `name` varchar(32) NOT NULL default '',
142  `caption` varchar(64) NOT NULL default '',
143  `url` varchar(255) NOT NULL default '',   
144  `icon` varchar(128) NOT NULL default '',
145  `order` float NOT NULL default '0',
146  PRIMARY KEY  (`id`)
147) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
148
149--
150-- Dumping data for table `sys_menu_admin_top`
151--
152
153INSERT INTO `sys_menu_admin_top`(`name`, `caption`, `url`, `icon`, `order`) VALUES
154('home', '_adm_tmi_home', '{site_url}index.php', 'globe', 1),
155('info', '_adm_tmi_info', 'http://www.boonex.com/trac/dolphin/wiki/Dolphin7Docs', 'question-sign', 2),
156('extensions', '_adm_tmi_extensions', 'http://www.boonex.com/market', 'shopping-cart', 3),
157('logout', '_adm_tmi_logout', '{site_url}logout.php', 'off', 4);
158
159-- --------------------------------------------------------
160
161--
162-- Table structure for table `sys_menu_service`
163--
164CREATE TABLE `sys_menu_service` (
165  `ID` int(10) unsigned NOT NULL auto_increment,
166  `Name` varchar(200) NOT NULL,
167  `Caption` varchar(100) NOT NULL,
168  `Icon` varchar(100) NOT NULL,
169  `Link` varchar(250) NOT NULL,
170  `Script` varchar(250) NOT NULL,
171  `Target` varchar(200) NOT NULL,
172  `Order` int(5) NOT NULL,
173  `Visible` set('non','memb') NOT NULL DEFAULT '',
174  `Active` tinyint(1) NOT NULL DEFAULT '1',
175  `Movable` tinyint(1) NOT NULL DEFAULT '1',
176  `Clonable` tinyint(1) NOT NULL DEFAULT '1',
177  `Editable` tinyint(1) NOT NULL DEFAULT '1',
178  `Deletable` tinyint(1) NOT NULL DEFAULT '1',
179  PRIMARY KEY  (`ID`)
180) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
181
182--
183-- Dumping data for table `sys_menu_bottom`
184--
185INSERT INTO `sys_menu_service` (`Name`, `Caption`, `Icon`, `Link`, `Script`, `Target`, `Order`, `Visible`, `Active`, `Movable`, `Clonable`, `Editable`, `Deletable`) VALUES
186('Join', '_sys_sm_join', '', 'join.php', '', '', 1, 'non', 1, 3, 1, 1, 1),
187('Login', '_sys_sm_login', '', '', 'showPopupLoginForm(); return false;', '', 2, 'non', 1, 3, 1, 1, 1),
188('Profile', '_sys_sm_profile', '', '{memberLink}|{memberNick}|change_status.php', '', '', 1, 'memb', 1, 3, 1, 1, 1),
189('Account', '_sys_sm_account', '', 'member.php', '', '', 2, 'memb', 1, 3, 1, 1, 1),
190('Logout', '_sys_sm_logout', '', 'logout.php?action=member_logout', '', '', 3, 'memb', 1, 3, 1, 1, 1);
191
192-- --------------------------------------------------------
193
194--
195-- Table structure for table `sys_menu_bottom`
196--
197CREATE TABLE `sys_menu_bottom` (
198  `ID` int(10) unsigned NOT NULL auto_increment,
199  `Caption` varchar(100) NOT NULL,
200  `Name` varchar(200) NOT NULL,
201  `Icon` varchar(100) NOT NULL,
202  `Link` varchar(250) NOT NULL,
203  `Script` varchar(250) NOT NULL,
204  `Order` int(5) NOT NULL,
205  `Target` varchar(200) NOT NULL,
206  `Visible` set('non','memb') NOT NULL DEFAULT '',
207  `Active` tinyint(1) NOT NULL DEFAULT '1',
208  `Movable` tinyint(1) NOT NULL DEFAULT '1',
209  `Clonable` tinyint(1) NOT NULL DEFAULT '1',
210  `Editable` tinyint(1) NOT NULL DEFAULT '1',
211  `Deletable` tinyint(1) NOT NULL DEFAULT '1',
212  PRIMARY KEY  (`ID`)
213) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
214
215--
216-- Dumping data for table `sys_menu_bottom`
217--
218INSERT INTO `sys_menu_bottom` (`Caption`, `Name`, `Icon`, `Link`, `Script`, `Order`, `Target`, `Visible`, `Active`, `Movable`, `Clonable`, `Editable`, `Deletable`) VALUES
219('_About Us', 'About Us', '', 'about_us.php', '', 1, '', 'non,memb', 1, 3, 1, 1, 1),
220('_Privacy', 'Privacy', '', 'privacy.php', '', 2, '', 'non,memb', 1, 3, 1, 1, 1),
221('_Terms_of_use', 'Terms of use', '', 'terms_of_use.php', '', 3, '', 'non,memb', 1, 3, 1, 1, 1),
222('_FAQ', 'FAQ', '', 'faq.php', '', 4, '', 'non,memb', 1, 3, 1, 1, 1),
223('_Invite a friend', 'Invite a friend', '', 'tellfriend.php', 'return launchTellFriend();', 5, '', 'non,memb', 1, 3, 1, 1, 1),
224('_contact_us', 'Contact us', '', 'contact.php', '', 6, '', 'non,memb', 1, 3, 1, 1, 1),
225('_Bookmark', 'Bookmark', '', '', 'addBookmark(); return false;', 7, '', 'non,memb', 1, 3, 1, 1, 1);
226
227-- --------------------------------------------------------
228
229
230-- --------------------------------------------------------
231
232--
233-- Table structure for table `sys_albums`
234--
235
236CREATE TABLE `sys_albums` (
237    `ID` int(10) NOT NULL auto_increment,
238    `Caption` varchar(128) NOT NULL default '',
239    `Uri` varchar(255) NOT NULL default '',
240    `Location` varchar(128) NOT NULL default '',
241    `Description` varchar(255) NOT NULL default '',
242    `Type` varchar(20) NOT NULL default '',
243    `Owner` int(10) NOT NULL default '0',
244    `Status` enum('active', 'passive') NOT NULL default 'active',
245    `Date` int(10) NOT NULL default '0',
246    `ObjCount` int(10) NOT NULL default '0',
247    `LastObjId` int(10) NOT NULL default '0',
248    `AllowAlbumView` int(10) NOT NULL default '3',
249    PRIMARY KEY (`ID`),
250    UNIQUE KEY (`Uri`, `Type`, `Owner`),
251    KEY `Owner` (`Owner`)
252) ENGINE=MyISAM DEFAULT CHARSET=utf8;
253
254--
255-- Dumping data for table `sys_albums`
256--
257
258-- --------------------------------------------------------
259
260--
261-- Table structure for table `sys_albums_objects`
262--
263
264CREATE TABLE `sys_albums_objects` (
265    `id_album` int(10) NOT NULL,
266    `id_object` int(10) NOT NULL,
267    `obj_order` int(10) NOT NULL default '0',
268    UNIQUE KEY (`id_album`, `id_object`),
269    KEY `id_object` (`id_object`)
270) ENGINE=MyISAM DEFAULT CHARSET=utf8;
271
272--
273-- Dumping data for table `sys_albums_objects`
274--
275
276-- --------------------------------------------------------
277
278--
279-- Table structure for table `sys_banners`
280--
281
282CREATE TABLE `sys_banners` (
283  `ID` int(11) unsigned NOT NULL auto_increment,
284  `Title` varchar(32) NOT NULL default '',
285  `Url` varchar(255) NOT NULL default '',
286  `Text` mediumtext NOT NULL,
287  `Active` tinyint(4) NOT NULL default '0',
288  `Created` date NOT NULL default '0000-00-00',
289  `campaign_start` date NOT NULL default '2005-01-01',
290  `campaign_end` date NOT NULL default '2007-01-01',
291  `Position` varchar(10) NOT NULL default '4',
292  `lhshift` int(5) NOT NULL default '-200',
293  `lvshift` int(5) NOT NULL default '-750',
294  `rhshift` int(5) NOT NULL default '100',
295  `rvshift` int(5) NOT NULL default '-750',
296  PRIMARY KEY  (`ID`)
297) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0;
298
299--
300-- Dumping data for table `sys_banners`
301--
302
303
304-- --------------------------------------------------------
305
306--
307-- Table structure for table `sys_banners_clicks`
308--
309
310CREATE TABLE `sys_banners_clicks` (
311  `ID` int(10) unsigned NOT NULL default '0',
312  `Date` int(10) NOT NULL default '0',
313  `IP` varchar(16) NOT NULL default '',
314  UNIQUE KEY `ID_2` (`ID`,`Date`,`IP`),
315  KEY `ID` (`ID`)
316) ENGINE=MyISAM DEFAULT CHARSET=utf8;
317
318--
319-- Dumping data for table `sys_banners_clicks`
320--
321
322
323-- --------------------------------------------------------
324
325--
326-- Table structure for table `sys_banners_shows`
327--
328
329CREATE TABLE `sys_banners_shows` (
330  `ID` int(10) unsigned NOT NULL default '0',
331  `Date` int(10) NOT NULL default '0',
332  `IP` varchar(16) NOT NULL default '',
333  KEY `ID` (`ID`)
334) ENGINE=MyISAM DEFAULT CHARSET=utf8;
335
336--
337-- Dumping data for table `sys_banners_shows`
338--
339
340
341-- --------------------------------------------------------
342
343--
344-- Table structure for table `sys_block_list`
345--
346
347CREATE TABLE `sys_block_list` (
348  `ID` int(10) unsigned NOT NULL default '0',
349  `Profile` int(10) unsigned NOT NULL default '0',
350  `When` timestamp NOT NULL default CURRENT_TIMESTAMP,
351  UNIQUE KEY `BlockPair` (`ID`,`Profile`),
352  KEY `ID` (`ID`),
353  KEY `Profile` (`Profile`)
354) ENGINE=MyISAM DEFAULT CHARSET=utf8;
355
356--
357-- Dumping data for table `sys_block_list`
358--
359
360-- --------------------------------------------------------
361
362--
363-- Table structure for table `sys_categories`
364--
365
366CREATE TABLE `sys_categories` (
367  `Category` varchar(32) NOT NULL default '',
368  `ID` int(10) unsigned NOT NULL default '0',
369  `Type` varchar(20) NOT NULL default 'photo',
370  `Owner` int(10) unsigned NOT NULL,
371  `Status` enum('active', 'passive') NOT NULL default 'active',
372  `Date` timestamp NOT NULL default CURRENT_TIMESTAMP,
373  PRIMARY KEY  (`Category`, `ID`, `Type`)
374) ENGINE=MyISAM DEFAULT CHARSET=utf8;
375
376--
377-- Dumping data for table `sys_categories`
378--
379
380-- --------------------------------------------------------
381
382
383--
384-- Table structure for table `sys_objects_auths`
385--
386
387CREATE TABLE `sys_objects_auths` (
388  `ID` int(10) unsigned NOT NULL auto_increment,
389  `Title` varchar(128) NOT NULL,
390  `Link` varchar(255) NOT NULL,
391  PRIMARY KEY  (`ID`)
392) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
393
394
395--
396-- Table structure for table `sys_objects_categories`
397--
398
399CREATE TABLE `sys_objects_categories` (
400  `ID` int(10) unsigned NOT NULL auto_increment,
401  `ObjectName` varchar(50) NOT NULL,
402  `Query` text  NOT NULL,
403  `PermalinkParam` varchar(50) NOT NULL default '',
404  `EnabledPermalink` varchar(100) NOT NULL default '',
405  `DisabledPermalink` varchar(100) NOT NULL default '',
406  `LangKey` varchar(100) NOT NULL default '',
407  PRIMARY KEY (`ID`)
408) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
409
410--
411-- Dumping data for table `sys_objects_categories`
412--
413
414-- --------------------------------------------------------
415
416--
417-- Table structure for table `sys_cmts_profile`
418--
419
420CREATE TABLE `sys_cmts_profile` (
421  `cmt_id` int(11) NOT NULL auto_increment,
422  `cmt_parent_id` int(11) NOT NULL default '0',
423  `cmt_object_id` int(11) NOT NULL default '0',
424  `cmt_author_id` int(10) unsigned NOT NULL default '0',
425  `cmt_text` text NOT NULL,
426  `cmt_mood` tinyint NOT NULL DEFAULT '0',
427  `cmt_rate` int(11) NOT NULL default '0',
428  `cmt_rate_count` int(11) NOT NULL default '0',
429  `cmt_time` datetime NOT NULL default '0000-00-00 00:00:00',
430  `cmt_replies` int(11) NOT NULL default '0',
431  PRIMARY KEY  (`cmt_id`),
432  KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
433) ENGINE=MyISAM DEFAULT CHARSET=utf8;
434
435--
436-- Dumping data for table `sys_cmts_profile`
437--
438
439-- --------------------------------------------------------
440
441--
442-- Table structure for table `sys_cmts_track`
443--
444
445CREATE TABLE `sys_cmts_track` (
446  `cmt_system_id` int(11) NOT NULL default '0',
447  `cmt_id` int(11) NOT NULL default '0',
448  `cmt_rate` tinyint(4) NOT NULL default '0',
449  `cmt_rate_author_id` int(10) unsigned NOT NULL default '0',
450  `cmt_rate_author_nip` int(11) unsigned NOT NULL default '0',
451  `cmt_rate_ts` int(11) NOT NULL default '0',
452  PRIMARY KEY  (`cmt_system_id`,`cmt_id`,`cmt_rate_author_nip`)
453) ENGINE=MyISAM DEFAULT CHARSET=utf8;
454
455--
456-- Dumping data for table `sys_cmts_track`
457--
458
459
460-- --------------------------------------------------------
461
462--
463-- Table structure for table `sys_objects_cmts`
464--
465
466CREATE TABLE `sys_objects_cmts` (
467  `ID` int(10) unsigned NOT NULL auto_increment,
468  `ObjectName` varchar(50) NOT NULL,
469  `TableCmts` varchar(50) NOT NULL,
470  `TableTrack` varchar(50) NOT NULL,
471  `AllowTags` smallint(1) NOT NULL,
472  `Nl2br` smallint(1) NOT NULL,
473  `SecToEdit` smallint(6) NOT NULL,
474  `PerView` smallint(6) NOT NULL,
475  `IsRatable` smallint(1) NOT NULL,
476  `ViewingThreshold` smallint(6) NOT NULL,
477  `AnimationEffect` varchar(50) NOT NULL,
478  `AnimationSpeed` smallint(6) NOT NULL,
479  `IsOn` smallint(1) NOT NULL,
480  `IsMood` smallint(1) NOT NULL,
481  `RootStylePrefix` varchar(16) NOT NULL default 'cmt',
482  `TriggerTable` varchar(32) NOT NULL,
483  `TriggerFieldId` varchar(32) NOT NULL,
484  `TriggerFieldComments` varchar(32) NOT NULL,
485  `ClassName` varchar(32) NOT NULL,
486  `ClassFile` varchar(256) NOT NULL,
487  PRIMARY KEY  (`ID`)
488) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
489
490--
491-- Dumping data for table `sys_objects_cmts`
492--
493
494INSERT INTO `sys_objects_cmts` VALUES(1, 'profile', 'sys_cmts_profile', 'sys_cmts_track', 0, 1, 90, 5, 1, -3, 'none', 0, 1, 0, 'cmt', 'Profiles', 'ID', 'CommentsCount', 'BxDolCmtsProfile', 'inc/classes/BxDolCmtsProfile.php');
495
496--
497-- Table structure for table `sys_color_base`
498--
499
500CREATE TABLE `sys_color_base` (
501  `ColorName` varchar(20) NOT NULL default '',
502  `ColorCode` varchar(10) NOT NULL default '',
503  UNIQUE KEY `ColorName` (`ColorName`)
504) ENGINE=MyISAM DEFAULT CHARSET=utf8;
505
506--
507-- Dumping data for table `sys_color_base`
508--
509
510INSERT INTO `sys_color_base` VALUES('AliceBlue', '#F0F8FF');
511INSERT INTO `sys_color_base` VALUES('AntiqueWhite', '#FAEBD7');
512INSERT INTO `sys_color_base` VALUES('Aqua', '#00FFFF');
513INSERT INTO `sys_color_base` VALUES('Aquamarine', '#7FFFD4');
514INSERT INTO `sys_color_base` VALUES('Azure', '#F0FFFF');
515INSERT INTO `sys_color_base` VALUES('Beige', '#F5F5DC');
516INSERT INTO `sys_color_base` VALUES('Bisque', '#FFE4C4');
517INSERT INTO `sys_color_base` VALUES('Black', '#000000');
518INSERT INTO `sys_color_base` VALUES('BlanchedAlmond', '#FFEBCD');
519INSERT INTO `sys_color_base` VALUES('Blue', '#0000FF');
520INSERT INTO `sys_color_base` VALUES('BlueViolet', '#8A2BE2');
521INSERT INTO `sys_color_base` VALUES('Brown', '#A52A2A');
522INSERT INTO `sys_color_base` VALUES('BurlyWood', '#DEB887');
523INSERT INTO `sys_color_base` VALUES('CadetBlue', '#5F9EA0');
524INSERT INTO `sys_color_base` VALUES('Chartreuse', '#7FFF00');
525INSERT INTO `sys_color_base` VALUES('Chocolate', '#D2691E');
526INSERT INTO `sys_color_base` VALUES('Coral', '#FF7F50');
527INSERT INTO `sys_color_base` VALUES('CornflowerBlue', '#6495ED');
528INSERT INTO `sys_color_base` VALUES('Cornsilk', '#FFF8DC');
529INSERT INTO `sys_color_base` VALUES('Crimson', '#DC143C');
530INSERT INTO `sys_color_base` VALUES('Cyan', '#00FFFF');
531INSERT INTO `sys_color_base` VALUES('DarkBlue', '#00008B');
532INSERT INTO `sys_color_base` VALUES('DarkCyan', '#008B8B');
533INSERT INTO `sys_color_base` VALUES('DarkGoldenRod', '#B8860B');
534INSERT INTO `sys_color_base` VALUES('DarkGray', '#A9A9A9');
535INSERT INTO `sys_color_base` VALUES('DarkGreen', '#006400');
536INSERT INTO `sys_color_base` VALUES('DarkKhaki', '#BDB76B');
537INSERT INTO `sys_color_base` VALUES('DarkMagenta', '#8B008B');
538INSERT INTO `sys_color_base` VALUES('DarkOliveGreen', '#556B2F');
539INSERT INTO `sys_color_base` VALUES('Darkorange', '#FF8C00');
540INSERT INTO `sys_color_base` VALUES('DarkOrchid', '#9932CC');
541INSERT INTO `sys_color_base` VALUES('DarkRed', '#8B0000');
542INSERT INTO `sys_color_base` VALUES('DarkSalmon', '#E9967A');
543INSERT INTO `sys_color_base` VALUES('DarkSeaGreen', '#8FBC8F');
544INSERT INTO `sys_color_base` VALUES('DarkSlateBlue', '#483D8B');
545INSERT INTO `sys_color_base` VALUES('DarkSlateGray', '#2F4F4F');
546INSERT INTO `sys_color_base` VALUES('DarkTurquoise', '#00CED1');
547INSERT INTO `sys_color_base` VALUES('DarkViolet', '#9400D3');
548INSERT INTO `sys_color_base` VALUES('DeepPink', '#FF1493');
549INSERT INTO `sys_color_base` VALUES('DeepSkyBlue', '#00BFFF');
550INSERT INTO `sys_color_base` VALUES('DimGray', '#696969');
551INSERT INTO `sys_color_base` VALUES('DodgerBlue', '#1E90FF');
552INSERT INTO `sys_color_base` VALUES('Feldspar', '#D19275');
553INSERT INTO `sys_color_base` VALUES('FireBrick', '#B22222');
554INSERT INTO `sys_color_base` VALUES('FloralWhite', '#FFFAF0');
555INSERT INTO `sys_color_base` VALUES('ForestGreen', '#228B22');
556INSERT INTO `sys_color_base` VALUES('Fuchsia', '#FF00FF');
557INSERT INTO `sys_color_base` VALUES('Gainsboro', '#DCDCDC');
558INSERT INTO `sys_color_base` VALUES('GhostWhite', '#F8F8FF');
559INSERT INTO `sys_color_base` VALUES('Gold', '#FFD700');
560INSERT INTO `sys_color_base` VALUES('GoldenRod', '#DAA520');
561INSERT INTO `sys_color_base` VALUES('Gray', '#808080');
562INSERT INTO `sys_color_base` VALUES('Green', '#008000');
563INSERT INTO `sys_color_base` VALUES('GreenYellow', '#ADFF2F');
564INSERT INTO `sys_color_base` VALUES('HoneyDew', '#F0FFF0');
565INSERT INTO `sys_color_base` VALUES('HotPink', '#FF69B4');
566INSERT INTO `sys_color_base` VALUES('IndianRed', '#CD5C5C');
567INSERT INTO `sys_color_base` VALUES('Indigo', '#4B0082');
568INSERT INTO `sys_color_base` VALUES('Ivory', '#FFFFF0');
569INSERT INTO `sys_color_base` VALUES('Khaki', '#F0E68C');
570INSERT INTO `sys_color_base` VALUES('Lavender', '#E6E6FA');
571INSERT INTO `sys_color_base` VALUES('LavenderBlush', '#FFF0F5');
572INSERT INTO `sys_color_base` VALUES('LawnGreen', '#7CFC00');
573INSERT INTO `sys_color_base` VALUES('LemonChiffon', '#FFFACD');
574INSERT INTO `sys_color_base` VALUES('LightBlue', '#ADD8E6');
575INSERT INTO `sys_color_base` VALUES('LightCoral', '#F08080');
576INSERT INTO `sys_color_base` VALUES('LightCyan', '#E0FFFF');
577INSERT INTO `sys_color_base` VALUES('LightGoldenRodYellow', '#FAFAD2');
578INSERT INTO `sys_color_base` VALUES('LightGrey', '#D3D3D3');
579INSERT INTO `sys_color_base` VALUES('LightGreen', '#90EE90');
580INSERT INTO `sys_color_base` VALUES('LightPink', '#FFB6C1');
581INSERT INTO `sys_color_base` VALUES('LightSalmon', '#FFA07A');
582INSERT INTO `sys_color_base` VALUES('LightSeaGreen', '#20B2AA');
583INSERT INTO `sys_color_base` VALUES('LightSkyBlue', '#87CEFA');
584INSERT INTO `sys_color_base` VALUES('LightSlateBlue', '#8470FF');
585INSERT INTO `sys_color_base` VALUES('LightSlateGray', '#778899');
586INSERT INTO `sys_color_base` VALUES('LightSteelBlue', '#B0C4DE');
587INSERT INTO `sys_color_base` VALUES('LightYellow', '#FFFFE0');
588INSERT INTO `sys_color_base` VALUES('Lime', '#00FF00');
589INSERT INTO `sys_color_base` VALUES('LimeGreen', '#32CD32');
590INSERT INTO `sys_color_base` VALUES('Linen', '#FAF0E6');
591INSERT INTO `sys_color_base` VALUES('Magenta', '#FF00FF');
592INSERT INTO `sys_color_base` VALUES('Maroon', '#800000');
593INSERT INTO `sys_color_base` VALUES('MediumAquaMarine', '#66CDAA');
594INSERT INTO `sys_color_base` VALUES('MediumBlue', '#0000CD');
595INSERT INTO `sys_color_base` VALUES('MediumOrchid', '#BA55D3');
596INSERT INTO `sys_color_base` VALUES('MediumPurple', '#9370D8');
597INSERT INTO `sys_color_base` VALUES('MediumSeaGreen', '#3CB371');
598INSERT INTO `sys_color_base` VALUES('MediumSlateBlue', '#7B68EE');
599INSERT INTO `sys_color_base` VALUES('MediumSpringGreen', '#00FA9A');
600INSERT INTO `sys_color_base` VALUES('MediumTurquoise', '#48D1CC');
601INSERT INTO `sys_color_base` VALUES('MediumVioletRed', '#C71585');
602INSERT INTO `sys_color_base` VALUES('MidnightBlue', '#191970');
603INSERT INTO `sys_color_base` VALUES('MintCream', '#F5FFFA');
604INSERT INTO `sys_color_base` VALUES('MistyRose', '#FFE4E1');
605INSERT INTO `sys_color_base` VALUES('Moccasin', '#FFE4B5');
606INSERT INTO `sys_color_base` VALUES('NavajoWhite', '#FFDEAD');
607INSERT INTO `sys_color_base` VALUES('Navy', '#000080');
608INSERT INTO `sys_color_base` VALUES('OldLace', '#FDF5E6');
609INSERT INTO `sys_color_base` VALUES('Olive', '#808000');
610INSERT INTO `sys_color_base` VALUES('OliveDrab', '#6B8E23');
611INSERT INTO `sys_color_base` VALUES('Orange', '#FFA500');
612INSERT INTO `sys_color_base` VALUES('OrangeRed', '#FF4500');
613INSERT INTO `sys_color_base` VALUES('Orchid', '#DA70D6');
614INSERT INTO `sys_color_base` VALUES('PaleGoldenRod', '#EEE8AA');
615INSERT INTO `sys_color_base` VALUES('PaleGreen', '#98FB98');
616INSERT INTO `sys_color_base` VALUES('PaleTurquoise', '#AFEEEE');
617INSERT INTO `sys_color_base` VALUES('PaleVioletRed', '#D87093');
618INSERT INTO `sys_color_base` VALUES('PapayaWhip', '#FFEFD5');
619INSERT INTO `sys_color_base` VALUES('PeachPuff', '#FFDAB9');
620INSERT INTO `sys_color_base` VALUES('Peru', '#CD853F');
621INSERT INTO `sys_color_base` VALUES('Pink', '#FFC0CB');
622INSERT INTO `sys_color_base` VALUES('Plum', '#DDA0DD');
623INSERT INTO `sys_color_base` VALUES('PowderBlue', '#B0E0E6');
624INSERT INTO `sys_color_base` VALUES('Purple', '#800080');
625INSERT INTO `sys_color_base` VALUES('Red', '#FF0000');
626INSERT INTO `sys_color_base` VALUES('RosyBrown', '#BC8F8F');
627INSERT INTO `sys_color_base` VALUES('RoyalBlue', '#4169E1');
628INSERT INTO `sys_color_base` VALUES('SaddleBrown', '#8B4513');
629INSERT INTO `sys_color_base` VALUES('Salmon', '#FA8072');
630INSERT INTO `sys_color_base` VALUES('SandyBrown', '#F4A460');
631INSERT INTO `sys_color_base` VALUES('SeaGreen', '#2E8B57');
632INSERT INTO `sys_color_base` VALUES('SeaShell', '#FFF5EE');
633INSERT INTO `sys_color_base` VALUES('Sienna', '#A0522D');
634INSERT INTO `sys_color_base` VALUES('Silver', '#C0C0C0');
635INSERT INTO `sys_color_base` VALUES('SkyBlue', '#87CEEB');
636INSERT INTO `sys_color_base` VALUES('SlateBlue', '#6A5ACD');
637INSERT INTO `sys_color_base` VALUES('SlateGray', '#708090');
638INSERT INTO `sys_color_base` VALUES('Snow', '#FFFAFA');
639INSERT INTO `sys_color_base` VALUES('SpringGreen', '#00FF7F');
640INSERT INTO `sys_color_base` VALUES('SteelBlue', '#4682B4');
641INSERT INTO `sys_color_base` VALUES('Tan', '#D2B48C');
642INSERT INTO `sys_color_base` VALUES('Teal', '#008080');
643INSERT INTO `sys_color_base` VALUES('Thistle', '#D8BFD8');
644INSERT INTO `sys_color_base` VALUES('Tomato', '#FF6347');
645INSERT INTO `sys_color_base` VALUES('Turquoise', '#40E0D0');
646INSERT INTO `sys_color_base` VALUES('Violet', '#EE82EE');
647INSERT INTO `sys_color_base` VALUES('VioletRed', '#D02090');
648INSERT INTO `sys_color_base` VALUES('Wheat', '#F5DEB3');
649INSERT INTO `sys_color_base` VALUES('White', '#FFFFFF');
650INSERT INTO `sys_color_base` VALUES('WhiteSmoke', '#F5F5F5');
651INSERT INTO `sys_color_base` VALUES('Yellow', '#FFFF00');
652INSERT INTO `sys_color_base` VALUES('YellowGreen', '#9ACD32');
653
654-- --------------------------------------------------------
655
656--
657-- Table structure for table `sys_countries`
658--
659
660CREATE TABLE `sys_countries` (
661  `ISO2` varchar(2) NOT NULL default '',
662  `ISO3` varchar(3) NOT NULL default '',
663  `ISONo` smallint(3) NOT NULL default '0',
664  `Country` varchar(100) NOT NULL default '',
665  `Region` varchar(100) default NULL,
666  `Currency` varchar(100) default NULL,
667  `CurrencyCode` varchar(3) default NULL,
668  PRIMARY KEY  (`ISO2`),
669  KEY `CurrencyCode` (`CurrencyCode`)
670) ENGINE=MyISAM DEFAULT CHARSET=utf8;
671
672--
673-- Dumping data for table `sys_countries`
674--
675
676INSERT INTO `sys_countries` VALUES('AD', 'AND', 20, 'Andorra', 'Europe', 'Euro', 'EUR');
677INSERT INTO `sys_countries` VALUES('AE', 'ARE', 784, 'United Arab Emirates', 'Middle East', 'UAE Dirham', 'AED');
678INSERT INTO `sys_countries` VALUES('AF', 'AFG', 4, 'Afghanistan', 'Asia', 'Afghani', 'AFA');
679INSERT INTO `sys_countries` VALUES('AG', 'ATG', 28, 'Antigua and Barbuda', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
680INSERT INTO `sys_countries` VALUES('AI', 'AIA', 660, 'Anguilla', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
681INSERT INTO `sys_countries` VALUES('AL', 'ALB', 8, 'Albania', 'Europe', 'Lek', 'ALL');
682INSERT INTO `sys_countries` VALUES('AM', 'ARM', 51, 'Armenia', 'Commonwealth of Independent States', 'Armenian Dram', 'AMD');
683INSERT INTO `sys_countries` VALUES('AN', 'ANT', 530, 'Netherlands Antilles', 'Central America and the Caribbean', 'Netherlands Antillean guilder', 'ANG');
684INSERT INTO `sys_countries` VALUES('AO', 'AGO', 24, 'Angola', 'Africa', 'Kwanza', 'AOA');
685INSERT INTO `sys_countries` VALUES('AQ', 'ATA', 10, 'Antarctica', 'Antarctic Region', NULL, NULL);
686INSERT INTO `sys_countries` VALUES('AR', 'ARG', 32, 'Argentina', 'South America', 'Argentine Peso', 'ARS');
687INSERT INTO `sys_countries` VALUES('AS', 'ASM', 16, 'American Samoa', 'Oceania', 'US Dollar', 'USD');
688INSERT INTO `sys_countries` VALUES('AT', 'AUT', 40, 'Austria', 'Europe', 'Euro', 'EUR');
689INSERT INTO `sys_countries` VALUES('AU', 'AUS', 36, 'Australia', 'Oceania', 'Australian dollar', 'AUD');
690INSERT INTO `sys_countries` VALUES('AW', 'ABW', 533, 'Aruba', 'Central America and the Caribbean', 'Aruban Guilder', 'AWG');
691INSERT INTO `sys_countries` VALUES('AX', 'ALA', 248, 'Aland Islands', 'Europe', 'Euro', 'EUR');
692INSERT INTO `sys_countries` VALUES('AZ', 'AZE', 31, 'Azerbaijan', 'Commonwealth of Independent States', 'Azerbaijani Manat', 'AZM');
693INSERT INTO `sys_countries` VALUES('BA', 'BIH', 70, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina, Europe', 'Convertible Marka', 'BAM');
694INSERT INTO `sys_countries` VALUES('BB', 'BRB', 52, 'Barbados', 'Central America and the Caribbean', 'Barbados Dollar', 'BBD');
695INSERT INTO `sys_countries` VALUES('BD', 'BGD', 50, 'Bangladesh', 'Asia', 'Taka', 'BDT');
696INSERT INTO `sys_countries` VALUES('BE', 'BEL', 56, 'Belgium', 'Europe', 'Euro', 'EUR');
697INSERT INTO `sys_countries` VALUES('BF', 'BFA', 854, 'Burkina Faso', 'Africa', 'CFA Franc BCEAO', 'XOF');
698INSERT INTO `sys_countries` VALUES('BG', 'BGR', 100, 'Bulgaria', 'Europe', 'Lev', 'BGL');
699INSERT INTO `sys_countries` VALUES('BH', 'BHR', 48, 'Bahrain', 'Middle East', 'Bahraini Dinar', 'BHD');
700INSERT INTO `sys_countries` VALUES('BI', 'BDI', 108, 'Burundi', 'Africa', 'Burundi Franc', 'BIF');
701INSERT INTO `sys_countries` VALUES('BJ', 'BEN', 204, 'Benin', 'Africa', 'CFA Franc BCEAO', 'XOF');
702INSERT INTO `sys_countries` VALUES('BL', 'BLM', 652, 'Saint Barthelemy', 'Central America and the Caribbean', 'Euro', 'EUR');
703INSERT INTO `sys_countries` VALUES('BM', 'BMU', 60, 'Bermuda', 'North America', 'Bermudian Dollar', 'BMD');
704INSERT INTO `sys_countries` VALUES('BN', 'BRN', 96, 'Brunei Darussalam', 'Southeast Asia', 'Brunei Dollar', 'BND');
705INSERT INTO `sys_countries` VALUES('BO', 'BOL', 68, 'Bolivia', 'South America', 'Boliviano', 'BOB');
706INSERT INTO `sys_countries` VALUES('BR', 'BRA', 76, 'Brazil', 'South America', 'Brazilian Real', 'BRL');
707INSERT INTO `sys_countries` VALUES('BS', 'BHS', 44, 'The Bahamas', 'Central America and the Caribbean', 'Bahamian Dollar', 'BSD');
708INSERT INTO `sys_countries` VALUES('BT', 'BTN', 64, 'Bhutan', 'Asia', 'Ngultrum', 'BTN');
709INSERT INTO `sys_countries` VALUES('BV', 'BVT', 74, 'Bouvet Island', 'Antarctic Region', 'Norwegian Krone', 'NOK');
710INSERT INTO `sys_countries` VALUES('BW', 'BWA', 72, 'Botswana', 'Africa', 'Pula', 'BWP');
711INSERT INTO `sys_countries` VALUES('BY', 'BLR', 112, 'Belarus', 'Commonwealth of Independent States', 'Belarussian Ruble', 'BYR');
712INSERT INTO `sys_countries` VALUES('BZ', 'BLZ', 84, 'Belize', 'Central America and the Caribbean', 'Belize Dollar', 'BZD');
713INSERT INTO `sys_countries` VALUES('CA', 'CAN', 124, 'Canada', 'North America', 'Canadian Dollar', 'CAD');
714INSERT INTO `sys_countries` VALUES('CC', 'CCK', 166, 'Cocos (Keeling) Islands', 'Southeast Asia', 'Australian Dollar', 'AUD');
715INSERT INTO `sys_countries` VALUES('CD', 'COD', 180, 'Congo, Democratic Republic of the', 'Africa', 'Franc Congolais', 'CDF');
716INSERT INTO `sys_countries` VALUES('CF', 'CAF', 140, 'Central African Republic', 'Africa', 'CFA Franc BEAC', 'XAF');
717INSERT INTO `sys_countries` VALUES('CG', 'COG', 178, 'Congo, Republic of the', 'Africa', 'CFA Franc BEAC', 'XAF');
718INSERT INTO `sys_countries` VALUES('CH', 'CHE', 756, 'Switzerland', 'Europe', 'Swiss Franc', 'CHF');
719INSERT INTO `sys_countries` VALUES('CI', 'CIV', 384, 'Cote d''Ivoire', 'Africa', 'CFA Franc BCEAO', 'XOF');
720INSERT INTO `sys_countries` VALUES('CK', 'COK', 184, 'Cook Islands', 'Oceania', 'New Zealand Dollar', 'NZD');
721INSERT INTO `sys_countries` VALUES('CL', 'CHL', 152, 'Chile', 'South America', 'Chilean Peso', 'CLP');
722INSERT INTO `sys_countries` VALUES('CM', 'CMR', 120, 'Cameroon', 'Africa', 'CFA Franc BEAC', 'XAF');
723INSERT INTO `sys_countries` VALUES('CN', 'CHN', 156, 'China', 'Asia', 'Yuan Renminbi', 'CNY');
724INSERT INTO `sys_countries` VALUES('CO', 'COL', 170, 'Colombia', 'South America, Central America and the Caribbean', 'Colombian Peso', 'COP');
725INSERT INTO `sys_countries` VALUES('CR', 'CRI', 188, 'Costa Rica', 'Central America and the Caribbean', 'Costa Rican Colon', 'CRC');
726INSERT INTO `sys_countries` VALUES('CU', 'CUB', 192, 'Cuba', 'Central America and the Caribbean', 'Cuban Peso', 'CUP');
727INSERT INTO `sys_countries` VALUES('CV', 'CPV', 132, 'Cape Verde', 'World', 'Cape Verdean Escudo', 'CVE');
728INSERT INTO `sys_countries` VALUES('CX', 'CXR', 162, 'Christmas Island', 'Southeast Asia', 'Australian Dollar', 'AUD');
729INSERT INTO `sys_countries` VALUES('CY', 'CYP', 196, 'Cyprus', 'Middle East', 'Cyprus Pound', 'CYP');
730INSERT INTO `sys_countries` VALUES('CZ', 'CZE', 203, 'Czech Republic', 'Europe', 'Czech Koruna', 'CZK');
731INSERT INTO `sys_countries` VALUES('DE', 'DEU', 276, 'Germany', 'Europe', 'Euro', 'EUR');
732INSERT INTO `sys_countries` VALUES('DJ', 'DJI', 262, 'Djibouti', 'Africa', 'Djibouti Franc', 'DJF');
733INSERT INTO `sys_countries` VALUES('DK', 'DNK', 208, 'Denmark', 'Europe', 'Danish Krone', 'DKK');
734INSERT INTO `sys_countries` VALUES('DM', 'DMA', 212, 'Dominica', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
735INSERT INTO `sys_countries` VALUES('DO', 'DOM', 214, 'Dominican Republic', 'Central America and the Caribbean', 'Dominican Peso', 'DOP');
736INSERT INTO `sys_countries` VALUES('DZ', 'DZA', 12, 'Algeria', 'Africa', 'Algerian Dinar', 'DZD');
737INSERT INTO `sys_countries` VALUES('EC', 'ECU', 218, 'Ecuador', 'South America', 'US dollar', 'USD');
738INSERT INTO `sys_countries` VALUES('EE', 'EST', 233, 'Estonia', 'Europe', 'Kroon', 'EEK');
739INSERT INTO `sys_countries` VALUES('EG', 'EGY', 818, 'Egypt', 'Africa', 'Egyptian Pound', 'EGP');
740INSERT INTO `sys_countries` VALUES('EH', 'ESH', 732, 'Western Sahara', 'Africa', 'Moroccan Dirham', 'MAD');
741INSERT INTO `sys_countries` VALUES('ER', 'ERI', 232, 'Eritrea', 'Africa', 'Nakfa', 'ERN');
742INSERT INTO `sys_countries` VALUES('ES', 'ESP', 724, 'Spain', 'Europe', 'Euro', 'EUR');
743INSERT INTO `sys_countries` VALUES('ET', 'ETH', 231, 'Ethiopia', 'Africa', 'Ethiopian Birr', 'ETB');
744INSERT INTO `sys_countries` VALUES('FI', 'FIN', 246, 'Finland', 'Europe', 'Euro', 'EUR');
745INSERT INTO `sys_countries` VALUES('FJ', 'FJI', 242, 'Fiji', 'Oceania', 'Fijian Dollar', 'FJD');
746INSERT INTO `sys_countries` VALUES('FK', 'FLK', 238, 'Falkland Islands (Islas Malvinas)', 'South America', 'Falkland Islands Pound', 'FKP');
747INSERT INTO `sys_countries` VALUES('FM', 'FSM', 583, 'Micronesia, Federated States of', 'Oceania', 'US dollar', 'USD');
748INSERT INTO `sys_countries` VALUES('FO', 'FRO', 234, 'Faroe Islands', 'Europe', 'Danish Krone', 'DKK');
749INSERT INTO `sys_countries` VALUES('FR', 'FRA', 250, 'France', 'Europe', 'Euro', 'EUR');
750INSERT INTO `sys_countries` VALUES('GA', 'GAB', 266, 'Gabon', 'Africa', 'CFA Franc BEAC', 'XAF');
751INSERT INTO `sys_countries` VALUES('GB', 'GBR', 826, 'United Kingdom', 'Europe', 'Pound Sterling', 'GBP');
752INSERT INTO `sys_countries` VALUES('GD', 'GRD', 308, 'Grenada', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
753INSERT INTO `sys_countries` VALUES('GE', 'GEO', 268, 'Georgia', 'Commonwealth of Independent States', 'Lari', 'GEL');
754INSERT INTO `sys_countries` VALUES('GF', 'GUF', 254, 'French Guiana', 'South America', 'Euro', 'EUR');
755INSERT INTO `sys_countries` VALUES('GG', 'GGY', 831, 'Guernsey', 'Europe', 'Pound sterling', 'GBP');
756INSERT INTO `sys_countries` VALUES('GH', 'GHA', 288, 'Ghana', 'Africa', 'Cedi', 'GHC');
757INSERT INTO `sys_countries` VALUES('GI', 'GIB', 292, 'Gibraltar', 'Europe', 'Gibraltar Pound', 'GIP');
758INSERT INTO `sys_countries` VALUES('GL', 'GRL', 304, 'Greenland', 'Arctic Region', 'Danish Krone', 'DKK');
759INSERT INTO `sys_countries` VALUES('GM', 'GMB', 270, 'The Gambia', 'Africa', 'Dalasi', 'GMD');
760INSERT INTO `sys_countries` VALUES('GN', 'GIN', 324, 'Guinea', 'Africa', 'Guinean Franc', 'GNF');
761INSERT INTO `sys_countries` VALUES('GP', 'GLP', 312, 'Guadeloupe', 'Central America and the Caribbean', 'Euro', 'EUR');
762INSERT INTO `sys_countries` VALUES('GQ', 'GNQ', 226, 'Equatorial Guinea', 'Africa', 'CFA Franc BEAC', 'XAF');
763INSERT INTO `sys_countries` VALUES('GR', 'GRC', 300, 'Greece', 'Europe', 'Euro', 'EUR');
764INSERT INTO `sys_countries` VALUES('GS', 'SGS', 239, 'South Georgia and the South Sandwich Islands', 'Antarctic Region', 'Pound Sterling', 'GBP');
765INSERT INTO `sys_countries` VALUES('GT', 'GTM', 320, 'Guatemala', 'Central America and the Caribbean', 'Quetzal', 'GTQ');
766INSERT INTO `sys_countries` VALUES('GU', 'GUM', 316, 'Guam', 'Oceania', 'US Dollar', 'USD');
767INSERT INTO `sys_countries` VALUES('GW', 'GNB', 624, 'Guinea-Bissau', 'Africa', 'CFA Franc BCEAO', 'XOF');
768INSERT INTO `sys_countries` VALUES('GY', 'GUY', 328, 'Guyana', 'South America', 'Guyana Dollar', 'GYD');
769INSERT INTO `sys_countries` VALUES('HK', 'HKG', 344, 'Hong Kong (SAR)', 'Southeast Asia', 'Hong Kong Dollar', 'HKD');
770INSERT INTO `sys_countries` VALUES('HM', 'HMD', 334, 'Heard Island and McDonald Islands', 'Antarctic Region', 'Australian Dollar', 'AUD');
771INSERT INTO `sys_countries` VALUES('HN', 'HND', 340, 'Honduras', 'Central America and the Caribbean', 'Lempira', 'HNL');
772INSERT INTO `sys_countries` VALUES('HR', 'HRV', 191, 'Croatia', 'Europe', 'Kuna', 'HRK');
773INSERT INTO `sys_countries` VALUES('HT', 'HTI', 332, 'Haiti', 'Central America and the Caribbean', 'Gourde', 'HTG');
774INSERT INTO `sys_countries` VALUES('HU', 'HUN', 348, 'Hungary', 'Europe', 'Forint', 'HUF');
775INSERT INTO `sys_countries` VALUES('ID', 'IDN', 360, 'Indonesia', 'Southeast Asia', 'Rupiah', 'IDR');
776INSERT INTO `sys_countries` VALUES('IE', 'IRL', 372, 'Ireland', 'Europe', 'Euro', 'EUR');
777INSERT INTO `sys_countries` VALUES('IL', 'ISR', 376, 'Israel', 'Middle East', 'New Israeli Sheqel', 'ILS');
778INSERT INTO `sys_countries` VALUES('IM', 'IMN', 833, 'Isle of Man', 'Europe', 'Pound sterling', 'GBP');
779INSERT INTO `sys_countries` VALUES('IN', 'IND', 356, 'India', 'Asia', 'Indian Rupee', 'INR');
780INSERT INTO `sys_countries` VALUES('IO', 'IOT', 86, 'British Indian Ocean Territory', 'World', 'US Dollar', 'USD');
781INSERT INTO `sys_countries` VALUES('IQ', 'IRQ', 368, 'Iraq', 'Middle East', 'Iraqi Dinar', 'IQD');
782INSERT INTO `sys_countries` VALUES('IR', 'IRN', 364, 'Iran', 'Middle East', 'Iranian Rial', 'IRR');
783INSERT INTO `sys_countries` VALUES('IS', 'ISL', 352, 'Iceland', 'Arctic Region', 'Iceland Krona', 'ISK');
784INSERT INTO `sys_countries` VALUES('IT', 'ITA', 380, 'Italy', 'Europe', 'Euro', 'EUR');
785INSERT INTO `sys_countries` VALUES('JE', 'JEY', 832, 'Jersey', 'Europe', 'Pound sterling', 'GBP');
786INSERT INTO `sys_countries` VALUES('JM', 'JAM', 388, 'Jamaica', 'Central America and the Caribbean', 'Jamaican dollar', 'JMD');
787INSERT INTO `sys_countries` VALUES('JO', 'JOR', 400, 'Jordan', 'Middle East', 'Jordanian Dinar', 'JOD');
788INSERT INTO `sys_countries` VALUES('JP', 'JPN', 392, 'Japan', 'Asia', 'Yen', 'JPY');
789INSERT INTO `sys_countries` VALUES('KE', 'KEN', 404, 'Kenya', 'Africa', 'Kenyan shilling', 'KES');
790INSERT INTO `sys_countries` VALUES('KG', 'KGZ', 417, 'Kyrgyzstan', 'Commonwealth of Independent States', 'Som', 'KGS');
791INSERT INTO `sys_countries` VALUES('KH', 'KHM', 116, 'Cambodia', 'Southeast Asia', 'Riel', 'KHR');
792INSERT INTO `sys_countries` VALUES('KI', 'KIR', 296, 'Kiribati', 'Oceania', 'Australian dollar', 'AUD');
793INSERT INTO `sys_countries` VALUES('KM', 'COM', 174, 'Comoros', 'Africa', 'Comoro Franc', 'KMF');
794INSERT INTO `sys_countries` VALUES('KN', 'KNA', 659, 'Saint Kitts and Nevis', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
795INSERT INTO `sys_countries` VALUES('KP', 'PRK', 408, 'Korea, North', 'Asia', 'North Korean Won', 'KPW');
796INSERT INTO `sys_countries` VALUES('KR', 'KOR', 410, 'Korea, South', 'Asia', 'Won', 'KRW');
797INSERT INTO `sys_countries` VALUES('KW', 'KWT', 414, 'Kuwait', 'Middle East', 'Kuwaiti Dinar', 'KWD');
798INSERT INTO `sys_countries` VALUES('KY', 'CYM', 136, 'Cayman Islands', 'Central America and the Caribbean', 'Cayman Islands Dollar', 'KYD');
799INSERT INTO `sys_countries` VALUES('KZ', 'KAZ', 398, 'Kazakhstan', 'Commonwealth of Independent States', 'Tenge', 'KZT');
800INSERT INTO `sys_countries` VALUES('LA', 'LAO', 418, 'Laos', 'Southeast Asia', 'Kip', 'LAK');
801INSERT INTO `sys_countries` VALUES('LB', 'LBN', 422, 'Lebanon', 'Middle East', 'Lebanese Pound', 'LBP');
802INSERT INTO `sys_countries` VALUES('LC', 'LCA', 662, 'Saint Lucia', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
803INSERT INTO `sys_countries` VALUES('LI', 'LIE', 438, 'Liechtenstein', 'Europe', 'Swiss Franc', 'CHF');
804INSERT INTO `sys_countries` VALUES('LK', 'LKA', 144, 'Sri Lanka', 'Asia', 'Sri Lanka Rupee', 'LKR');
805INSERT INTO `sys_countries` VALUES('LR', 'LBR', 430, 'Liberia', 'Africa', 'Liberian Dollar', 'LRD');
806INSERT INTO `sys_countries` VALUES('LS', 'LSO', 426, 'Lesotho', 'Africa', 'Loti', 'LSL');
807INSERT INTO `sys_countries` VALUES('LT', 'LTU', 440, 'Lithuania', 'Europe', 'Lithuanian Litas', 'LTL');
808INSERT INTO `sys_countries` VALUES('LU', 'LUX', 442, 'Luxembourg', 'Europe', 'Euro', 'EUR');
809INSERT INTO `sys_countries` VALUES('LV', 'LVA', 428, 'Latvia', 'Europe', 'Latvian Lats', 'LVL');
810INSERT INTO `sys_countries` VALUES('LY', 'LBY', 434, 'Libya', 'Africa', 'Libyan Dinar', 'LYD');
811INSERT INTO `sys_countries` VALUES('MA', 'MAR', 504, 'Morocco', 'Africa', 'Moroccan Dirham', 'MAD');
812INSERT INTO `sys_countries` VALUES('MC', 'MCO', 492, 'Monaco', 'Europe', 'Euro', 'EUR');
813INSERT INTO `sys_countries` VALUES('MD', 'MDA', 498, 'Moldova', 'Commonwealth of Independent States', 'Moldovan Leu', 'MDL');
814INSERT INTO `sys_countries` VALUES('ME', 'MNE', 499, 'Montenegro', 'Europe', 'Euro', 'EUR');
815INSERT INTO `sys_countries` VALUES('MF', 'MAF', 663, 'Saint Martin (French part)', 'Central America and the Caribbean', 'Euro', 'EUR');
816INSERT INTO `sys_countries` VALUES('MG', 'MDG', 450, 'Madagascar', 'Africa', 'Malagasy Franc', 'MGF');
817INSERT INTO `sys_countries` VALUES('MH', 'MHL', 584, 'Marshall Islands', 'Oceania', 'US dollar', 'USD');
818INSERT INTO `sys_countries` VALUES('MK', 'MKD', 807, 'Macedonia, The Former Yugoslav Republic of', 'Europe', 'Denar', 'MKD');
819INSERT INTO `sys_countries` VALUES('ML', 'MLI', 466, 'Mali', 'Africa', 'CFA Franc BCEAO', 'XOF');
820INSERT INTO `sys_countries` VALUES('MM', 'MMR', 104, 'Myanmar', 'Southeast Asia', 'kyat', 'MMK');
821INSERT INTO `sys_countries` VALUES('MN', 'MNG', 496, 'Mongolia', 'Asia', 'Tugrik', 'MNT');
822INSERT INTO `sys_countries` VALUES('MO', 'MAC', 446, 'Macao', 'Southeast Asia', 'Pataca', 'MOP');
823INSERT INTO `sys_countries` VALUES('MP', 'MNP', 580, 'Northern Mariana Islands', 'Oceania', 'US Dollar', 'USD');
824INSERT INTO `sys_countries` VALUES('MQ', 'MTQ', 474, 'Martinique', 'Central America and the Caribbean', 'Euro', 'EUR');
825INSERT INTO `sys_countries` VALUES('MR', 'MRT', 478, 'Mauritania', 'Africa', 'Ouguiya', 'MRO');
826INSERT INTO `sys_countries` VALUES('MS', 'MSR', 500, 'Montserrat', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
827INSERT INTO `sys_countries` VALUES('MT', 'MLT', 470, 'Malta', 'Europe', 'Maltese Lira', 'MTL');
828INSERT INTO `sys_countries` VALUES('MU', 'MUS', 480, 'Mauritius', 'World', 'Mauritius Rupee', 'MUR');
829INSERT INTO `sys_countries` VALUES('MV', 'MDV', 462, 'Maldives', 'Asia', 'Rufiyaa', 'MVR');
830INSERT INTO `sys_countries` VALUES('MW', 'MWI', 454, 'Malawi', 'Africa', 'Kwacha', 'MWK');
831INSERT INTO `sys_countries` VALUES('MX', 'MEX', 484, 'Mexico', 'North America', 'Mexican Peso', 'MXN');
832INSERT INTO `sys_countries` VALUES('MY', 'MYS', 458, 'Malaysia', 'Southeast Asia', 'Malaysian Ringgit', 'MYR');
833INSERT INTO `sys_countries` VALUES('MZ', 'MOZ', 508, 'Mozambique', 'Africa', 'Metical', 'MZM');
834INSERT INTO `sys_countries` VALUES('NA', 'NAM', 516, 'Namibia', 'Africa', 'Namibian Dollar', 'NAD');
835INSERT INTO `sys_countries` VALUES('NC', 'NCL', 540, 'New Caledonia', 'Oceania', 'CFP Franc', 'XPF');
836INSERT INTO `sys_countries` VALUES('NE', 'NER', 562, 'Niger', 'Africa', 'CFA Franc BCEAO', 'XOF');
837INSERT INTO `sys_countries` VALUES('NF', 'NFK', 574, 'Norfolk Island', 'Oceania', 'Australian Dollar', 'AUD');
838INSERT INTO `sys_countries` VALUES('NG', 'NGA', 566, 'Nigeria', 'Africa', 'Naira', 'NGN');
839INSERT INTO `sys_countries` VALUES('NI', 'NIC', 558, 'Nicaragua', 'Central America and the Caribbean', 'Cordoba Oro', 'NIO');
840INSERT INTO `sys_countries` VALUES('NL', 'NLD', 528, 'Netherlands', 'Europe', 'Euro', 'EUR');
841INSERT INTO `sys_countries` VALUES('NO', 'NOR', 578, 'Norway', 'Europe', 'Norwegian Krone', 'NOK');
842INSERT INTO `sys_countries` VALUES('NP', 'NPL', 524, 'Nepal', 'Asia', 'Nepalese Rupee', 'NPR');
843INSERT INTO `sys_countries` VALUES('NR', 'NRU', 520, 'Nauru', 'Oceania', 'Australian Dollar', 'AUD');
844INSERT INTO `sys_countries` VALUES('NU', 'NIU', 570, 'Niue', 'Oceania', 'New Zealand Dollar', 'NZD');
845INSERT INTO `sys_countries` VALUES('NZ', 'NZL', 554, 'New Zealand', 'Oceania', 'New Zealand Dollar', 'NZD');
846INSERT INTO `sys_countries` VALUES('OM', 'OMN', 512, 'Oman', 'Middle East', 'Rial Omani', 'OMR');
847INSERT INTO `sys_countries` VALUES('PA', 'PAN', 591, 'Panama', 'Central America and the Caribbean', 'balboa', 'PAB');
848INSERT INTO `sys_countries` VALUES('PE', 'PER', 604, 'Peru', 'South America', 'Nuevo Sol', 'PEN');
849INSERT INTO `sys_countries` VALUES('PF', 'PYF', 258, 'French Polynesia', 'Oceania', 'CFP Franc', 'XPF');
850INSERT INTO `sys_countries` VALUES('PG', 'PNG', 598, 'Papua New Guinea', 'Oceania', 'Kina', 'PGK');
851INSERT INTO `sys_countries` VALUES('PH', 'PHL', 608, 'Philippines', 'Southeast Asia', 'Philippine Peso', 'PHP');
852INSERT INTO `sys_countries` VALUES('PK', 'PAK', 586, 'Pakistan', 'Asia', 'Pakistan Rupee', 'PKR');
853INSERT INTO `sys_countries` VALUES('PL', 'POL', 616, 'Poland', 'Europe', 'Zloty', 'PLN');
854INSERT INTO `sys_countries` VALUES('PM', 'SPM', 666, 'Saint Pierre and Miquelon', 'North America', 'Euro', 'EUR');
855INSERT INTO `sys_countries` VALUES('PN', 'PCN', 612, 'Pitcairn Islands', 'Oceania', 'New Zealand Dollar', 'NZD');
856INSERT INTO `sys_countries` VALUES('PR', 'PRI', 630, 'Puerto Rico', 'Central America and the Caribbean', 'US dollar', 'USD');
857INSERT INTO `sys_countries` VALUES('PS', 'PSE', 275, 'Palestinian Territory, Occupied', NULL, NULL, NULL);
858INSERT INTO `sys_countries` VALUES('PT', 'PRT', 620, 'Portugal', 'Europe', 'Euro', 'EUR');
859INSERT INTO `sys_countries` VALUES('PW', 'PLW', 585, 'Palau', 'Oceania', 'US dollar', 'USD');
860INSERT INTO `sys_countries` VALUES('PY', 'PRY', 600, 'Paraguay', 'South America', 'Guarani', 'PYG');
861INSERT INTO `sys_countries` VALUES('QA', 'QAT', 634, 'Qatar', 'Middle East', 'Qatari Rial', 'QAR');
862INSERT INTO `sys_countries` VALUES('RE', 'REU', 638, 'Reunion', 'World', 'Euro', 'EUR');
863INSERT INTO `sys_countries` VALUES('RO', 'ROU', 642, 'Romania', 'Europe', 'Leu', 'ROL');
864INSERT INTO `sys_countries` VALUES('RS', 'SRB', 688, 'Serbia', 'Europe', 'Serbian Dinar', 'RSD');
865INSERT INTO `sys_countries` VALUES('RU', 'RUS', 643, 'Russia', 'Asia', 'Russian Ruble', 'RUB');
866INSERT INTO `sys_countries` VALUES('RW', 'RWA', 646, 'Rwanda', 'Africa', 'Rwanda Franc', 'RWF');
867INSERT INTO `sys_countries` VALUES('SA', 'SAU', 682, 'Saudi Arabia', 'Middle East', 'Saudi Riyal', 'SAR');
868INSERT INTO `sys_countries` VALUES('SB', 'SLB', 90, 'Solomon Islands', 'Oceania', 'Solomon Islands Dollar', 'SBD');
869INSERT INTO `sys_countries` VALUES('SC', 'SYC', 690, 'Seychelles', 'Africa', 'Seychelles Rupee', 'SCR');
870INSERT INTO `sys_countries` VALUES('SD', 'SDN', 736, 'Sudan', 'Africa', 'Sudanese Dinar', 'SDD');
871INSERT INTO `sys_countries` VALUES('SE', 'SWE', 752, 'Sweden', 'Europe', 'Swedish Krona', 'SEK');
872INSERT INTO `sys_countries` VALUES('SG', 'SGP', 702, 'Singapore', 'Southeast Asia', 'Singapore Dollar', 'SGD');
873INSERT INTO `sys_countries` VALUES('SH', 'SHN', 654, 'Saint Helena', 'Africa', 'Saint Helenian Pound', 'SHP');
874INSERT INTO `sys_countries` VALUES('SI', 'SVN', 705, 'Slovenia', 'Europe', 'Tolar', 'SIT');
875INSERT INTO `sys_countries` VALUES('SJ', 'SJM', 744, 'Svalbard', 'Arctic Region', 'Norwegian Krone', 'NOK');
876INSERT INTO `sys_countries` VALUES('SK', 'SVK', 703, 'Slovakia', 'Europe', 'Slovak Koruna', 'SKK');
877INSERT INTO `sys_countries` VALUES('SL', 'SLE', 694, 'Sierra Leone', 'Africa', 'Leone', 'SLL');
878INSERT INTO `sys_countries` VALUES('SM', 'SMR', 674, 'San Marino', 'Europe', 'Euro', 'EUR');
879INSERT INTO `sys_countries` VALUES('SN', 'SEN', 686, 'Senegal', 'Africa', 'CFA Franc BCEAO', 'XOF');
880INSERT INTO `sys_countries` VALUES('SO', 'SOM', 706, 'Somalia', 'Africa', 'Somali Shilling', 'SOS');
881INSERT INTO `sys_countries` VALUES('SR', 'SUR', 740, 'Suriname', 'South America', 'Suriname Guilder', 'SRG');
882INSERT INTO `sys_countries` VALUES('ST', 'STP', 678, 'Sao Tome and Principe', 'Africa', 'Dobra', 'STD');
883INSERT INTO `sys_countries` VALUES('SV', 'SLV', 222, 'El Salvador', 'Central America and the Caribbean', 'El Salvador Colon', 'SVC');
884INSERT INTO `sys_countries` VALUES('SY', 'SYR', 760, 'Syria', 'Middle East', 'Syrian Pound', 'SYP');
885INSERT INTO `sys_countries` VALUES('SZ', 'SWZ', 748, 'Swaziland', 'Africa', 'Lilangeni', 'SZL');
886INSERT INTO `sys_countries` VALUES('TC', 'TCA', 796, 'Turks and Caicos Islands', 'Central America and the Caribbean', 'US Dollar', 'USD');
887INSERT INTO `sys_countries` VALUES('TD', 'TCD', 148, 'Chad', 'Africa', 'CFA Franc BEAC', 'XAF');
888INSERT INTO `sys_countries` VALUES('TF', 'ATF', 260, 'French Southern and Antarctic Lands', 'Antarctic Region', 'Euro', 'EUR');
889INSERT INTO `sys_countries` VALUES('TG', 'TGO', 768, 'Togo', 'Africa', 'CFA Franc BCEAO', 'XOF');
890INSERT INTO `sys_countries` VALUES('TH', 'THA', 764, 'Thailand', 'Southeast Asia', 'Baht', 'THB');
891INSERT INTO `sys_countries` VALUES('TJ', 'TJK', 762, 'Tajikistan', 'Commonwealth of Independent States', 'Somoni', 'TJS');
892INSERT INTO `sys_countries` VALUES('TK', 'TKL', 772, 'Tokelau', 'Oceania', 'New Zealand Dollar', 'NZD');
893INSERT INTO `sys_countries` VALUES('TL', 'TLS', 626, 'East Timor', NULL, 'Timor Escudo', 'TPE');
894INSERT INTO `sys_countries` VALUES('TM', 'TKM', 795, 'Turkmenistan', 'Commonwealth of Independent States', 'Manat', 'TMM');
895INSERT INTO `sys_countries` VALUES('TN', 'TUN', 788, 'Tunisia', 'Africa', 'Tunisian Dinar', 'TND');
896INSERT INTO `sys_countries` VALUES('TO', 'TON', 776, 'Tonga', 'Oceania', 'Pa''anga', 'TOP');
897INSERT INTO `sys_countries` VALUES('TR', 'TUR', 792, 'Turkey', 'Middle East', 'Turkish Lira', 'TRL');
898INSERT INTO `sys_countries` VALUES('TT', 'TTO', 780, 'Trinidad and Tobago', 'Central America and the Caribbean', 'Trinidad and Tobago Dollar', 'TTD');
899INSERT INTO `sys_countries` VALUES('TV', 'TUV', 798, 'Tuvalu', 'Oceania', 'Australian Dollar', 'AUD');
900INSERT INTO `sys_countries` VALUES('TW', 'TWN', 158, 'Taiwan', 'Southeast Asia', 'New Taiwan Dollar', 'TWD');
901INSERT INTO `sys_countries` VALUES('TZ', 'TZA', 834, 'Tanzania', 'Africa', 'Tanzanian Shilling', 'TZS');
902INSERT INTO `sys_countries` VALUES('UA', 'UKR', 804, 'Ukraine', 'Commonwealth of Independent States', 'Hryvnia', 'UAH');
903INSERT INTO `sys_countries` VALUES('UG', 'UGA', 800, 'Uganda', 'Africa', 'Uganda Shilling', 'UGX');
904INSERT INTO `sys_countries` VALUES('UM', 'UMI', 581, 'United States Minor Outlying Islands', NULL, 'US Dollar', 'USD');
905INSERT INTO `sys_countries` VALUES('US', 'USA', 840, 'United States', 'North America', 'US Dollar', 'USD');
906INSERT INTO `sys_countries` VALUES('UY', 'URY', 858, 'Uruguay', 'South America', 'Peso Uruguayo', 'UYU');
907INSERT INTO `sys_countries` VALUES('UZ', 'UZB', 860, 'Uzbekistan', 'Commonwealth of Independent States', 'Uzbekistan Sum', 'UZS');
908INSERT INTO `sys_countries` VALUES('VA', 'VAT', 336, 'Holy See (Vatican City)', 'Europe', 'Euro', 'EUR');
909INSERT INTO `sys_countries` VALUES('VC', 'VCT', 670, 'Saint Vincent and the Grenadines', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
910INSERT INTO `sys_countries` VALUES('VE', 'VEN', 862, 'Venezuela', 'South America, Central America and the Caribbean', 'Bolivar', 'VEB');
911INSERT INTO `sys_countries` VALUES('VG', 'VGB', 92, 'British Virgin Islands', 'Central America and the Caribbean', 'US dollar', 'USD');
912INSERT INTO `sys_countries` VALUES('VI', 'VIR', 850, 'Virgin Islands', 'Central America and the Caribbean', 'US Dollar', 'USD');
913INSERT INTO `sys_countries` VALUES('VN', 'VNM', 704, 'Vietnam', 'Southeast Asia', 'Dong', 'VND');
914INSERT INTO `sys_countries` VALUES('VU', 'VUT', 548, 'Vanuatu', 'Oceania', 'Vatu', 'VUV');
915INSERT INTO `sys_countries` VALUES('WF', 'WLF', 876, 'Wallis and Futuna', 'Oceania', 'CFP Franc', 'XPF');
916INSERT INTO `sys_countries` VALUES('WS', 'WSM', 882, 'Samoa', 'Oceania', 'Tala', 'WST');
917INSERT INTO `sys_countries` VALUES('YE', 'YEM', 887, 'Yemen', 'Middle East', 'Yemeni Rial', 'YER');
918INSERT INTO `sys_countries` VALUES('YT', 'MYT', 175, 'Mayotte', 'Africa', 'Euro', 'EUR');
919INSERT INTO `sys_countries` VALUES('ZA', 'ZAF', 710, 'South Africa', 'Africa', 'Rand', 'ZAR');
920INSERT INTO `sys_countries` VALUES('ZM', 'ZWB', 894, 'Zambia', 'Africa', 'Kwacha', 'ZMK');
921INSERT INTO `sys_countries` VALUES('ZW', 'ZWE', 716, 'Zimbabwe', 'Africa', 'Zimbabwe Dollar', 'ZWD');
922
923
924-- --------------------------------------------------------
925
926
927CREATE TABLE IF NOT EXISTS `sys_email_templates` (
928  `ID` int(11) unsigned NOT NULL auto_increment,
929  `Name` varchar(255) NOT NULL,
930  `Subject` varchar(255) NOT NULL,
931  `Body` text NOT NULL,
932  `Desc` varchar(255) NOT NULL,
933  `LangID` tinyint(4) unsigned NOT NULL default '1',
934  PRIMARY KEY  (`ID`),
935  KEY `Name` (`Name`,`LangID`)
936) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
937
938INSERT INTO `sys_email_templates` (`Name`, `Subject`, `Body`, `Desc`, `LangID`) VALUES
939('t_Activation', 'Your Profile Is Now Active', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Your profile was reviewed and activated!</p>\r\n\r\n<p>Your Account: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<p>Member ID: <b><recipientID></b></p>\r\n\r\n<p>Your E-mail: <span style="color:#FF6633"><Email></span></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Profile activation notification.', 0),
940('t_AdminEmail', '<SiteName> Admin: <MessageSubject>', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><a href="<Domain>"><SiteName></a> Admin sent you a message:</p>\r\n\r\n<hr>\r\n<p style="color:#3B5C8E"><MessageText></p>\r\n<hr>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Message from the site Admin.', 0),
941('t_AdminStats', 'Content Pending Admin Review', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><MessageText></p>\r\n\r\n<p>Go to <a href="<ViewLink>">administration panel</a> to review pending content.</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Message to admin about content pending review', 0),
942('t_Compose', 'You''ve Got A New Message', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>You have received a message from <a href="<ProfileUrl>"><ProfileReference></a>!</p>\r\n\r\n<p>Go to your account to read and reply: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'New message notification without message text', 0),
943('t_Confirmation', 'Email Confirmation Request', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Thank you for registering at <SiteName>!</p>\r\n\r\n<p>Click to confirm your email:\r\n<a href="<ConfirmationLink>"><ConfirmationLink></a></p>\r\n\r\n<p>CONFIRMATION CODE: <ConfCode></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Email confirmation message.', 0),
944('t_CupidMail', 'Your Matches', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>Check out some <SiteName> members that may be a good match with you:</p>\r\n\r\n<p><a href="<MatchProfileLink>"><MatchProfileLink></a></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Matching profiles notification.', 0),
945('t_Forgot', 'Your Account Password', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Your member ID: <b><recipientID></b></p>\r\n\r\n<p>Your password: <b><Password></b></p>\r\n\r\n<p>You may login here: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Password retrieval', 0),
946('t_FreeEmail', 'Member Email Address', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><profileNickName>''s contact info:</p> \r\n\r\n<p><profileContactInfo></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Requested Member Email Address', 0),
947('t_MemExpiration', 'Your Membership Is About To Expire', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>Your <SiteName> <MembershipName> membership will expire in <ExpireDays> days.</p>\r\n\r\n<p>NOTE: -1 means it has already expired</p>\r\n\r\n\r\n<p><a href="<Domain>modules/?r=membership/index/">Renew Membership</a></p>\r\n<bx_include_auto:_email_footer.html />', 'Membership expiration notice', 0),
948('t_MemChanged', 'Your Membership Changed', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>Your membership level was changed to: <b><a href="<Domain>modules/?r=membership/index/"><MembershipLevel></a></b></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Membership change', 0),
949('t_Message', 'You''ve Got A New Message', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><a href="<ProfileUrl>"><ProfileReference></a> sent you a message: </p>\r\n\r\n<hr>\r\n<p><MessageText></p>\r\n<hr>\r\n\r\n<p>Go to your account to reply: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'New message notification with message text', 0),
950('t_UserJoined', 'New Member Joined', '<bx_include_auto:_email_header.html />\r\n\r\n<p>New user: <RealName></p> \r\n<p>Email: <Email></p> \r\n\r\n<bx_include_auto:_email_footer.html />', 'Admin notification about new member', 0),
951('t_UserConfirmed', 'User Confirmed Email', '<bx_include_auto:_email_header.html />\r\n\r\n<p>User: <RealName></p> \r\n<p>Email: <Email></p> \r\n\r\n<bx_include_auto:_email_footer.html />', 'Admin notification - user confirmed email', 0),
952('t_SpamReport', 'Profile Spam Report', '<bx_include_auto:_email_header.html />\r\n\r\n<p><a href="<Domain>profile.php?ID=<reporterID>"><reporterNick></a> reported Profile SPAM:  <a href="<Domain>profile.php?ID=<spamerID>"><b><spamerNick></b></a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Profile Spam Report', 0),
953('t_TellFriend', 'Check This Out!', '<bx_include_auto:_email_header.html />\r\n\r\n\r\n<p>I thought you''d be interested: <a href="<Link>"><Link></a><br />\r\n</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Friend Invitation', 0),
954('t_TellFriendProfile', 'Look At This Profile', '<bx_include_auto:_email_header.html />\r\n\r\n\r\n\r\n<p>Check out this profile: <a href="<Link>"><Link></a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Email profile to a friend', 0),
955('t_VKiss', 'Greeting notification', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><ProfileReference> sent you a greeting!</p>\r\n\r\n<p><ProfileReference> may be interested in you or maybe just wants to say Hello!\r\n</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Greeting notification ', 0),
956('t_VKiss_visitor', 'Greeting notification', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Our site visitor sent you a greeting!</p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Greeting from visitor notification', 0),
957('t_MessageCopy', 'Copy Of Your Message : <your subject here>', '<bx_include_auto:_email_header.html />\r\n\r\n<p>You wrote:</p>\r\n<hr>\r\n<p><your message here></p>\r\n<hr>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Message copy', 0),
958('t_Subscription', 'Your Subscription', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>You subscribed to <a href="<ViewLink>"><Subscription></a></p>\r\n\r\n<p>You may cancel the subscription here: <a href="<SysUnsubscribeLink>"><SysUnsubscribeLink></a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Subscription confirmation', 0),
959('t_sbsProfileComments', 'New Profile Comments', '<bx_include_auto:_email_header.html />\r\n\r\n <p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Profile you subscribed to got <a href="<ViewLink>">new comments</a>.</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'New comments to profile subscription', 0),
960('t_sbsProfileEdit', 'Subscription: Profile Edited', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><a href="<ViewLink>">Profile you subscribed to</a> has been updated.</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Profile info subscription.', 0),
961('t_FriendRequest', 'Friendship Request', '<bx_include_auto:_email_header.html />\r\n\r\n    <p><b>Dear <Recipient></b>,</p>\r\n   \r\n    <p><a href="<SenderLink>"><Sender></a> wants to be friends with you. <a href="<RequestLink>">Respond</a>.</p>\r\n    <br /> \r\n    <bx_include_auto:_email_footer.html />', 'Friendship Request', 0),
962('t_FriendRequestAccepted', 'Friendship Request Accepted', '<bx_include_auto:_email_header.html />\r\n\r\n    <p><b>Dear <Recipient></b>,</p>\r\n    \r\n    <p><a href="<SenderLink>"><Sender></a> accepted your friendship request.</p>\r\n    <br /> \r\n    <bx_include_auto:_email_footer.html />', 'Friendship Request Accepted', 0),
963('t_SpamReportAuto', '<SiteName> Automatic Spam Report', '<bx_include_auto:_email_header.html />\r\n\r\n\r\n<b>Profile:</b> <a href="<SpammerUrl>"><SpammerNickName></a><br />\r\n\r\n<b>Page:</b> <Page><br />\r\n\r\n<b>GET variables:</b>\r\n<pre>\r\n<Get>\r\n</pre>\r\n\r\n<b>Spam Content:</b>\r\n<pre>\r\n<SpamContent>\r\n</pre>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Automatic spam report', 0);
964
965
966-- --------------------------------------------------------
967
968--
969-- Table structure for table `sys_menu_member`
970--
971
972CREATE TABLE `sys_menu_member` (
973  `ID` int(10) unsigned NOT NULL auto_increment,
974  `Caption` varchar(100) NOT NULL,
975  `Name` varchar(200) NOT NULL,
976  `Icon` varchar(100) NOT NULL,
977  `Link` varchar(250) NOT NULL,
978  `Script` varchar(250) NOT NULL,
979  `Eval` text NOT NULL,
980  `PopupMenu` text NOT NULL,
981  `Order` int(5) NOT NULL,
982  `Active` enum('1','0') NOT NULL,
983  `Movable` tinyint(4) NOT NULL default '3',
984  `Clonable` tinyint(1) NOT NULL default '1',
985  `Editable` tinyint(1) NOT NULL default '1',
986  `Deletable` tinyint(1) NOT NULL default '1',
987  `Target` varchar(200) NOT NULL,
988  `Position` enum('top','bottom','top_extra') NOT NULL default 'top',
989  `Type` enum('link','system','linked_item') NOT NULL,
990  `Parent` int(11) NOT NULL,
991  `Bubble` text NOT NULL,
992  `Description` varchar(50) NOT NULL,
993  PRIMARY KEY  (`ID`),
994  KEY `Parent` (`Parent`)
995) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
996
997--
998-- Dumping data for table `sys_menu_member`
999--
1000INSERT INTO `sys_menu_member` (`ID`, `Caption`, `Name`, `Icon`, `Link`, `Script`, `Eval`, `PopupMenu`, `Order`, `Active`, `Movable`, `Clonable`, `Editable`, `Deletable`, `Target`, `Position`, `Type`, `Parent`, `Bubble`, `Description`) VALUES 
1001(6, '{evalResult}', 'MemberBlock', '', '{ProfileLink}', '', 'return ''<b>'' . getNickName({ID}) . ''</b>'';', 'bx_import(''BxDolUserStatusView'');\r\n$oStatusView = new BxDolUserStatusView();\r\nreturn $oStatusView->getMemberMenuStatuses();', 1, '1', 3, 1, 0, 0, '', 'top', 'link', 0, '', '_Presence'),
1002(4, '_Settings', 'Settings', 'cog', 'pedit.php?ID={ID}', '', '', '', 2, 1, 3, 1, 0, 0, '', 'top', 'link', 0, '', '_Edit_profile_and_settings'),
1003(7, '_Status Message', 'Status Message', 'edit', 'javascript:void(0);', '', '', 'bx_import( ''BxDolUserStatusView'' );\r\n$oStatusView = new BxDolUserStatusView();\r\nreturn $oStatusView -> getStatusField({ID});', 3, 1, 3, 1, 1, 1, '', 'top', 'link', 0, '', '_Status Message'),
1004(8, '_sys_add_content', 'AddContent', 'plus', 'javascript:void(0);', '', '', 'return '''';', 4, '1', 3, 0, 0, 0, '', 'top', 'link', 0, '$isSkipItem = $aReplaced[$sPosition][$iKey][''linked_items''] ? false : true;\r\n$aRetEval = false;', '_sys_add_content'),
1005
1006(2, '_Mail', 'Mail', 'envelope', 'mail.php?mode=inbox', '', '', 'bx_import( ''BxTemplMailBox'' );\r\n// return list of messages ;\r\nreturn BxTemplMailBox::get_member_menu_messages_list({ID});', 1, 1, 3, 1, 0, 0, '', 'top_extra', 'link', 0, 'bx_import( ''BxTemplMailBox'' );\r\n// return list of new messages ;\r\n$aRetEval= BxTemplMailBox::get_member_menu_bubble_new_messages({ID}, {iOldCount});', '_Mail'),
1007(3, '_Friends', 'Friends', 'user', 'viewFriends.php?iUser={ID}', '', '', 'bx_import( ''BxDolFriendsPageView'' );\r\nreturn BxDolFriendsPageView::get_member_menu_friends_list({ID});', 2, 1, 3, 1, 0, 0, '', 'top_extra', 'link', 0, 'bx_import( ''BxDolFriendsPageView'' );\r\n$aRetEval = BxDolFriendsPageView::get_member_menu_bubble_friend_requests( {ID}, {iOldCount});', '_Friends'),
1008(10, '_Admin Panel', 'Admin Panel', 'wrench', '{evalResult}', '', 'return isAdmin() ? $GLOBALS[''site''][''url_admin''] : '''';', '', 6, 1, 3, 1, 1, 1, '', 'top_extra', 'link', 0, '', '_Go admin panel');
1009
1010
1011--
1012-- Table structure for table `sys_friend_list`
1013--
1014
1015CREATE TABLE `sys_friend_list` (
1016  `ID` int(10) unsigned NOT NULL default '0',
1017  `Profile` int(10) unsigned NOT NULL default '0',
1018  `Check` tinyint(2) NOT NULL default '0',
1019  `When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1020  UNIQUE KEY `FriendPair` (`ID`,`Profile`),
1021  KEY `Profile` (`Profile`)
1022) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1023
1024
1025-- --------------------------------------------------------
1026
1027
1028CREATE TABLE `sys_options` (
1029  `Name` varchar(64) NOT NULL default '',
1030  `VALUE` mediumtext NOT NULL,
1031  `kateg` int(6) unsigned NOT NULL default '0',
1032  `desc` varchar(255) NOT NULL default '',
1033  `Type` enum('digit','text','checkbox','select','select_multiple','file','list') NOT NULL default 'digit',
1034  `check` text NOT NULL,
1035  `err_text` varchar(255) NOT NULL default '',
1036  `order_in_kateg` float default NULL,
1037  `AvailableValues` text NOT NULL default '',
1038  PRIMARY KEY  (`Name`),
1039  KEY `kateg` (`kateg`)
1040) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1041
1042
1043-- CAT: Profiles
1044SET @iCatProfiles = 1;
1045INSERT INTO `sys_options` VALUES
1046('enable_global_couple', '', @iCatProfiles, 'Enable couple profiles', 'checkbox', '', '', 10, ''),
1047('votes', 'on', @iCatProfiles, 'Enable profile rating', 'checkbox', '', '', 20, ''),
1048('zodiac', '', @iCatProfiles, 'Enable zodiac signs', 'checkbox', '', '', 30, ''),
1049('anon_mode', '', @iCatProfiles, 'Enable anonymous mode', 'checkbox', '', '', 40, ''),
1050('reg_by_inv_only', '', @iCatProfiles, 'Enable registration by invitation only', 'checkbox', '', '', 50, ''),
1051('enable_cmts_profile_delete', '', @iCatProfiles, 'Allow profile comments deletion by profile owner', 'checkbox', '', '', 60, ''),
1052('member_online_time', '1', @iCatProfiles, 'Online status timeframe (minutes)', 'digit', '', '', 70, ''),
1053('search_start_age', '18', @iCatProfiles, 'Lowest age possible for site members', 'digit', 'return setSearchStartAge((int)$arg0);', '', 80, ''),
1054('search_end_age', '75', @iCatProfiles, 'Highest age possible for site members', 'digit', 'return setSearchEndAge((int)$arg0);', '', 90, ''),
1055('friends_per_page', '14', @iCatProfiles, 'Number of friends displayed per page in profile', 'digit', '', '', 100, ''),
1056('featured_num', '8', @iCatProfiles, 'Number of Featured Members per page', 'digit', '', '', 110, ''),
1057('top_members_max_num', '8', @iCatProfiles, 'Number of Top Members per page', 'digit', '', '', 120, ''),
1058('sys_member_info_name', 'sys_username', @iCatProfiles, 'Member display-name', 'select', '', '', 130, 'PHP:bx_import(\'BxDolMemberInfoQuery\'); return BxDolMemberInfoQuery::getMemberInfoKeysByType(\'name\');'),
1059('sys_member_info_info', 'sys_headline', @iCatProfiles, 'Member brief info', 'select', '', '', 140, 'PHP:bx_import(\'BxDolMemberInfoQuery\'); return BxDolMemberInfoQuery::getMemberInfoKeysByType(\'info\');'),
1060('sys_member_info_thumb', 'sys_avatar', @iCatProfiles, 'Member thumb', 'select', '', '', 150, 'PHP:bx_import(\'BxDolMemberInfoQuery\'); return BxDolMemberInfoQuery::getMemberInfoKeysByType(\'thumb\');'),
1061('sys_member_info_thumb_icon', 'sys_avatar_icon', @iCatProfiles, 'Member thumb icon', 'select', '', '', 160, 'PHP:bx_import(\'BxDolMemberInfoQuery\'); return BxDolMemberInfoQuery::getMemberInfoKeysByType(\'thumb_icon\');');
1062
1063-- CAT: General
1064SET @iCatGeneral = 3;
1065INSERT INTO `sys_options` VALUES
1066('MetaDescription', '', @iCatGeneral, 'Homepage meta-description', 'text', '', '', 10, ''),
1067('MetaKeyWords', '', @iCatGeneral, 'Homepage meta-keywords', 'text', '', '', 20, ''),
1068
1069('enable_tiny_in_comments', '', @iCatGeneral, 'Enable WYSIWYG editor in comments', 'checkbox', '', '', 30, ''),
1070
1071('sys_make_album_cover_last', 'on', @iCatGeneral, 'Enable last-added item as album cover', 'checkbox', '', '', 70, ''),
1072('sys_album_default_name', 'Hidden', @iCatGeneral, 'Default album name', 'digit', '', '', 80, ''),
1073
1074('news_enable', 'on', @iCatGeneral, 'Enable BoonEx News in Admin', 'checkbox', '', '', 90, ''),
1075('feeds_enable', 'on', @iCatGeneral, 'Enable BoonEx Market Feeds in Admin', 'checkbox', '', '', 100, ''),
1076
1077('enable_contact_form', 'on', @iCatGeneral, 'Enable contact form', 'checkbox', '', '', 110, ''),
1078
1079('default_country', 'US', @iCatGeneral, 'Default country', 'digit', '', '', 120, ''),
1080
1081('boonexAffID', '', @iCatGeneral, 'BoonEx affiliate ID', 'digit', '', '', 140, ''),
1082('enable_gd', 'on', @iCatGeneral, 'Enable GD library for image processing', 'checkbox', '', '', 150, ''),
1083('useLikeOperator', 'on', @iCatGeneral, 'Disable full-text search', 'checkbox', '', '', 160, '');
1084
1085
1086-- CAT: Massmailer
1087SET @iCatMassmailer = 4;
1088INSERT INTO `sys_options` VALUES
1089('msgs_per_start', '20', @iCatMassmailer, 'Number of emails to send from queue per run, it happens every 5m-1h', 'digit', '', '', 10, '');
1090
1091
1092-- CAT: Memberships
1093SET @iCatMemberships = 5;
1094INSERT INTO `sys_options` VALUES
1095('expire_notify_once', 'on', @iCatMemberships, 'Notify members about membership expiration only once (every day otherwise)', 'checkbox', '', '', 10, ''),
1096('expire_notification_days', '1', @iCatMemberships, 'Number of days before membership expiration to notify members (-1 = after expiration)', 'digit', '', '', 20, ''),
1097('enable_promotion_membership', '', @iCatMemberships, 'Enable promotional membership', 'checkbox', '', '', 30, ''),
1098('promotion_membership_days', '7', @iCatMemberships, 'Number of days for promotional membership', 'digit', '', '', 40, '');
1099
1100
1101-- CAT: Moderation
1102SET @iCatModeration = 6;
1103INSERT INTO `sys_options` VALUES
1104('autoApproval_ifJoin', '', @iCatModeration, 'Auto-activate profiles after joining', 'checkbox', '', '', 10, ''),
1105('autoApproval_ifProfile', 'on', @iCatModeration, 'Preserve profile status after profile info editing', 'checkbox', '', '', 20, ''),
1106('autoApproval_ifNoConfEmail', '', @iCatModeration, 'Auto-confirm profile without confirmation email', 'checkbox', '', '', 30, ''),
1107('newusernotify', 'on', @iCatModeration, 'Enable notification about new members', 'checkbox', '', '', 40, ''),
1108('sys_album_auto_app', 'on', @iCatModeration, 'Enable albums auto-approval', 'checkbox', '', '', 50, '');
1109
1110
1111-- CAT: Site
1112SET @iCatSite = 7;
1113INSERT INTO `sys_options` VALUES
1114('site_email', 'captain@example.com', @iCatSite, 'Site Email', 'digit', '', '', 10, ''),
1115('site_title', 'Community', @iCatSite, 'Site Title', 'digit', '', '', 20, ''),
1116('site_email_notify', 'no-reply@example.com', @iCatSite, 'Email to send site''s mail from', 'digit', '', '', 30, '');
1117
1118
1119-- CAT: Privacy
1120SET @iCatPrivacy = 9;
1121INSERT INTO `sys_options` VALUES
1122('sys_ps_enable_create_group', '', @iCatPrivacy, 'Enable \'Create New Privacy Group\'', 'checkbox', '', '', 10, ''),
1123('sys_ps_enable_default_values', '', @iCatPrivacy, 'Enable \'Default Values\'', 'checkbox', '', '', 20, ''),
1124('sys_ps_enabled_group_1', '', @iCatPrivacy, 'Enable \'Default\' group', 'checkbox', '', '', 30, ''),
1125('sys_ps_enabled_group_2', 'on', @iCatPrivacy, 'Enable \'Me Only\' group', 'checkbox', '', '', 40, ''),
1126('sys_ps_enabled_group_3', 'on', @iCatPrivacy, 'Enable \'Public\' group', 'checkbox', '', '', 50, ''),
1127('sys_ps_enabled_group_4', 'on', @iCatPrivacy, 'Enable \'Members\' group', 'checkbox', '', '', 60, ''),
1128('sys_ps_enabled_group_5', 'on', @iCatPrivacy, 'Enable \'Friends\' group', 'checkbox', '', '', 70, ''),
1129('sys_ps_enabled_group_6', '', @iCatPrivacy, 'Enable \'Faves\' group', 'checkbox', '', '', 80, ''),
1130('sys_ps_enabled_group_7', '', @iCatPrivacy, 'Enable \'Contacts\' group', 'checkbox', '', '', 90, '');
1131
1132
1133-- CAT: Pruning
1134SET @iCatPruning = 11;
1135INSERT INTO `sys_options` VALUES
1136('db_clean_msg', '365', @iCatPruning, 'Delete messages older than (days)', 'digit', '', '', 10, ''),
1137('db_clean_profiles', '0', @iCatPruning, 'Delete profiles of members that didn\'t login for (days)', 'digit', '', '', 20, ''),
1138('db_clean_members_visits', '90', @iCatPruning, 'Delete stored members IPs older than (days)', 'digit', '', '', 30, ''),
1139('db_clean_banners_info', '60', @iCatPruning, 'Delete banner views and clicks data older than (days)', 'digit', '', '', 40, ''),
1140('db_clean_vkiss', '90', @iCatPruning, 'Delete greeting older than (days)', 'digit', '', '', 50, ''),
1141('db_clean_mem_levels', '30', @iCatPruning, 'Delete membership levels expired for (days)', 'digit', '', '', 60, '');
1142
1143
1144-- CAT: Matches
1145SET @iCatMatches = 12;
1146INSERT INTO `sys_options` VALUES
1147('enable_match', '', @iCatMatches, 'Enable matchmaking', 'checkbox', '', '', 10, ''),
1148('view_match_percent', '', @iCatMatches, 'Enable match percentage display', 'checkbox', '', '', 20, ''),
1149('match_percent', '85', @iCatMatches, 'Match percentage threshold for email notification (0-100)', 'digit', '', '', 30, '');
1150
1151
1152-- CAT: Template
1153SET @iCatTemplate = 13;
1154INSERT INTO `sys_options` VALUES
1155('template', 'uni', @iCatTemplate, 'Default template', 'select', 'global $dir; return (strlen($arg0) > 0 && file_exists($dir["root"]."templates/tmpl_".$arg0) ) ? true : false;', 'Template can not be empty and must be valid', 10, 'PHP:$aValues = get_templates_array(); $aResult = array(); foreach($aValues as $sKey => $sValue) $aResult[] = array(\'key\' => $sKey, \'value\' => $sValue); return $aResult;'),
1156('enable_template', 'on', @iCatTemplate, 'Allow users to choose templates', 'checkbox', '', '', 20, ''),
1157('nav_menu_elements_on_line_usr', '16', @iCatTemplate, 'Number of main menu tabs visible to members outside of "more" tab', 'digit', '', '', 30, ''),
1158('nav_menu_elements_on_line_gst', '16', @iCatTemplate, 'Number of main menu tabs visible to guests outside of "more" tab', 'digit', '', '', 40, ''),
1159('sys_template_page_width_min', '774', @iCatTemplate, 'Minimal allowed page width (pixels)', 'digit', '', '', 50, ''),
1160('sys_template_page_width_max', '1600', @iCatTemplate, 'Maximal allowed page width (pixels)', 'digit', '', '', 60, ''),
1161('ext_nav_menu_enabled', 'on', @iCatTemplate, 'Enable member menu', 'checkbox', '', '', 70, ''),
1162('ext_nav_menu_top_position', 'bottom', @iCatTemplate, 'Default position of member menu', 'select', '', '', 80, 'top,bottom,static');
1163
1164-- CAT: Security
1165SET @iCatSecurity = 14;
1166INSERT INTO `sys_options` VALUES
1167('sys_security_impact_threshold_log', '-1', @iCatSecurity, 'Breach impact threshold for report', 'digit', '', '', 10, ''),
1168('sys_security_impact_threshold_block', '-1', @iCatSecurity, 'Breach impact threshold for report and block', 'digit', '', '', 20, ''),
1169('sys_security_form_token_enable', 'on', @iCatSecurity, 'Enable CSRF token in forms', 'checkbox', '', '', 30, ''),
1170('sys_security_form_token_lifetime', '86400', @iCatSecurity, 'SCRF token lifetime (seconds, 0 - no tracking)', 'digit', '', '', 40, ''),
1171('sys_recaptcha_key_public', '', @iCatSecurity, 'reCAPTCHA public key', 'digit', '', '', 50, ''),
1172('sys_recaptcha_key_private', '', @iCatSecurity, 'reCAPTCHA private key', 'digit', '', '', 60, '');
1173
1174-- CAT: Watermark
1175SET @iCatWatermark = 16;
1176INSERT INTO `sys_options` VALUES
1177('enable_watermark', '', @iCatWatermark, 'Enable Watermark', 'checkbox', '', '', 10, ''),
1178('transparent1', '0', @iCatWatermark, 'Transparency for first image', 'digit', '', '', 20, ''),
1179('Water_Mark', '', @iCatWatermark, 'Water Mark', 'file', '', '', 30, '');
1180
1181
1182-- CAT: Languages
1183SET @iCatLanguages = 21;
1184INSERT INTO `sys_options` VALUES
1185('lang_default', 'en', @iCatLanguages, 'Default site language', 'text', '', '', 1, ''),
1186
1187('sys_calendar_starts_sunday', '', @iCatLanguages, 'Enable Sunday as the first weekday', 'checkbox', '', '', '30', ''),
1188
1189('time_format_php', 'H:i', @iCatLanguages, 'Time format (for code)', 'digit', '', '', 40, ''),
1190('short_date_format_php', 'd.m.Y', @iCatLanguages, 'Short date format (for code)', 'digit', '', '', 50, ''),
1191('date_format_php', 'd.m.Y H:i', @iCatLanguages, 'Long date format (for code)', 'digit', '', '', 60, ''),
1192
1193('time_format', '%H:%i', @iCatLanguages, 'Time format (for database)', 'digit', '', '', 70, ''),
1194('short_date_format', '%d.%m.%Y', @iCatLanguages, 'Short date format (for database)', 'digit', '', '', 80, ''),
1195('date_format', '%d.%m.%Y %H:%i', @iCatLanguages, 'Long date format (for database)', 'digit', '', '', 90, '');
1196
1197
1198-- CAT: IP List
1199SET @iCatIPList = 22;
1200INSERT INTO `sys_options` VALUES
1201('enable_member_store_ip', 'on', @iCatIPList, 'Enable member IP tracking', 'checkbox', '', '', 10, ''),
1202('ipBlacklistMode', '2', @iCatIPList, 'IP blacklist mode (1 - total block, 2 - login block)', 'digit', '', '', 20, ''),
1203('ipListGlobalType', '0', @iCatIPList, 'IP list type (0 - disabled, 1 - all allowed except listed, 2 - all blocked except listed)', 'digit', '', '', 30, '');
1204
1205
1206-- CAT: Antispam
1207SET @iCatAntispam = 23;
1208INSERT INTO `sys_options` VALUES
1209('sys_dnsbl_enable', 'on', @iCatAntispam, 'Enable DNS Block Lists', 'checkbox', '', '', 10, ''),
1210('sys_uridnsbl_enable', 'on', @iCatAntispam, 'Enable URI DNS Block Lists', 'checkbox', '', '', 20, ''),
1211('sys_akismet_enable', '', @iCatAntispam, 'Enable Akismet', 'checkbox', '', '', 30, ''),
1212('sys_akismet_api_key', '', @iCatAntispam, 'Akismet API Key', 'digit', '', '', 40, ''),
1213('sys_antispam_block', '', @iCatAntispam, 'Total block all spam content', 'checkbox', '', '', 50, ''),
1214('sys_antispam_report', 'on', @iCatAntispam, 'Send report to admin if spam content discovered', 'checkbox', '', '', 60, ''),
1215('sys_antispam_smart_check', 'on', @iCatAntispam, 'Smart antispam check', 'checkbox', '', '', 70, '');
1216
1217
1218-- CAT: Caching
1219SET @iCatCaching = 24;
1220INSERT INTO `sys_options` VALUES
1221('enable_cache_system', 'on', @iCatCaching, 'Enable cache for profiles information', 'checkbox', '', '', 10, ''),
1222('sys_db_cache_enable', 'on', @iCatCaching, 'Enable DB cache', 'checkbox', '', '', 20, ''),
1223('sys_db_cache_engine', 'File', @iCatCaching, 'DB cache engine (other than File option may require custom server setup)', 'select', '', '', 30, 'File,Memcache,APC,XCache'),
1224('sys_cache_memcache_host', '', @iCatCaching, 'Memcached server host', 'digit', '', '', 40, ''),
1225('sys_cache_memcache_port', '11211', @iCatCaching, 'Memcached server port', 'digit', '', '', 50, ''),
1226('sys_pb_cache_enable', 'on', @iCatCaching, 'Enable page blocks cache', 'checkbox', '', '', 60, ''),
1227('sys_pb_cache_engine', 'File', @iCatCaching, 'Page blocks cache engine (other than File option may require custom server setup)', 'select', '', '', 70, 'File,Memcache,APC,XCache'),
1228('sys_mm_cache_engine', 'File', @iCatCaching, 'Member menu cache engine (other than File option may require custom server setup)', 'select', '', '', 80, 'File,Memcache,APC,XCache'),
1229('sys_template_cache_enable', 'on', @iCatCaching, 'Enable cache for HTML files', 'checkbox', '', '', 90, ''),
1230('sys_template_cache_engine', 'FileHtml', @iCatCaching, 'Template cache engine (other than FileHtml option may require custom server setup)', 'select', '', '', 100, 'FileHtml,Memcache,APC,XCache'),
1231('sys_template_cache_css_enable', 'on', @iCatCaching, 'Enable cache for CSS files', 'checkbox', '', '', 110, ''),
1232('sys_template_cache_js_enable', 'on', @iCatCaching, 'Enable cache for JS files', 'checkbox', '', '', 120, ''),
1233('sys_template_cache_compress_enable', 'on', @iCatCaching, 'Enable compression for JS/CSS files(cache must be enabled)', 'checkbox', '', '', 130, '');
1234
1235
1236-- CAT: Tags
1237SET @iCatTags = 25;
1238INSERT INTO `sys_options` VALUES
1239('tags_non_parsable', 'hi, hey, hello, all, i, i''m, i''d, am, for, in, to, a, the, on, it''s, is, my, of, are, from, i''m, me, you, and, we, not, will, at, where, there', @iCatTags, 'Ignored words (lower case, comma-separated)', 'text', '', '', 10, ''),
1240('tags_min_rating', '2', @iCatTags, 'Minimum tag repeats to display for browsing', 'digit', '', '', 20, ''),
1241('tags_perpage_browse', '30', @iCatTags, 'Number of tags per page displayed for browsing', 'digit', '', '', 30, ''),
1242('tags_show_limit', '50', @iCatTags, 'Number of hot tags displayed for browsing', 'digit', '', '', 40, '');
1243
1244
1245-- CAT: Permalinks
1246SET @iCatPermalinks = 26;
1247INSERT INTO `sys_options` VALUES
1248('enable_modrewrite', 'on', @iCatPermalinks, 'Enable friendly profile permalinks', 'checkbox', '', '', 10, ''),
1249('permalinks_browse', 'on', @iCatPermalinks, 'Enable friendly browse permalinks', 'checkbox', '', '', 20, '');
1250
1251
1252-- CAT: Categories
1253SET @iCatCategories = 27;
1254INSERT INTO `sys_options` VALUES
1255('categ_perpage_browse', '30', @iCatCategories, 'Number of categories to show on browse pages', 'digit', '', '', 10, ''),
1256('categ_show_limit', '50', @iCatCategories, 'Number of categories to show limit', 'digit', '', '', 20, ''),
1257('categ_show_columns', '3', @iCatCategories, 'Number of columns to show categories', 'digit', '', '', 30, '');
1258
1259
1260-- CAT: Hidden
1261SET @iCatHidden = 0;
1262INSERT INTO `sys_options` VALUES
1263
1264('sys_tmp_version', '7.1.2', @iCatHidden, 'Dolphin version ', 'digit', '', '', 10, ''),
1265('license_code', '', @iCatHidden, 'Dolphin License Code', 'digit', '', '', 11, ''),
1266('license_expiration', '', @iCatHidden, 'Dolphin License Expiration', 'digit', '', '', 12, ''),
1267('license_checksum', '', @iCatHidden, 'Dolphin License Checksum', 'digit', '', '', 13, ''),
1268('enable_dolphin_footer', 'on', @iCatHidden, 'Enable BoonEx Footers', 'checkbox', '', '', 14, ''),
1269
1270('sys_ftp_login', '', @iCatHidden, 'FTP server login', 'digit', '', '', 20, ''),
1271('sys_ftp_password', '', @iCatHidden, 'FTP server password', 'digit', '', '', 21, ''),
1272('sys_ftp_dir', '', @iCatHidden, 'Path to Dolphin on FTP server', 'digit', '', '', 22, ''),
1273
1274('splash_editor', 'on', @iCatHidden, '', 'checkbox', '', '', 30, ''),
1275('splash_code', '<div class="bx-splash" style="position:relative; height:237px; background-repeat:no-repeat; background-position:0px 0px; background-image:url(templates/base/images/bx_splash_image.jpg)">\r\n    <div class="bx-splash-txt-bg" style="position:absolute; z-index:1; bottom:0px; width:100%; height:96px; background-color:#ffffff; opacity:0.7;">\r\n        <img src="templates/base/images/spacer.gif" />\r\n    </div>\r\n    <div class="bx-splash-txt" style="position:absolute; z-index:2; bottom:0px; width:100%; height:96px;">\r\n        <div class="bx-splash-txt-cnt bx-def-margin" style="position:relative; opacity:1.0;">\r\n            <div class="bx-splash-txt-l1" style="font-size: 36px;">Welcome to the community!</div>\r\n            <div class="bx-splash-txt-l2 bx-def-font-grayed" style="font-size:14px;">This social networking site is powered by <a href="http://www.boonex.com/dolphin">Dolphin Community Software</a> from BoonEx.</div>\r\n            <div class="bx-splash-action bx-def-padding-sec-topbottom" style="position:absolute; top:0px; right:0px;">\r\n                <button class="bx-btn bx-btn-primary" onclick="window.open (''join.php'',''_self'');">Join</button>\r\n                <button class="bx-btn" style="margin-left:10px;" onclick="showPopupLoginForm(); return false;">Login</button>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>', @iCatHidden, '', 'text', '', '', 31, ''),
1276('splash_visibility', 'index', @iCatHidden, '', 'text', '', '', 32, ''),
1277('splash_logged', 'on', @iCatHidden, '', 'checkbox', '', '', 33, ''),
1278
1279('sys_html_fields', 'a:1:{s:6:"system";a:4:{i:0;s:12:"POST.message";i:1;s:15:"REQUEST.message";i:2;s:12:"POST.CmtText";i:3;s:15:"REQUEST.CmtText";}}', @iCatHidden, 'HTML fields', 'text', '', '', 40, ''),
1280('sys_json_fields', '', @iCatHidden, 'JSON fields', 'text', '', '', 41, ''),
1281('sys_exceptions_fields', '', @iCatHidden, 'Exceptions fields', 'text', '', '', 42, ''),
1282
1283('cmdDay', '10', @iCatHidden, '', 'digit', '', '', 50, ''),
1284('tags_last_parse_time', '0', @iCatHidden, 'Temporary value when tags cron-job was runed last time', 'digit', '', '', 51, ''),
1285('cupid_last_cron', '0', @iCatHidden, 'Temporary value when cupid mails checked was runed last time', 'text', '', '', 52, ''),
1286('sys_show_admin_help', 'on', @iCatHidden, 'Show help in admin dashboard', 'checkbox', '', '', 53, ''),
1287
1288('sys_main_logo', '', @iCatHidden, 'Main logo file name', 'text', '', '', 60, ''),
1289('main_div_width', '1140px', @iCatHidden, 'Width of the main container of the site', 'digit', '', '', 61, ''),
1290
1291('sys_template_cache_image_enable', '', @iCatHidden, 'Enable cache for images (do not work for IE7)', 'checkbox', '', '', 70, ''),
1292('sys_template_cache_image_max_size', '5', @iCatHidden, 'Max image size to be cached(in kb)', 'digit', '', '', 71, ''),
1293
1294('sys_sitemap_enable', '', @iCatHidden, 'Enable sitemap generation', 'checkbox', '', '', 80, ''),
1295
1296('sys_captcha_default', 'sys_recaptcha', @iCatHidden, 'Default CAPTCHA', 'digit', '', '', 90, ''),
1297('sys_editor_default', 'sys_tinymce', @iCatHidden, 'Default HTML editor', 'digit', '', '', 91, '');
1298
1299
1300
1301
1302CREATE TABLE `sys_options_cats` (
1303  `ID` int(6) unsigned NOT NULL auto_increment,
1304  `name` varchar(50) NOT NULL default '',
1305  `menu_order` float default NULL,
1306  PRIMARY KEY  (`ID`)
1307) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=100;
1308
1309
1310INSERT INTO `sys_options_cats` VALUES(1, 'Profiles', 1);
1311INSERT INTO `sys_options_cats` VALUES(3, 'General', 3);
1312INSERT INTO `sys_options_cats` VALUES(4, 'Massmailer', 4);
1313INSERT INTO `sys_options_cats` VALUES(5, 'Memberships', 5);
1314INSERT INTO `sys_options_cats` VALUES(6, 'Moderation', 6);
1315INSERT INTO `sys_options_cats` VALUES(7, 'Site', 7);
1316INSERT INTO `sys_options_cats` VALUES(9, 'Privacy Groups', 9);
1317INSERT INTO `sys_options_cats` VALUES(11, 'Pruning', 11);
1318INSERT INTO `sys_options_cats` VALUES(12, 'Matches', 12);
1319INSERT INTO `sys_options_cats` VALUES(13, 'Template', 13);
1320INSERT INTO `sys_options_cats` VALUES(14, 'Security', 14);
1321INSERT INTO `sys_options_cats` VALUES(16, 'Watermark', 16);
1322INSERT INTO `sys_options_cats` VALUES(21, 'Languages', 21);
1323INSERT INTO `sys_options_cats` VALUES(22, 'IP Block List', 22);
1324INSERT INTO `sys_options_cats` VALUES(23, 'Antispam', 23);
1325INSERT INTO `sys_options_cats` VALUES(24, 'Caching', 24);
1326INSERT INTO `sys_options_cats` VALUES(25, 'Tags Settings', 25);
1327INSERT INTO `sys_options_cats` VALUES(26, 'Permalinks', 26);
1328INSERT INTO `sys_options_cats` VALUES(27, 'Categories Settings', 27);
1329
1330-- --------------------------------------------------------
1331
1332--
1333-- Table structure for table `sys_fave_list`
1334--
1335
1336CREATE TABLE `sys_fave_list` (
1337  `ID` int(10) unsigned NOT NULL default '0',
1338  `Profile` int(10) unsigned NOT NULL default '0',
1339  `When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1340  UNIQUE KEY `HotPair` (`ID`,`Profile`),
1341  KEY `ID` (`ID`),
1342  KEY `Profile` (`Profile`)
1343) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1344
1345--
1346-- Dumping data for table `sys_fave_list`
1347--
1348
1349-- --------------------------------------------------------
1350
1351--
1352-- Table structure for table `sys_ip_list`
1353--
1354
1355CREATE TABLE `sys_ip_list` (
1356  `ID` int(11) NOT NULL auto_increment,
1357  `From` int(10) unsigned NOT NULL,
1358  `To` int(10) unsigned NOT NULL,
1359  `Type` enum('allow','deny') NOT NULL default 'deny',
1360  `LastDT` int(11) unsigned NOT NULL,
1361  `Desc` varchar(128) NOT NULL,
1362  PRIMARY KEY  (`ID`),
1363  KEY `From` (`From`),
1364  KEY `To` (`To`)
1365) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1366
1367--
1368-- Dumping data for table `sys_ip_list`
1369--
1370
1371-- --------------------------------------------------------
1372
1373
1374--
1375-- Table structure for table `sys_ip_members_visits`
1376--
1377
1378CREATE TABLE `sys_ip_members_visits` (
1379  `ID` int(11) NOT NULL AUTO_INCREMENT,
1380  `MemberID` int(10) unsigned NOT NULL,
1381  `From` int(10) unsigned NOT NULL,
1382  `DateTime` datetime NOT NULL,
1383  PRIMARY KEY (`ID`),
1384  KEY `From` (`From`)
1385) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
1386
1387--
1388-- Dumping data for table `sys_ip_members_visits`
1389--
1390
1391-- --------------------------------------------------------
1392
1393--
1394-- Table structure for table `sys_localization_categories`
1395--
1396
1397CREATE TABLE `sys_localization_categories` (
1398  `ID` int(6) unsigned NOT NULL auto_increment,
1399  `Name` varchar(255) NOT NULL default '',
1400  PRIMARY KEY  (`ID`),
1401  UNIQUE KEY `Name` (`Name`)
1402) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
1403
1404--
1405-- Dumping data for table `sys_localization_categories`
1406--
1407
1408INSERT INTO `sys_localization_categories` VALUES(1, 'System');
1409
1410-- --------------------------------------------------------
1411
1412--
1413-- Table structure for table `sys_localization_keys`
1414--
1415
1416CREATE TABLE `sys_localization_keys` (
1417  `ID` int(10) unsigned NOT NULL auto_increment,
1418  `IDCategory` int(6) unsigned NOT NULL default '0',
1419  `Key` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
1420  PRIMARY KEY  (`ID`),
1421  UNIQUE KEY `Key` (`Key`)
1422) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
1423
1424--
1425-- Dumping data for table `sys_localization_keys`
1426--
1427
1428-- --------------------------------------------------------
1429
1430--
1431-- Table structure for table `sys_localization_languages`
1432--
1433
1434CREATE TABLE `sys_localization_languages` (
1435  `ID` tinyint(3) unsigned NOT NULL auto_increment,
1436  `Name` varchar(5) NOT NULL default '',
1437  `Flag` varchar(2) NOT NULL default '',
1438  `Title` varchar(255) NOT NULL default '',
1439  PRIMARY KEY  (`ID`),
1440  UNIQUE KEY `Name` (`Name`)
1441) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
1442
1443--
1444-- Dumping data for table `sys_localization_languages`
1445--
1446
1447-- INSERT INTO `sys_localization_languages` VALUES(1, 'en', 'gb', 'English');
1448
1449-- --------------------------------------------------------
1450
1451--
1452-- Table structure for table `sys_localization_string_params`
1453--
1454
1455CREATE TABLE `sys_localization_string_params` (
1456  `IDKey` int(10) unsigned NOT NULL default '0',
1457  `IDParam` tinyint(3) unsigned NOT NULL default '0',
1458  `Description` varchar(255) NOT NULL default '',
1459  PRIMARY KEY  (`IDKey`,`IDParam`)
1460) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1461
1462--
1463-- Dumping data for table `sys_localization_string_params`
1464--
1465
1466-- --------------------------------------------------------
1467
1468--
1469-- Table structure for table `sys_localization_strings`
1470--
1471
1472CREATE TABLE `sys_localization_strings` (
1473  `IDKey` int(10) unsigned NOT NULL default '0',
1474  `IDLanguage` tinyint(3) unsigned NOT NULL default '0',
1475  `String` mediumtext NOT NULL,
1476  PRIMARY KEY  (`IDKey`,`IDLanguage`)
1477) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1478
1479--
1480-- Dumping data for table `sys_localization_strings`
1481--
1482
1483-- --------------------------------------------------------
1484--
1485-- Table structure for table `sys_acl_actions`
1486--
1487
1488CREATE TABLE `sys_acl_actions` (
1489  `ID` smallint(5) unsigned NOT NULL auto_increment,
1490  `Name` varchar(255) NOT NULL default '',
1491  `AdditionalParamName` varchar(80) default NULL,
1492  PRIMARY KEY  (`ID`)
1493) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
1494
1495--
1496-- Dumping data for table `sys_acl_actions`
1497--
1498
1499INSERT INTO `sys_acl_actions` VALUES(1, 'send greetings', NULL);
1500INSERT INTO `sys_acl_actions` VALUES(2, 'view profiles', NULL);
1501INSERT INTO `sys_acl_actions` VALUES(3, 'vote', NULL);
1502INSERT INTO `sys_acl_actions` VALUES(4, 'send messages', NULL);
1503INSERT INTO `sys_acl_actions` VALUES(5, 'get other members emails', NULL);
1504INSERT INTO `sys_acl_actions` VALUES(6, 'comments post', NULL);
1505INSERT INTO `sys_acl_actions` VALUES(7, 'comments vote', NULL);
1506INSERT INTO `sys_acl_actions` VALUES(8, 'comments edit own', NULL);
1507INSERT INTO `sys_acl_actions` VALUES(9, 'comments remove own', NULL);
1508
1509-- --------------------------------------------------------
1510
1511--
1512-- Table structure for table `sys_acl_actions_track`
1513--
1514
1515CREATE TABLE `sys_acl_actions_track` (
1516  `IDAction` smallint(5) unsigned NOT NULL default '0',
1517  `IDMember` int(10) unsigned NOT NULL default '0',
1518  `ActionsLeft` smallint(5) unsigned NOT NULL default '0',
1519  `ValidSince` datetime default NULL,
1520  PRIMARY KEY  (`IDAction`,`IDMember`)
1521) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1522
1523--
1524-- Dumping data for table `sys_acl_actions_track`
1525--
1526
1527
1528-- --------------------------------------------------------
1529
1530
1531--
1532-- Table structure for table `sys_acl_matrix`
1533--
1534
1535CREATE TABLE `sys_acl_matrix` (
1536  `IDLevel` smallint(5) unsigned NOT NULL default '0',
1537  `IDAction` smallint(5) unsigned NOT NULL default '0',
1538  `AllowedCount` smallint(5) unsigned default NULL,
1539  `AllowedPeriodLen` smallint(5) unsigned default NULL,
1540  `AllowedPeriodStart` datetime default NULL,
1541  `AllowedPeriodEnd` datetime default NULL,
1542  `AdditionalParamValue` varchar(255) default NULL,
1543  PRIMARY KEY  (`IDLevel`,`IDAction`)
1544) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1545
1546--
1547-- Dumping data for table `sys_acl_matrix`
1548--
1549
1550INSERT INTO `sys_acl_matrix` VALUES(1, 2, NULL, NULL, NULL, NULL, NULL);
1551INSERT INTO `sys_acl_matrix` VALUES(1, 3, NULL, NULL, NULL, NULL, NULL);
1552INSERT INTO `sys_acl_matrix` VALUES(1, 7, NULL, NULL, NULL, NULL, NULL);
1553INSERT INTO `sys_acl_matrix` VALUES(2, 1, 4, 24, NULL, NULL, NULL);
1554INSERT INTO `sys_acl_matrix` VALUES(2, 2, NULL, NULL, NULL, NULL, NULL);
1555INSERT INTO `sys_acl_matrix` VALUES(2, 3, NULL, NULL, NULL, NULL, NULL);
1556INSERT INTO `sys_acl_matrix` VALUES(2, 4, 10, 24, NULL, NULL, NULL);
1557INSERT INTO `sys_acl_matrix` VALUES(2, 6, NULL, NULL, NULL, NULL, NULL);
1558INSERT INTO `sys_acl_matrix` VALUES(2, 7, NULL, NULL, NULL, NULL, NULL);
1559INSERT INTO `sys_acl_matrix` VALUES(2, 8, NULL, NULL, NULL, NULL, NULL);
1560INSERT INTO `sys_acl_matrix` VALUES(2, 9, NULL, NULL, NULL, NULL, NULL);
1561INSERT INTO `sys_acl_matrix` VALUES(3, 1, NULL, NULL, NULL, NULL, NULL);
1562INSERT INTO `sys_acl_matrix` VALUES(3, 2, NULL, NULL, NULL, NULL, NULL);
1563INSERT INTO `sys_acl_matrix` VALUES(3, 3, NULL, NULL, NULL, NULL, NULL);
1564INSERT INTO `sys_acl_matrix` VALUES(3, 4, NULL, NULL, NULL, NULL, NULL);
1565INSERT INTO `sys_acl_matrix` VALUES(3, 6, NULL, NULL, NULL, NULL, NULL);
1566INSERT INTO `sys_acl_matrix` VALUES(3, 7, NULL, NULL, NULL, NULL, NULL);
1567INSERT INTO `sys_acl_matrix` VALUES(3, 8, NULL, NULL, NULL, NULL, NULL);
1568INSERT INTO `sys_acl_matrix` VALUES(3, 9, NULL, NULL, NULL, NULL, NULL);
1569
1570-- --------------------------------------------------------
1571
1572--
1573-- Table structure for table `sys_acl_level_prices`
1574--
1575
1576CREATE TABLE `sys_acl_level_prices` (
1577  `id` int(11) NOT NULL auto_increment,
1578  `IDLevel` smallint(5) unsigned NOT NULL default '0',
1579  `Days` int(10) unsigned NOT NULL default '1',
1580  `Price` float unsigned NOT NULL default '1',
1581  PRIMARY KEY (`id`),
1582  UNIQUE KEY `type` (`IDLevel`,`Days`)
1583) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1584
1585--
1586-- Dumping data for table `sys_acl_level_prices`
1587--
1588
1589
1590-- --------------------------------------------------------
1591
1592--
1593-- Table structure for table `sys_acl_levels`
1594--
1595
1596CREATE TABLE `sys_acl_levels` (
1597  `ID` int(11) NOT NULL auto_increment,
1598  `Name` varchar(100) NOT NULL default '',
1599  `Icon` varchar(255) NOT NULL default '',
1600  `Description` text NOT NULL default '',
1601  `Active` enum('yes','no') NOT NULL default 'no',
1602  `Purchasable` enum('yes','no') NOT NULL default 'yes',
1603  `Removable` enum('yes','no') NOT NULL default 'yes',
1604  `Order` int(11) NOT NULL default '0',
1605  PRIMARY KEY  (`ID`),
1606  UNIQUE KEY `Name` (`Name`)
1607) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
1608
1609--
1610-- Dumping data for table `sys_acl_levels`
1611--
1612
1613INSERT INTO `sys_acl_levels` VALUES(1, 'Non-member', 'non-member.png', '', 'yes', 'no', 'no', 0);
1614INSERT INTO `sys_acl_levels` VALUES(2, 'Standard',  'member.png', '', 'yes', 'no', 'no', 0);
1615INSERT INTO `sys_acl_levels` VALUES(3, 'Promotion',  'promotion.png', '', 'yes', 'no', 'no', 0);
1616
1617-- --------------------------------------------------------
1618
1619--
1620-- Table structure for table `sys_messages`
1621--
1622
1623
1624--
1625-- Table structure for table `sys_messages`
1626--
1627
1628CREATE TABLE `sys_messages` (
1629  `ID` int(11) NOT NULL AUTO_INCREMENT,
1630  `Date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1631  `Sender` int(10) unsigned NOT NULL DEFAULT '0',
1632  `Recipient` int(10) unsigned NOT NULL DEFAULT '0',
1633  `Text` mediumtext NOT NULL,
1634  `Subject` varchar(255) NOT NULL DEFAULT '',
1635  `New` enum('0','1') NOT NULL DEFAULT '1',
1636  `Type` enum('letter','greeting') NOT NULL DEFAULT 'letter',
1637  `Trash` set('sender','recipient') NOT NULL,
1638  `TrashNotView` set('sender','recipient') NOT NULL,
1639  PRIMARY KEY (`ID`),
1640  KEY `Pair` (`Sender`,`Recipient`),
1641  KEY `TrashNotView` (`TrashNotView`),
1642  KEY `Trash` (`Trash`)
1643) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
1644
1645
1646-- --------------------------------------------------------
1647
1648
1649CREATE TABLE `sys_page_compose_pages` (
1650  `Name` varchar(255) NOT NULL default '',
1651  `Title` varchar(255) NOT NULL default '',
1652  `Order` int(10) unsigned NOT NULL default '0',
1653  `System` tinyint(1) NOT NULL default '1',
1654  PRIMARY KEY  (`Name`)
1655) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1656
1657INSERT INTO `sys_page_compose_pages` VALUES('index', 'Homepage', 1, 1);
1658INSERT INTO `sys_page_compose_pages` VALUES('member', 'Account', 6, 1);
1659INSERT INTO `sys_page_compose_pages` VALUES('profile', 'Profile', 7, 1);
1660INSERT INTO `sys_page_compose_pages` VALUES('pedit', 'Profile Edit', 8, 1);
1661INSERT INTO `sys_page_compose_pages` VALUES('profile_info', 'Profile Info', 14, 1);
1662INSERT INTO `sys_page_compose_pages` VALUES('profile_private', 'Profile Private', 15, 1);
1663INSERT INTO `sys_page_compose_pages` VALUES('browse_page', 'All Members', 17, 1);
1664INSERT INTO `sys_page_compose_pages` VALUES('mail_page', 'Mail messages', 18, 1);
1665INSERT INTO `sys_page_compose_pages` VALUES('mail_page_view', 'Mail view message', 19, 1);
1666INSERT INTO `sys_page_compose_pages` VALUES('mail_page_compose', 'Mail compose message', 20, 1);
1667INSERT INTO `sys_page_compose_pages` VALUES('search', 'Search Profiles', 21, 1);
1668INSERT INTO `sys_page_compose_pages` VALUES('join', 'Join Page', 22, 1);
1669INSERT INTO `sys_page_compose_pages` VALUES('friends', 'Friends', 23, 1);
1670INSERT INTO `sys_page_compose_pages` VALUES('communicator_page', 'Communicator', 24, 1);
1671INSERT INTO `sys_page_compose_pages` VALUES('search_home', 'Search Home', 25, 1);
1672INSERT INTO `sys_page_compose_pages` VALUES('tags_home', 'Tags Home', 26, 1);
1673INSERT INTO `sys_page_compose_pages` VALUES('tags_calendar', 'Tags Search', 27, 1);
1674INSERT INTO `sys_page_compose_pages` VALUES('tags_search', 'Tags Calendar', 28, 1);
1675INSERT INTO `sys_page_compose_pages` VALUES('tags_module', 'Tags Module', 29, 1);
1676INSERT INTO `sys_page_compose_pages` VALUES('categ_calendar', 'Categories Calendar', 30, 1);
1677INSERT INTO `sys_page_compose_pages` VALUES('categ_search', 'Categories Search', 31, 1);
1678INSERT INTO `sys_page_compose_pages` VALUES('categ_module', 'Categories Module', 32, 1);
1679
1680
1681CREATE TABLE `sys_page_compose_privacy` (
1682  `id` int(11) unsigned NOT NULL auto_increment,
1683  `user_id` int(11) unsigned NOT NULL default '0',
1684  `block_id` int(11) unsigned NOT NULL default '0',
1685  `allow_view_block_to` int(11) unsigned NOT NULL default '0',
1686  PRIMARY KEY  (`id`),
1687  UNIQUE KEY `block` (`user_id`, `block_id`)
1688) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1689
1690
1691CREATE TABLE `sys_page_compose` (
1692  `ID` int(11) unsigned NOT NULL auto_increment,
1693  `Page` varchar(255) NOT NULL default '',
1694  `PageWidth` varchar(10) NOT NULL default '1140px',
1695  `Desc` text NOT NULL,
1696  `Caption` varchar(255) NOT NULL default '',
1697  `Column` tinyint(3) unsigned NOT NULL default '0',
1698  `Order` smallint(6) unsigned NOT NULL default '0',
1699  `Func` varchar(255) NOT NULL default '',
1700  `Content` text NOT NULL,
1701  `DesignBox` tinyint(3) unsigned NOT NULL default '1',
1702  `ColWidth` float unsigned NOT NULL default '0',
1703  `Visible` set('non','memb') NOT NULL default 'non,memb',
1704  `MinWidth` int(10) unsigned NOT NULL default '0',
1705  `Cache` int(11) NOT NULL DEFAULT '0',
1706  PRIMARY KEY  (`ID`)
1707) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
1708
1709INSERT INTO `sys_page_compose` (`Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`, `Cache`) VALUES
1710('', '1140px', 'RSS Feed', '_RSS Feed', 0, 0, 'Sample', 'RSS', 1, 0, 'non,memb', 0, 0),
1711('', '1140px', 'Simple HTML Block', '_HTML Block', 0, 0, 'Sample', 'Echo', 11, 0, 'non,memb', 0, 0),
1712
1713('index', '1140px', 'Shows statistic information about your site content', '_Site Stats', 2, 2, 'SiteStats', '', 1, 28.1, 'non,memb', 0, 3600),
1714('index', '1140px', 'Display form to subscribe to newsletters', '_Subscribe_block_caption', 2, 1, 'Subscribe', '', 1, 28.1, 'non,memb', 0, 0),
1715('index', '1140px', 'Quick search form', '_Quick Search', 0, 0, 'QuickSearch', '', 1, 28.1, 'non,memb', 0, 0),
1716('index', '1140px', 'List of featured profiles', '_featured members', 0, 0, 'Featured', '', 1, 71.9, 'non,memb', 0, 0),
1717('index', '1140px', 'Site Tags', '_Tags', 0, 0, 'Tags', '', 1, 71.9, 'non,memb', 0, 0),
1718('index', '1140px', 'Site Categories', '_Categories', 0, 0, 'Categories', '', 1, 71.9, 'non,memb', 0, 0),
1719('index', '1140px', 'List of profiles', '_Members', 2, 0, 'Members', '', 1, 28.1, 'non,memb', 0, 0),
1720('index', '1140px', 'Shows Login Form', '_Member Login', 0, 0, 'LoginSection', '', 1, 28.1, 'non', 0, 86400),
1721('index', '1140px', '', '_BoonEx News', 1, 0, 'RSS', 'http://www.boonex.com/notes/featured_posts/?rss=1#4', 1, 71.9, 'non,memb', 0, 86400),
1722('index', '1140px', 'Download', '_sys_box_title_download', 0, 0, 'Download', '', 1, 28.1, 'non,memb', 0, 86400),
1723
1724('member', '1140px', 'Quick Links', '_Quick Links', 1, 0, 'QuickLinks', '', 1, 71.9, 'memb', 0, 0),
1725('member', '1140px', 'Friend Requests', '_sys_bcpt_member_friend_requests', 2, 1, 'FriendRequests', '', 1, 28.1, 'memb', 0, 0),
1726('member', '1140px', 'New Messages', '_sys_bcpt_member_new_messages', 2, 2, 'NewMessages', '', 1, 28.1, 'memb', 0, 0),
1727('member', '1140px', 'Account Control', '_sys_bcpt_member_account_control', 2, 3, 'AccountControl', '', 1, 28.1, 'memb', 0, 0),
1728('member', '1140px', 'Member Friends', '_My Friends', 0, 0, 'Friends', '', 1, 28.1, 'memb', 0, 0),
1729
1730('profile', '1140px', 'Profile actions', '_Actions', 1, 2, 'ActionsMenu', '', 1, 28.1, 'non,memb', 0, 0),
1731('profile', '1140px', 'Friend request notification', '_FriendRequest', 1, 3, 'FriendRequest', '', 1, 28.1, 'memb', 0, 0),
1732('profile', '1140px', 'Profile description block', '_Description', 2, 2, 'Description', '', 1, 71.9, 'non,memb', 0, 0),
1733('profile', '1140px', 'Profile Fields Block', '_FieldCaption_Admin Controls_View', 1, 4, 'PFBlock', '21', 1, 28.1, 'non,memb', 0, 0),
1734('profile', '1140px', 'Profile Fields Block', '_FieldCaption_General Info_View', 1, 5, 'PFBlock', '17', 1, 28.1, 'non,memb', 0, 0),
1735('profile', '1140px', 'Profile rating form', '_rate profile', 1, 6, 'RateProfile', '', 1, 28.1, 'non,memb', 0, 0),
1736('profile', '1140px', 'Member friends list', '_Friends', 0, 0, 'Friends', '', 1, 71.9, 'non,memb', 0, 0),
1737('profile', '1140px', 'Mutual friends of viewing and viewed members', '_Mutual Friends', 0, 0, 'MutualFriends', '', 1, 71.9, 'non,memb', 0, 0),
1738('profile', '1140px', 'Comments on member profile', '_profile_comments', 0, 0, 'Cmts', '', 1, 71.9, 'non,memb', 0, 0),
1739('profile', '1140px', 'Profile Fields Block', '_FieldCaption_Misc_View', 0, 0, 'PFBlock', '20', 1, 71.9, 'non,memb', 0, 0),
1740
1741('profile_info', '1140px', '', '_FieldCaption_General Info_View', 1, 0, 'GeneralInfo', '', 1, 100, 'non,memb', 0, 0),
1742('profile_info', '1140px', '', '_Additional information', 1, 2, 'AdditionalInfo', '', 1, 100, 'non,memb', 0, 0),
1743('profile_info', '1140px', 'Profile''s description', '_Description', 1, 1, 'Description', '', 1, 100, 'non,memb', 0, 0),
1744
1745('friends', '1140px', '', '_Member Friends', 1, 1, 'Friends', '', 1, 71.9, 'non,memb', 0, 0),
1746('friends', '1140px', '', '_Member Friends Requests', 2, 1, 'FriendsRequests', '', 1, 28.1, 'memb', 0, 0),
1747('friends', '1140px', '', '_Member Friends Mutual', 2, 2, 'FriendsMutual', '', 1, 28.1, 'memb', 0, 0),
1748
1749('browse_page', '1140px', '', '_Browse', 2, 0, 'SettingsBlock', '', 0, 28.1, 'non,memb', 0, 0),
1750('browse_page', '1140px', '', '_People', 1, 0, 'SearchedMembersBlock', '', 1, 71.9, 'non,memb', 0, 0),
1751
1752('mail_page', '1140px', '', '_Mail box', 1, 0, 'MailBox', '', 1, 71.9, 'non,memb', 0, 0),
1753('mail_page', '1140px', '', '_My contacts', 2, 0, 'Contacts', '', 1, 28.1, 'non,memb', 0, 0),
1754('mail_page_view', '1140px', '', '_Mail box', 1, 0, 'ViewMessage', '', 1, 71.9, 'non,memb', 0, 0),
1755('mail_page_view', '1140px', '', '_Archive', 2, 0, 'Archives', '', 1, 28.1, 'non,memb', 0, 0),
1756('mail_page_compose', '1140px', '', '_COMPOSE_H', 1, 0, 'ComposeMessage', '', 1, 71.9, 'non,memb', 0, 0),
1757('mail_page_compose', '1140px', '', '_My contacts', 2, 0, 'Contacts', '', 1, 28.1, 'non,memb', 0, 0),
1758
1759('search', '1140px', 'Search Results', '_Search result', 1, 0, 'Results', '', 1, 71.9, 'non,memb', 0, 0),
1760('search', '1140px', 'Search Form', '_Search profiles', 2, 0, 'SearchForm', '', 1, 28.1, 'non,memb', 0, 0),
1761('search_home', '1140px', 'Keyword Search', '_sys_box_title_search_keyword', 1, 0, 'Keyword', '', 1, 71.9, 'non,memb', 0, 86400),
1762('search_home', '1140px', 'People Search', '_sys_box_title_search_people', 2, 0, 'People', '', 1, 28.1, 'non,memb', 0, 0),
1763
1764('join', '1140px', 'Join Form Block', '_Join now', 1, 0, 'JoinForm', '', 1, 71.9, 'non', 413, 0),
1765('join', '1140px', 'Login Form Block', '_Login', 2, 0, 'LoginSection', 'no_join_text', 1, 28.1, 'non', 250, 86400),
1766
1767('communicator_page', '1140px', '', '_sys_cnts_bcpt_connections', 1, 1, 'Connections', '', 1, 71.9, 'memb', 0, 0),
1768('communicator_page', '1140px', '', '_sys_cnts_bcpt_friend_requests', 2, 1, 'FriendRequests', '', 1, 28.1, 'memb', 0, 0),
1769
1770('tags_home', '1140px', 'Recent Tags', '_tags_recent', 1, 0, 'Recent', '', 1, 28.1, 'non,memb', 0, 0),
1771('tags_home', '1140px', 'Popular Tags', '_popular_tags', 2, 0, 'Popular', '', 1, 71.9, 'non,memb', 0, 0),
1772('tags_calendar', '1140px', 'Calendar', '_tags_calendar', 1, 0, 'Calendar', '', 1, 100, 'non,memb', 0, 0),
1773('tags_calendar', '1140px', 'Date Tags', '_Tags', 1, 1, 'TagsDate', '', 1, 100, 'non,memb', 0, 0),
1774('tags_search', '1140px', 'Search Form', '_tags_search_form', 1, 0, 'Form', '', 1, 100, 'non,memb', 0, 86400),
1775('tags_search', '1140px', 'Founded Tags', '_tags_founded_tags', 1, 1, 'Founded', '', 1, 100, 'non,memb', 0, 0),
1776('tags_module', '1140px', 'Recent Tags', '_tags_recent', 1, 0, 'Recent', '', 1, 28.1, 'non,memb', 0, 0),
1777('tags_module', '1140px', 'All Tags', '_all_tags', 2, 0, 'All', '', 1, 71.9, 'non,memb', 0, 0),
1778
1779('categ_calendar', '1140px', 'Calendar', '_categ_caption_calendar', 1, 0, 'Calendar', '', 1, 100, 'non,memb', 0, 0),
1780('categ_calendar', '1140px', 'Categories By Day', '_categ_caption_day', 1, 1, 'CategoriesDate', '', 1, 100, 'non,memb', 0, 0),
1781('categ_search', '1140px', 'Search Form', '_categ_caption_search_form', 1, 0, 'Form', '', 1, 100, 'non,memb', 0, 86400),
1782('categ_search', '1140px', 'Founded Categories', '_categ_caption_founded', 1, 1, 'Founded', '', 1, 100, 'non,memb', 0, 0),
1783('categ_module', '1140px', 'Common Categories', '_categ_caption_common', 1, 0, 'Common', '', 1, 28.1, 'non,memb', 0, 0),
1784('categ_module', '1140px', 'All Categories', '_categ_caption_all', 2, 0, 'All', '', 1, 71.9, 'non,memb', 0, 0),
1785
1786('pedit', '1140px', 'Profile fields', '_edit_profile_info', 1, 1, 'Info', '', 1, 71.9, 'memb', 0, 0),
1787('pedit', '1140px', 'Profile privacy', '_edit_profile_privacy', 2, 1, 'Privacy', '', 1, 28.1, 'memb', 0, 0),
1788('pedit', '1140px', 'Profile membership', '_edit_profile_membership', 2, 2, 'Membership', '', 1, 28.1, 'memb', 0, 0),
1789
1790('profile_private', '1140px', 'Actions that other members can do', '_Actions', 1, 0, 'ActionsMenu', '', 1, 28.1, 'non,memb', 0, 0),
1791('profile_private', '1140px', 'Some text to explain why this profile can not be viewed. Translation for this block is stored in ''_sys_profile_private_text'' language key.', '_sys_profile_private_text_title', 2, 0, 'PrivacyExplain', '', 1, 71.9, 'non,memb', 0, 0);
1792
1793
1794-- --------------------------------------------------------
1795
1796--
1797-- Table structure for table `boon_sys_sessions`
1798--
1799
1800CREATE TABLE IF NOT EXISTS `sys_sessions` (
1801  `id` varchar(32) NOT NULL default '',
1802  `user_id` int(10) unsigned NOT NULL default '0',
1803  `data` text collate utf8_unicode_ci,
1804  `date` int(10) unsigned NOT NULL default '0',
1805  PRIMARY KEY (`id`),
1806  KEY `user_id` (`user_id`),
1807  KEY `date` (`date`)
1808) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
1809
1810-- --------------------------------------------------------
1811
1812--
1813-- Table structure for table `sys_stat_member`
1814--
1815
1816CREATE TABLE `sys_stat_member` (
1817  `Type` varchar(10) NOT NULL,
1818  `SQL` varchar(255) NOT NULL
1819) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
1820
1821--
1822-- Dumping data for table `sys_stat_member`
1823--
1824
1825INSERT INTO `sys_stat_member` VALUES('mma', 'SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=''__member_id__'' AND NOT FIND_IN_SET(''Recipient'', `sys_messages`.`Trash`)');
1826INSERT INTO `sys_stat_member` VALUES('mmn', 'SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=''__member_id__'' AND `New`=''1'' AND NOT FIND_IN_SET(''Recipient'', `sys_messages`.`Trash`)');
1827INSERT INTO `sys_stat_member` VALUES('mfl', 'SELECT COUNT(*) FROM `sys_fave_list` WHERE `ID` = ''__member_id__'' ');
1828INSERT INTO `sys_stat_member` VALUES('mfr', 'SELECT COUNT(*) FROM `sys_friend_list` as f LEFT JOIN `Profiles` as p ON p.`ID` = f.`ID` WHERE f.`Profile` = __member_id__ AND f.`Check` = ''0'' AND p.`Status`=''Active''');
1829INSERT INTO `sys_stat_member` VALUES('mfa', 'SELECT COUNT(*) FROM `sys_friend_list` WHERE ( `ID`=''__member_id__'' OR `Profile`=''__member_id__'' ) AND `Check`=''1''');
1830INSERT INTO `sys_stat_member` VALUES('mgc', 'SELECT COUNT(*) FROM `sys_greetings` WHERE `ID` = ''__member_id__'' AND New = ''1''');
1831INSERT INTO `sys_stat_member` VALUES('mbc', 'SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = ''__member_id__''');
1832INSERT INTO `sys_stat_member` VALUES('mgmc', 'SELECT COUNT(*) FROM `sys_greetings` WHERE `Profile` = ''__member_id__'' AND New = ''1''');
1833
1834-- --------------------------------------------------------
1835
1836--
1837-- Table structure for table `sys_pre_values`
1838--
1839
1840CREATE TABLE `sys_pre_values` (
1841  `Key` varchar(255) NOT NULL default '' COMMENT 'Key which defines link to values list',
1842  `Value` varchar(255) NOT NULL default '' COMMENT 'Simple value stored in the database',
1843  `Order` int(10) unsigned NOT NULL default '0',
1844  `LKey` varchar(255) NOT NULL default '' COMMENT 'Primary language key used for displaying this value',
1845  `LKey2` varchar(255) NOT NULL default '' COMMENT 'Additional key used in some other places',
1846  `LKey3` varchar(255) NOT NULL default '',
1847  `Extra` varchar(255) NOT NULL default '' COMMENT 'Some extra values. For example image link for sex',
1848  `Extra2` varchar(255) NOT NULL default '',
1849  `Extra3` varchar(255) NOT NULL default ''
1850) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1851
1852--
1853-- Dumping data for table `sys_pre_values`
1854--
1855INSERT INTO `sys_pre_values` VALUES
1856('Country', 'AF', 1, '__Afghanistan', '', '', '', '', ''),
1857('Country', 'AX', 2, '__Aland_Islands', '', '', '', '', ''),
1858('Country', 'AL', 3, '__Albania', '', '', '', '', ''),
1859('Country', 'DZ', 4, '__Algeria', '', '', '', '', ''),
1860('Country', 'AS', 5, '__American Samoa', '', '', '', '', ''),
1861('Country', 'AD', 6, '__Andorra', '', '', '', '', ''),
1862('Country', 'AO', 7, '__Angola', '', '', '', '', ''),
1863('Country', 'AI', 8, '__Anguilla', '', '', '', '', ''),
1864('Country', 'AQ', 9, '__Antarctica', '', '', '', '', ''),
1865('Country', 'AG', 10, '__Antigua and Barbuda', '', '', '', '', ''),
1866('Country', 'AR', 11, '__Argentina', '', '', '', '', ''),
1867('Country', 'AM', 12, '__Armenia', '', '', '', '', ''),
1868('Country', 'AW', 13, '__Aruba', '', '', '', '', ''),
1869('Country', 'AU', 14, '__Australia', '', '', '', '', ''),
1870('Country', 'AT', 15, '__Austria', '', '', '', '', ''),
1871('Country', 'AZ', 16, '__Azerbaijan', '', '', '', '', ''),
1872('Country', 'BH', 17, '__Bahrain', '', '', '', '', ''),
1873('Country', 'BD', 18, '__Bangladesh', '', '', '', '', ''),
1874('Country', 'BB', 19, '__Barbados', '', '', '', '', ''),
1875('Country', 'BY', 20, '__Belarus', '', '', '', '', ''),
1876('Country', 'BE', 21, '__Belgium', '', '', '', '', ''),
1877('Country', 'BZ', 22, '__Belize', '', '', '', '', ''),
1878('Country', 'BJ', 23, '__Benin', '', '', '', '', ''),
1879('Country', 'BM', 24, '__Bermuda', '', '', '', '', ''),
1880('Country', 'BT', 25, '__Bhutan', '', '', '', '', ''),
1881('Country', 'BO', 26, '__Bolivia', '', '', '', '', ''),
1882('Country', 'BA', 27, '__Bosnia and Herzegovina', '', '', '', '', ''),
1883('Country', 'BW', 28, '__Botswana', '', '', '', '', ''),
1884('Country', 'BV', 29, '__Bouvet Island', '', '', '', '', ''),
1885('Country', 'BR', 30, '__Brazil', '', '', '', '', ''),
1886('Country', 'IO', 31, '__British Indian Ocean Territory', '', '', '', '', ''),
1887('Country', 'VG', 32, '__British Virgin Islands', '', '', '', '', ''),
1888('Country', 'BN', 33, '__Brunei Darussalam', '', '', '', '', ''),
1889('Country', 'BG', 34, '__Bulgaria', '', '', '', '', ''),
1890('Country', 'BF', 35, '__Burkina Faso', '', '', '', '', ''),
1891('Country', 'MM', 36, '__Burma', '', '', '', '', ''),
1892('Country', 'BI', 37, '__Burundi', '', '', '', '', ''),
1893('Country', 'KH', 38, '__Cambodia', '', '', '', '', ''),
1894('Country', 'CM', 39, '__Cameroon', '', '', '', '', ''),
1895('Country', 'CA', 40, '__Canada', '', '', '', '', ''),
1896('Country', 'CV', 41, '__Cape Verde', '', '', '', '', ''),
1897('Country', 'KY', 42, '__Cayman Islands', '', '', '', '', ''),
1898('Country', 'CF', 43, '__Central African Republic', '', '', '', '', ''),
1899('Country', 'TD', 44, '__Chad', '', '', '', '', ''),
1900('Country', 'CL', 45, '__Chile', '', '', '', '', ''),
1901('Country', 'CN', 46, '__China', '', '', '', '', ''),
1902('Country', 'CX', 47, '__Christmas Island', '', '', '', '', ''),
1903('Country', 'CC', 48, '__Cocos (Keeling) Islands', '', '', '', '', ''),
1904('Country', 'CO', 49, '__Colombia', '', '', '', '', ''),
1905('Country', 'KM', 50, '__Comoros', '', '', '', '', ''),
1906('Country', 'CD', 51, '__Congo, Democratic Republic of the', '', '', '', '', ''),
1907('Country', 'CG', 52, '__Congo, Republic of the', '', '', '', '', ''),
1908('Country', 'CK', 53, '__Cook Islands', '', '', '', '', ''),
1909('Country', 'CR', 54, '__Costa Rica', '', '', '', '', ''),
1910('Country', 'CI', 55, '__Cote d''Ivoire', '', '', '', '', ''),
1911('Country', 'HR', 56, '__Croatia', '', '', '', '', ''),
1912('Country', 'CU', 57, '__Cuba', '', '', '', '', ''),
1913('Country', 'CY', 58, '__Cyprus', '', '', '', '', ''),
1914('Country', 'CZ', 59, '__Czech Republic', '', '', '', '', ''),
1915('Country', 'DK', 60, '__Denmark', '', '', '', '', ''),
1916('Country', 'DJ', 61, '__Djibouti', '', '', '', '', ''),
1917('Country', 'DM', 62, '__Dominica', '', '', '', '', ''),
1918('Country', 'DO', 63, '__Dominican Republic', '', '', '', '', ''),
1919('Country', 'TL', 64, '__East Timor', '', '', '', '', ''),
1920('Country', 'EC', 65, '__Ecuador', '', '', '', '', ''),
1921('Country', 'EG', 66, '__Egypt', '', '', '', '', ''),
1922('Country', 'SV', 67, '__El Salvador', '', '', '', '', ''),
1923('Country', 'GQ', 68, '__Equatorial Guinea', '', '', '', '', ''),
1924('Country', 'ER', 69, '__Eritrea', '', '', '', '', ''),
1925('Country', 'EE', 70, '__Estonia', '', '', '', '', ''),
1926('Country', 'ET', 71, '__Ethiopia', '', '', '', '', ''),
1927('Country', 'FK', 72, '__Falkland Islands (Islas Malvinas)', '', '', '', '', ''),
1928('Country', 'FO', 73, '__Faroe Islands', '', '', '', '', ''),
1929('Country', 'FJ', 74, '__Fiji', '', '', '', '', ''),
1930('Country', 'FI', 75, '__Finland', '', '', '', '', ''),
1931('Country', 'FR', 76, '__France', '', '', '', '', ''),
1932('Country', 'GF', 77, '__French Guiana', '', '', '', '', ''),
1933('Country', 'PF', 78, '__French Polynesia', '', '', '', '', ''),
1934('Country', 'TF', 79, '__French Southern and Antarctic Lands', '', '', '', '', ''),
1935('Country', 'GA', 80, '__Gabon', '', '', '', '', ''),
1936('Country', 'GE', 81, '__Georgia', '', '', '', '', ''),
1937('Country', 'DE', 82, '__Germany', '', '', '', '', ''),
1938('Country', 'GH', 83, '__Ghana', '', '', '', '', ''),
1939('Country', 'GI', 84, '__Gibraltar', '', '', '', '', ''),
1940('Country', 'GR', 85, '__Greece', '', '', '', '', ''),
1941('Country', 'GL', 86, '__Greenland', '', '', '', '', ''),
1942('Country', 'GD', 87, '__Grenada', '', '', '', '', ''),
1943('Country', 'GP', 88, '__Guadeloupe', '', '', '', '', ''),
1944('Country', 'GU', 89, '__Guam', '', '', '', '', ''),
1945('Country', 'GT', 90, '__Guatemala', '', '', '', '', ''),
1946('Country', 'GG', 91, '__Guernsey', '', '', '', '', ''),
1947('Country', 'GN', 92, '__Guinea', '', '', '', '', ''),
1948('Country', 'GW', 93, '__Guinea-Bissau', '', '', '', '', ''),
1949('Country', 'GY', 94, '__Guyana', '', '', '', '', ''),
1950('Country', 'HT', 95, '__Haiti', '', '', '', '', ''),
1951('Country', 'HM', 96, '__Heard Island and McDonald Islands', '', '', '', '', ''),
1952('Country', 'VA', 97, '__Holy See (Vatican City)', '', '', '', '', ''),
1953('Country', 'HN', 98, '__Honduras', '', '', '', '', ''),
1954('Country', 'HK', 99, '__Hong Kong (SAR)', '', '', '', '', ''),
1955('Country', 'HU', 100, '__Hungary', '', '', '', '', ''),
1956('Country', 'IS', 101, '__Iceland', '', '', '', '', ''),
1957('Country', 'IN', 102, '__India', '', '', '', '', ''),
1958('Country', 'ID', 103, '__Indonesia', '', '', '', '', ''),
1959('Country', 'IR', 104, '__Iran', '', '', '', '', ''),
1960('Country', 'IQ', 105, '__Iraq', '', '', '', '', ''),
1961('Country', 'IE', 106, '__Ireland', '', '', '', '', ''),
1962('Country', 'IM', 107, '__Isle_of_Man', '', '', '', '', ''),
1963('Country', 'IL', 108, '__Israel', '', '', '', '', ''),
1964('Country', 'IT', 109, '__Italy', '', '', '', '', ''),
1965('Country', 'JM', 110, '__Jamaica', '', '', '', '', ''),
1966('Country', 'JP', 111, '__Japan', '', '', '', '', ''),
1967('Country', 'JE', 112, '__Jersey', '', '', '', '', ''),
1968('Country', 'JO', 113, '__Jordan', '', '', '', '', ''),
1969('Country', 'KZ', 114, '__Kazakhstan', '', '', '', '', ''),
1970('Country', 'KE', 115, '__Kenya', '', '', '', '', ''),
1971('Country', 'KI', 116, '__Kiribati', '', '', '', '', ''),
1972('Country', 'KP', 117, '__Korea, North', '', '', '', '', ''),
1973('Country', 'KR', 118, '__Korea, South', '', '', '', '', ''),
1974('Country', 'KW', 119, '__Kuwait', '', '', '', '', ''),
1975('Country', 'KG', 120, '__Kyrgyzstan', '', '', '', '', ''),
1976('Country', 'LA', 121, '__Laos', '', '', '', '', ''),
1977('Country', 'LV', 122, '__Latvia', '', '', '', '', ''),
1978('Country', 'LB', 123, '__Lebanon', '', '', '', '', ''),
1979('Country', 'LS', 124, '__Lesotho', '', '', '', '', ''),
1980('Country', 'LR', 125, '__Liberia', '', '', '', '', ''),
1981('Country', 'LY', 126, '__Libya', '', '', '', '', ''),
1982('Country', 'LI', 127, '__Liechtenstein', '', '', '', '', ''),
1983('Country', 'LT', 128, '__Lithuania', '', '', '', '', ''),
1984('Country', 'LU', 129, '__Luxembourg', '', '', '', '', ''),
1985('Country', 'MO', 130, '__Macao', '', '', '', '', ''),
1986('Country', 'MK', 131, '__Macedonia, The Former Yugoslav Republic of', '', '', '', '', ''),
1987('Country', 'MG', 132, '__Madagascar', '', '', '', '', ''),
1988('Country', 'MW', 133, '__Malawi', '', '', '', '', ''),
1989('Country', 'MY', 134, '__Malaysia', '', '', '', '', ''),
1990('Country', 'MV', 135, '__Maldives', '', '', '', '', ''),
1991('Country', 'ML', 136, '__Mali', '', '', '', '', ''),
1992('Country', 'MT', 137, '__Malta', '', '', '', '', ''),
1993('Country', 'MH', 138, '__Marshall Islands', '', '', '', '', ''),
1994('Country', 'MQ', 139, '__Martinique', '', '', '', '', ''),
1995('Country', 'MR', 140, '__Mauritania', '', '', '', '', ''),
1996('Country', 'MU', 141, '__Mauritius', '', '', '', '', ''),
1997('Country', 'YT', 142, '__Mayotte', '', '', '', '', ''),
1998('Country', 'MX', 143, '__Mexico', '', '', '', '', ''),
1999('Country', 'FM', 144, '__Micronesia, Federated States of', '', '', '', '', ''),
2000('Country', 'MD', 145, '__Moldova', '', '', '', '', ''),
2001('Country', 'MC', 146, '__Monaco', '', '', '', '', ''),
2002('Country', 'MN', 147, '__Mongolia', '', '', '', '', ''),
2003('Country', 'ME', 148, '__Montenegro', '', '', '', '', ''),
2004('Country', 'MS', 149, '__Montserrat', '', '', '', '', ''),
2005('Country', 'MA', 150, '__Morocco', '', '', '', '', ''),
2006('Country', 'MZ', 151, '__Mozambique', '', '', '', '', ''),
2007('Country', 'NA', 152, '__Namibia', '', '', '', '', ''),
2008('Country', 'NR', 153, '__Nauru', '', '', '', '', ''),
2009('Country', 'NP', 154, '__Nepal', '', '', '', '', ''),
2010('Country', 'NL', 155, '__Netherlands', '', '', '', '', ''),
2011('Country', 'AN', 156, '__Netherlands Antilles', '', '', '', '', ''),
2012('Country', 'NC', 157, '__New Caledonia', '', '', '', '', ''),
2013('Country', 'NZ', 158, '__New Zealand', '', '', '', '', ''),
2014('Country', 'NI', 159, '__Nicaragua', '', '', '', '', ''),
2015('Country', 'NE', 160, '__Niger', '', '', '', '', ''),
2016('Country', 'NG', 161, '__Nigeria', '', '', '', '', ''),
2017('Country', 'NU', 162, '__Niue', '', '', '', '', ''),
2018('Country', 'NF', 163, '__Norfolk Island', '', '', '', '', ''),
2019('Country', 'MP', 164, '__Northern Mariana Islands', '', '', '', '', ''),
2020('Country', 'NO', 165, '__Norway', '', '', '', '', ''),
2021('Country', 'OM', 166, '__Oman', '', '', '', '', ''),
2022('Country', 'PK', 167, '__Pakistan', '', '', '', '', ''),
2023('Country', 'PW', 168, '__Palau', '', '', '', '', ''),
2024('Country', 'PS', 169, '__Palestinian Territory, Occupied', '', '', '', '', ''),
2025('Country', 'PA', 170, '__Panama', '', '', '', '', ''),
2026('Country', 'PG', 171, '__Papua New Guinea', '', '', '', '', ''),
2027('Country', 'PY', 172, '__Paraguay', '', '', '', '', ''),
2028('Country', 'PE', 173, '__Peru', '', '', '', '', ''),
2029('Country', 'PH', 174, '__Philippines', '', '', '', '', ''),
2030('Country', 'PN', 175, '__Pitcairn Islands', '', '', '', '', ''),
2031('Country', 'PL', 176, '__Poland', '', '', '', '', ''),
2032('Country', 'PT', 177, '__Portugal', '', '', '', '', ''),
2033('Country', 'PR', 178, '__Puerto Rico', '', '', '', '', ''),
2034('Country', 'QA', 179, '__Qatar', '', '', '', '', ''),
2035('Country', 'RE', 180, '__Reunion', '', '', '', '', ''),
2036('Country', 'RO', 181, '__Romania', '', '', '', '', ''),
2037('Country', 'RU', 182, '__Russia', '', '', '', '', ''),
2038('Country', 'RW', 183, '__Rwanda', '', '', '', '', ''),
2039('Country', 'SH', 184, '__Saint Helena', '', '', '', '', ''),
2040('Country', 'KN', 185, '__Saint Kitts and Nevis', '', '', '', '', ''),
2041('Country', 'LC', 186, '__Saint Lucia', '', '', '', '', ''),
2042('Country', 'PM', 187, '__Saint Pierre and Miquelon', '', '', '', '', ''),
2043('Country', 'VC', 188, '__Saint Vincent and the Grenadines', '', '', '', '', ''),
2044('Country', 'BL', 189, '__Saint_Barthelemy', '', '', '', '', ''),
2045('Country', 'MF', 190, '__Saint_Martin_French_part', '', '', '', '', ''),
2046('Country', 'WS', 191, '__Samoa', '', '', '', '', ''),
2047('Country', 'SM', 192, '__San Marino', '', '', '', '', ''),
2048('Country', 'ST', 193, '__Sao Tome and Principe', '', '', '', '', ''),
2049('Country', 'SA', 194, '__Saudi Arabia', '', '', '', '', ''),
2050('Country', 'SN', 195, '__Senegal', '', '', '', '', ''),
2051('Country', 'RS', 196, '__Serbia', '', '', '', '', ''),
2052('Country', 'SC', 197, '__Seychelles', '', '', '', '', ''),
2053('Country', 'SL', 198, '__Sierra Leone', '', '', '', '', ''),
2054('Country', 'SG', 199, '__Singapore', '', '', '', '', ''),
2055('Country', 'SK', 200, '__Slovakia', '', '', '', '', ''),
2056('Country', 'SI', 201, '__Slovenia', '', '', '', '', ''),
2057('Country', 'SB', 202, '__Solomon Islands', '', '', '', '', ''),
2058('Country', 'SO', 203, '__Somalia', '', '', '', '', ''),
2059('Country', 'ZA', 204, '__South Africa', '', '', '', '', ''),
2060('Country', 'GS', 205, '__South Georgia and the South Sandwich Islands', '', '', '', '', ''),
2061('Country', 'ES', 206, '__Spain', '', '', '', '', ''),
2062('Country', 'LK', 207, '__Sri Lanka', '', '', '', '', ''),
2063('Country', 'SD', 208, '__Sudan', '', '', '', '', ''),
2064('Country', 'SR', 209, '__Suriname', '', '', '', '', ''),
2065('Country', 'SJ', 210, '__Svalbard', '', '', '', '', ''),
2066('Country', 'SZ', 211, '__Swaziland', '', '', '', '', ''),
2067('Country', 'SE', 212, '__Sweden', '', '', '', '', ''),
2068('Country', 'CH', 213, '__Switzerland', '', '', '', '', ''),
2069('Country', 'SY', 214, '__Syria', '', '', '', '', ''),
2070('Country', 'TW', 215, '__Taiwan', '', '', '', '', ''),
2071('Country', 'TJ', 216, '__Tajikistan', '', '', '', '', ''),
2072('Country', 'TZ', 217, '__Tanzania', '', '', '', '', ''),
2073('Country', 'TH', 218, '__Thailand', '', '', '', '', ''),
2074('Country', 'BS', 219, '__The Bahamas', '', '', '', '', ''),
2075('Country', 'GM', 220, '__The Gambia', '', '', '', '', ''),
2076('Country', 'TG', 221, '__Togo', '', '', '', '', ''),
2077('Country', 'TK', 222, '__Tokelau', '', '', '', '', ''),
2078('Country', 'TO', 223, '__Tonga', '', '', '', '', ''),
2079('Country', 'TT', 224, '__Trinidad and Tobago', '', '', '', '', ''),
2080('Country', 'TN', 225, '__Tunisia', '', '', '', '', ''),
2081('Country', 'TR', 226, '__Turkey', '', '', '', '', ''),
2082('Country', 'TM', 227, '__Turkmenistan', '', '', '', '', ''),
2083('Country', 'TC', 228, '__Turks and Caicos Islands', '', '', '', '', ''),
2084('Country', 'TV', 229, '__Tuvalu', '', '', '', '', ''),
2085('Country', 'UG', 230, '__Uganda', '', '', '', '', ''),
2086('Country', 'UA', 231, '__Ukraine', '', '', '', '', ''),
2087('Country', 'AE', 232, '__United Arab Emirates', '', '', '', '', ''),
2088('Country', 'GB', 233, '__United Kingdom', '', '', '', '', ''),
2089('Country', 'US', 234, '__United States', '', '', '', '', ''),
2090('Country', 'UM', 235, '__United States Minor Outlying Islands', '', '', '', '', ''),
2091('Country', 'UY', 236, '__Uruguay', '', '', '', '', ''),
2092('Country', 'UZ', 237, '__Uzbekistan', '', '', '', '', ''),
2093('Country', 'VU', 238, '__Vanuatu', '', '', '', '', ''),
2094('Country', 'VE', 239, '__Venezuela', '', '', '', '', ''),
2095('Country', 'VN', 240, '__Vietnam', '', '', '', '', ''),
2096('Country', 'VI', 241, '__Virgin Islands', '', '', '', '', ''),
2097('Country', 'WF', 242, '__Wallis and Futuna', '', '', '', '', ''),
2098('Country', 'EH', 243, '__Western Sahara', '', '', '', '', ''),
2099('Country', 'YE', 244, '__Yemen', '', '', '', '', ''),
2100('Country', 'ZM', 245, '__Zambia', '', '', '', '', ''),
2101('Country', 'ZW', 246, '__Zimbabwe', '', '', '', '', '');
2102
2103INSERT INTO `sys_pre_values` VALUES('Sex', 'female', 1, '_Female', '_LookinFemale', '', '', '', '');
2104INSERT INTO `sys_pre_values` VALUES('Sex', 'male', 0, '_Male', '_LookinMale', '', '', '', '');
2105INSERT INTO `sys_pre_values` VALUES('Height', '1', 1, '__4''7" (140cm) or below', '', '', '', '', '');
2106INSERT INTO `sys_pre_values` VALUES('Height', '2', 2, '__4''8" - 4''11" (141-150cm)', '', '', '', '', '');
2107INSERT INTO `sys_pre_values` VALUES('Height', '3', 3, '__5''0" - 5''3" (151-160cm)', '', '', '', '', '');
2108INSERT INTO `sys_pre_values` VALUES('Height', '4', 4, '__5''4" - 5''7" (161-170cm)', '', '', '', '', '');
2109INSERT INTO `sys_pre_values` VALUES('Height', '5', 5, '__5''8" - 5''11" (171-180cm)', '', '', '', '', '');
2110INSERT INTO `sys_pre_values` VALUES('Height', '6', 6, '__6''0" - 6''3" (181-190cm)', '', '', '', '', '');
2111INSERT INTO `sys_pre_values` VALUES('Height', '7', 7, '__6''4" (191cm) or above', '', '', '', '', '');
2112INSERT INTO `sys_pre_values` VALUES('BodyType', '1', 1, '__Average', '', '', '', '', '');
2113INSERT INTO `sys_pre_values` VALUES('BodyType', '2', 2, '__Ample', '', '', '', '', '');
2114INSERT INTO `sys_pre_values` VALUES('BodyType', '3', 3, '__Athletic', '', '', '', '', '');
2115INSERT INTO `sys_pre_values` VALUES('BodyType', '4', 4, '__Cuddly', '', '', '', '', '');
2116INSERT INTO `sys_pre_values` VALUES('BodyType', '5', 5, '__Slim', '', '', '', '', '');
2117INSERT INTO `sys_pre_values` VALUES('BodyType', '6', 6, '__Very Cuddly', '', '', '', '', '');
2118INSERT INTO `sys_pre_values` VALUES('Religion', '1', 1, '__Adventist', '', '', '', '', '');
2119INSERT INTO `sys_pre_values` VALUES('Religion', '2', 2, '__Agnostic', '', '', '', '', '');
2120INSERT INTO `sys_pre_values` VALUES('Religion', '3', 3, '__Atheist', '', '', '', '', '');
2121INSERT INTO `sys_pre_values` VALUES('Religion', '4', 4, '__Baptist', '', '', '', '', '');
2122INSERT INTO `sys_pre_values` VALUES('Religion', '5', 5, '__Buddhist', '', '', '', '', '');
2123INSERT INTO `sys_pre_values` VALUES('Religion', '6', 6, '__Caodaism', '', '', '', '', '');
2124INSERT INTO `sys_pre_values` VALUES('Religion', '7', 7, '__Catholic', '', '', '', '', '');
2125INSERT INTO `sys_pre_values` VALUES('Religion', '8', 8, '__Christian', '', '', '', '', '');
2126INSERT INTO `sys_pre_values` VALUES('Religion', '9', 9, '__Hindu', '', '', '', '', '');
2127INSERT INTO `sys_pre_values` VALUES('Religion', '10', 10, '__Iskcon', '', '', '', '', '');
2128INSERT INTO `sys_pre_values` VALUES('Religion', '11', 11, '__Jainism', '', '', '', '', '');
2129INSERT INTO `sys_pre_values` VALUES('Religion', '12', 12, '__Jewish', '', '', '', '', '');
2130INSERT INTO `sys_pre_values` VALUES('Religion', '13', 13, '__Methodist', '', '', '', '', '');
2131INSERT INTO `sys_pre_values` VALUES('Religion', '14', 14, '__Mormon', '', '', '', '', '');
2132INSERT INTO `sys_pre_values` VALUES('Religion', '15', 15, '__Moslem', '', '', '', '', '');
2133INSERT INTO `sys_pre_values` VALUES('Religion', '16', 16, '__Orthodox', '', '', '', '', '');
2134INSERT INTO `sys_pre_values` VALUES('Religion', '17', 17, '__Pentecostal', '', '', '', '', '');
2135INSERT INTO `sys_pre_values` VALUES('Religion', '18', 18, '__Protestant', '', '', '', '', '');
2136INSERT INTO `sys_pre_values` VALUES('Religion', '19', 19, '__Quaker', '', '', '', '', '');
2137INSERT INTO `sys_pre_values` VALUES('Religion', '20', 20, '__Scientology', '', '', '', '', '');
2138INSERT INTO `sys_pre_values` VALUES('Religion', '21', 21, '__Shinto', '', '', '', '', '');
2139INSERT INTO `sys_pre_values` VALUES('Religion', '22', 22, '__Sikhism', '', '', '', '', '');
2140INSERT INTO `sys_pre_values` VALUES('Religion', '23', 23, '__Spiritual', '', '', '', '', '');
2141INSERT INTO `sys_pre_values` VALUES('Religion', '24', 24, '__Taoism', '', '', '', '', '');
2142INSERT INTO `sys_pre_values` VALUES('Religion', '25', 25, '__Wiccan', '', '', '', '', '');
2143INSERT INTO `sys_pre_values` VALUES('Religion', '26', 26, '__Other', '', '', '', '', '');
2144INSERT INTO `sys_pre_values` VALUES('Ethnicity', '1', 1, '__African', '', '', '', '', '');
2145INSERT INTO `sys_pre_values` VALUES('Ethnicity', '2', 2, '__African American', '', '', '', '', '');
2146INSERT INTO `sys_pre_values` VALUES('Ethnicity', '3', 3, '__Asian', '', '', '', '', '');
2147INSERT INTO `sys_pre_values` VALUES('Ethnicity', '4', 4, '__Caucasian', '', '', '', '', '');
2148INSERT INTO `sys_pre_values` VALUES('Ethnicity', '5', 5, '__East Indian', '', '', '', '', '');
2149INSERT INTO `sys_pre_values` VALUES('Ethnicity', '6', 6, '__Hispanic', '', '', '', '', '');
2150INSERT INTO `sys_pre_values` VALUES('Ethnicity', '7', 7, '__Indian', '', '', '', '', '');
2151INSERT INTO `sys_pre_values` VALUES('Ethnicity', '8', 8, '__Latino', '', '', '', '', '');
2152INSERT INTO `sys_pre_values` VALUES('Ethnicity', '9', 9, '__Mediterranean', '', '', '', '', '');
2153INSERT INTO `sys_pre_values` VALUES('Ethnicity', '10', 10, '__Middle Eastern', '', '', '', '', '');
2154INSERT INTO `sys_pre_values` VALUES('Ethnicity', '11', 11, '__Mixed', '', '', '', '', '');
2155INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '1', 1, '__Single', '', '', '', '', '');
2156INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '2', 2, '__Attached', '', '', '', '', '');
2157INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '3', 3, '__Divorced', '', '', '', '', '');
2158INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '4', 4, '__Married', '', '', '', '', '');
2159INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '5', 5, '__Separated', '', '', '', '', '');
2160INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '6', 6, '__Widow', '', '', '', '', '');
2161INSERT INTO `sys_pre_values` VALUES('Language', '0', 0, '__English', '', '', '', '', '');
2162INSERT INTO `sys_pre_values` VALUES('Language', '1', 1, '__Afrikaans', '', '', '', '', '');
2163INSERT INTO `sys_pre_values` VALUES('Language', '2', 2, '__Arabic', '', '', '', '', '');
2164INSERT INTO `sys_pre_values` VALUES('Language', '3', 3, '__Bulgarian', '', '', '', '', '');
2165INSERT INTO `sys_pre_values` VALUES('Language', '4', 4, '__Burmese', '', '', '', '', '');
2166INSERT INTO `sys_pre_values` VALUES('Language', '5', 5, '__Cantonese', '', '', '', '', '');
2167INSERT INTO `sys_pre_values` VALUES('Language', '6', 6, '__Croatian', '', '', '', '', '');
2168INSERT INTO `sys_pre_values` VALUES('Language', '7', 7, '__Danish', '', '', '', '', '');
2169INSERT INTO `sys_pre_values` VALUES('Language', '8', 8, '__Dutch', '', '', '', '', '');
2170INSERT INTO `sys_pre_values` VALUES('Language', '9', 9, '__Esperanto', '', '', '', '', '');
2171INSERT INTO `sys_pre_values` VALUES('Language', '10', 10, '__Estonian', '', '', '', '', '');
2172INSERT INTO `sys_pre_values` VALUES('Language', '11', 11, '__Finnish', '', '', '', '', '');
2173INSERT INTO `sys_pre_values` VALUES('Language', '12', 12, '__French', '', '', '', '', '');
2174INSERT INTO `sys_pre_values` VALUES('Language', '13', 13, '__German', '', '', '', '', '');
2175INSERT INTO `sys_pre_values` VALUES('Language', '14', 14, '__Greek', '', '', '', '', '');
2176INSERT INTO `sys_pre_values` VALUES('Language', '15', 15, '__Gujrati', '', '', '', '', '');
2177INSERT INTO `sys_pre_values` VALUES('Language', '16', 16, '__Hebrew', '', '', '', '', '');
2178INSERT INTO `sys_pre_values` VALUES('Language', '17', 17, '__Hindi', '', '', '', '', '');
2179INSERT INTO `sys_pre_values` VALUES('Language', '18', 18, '__Hungarian', '', '', '', '', '');
2180INSERT INTO `sys_pre_values` VALUES('Language', '19', 19, '__Icelandic', '', '', '', '', '');
2181INSERT INTO `sys_pre_values` VALUES('Language', '20', 20, '__Indian', '', '', '', '', '');
2182INSERT INTO `sys_pre_values` VALUES('Language', '21', 21, '__Indonesian', '', '', '', '', '');
2183INSERT INTO `sys_pre_values` VALUES('Language', '22', 22, '__Italian', '', '', '', '', '');
2184INSERT INTO `sys_pre_values` VALUES('Language', '23', 23, '__Japanese', '', '', '', '', '');
2185INSERT INTO `sys_pre_values` VALUES('Language', '24', 24, '__Korean', '', '', '', '', '');
2186INSERT INTO `sys_pre_values` VALUES('Language', '25', 25, '__Latvian', '', '', '', '', '');
2187INSERT INTO `sys_pre_values` VALUES('Language', '26', 26, '__Lithuanian', '', '', '', '', '');
2188INSERT INTO `sys_pre_values` VALUES('Language', '27', 27, '__Malay', '', '', '', '', '');
2189INSERT INTO `sys_pre_values` VALUES('Language', '28', 28, '__Mandarin', '', '', '', '', '');
2190INSERT INTO `sys_pre_values` VALUES('Language', '29', 29, '__Marathi', '', '', '', '', '');
2191INSERT INTO `sys_pre_values` VALUES('Language', '30', 30, '__Moldovian', '', '', '', '', '');
2192INSERT INTO `sys_pre_values` VALUES('Language', '31', 31, '__Nepalese', '', '', '', '', '');
2193INSERT INTO `sys_pre_values` VALUES('Language', '32', 32, '__Norwegian', '', '', '', '', '');
2194INSERT INTO `sys_pre_values` VALUES('Language', '33', 33, '__Persian', '', '', '', '', '');
2195INSERT INTO `sys_pre_values` VALUES('Language', '34', 34, '__Polish', '', '', '', '', '');
2196INSERT INTO `sys_pre_values` VALUES('Language', '35', 35, '__Portuguese', '', '', '', '', '');
2197INSERT INTO `sys_pre_values` VALUES('Language', '36', 36, '__Punjabi', '', '', '', '', '');
2198INSERT INTO `sys_pre_values` VALUES('Language', '37', 37, '__Romanian', '', '', '', '', '');
2199INSERT INTO `sys_pre_values` VALUES('Language', '38', 38, '__Russian', '', '', '', '', '');
2200INSERT INTO `sys_pre_values` VALUES('Language', '39', 39, '__Serbian', '', '', '', '', '');
2201INSERT INTO `sys_pre_values` VALUES('Language', '40', 40, '__Spanish', '', '', '', '', '');
2202INSERT INTO `sys_pre_values` VALUES('Language', '41', 41, '__Swedish', '', '', '', '', '');
2203INSERT INTO `sys_pre_values` VALUES('Language', '42', 42, '__Tagalog', '', '', '', '', '');
2204INSERT INTO `sys_pre_values` VALUES('Language', '43', 43, '__Taiwanese', '', '', '', '', '');
2205INSERT INTO `sys_pre_values` VALUES('Language', '44', 44, '__Tamil', '', '', '', '', '');
2206INSERT INTO `sys_pre_values` VALUES('Language', '45', 45, '__Telugu', '', '', '', '', '');
2207INSERT INTO `sys_pre_values` VALUES('Language', '46', 46, '__Thai', '', '', '', '', '');
2208INSERT INTO `sys_pre_values` VALUES('Language', '47', 47, '__Tongan', '', '', '', '', '');
2209INSERT INTO `sys_pre_values` VALUES('Language', '48', 48, '__Turkish', '', '', '', '', '');
2210INSERT INTO `sys_pre_values` VALUES('Language', '49', 49, '__Ukrainian', '', '', '', '', '');
2211INSERT INTO `sys_pre_values` VALUES('Language', '50', 50, '__Urdu', '', '', '', '', '');
2212INSERT INTO `sys_pre_values` VALUES('Language', '51', 51, '__Vietnamese', '', '', '', '', '');
2213INSERT INTO `sys_pre_values` VALUES('Language', '52', 52, '__Visayan', '', '', '', '', '');
2214INSERT INTO `sys_pre_values` VALUES('Education', '1', 1, '__High School graduate', '', '', '', '', '');
2215INSERT INTO `sys_pre_values` VALUES('Education', '2', 2, '__Some college', '', '', '', '', '');
2216INSERT INTO `sys_pre_values` VALUES('Education', '3', 3, '__College student', '', '', '', '', '');
2217INSERT INTO `sys_pre_values` VALUES('Education', '4', 4, '__AA (2 years college)', '', '', '', '', '');
2218INSERT INTO `sys_pre_values` VALUES('Education', '5', 5, '__BA/BS (4 years college)', '', '', '', '', '');
2219INSERT INTO `sys_pre_values` VALUES('Education', '6', 6, '__Some grad school', '', '', '', '', '');
2220INSERT INTO `sys_pre_values` VALUES('Education', '7', 7, '__Grad school student', '', '', '', '', '');
2221INSERT INTO `sys_pre_values` VALUES('Education', '8', 8, '__MA/MS/MBA', '', '', '', '', '');
2222INSERT INTO `sys_pre_values` VALUES('Education', '9', 9, '__PhD/Post doctorate', '', '', '', '', '');
2223INSERT INTO `sys_pre_values` VALUES('Education', '10', 10, '__JD', '', '', '', '', '');
2224INSERT INTO `sys_pre_values` VALUES('Income', '1', 1, '__$10,000/year and less', '', '', '', '', '');
2225INSERT INTO `sys_pre_values` VALUES('Income', '2', 2, '__$10,000-$30,000/year', '', '', '', '', '');
2226INSERT INTO `sys_pre_values` VALUES('Income', '3', 3, '__$30,000-$50,000/year', '', '', '', '', '');
2227INSERT INTO `sys_pre_values` VALUES('Income', '4', 4, '__$50,000-$70,000/year', '', '', '', '', '');
2228INSERT INTO `sys_pre_values` VALUES('Income', '5', 5, '__$70,000/year and more', '', '', '', '', '');
2229INSERT INTO `sys_pre_values` VALUES('Smoker', '1', 1, '__No', '', '', '', '', '');
2230INSERT INTO `sys_pre_values` VALUES('Smoker', '2', 2, '__Rarely', '', '', '', '', '');
2231INSERT INTO `sys_pre_values` VALUES('Smoker', '3', 3, '__Often', '', '', '', '', '');
2232INSERT INTO `sys_pre_values` VALUES('Smoker', '4', 4, '__Very often', '', '', '', '', '');
2233INSERT INTO `sys_pre_values` VALUES('Drinker', '1', 1, '__No', '', '', '', '', '');
2234INSERT INTO `sys_pre_values` VALUES('Drinker', '2', 2, '__Rarely', '', '', '', '', '');
2235INSERT INTO `sys_pre_values` VALUES('Drinker', '3', 3, '__Often', '', '', '', '', '');
2236INSERT INTO `sys_pre_values` VALUES('Drinker', '4', 4, '__Very often', '', '', '', '', '');
2237-- --------------------------------------------------------
2238
2239--
2240-- Table structure for table `sys_profile_fields`
2241--
2242
2243CREATE TABLE `sys_profile_fields` (
2244  `ID` smallint(10) unsigned NOT NULL AUTO_INCREMENT,
2245  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2246  `Type` enum('text','html_area','area','pass','date','select_one','select_set','num','range','bool','system','block') NOT NULL DEFAULT 'text',
2247  `Control` enum('select','checkbox','radio') DEFAULT NULL COMMENT 'input element for selectors',
2248  `Extra` text NOT NULL,
2249  `Min` float DEFAULT NULL,
2250  `Max` float DEFAULT NULL,
2251  `Values` text NOT NULL,
2252  `UseLKey` enum('LKey','LKey2','LKey3') NOT NULL DEFAULT 'LKey',
2253  `Check` text NOT NULL,
2254  `Unique` tinyint(1) NOT NULL DEFAULT '0',
2255  `Default` text NOT NULL,
2256  `Mandatory` tinyint(1) NOT NULL DEFAULT '0',
2257  `Deletable` tinyint(1) NOT NULL DEFAULT '1',
2258  `JoinPage` int(10) unsigned NOT NULL DEFAULT '0',
2259  `JoinBlock` int(10) unsigned NOT NULL DEFAULT '0',
2260  `JoinOrder` float DEFAULT NULL,
2261  `EditOwnBlock` int(10) unsigned NOT NULL DEFAULT '0',
2262  `EditOwnOrder` float DEFAULT NULL,
2263  `EditAdmBlock` int(10) unsigned NOT NULL DEFAULT '0',
2264  `EditAdmOrder` float DEFAULT NULL,
2265  `EditModBlock` int(10) unsigned NOT NULL DEFAULT '0',
2266  `EditModOrder` float DEFAULT NULL,
2267  `ViewMembBlock` int(10) unsigned NOT NULL DEFAULT '0',
2268  `ViewMembOrder` float DEFAULT NULL,
2269  `ViewAdmBlock` int(10) unsigned NOT NULL DEFAULT '0',
2270  `ViewAdmOrder` float DEFAULT NULL,
2271  `ViewModBlock` int(10) unsigned NOT NULL DEFAULT '0',
2272  `ViewModOrder` float DEFAULT NULL,
2273  `ViewVisBlock` int(10) unsigned NOT NULL DEFAULT '0',
2274  `ViewVisOrder` float DEFAULT NULL,
2275  `SearchParams` text NOT NULL,
2276  `SearchSimpleBlock` int(10) unsigned NOT NULL DEFAULT '0',
2277  `SearchSimpleOrder` float DEFAULT NULL,
2278  `SearchQuickBlock` int(10) unsigned NOT NULL DEFAULT '0',
2279  `SearchQuickOrder` float DEFAULT NULL,
2280  `SearchAdvBlock` int(10) unsigned NOT NULL DEFAULT '0',
2281  `SearchAdvOrder` float DEFAULT NULL,
2282  `MatchField` int(10) unsigned NOT NULL DEFAULT '0',
2283  `MatchPercent` tinyint(7) unsigned NOT NULL DEFAULT '0',
2284  PRIMARY KEY (`ID`),
2285  UNIQUE KEY `Name` (`Name`)
2286) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
2287
2288--
2289-- Dumping data for table `sys_profile_fields`
2290--
2291
2292INSERT INTO `sys_profile_fields` VALUES(1, 'ID', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 1, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 1, 17, 1, 0, NULL, '', 17, 2, 17, 2, 0, NULL, 0, 0);
2293INSERT INTO `sys_profile_fields` VALUES(2, 'NickName', 'text', NULL, '', 4, 16, '', 'LKey', 'return ( preg_match( ''/^[a-zA-Z0-9_-]+$/'', $arg0 ) and !file_exists( $dir[''root''] . $arg0 ) );', 1, '', 1, 0, 0, 17, 2, 0, NULL, 0, NULL, 17, 1, 0, NULL, 17, 3, 17, 2, 0, NULL, '', 17, 1, 17, 1, 0, NULL, 0, 0);
2294INSERT INTO `sys_profile_fields` VALUES(3, 'Password', 'pass', NULL, '', 5, 16, '', 'LKey', '', 0, '', 1, 0, 0, 17, 5, 17, 7, 17, 6, 17, 8, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2295INSERT INTO `sys_profile_fields` VALUES(4, 'Email', 'text', NULL, '', 6, NULL, '', 'LKey', 'return (bool) preg_match(''/^([a-z0-9\\+\\_\\-\\.]+)@([a-z0-9\\+\\_\\-\\.]+)$/i'', $arg0);', 1, '', 1, 0, 0, 17, 6, 17, 4, 17, 4, 17, 2, 0, NULL, 21, 1, 21, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2296INSERT INTO `sys_profile_fields` VALUES(5, 'DateReg', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2297INSERT INTO `sys_profile_fields` VALUES(6, 'DateLastEdit', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 4, 21, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2298INSERT INTO `sys_profile_fields` VALUES(7, 'Status', 'system', NULL, '', NULL, NULL, 'Unconfirmed\nApproval\nActive\nRejected\nSuspended', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 1, 21, 1, 0, NULL, 17, 6, 17, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2299INSERT INTO `sys_profile_fields` VALUES(8, 'DateLastLogin', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 3, 21, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2300INSERT INTO `sys_profile_fields` VALUES(9, 'Featured', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2301INSERT INTO `sys_profile_fields` VALUES(10, 'Sex', 'select_one', 'radio', '', NULL, NULL, '#!Sex', 'LKey', '', 0, 'male', 1, 0, 0, 20, 1, 17, 6, 17, 5, 17, 3, 17, 4, 17, 7, 17, 4, 17, 5, '', 20, 2, 20, 2, 17, 2, 11, 15);
2302INSERT INTO `sys_profile_fields` VALUES(11, 'LookingFor', 'select_set', 'checkbox', '', NULL, NULL, '#!Sex', 'LKey2', '', 0, '', 0, 0, 0, 20, 8, 20, 1, 20, 1, 17, 7, 17, 8, 17, 11, 17, 5, 17, 7, '', 20, 1, 20, 1, 0, NULL, 10, 30);
2303INSERT INTO `sys_profile_fields` VALUES(12, 'DescriptionMe', 'html_area', NULL, '', 20, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 20, 7, 20, 4, 20, 4, 20, 2, 0, NULL, 0, NULL, 22, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2304INSERT INTO `sys_profile_fields` VALUES(13, 'DateOfBirth', 'date', NULL, '', 18, 75, '', 'LKey', '', 0, '', 1, 1, 0, 20, 2, 20, 2, 20, 2, 17, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 3, 20, 3, 17, 3, 13, 0);
2305INSERT INTO `sys_profile_fields` VALUES(14, 'Headline', 'text', NULL, '', 5, 65535, '', 'LKey', '', 0, '', 1, 0, 0, 20, 6, 20, 3, 20, 3, 20, 1, 17, 1, 17, 2, 22, 1, 17, 1, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2306INSERT INTO `sys_profile_fields` VALUES(15, 'Country', 'select_one', 'select', '', NULL, NULL, '#!Country', 'LKey', '', 0, 'US', 1, 0, 0, 20, 3, 20, 5, 20, 5, 17, 5, 17, 6, 17, 9, 20, 2, 17, 4, '', 20, 4, 20, 4, 20, 1, 15, 40);
2307INSERT INTO `sys_profile_fields` VALUES(16, 'City', 'text', NULL, '', 2, 64, '', 'LKey', '', 0, '', 1, 0, 0, 20, 4, 20, 6, 20, 6, 17, 6, 17, 7, 17, 10, 20, 3, 17, 6, '', 0, NULL, 0, NULL, 20, 2, 0, 0);
2308INSERT INTO `sys_profile_fields` VALUES(17, 'General Info', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 1, 0, 1, 0, 2, 0, 2, 0, 1, 0, 1, 0, 1, 0, 1, '', 0, 1, 0, 1, 0, 1, 0, 0);
2309INSERT INTO `sys_profile_fields` VALUES(18, 'Location', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 5, 0, 0);
2310INSERT INTO `sys_profile_fields` VALUES(19, 'Keyword', 'system', NULL, 'DescriptionMe\nHeadline', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 3, 0, 0);
2311INSERT INTO `sys_profile_fields` VALUES(20, 'Misc Info', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 2, 0, 2, 0, 3, 0, 3, 0, 2, 0, 2, 0, 2, 0, 2, '', 0, 2, 0, 2, 0, 2, 0, 0);
2312INSERT INTO `sys_profile_fields` VALUES(21, 'Admin Controls', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 0, NULL, 0, 1, 0, 1, 0, NULL, 0, 3, 0, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2313INSERT INTO `sys_profile_fields` VALUES(23, 'Couple', 'system', NULL, 'Country\nCity', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 17, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 17, 1, 0, 0);
2314INSERT INTO `sys_profile_fields` VALUES(24, 'Captcha', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2315INSERT INTO `sys_profile_fields` VALUES(25, 'Security Image', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 3, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2316INSERT INTO `sys_profile_fields` VALUES(41, 'EmailNotify', 'bool', 'checkbox', '', NULL, NULL, '', 'LKey', '', 0, '1', 0, 0, 0, 17, 7, 17, 5, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2317INSERT INTO `sys_profile_fields` VALUES(39, 'zip', 'text', NULL, '', 1, 32, '', 'LKey', '', 0, '', 1, 0, 0, 20, 5, 20, 7, 20, 7, 20, 3, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2318INSERT INTO `sys_profile_fields` VALUES(34, 'DateLastNav', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2319INSERT INTO `sys_profile_fields` VALUES(37, 'aff_num', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2320INSERT INTO `sys_profile_fields` VALUES(38, 'Tags', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 9, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 5, 20, 5, 20, 4, 0, 0);
2321INSERT INTO `sys_profile_fields` VALUES(42, 'TermsOfUse', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2322INSERT INTO `sys_profile_fields` VALUES(44, 'Age', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 5, 17, 8, 20, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2323INSERT INTO `sys_profile_fields` VALUES(45, 'ProfilePhoto', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 10, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2324INSERT INTO `sys_profile_fields` VALUES(46, 'UserStatus', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2325INSERT INTO `sys_profile_fields` VALUES(47, 'UserStatusMessage', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2326INSERT INTO `sys_profile_fields` VALUES(48, 'UserStatusMessageWhen', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2327INSERT INTO `sys_profile_fields` VALUES(49, 'Avatar', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2328INSERT INTO `sys_profile_fields` VALUES(51, 'Height', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 8, 20, 8, 20, 4, 20, 1, 20, 1, 0, NULL, 20, 1, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2329INSERT INTO `sys_profile_fields` VALUES(52, 'Weight', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 9, 20, 9, 20, 5, 20, 2, 20, 2, 0, NULL, 20, 2, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2330INSERT INTO `sys_profile_fields` VALUES(53, 'Income', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 10, 20, 10, 20, 6, 20, 3, 20, 3, 0, NULL, 20, 3, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2331INSERT INTO `sys_profile_fields` VALUES(54, 'Occupation', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 11, 20, 11, 20, 7, 20, 4, 20, 4, 0, NULL, 20, 4, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2332INSERT INTO `sys_profile_fields` VALUES(55, 'Religion', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 12, 20, 12, 20, 8, 20, 5, 20, 5, 0, NULL, 20, 5, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2333INSERT INTO `sys_profile_fields` VALUES(56, 'Education', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 13, 20, 13, 20, 9, 20, 6, 20, 6, 0, NULL, 20, 6, '', 0, NULL, 0, NULL, 0, NULL, 56, 0);
2334INSERT INTO `sys_profile_fields` VALUES(57, 'RelationshipStatus', 'select_one', 'select', '', NULL, NULL, 'Single\nIn a Relationship\nEngaged\nMarried\nIt''s Complicated\nIn an Open Relationship', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 14, 20, 14, 20, 10, 20, 7, 20, 7, 0, NULL, 20, 7, '', 0, NULL, 0, NULL, 0, NULL, 57, 10);
2335INSERT INTO `sys_profile_fields` VALUES(58, 'Hobbies', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 15, 20, 15, 20, 11, 20, 8, 20, 8, 0, NULL, 20, 8, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2336INSERT INTO `sys_profile_fields` VALUES(59, 'Interests', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 16, 20, 16, 20, 12, 20, 9, 20, 9, 0, NULL, 20, 9, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2337INSERT INTO `sys_profile_fields` VALUES(60, 'Ethnicity', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 17, 20, 17, 20, 13, 20, 10, 20, 10, 0, NULL, 20, 10, '', 0, NULL, 0, NULL, 0, NULL, 60, 5);
2338INSERT INTO `sys_profile_fields` VALUES(61, 'FavoriteSites', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 18, 20, 18, 20, 14, 20, 11, 20, 11, 0, NULL, 20, 11, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2339INSERT INTO `sys_profile_fields` VALUES(62, 'FavoriteMusic', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 19, 20, 19, 20, 15, 20, 12, 20, 12, 0, NULL, 20, 12, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2340INSERT INTO `sys_profile_fields` VALUES(63, 'FavoriteFilms', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 20, 20, 20, 20, 16, 20, 13, 20, 13, 0, NULL, 20, 13, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2341INSERT INTO `sys_profile_fields` VALUES(64, 'FavoriteBooks', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 21, 20, 21, 20, 17, 20, 14, 20, 14, 0, NULL, 20, 14, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2342INSERT INTO `sys_profile_fields` VALUES(66, 'FirstName', 'text', NULL, '', 2, 200, '', 'LKey', '', 0, '', 1, 1, 0, 17, 3, 17, 2, 17, 2, 0, NULL, 17, 2, 17, 5, 0, NULL, 17, 2, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2343INSERT INTO `sys_profile_fields` VALUES(67, 'LastName', 'text', NULL, '', 2, 200, '', 'LKey', '', 0, '', 1, 1, 0, 17, 4, 17, 3, 17, 3, 0, NULL, 17, 3, 17, 4, 0, NULL, 17, 3, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2344INSERT INTO `sys_profile_fields` VALUES(68, 'allow_view_to', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0);
2345
2346-- --------------------------------------------------------
2347
2348--
2349-- Table structure for table `sys_acl_levels_members`
2350--
2351
2352CREATE TABLE `sys_acl_levels_members` (
2353  `IDMember` int(10) unsigned NOT NULL default '0',
2354  `IDLevel` smallint(5) unsigned NOT NULL default '0',
2355  `DateStarts` datetime NOT NULL default '0000-00-00 00:00:00',
2356  `DateExpires` datetime default NULL,
2357  `TransactionID` varchar(16) NOT NULL default '',
2358  PRIMARY KEY  (`IDMember`,`IDLevel`,`DateStarts`)
2359) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2360
2361--
2362-- Dumping data for table `sys_acl_levels_members`
2363--
2364
2365
2366-- --------------------------------------------------------
2367
2368--
2369-- Table structure for table `Profiles`
2370--
2371
2372CREATE TABLE `Profiles` (
2373  `ID` int(10) unsigned NOT NULL auto_increment,
2374  `NickName` varchar(255) NOT NULL default '',
2375  `Email` varchar(255) NOT NULL default '',
2376  `Password` varchar(40) NOT NULL default '',
2377  `Salt` varchar(10) NOT NULL default '',
2378  `Status` enum('Unconfirmed','Approval','Active','Rejected','Suspended') NOT NULL default 'Unconfirmed',
2379  `Role` tinyint(4) unsigned NOT NULL default '1',
2380  `Couple` int(10) unsigned NOT NULL default '0',
2381  `Sex` varchar(255) NOT NULL default '',
2382  `LookingFor` set('male','female') NOT NULL default '',
2383  `Headline` varchar(255) NOT NULL,
2384  `DescriptionMe` text NOT NULL,
2385  `Country` varchar(255) NOT NULL default '',
2386  `City` varchar(255) NOT NULL,
2387  `DateOfBirth` date NOT NULL,
2388  `Featured` tinyint(1) NOT NULL default '0',
2389  `DateReg` datetime NOT NULL default '0000-00-00 00:00:00',
2390  `DateLastEdit` datetime NOT NULL default '0000-00-00 00:00:00',
2391  `DateLastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
2392  `DateLastNav` datetime NOT NULL default '0000-00-00 00:00:00',
2393  `aff_num` int(10) unsigned NOT NULL default '0',
2394  `Tags` varchar(255) NOT NULL default '',
2395  `zip` varchar(255) NOT NULL,
2396  `EmailNotify` tinyint(1) NOT NULL default '1',
2397  `LangID` int(11) NOT NULL,
2398  `UpdateMatch` tinyint(1) NOT NULL default '1',
2399  `Views` int(11) NOT NULL,
2400  `Rate` float NOT NULL,
2401  `RateCount` int(11) NOT NULL,
2402  `CommentsCount` int(11) NOT NULL,
2403  `PrivacyDefaultGroup` int(11) NOT NULL default '3',
2404  `allow_view_to` int(11) NOT NULL default '3',
2405  `UserStatus` varchar(64) NOT NULL default 'online',
2406  `UserStatusMessage` varchar(255) NOT NULL default '',
2407  `UserStatusMessageWhen` int(10) NOT NULL,
2408  `Avatar` int(10) unsigned NOT NULL,
2409  `Height` varchar(255) NOT NULL,
2410  `Weight` varchar(255) NOT NULL,
2411  `Income` varchar(255) NOT NULL,
2412  `Occupation` varchar(255) NOT NULL,
2413  `Religion` varchar(255) NOT NULL,
2414  `Education` varchar(255) NOT NULL,
2415  `RelationshipStatus` enum('Single','In a Relationship','Engaged','Married','It''s Complicated','In an Open Relationship') default NULL,
2416  `Hobbies` text NOT NULL,
2417  `Interests` text NOT NULL,
2418  `Ethnicity` varchar(255) NOT NULL,
2419  `FavoriteSites` text NOT NULL,
2420  `FavoriteMusic` text NOT NULL,
2421  `FavoriteFilms` text NOT NULL,
2422  `FavoriteBooks` text NOT NULL,
2423  `FirstName` varchar(255) NOT NULL,
2424  `LastName` varchar(255) NOT NULL,
2425  PRIMARY KEY  (`ID`),
2426  UNIQUE KEY `NickName` (`NickName`),
2427  KEY `Country` (`Country`),
2428  KEY `DateOfBirth` (`DateOfBirth`),
2429  KEY `DateReg` (`DateReg`),
2430  KEY `DateLastNav` (`DateLastNav`),
2431  FULLTEXT KEY `NickName_2` (`NickName`,`City`,`Headline`,`DescriptionMe`,`Tags`)
2432) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
2433
2434--
2435-- Dumping data for table `Profiles`
2436--
2437
2438
2439-- --------------------------------------------------------
2440
2441--
2442-- Table structure for table `sys_profile_views_track`
2443--
2444
2445CREATE TABLE IF NOT EXISTS `sys_profile_views_track` (
2446  `id` int(10) unsigned NOT NULL,
2447  `viewer` int(10) unsigned NOT NULL,
2448  `ip` int(10) unsigned NOT NULL,
2449  `ts` int(10) unsigned NOT NULL,
2450  KEY `id` (`id`,`viewer`,`ip`)
2451) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2452
2453--
2454-- Dumping data for table `sys_profile_views_track`
2455--
2456
2457-- --------------------------------------------------------
2458
2459--
2460-- Table structure for table `sys_profiles_match`
2461--
2462
2463CREATE TABLE `sys_profiles_match` (
2464  `profile_id` int(10) NOT NULL,
2465  `sort` enum('none','activity','date_reg') NOT NULL default 'none',
2466  `profiles_match` text,
2467  UNIQUE KEY `profile_id` (`profile_id`,`sort`)
2468) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2469
2470
2471--
2472-- Table structure for table `sys_profiles_match_mails`
2473--
2474
2475CREATE TABLE `sys_profiles_match_mails` (
2476  `profile_id` int(10) NOT NULL,
2477  `profiles_match` text NOT NULL,
2478  PRIMARY KEY (`profile_id`)
2479) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2480
2481
2482-- --------------------------------------------------------
2483
2484--
2485-- Table structure for table `sys_profile_rating`
2486--
2487
2488CREATE TABLE `sys_profile_rating` (
2489  `pr_id` int(10) unsigned NOT NULL default '0',
2490  `pr_rating_count` int(11) NOT NULL default '0',
2491  `pr_rating_sum` int(11) NOT NULL default '0',
2492  UNIQUE KEY `med_id` (`pr_id`)
2493) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2494
2495--
2496-- Dumping data for table `sys_profile_rating`
2497--
2498
2499
2500-- --------------------------------------------------------
2501
2502--
2503-- Table structure for table `sys_profile_voting_track`
2504--
2505
2506CREATE TABLE `sys_profile_voting_track` (
2507  `pr_id` int(10) unsigned NOT NULL default '0',
2508  `pr_ip` varchar(20) default NULL,
2509  `pr_date` datetime default NULL,
2510  KEY `pr_ip` (`pr_ip`,`pr_id`)
2511) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2512
2513--
2514-- Dumping data for table `sys_profile_voting_track`
2515--
2516
2517-- RAY AS IT WAS INTEGRATED
2518
2519-- --------------------------------------------------------
2520
2521--
2522-- Table structure for table `RayBoardBoards`
2523--
2524
2525CREATE TABLE IF NOT EXISTS `RayBoardCurrentUsers` (
2526  `ID` varchar(20) NOT NULL default '',
2527  `Nick` varchar(255) NOT NULL,
2528  `Sex` enum('M','F') NOT NULL default 'M',
2529  `Age` int(11) NOT NULL default '0',
2530  `Photo` varchar(255) NOT NULL default '',
2531  `Profile` varchar(255) NOT NULL default '',
2532  `Desc` varchar(255) NOT NULL,
2533  `When` int(11) NOT NULL default '0',
2534  `Status` enum('new','old','idle') NOT NULL default 'new',
2535  PRIMARY KEY  (`ID`)
2536) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2537
2538CREATE TABLE IF NOT EXISTS `RayBoardBoards` (
2539  `ID` int(11) NOT NULL auto_increment, 
2540  `Name` varchar(255) NOT NULL default '',
2541  `Password` varchar(255) NOT NULL default '',
2542  `OwnerID` varchar(20) NOT NULL default '0',
2543  `When` int(11) default NULL,
2544  `Status` enum('new', 'normal','delete') NOT NULL default 'new',
2545  PRIMARY KEY  (`ID`)
2546) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2547
2548CREATE TABLE IF NOT EXISTS `RayBoardUsers` (
2549  `ID` int(11) NOT NULL auto_increment, 
2550  `Board` int(11) NOT NULL default '0',
2551  `User` varchar(20) NOT NULL default '',
2552  `When` int(11) default NULL,
2553  `Status` enum('normal','delete') NOT NULL default 'normal',
2554   PRIMARY KEY  (`ID`)
2555) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2556
2557-- --------------------------------------------------------
2558
2559--
2560-- Table structure for table `RayChatCurrentUsers`
2561--
2562
2563CREATE TABLE `RayChatCurrentUsers` (
2564  `ID` varchar(20) NOT NULL default '',
2565  `Nick` varchar(36) NOT NULL default '',
2566  `Sex` enum('M','F') NOT NULL default 'M',
2567  `Age` int(11) NOT NULL default '0',
2568  `Desc` text NOT NULL,
2569  `Photo` varchar(255) NOT NULL default '',
2570  `Profile` varchar(255) NOT NULL default '',
2571  `Online` varchar(10) NOT NULL default 'online',
2572  `Start` int(11) NOT NULL default '0',
2573  `When` int(11) NOT NULL default '0',
2574  `Status` enum('new','old','idle','kick','type','online') NOT NULL default 'new',
2575  PRIMARY KEY  (`ID`)
2576) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2577
2578--
2579-- Dumping data for table `RayChatCurrentUsers`
2580--
2581
2582
2583-- --------------------------------------------------------
2584
2585--
2586-- Table structure for table `RayChatMessages`
2587--
2588
2589CREATE TABLE `RayChatMessages` (
2590  `ID` int(11) NOT NULL auto_increment,
2591  `Room` int(11) NOT NULL default '0',
2592  `Sender` varchar(20) NOT NULL default '',
2593  `Recipient` varchar(20) NOT NULL default '',
2594  `Whisper` enum('true','false') NOT NULL default 'false',
2595  `Message` text NOT NULL,
2596  `Style` text NOT NULL,
2597  `Type` varchar(10) NOT NULL default 'text',
2598  `When` int(11) NOT NULL default '0',
2599  PRIMARY KEY  (`ID`)
2600) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2601
2602--
2603-- Dumping data for table `RayChatMessages`
2604--
2605
2606
2607-- --------------------------------------------------------
2608
2609--
2610-- Table structure for table `RayChatProfiles`
2611--
2612
2613CREATE TABLE `RayChatProfiles` (
2614  `ID` varchar(20) NOT NULL default '0',
2615  `Banned` enum('true','false') NOT NULL default 'false',
2616  `Type` varchar(10) NOT NULL default 'full',
2617  `Smileset` varchar(255) NOT NULL default '',
2618  PRIMARY KEY  (`ID`)
2619) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2620
2621--
2622-- Dumping data for table `RayChatProfiles`
2623--
2624
2625
2626-- --------------------------------------------------------
2627
2628--
2629-- Table structure for table `RayChatRooms`
2630--
2631
2632CREATE TABLE `RayChatRooms` (
2633  `ID` int(11) NOT NULL auto_increment,
2634  `Name` varchar(255) NOT NULL default '',
2635  `Password` varchar(255) NOT NULL default '',
2636  `Desc` text NOT NULL,
2637  `OwnerID` varchar(20) NOT NULL default '0',
2638  `When` int(11) default NULL,
2639  `Status` enum('normal','delete') NOT NULL default 'normal',
2640  PRIMARY KEY  (`ID`),
2641  UNIQUE KEY `Name` (`Name`)
2642) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
2643
2644--
2645-- Dumping data for table `RayChatRooms`
2646--
2647
2648INSERT INTO `RayChatRooms` VALUES(1, 'Lobby', '', 'Welcome to our chat! You are in the "Lobby" now, but you can pass into any other public room you wish to - take a look at the "All rooms" box.', '0', 0, 'normal');
2649INSERT INTO `RayChatRooms` VALUES(2, 'Friends', '', 'Welcome to the "Friends" room! This is a public room where you can have a fun chat with existing friends or make new ones! Enjoy!', '0', 1, 'normal');
2650
2651-- --------------------------------------------------------
2652
2653--
2654-- Table structure for table `RayChatRoomsUsers`
2655--
2656
2657CREATE TABLE `RayChatRoomsUsers` (
2658  `ID` int(11) NOT NULL auto_increment,
2659  `Room` int(11) NOT NULL default '0',
2660  `User` varchar(20) NOT NULL default '',
2661  `When` int(11) default NULL,
2662  `Status` enum('normal','delete') NOT NULL default 'normal',
2663  PRIMARY KEY  (`ID`)
2664) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2665
2666--
2667-- Dumping data for table `RayChatRoomsUsers`
2668--
2669
2670CREATE TABLE IF NOT EXISTS `RayChatMembershipsSettings` (
2671  `ID` int(11) NOT NULL auto_increment,
2672  `Name` varchar(20) NOT NULL default '' UNIQUE,
2673  `Caption` varchar(255) NOT NULL default '',
2674  `Type` enum('boolean','number','custom') NOT NULL default 'boolean',
2675  `Default` varchar(255) NOT NULL default '',
2676  `Range` int(3) NOT NULL default '3',
2677  `Error` varchar(255) NOT NULL default '',
2678  PRIMARY KEY  (`ID`)
2679);
2680TRUNCATE TABLE `RayChatMembershipsSettings`;
2681
2682INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('RoomCreate', 'New Rooms Creating:', 'boolean', 'true', '1', 'RayzRoomCreate');
2683INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('PrivateRoomCreate', 'Private Rooms Creating:', 'boolean', 'true', '1', 'RayzPrivateRoomCreate');
2684INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('AVCasting', 'Audio/Video Casting:', 'boolean', 'true', '1', 'RayzAVCasting');
2685INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('AVPlaying', 'Audio/Video Playing (for Messenger):', 'boolean', 'true', '1', 'RayzAVPlaying');
2686INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('AVLargeWindow', 'Enable Large Video Window:', 'boolean', 'true', '1', 'RayzAVLargeWindow');
2687INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('FileSend', 'Files Sending:', 'boolean', 'true', '1', 'RayzFileSend');
2688INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('WhisperMessages', 'Whispering Messages:', 'boolean', 'true', '1', 'RayzWhisperMessages');
2689INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('DirectMessages', 'Addressed Messages:', 'boolean', 'true', '1', 'RayzDirectMessages');
2690INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('RoomsNumber', 'Maximum Rooms Number:', 'number', '100', '3', 'RayzRoomsNumber');
2691INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('ChatsNumber', 'Maximum Private Chats Number:', 'number', '100', '3', 'RayzChatsNumber');
2692INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('AVWindowsNumber', 'Maximum Video Windows Number:', 'number', '100', '3', 'RayzAVWindowsNumber');
2693INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('RestrictedRooms', 'Restricted Rooms:', 'custom', '', '1', 'RayzRestrictedRooms');
2694
2695CREATE TABLE IF NOT EXISTS `RayChatMemberships` (
2696  `ID` int(11) NOT NULL auto_increment,
2697  `Setting` int(11) NOT NULL default '0',
2698  `Value` varchar(255) NOT NULL default '',
2699  `Membership` int(11) NOT NULL default '0',
2700  PRIMARY KEY  (`ID`)
2701);
2702TRUNCATE TABLE `RayChatMemberships`;
2703
2704
2705-- --------------------------------------------------------
2706
2707--
2708-- Table structure for table `RayImContacts`
2709--
2710
2711CREATE TABLE `RayImContacts` (
2712  `ID` int(11) NOT NULL auto_increment,
2713  `SenderID` int(11) NOT NULL default '0',
2714  `RecipientID` int(11) NOT NULL default '0',
2715  `Online` varchar(10) NOT NULL default 'online',
2716  `When` int(11) NOT NULL default '0',
2717  PRIMARY KEY  (`ID`)
2718) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2719
2720--
2721-- Dumping data for table `RayImContacts`
2722--
2723
2724
2725-- --------------------------------------------------------
2726
2727--
2728-- Table structure for table `RayImMessages`
2729--
2730
2731CREATE TABLE `RayImMessages` (
2732  `ID` int(11) NOT NULL auto_increment,
2733  `ContactID` int(11) NOT NULL default '0',
2734  `Message` text NOT NULL,
2735  `Style` text NOT NULL,
2736  `Type` varchar(10) NOT NULL default 'text',
2737  `When` int(11) NOT NULL default '0',
2738  PRIMARY KEY  (`ID`)
2739) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2740
2741--
2742-- Dumping data for table `RayImMessages`
2743--
2744
2745
2746-- --------------------------------------------------------
2747
2748--
2749-- Table structure for table `RayImPendings`
2750--
2751
2752CREATE TABLE `RayImPendings` (
2753  `ID` int(11) NOT NULL auto_increment,
2754  `SenderID` int(11) NOT NULL default '0',
2755  `RecipientID` int(11) NOT NULL default '0',
2756  `Message` varchar(255) NOT NULL default '',
2757  `When` int(11) NOT NULL default '0',
2758  PRIMARY KEY  (`ID`),
2759  KEY `RecipientID` (`RecipientID`)
2760) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2761
2762--
2763-- Dumping data for table `RayImPendings`
2764--
2765
2766
2767-- --------------------------------------------------------
2768
2769--
2770-- Table structure for table `RayImProfiles`
2771--
2772
2773CREATE TABLE `RayImProfiles` (
2774  `ID` int(11) NOT NULL default '0',
2775  `Smileset` varchar(255) NOT NULL default '',
2776  PRIMARY KEY  (`ID`)
2777) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2778
2779--
2780-- Dumping data for table `RayImProfiles`
2781--
2782
2783-- --------------------------------------------------------
2784
2785--
2786-- Table structure for table `RayMp3Files`
2787--
2788
2789CREATE TABLE `RayMp3Files` (
2790  `ID` int(11) NOT NULL auto_increment,
2791  `Categories` text NOT NULL,
2792  `Title` varchar(255) NOT NULL default '',
2793  `Uri` varchar(255) NOT NULL default '',
2794  `Tags` text NOT NULL,
2795  `Description` text NOT NULL,
2796  `Time` int(11) NOT NULL default '0',
2797  `Date` int(20) NOT NULL default '0',
2798  `Reports` int(11) NOT NULL default '0',
2799  `Owner` varchar(64) NOT NULL default '',
2800  `Listens` int(12) default '0',
2801  `Rate` float NOT NULL,
2802  `RateCount` int(11) NOT NULL,
2803  `CommentsCount` int(11) NOT NULL,
2804  `Featured` tinyint(4) NOT NULL,
2805  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL default 'pending',
2806  PRIMARY KEY  (`ID`),
2807  KEY (`Owner`)
2808) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2809
2810--
2811-- Dumping data for table `RayMp3Files`
2812--
2813
2814-- --------------------------------------------------------
2815
2816--
2817-- Table structure for table `RayMp3Tokens`
2818--
2819
2820CREATE TABLE `RayMp3Tokens` (
2821  `ID` int(11) NOT NULL default '0',
2822  `Token` varchar(32) NOT NULL default '',
2823  `Date` int(20) NOT NULL default '0',
2824  PRIMARY KEY `TokenId` (`ID`,`Token`)
2825) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2826
2827--
2828-- Dumping data for table `RayMp3Tokens`
2829--
2830
2831-- --------------------------------------------------------
2832
2833--
2834-- Table structure for table `RayShoutboxMessages`
2835--
2836
2837CREATE TABLE `RayShoutboxMessages` (
2838  `ID` int(11) NOT NULL auto_increment,
2839  `UserID` varchar(20) NOT NULL default '0',
2840  `Msg` text NOT NULL,
2841  `When` int(11) NOT NULL default '0',
2842  PRIMARY KEY  (`ID`)
2843) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2844
2845--
2846-- Dumping data for table `RayShoutboxMessages`
2847--
2848
2849-- --------------------------------------------------------
2850
2851--
2852-- Table structure for table `RayVideoFiles`
2853--
2854
2855CREATE TABLE `RayVideoFiles` (
2856  `ID` int(11) NOT NULL auto_increment,
2857  `Categories` text NOT NULL,
2858  `Title` varchar(255) NOT NULL default '',
2859  `Uri` varchar(255) NOT NULL default '',
2860  `Tags` text NOT NULL,
2861  `Description` text NOT NULL,
2862  `Time` int(11) NOT NULL default '0',
2863  `Date` int(20) NOT NULL default '0',
2864  `Owner` varchar(64) NOT NULL default '',
2865  `Views` int(12) default '0',
2866  `Rate` float NOT NULL,
2867  `RateCount` int(11) NOT NULL,
2868  `CommentsCount` int(11) NOT NULL,
2869  `Featured` tinyint(4) NOT NULL,
2870  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL default 'pending',
2871  `Source` varchar(20) NOT NULL default '',
2872  `Video` varchar(32) NOT NULL default '',
2873  PRIMARY KEY  (`ID`),
2874  KEY (`Owner`)
2875) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
2876
2877--
2878-- Dumping data for table `RayVideoFiles`
2879--
2880
2881-- --------------------------------------------------------
2882
2883--
2884-- Table structure for table `RayVideoFiles`
2885--
2886
2887CREATE TABLE `RayVideoTokens` (
2888  `ID` int(11) NOT NULL default '0',
2889  `Token` varchar(32) NOT NULL default '',
2890  `Date` int(20) NOT NULL default '0',
2891  PRIMARY KEY `TokenId` (`ID`,`Token`)
2892) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2893
2894--
2895-- Dumping data for table `RayVideoFiles`
2896--
2897
2898-- --------------------------------------------------------
2899
2900--
2901-- Table structure for table `RayVideo_commentsFiles`
2902--
2903
2904CREATE TABLE `RayVideo_commentsFiles` (
2905  `ID` int(11) NOT NULL auto_increment,
2906  `Categories` text NOT NULL,
2907  `Title` varchar(255) NOT NULL default '',
2908  `Uri` varchar(255) NOT NULL default '',
2909  `Tags` text NOT NULL,
2910  `Description` text NOT NULL,
2911  `Time` int(11) NOT NULL default '0',
2912  `Date` int(20) NOT NULL default '0',
2913  `Owner` varchar(64) NOT NULL default '',
2914  `Views` int(12) default '0',
2915  `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL default 'pending',
2916  PRIMARY KEY  (`ID`),
2917  KEY (`Owner`)
2918) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
2919
2920-- --------------------------------------------------------
2921
2922--
2923-- Table structure for table `RayVideo_commentsTokens`
2924--
2925
2926CREATE TABLE `RayVideo_commentsTokens` (
2927  `ID` int(11) NOT NULL default '0',
2928  `Token` varchar(32) NOT NULL default '',
2929  `Date` int(20) NOT NULL default '0',
2930  PRIMARY KEY `TokenId` (`ID`,`Token`)
2931) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2932
2933-- --------------------------------------------------------
2934-- RAY AS IT WAS INTEGRATED [END]
2935-- --------------------------------------------------------
2936
2937--
2938-- Table structure for table `sys_stat_site`
2939--
2940
2941CREATE TABLE `sys_stat_site` (
2942  `ID` tinyint(4) unsigned NOT NULL auto_increment,
2943  `Name` varchar(20) NOT NULL default '',
2944  `Title` varchar(50) NOT NULL default '',
2945  `UserLink` varchar(255) NOT NULL default '',
2946  `UserQuery` varchar(255) NOT NULL default '',
2947  `AdminLink` varchar(255) NOT NULL default '',
2948  `AdminQuery` varchar(255) NOT NULL default '',
2949  `IconName` varchar(50) NOT NULL default '',
2950  `StatOrder` int(4) unsigned NOT NULL default '0',
2951  PRIMARY KEY  (`ID`)
2952) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
2953
2954--
2955-- Dumping data for table `sys_stat_site`
2956--
2957INSERT INTO `sys_stat_site`(`Name`, `Title`, `UserLink`, `UserQuery`, `AdminLink`, `AdminQuery`, `IconName`, `StatOrder`) VALUES
2958('all', 'Members', 'browse.php', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status`=''Active'' AND (`Couple`=''0'' OR `Couple`>`ID`)', '{admin_url}profiles.php?action=browse&by=status&value=approval', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status`=''Approval'' AND (`Couple`=''0'' OR `Couple`>`ID`)', 'user', 1);
2959
2960-- --------------------------------------------------------
2961
2962--
2963-- Table structure for table 'sys_objects_search'
2964--
2965
2966CREATE TABLE `sys_objects_search` (
2967  `ID` int(10) unsigned NOT NULL auto_increment,
2968  `ObjectName` varchar(50) NOT NULL  default '',
2969  `Title` varchar(50) NOT NULL default '',
2970  `ClassName` varchar(50) NOT NULL  default '',
2971  `ClassPath` varchar(100) NOT NULL  default '',
2972  PRIMARY KEY  (`ID`)
2973) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
2974
2975--
2976-- Dumping data for table 'sys_objects_search'
2977--
2978
2979INSERT INTO `sys_objects_search` VALUES(3, 'profile', '_Profiles', 'BxTemplSearchProfile', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchProfile.php');
2980
2981-- --------------------------------------------------------
2982
2983--
2984-- Table structure for table 'sys_shared_sites'
2985--
2986
2987CREATE TABLE `sys_shared_sites` (
2988  `ID` tinyint(4) unsigned NOT NULL auto_increment,
2989  `Name` varchar(255) default NULL,
2990  `URL` varchar(255) NOT NULL default '',
2991  `Icon` varchar(255) NOT NULL default '',
2992  PRIMARY KEY  (`ID`)
2993) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
2994
2995INSERT INTO `sys_shared_sites` (`Name`, `URL`, `Icon`) VALUES
2996('digg', 'http://digg.com/submit?phase=2&url=', 'digg.png'),
2997('delicious', 'http://del.icio.us/post?url=', 'delicious.png'),
2998('blinklist', 'http://www.blinklist.com/index.php?Action=Blink/addblink.php&amp;Url=', 'blinklist.png'),
2999('newsvine', 'http://www.newsvine.com/_tools/seed&save?u=', 'newsvine.png'),
3000('reddit', 'http://reddit.com/submit?url=', 'reddit.png'),
3001('slashdot', 'http://slashdot.org/bookmark.pl?url=', 'slashdot.png'),
3002('stumbleupon', 'http://www.stumbleupon.com/url/http', 'stumbleupon.png'),
3003('technorati', 'http://technorati.com/faves?add=', 'technorati.png'),
3004('facebook', 'http://www.facebook.com/sharer/sharer.php?u=', 'facebook.png'),
3005('twitter', 'https://twitter.com/share?url=', 'twitter.png');
3006
3007--
3008-- Dumping data for table 'sys_shared_sites'
3009--
3010
3011-- --------------------------------------------------------
3012
3013--
3014-- Table structure for table `sys_tags`
3015--
3016
3017CREATE TABLE `sys_tags` (
3018  `Tag` varchar(32) NOT NULL default '',
3019  `ObjID` int(10) unsigned NOT NULL default '0',
3020  `Type` varchar(20) NOT NULL default 'profile',
3021  `Date` timestamp NOT NULL default CURRENT_TIMESTAMP,
3022  PRIMARY KEY  (`Tag`,`ObjID`,`Type`)
3023) ENGINE=MyISAM DEFAULT CHARSET=utf8;
3024
3025--
3026-- Dumping data for table `sys_tags`
3027--
3028
3029-- --------------------------------------------------------
3030
3031--
3032-- Table structure for table `sys_objects_tag`
3033--
3034
3035CREATE TABLE `sys_objects_tag` (
3036  `ID` int(10) unsigned NOT NULL auto_increment,
3037  `ObjectName` varchar(50) NOT NULL,
3038  `Query` text NOT NULL,
3039  `PermalinkParam` varchar(50) NOT NULL default '',
3040  `EnabledPermalink` varchar(100) NOT NULL default '',
3041  `DisabledPermalink` varchar(100) NOT NULL default '',
3042  `LangKey` varchar(100) NOT NULL default '',
3043  PRIMARY KEY  (`ID`)
3044) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3045
3046--
3047-- Dumping data for table `sys_objects_tag`
3048--
3049
3050INSERT INTO `sys_objects_tag` VALUES(1, 'profile', 'SELECT `Tags` FROM `Profiles` WHERE `ID` = {iID} AND `Status` = ''Active''', 'enable_modrewrite', 'search/tag/{tag}', 'search.php?Tags={tag}', '_Profiles');
3051
3052-- --------------------------------------------------------
3053
3054--
3055-- Table structure for table `sys_menu_top`
3056--
3057
3058CREATE TABLE `sys_menu_top` (
3059  `ID` smallint(6) unsigned NOT NULL auto_increment,
3060  `Parent` smallint(6) unsigned NOT NULL default '0',
3061  `Name` varchar(50) NOT NULL default '',
3062  `Caption` varchar(50) NOT NULL default '',
3063  `Link` varchar(255) NOT NULL default '',
3064  `Order` smallint(6) unsigned NOT NULL default '0',
3065  `Visible` set('non','memb') NOT NULL default '',
3066  `Target` varchar(20) NOT NULL default '',
3067  `Onclick` mediumtext NOT NULL,
3068  `Check` varchar(255) NOT NULL default '',
3069  `Movable` tinyint(4) NOT NULL default '3',
3070  `Clonable` tinyint(1) NOT NULL default '1',
3071  `Editable` tinyint(1) NOT NULL default '1',
3072  `Deletable` tinyint(1) NOT NULL default '1',
3073  `Active` tinyint(1) NOT NULL default '1',
3074  `Type` enum('system','top','custom') NOT NULL default 'top',
3075  `Picture` varchar(128) NOT NULL,
3076  `Icon` varchar(128) NOT NULL,
3077  `BQuickLink` tinyint(1) NOT NULL default '0',
3078  `Statistics` varchar(10) NOT NULL,
3079  PRIMARY KEY  (`ID`)
3080) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3081
3082
3083--
3084-- Dumping data for table `sys_menu_top`
3085--
3086
3087INSERT INTO `sys_menu_top` (`ID`, `Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Movable`, `Clonable`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `Icon`, `BQuickLink`, `Statistics`) VALUES
3088(4, 0, 'My Profile', '{memberNick}', '{memberLink}|{memberUsername}|change_status.php', 3, 'memb', '', '', '', 1, 0, 0, 0, 1, 'system', 'user', '', 0, ''),
3089(5, 0, 'Home', '_Home', 'index.php', 0, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'top', 'home', '', 0, ''),
3090(6, 0, 'People', '_People', 'browse.php|search.php|calendar.php|tags.php?tags_mode=profile|search.php?show=match', 5, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'top', 'user', '', 0, ''),
3091(7, 6, 'All members', '_All Members', 'browse.php', 0, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3092(8, 6, 'Search Members', '_Search', 'search.php', 9, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3093(9, 0, 'Profile View', '{profileNick}', '{profileUsername}|pedit.php?ID={profileID}', 0, 'non,memb', '', '', '', 3, 1, 1, 0, 1, 'system', '', '', 0, ''),
3094(11, 4, 'View My Profile', '_Profile', '{memberLink}|{memberUsername}|profile.php?ID={memberID}', 0, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3095(12, 179, 'Mail Compose', '_Compose', 'mail.php?mode=compose', 0, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3096(17, 179, 'Mail Inbox', '_Inbox', 'mail.php?mode=inbox', 1, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 1, 'mma'),
3097(14, 179, 'Mail Outbox', '_Outbox', 'mail.php?mode=outbox', 2, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3098(18, 179, 'Mail Trash', '_Trash', 'mail.php?mode=trash', 3, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3099(20, 0, 'Edit My Profile', '_Customize', 'pedit.php?ID={memberID}', 0, 'memb', '', '', '', 3, 1, 1, 1, 0, 'custom', 'user', '', 1, ''),
3100(25, 6, 'Online Members', '_Online', 'search.php?online_only=1', 2, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3101(60, 9, 'View Profile', '_Profile', '{profileLink}|{profileUsername}|profile.php?ID={profileID}', 0, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3102(80, 4, 'My Friends', '_Friends', 'viewFriends.php?iUser={memberID}', 2, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, 'mfa'),
3103(82, 9, 'Info', '_profile_info', 'profile_info.php?ID={profileID}', 1, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3104(83, 9, 'Member Friends', '_Friends', 'viewFriends.php?iUser={profileID}', 2, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3105(98, 0, 'Join', '_Account', 'join.php', 1, 'non', '', '', '', 3, 1, 1, 1, 1, 'system', 'user', '', 0, ''),
3106(99, 0, 'Login', '_Login', 'member.php', 0, 'non', '', '', '', 3, 1, 0, 1, 0, 'custom', 'user', '', 0, ''),
3107(100, 0, 'Main', '_Main', 'index.php|', 0, 'non,memb', '', '', '', 3, 1, 1, 1, 0, 'custom', '', '', 0, ''),
3108(101, 118, 'Account home', '_Account Home', 'member.php', 0, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3109(129, 6, 'Top Rated', '_Top Rated', 'search.php?show=top_rated', 4, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3110(127, 6, 'Match', '_Match', 'search.php?show=match', 1, 'non,memb', '', '', 'return isLogged() && getParam(\'enable_match\') == \'on\';', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3111(128, 6, 'Featured', '_Featured', 'search.php?show=featured', 3, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3112(107, 118, 'Privacy Groups', '_ps_tmenu_privacy_settings', 'member_privacy.php', 5, 'memb', '', '', 'bx_import(\'BxDolPrivacy\'); return BxDolPrivacy::isPrivacyPage();', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3113(109, 118, 'Unregister', '_Unregister', 'unregister.php', 8, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3114(111, 4, 'Profile Info', '_Info', 'profile_info.php', 1, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3115(118, 0, 'Dashboard', '_Dashboard', 'member.php', 2, 'memb', '', '', '', 1, 0, 1, 0, 1, 'system', 'dashboard', '', 0, ''),
3116(120, 0, 'About', '_About', 'about_us.php', 13, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'top', 'info-sign', '', 0, ''),
3117(122, 120, 'Terms of Use', '_TERMS_OF_USE_H', 'terms_of_use.php', 2, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3118(123, 120, 'Privacy Policy', '_PRIVACY_H', 'privacy.php', 3, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3119(126, 118, 'Activity', '_Activity', 'communicator.php', 3, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3120(130, 6, 'Popular', '_Popular', 'search.php?show=popular', 5, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3121(131, 6, 'Birthdays', '_Birthdays', 'search.php?show=birthdays', 6, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3122(132, 6, 'People Calendar', '_People_Calendar', 'calendar.php', 8, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3123(138, 0, 'Search', '_Search', 'search_home.php', 9, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'top', 'search', '', 0, ''),
3124(139, 138, 'Keyword Search', '_Keyword_Search', 'searchKeyword.php', 1, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3125(141, 138, 'People Search', '_People_Search', 'search.php', 3, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3126(159, 0, 'Help', '_help', 'help.php', 12, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'top', 'question-sign', '', 0, ''),
3127(160, 159, 'FAQ', '_FAQ', 'faq.php', 1, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3128(161, 159, 'Contact', '_Contact', 'contact.php', 2, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3129(162, 159, 'Advice', '_Advice', 'advice.php', 3, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3130(163, 159, 'Help', '_help', 'help.php', 0, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3131(175, 120, 'About', '_About', 'about_us.php', 0, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3132(176, 138, 'Search Home', '_Search_Home', 'search_home.php', 0, 'non,memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, ''),
3133(179, 0, 'Mail', '_Mail', 'mail.php?mode=inbox', 4, 'memb', '', '', '', 3, 1, 1, 1, 1, 'system', 'envelope', '', 0, ''),
3134(191, 118, 'Subscriptions', '_sbs_tmenu_my_subscriptions', 'member_subscriptions.php', 7, 'memb', '', '', '', 3, 1, 1, 1, 1, 'custom', '', '', 0, '');
3135
3136
3137-- --------------------------------------------------------
3138
3139
3140CREATE TABLE `sys_objects_actions` (
3141  `ID` int(10) unsigned NOT NULL auto_increment,
3142  `Caption` varchar(100) NOT NULL,
3143  `Icon` varchar(100) NOT NULL,
3144  `Url` varchar(250) NOT NULL,
3145  `Script` varchar(250) NOT NULL,
3146  `Eval` text NOT NULL,
3147  `Order` int(5) NOT NULL,
3148  `Type` varchar(20) NOT NULL,
3149  `bDisplayInSubMenuHeader` tinyint(1) NOT NULL default '0',
3150  PRIMARY KEY  (`ID`)
3151) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3152
3153INSERT INTO `sys_objects_actions` (`Caption`, `Icon`, `Url`, `Script`, `Eval`, `Order`, `Type`, `bDisplayInSubMenuHeader`) VALUES
3154('{evalResult}', 'edit', 'pedit.php?ID={ID}', '', 'if ({ID} != {member_id}) return;\r\nreturn _t(''{cpt_edit}'');', 1, 'Profile', 0),
3155('{evalResult}', 'envelope', 'mail.php?mode=compose&recipient_id={ID}', '', 'if ({ID} == {member_id}) return;\r\nreturn _t(''{cpt_send_letter}'');', 2, 'Profile', 0),
3156('{cpt_fave}', 'asterisk', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFaveAdd({ID}, {member_id});', 3, 'Profile', 0),
3157('{cpt_remove_fave}', 'asterisk', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFaveCancel({ID}, {member_id});', 3, 'Profile', 0),
3158('{cpt_befriend}', 'plus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendAdd({ID}, {member_id});', 4, 'Profile', 0),
3159('{cpt_remove_friend}', 'minus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendCancel({ID}, {member_id}, false);', 4, 'Profile', 0),
3160('{cpt_greet}', 'hand-right', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\nreturn "$.post(''greet.php'', { sendto: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 5, 'Profile', 0),
3161('{cpt_get_mail}', 'envelope-alt', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\n$bAnonymousMode  = ''{anonym_mode}'';\r\n\r\nif ( !$bAnonymousMode ) {\r\n    return "$.post(''freemail.php'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n}\r\n', 6, 'Profile', 0),
3162('{cpt_share}', 'share', '', 'return launchTellFriendProfile({ID});', '', 7, 'Profile', 0),
3163('{cpt_report}', 'exclamation-sign', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\nreturn  "$.post(''list_pop.php?action=spam'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 8, 'Profile', 0),
3164('{cpt_block}', 'ban-circle', '', '{evalResult}', 'if ( {ID} == {member_id} || isBlocked({member_id}, {ID}) ) return;\r\n\r\nreturn  "$.post(''list_pop.php?action=block'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 9, 'Profile', 0),
3165('{sbs_profile_title}', 'paper-clip', '', '{sbs_profile_script}', '', 10, 'Profile', 0),
3166('{cpt_unblock}', 'ban-circle', '', '{evalResult}', 'if ({ID} == {member_id} || !isBlocked({member_id}, {ID}) ) return;\r\n\r\nreturn "$.post(''list_pop.php?action=unblock'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 9, 'Profile', 0),
3167
3168('{evalResult}', 'plus', '{BaseUri}mail.php?mode=compose', '', 'return $GLOBALS[''logged''][''member''] || $GLOBALS[''logged''][''admin''] ? _t(''_sys_am_mailbox_compose'') : '''';', 1, 'Mailbox', 1),
3169
3170('{cpt_am_friend_add}', 'plus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendAdd({ID}, {member_id}, false);', 1, 'ProfileTitle', 1),
3171('{cpt_am_friend_accept}', 'plus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendAccept({ID}, {member_id}, false);', 2, 'ProfileTitle', 1),
3172('{cpt_am_friend_cancel}', 'minus', '', '{evalResult}', 'return $GLOBALS[''oTopMenu'']->getScriptFriendCancel({ID}, {member_id}, false);', 3, 'ProfileTitle', 1),
3173('{cpt_am_profile_message}', 'envelope', '{evalResult}', '', 'return $GLOBALS[''oTopMenu'']->getUrlProfileMessage({ID});', 4, 'ProfileTitle', 1),
3174('{cpt_am_profile_account_page}', 'dashboard', '{evalResult}', '', 'return $GLOBALS[''oTopMenu'']->getUrlAccountPage({ID});', 5, 'ProfileTitle', 1),
3175
3176('{cpt_am_account_profile_page}', 'user', '{evalResult}', '', 'return $GLOBALS[''oTopMenu'']->getUrlProfilePage({ID});', 1, 'AccountTitle', 1);
3177
3178
3179-- --------------------------------------------------------
3180
3181
3182--
3183-- Table structure for table `sys_greetings`
3184--
3185
3186CREATE TABLE `sys_greetings` (
3187  `ID` int(10) unsigned NOT NULL default '0',
3188  `Profile` int(10) unsigned NOT NULL default '0',
3189  `Number` smallint(5) unsigned NOT NULL default '0',
3190  `When` date NOT NULL default '0000-00-00',
3191  `New` enum('0','1') NOT NULL default '1',
3192  PRIMARY KEY  (`ID`,`Profile`)
3193) ENGINE=MyISAM DEFAULT CHARSET=utf8;
3194
3195--
3196-- Dumping data for table `sys_greetings`
3197--
3198
3199-- --------------------------------------------------------
3200
3201--
3202-- Table structure for table `sys_objects_vote`
3203--
3204
3205CREATE TABLE `sys_objects_vote` (
3206  `ID` int(10) unsigned NOT NULL auto_increment,
3207  `ObjectName` varchar(50) NOT NULL,
3208  `TableRating` varchar(50) NOT NULL,
3209  `TableTrack` varchar(50) NOT NULL,
3210  `RowPrefix` varchar(20) NOT NULL,
3211  `MaxVotes` smallint(2) NOT NULL,
3212  `PostName` varchar(50) NOT NULL,
3213  `IsDuplicate` varchar(80) NOT NULL,
3214  `IsOn` smallint(1) NOT NULL,
3215  `className` varchar(50) NOT NULL default '',
3216  `classFile` varchar(100) NOT NULL default '',
3217  `TriggerTable` varchar(32) NOT NULL,
3218  `TriggerFieldRate` varchar(32) NOT NULL,
3219  `TriggerFieldRateCount` varchar(32) NOT NULL,
3220  `TriggerFieldId` varchar(32) NOT NULL,
3221  `OverrideClassName` varchar(32) NOT NULL,
3222  `OverrideClassFile` varchar(256) NOT NULL,
3223  PRIMARY KEY  (`ID`)
3224) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3225
3226--
3227-- Dumping data for table `sys_objects_vote`
3228--
3229
3230INSERT INTO `sys_objects_vote` VALUES(1, 'profile', 'sys_profile_rating', 'sys_profile_voting_track', 'pr_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'Profiles', 'Rate', 'RateCount', 'ID', '', '');
3231
3232
3233-- -------------------------------------------------------
3234
3235ALTER TABLE `RayMp3Files` ADD FULLTEXT KEY `ftMain` (`Title`, `Tags`, `Description`, `Categories`);
3236ALTER TABLE `RayMp3Files` ADD FULLTEXT KEY `ftTags` (`Tags`);
3237ALTER TABLE `RayMp3Files` ADD FULLTEXT KEY `ftCategories` (`Categories`);
3238
3239ALTER TABLE `RayVideoFiles` ADD FULLTEXT KEY `ftMain` (`Title`, `Tags`, `Description`, `Categories`);
3240ALTER TABLE `RayVideoFiles` ADD FULLTEXT KEY `ftTags` (`Tags`);
3241ALTER TABLE `RayVideoFiles` ADD FULLTEXT KEY `ftCategories` (`Categories`);
3242
3243--
3244-- Table structure for table `sys_modules`
3245--
3246
3247CREATE TABLE `sys_modules` (
3248  `id` int(11) unsigned NOT NULL auto_increment,
3249  `title` varchar(255) NOT NULL default '',
3250  `vendor` varchar(64) NOT NULL default '',
3251  `version` varchar(32) NOT NULL default '',
3252  `update_url` varchar(128) NOT NULL default '',
3253  `path` varchar(255) NOT NULL default '', 
3254  `uri` varchar(32) NOT NULL default '',
3255  `class_prefix` varchar(32) NOT NULL default '',
3256  `db_prefix` varchar(32) NOT NULL default '',
3257  `dependencies` varchar(255) NOT NULL default '',
3258  `date` int(11) unsigned NOT NULL default '0', 
3259  PRIMARY KEY  (`id`),
3260  UNIQUE KEY `path` (`path`),
3261  UNIQUE KEY `uri` (`uri`),
3262  UNIQUE KEY `class_prefix` (`class_prefix`),
3263  UNIQUE KEY `db_prefix` (`db_prefix`)
3264) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3265
3266--
3267-- Table structure for table `sys_modules_file_tracks`
3268--
3269CREATE TABLE `sys_modules_file_tracks` (
3270  `id` int(11) unsigned NOT NULL auto_increment,
3271  `module_id` int(11) unsigned NOT NULL default '0',
3272  `file` varchar(255) NOT NULL default '',
3273  `hash` varchar(64) NOT NULL default '', 
3274  PRIMARY KEY  (`id`)
3275) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3276
3277--
3278-- Table structure for table `sys_injections`
3279--
3280
3281CREATE TABLE `sys_injections` (
3282  `id` int(11) unsigned NOT NULL auto_increment,
3283  `name` varchar(128) NOT NULL default '',
3284  `page_index` int(11) NOT NULL default '0',
3285  `key` varchar(128) NOT NULL default '',
3286  `type` enum('text', 'php') NOT NULL default 'text',
3287  `data` text NOT NULL default '',
3288  `replace` TINYINT NOT NULL DEFAULT '0',
3289  `active` TINYINT NOT NULL DEFAULT '1',
3290  PRIMARY KEY  (`id`)
3291) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3292
3293--
3294-- Dumping data for table `sys_injections`
3295--
3296INSERT INTO `sys_injections` (`name`, `page_index`, `key`, `type`, `data`, `replace`, `active`) VALUES
3297('flash_integration', '0', 'injection_header', 'php', 'return getRayIntegrationJS(true);', '0', '1'),
3298('site_search', '0', 'injection_logo_before', 'php', 'return $GLOBALS[''oFunctions'']->genSiteSearch();', '0', '1'),
3299('site_service_menu', '0', 'injection_logo_after', 'php', 'return $GLOBALS[''oFunctions'']->genSiteServiceMenu();', '0', '1'),
3300('banner_bottom', 0, 'banner_bottom', 'php', 'return banner_put_nv(4);', 0, 1),
3301('banner_right', 0, 'banner_right', 'php', 'return banner_put_nv(3);', 0, 1),
3302('banner_top', 0, 'banner_top', 'php', 'return banner_put_nv(1);', 0, 1),
3303('banner_left', 0, 'banner_left', 'php', 'return banner_put_nv(2);', 0, 1);
3304
3305--
3306-- Table structure for table `sys_injections_admin`
3307--
3308
3309CREATE TABLE `sys_injections_admin` (
3310  `id` int(11) unsigned NOT NULL auto_increment,
3311  `name` varchar(128) NOT NULL default '',
3312  `page_index` int(11) NOT NULL default '0',
3313  `key` varchar(128) NOT NULL default '',
3314  `type` enum('text','php') NOT NULL default 'text',
3315  `data` text NOT NULL,
3316  `replace` tinyint(4) NOT NULL default '0',
3317  `active` tinyint(4) NOT NULL default '1',
3318  PRIMARY KEY (`id`)
3319) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3320
3321--
3322-- Dumping data for table `sys_injections`
3323--
3324INSERT INTO `sys_injections_admin` (`name`, `page_index`, `key`, `type`, `data`, `replace`, `active`) VALUES
3325('flash_integration', '0', 'injection_header', 'php', 'return getRayIntegrationJS();', '0', '1'),
3326('lfa', '0', 'injection_header', 'php', 'return lfa();', '0', '1');
3327
3328--
3329-- Table structure for table `sys_permalinks`
3330--
3331
3332CREATE TABLE `sys_permalinks` (
3333  `id` int(11) unsigned NOT NULL auto_increment,
3334  `standard` varchar(128) NOT NULL default '',
3335  `permalink` varchar(128) NOT NULL default '',
3336  `check` varchar(64) NOT NULL default '',
3337  PRIMARY KEY  (`id`),
3338  UNIQUE KEY `check` (`standard`, `permalink`, `check`)
3339) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3340
3341--
3342-- Table structure for table `sys_alerts_handlers`
3343--
3344CREATE TABLE `sys_alerts_handlers` (
3345  `id` int(11) unsigned NOT NULL auto_increment,
3346  `name` varchar(128) NOT NULL default '',
3347  `class` varchar(128) NOT NULL default '',
3348  `file` varchar(255) NOT NULL default '',
3349  `eval` text NOT NULL default '',
3350  PRIMARY KEY  (`id`),
3351  UNIQUE KEY `name` (`name`)
3352) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3353
3354--
3355-- Dumping data for table `sys_alerts_handlers`
3356--
3357INSERT INTO `sys_alerts_handlers` (`id`, `name`, `class`, `file`) VALUES
3358(1, 'system', 'BxDolAlertsResponseSystem', 'inc/classes/BxDolAlertsResponseSystem.php'),
3359(2, 'profile', 'BxDolAlertsResponseProfile', 'inc/classes/BxDolAlertsResponseProfile.php'),
3360(3, 'membersData', 'BxDolUpdateMembersCache', 'inc/classes/BxDolUpdateMembersCache.php'),
3361(4, 'profileMatch', 'BxDolAlertsResponceMatch', 'inc/classes/BxDolAlertsResponceMatch.php');
3362
3363--
3364-- Table structure for table `sys_alerts`
3365--
3366CREATE TABLE `sys_alerts` (
3367  `id` int(11) unsigned NOT NULL auto_increment, 
3368  `unit` varchar(64) NOT NULL default '',
3369  `action` varchar(64) NOT NULL default 'none',
3370  `handler_id` int(11) NOT NULL default '0',
3371  PRIMARY KEY (`id`),
3372  UNIQUE KEY `alert_handler` (`unit`, `action`, `handler_id`)
3373) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3374
3375--
3376-- Dumping data for table `sys_alerts`
3377--
3378INSERT INTO `sys_alerts` (`unit`, `action`, `handler_id`) VALUES
3379('system', 'begin', 1),
3380('profile', 'before_join', 2),
3381('profile', 'join', 2),
3382('profile', 'before_login', 2),
3383('profile', 'login', 2),
3384('profile', 'logout', 2),
3385('profile', 'edit', 2),
3386('profile', 'join', 3),
3387('profile', 'edit', 3),
3388('profile', 'delete', 3),
3389('profile', 'join', 4),
3390('profile', 'edit', 4),
3391('profile', 'delete', 4),
3392('profile', 'change_status', 4);
3393
3394
3395--
3396-- Deleting video comments handler
3397--
3398INSERT INTO `sys_alerts_handlers`(`name`, `class`, `file`) VALUES('bx_videos_comments_delete', 'BxDolVideoDeleteResponse', 'flash/modules/video_comments/inc/classes/BxDolVideoDeleteResponse.php');
3399SET @iHandlerId = (SELECT LAST_INSERT_ID());
3400INSERT INTO `sys_alerts`(`unit`, `action`, `handler_id`) VALUES('profile', 'commentRemoved', @iHandlerId);
3401
3402-- --------------------------------------------------------
3403
3404--
3405-- Table structure for table `sys_objects_views`
3406--
3407
3408CREATE TABLE `sys_objects_views` (
3409  `id` int(11) NOT NULL auto_increment,
3410  `name` varchar(32) NOT NULL,
3411  `table_track` varchar(32) NOT NULL,
3412  `period` int(11) NOT NULL default '86400',
3413  `trigger_table` varchar(32) NOT NULL,
3414  `trigger_field_id` varchar(32) NOT NULL,
3415  `trigger_field_views` varchar(32) NOT NULL,
3416  `is_on` tinyint(4) NOT NULL default '1',
3417  PRIMARY KEY  (`id`)
3418) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3419
3420--
3421-- Dumping data for table `sys_objects_views`
3422--
3423
3424INSERT INTO `sys_objects_views` VALUES(NULL, 'profiles', 'sys_profile_views_track', 86400, 'Profiles', 'ID', 'Views', 1);
3425
3426--
3427-- Table structure for table `sys_privacy_groups`
3428--
3429CREATE TABLE `sys_privacy_groups` (
3430  `id` int(11) unsigned NOT NULL auto_increment,
3431  `owner_id` int(11) NOT NULL default '0',
3432  `parent_id` int(11) NOT NULL default '0',
3433  `title` varchar(255) NOT NULL default '',
3434  `home_url` varchar(255) NOT NULL default '',
3435  `get_parent` text NOT NULL default '',
3436  `get_content` text NOT NULL default '',
3437  `members_count` int(11) NOT NULL default '0',
3438  PRIMARY KEY  (`id`)
3439) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3440
3441--
3442-- Dumping data for table `sys_privacy_groups`
3443--
3444INSERT INTO `sys_privacy_groups`(`id`, `owner_id`, `parent_id`, `title`, `home_url`, `get_parent`, `get_content`, `members_count`) VALUES
3445('1', '0', '0', '', '', '$aProfile = getProfileInfo($arg1); return (int)$aProfile[\'PrivacyDefaultGroup\'];', '', 0),
3446('2', '0', '0', '', '', '', 'return false;', 0),
3447('3', '0', '0', '', '', '', 'return true;', 0),
3448('4', '0', '0', '', '', '', 'return isMember() && isProfileActive($arg2);', 0),
3449('5', '0', '0', '', 'communicator.php?communicator_mode=friends_list', '', '$aIds = $arg0->fromMemory($arg0->_sGroupFriendsCache . $arg1, "getColumn", "SELECT `p`.`ID` AS `id` FROM `Profiles` AS `p` LEFT JOIN `sys_friend_list` AS `f1` ON (`f1`.`ID`=`p`.`ID` AND `f1`.`Profile`=\'" . $arg1 . "\' AND `f1`.`Check`=1) LEFT JOIN `sys_friend_list` AS `f2` ON (`f2`.`Profile`=p.`ID` AND `f2`.`ID`=\'" . $arg1 . "\' AND `f2`.`Check`=1) WHERE 1 AND (`f1`.`ID` IS NOT NULL OR `f2`.`ID` IS NOT NULL)"); return isProfileActive($arg2) && in_array($arg2, $aIds);', 0),
3450('6', '0', '0', '', 'communicator.php?&communicator_mode=hotlist_requests', '', '$aIds = $arg0->fromMemory($arg0->_sGroupFavesCache . $arg1, "getColumn", "SELECT `Profile` AS `id` FROM `sys_fave_list` WHERE `ID`=\'" . $arg1 . "\'"); return isProfileActive($arg2) && in_array($arg2, $aIds);', 0),
3451('7', '0', '0', '', 'mail.php?&mode=inbox&contacts_mode=Contacted', '', '$aIds = $arg0->fromMemory($arg0->_sGroupContactsCache . $arg1, "getColumn", "SELECT `tp`.`ID` AS `id` FROM `sys_messages` AS `tm` INNER JOIN `Profiles` AS `tp` ON (`tm`.`Sender`=`tp`.`ID` AND `tm`.`Recipient`=\'" . $arg1 . "\') OR (`tm`.`Recipient`=`tp`.`ID` AND `tm`.`Sender`=\'" . $arg1 . "\')"); return isProfileActive($arg2) && in_array($arg2, $aIds);', 0),
3452('8', '0', '0', '', '', '', '', 0);
3453
3454--
3455-- Table structure for table `sys_privacy_members`
3456--
3457CREATE TABLE `sys_privacy_members` (
3458  `id` int(11) NOT NULL auto_increment, 
3459  `group_id` int(11) NOT NULL default '0',
3460  `member_id` int(11) NOT NULL default '0',
3461  PRIMARY KEY  (`id`),
3462  UNIQUE KEY `group_member` (`group_id`, `member_id`)
3463) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3464
3465--
3466-- Table structure for table `sys_privacy_actions`
3467--
3468CREATE TABLE `sys_privacy_actions` (
3469  `id` int(11) NOT NULL auto_increment, 
3470  `module_uri` varchar(64) NOT NULL default '',
3471  `name` varchar(255) NOT NULL default '',
3472  `title` varchar(255) NOT NULL default '',
3473  `default_group` varchar(255) NOT NULL default '1',
3474  PRIMARY KEY  (`id`),
3475  UNIQUE KEY `action` (`module_uri`, `name` )
3476) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3477
3478--
3479-- Dumping data for table `sys_privacy_actions`
3480--
3481INSERT INTO `sys_privacy_actions`(`module_uri`, `name`, `title`, `default_group`) VALUES
3482('profile', 'view_block', '_ps_view_block', '3');
3483
3484--
3485-- Table structure for table `sys_privacy_defaults`
3486--
3487CREATE TABLE `sys_privacy_defaults` ( 
3488  `owner_id` int(11) NOT NULL default '0',
3489  `action_id` int(11) NOT NULL default '0',
3490  `group_id` int(11) NOT NULL default '0',
3491  PRIMARY KEY  (`owner_id`, `action_id`)
3492) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3493
3494--
3495-- Table structure for table `sys_sbs_users`
3496--
3497CREATE TABLE `sys_sbs_users` (
3498  `id` int(11) NOT NULL auto_increment,
3499  `name` varchar(64) NOT NULL default '',
3500  `email` varchar(64) NOT NULL default '',
3501  `date` int(11) unsigned NOT NULL default '0',
3502  PRIMARY KEY (`id`),
3503  UNIQUE KEY `subscriber` (`name`, `email`)
3504) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3505
3506--
3507-- Table structure for table `sys_sbs_entries`
3508--
3509CREATE TABLE `sys_sbs_entries` (
3510  `id` int(11) NOT NULL auto_increment,
3511  `subscriber_id` int(11) NOT NULL default '0',
3512  `subscriber_type` tinyint(4) NOT NULL default '0',
3513  `subscription_id` int(11) NOT NULL default '0', 
3514  `object_id` int(11) NOT NULL default '0', 
3515  PRIMARY KEY (`id`),
3516  UNIQUE KEY `entry` (`subscriber_id`, `subscriber_type`, `subscription_id`, `object_id`)
3517) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3518
3519--
3520-- Table structure for table `sys_sbs_types`
3521--
3522CREATE TABLE `sys_sbs_types` ( 
3523  `id` int(11) NOT NULL auto_increment,
3524  `unit` varchar(32) NOT NULL default '',
3525  `action` varchar(32) NOT NULL default '',
3526  `template` varchar(64) NOT NULL default '',
3527  `params` text NOT NULL default '',
3528  PRIMARY KEY (`id`),
3529  UNIQUE KEY `subscription` (`unit`, `action`, `template`)
3530) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3531
3532--
3533-- Dumping data for table `sys_sbs_types`
3534--
3535INSERT INTO `sys_sbs_types`(`unit`, `action`, `template`, `params`) VALUES
3536('system', '', '', 'return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_mass_mailer''), ''ViewLink'' => BX_DOL_URL_ROOT));'),
3537('system', 'mass_mailer', 't_AdminEmail', 'return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_mass_mailer''), ''ViewLink'' => BX_DOL_URL_ROOT));'),
3538('profile', '', '', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));'),
3539('profile', 'commentPost', 't_sbsProfileComments', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile_comments'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));'),
3540('profile', 'edit', 't_sbsProfileEdit', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile_edit'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));');
3541
3542--
3543-- Table structure for table `sys_sbs_queue`
3544--
3545CREATE TABLE `sys_sbs_queue` (
3546  `id` int(11) NOT NULL auto_increment,
3547  `email` varchar(64) NOT NULL default '',
3548  `subject` varchar(255) NOT NULL default '',
3549  `body` text NOT NULL default '',
3550  PRIMARY KEY (`id`)
3551) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3552
3553--
3554-- Table structure for table `sys_sbs_messages`
3555--
3556CREATE TABLE `sys_sbs_messages` (
3557  `id` int(10) unsigned NOT NULL auto_increment,
3558  `subject` varchar(128) NOT NULL default '', 
3559  `body` mediumtext NOT NULL,
3560  PRIMARY KEY  (`ID`)
3561) ENGINE=MyISAM DEFAULT CHARSET=utf8;
3562
3563--
3564-- Table structure for table `sys_box_download`
3565--
3566CREATE TABLE IF NOT EXISTS `sys_box_download` (
3567  `id` int(11) NOT NULL auto_increment,
3568  `title` varchar(64) NOT NULL,
3569  `url` varchar(255) NOT NULL,
3570  `onclick` varchar(255) NOT NULL,
3571  `desc` text NOT NULL,
3572  `icon` varchar(255) NOT NULL,
3573  `order` int(11) NOT NULL,
3574  `disabled` tinyint(4) NOT NULL,
3575  PRIMARY KEY  (`id`)
3576) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3577
3578INSERT INTO `sys_box_download` (`id`, `title`, `url`, `onclick`, `desc`, `icon`, `order`, `disabled`) VALUES
3579(1, '_sbd_iPhone_title', 'http://itunes.apple.com/us/app/oo/id345450186', '', '_sbd_iPhone_desc', 'iphone.png', 2, 0),
3580(2, '_sbd_Android_title', 'https://play.google.com/store/apps/details?id=com.boonex.oo', '', '_sbd_Android_desc', 'android.png', 3, 0);
3581
3582
3583--
3584-- Table structure for table `sys_cron_jobs`
3585--
3586
3587CREATE TABLE `sys_cron_jobs` (
3588  `id` int(11) unsigned NOT NULL auto_increment,
3589  `name` varchar(128) NOT NULL default '',
3590  `time` varchar(128) NOT NULL default '*',
3591  `class` varchar(128) NOT NULL default '',
3592  `file` varchar(255) NOT NULL default '',
3593  `eval` text NOT NULL default '',
3594  PRIMARY KEY  (`id`)
3595) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3596
3597--
3598-- Dumping data for table `sys_cron_jobs`
3599--
3600
3601INSERT INTO `sys_cron_jobs` (`name`, `time`, `class`, `file`, `eval`) VALUES
3602('cmd', '0 0 * * *', 'BxDolCronCmd', 'inc/classes/BxDolCronCmd.php', ''),
3603('notifies', '*/10 * * * *', 'BxDolCronNotifies', 'inc/classes/BxDolCronNotifies.php', ''),
3604('video_comments', '* * * * *', 'BxDolCronVideoComments', 'flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php', ''),
3605('sitemap', '0 2 * * *', '', '', 'bx_import(''BxDolSiteMaps'');\r\nBxDolSiteMaps::generateAllSiteMaps();');
3606
3607
3608-- --------------------------------------------------------
3609
3610
3611CREATE TABLE IF NOT EXISTS `sys_dnsbl_rules` (
3612  `id` int(11) NOT NULL AUTO_INCREMENT,
3613  `chain` enum('spammers','whitelist','uridns') NOT NULL,
3614  `zonedomain` varchar(255) NOT NULL,
3615  `postvresp` varchar(32) NOT NULL,
3616  `url` varchar(255) NOT NULL,
3617  `recheck` varchar(255) NOT NULL,
3618  `comment` varchar(255) NOT NULL,
3619  `added` int(11) NOT NULL,
3620  `active` tinyint(4) NOT NULL,
3621  PRIMARY KEY (`id`)
3622) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3623
3624INSERT INTO `sys_dnsbl_rules` (`id`, `chain`, `zonedomain`, `postvresp`, `url`, `recheck`, `comment`, `added`, `active`) VALUES
3625(1, 'whitelist', 'au.countries.nerd.dk.', '127.0.0.2', 'http://countries.nerd.dk/', '', 'Country based zone, any ip from Australia is whitelisted', 1287642420, 0),
3626(2, 'spammers', 'sbl.spamhaus.org.', 'any', 'http://www.spamhaus.org/sbl/', 'http://www.spamhaus.org/query/bl?ip=%s', 'Any non-failure result from sbl.spamhaus.org is a positive match', 1287642420, 1),
3627(4, 'spammers', 'cn.countries.nerd.dk.', '127.0.0.2', 'http://countries.nerd.dk/', '', 'Country based zone, any ip from China is blocked', 1287642420, 0),
3628(5, 'uridns', 'multi.surbl.org.', 'any', 'http://www.surbl.org/', 'http://george.surbl.org/lookup.html', 'SURBLs are lists of web sites that have appeared in unsolicited messages. Unlike most lists, SURBLs are not lists of message senders.', 1287642420, 1);
3629
3630CREATE TABLE IF NOT EXISTS `sys_antispam_block_log` (
3631  `ip` int(10) unsigned NOT NULL,
3632  `member_id` int(10) unsigned NOT NULL,
3633  `type` varchar(32) NOT NULL,
3634  `extra` text NOT NULL,
3635  `added` int(11) NOT NULL,
3636  KEY `ip` (`ip`),
3637  KEY `member_id` (`member_id`)
3638) ENGINE=MyISAM DEFAULT CHARSET=utf8;
3639
3640CREATE TABLE IF NOT EXISTS `sys_dnsbluri_zones` (
3641  `level` tinyint(4) NOT NULL,
3642  `zone` varchar(64) NOT NULL
3643) ENGINE=MyISAM DEFAULT CHARSET=utf8;
3644
3645-- --------------------------------------------------------
3646
3647CREATE TABLE IF NOT EXISTS `sys_menu_mobile_pages` (
3648  `id` int(11) NOT NULL AUTO_INCREMENT,
3649  `page` varchar(32) NOT NULL,
3650  `title` varchar(255) NOT NULL,
3651  `order` int(11) NOT NULL,
3652  PRIMARY KEY (`id`),
3653  UNIQUE KEY `page` (`page`)
3654) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3655
3656INSERT INTO `sys_menu_mobile_pages` (`id`, `page`, `title`, `order`) VALUES
3657(1, 'homepage', '_adm_mobile_page_homepage', 1),
3658(2, 'profile', '_adm_mobile_page_profile', 2),
3659(3, 'search', '_adm_mobile_page_search', 3);
3660
3661CREATE TABLE IF NOT EXISTS `sys_menu_mobile` (
3662  `id` int(11) NOT NULL AUTO_INCREMENT,
3663  `type` varchar(32) NOT NULL,
3664  `page` varchar(32) NOT NULL,
3665  `title` varchar(255) NOT NULL,
3666  `icon` varchar(255) NOT NULL,
3667  `action` int(11) NOT NULL,
3668  `action_data` varchar(255) NOT NULL,
3669  `eval_bubble` text NOT NULL,
3670  `eval_hidden` text NOT NULL,
3671  `order` int(11) NOT NULL,
3672  `active` int(11) NOT NULL,
3673  PRIMARY KEY (`id`)
3674) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3675
3676INSERT INTO `sys_menu_mobile` (`type`, `page`, `title`, `icon`, `action`, `action_data`, `eval_bubble`, `eval_hidden`, `order`, `active`) VALUES
3677('system', 'homepage', '_sys_mobile_status', 'home_status.png', 1, '', '', '', 1, 1),
3678('system', 'homepage', '_sys_mobile_mail', 'home_messages.png', 3, '', 'return getNewLettersNum({member_id});', '', 2, 1),
3679('system', 'homepage', '_sys_mobile_friends', 'home_friends.png', 4, '', 'return getFriendRequests({member_id});', '', 3, 1),
3680('system', 'homepage', '_sys_mobile_info', 'home_info.png', 5, '', '', '', 4, 1),
3681('system', 'homepage', '_sys_mobile_search', 'home_search.png', 6, '', '', '', 5, 1),
3682('system', 'profile', '_sys_mobile_profile_info', '', 5, '', '', '', 1, 1),
3683('system', 'profile', '_sys_mobile_profile_contact', '', 3, '', '', '', 2, 1),
3684('system', 'profile', '_sys_mobile_profile_friends', '', 4, '', 'return getFriendNumber(''{profile_id}'');', '', 3, 1),
3685('system', 'search', '_sys_mobile_search_by_keyword', '', 30, '', '', '', 1, 1),
3686('system', 'search', '_sys_mobile_search_by_location', '', 31, '', '', '', 2, 1);
3687
3688
3689-- --------------------------------------------------------
3690
3691
3692CREATE TABLE IF NOT EXISTS `sys_objects_social_sharing` (
3693  `id` int(11) NOT NULL AUTO_INCREMENT,
3694  `object` varchar(32) NOT NULL,
3695  `content` text NOT NULL,
3696  `order` int(11) NOT NULL,
3697  `active` tinyint(4) NOT NULL,
3698  PRIMARY KEY (`id`)
3699) ENGINE=MyISAM DEFAULT CHARSET=utf8;
3700
3701INSERT INTO `sys_objects_social_sharing` (`object`, `content`, `order`, `active`) VALUES
3702('facebook', '<iframe src="//www.facebook.com/plugins/like.php?href={url_encoded}&amp;send=false&amp;layout=button_count&amp;width=450&amp;show_faces=false&amp;action=like&amp;colorscheme=light&amp;font&amp;height=21&amp;locale={locale}" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:100%; height:21px;" allowTransparency="true"></iframe>', 1, 1),
3703('googleplus', '<div style="height:21px;">\r\n<div class="g-plusone" data-size="medium" data-href="{url}"></div>\r\n<script type="text/javascript">\r\n  window.___gcfg = {lang: ''{lang}''};\r\(function() {\r\n    var po = document.createElement(''script''); po.type = ''text/javascript''; po.async = true;\r\n    po.src = ''https://apis.google.com/js/plusone.js'';\r\n    var s = document.getElementsByTagName(''script'')[0]; s.parentNode.insertBefore(po, s);\r\})();\r\n</script>\r\n</div>', 2, 1),
3704('twitter', '<iframe allowtransparency="true" frameborder="0" scrolling="no" src="//platform.twitter.com/widgets/tweet_button.html?url={url_encoded}&amp;text={title_encoded}&amp;size=medium&amp;count=horizontal&amp;lang={lang}" style="width:100%;height:21px;"></iframe>', 3, 1),
3705('pinterest', '<a href="http://pinterest.com/pin/create/button/?url={url_encoded}&media={img_url_encoded}&description={title_encoded}" class="pin-it-button" count-layout="horizontal"><img border="0" src="//assets.pinterest.com/images/PinExt.png" title="Pin It" /></a>\r\n\r\n<script type="text/javascript" src="//assets.pinterest.com/js/pinit.js"></script>', 4, 1);
3706
3707
3708-- --------------------------------------------------------
3709
3710
3711CREATE TABLE IF NOT EXISTS `sys_objects_site_maps` (
3712  `id` int(11) NOT NULL AUTO_INCREMENT,
3713  `object` varchar(32) NOT NULL,
3714  `title` varchar(255) NOT NULL,
3715  `priority` varchar(5) NOT NULL DEFAULT '0.6',
3716  `changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never','auto') NOT NULL DEFAULT 'auto',
3717  `class_name` varchar(255) NOT NULL,
3718  `class_file` varchar(255) NOT NULL,
3719  `order` tinyint(4) NOT NULL,
3720  `active` tinyint(4) NOT NULL,
3721  PRIMARY KEY (`id`),
3722  UNIQUE KEY `object` (`object`)
3723) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3724
3725INSERT INTO `sys_objects_site_maps` (`object`, `title`, `priority`, `changefreq`, `class_name`, `class_file`, `order`, `active`) VALUES
3726('system', '_sys_sitemap_system', '0.6', 'weekly', 'BxDolSiteMapsSystem', '', 1, 1),
3727('profiles', '_sys_sitemap_profiles', '0.8', 'daily', 'BxDolSiteMapsProfiles', '', 2, 1),
3728('profiles_info', '_sys_sitemap_profiles_info', '0.8', 'daily', 'BxDolSiteMapsProfilesInfo', '', 3, 1),
3729('pages', '_sys_sitemap_pages', '0.8', 'weekly', 'BxDolSiteMapsPages', '', 4, 1);
3730
3731
3732-- --------------------------------------------------------
3733
3734
3735CREATE TABLE IF NOT EXISTS `sys_objects_charts` (
3736  `id` int(11) NOT NULL AUTO_INCREMENT,
3737  `object` varchar(32) NOT NULL,
3738  `title` varchar(255) NOT NULL,
3739  `table` varchar(255) NOT NULL,
3740  `field_date_ts` varchar(255) NOT NULL,
3741  `field_date_dt` varchar(255) NOT NULL,
3742  `column_date` int(11) NOT NULL DEFAULT '0',
3743  `column_count` int(11) NOT NULL DEFAULT '1',
3744  `type` varchar(255) NOT NULL,
3745  `options` text NOT NULL,
3746  `query` text NOT NULL,
3747  `active` tinyint(4) NOT NULL DEFAULT '1',
3748  `order` int(11) NOT NULL,
3749  PRIMARY KEY (`id`),
3750  UNIQUE KEY `object` (`object`)
3751) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3752
3753INSERT INTO `sys_objects_charts` (`object`, `title`, `table`, `field_date_ts`, `field_date_dt`, `query`, `active`, `order`) VALUES
3754('sys_profiles', '_Members', 'Profiles', '', 'DateReg', '', 1, 1),
3755('sys_subscribers', '_Subscribers', 'sys_sbs_users', 'date', '', '', 1, 2),
3756('sys_messages', '_Messages', 'sys_messages', '', 'Date', '', 1, 3),
3757('sys_greetings', '_Greetings', 'sys_greetings', '', 'When', '', 1, 4),
3758('sys_tags', '_Tags', 'sys_tags', '', 'Date', '', 1, 5),
3759('sys_categories', '_Categories', 'sys_categories', '', 'Date', '', 1, 6),
3760('sys_banners', '_adm_bann_clicks_chart', 'sys_banners_clicks', 'Date', '', '', 1, 7);
3761
3762
3763-- --------------------------------------------------------
3764
3765
3766CREATE TABLE `sys_objects_captcha` (
3767  `id` int(11) NOT NULL AUTO_INCREMENT,
3768  `object` varchar(32) NOT NULL,
3769  `title` varchar(255) NOT NULL,
3770  `override_class_name` varchar(255) NOT NULL,
3771  `override_class_file` varchar(255) NOT NULL,
3772  PRIMARY KEY (`id`)
3773) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3774
3775INSERT INTO `sys_objects_captcha` (`object`, `title`, `override_class_name`, `override_class_file`) VALUES
3776('sys_recaptcha', 'reCAPTCHA', 'BxTemplCaptchaReCAPTCHA', '');
3777
3778
3779-- --------------------------------------------------------
3780
3781
3782CREATE TABLE `sys_objects_editor` (
3783  `id` int(11) NOT NULL AUTO_INCREMENT,
3784  `object` varchar(32) NOT NULL,
3785  `title` varchar(255) NOT NULL,
3786  `skin` varchar(255) NOT NULL,
3787  `override_class_name` varchar(255) NOT NULL,
3788  `override_class_file` varchar(255) NOT NULL,
3789  PRIMARY KEY (`id`),
3790  UNIQUE KEY `object` (`object`)
3791) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3792
3793INSERT INTO `sys_objects_editor` (`object`, `title`, `skin`, `override_class_name`, `override_class_file`) VALUES
3794('sys_tinymce', 'TinyMCE', 'default', 'BxTemplEditorTinyMCE', '');
3795
3796
3797-- --------------------------------------------------------
3798
3799
3800CREATE TABLE IF NOT EXISTS `sys_objects_member_info` (
3801  `id` int(11) NOT NULL AUTO_INCREMENT,
3802  `object` varchar(32) NOT NULL,
3803  `title` varchar(255) NOT NULL,
3804  `type` varchar(32) NOT NULL,
3805  `override_class_name` varchar(255) NOT NULL,
3806  `override_class_file` varchar(255) NOT NULL,
3807  PRIMARY KEY (`id`)
3808) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
3809
3810INSERT INTO `sys_objects_member_info` (`object`, `title`, `type`, `override_class_name`, `override_class_file`) VALUES
3811('sys_username', '_sys_member_info_username', 'name', '', ''),
3812('sys_first_name', '_sys_member_info_first_name', 'name', '', ''),
3813('sys_first_name_last_name', '_sys_member_info_first_name_last_name', 'name', '', ''),
3814('sys_last_name_firs_name', '_sys_member_info_last_name_firs_name', 'name', '', ''),
3815('sys_headline', '_sys_member_info_headline', 'info', '', ''),
3816('sys_status_message', '_sys_member_info_status_message', 'info', '', ''),
3817('sys_age_sex', '_sys_member_info_age_sex', 'info', '', ''),
3818('sys_location', '_sys_member_info_location', 'info', '', ''),
3819('sys_avatar', '_sys_member_thumb_avatar', 'thumb', '', ''),
3820('sys_avatar_icon', '_sys_member_thumb_icon_avatar', 'thumb_icon', '', '');
3821
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
Fork me on GitHub