Changeset 9977 for trunk/install/sql/v70.sql

Timestamp:

04/06/09 05:42:46 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/install/sql/v70.sql (modified) (14 diffs)

trunk/install/sql/v70.sql

@@ -6 +6 @@
 
 SET NAMES 'utf8';
-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`, `sys_ip_list`, `sys_ip_members_visits`, `Links`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `sys_moderators`, `News`, `sys_subscriptions`, `sys_mail_mass_messages`, `sys_mail_queue`, `sys_page_compose`, `sys_page_compose_pages`, `sys_payment_parameters`, `sys_payment_providers`, `sys_payment_subscriptions`, `sys_stat_member`, `sys_pre_values`, `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`;
+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`, `sys_ip_list`, `sys_ip_members_visits`, `Links`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `sys_moderators`, `News`, `sys_subscriptions`, `sys_mail_mass_messages`, `sys_mail_queue`, `sys_page_compose`, `sys_page_compose_pages`, `sys_payment_parameters`, `sys_payment_providers`, `sys_payment_subscriptions`, `sys_stat_member`, `sys_pre_values`, `ProfileFields`, `sys_acl_levels_members`, `Profiles`, `sys_profile_views_track`, `sys_profiles_match`, `sys_profiles_settings`, `sys_profiles_track`, `sys_profile_rating`, `sys_profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `sys_objects_search`, `sys_shared_sites`, `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`;
 ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci';
 
@@ -2352 +2352 @@
 INSERT INTO `sys_stat_member` VALUES('mgc', 'SELECT COUNT(*) FROM `Greetings` WHERE `ID` = ''__member_id__'' AND New = ''1''');
 INSERT INTO `sys_stat_member` VALUES('mbc', 'SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = ''__member_id__''');
-INSERT INTO `sys_stat_member` VALUES('mvc', 'SELECT COUNT(*) FROM `ProfilesTrack` WHERE `ID` = ''__member_id__''');
+INSERT INTO `sys_stat_member` VALUES('mvc', 'SELECT COUNT(*) FROM `sys_profiles_track` WHERE `ID` = ''__member_id__''');
 INSERT INTO `sys_stat_member` VALUES('mg', 'SELECT COUNT(*) FROM `Groups` WHERE `creatorID` = ''__member_id__'' AND `status`=''Active''');
 INSERT INTO `sys_stat_member` VALUES('mgj', 'SELECT COUNT(*) FROM `GroupsMembers` WHERE `memberID` = ''__member_id__'' AND `status`=''Active''');
 INSERT INTO `sys_stat_member` VALUES('mgmc', 'SELECT COUNT(*) FROM `Greetings` WHERE `Profile` = ''__member_id__'' AND New = ''1''');
 INSERT INTO `sys_stat_member` VALUES('mrc', 'SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = ''__member_id__''');
-INSERT INTO `sys_stat_member` VALUES('mvmc', 'SELECT COUNT(*) FROM `ProfilesTrack` WHERE `Profile` = ''__member_id__''');
+INSERT INTO `sys_stat_member` VALUES('mvmc', 'SELECT COUNT(*) FROM `sys_profiles_track` WHERE `Profile` = ''__member_id__''');
 
 
@@ -2931 +2931 @@
 
 --
--- Table structure for table `profile_views_track`
---
-
-CREATE TABLE IF NOT EXISTS `profile_views_track` (
+-- Table structure for table `sys_profile_views_track`
+--
+
+CREATE TABLE IF NOT EXISTS `sys_profile_views_track` (
   `id` int(10) unsigned NOT NULL,
   `viewer` int(10) unsigned NOT NULL,
@@ -2943 +2943 @@
 
 --
--- Dumping data for table `profile_views_track`
---
-
--- --------------------------------------------------------
-
---
--- Table structure for table `ProfilesMatch`
---
-
-CREATE TABLE `ProfilesMatch` (
+-- Dumping data for table `sys_profile_views_track`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profiles_match`
+--
+
+CREATE TABLE `sys_profiles_match` (
   `PID1` int(10) unsigned NOT NULL default '0' COMMENT 'Profile ID',
   `PID2` int(10) unsigned NOT NULL default '0',
@@ -2960 +2960 @@
 
 --
--- Dumping data for table `ProfilesMatch`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `ProfilesSettings`
---
-
-CREATE TABLE `ProfilesSettings` (
+-- Dumping data for table `sys_profiles_match`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profiles_settings`
+--
+
+CREATE TABLE `sys_profiles_settings` (
   `IDMember` int(10) NOT NULL default '0',
   `BackgroundFilename` varchar(40) default NULL,
@@ -2982 +2982 @@
 
 --
--- Dumping data for table `ProfilesSettings`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `ProfilesTrack`
---
-
-CREATE TABLE `ProfilesTrack` (
+-- Dumping data for table `sys_profiles_settings`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profiles_track`
+--
+
+CREATE TABLE `sys_profiles_track` (
   `ID` int(10) unsigned NOT NULL default '0',
   `Profile` int(10) unsigned NOT NULL default '0',
@@ -3004 +3004 @@
 
 --
--- Dumping data for table `ProfilesTrack`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `profile_rating`
---
-
-CREATE TABLE `profile_rating` (
+-- Dumping data for table `sys_profiles_track`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profile_rating`
+--
+
+CREATE TABLE `sys_profile_rating` (
   `pr_id` int(10) unsigned NOT NULL default '0',
   `pr_rating_count` int(11) NOT NULL default '0',
@@ -3022 +3022 @@
 
 --
--- Dumping data for table `profile_rating`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `profile_voting_track`
---
-
-CREATE TABLE `profile_voting_track` (
+-- Dumping data for table `sys_profile_rating`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_profile_voting_track`
+--
+
+CREATE TABLE `sys_profile_voting_track` (
   `pr_id` int(10) unsigned NOT NULL default '0',
   `pr_ip` varchar(20) default NULL,
@@ -3040 +3040 @@
 
 --
--- Dumping data for table `profile_voting_track`
+-- Dumping data for table `sys_profile_voting_track`
 --
 
@@ -3492 +3492 @@
 
 --
--- Table structure for table `Stories`
---
-
-CREATE TABLE `Stories` (
-  `ID` smallint(6) unsigned NOT NULL auto_increment,
-  `Date` date NOT NULL default '0000-00-00',
-  `Sender` bigint(8) unsigned NOT NULL default '0',
-  `Header` varchar(50) NOT NULL default '',
-  `Text` longtext NOT NULL,
-  `active` varchar(4) NOT NULL default '',
-  PRIMARY KEY  (`ID`),
-  KEY `Sender` (`Sender`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `Stories`
---
-
--- --------------------------------------------------------
-
---
--- Table structure for table 'SearchObjects'
---
-
-CREATE TABLE `SearchObjects` (
+-- Table structure for table 'sys_objects_search'
+--
+
+CREATE TABLE `sys_objects_search` (
   `ID` int(10) unsigned NOT NULL auto_increment,
   `ObjectName` varchar(50) NOT NULL  default '',
@@ -3526 +3505 @@
 
 --
--- Dumping data for table 'SearchObjects'
---
-
-INSERT INTO `SearchObjects` VALUES(2, 'group', '_Groups', 'BxTemplSearchGroup', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchGroup.php');
-INSERT INTO `SearchObjects` VALUES(3, 'profile', '_Profiles', 'BxTemplSearchProfile', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchProfile.php');
-
--- --------------------------------------------------------
-
---
--- Table structure for table 'sharedSites'
---
-
-CREATE TABLE `sharedSites` (
+-- Dumping data for table 'sys_objects_search'
+--
+
+INSERT INTO `sys_objects_search` VALUES(2, 'group', '_Groups', 'BxTemplSearchGroup', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchGroup.php');
+INSERT INTO `sys_objects_search` VALUES(3, 'profile', '_Profiles', 'BxTemplSearchProfile', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchProfile.php');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table 'sys_shared_sites'
+--
+
+CREATE TABLE `sys_shared_sites` (
   `ID` tinyint(4) unsigned NOT NULL auto_increment,
   `Name` varchar(255) default NULL,
@@ -3546 +3525 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
-INSERT INTO `sharedSites` VALUES('', 'digg', 'http://digg.com/submit?phase=2&url=', 'digg.png');
-INSERT INTO `sharedSites` VALUES('', 'delicious', 'http://del.icio.us/post?url=', 'delicious.png');
-INSERT INTO `sharedSites` VALUES('', 'blinklist', 'http://www.blinklist.com/index.php?Action=Blink/addblink.php&Url=', 'blinklist.png');
-INSERT INTO `sharedSites` VALUES('', 'furl', 'http://www.furl.net/storeIt.jsp?u=', 'furl.png');
-INSERT INTO `sharedSites` VALUES('', 'netscape', 'http://www.netscape.com/submit/?U=', 'netscape.gif');
-INSERT INTO `sharedSites` VALUES('', 'newsvine', 'http://www.newsvine.com/_tools/seed&save?u=', 'newsvine.png');
-INSERT INTO `sharedSites` VALUES('', 'reddit', 'http://reddit.com/submit?url=', 'reddit.png');
-INSERT INTO `sharedSites` VALUES('', 'shadows', 'http://www.shadows.com/features/tcr.htm?url=', 'shadows.png');
-INSERT INTO `sharedSites` VALUES('', 'slashdot', 'http://slashdot.org/bookmark.pl?url=', 'slashdot.png');
-INSERT INTO `sharedSites` VALUES('', 'sphere', 'http://www.sphere.com/search?q=sphereit:', 'sphere.png');
-INSERT INTO `sharedSites` VALUES('', 'stumbleupon', 'http://www.stumbleupon.com/url/http', 'stumbleupon.png');
-INSERT INTO `sharedSites` VALUES('', 'technorati', 'http://technorati.com/faves?add=', 'technorati.png');
-
---
--- Dumping data for table 'sharedSites'
+INSERT INTO `sys_shared_sites` VALUES('', 'digg', 'http://digg.com/submit?phase=2&url=', 'digg.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'delicious', 'http://del.icio.us/post?url=', 'delicious.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'blinklist', 'http://www.blinklist.com/index.php?Action=Blink/addblink.php&Url=', 'blinklist.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'furl', 'http://www.furl.net/storeIt.jsp?u=', 'furl.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'netscape', 'http://www.netscape.com/submit/?U=', 'netscape.gif');
+INSERT INTO `sys_shared_sites` VALUES('', 'newsvine', 'http://www.newsvine.com/_tools/seed&save?u=', 'newsvine.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'reddit', 'http://reddit.com/submit?url=', 'reddit.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'shadows', 'http://www.shadows.com/features/tcr.htm?url=', 'shadows.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'slashdot', 'http://slashdot.org/bookmark.pl?url=', 'slashdot.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'sphere', 'http://www.sphere.com/search?q=sphereit:', 'sphere.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'stumbleupon', 'http://www.stumbleupon.com/url/http', 'stumbleupon.png');
+INSERT INTO `sys_shared_sites` VALUES('', 'technorati', 'http://technorati.com/faves?add=', 'technorati.png');
+
+--
+-- Dumping data for table 'sys_shared_sites'
 --
 
@@ -3858 +3837 @@
 --
 
-INSERT INTO `VoteObjects` VALUES(1, 'profile', 'profile_rating', 'profile_voting_track', 'pr_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'Profiles', 'Rate', 'RateCount', 'ID', '', '');
+INSERT INTO `VoteObjects` VALUES(1, 'profile', 'sys_profile_rating', 'sys_profile_voting_track', 'pr_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'Profiles', 'Rate', 'RateCount', 'ID', '', '');
 
 --
@@ -4056 +4035 @@
 --
 
-INSERT INTO `sys_objects_views` VALUES(NULL, 'profiles', 'profile_views_track', 86400, 'Profiles', 'ID', 'Views', 1);
+INSERT INTO `sys_objects_views` VALUES(NULL, 'profiles', 'sys_profile_views_track', 86400, 'Profiles', 'ID', 'Views', 1);
 
 --