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

Timestamp:

04/06/09 22:50:09 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/install/sql/v70.sql (modified) (10 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`, `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`, `sys_objects_tag`, `sys_menu_top`, `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`, `sys_admins`, `sys_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`, `sys_objects_tag`, `sys_menu_top`, `sys_transactions`, `sys_objects_actions`, `sys_greetings`, `sys_zip_codes`, `sys_objects_vote`, `sys_objects_views`, `sys_box_download`;
 ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci';
 
@@ -170 +170 @@
 
 --
--- Table structure for table `Admins`
---
-
-CREATE TABLE `Admins` (
+-- Table structure for table `sys_admins`
+--
+
+CREATE TABLE `sys_admins` (
   `Name` varchar(10) NOT NULL default '',
   `Password` varchar(32) NOT NULL default '',
@@ -180 +180 @@
 
 --
--- Dumping data for table `Admins`
---
-
-INSERT INTO `Admins` VALUES('admin', '36cdf8b887a5cffc78dcd5c08991b993');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `aff`
---
-
-CREATE TABLE `aff` (
+-- Dumping data for table `sys_admins`
+--
+
+INSERT INTO `sys_admins` VALUES('admin', '36cdf8b887a5cffc78dcd5c08991b993');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_aff`
+--
+
+CREATE TABLE `sys_aff` (
   `ID` bigint(8) NOT NULL auto_increment,
   `Name` varchar(10) NOT NULL default '',
@@ -206 +206 @@
 
 --
--- Dumping data for table `aff`
+-- Dumping data for table `sys_aff`
 --
 
@@ -2350 +2350 @@
 INSERT INTO `sys_stat_member` VALUES('mfr', 'SELECT COUNT(*) FROM `sys_friend_list` WHERE `Profile` = ''__member_id__'' AND  `Check` = ''0''');
 INSERT INTO `sys_stat_member` VALUES('mfa', 'SELECT COUNT(*) FROM `sys_friend_list` WHERE ( `ID`=''__member_id__'' OR `Profile`=''__member_id__'' ) AND `Check`=''1''');
-INSERT INTO `sys_stat_member` VALUES('mgc', 'SELECT COUNT(*) FROM `Greetings` WHERE `ID` = ''__member_id__'' AND New = ''1''');
+INSERT INTO `sys_stat_member` VALUES('mgc', 'SELECT COUNT(*) FROM `sys_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 `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('mgmc', 'SELECT COUNT(*) FROM `sys_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 `sys_profiles_track` WHERE `Profile` = ''__member_id__''');
@@ -3710 +3710 @@
 
 --
--- Table structure for table `Transactions`
---
-
-CREATE TABLE `Transactions` (
+-- Table structure for table `sys_transactions`
+--
+
+CREATE TABLE `sys_transactions` (
   `ID` bigint(20) unsigned NOT NULL auto_increment,
   `IDMember` int(10) unsigned NOT NULL default '0',
@@ -3732 +3732 @@
 
 --
--- Dumping data for table `Transactions`
+-- Dumping data for table `sys_transactions`
 --
 
@@ -3769 +3769 @@
 
 --
--- Table structure for table `Greetings`
---
-
-CREATE TABLE `Greetings` (
+-- Table structure for table `sys_greetings`
+--
+
+CREATE TABLE `sys_greetings` (
   `ID` int(10) unsigned NOT NULL default '0',
   `Profile` int(10) unsigned NOT NULL default '0',
@@ -3782 +3782 @@
 
 --
--- Dumping data for table `Greetings`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `Votes`
---
-
-CREATE TABLE `Votes` (
-  `Member` int(10) unsigned NOT NULL default '0',
-  `Mark` int(11) NOT NULL default '0',
-  `IP` varchar(18) NOT NULL default '',
-  `Date` date NOT NULL default '0000-00-00',
-  UNIQUE KEY `Member` (`Member`,`IP`,`Date`),
-  KEY `Member_2` (`Member`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `Votes`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `VoteObjects`
---
-
-CREATE TABLE `VoteObjects` (
+-- Dumping data for table `sys_greetings`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sys_objects_vote`
+--
+
+CREATE TABLE `sys_objects_vote` (
   `ID` int(10) unsigned NOT NULL auto_increment,
   `ObjectName` varchar(50) NOT NULL,
@@ -3834 +3813 @@
 
 --
--- Dumping data for table `VoteObjects`
---
-
-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', '', '');
-
---
--- Table structure for table `ZIPCodes`
---
-
-CREATE TABLE `ZIPCodes` (
+-- Dumping data for table `sys_objects_vote`
+--
+
+INSERT INTO `sys_objects_vote` VALUES(1, 'profile', 'sys_profile_rating', 'sys_profile_voting_track', 'pr_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'Profiles', 'Rate', 'RateCount', 'ID', '', '');
+
+--
+-- Table structure for table `sys_zip_codes`
+--
+
+CREATE TABLE `sys_zip_codes` (
   `ZIPCode` varchar(8) default NULL,
   `ZIPCodeType` char(1) default NULL,