Changeset 8629 for trunk/install/sql/v61.sql

Timestamp:

01/20/09 00:46:27 (3 years ago)

Author:

Alexander Ermashev

Message:

• Rename the table 'VKisses' to 'Greetings'. List of changed files : install.sql, greet.php, inc/admin.inc.php, member.php,

periodic/cmd.php ;

File:

• trunk/install/sql/v61.sql (modified) (4 diffs)

trunk/install/sql/v61.sql

@@ -6 +6 @@
 
 SET NAMES 'utf8';
-DROP TABLE IF EXISTS `AccountCustomStatElements`, `AdminBanList`, `AdminLinks`, `AdminMenu`, `AdminMenuCateg`, `Admins`, `aff`, `aff_banners`, `aff_members`, `alerts`, `Articles`, `articles_rating`, `articles_voting_track`, `ArticlesCategory`, `Banners`, `BannersClicks`, `BannersShows`, `BlockList`, `BrowseObjectClasses`, `Categories`, `CategoryObjects`, `CmtsGuestbook`, `CmtsObjects`, `CmtsProfile`, `CmtsTrack`, `ColorBase`, `Countries`, `DailyQuotes`, `EmailTemplates`, `event_rating`, `event_voting_track`, `ExtendedMenuItems`, `FriendList`, `GlParams`, `GlParamsKateg`, `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`, `HotList`, `IPList`, `IPMembersVisits`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `MemActions`, `MemActionsTrack`, `members_as_aff`, `MemLevelActions`, `MemLevelPrices`, `MemLevels`, `Messages`, `moderators`, `Modules`, `News`, `NotifyEmails`, `NotifyMsgs`, `NotifyQueue`, `PageCompose`, `PageComposePages`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `PQStatistics`, `PreValues`, `ProfileFields`, `ProfileMemLevels`, `Profiles`, `ProfilesMatch`, `ProfilesPolls`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardBoards`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `SDatingEvents`, `SDatingParticipants`, `SearchObjects`, `sharedSites`, `SiteStat`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `TagObjects`, `TopMenu`, `Transactions`, `UsersActions`, `VKisses`, `Votes`, `ZIPCodes`, `VoteObjects`;
+DROP TABLE IF EXISTS `AccountCustomStatElements`, `AdminBanList`, `AdminLinks`, `AdminMenu`, `AdminMenuCateg`, `Admins`, `aff`, `aff_banners`, `aff_members`, `alerts`, `Articles`, `articles_rating`, `articles_voting_track`, `ArticlesCategory`, `Banners`, `BannersClicks`, `BannersShows`, `BlockList`, `BrowseObjectClasses`, `Categories`, `CategoryObjects`, `CmtsGuestbook`, `CmtsObjects`, `CmtsProfile`, `CmtsTrack`, `ColorBase`, `Countries`, `DailyQuotes`, `EmailTemplates`, `event_rating`, `event_voting_track`, `ExtendedMenuItems`, `FriendList`, `GlParams`, `GlParamsKateg`, `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`, `HotList`, `IPList`, `IPMembersVisits`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `MemActions`, `MemActionsTrack`, `members_as_aff`, `MemLevelActions`, `MemLevelPrices`, `MemLevels`, `Messages`, `moderators`, `Modules`, `News`, `NotifyEmails`, `NotifyMsgs`, `NotifyQueue`, `PageCompose`, `PageComposePages`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `PQStatistics`, `PreValues`, `ProfileFields`, `ProfileMemLevels`, `Profiles`, `ProfilesMatch`, `ProfilesPolls`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardBoards`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `SDatingEvents`, `SDatingParticipants`, `SearchObjects`, `sharedSites`, `SiteStat`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `TagObjects`, `TopMenu`, `Transactions`, `UsersActions`, `Greetings`, `Votes`, `ZIPCodes`, `VoteObjects`;
 ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci';
 
@@ -6509 +6509 @@
 INSERT INTO `PQStatistics` VALUES('mfr', 'SELECT COUNT(*) FROM `FriendList` WHERE `Profile` = ''__member_id__'' AND  `Check` = ''0''');
 INSERT INTO `PQStatistics` VALUES('mfa', 'SELECT COUNT(*) FROM `FriendList` WHERE ( `ID`=''__member_id__'' OR `Profile`=''__member_id__'' ) AND `Check`=''1''');
-INSERT INTO `PQStatistics` VALUES('mgc', 'SELECT COUNT(*) FROM `VKisses` WHERE `ID` = ''__member_id__'' AND New = ''1''');
+INSERT INTO `PQStatistics` VALUES('mgc', 'SELECT COUNT(*) FROM `Greetings` WHERE `ID` = ''__member_id__'' AND New = ''1''');
 INSERT INTO `PQStatistics` VALUES('mbc', 'SELECT COUNT(*) FROM `BlockList` WHERE `ID` = ''__member_id__''');
 INSERT INTO `PQStatistics` VALUES('mvc', 'SELECT COUNT(*) FROM `ProfilesTrack` WHERE `Member` = ''__member_id__''');
@@ -7931 +7931 @@
 
 --
--- Table structure for table `VKisses`
---
-
-CREATE TABLE `VKisses` (
+-- Table structure for table `Greetings`
+--
+
+CREATE TABLE `Greetings` (
   `ID` bigint(8) unsigned NOT NULL default '0',
   `Profile` bigint(8) unsigned NOT NULL default '0',
@@ -7944 +7944 @@
 
 --
--- Dumping data for table `VKisses`
+-- Dumping data for table `Greetings`
 --