Changeset 9972 for trunk/install/sql/v70.sql
- Timestamp:
- 04/06/09 04:21:27 (3 years ago)
- File:
-
- 1 edited
-
trunk/install/sql/v70.sql (modified) (6 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/install/sql/v70.sql
r9970 r9972 6 6 7 7 SET 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`;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`, `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`; 9 9 ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'; 10 10 … … 1099 1099 1100 1100 -- 1101 -- Table structure for table ` GlParams`1102 -- 1103 1104 CREATE TABLE ` GlParams` (1101 -- Table structure for table `sys_options` 1102 -- 1103 1104 CREATE TABLE `sys_options` ( 1105 1105 `Name` varchar(64) NOT NULL default '', 1106 1106 `VALUE` mediumtext NOT NULL, … … 1117 1117 1118 1118 -- 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} {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} {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 1122 INSERT INTO `sys_options` VALUES('anon_mode', '', 1, 'Anonymous mode (no contact information)', 'checkbox', '', '', 12, ''); 1123 INSERT INTO `sys_options` VALUES('autoApproval_ifJoin', 'on', 6, 'Automatic profile activation after joining', 'checkbox', '', '', NULL, ''); 1124 INSERT INTO `sys_options` VALUES('autoApproval_ifProfile', 'on', 6, 'Do not change profile status after editing profile information', 'checkbox', '', '', NULL, ''); 1125 INSERT INTO `sys_options` VALUES('cmdDay', '10', 0, '', 'digit', '', '', NULL, ''); 1126 INSERT INTO `sys_options` VALUES('currency_code', 'USD', 0, 'Currency code (for checkout system)', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', NULL, 'USD,EURO'); 1127 INSERT INTO `sys_options` VALUES('currency_sign', '$', 15, 'Currency sign (for display purposes only)', 'digit', 'return strlen($arg0) > 0;', 'cannot be empty.', 9, ''); 1128 INSERT 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, ''); 1129 INSERT INTO `sys_options` VALUES('db_clean_msg', '180', 11, 'Clean old messages ( days )', 'digit', '', '', NULL, ''); 1130 INSERT INTO `sys_options` VALUES('db_clean_profiles', '180', 11, 'Clean old profiles by last log in ( days )', 'digit', '', '', NULL, ''); 1131 INSERT INTO `sys_options` VALUES('db_clean_views', '180', 11, 'Clean old profile views ( days )', 'digit', '', '', NULL, ''); 1132 INSERT INTO `sys_options` VALUES('db_clean_vkiss', '90', 11, 'Clean old greetings ( days )', 'digit', '', '', NULL, ''); 1133 INSERT INTO `sys_options` VALUES('default_country', 'US', 51, 'Default Country on Index Page', 'text', '', '', NULL, ''); 1134 INSERT INTO `sys_options` VALUES('enable_aff', '', 15, 'Enable affiliate support', 'checkbox', '', '', 1, ''); 1135 INSERT INTO `sys_options` VALUES('enable_contact_form', 'on', 15, 'Show contact form on contact us page', 'checkbox', '', '', 2, ''); 1136 INSERT INTO `sys_options` VALUES('enable_cupid', 'on', 12, 'Enable cupid mails', 'checkbox', '', '', NULL, ''); 1137 INSERT INTO `sys_options` VALUES('enable_customization', 'on', 1, 'Enable profile customization', 'checkbox', '', '', 10, ''); 1138 INSERT INTO `sys_options` VALUES('enable_gd', 'on', 15, 'Use GD library for image processing', 'checkbox', '', '', 5, ''); 1139 INSERT INTO `sys_options` VALUES('enable_inbox_notify', '', 17, 'Enable new message notifications', 'checkbox', '', '', NULL, ''); 1140 INSERT INTO `sys_options` VALUES('enable_match', 'on', 12, 'Enable matchmaking', 'checkbox', '', '', NULL, ''); 1141 INSERT INTO `sys_options` VALUES('enable_msg_dest_choice', 'on', 17, 'Enable message destination user choice', 'checkbox', '', '', NULL, ''); 1142 INSERT INTO `sys_options` VALUES('enable_promotion_membership', 'on', 7, 'Enable promotional membership', 'checkbox', '', '', 1, ''); 1143 INSERT INTO `sys_options` VALUES('enable_recurring', 'on', 0, 'Enable recurring billings', 'checkbox', '', '', NULL, ''); 1144 INSERT INTO `sys_options` VALUES('enable_template', '', 15, 'Enable Users to Change Templates', 'checkbox', '', '', NULL, ''); 1145 INSERT INTO `sys_options` VALUES('enable_watermark', '', 16, 'Enable Watermark', 'checkbox', '', '', 1, ''); 1146 INSERT INTO `sys_options` VALUES('enable_zip_loc', 'on', 15, 'Enable search by ZIP codes', 'checkbox', '', '', 0, ''); 1147 INSERT INTO `sys_options` VALUES('expire_notification_days', '1', 5, 'Number of days before membership expiration to notify members ( -1 = after expiration )', 'digit', '', '', NULL, ''); 1148 INSERT INTO `sys_options` VALUES('expire_notify_once', 'on', 5, 'Notify members about membership expiration only once (every day otherwise)', 'checkbox', '', '', NULL, ''); 1149 INSERT 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, ''); 1150 INSERT INTO `sys_options` VALUES('free_mode', 'on', 0, 'Site is running in free mode', 'checkbox', '', '', NULL, ''); 1151 INSERT INTO `sys_options` VALUES('lang_default', 'en', 0, 'Default site language', 'text', '', '', NULL, ''); 1152 INSERT 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, ''); 1154 INSERT INTO `sys_options` VALUES('max_inbox_message_size', '1500', 3, 'Maximum message size in symbols', 'digit', '', '', 4, ''); 1155 INSERT INTO `sys_options` VALUES('member_online_time', '5', 3, 'Time period in minutes within which a member is considered to be online', 'digit', '', '', 5, ''); 1156 INSERT INTO `sys_options` VALUES('MetaDescription', '', 19, 'Insert Meta description on site pages', 'text', '', '', NULL, ''); 1157 INSERT INTO `sys_options` VALUES('MetaKeyWords', '', 19, 'Insert Meta keywords on site pages (comma-separated list)', 'text', '', '', NULL, ''); 1158 INSERT INTO `sys_options` VALUES('msgs_per_start', '20', 8, 'Send emails from queue, it happens every cron execution (5m-1h)', 'digit', '', '', NULL, ''); 1159 INSERT INTO `sys_options` VALUES('news_enable', '1', 0, 'show boonex news in admin panel', 'digit', '', '', NULL, ''); 1160 INSERT INTO `sys_options` VALUES('newusernotify', 'on', 1, 'New User Notify', 'checkbox', '', '', 2, ''); 1161 INSERT INTO `sys_options` VALUES('promotion_membership_days', '7', 7, 'Number of days for promotional membership', 'digit', '', '', 2, ''); 1162 INSERT INTO `sys_options` VALUES('search_end_age', '75', 1, 'Highest age possible for site members', 'digit', '', '', 21, ''); 1163 INSERT INTO `sys_options` VALUES('search_start_age', '18', 1, 'Lowest age possible for site members', 'digit', '', '', 20, ''); 1164 INSERT 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, ''); 1165 INSERT 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, ''); 1166 INSERT INTO `sys_options` VALUES('sys_calendar_starts_sunday', '', 15, 'Is calendar starts from Sunday?', 'checkbox', '', '', '18', ''); 1167 INSERT INTO `sys_options` VALUES('top_members_max_num', '16', 51, 'How many results show on index page in top members area', 'digit', '', '', NULL, ''); 1168 INSERT INTO `sys_options` VALUES('track_profile_view', 'on', 1, 'Track all profile views. Later a member can manage these "views".', 'checkbox', '', '', 1, ''); 1169 INSERT INTO `sys_options` VALUES('transparent1', '0', 16, 'Transparency for first image', 'digit', '', '', 2, ''); 1170 INSERT INTO `sys_options` VALUES('transparent2', '15', 16, 'Transparency for second image', 'digit', '', '', NULL, ''); 1171 INSERT INTO `sys_options` VALUES('votes', 'on', 1, 'Enable profile votes', 'checkbox', '', '', 5, ''); 1172 INSERT INTO `sys_options` VALUES('Water_Mark', '', 16, 'Water Mark', 'text', '', '', 3, ''); 1173 INSERT INTO `sys_options` VALUES('zodiac', '', 1, 'Show zodiac signs', 'checkbox', '', '', 9, ''); 1174 INSERT INTO `sys_options` VALUES('php_date_format', 'F j, Y', 15, 'PHP date format', 'digit', '', '', 16, ''); 1175 INSERT INTO `sys_options` VALUES('group_img_width', '600', 24, 'Gallery max image width', 'digit', '', '', 1, ''); 1176 INSERT INTO `sys_options` VALUES('group_img_height', '600', 24, 'Gallery max image height', 'digit', '', '', 2, ''); 1177 INSERT INTO `sys_options` VALUES('group_img_tmb_width', '100', 24, 'Gallery max image thumb width', 'digit', '', '', 3, ''); 1178 INSERT INTO `sys_options` VALUES('group_img_tmb_height', '100', 24, 'Gallery max image thumb height', 'digit', '', '', 4, ''); 1179 INSERT 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} {reject}</b>', 24, 'Group invitation text', 'text', '', '', 5, ''); 1180 INSERT 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, ''); 1181 INSERT 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} {reject}', 24, 'Request message to group creator', 'text', '', '', 8, ''); 1182 INSERT 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, ''); 1183 INSERT 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, ''); 1184 INSERT INTO `sys_options` VALUES('tags_last_parse_time', '0', 0, 'Temporary value when tags cron-job was runed last time', 'digit', '', '', NULL, ''); 1185 INSERT INTO `sys_options` VALUES('tags_min_rating', '2', 25, 'Minimum rating of tag to show it', 'digit', '', '', 2, ''); 1186 INSERT INTO `sys_options` VALUES('autoApproval_ifNoConfEmail', 'on', 6, 'Automatic profile confirmation without Confirmation Email', 'checkbox', '', '', NULL, ''); 1187 INSERT INTO `sys_options` VALUES('enable_flash_promo', 'on', 0, '', 'checkbox', '', '', NULL, ''); 1188 INSERT INTO `sys_options` VALUES('custom_promo_code', '', 0, '', 'text', '', '', NULL, ''); 1189 INSERT INTO `sys_options` VALUES('license_code', '', 1, 'Dolphin License Code', 'digit', '', '', 0, ''); 1190 INSERT INTO `sys_options` VALUES('enable_dolphin_footer', 'on', 0, 'enable boonex footers', 'checkbox', '', '', NULL, ''); 1191 INSERT 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, ''); 1193 INSERT INTO `sys_options` VALUES('enable_modrewrite', 'on', 26, 'Enable friendly profile permalinks', 'checkbox', '', '', 1, ''); 1194 INSERT INTO `sys_options` VALUES('permalinks_groups', 'on', 26, 'Enable friendly groups permalinks', 'checkbox', '', '', 10, ''); 1195 INSERT INTO `sys_options` VALUES('cupid_last_cron', '0', 0, 'Temporary value when cupid mails checked was runed last time', 'text', '', '', NULL, ''); 1196 INSERT INTO `sys_options` VALUES('reg_by_inv_only', '', 3, 'Registration by invitation only (need before Enable affiliate support)', 'checkbox', '', '', 13, ''); 1197 INSERT INTO `sys_options` VALUES('main_div_width', '960px', 0, 'Width of the main container of the site', 'digit', '', '', 0, ''); 1198 INSERT INTO `sys_options` VALUES('promoWidth', '960', 0, 'Default Width of the Promo Images for resizing', 'digit', '', '', 0, ''); 1199 INSERT INTO `sys_options` VALUES('profile_gallery_feature', '', 3, 'New Gallery Feature for Shared Photos', 'checkbox', '', '', NULL, ''); 1200 INSERT INTO `sys_options` VALUES('boonexAffID', '', 1, 'My BoonEx Affiliate ID', 'digit', '', '', 0.5, ''); 1201 INSERT INTO `sys_options` VALUES('ipBlacklistMode', '1', 3, 'IP Blacklist system mode (1 - total block, 2 - login block)', 'digit', '', '', NULL, ''); 1202 INSERT INTO `sys_options` VALUES('ipListGlobalType', '3', 3, 'IP List Type (1 - all allowed except listed, 2 - all blocked except listed, 0 - disabled)', 'digit', '', '', NULL, ''); 1203 INSERT 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, ''); 1204 INSERT INTO `sys_options` VALUES('site_email', 'xxx@gmail.com', 50, 'Site Email', 'digit', '', '', NULL, ''); 1205 INSERT INTO `sys_options` VALUES('site_title', 'Unite Community', 50, 'Site Title', 'digit', '', '', NULL, ''); 1206 INSERT INTO `sys_options` VALUES('site_email_notify', 'xxx2@gmail.com', 50, 'Site Email Notify', 'digit', '', '', NULL, ''); 1207 INSERT INTO `sys_options` VALUES('enable_html_in_comments', 'on', 3, 'Enable HTML in comments', 'checkbox', '', '', NULL, ''); 1208 INSERT INTO `sys_options` VALUES('enable_tiny_in_comments', '', 3, 'Enable TinyMCS in comments', 'checkbox', '', '', NULL, ''); 1209 INSERT INTO `sys_options` VALUES('enable_global_couple', 'on', 3, 'Global Enabling of Couples', 'checkbox', '', '', NULL, ''); 1210 INSERT INTO `sys_options` VALUES('enable_new_dhtml_popups', 'on', 3, 'Enable new DHTML notifications rather than popup', 'checkbox', '', '', NULL, ''); 1211 INSERT INTO `sys_options` VALUES('dbCleanAlert', '2', 3, 'Clean old user alerts', 'digit', '', '', 5, ''); 1212 INSERT INTO `sys_options` VALUES('galleryFiles_user', '2', 23, 'Number of gallery files relate to user', 'digit', '', '', 21, ''); 1213 INSERT INTO `sys_options` VALUES('galleryFiles_keyword', '2', 23, 'Number of related gallery files', 'digit', '', '', 22, ''); 1214 INSERT INTO `sys_options` VALUES('enable_cache_system', 'on', 3, 'Enable caching system to store profiles information', 'checkbox', '', '', NULL, ''); 1215 INSERT 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, ''); 1216 INSERT 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, ''); 1217 INSERT INTO `sys_options` VALUES('enable_guest_comments', '', 3, 'enable possibility to post comments by guests', 'checkbox', '', '', NULL, ''); 1218 INSERT INTO `sys_options` VALUES('permalinks_browse', 'on', 26, 'Enable friendly browse permalinks', 'checkbox', '', '', 12, ''); 1219 INSERT INTO `sys_options` VALUES('sys_ntns_ajax_mode', 'on', 1, 'Enable Ajax mode for Notifications', 'checkbox', '', '', 23, ''); 1220 INSERT INTO `sys_options` VALUES('sys_ntns_update_interval', '10', 1, 'Notification''s update interval in seconds(for Ajax mode only)', 'digit', '', '', 24, ''); 1221 INSERT INTO `sys_options` VALUES('sys_ntns_expiration_time', '30', 1, 'Notification''s expiration time in minutes', 'digit', '', '', 25, ''); 1222 INSERT INTO `sys_options` VALUES('sys_ntns_display_number', '3', 1, 'Notification''s display number', 'digit', '', '', 26, ''); 1223 INSERT INTO `sys_options` VALUES('promo_relocation_link_visitor', 'join.php', 3, 'Default relocation link to Promo for non-members', 'text', '', '', NULL, ''); 1224 INSERT INTO `sys_options` VALUES('promo_relocation_link_member', 'member.php', 3, 'Default relocation link to Promo for members', 'text', '', '', NULL, ''); 1225 INSERT INTO `sys_options` VALUES('leaders_male_types', 'year,month,week,day', 3, 'Period types of leaders for male', 'select', '', '', NULL, 'year,month,week,day'); 1226 INSERT INTO `sys_options` VALUES('leaders_female_types', 'year,month,week,day', 3, 'Period types of leaders for female', 'select', '', '', NULL, 'year,month,week,day'); 1227 INSERT INTO `sys_options` VALUES('useLikeOperator', '', 15, 'Use operator LIKE for search (recommended for small content)', 'checkbox', '', '', 21, ''); 1228 INSERT 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'); 1229 INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_2', 'on', 9, 'Enable \'All\' group', 'checkbox', '', '', 1, ''); 1230 INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_3', 'on', 9, 'Enable \'Friends\' group', 'checkbox', '', '', 2, ''); 1231 INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_4', 'on', 9, 'Enable \'Faves\' group', 'checkbox', '', '', 3, ''); 1232 INSERT INTO `sys_options` VALUES('sys_ps_enabled_group_5', 'on', 9, 'Enable \'Contacts\' group', 'checkbox', '', '', 4, ''); 1233 INSERT INTO `sys_options` VALUES('sys_make_album_cover_last', 'on', 1, 'Set last object as cover of album', 'checkbox', '', '', 20, ''); 1234 INSERT INTO `sys_options` VALUES('sys_album_auto_app', 'on', 1, 'Autoapproval for albums', 'checkbox', '', '', 21, ''); 1235 INSERT INTO `sys_options` VALUES('sys_album_default_name', 'Unsorted', 0, 'Default album name', 'text', '', '', 22, ''); 1236 1236 1237 1237 -- -------------------------------------------------------- … … 2050 2050 -- 2051 2051 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 2081 2052 -- -------------------------------------------------------- 2082 2053 … … 2124 2095 2125 2096 -- 2126 -- Table structure for table `sys_ma ss_messages`2127 -- 2128 2129 CREATE TABLE `sys_ma ss_messages` (2097 -- Table structure for table `sys_mail_mass_messages` 2098 -- 2099 2100 CREATE TABLE `sys_mail_mass_messages` ( 2130 2101 `ID` int(10) unsigned NOT NULL auto_increment, 2131 2102 `Subj` varchar(128) NOT NULL default '', … … 2136 2107 2137 2108 -- 2138 -- Dumping data for table `sys_ma ss_messages`2109 -- Dumping data for table `sys_mail_mass_messages` 2139 2110 -- 2140 2111
Note: See TracChangeset
for help on using the changeset viewer.