HomeHelpTrac

Ignore:
Timestamp:
04/06/09 04:21:27 (3 years ago)
Author:
Andrey Prikaznov
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/install/sql/v70.sql

    r9970 r9972  
    66 
    77SET NAMES 'utf8'; 
    8 DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_links`, `sys_admin_menu`, `sys_admin_menu_categ`, `Admins`, `aff`, `sys_aff_banners`, `sys_aff_members`, `alerts`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_objects_browse`, `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`, `GlParams`, `sys_options_cats`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `groups_rating`, `groups_voting_track`, `grp_forum`, `grp_forum_cat`, `grp_forum_flag`, `grp_forum_post`, `grp_forum_report`, `grp_forum_topic`, `grp_forum_user`, `grp_forum_user_activity`, `grp_forum_user_stat`, `grp_forum_vote`, `sys_fave_list`, `IPList`, `IPMembersVisits`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `sys_acl_actions`, `sys_acl_actions_track`, `members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `moderators`, `Modules`, `News`, `sys_subscriptions`, `sys_mass_messages`, `sys_mail_queue`, `PageCompose`, `PageComposePages`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `sys_stat_member`, `PreValues`, `ProfileFields`, `sys_acl_levels_members`, `Profiles`, `profile_views_track`, `ProfilesMatch`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `SearchObjects`, `sharedSites`, `sys_stat_site`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `TagObjects`, `TopMenu`, `Transactions`, `sys_objects_actions`, `Greetings`, `Votes`, `ZIPCodes`, `VoteObjects`, `sys_objects_views`, `sys_box_download`; 
     8DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_links`, `sys_admin_menu`, `sys_admin_menu_categ`, `Admins`, `aff`, `sys_aff_banners`, `sys_aff_members`, `alerts`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_objects_browse`, `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`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `groups_rating`, `groups_voting_track`, `grp_forum`, `grp_forum_cat`, `grp_forum_flag`, `grp_forum_post`, `grp_forum_report`, `grp_forum_topic`, `grp_forum_user`, `grp_forum_user_activity`, `grp_forum_user_stat`, `grp_forum_vote`, `sys_fave_list`, `IPList`, `IPMembersVisits`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `sys_acl_actions`, `sys_acl_actions_track`, `members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `moderators`, `News`, `sys_subscriptions`, `sys_mail_mass_messages`, `sys_mail_queue`, `PageCompose`, `PageComposePages`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `sys_stat_member`, `PreValues`, `ProfileFields`, `sys_acl_levels_members`, `Profiles`, `profile_views_track`, `ProfilesMatch`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `SearchObjects`, `sharedSites`, `sys_stat_site`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `TagObjects`, `TopMenu`, `Transactions`, `sys_objects_actions`, `Greetings`, `Votes`, `ZIPCodes`, `VoteObjects`, `sys_objects_views`, `sys_box_download`; 
    99ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'; 
    1010 
     
    10991099 
    11001100-- 
    1101 -- Table structure for table `GlParams` 
    1102 -- 
    1103  
    1104 CREATE TABLE `GlParams` ( 
     1101-- Table structure for table `sys_options` 
     1102-- 
     1103 
     1104CREATE TABLE `sys_options` ( 
    11051105  `Name` varchar(64) NOT NULL default '', 
    11061106  `VALUE` mediumtext NOT NULL, 
     
    11171117 
    11181118-- 
    1119 -- Dumping data for table `GlParams` 
    1120 -- 
    1121  
    1122 INSERT INTO `GlParams` VALUES('anon_mode', '', 1, 'Anonymous mode (no contact information)', 'checkbox', '', '', 12, ''); 
    1123 INSERT INTO `GlParams` VALUES('autoApproval_ifJoin', 'on', 6, 'Automatic profile activation after joining', 'checkbox', '', '', NULL, ''); 
    1124 INSERT INTO `GlParams` VALUES('autoApproval_ifProfile', 'on', 6, 'Do not change profile status after editing profile information', 'checkbox', '', '', NULL, ''); 
    1125 INSERT INTO `GlParams` VALUES('cmdDay', '10', 0, '', 'digit', '', '', NULL, ''); 
    1126 INSERT INTO `GlParams` VALUES('currency_code', 'USD', 0, 'Currency code (for checkout system)', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', NULL, 'USD,EURO'); 
    1127 INSERT INTO `GlParams` VALUES('currency_sign', '$', 15, 'Currency sign (for display purposes only)', 'digit', 'return strlen($arg0) > 0;', 'cannot be empty.', 9, ''); 
    1128 INSERT INTO `GlParams` VALUES('date_format', '%m-%d-%y %H:%i', 15, 'Long Date Format <a href="#" onclick="javascript: window.open(''/admin/help.html'', ''DateFormat'', ''width=500,height=400,scrollbars=yes,menubar=no,resizable=no''); return false;">?</a>', 'digit', '', '', 15, ''); 
    1129 INSERT INTO `GlParams` VALUES('db_clean_msg', '180', 11, 'Clean old messages ( days )', 'digit', '', '', NULL, ''); 
    1130 INSERT INTO `GlParams` VALUES('db_clean_profiles', '180', 11, 'Clean old profiles by last log in ( days )', 'digit', '', '', NULL, ''); 
    1131 INSERT INTO `GlParams` VALUES('db_clean_views', '180', 11, 'Clean old profile views ( days )', 'digit', '', '', NULL, ''); 
    1132 INSERT INTO `GlParams` VALUES('db_clean_vkiss', '90', 11, 'Clean old greetings ( days )', 'digit', '', '', NULL, ''); 
    1133 INSERT INTO `GlParams` VALUES('default_country', 'US', 51, 'Default Country on Index Page', 'text', '', '', NULL, ''); 
    1134 INSERT INTO `GlParams` VALUES('enable_aff', '', 15, 'Enable affiliate support', 'checkbox', '', '', 1, ''); 
    1135 INSERT INTO `GlParams` VALUES('enable_contact_form', 'on', 15, 'Show contact form on contact us page', 'checkbox', '', '', 2, ''); 
    1136 INSERT INTO `GlParams` VALUES('enable_cupid', 'on', 12, 'Enable cupid mails', 'checkbox', '', '', NULL, ''); 
    1137 INSERT INTO `GlParams` VALUES('enable_customization', 'on', 1, 'Enable profile customization', 'checkbox', '', '', 10, ''); 
    1138 INSERT INTO `GlParams` VALUES('enable_gd', 'on', 15, 'Use GD library for image processing', 'checkbox', '', '', 5, ''); 
    1139 INSERT INTO `GlParams` VALUES('enable_inbox_notify', '', 17, 'Enable new message notifications', 'checkbox', '', '', NULL, ''); 
    1140 INSERT INTO `GlParams` VALUES('enable_match', 'on', 12, 'Enable matchmaking', 'checkbox', '', '', NULL, ''); 
    1141 INSERT INTO `GlParams` VALUES('enable_msg_dest_choice', 'on', 17, 'Enable message destination user choice', 'checkbox', '', '', NULL, ''); 
    1142 INSERT INTO `GlParams` VALUES('enable_promotion_membership', 'on', 7, 'Enable promotional membership', 'checkbox', '', '', 1, ''); 
    1143 INSERT INTO `GlParams` VALUES('enable_recurring', 'on', 0, 'Enable recurring billings', 'checkbox', '', '', NULL, ''); 
    1144 INSERT INTO `GlParams` VALUES('enable_template', '', 15, 'Enable Users to Change Templates', 'checkbox', '', '', NULL, ''); 
    1145 INSERT INTO `GlParams` VALUES('enable_watermark', '', 16, 'Enable Watermark', 'checkbox', '', '', 1, ''); 
    1146 INSERT INTO `GlParams` VALUES('enable_zip_loc', 'on', 15, 'Enable search by ZIP codes', 'checkbox', '', '', 0, ''); 
    1147 INSERT INTO `GlParams` VALUES('expire_notification_days', '1', 5, 'Number of days before membership expiration to notify members ( -1 = after expiration )', 'digit', '', '', NULL, ''); 
    1148 INSERT INTO `GlParams` VALUES('expire_notify_once', 'on', 5, 'Notify members about membership expiration only once (every day otherwise)', 'checkbox', '', '', NULL, ''); 
    1149 INSERT INTO `GlParams` VALUES('featured_num', '16', 51, 'Number of featured members displayed on front page', 'digit', 'return $arg0 >= 0;', 'must be equal to or greater than zero.', NULL, ''); 
    1150 INSERT INTO `GlParams` VALUES('free_mode', 'on', 0, 'Site is running in free mode', 'checkbox', '', '', NULL, ''); 
    1151 INSERT INTO `GlParams` VALUES('lang_default', 'en', 0, 'Default site language', 'text', '', '', NULL, ''); 
    1152 INSERT INTO `GlParams` VALUES('match_percent', '70', 12, 'Send a cupid mail if the recently joined profile matches more than this percentage', 'digit', '', '', NULL, ''); 
    1153 -- INSERT INTO `GlParams` VALUES('max_inbox_messages', '5', 3, 'Maximum number of messages stored in inbox', 'digit', '', '', 3, ''); 
    1154 INSERT INTO `GlParams` VALUES('max_inbox_message_size', '1500', 3, 'Maximum message size in symbols', 'digit', '', '', 4, ''); 
    1155 INSERT INTO `GlParams` VALUES('member_online_time', '5', 3, 'Time period in minutes within which a member is considered to be online', 'digit', '', '', 5, ''); 
    1156 INSERT INTO `GlParams` VALUES('MetaDescription', '', 19, 'Insert Meta description on site  pages', 'text', '', '', NULL, ''); 
    1157 INSERT INTO `GlParams` VALUES('MetaKeyWords', '', 19, 'Insert Meta keywords on site pages (comma-separated list)', 'text', '', '', NULL, ''); 
    1158 INSERT INTO `GlParams` VALUES('msgs_per_start', '20', 8, 'Send emails from queue, it happens every cron execution (5m-1h)', 'digit', '', '', NULL, ''); 
    1159 INSERT INTO `GlParams` VALUES('news_enable', '1', 0, 'show boonex news in admin panel', 'digit', '', '', NULL, ''); 
    1160 INSERT INTO `GlParams` VALUES('newusernotify', 'on', 1, 'New User Notify', 'checkbox', '', '', 2, ''); 
    1161 INSERT INTO `GlParams` VALUES('promotion_membership_days', '7', 7, 'Number of days for promotional membership', 'digit', '', '', 2, ''); 
    1162 INSERT INTO `GlParams` VALUES('search_end_age', '75', 1, 'Highest age possible for site members', 'digit', '', '', 21, ''); 
    1163 INSERT INTO `GlParams` VALUES('search_start_age', '18', 1, 'Lowest age possible for site members', 'digit', '', '', 20, ''); 
    1164 INSERT INTO `GlParams` VALUES('short_date_format', '%m-%d-%y', 15, 'Short Date Format <a href="#" onclick="javascript: window.open(''/admin/help.html'', ''DateFormat'', ''width=500,height=400,scrollbars=yes,menubar=no,resizable=no''); return false;">?</a>', 'digit', '', '', 14, ''); 
    1165 INSERT INTO `GlParams` VALUES('template', 'uni', 15, 'Template', 'combobox', 'global $dir; return (strlen($arg0) > 0 && file_exists($dir["root"]."templates/tmpl_".$arg0) ) ? true : false;', 'cannot be empty and template must be valid.', 17, ''); 
    1166 INSERT INTO `GlParams` VALUES('sys_calendar_starts_sunday', '', 15, 'Is calendar starts from Sunday?', 'checkbox', '', '', '18', ''); 
    1167 INSERT INTO `GlParams` VALUES('top_members_max_num', '16', 51, 'How many results show on index page in top members area', 'digit', '', '', NULL, ''); 
    1168 INSERT INTO `GlParams` VALUES('track_profile_view', 'on', 1, 'Track all profile views. Later a member can manage these "views".', 'checkbox', '', '', 1, ''); 
    1169 INSERT INTO `GlParams` VALUES('transparent1', '0', 16, 'Transparency for first image', 'digit', '', '', 2, ''); 
    1170 INSERT INTO `GlParams` VALUES('transparent2', '15', 16, 'Transparency for second image', 'digit', '', '', NULL, ''); 
    1171 INSERT INTO `GlParams` VALUES('votes', 'on', 1, 'Enable profile votes', 'checkbox', '', '', 5, ''); 
    1172 INSERT INTO `GlParams` VALUES('Water_Mark', '', 16, 'Water Mark', 'text', '', '', 3, ''); 
    1173 INSERT INTO `GlParams` VALUES('zodiac', '', 1, 'Show zodiac signs', 'checkbox', '', '', 9, ''); 
    1174 INSERT INTO `GlParams` VALUES('php_date_format', 'F j, Y', 15, 'PHP date format', 'digit', '', '', 16, ''); 
    1175 INSERT INTO `GlParams` VALUES('group_img_width', '600', 24, 'Gallery max image width', 'digit', '', '', 1, ''); 
    1176 INSERT INTO `GlParams` VALUES('group_img_height', '600', 24, 'Gallery max image height', 'digit', '', '', 2, ''); 
    1177 INSERT INTO `GlParams` VALUES('group_img_tmb_width', '100', 24, 'Gallery max image thumb width', 'digit', '', '', 3, ''); 
    1178 INSERT INTO `GlParams` VALUES('group_img_tmb_height', '100', 24, 'Gallery max image thumb height', 'digit', '', '', 4, ''); 
    1179 INSERT INTO `GlParams` VALUES('group_invitation_text', '<b>{sender}</b> has invited you to join <b>{group}</b>.<br />\r\nGroups allow users to communicate on the forums on interesting topics, share pictures, etc.<br />\r\nYou may accept or reject this invitation below:<br />\r\n<b>{accept} &nbsp; &nbsp; &nbsp; {reject}</b>', 24, 'Group invitation text', 'text', '', '', 5, ''); 
    1180 INSERT INTO `GlParams` VALUES('group_approve_notify', 'The creator of the {group} allows you to join the group.<br />\r\nNow you''re an active member of this group and you can share your opinion, post images and communicate on message boards.\r\n', 24, 'Group member approve notification', 'text', '', '', 6, ''); 
    1181 INSERT INTO `GlParams` VALUES('group_creator_request', 'Hello, {creator}.<br />\r\nMember {member} would like to join your group {group}.<br />\r\nYou may approve or reject this join request below:<br />\r\n{approve} &nbsp; &nbsp; &nbsp; {reject}', 24, 'Request message to group creator', 'text', '', '', 8, ''); 
    1182 INSERT INTO `GlParams` VALUES('group_reject_notify', 'Dear {member},<br />\r\nSorry but the creator of the group {group} doesn''t allow you to join the group. If you wish try again later.\r\n', 24, 'Group member reject notification', 'text', '', '', 7, ''); 
    1183 INSERT INTO `GlParams` VALUES('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', 25, 'Non-parsable tags (type all tags in lower case, delimit them by comma)', 'text', '', '', 0, ''); 
    1184 INSERT INTO `GlParams` VALUES('tags_last_parse_time', '0', 0, 'Temporary value when tags cron-job was runed last time', 'digit', '', '', NULL, ''); 
    1185 INSERT INTO `GlParams` VALUES('tags_min_rating', '2', 25, 'Minimum rating of tag to show it', 'digit', '', '', 2, ''); 
    1186 INSERT INTO `GlParams` VALUES('autoApproval_ifNoConfEmail', 'on', 6, 'Automatic profile confirmation without Confirmation Email', 'checkbox', '', '', NULL, ''); 
    1187 INSERT INTO `GlParams` VALUES('enable_flash_promo', 'on', 0, '', 'checkbox', '', '', NULL, ''); 
    1188 INSERT INTO `GlParams` VALUES('custom_promo_code', '', 0, '', 'text', '', '', NULL, ''); 
    1189 INSERT INTO `GlParams` VALUES('license_code', '', 1, 'Dolphin License Code', 'digit', '', '', 0, ''); 
    1190 INSERT INTO `GlParams` VALUES('enable_dolphin_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 
    1191 INSERT INTO `GlParams` VALUES('enable_ray_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 
    1192 -- INSERT INTO `GlParams` VALUES('topmenu_items_perline', '0', 15, 'Number of items per line in top menu. 0 - no breaking.', 'digit', '', '', 20, ''); 
    1193 INSERT INTO `GlParams` VALUES('enable_modrewrite', 'on', 26, 'Enable friendly profile permalinks', 'checkbox', '', '', 1, ''); 
    1194 INSERT INTO `GlParams` VALUES('permalinks_groups', 'on', 26, 'Enable friendly groups permalinks', 'checkbox', '', '', 10, ''); 
    1195 INSERT INTO `GlParams` VALUES('cupid_last_cron', '0', 0, 'Temporary value when cupid mails checked was runed last time', 'text', '', '', NULL, ''); 
    1196 INSERT INTO `GlParams` VALUES('reg_by_inv_only', '', 3, 'Registration by invitation only (need before Enable affiliate support)', 'checkbox', '', '', 13, ''); 
    1197 INSERT INTO `GlParams` VALUES('main_div_width', '960px', 0, 'Width of the main container of the site', 'digit', '', '', 0, ''); 
    1198 INSERT INTO `GlParams` VALUES('promoWidth', '960', 0, 'Default Width of the Promo Images for resizing', 'digit', '', '', 0, ''); 
    1199 INSERT INTO `GlParams` VALUES('profile_gallery_feature', '', 3, 'New Gallery Feature for Shared Photos', 'checkbox', '', '', NULL, ''); 
    1200 INSERT INTO `GlParams` VALUES('boonexAffID', '', 1, 'My BoonEx Affiliate ID', 'digit', '', '', 0.5, ''); 
    1201 INSERT INTO `GlParams` VALUES('ipBlacklistMode', '1', 3, 'IP Blacklist system mode (1 - total block, 2 - login block)', 'digit', '', '', NULL, ''); 
    1202 INSERT INTO `GlParams` VALUES('ipListGlobalType', '3', 3, 'IP List Type (1 - all allowed except listed, 2 - all blocked except listed, 0 - disabled)', 'digit', '', '', NULL, ''); 
    1203 INSERT INTO `GlParams` VALUES('enable_member_store_ip', 'on', 3, 'When a member login into dolphin 6 that the IP address from that person will be saved into the database', 'checkbox', '', '', NULL, ''); 
    1204 INSERT INTO `GlParams` VALUES('site_email', 'xxx@gmail.com', 50, 'Site Email', 'digit', '', '', NULL, ''); 
    1205 INSERT INTO `GlParams` VALUES('site_title', 'Unite Community', 50, 'Site Title', 'digit', '', '', NULL, ''); 
    1206 INSERT INTO `GlParams` VALUES('site_email_notify', 'xxx2@gmail.com', 50, 'Site Email Notify', 'digit', '', '', NULL, ''); 
    1207 INSERT INTO `GlParams` VALUES('enable_html_in_comments', 'on', 3, 'Enable HTML in comments', 'checkbox', '', '', NULL, ''); 
    1208 INSERT INTO `GlParams` VALUES('enable_tiny_in_comments', '', 3, 'Enable TinyMCS in comments', 'checkbox', '', '', NULL, ''); 
    1209 INSERT INTO `GlParams` VALUES('enable_global_couple', 'on', 3, 'Global Enabling of Couples', 'checkbox', '', '', NULL, ''); 
    1210 INSERT INTO `GlParams` VALUES('enable_new_dhtml_popups', 'on', 3, 'Enable new DHTML notifications rather than popup', 'checkbox', '', '', NULL, ''); 
    1211 INSERT INTO `GlParams` VALUES('dbCleanAlert', '2', 3, 'Clean old user alerts', 'digit', '', '', 5, ''); 
    1212 INSERT INTO `GlParams` VALUES('galleryFiles_user', '2', 23, 'Number of gallery files relate to user', 'digit', '', '', 21, ''); 
    1213 INSERT INTO `GlParams` VALUES('galleryFiles_keyword', '2', 23, 'Number of related gallery files', 'digit', '', '', 22, ''); 
    1214 INSERT INTO `GlParams` VALUES('enable_cache_system', 'on', 3, 'Enable caching system to store profiles information', 'checkbox', '', '', NULL, ''); 
    1215 INSERT INTO `GlParams` VALUES('nav_menu_elements_on_line', '12', 3, 'The number of elements in the navigation menu which will be desplayed before the More link (line)', 'digit', '', '', 15, ''); 
    1216 INSERT INTO `GlParams` VALUES('ext_nav_menu_on_line_bottom', '11', 3, 'The number of elements in the additional members menu which will be desplayed (in bottom position )', 'digit', '', '', 17, ''); 
    1217 INSERT INTO `GlParams` VALUES('enable_guest_comments', '', 3, 'enable possibility to post comments by guests', 'checkbox', '', '', NULL, ''); 
    1218 INSERT INTO `GlParams` VALUES('permalinks_browse', 'on', 26, 'Enable friendly browse permalinks', 'checkbox', '', '', 12, ''); 
    1219 INSERT INTO `GlParams` VALUES('sys_ntns_ajax_mode', 'on', 1, 'Enable Ajax mode for Notifications', 'checkbox', '', '', 23, ''); 
    1220 INSERT INTO `GlParams` VALUES('sys_ntns_update_interval', '10', 1, 'Notification''s update interval in seconds(for Ajax mode only)', 'digit', '', '', 24, ''); 
    1221 INSERT INTO `GlParams` VALUES('sys_ntns_expiration_time', '30', 1, 'Notification''s expiration time in minutes', 'digit', '', '', 25, ''); 
    1222 INSERT INTO `GlParams` VALUES('sys_ntns_display_number', '3', 1, 'Notification''s display number', 'digit', '', '', 26, ''); 
    1223 INSERT INTO `GlParams` VALUES('promo_relocation_link_visitor', 'join.php', 3, 'Default relocation link to Promo for non-members', 'text', '', '', NULL, ''); 
    1224 INSERT INTO `GlParams` VALUES('promo_relocation_link_member', 'member.php', 3, 'Default relocation link to Promo for members', 'text', '', '', NULL, ''); 
    1225 INSERT INTO `GlParams` VALUES('leaders_male_types', 'year,month,week,day', 3, 'Period types of leaders for male', 'select', '', '', NULL, 'year,month,week,day'); 
    1226 INSERT INTO `GlParams` VALUES('leaders_female_types', 'year,month,week,day', 3, 'Period types of leaders for female', 'select', '', '', NULL, 'year,month,week,day'); 
    1227 INSERT INTO `GlParams` VALUES('useLikeOperator', '', 15, 'Use operator LIKE for search (recommended for small content)', 'checkbox', '', '', 21, ''); 
    1228 INSERT INTO `GlParams` VALUES('ext_nav_menu_top_position', 'bottom', 15, 'Member menu position', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', 16, 'top,bottom,static'); 
    1229 INSERT INTO `GlParams` VALUES('sys_ps_enabled_group_2', 'on', 9, 'Enable \'All\' group', 'checkbox', '', '', 1, ''); 
    1230 INSERT INTO `GlParams` VALUES('sys_ps_enabled_group_3', 'on', 9, 'Enable \'Friends\' group', 'checkbox', '', '', 2, ''); 
    1231 INSERT INTO `GlParams` VALUES('sys_ps_enabled_group_4', 'on', 9, 'Enable \'Faves\' group', 'checkbox', '', '', 3, ''); 
    1232 INSERT INTO `GlParams` VALUES('sys_ps_enabled_group_5', 'on', 9, 'Enable \'Contacts\' group', 'checkbox', '', '', 4, ''); 
    1233 INSERT INTO `GlParams` VALUES('sys_make_album_cover_last', 'on', 1, 'Set last object as cover of album', 'checkbox', '', '', 20, ''); 
    1234 INSERT INTO `GlParams` VALUES('sys_album_auto_app', 'on', 1, 'Autoapproval for albums', 'checkbox', '', '', 21, ''); 
    1235 INSERT INTO `GlParams` VALUES('sys_album_default_name', 'Unsorted', 0, 'Default album name', 'text', '', '', 22, ''); 
     1119-- Dumping data for table `sys_options` 
     1120-- 
     1121 
     1122INSERT INTO `sys_options` VALUES('anon_mode', '', 1, 'Anonymous mode (no contact information)', 'checkbox', '', '', 12, ''); 
     1123INSERT INTO `sys_options` VALUES('autoApproval_ifJoin', 'on', 6, 'Automatic profile activation after joining', 'checkbox', '', '', NULL, ''); 
     1124INSERT INTO `sys_options` VALUES('autoApproval_ifProfile', 'on', 6, 'Do not change profile status after editing profile information', 'checkbox', '', '', NULL, ''); 
     1125INSERT INTO `sys_options` VALUES('cmdDay', '10', 0, '', 'digit', '', '', NULL, ''); 
     1126INSERT INTO `sys_options` VALUES('currency_code', 'USD', 0, 'Currency code (for checkout system)', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', NULL, 'USD,EURO'); 
     1127INSERT INTO `sys_options` VALUES('currency_sign', '$', 15, 'Currency sign (for display purposes only)', 'digit', 'return strlen($arg0) > 0;', 'cannot be empty.', 9, ''); 
     1128INSERT INTO `sys_options` VALUES('date_format', '%m-%d-%y %H:%i', 15, 'Long Date Format <a href="#" onclick="javascript: window.open(''/admin/help.html'', ''DateFormat'', ''width=500,height=400,scrollbars=yes,menubar=no,resizable=no''); return false;">?</a>', 'digit', '', '', 15, ''); 
     1129INSERT INTO `sys_options` VALUES('db_clean_msg', '180', 11, 'Clean old messages ( days )', 'digit', '', '', NULL, ''); 
     1130INSERT INTO `sys_options` VALUES('db_clean_profiles', '180', 11, 'Clean old profiles by last log in ( days )', 'digit', '', '', NULL, ''); 
     1131INSERT INTO `sys_options` VALUES('db_clean_views', '180', 11, 'Clean old profile views ( days )', 'digit', '', '', NULL, ''); 
     1132INSERT INTO `sys_options` VALUES('db_clean_vkiss', '90', 11, 'Clean old greetings ( days )', 'digit', '', '', NULL, ''); 
     1133INSERT INTO `sys_options` VALUES('default_country', 'US', 51, 'Default Country on Index Page', 'text', '', '', NULL, ''); 
     1134INSERT INTO `sys_options` VALUES('enable_aff', '', 15, 'Enable affiliate support', 'checkbox', '', '', 1, ''); 
     1135INSERT INTO `sys_options` VALUES('enable_contact_form', 'on', 15, 'Show contact form on contact us page', 'checkbox', '', '', 2, ''); 
     1136INSERT INTO `sys_options` VALUES('enable_cupid', 'on', 12, 'Enable cupid mails', 'checkbox', '', '', NULL, ''); 
     1137INSERT INTO `sys_options` VALUES('enable_customization', 'on', 1, 'Enable profile customization', 'checkbox', '', '', 10, ''); 
     1138INSERT INTO `sys_options` VALUES('enable_gd', 'on', 15, 'Use GD library for image processing', 'checkbox', '', '', 5, ''); 
     1139INSERT INTO `sys_options` VALUES('enable_inbox_notify', '', 17, 'Enable new message notifications', 'checkbox', '', '', NULL, ''); 
     1140INSERT INTO `sys_options` VALUES('enable_match', 'on', 12, 'Enable matchmaking', 'checkbox', '', '', NULL, ''); 
     1141INSERT INTO `sys_options` VALUES('enable_msg_dest_choice', 'on', 17, 'Enable message destination user choice', 'checkbox', '', '', NULL, ''); 
     1142INSERT INTO `sys_options` VALUES('enable_promotion_membership', 'on', 7, 'Enable promotional membership', 'checkbox', '', '', 1, ''); 
     1143INSERT INTO `sys_options` VALUES('enable_recurring', 'on', 0, 'Enable recurring billings', 'checkbox', '', '', NULL, ''); 
     1144INSERT INTO `sys_options` VALUES('enable_template', '', 15, 'Enable Users to Change Templates', 'checkbox', '', '', NULL, ''); 
     1145INSERT INTO `sys_options` VALUES('enable_watermark', '', 16, 'Enable Watermark', 'checkbox', '', '', 1, ''); 
     1146INSERT INTO `sys_options` VALUES('enable_zip_loc', 'on', 15, 'Enable search by ZIP codes', 'checkbox', '', '', 0, ''); 
     1147INSERT INTO `sys_options` VALUES('expire_notification_days', '1', 5, 'Number of days before membership expiration to notify members ( -1 = after expiration )', 'digit', '', '', NULL, ''); 
     1148INSERT INTO `sys_options` VALUES('expire_notify_once', 'on', 5, 'Notify members about membership expiration only once (every day otherwise)', 'checkbox', '', '', NULL, ''); 
     1149INSERT INTO `sys_options` VALUES('featured_num', '16', 51, 'Number of featured members displayed on front page', 'digit', 'return $arg0 >= 0;', 'must be equal to or greater than zero.', NULL, ''); 
     1150INSERT INTO `sys_options` VALUES('free_mode', 'on', 0, 'Site is running in free mode', 'checkbox', '', '', NULL, ''); 
     1151INSERT INTO `sys_options` VALUES('lang_default', 'en', 0, 'Default site language', 'text', '', '', NULL, ''); 
     1152INSERT INTO `sys_options` VALUES('match_percent', '70', 12, 'Send a cupid mail if the recently joined profile matches more than this percentage', 'digit', '', '', NULL, ''); 
     1153-- INSERT INTO `sys_options` VALUES('max_inbox_messages', '5', 3, 'Maximum number of messages stored in inbox', 'digit', '', '', 3, ''); 
     1154INSERT INTO `sys_options` VALUES('max_inbox_message_size', '1500', 3, 'Maximum message size in symbols', 'digit', '', '', 4, ''); 
     1155INSERT INTO `sys_options` VALUES('member_online_time', '5', 3, 'Time period in minutes within which a member is considered to be online', 'digit', '', '', 5, ''); 
     1156INSERT INTO `sys_options` VALUES('MetaDescription', '', 19, 'Insert Meta description on site  pages', 'text', '', '', NULL, ''); 
     1157INSERT INTO `sys_options` VALUES('MetaKeyWords', '', 19, 'Insert Meta keywords on site pages (comma-separated list)', 'text', '', '', NULL, ''); 
     1158INSERT INTO `sys_options` VALUES('msgs_per_start', '20', 8, 'Send emails from queue, it happens every cron execution (5m-1h)', 'digit', '', '', NULL, ''); 
     1159INSERT INTO `sys_options` VALUES('news_enable', '1', 0, 'show boonex news in admin panel', 'digit', '', '', NULL, ''); 
     1160INSERT INTO `sys_options` VALUES('newusernotify', 'on', 1, 'New User Notify', 'checkbox', '', '', 2, ''); 
     1161INSERT INTO `sys_options` VALUES('promotion_membership_days', '7', 7, 'Number of days for promotional membership', 'digit', '', '', 2, ''); 
     1162INSERT INTO `sys_options` VALUES('search_end_age', '75', 1, 'Highest age possible for site members', 'digit', '', '', 21, ''); 
     1163INSERT INTO `sys_options` VALUES('search_start_age', '18', 1, 'Lowest age possible for site members', 'digit', '', '', 20, ''); 
     1164INSERT INTO `sys_options` VALUES('short_date_format', '%m-%d-%y', 15, 'Short Date Format <a href="#" onclick="javascript: window.open(''/admin/help.html'', ''DateFormat'', ''width=500,height=400,scrollbars=yes,menubar=no,resizable=no''); return false;">?</a>', 'digit', '', '', 14, ''); 
     1165INSERT INTO `sys_options` VALUES('template', 'uni', 15, 'Template', 'combobox', 'global $dir; return (strlen($arg0) > 0 && file_exists($dir["root"]."templates/tmpl_".$arg0) ) ? true : false;', 'cannot be empty and template must be valid.', 17, ''); 
     1166INSERT INTO `sys_options` VALUES('sys_calendar_starts_sunday', '', 15, 'Is calendar starts from Sunday?', 'checkbox', '', '', '18', ''); 
     1167INSERT INTO `sys_options` VALUES('top_members_max_num', '16', 51, 'How many results show on index page in top members area', 'digit', '', '', NULL, ''); 
     1168INSERT INTO `sys_options` VALUES('track_profile_view', 'on', 1, 'Track all profile views. Later a member can manage these "views".', 'checkbox', '', '', 1, ''); 
     1169INSERT INTO `sys_options` VALUES('transparent1', '0', 16, 'Transparency for first image', 'digit', '', '', 2, ''); 
     1170INSERT INTO `sys_options` VALUES('transparent2', '15', 16, 'Transparency for second image', 'digit', '', '', NULL, ''); 
     1171INSERT INTO `sys_options` VALUES('votes', 'on', 1, 'Enable profile votes', 'checkbox', '', '', 5, ''); 
     1172INSERT INTO `sys_options` VALUES('Water_Mark', '', 16, 'Water Mark', 'text', '', '', 3, ''); 
     1173INSERT INTO `sys_options` VALUES('zodiac', '', 1, 'Show zodiac signs', 'checkbox', '', '', 9, ''); 
     1174INSERT INTO `sys_options` VALUES('php_date_format', 'F j, Y', 15, 'PHP date format', 'digit', '', '', 16, ''); 
     1175INSERT INTO `sys_options` VALUES('group_img_width', '600', 24, 'Gallery max image width', 'digit', '', '', 1, ''); 
     1176INSERT INTO `sys_options` VALUES('group_img_height', '600', 24, 'Gallery max image height', 'digit', '', '', 2, ''); 
     1177INSERT INTO `sys_options` VALUES('group_img_tmb_width', '100', 24, 'Gallery max image thumb width', 'digit', '', '', 3, ''); 
     1178INSERT INTO `sys_options` VALUES('group_img_tmb_height', '100', 24, 'Gallery max image thumb height', 'digit', '', '', 4, ''); 
     1179INSERT INTO `sys_options` VALUES('group_invitation_text', '<b>{sender}</b> has invited you to join <b>{group}</b>.<br />\r\nGroups allow users to communicate on the forums on interesting topics, share pictures, etc.<br />\r\nYou may accept or reject this invitation below:<br />\r\n<b>{accept} &nbsp; &nbsp; &nbsp; {reject}</b>', 24, 'Group invitation text', 'text', '', '', 5, ''); 
     1180INSERT INTO `sys_options` VALUES('group_approve_notify', 'The creator of the {group} allows you to join the group.<br />\r\nNow you''re an active member of this group and you can share your opinion, post images and communicate on message boards.\r\n', 24, 'Group member approve notification', 'text', '', '', 6, ''); 
     1181INSERT INTO `sys_options` VALUES('group_creator_request', 'Hello, {creator}.<br />\r\nMember {member} would like to join your group {group}.<br />\r\nYou may approve or reject this join request below:<br />\r\n{approve} &nbsp; &nbsp; &nbsp; {reject}', 24, 'Request message to group creator', 'text', '', '', 8, ''); 
     1182INSERT INTO `sys_options` VALUES('group_reject_notify', 'Dear {member},<br />\r\nSorry but the creator of the group {group} doesn''t allow you to join the group. If you wish try again later.\r\n', 24, 'Group member reject notification', 'text', '', '', 7, ''); 
     1183INSERT INTO `sys_options` VALUES('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', 25, 'Non-parsable tags (type all tags in lower case, delimit them by comma)', 'text', '', '', 0, ''); 
     1184INSERT INTO `sys_options` VALUES('tags_last_parse_time', '0', 0, 'Temporary value when tags cron-job was runed last time', 'digit', '', '', NULL, ''); 
     1185INSERT INTO `sys_options` VALUES('tags_min_rating', '2', 25, 'Minimum rating of tag to show it', 'digit', '', '', 2, ''); 
     1186INSERT INTO `sys_options` VALUES('autoApproval_ifNoConfEmail', 'on', 6, 'Automatic profile confirmation without Confirmation Email', 'checkbox', '', '', NULL, ''); 
     1187INSERT INTO `sys_options` VALUES('enable_flash_promo', 'on', 0, '', 'checkbox', '', '', NULL, ''); 
     1188INSERT INTO `sys_options` VALUES('custom_promo_code', '', 0, '', 'text', '', '', NULL, ''); 
     1189INSERT INTO `sys_options` VALUES('license_code', '', 1, 'Dolphin License Code', 'digit', '', '', 0, ''); 
     1190INSERT INTO `sys_options` VALUES('enable_dolphin_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 
     1191INSERT INTO `sys_options` VALUES('enable_ray_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 
     1192-- INSERT INTO `sys_options` VALUES('topmenu_items_perline', '0', 15, 'Number of items per line in top menu. 0 - no breaking.', 'digit', '', '', 20, ''); 
     1193INSERT INTO `sys_options` VALUES('enable_modrewrite', 'on', 26, 'Enable friendly profile permalinks', 'checkbox', '', '', 1, ''); 
     1194INSERT INTO `sys_options` VALUES('permalinks_groups', 'on', 26, 'Enable friendly groups permalinks', 'checkbox', '', '', 10, ''); 
     1195INSERT INTO `sys_options` VALUES('cupid_last_cron', '0', 0, 'Temporary value when cupid mails checked was runed last time', 'text', '', '', NULL, ''); 
     1196INSERT INTO `sys_options` VALUES('reg_by_inv_only', '', 3, 'Registration by invitation only (need before Enable affiliate support)', 'checkbox', '', '', 13, ''); 
     1197INSERT INTO `sys_options` VALUES('main_div_width', '960px', 0, 'Width of the main container of the site', 'digit', '', '', 0, ''); 
     1198INSERT INTO `sys_options` VALUES('promoWidth', '960', 0, 'Default Width of the Promo Images for resizing', 'digit', '', '', 0, ''); 
     1199INSERT INTO `sys_options` VALUES('profile_gallery_feature', '', 3, 'New Gallery Feature for Shared Photos', 'checkbox', '', '', NULL, ''); 
     1200INSERT INTO `sys_options` VALUES('boonexAffID', '', 1, 'My BoonEx Affiliate ID', 'digit', '', '', 0.5, ''); 
     1201INSERT INTO `sys_options` VALUES('ipBlacklistMode', '1', 3, 'IP Blacklist system mode (1 - total block, 2 - login block)', 'digit', '', '', NULL, ''); 
     1202INSERT INTO `sys_options` VALUES('ipListGlobalType', '3', 3, 'IP List Type (1 - all allowed except listed, 2 - all blocked except listed, 0 - disabled)', 'digit', '', '', NULL, ''); 
     1203INSERT INTO `sys_options` VALUES('enable_member_store_ip', 'on', 3, 'When a member login into dolphin 6 that the IP address from that person will be saved into the database', 'checkbox', '', '', NULL, ''); 
     1204INSERT INTO `sys_options` VALUES('site_email', 'xxx@gmail.com', 50, 'Site Email', 'digit', '', '', NULL, ''); 
     1205INSERT INTO `sys_options` VALUES('site_title', 'Unite Community', 50, 'Site Title', 'digit', '', '', NULL, ''); 
     1206INSERT INTO `sys_options` VALUES('site_email_notify', 'xxx2@gmail.com', 50, 'Site Email Notify', 'digit', '', '', NULL, ''); 
     1207INSERT INTO `sys_options` VALUES('enable_html_in_comments', 'on', 3, 'Enable HTML in comments', 'checkbox', '', '', NULL, ''); 
     1208INSERT INTO `sys_options` VALUES('enable_tiny_in_comments', '', 3, 'Enable TinyMCS in comments', 'checkbox', '', '', NULL, ''); 
     1209INSERT INTO `sys_options` VALUES('enable_global_couple', 'on', 3, 'Global Enabling of Couples', 'checkbox', '', '', NULL, ''); 
     1210INSERT INTO `sys_options` VALUES('enable_new_dhtml_popups', 'on', 3, 'Enable new DHTML notifications rather than popup', 'checkbox', '', '', NULL, ''); 
     1211INSERT INTO `sys_options` VALUES('dbCleanAlert', '2', 3, 'Clean old user alerts', 'digit', '', '', 5, ''); 
     1212INSERT INTO `sys_options` VALUES('galleryFiles_user', '2', 23, 'Number of gallery files relate to user', 'digit', '', '', 21, ''); 
     1213INSERT INTO `sys_options` VALUES('galleryFiles_keyword', '2', 23, 'Number of related gallery files', 'digit', '', '', 22, ''); 
     1214INSERT INTO `sys_options` VALUES('enable_cache_system', 'on', 3, 'Enable caching system to store profiles information', 'checkbox', '', '', NULL, ''); 
     1215INSERT INTO `sys_options` VALUES('nav_menu_elements_on_line', '12', 3, 'The number of elements in the navigation menu which will be desplayed before the More link (line)', 'digit', '', '', 15, ''); 
     1216INSERT INTO `sys_options` VALUES('ext_nav_menu_on_line_bottom', '11', 3, 'The number of elements in the additional members menu which will be desplayed (in bottom position )', 'digit', '', '', 17, ''); 
     1217INSERT INTO `sys_options` VALUES('enable_guest_comments', '', 3, 'enable possibility to post comments by guests', 'checkbox', '', '', NULL, ''); 
     1218INSERT INTO `sys_options` VALUES('permalinks_browse', 'on', 26, 'Enable friendly browse permalinks', 'checkbox', '', '', 12, ''); 
     1219INSERT INTO `sys_options` VALUES('sys_ntns_ajax_mode', 'on', 1, 'Enable Ajax mode for Notifications', 'checkbox', '', '', 23, ''); 
     1220INSERT INTO `sys_options` VALUES('sys_ntns_update_interval', '10', 1, 'Notification''s update interval in seconds(for Ajax mode only)', 'digit', '', '', 24, ''); 
     1221INSERT INTO `sys_options` VALUES('sys_ntns_expiration_time', '30', 1, 'Notification''s expiration time in minutes', 'digit', '', '', 25, ''); 
     1222INSERT INTO `sys_options` VALUES('sys_ntns_display_number', '3', 1, 'Notification''s display number', 'digit', '', '', 26, ''); 
     1223INSERT INTO `sys_options` VALUES('promo_relocation_link_visitor', 'join.php', 3, 'Default relocation link to Promo for non-members', 'text', '', '', NULL, ''); 
     1224INSERT INTO `sys_options` VALUES('promo_relocation_link_member', 'member.php', 3, 'Default relocation link to Promo for members', 'text', '', '', NULL, ''); 
     1225INSERT INTO `sys_options` VALUES('leaders_male_types', 'year,month,week,day', 3, 'Period types of leaders for male', 'select', '', '', NULL, 'year,month,week,day'); 
     1226INSERT INTO `sys_options` VALUES('leaders_female_types', 'year,month,week,day', 3, 'Period types of leaders for female', 'select', '', '', NULL, 'year,month,week,day'); 
     1227INSERT INTO `sys_options` VALUES('useLikeOperator', '', 15, 'Use operator LIKE for search (recommended for small content)', 'checkbox', '', '', 21, ''); 
     1228INSERT INTO `sys_options` VALUES('ext_nav_menu_top_position', 'bottom', 15, 'Member menu position', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', 16, 'top,bottom,static'); 
     1229INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_2', 'on', 9, 'Enable \'All\' group', 'checkbox', '', '', 1, ''); 
     1230INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_3', 'on', 9, 'Enable \'Friends\' group', 'checkbox', '', '', 2, ''); 
     1231INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_4', 'on', 9, 'Enable \'Faves\' group', 'checkbox', '', '', 3, ''); 
     1232INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_5', 'on', 9, 'Enable \'Contacts\' group', 'checkbox', '', '', 4, ''); 
     1233INSERT INTO `sys_options` VALUES('sys_make_album_cover_last', 'on', 1, 'Set last object as cover of album', 'checkbox', '', '', 20, ''); 
     1234INSERT INTO `sys_options` VALUES('sys_album_auto_app', 'on', 1, 'Autoapproval for albums', 'checkbox', '', '', 21, ''); 
     1235INSERT INTO `sys_options` VALUES('sys_album_default_name', 'Unsorted', 0, 'Default album name', 'text', '', '', 22, ''); 
    12361236 
    12371237-- -------------------------------------------------------- 
     
    20502050-- 
    20512051 
    2052  
    2053 -- -------------------------------------------------------- 
    2054  
    2055 -- 
    2056 -- Table structure for table `Modules` 
    2057 -- 
    2058  
    2059 CREATE TABLE `Modules` ( 
    2060   `ID` tinyint(4) unsigned NOT NULL auto_increment, 
    2061   `Name` varchar(32) NOT NULL default '', 
    2062   `Conf` mediumtext NOT NULL, 
    2063   `FuncAdd` mediumtext NOT NULL, 
    2064   `FuncDel` mediumtext NOT NULL, 
    2065   `FuncUpdate` mediumtext NOT NULL, 
    2066   `FuncBlock` mediumtext NOT NULL, 
    2067   `FuncUnblock` mediumtext NOT NULL, 
    2068   `Help` mediumtext NOT NULL, 
    2069   `LogIn` mediumtext NOT NULL, 
    2070   `Type` enum('chat','forum') NOT NULL default 'chat', 
    2071   `ReadableName` varchar(15) NOT NULL default '', 
    2072   PRIMARY KEY  (`ID`), 
    2073   UNIQUE KEY `Name` (`Name`) 
    2074 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2075  
    2076 -- 
    2077 -- Dumping data for table `Modules` 
    2078 -- 
    2079  
    2080  
    20812052-- -------------------------------------------------------- 
    20822053 
     
    21242095 
    21252096-- 
    2126 -- Table structure for table `sys_mass_messages` 
    2127 -- 
    2128  
    2129 CREATE TABLE `sys_mass_messages` ( 
     2097-- Table structure for table `sys_mail_mass_messages` 
     2098-- 
     2099 
     2100CREATE TABLE `sys_mail_mass_messages` ( 
    21302101  `ID` int(10) unsigned NOT NULL auto_increment, 
    21312102  `Subj` varchar(128) NOT NULL default '', 
     
    21362107 
    21372108-- 
    2138 -- Dumping data for table `sys_mass_messages` 
     2109-- Dumping data for table `sys_mail_mass_messages` 
    21392110-- 
    21402111 
Note: See TracChangeset for help on using the changeset viewer.