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

Timestamp:

01/21/09 02:19:54 (3 years ago)

Author:

Alexander Ermashev

Message:

• rename the table's (ProfilesTrack?) fields from Member to ID, and Arrive to When

File:

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

trunk/install/sql/v61.sql

@@ -6359 +6359 @@
 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__''');
+INSERT INTO `PQStatistics` VALUES('mvc', 'SELECT COUNT(*) FROM `ProfilesTrack` WHERE `ID` = ''__member_id__''');
 INSERT INTO `PQStatistics` VALUES('spo', 'SELECT COUNT(*) FROM `ProfilesPolls` WHERE `id_profile` = ''__member_id__'' AND `poll_status`=''active''');
 INSERT INTO `PQStatistics` VALUES('me', 'SELECT COUNT(*) FROM `SDatingEvents` WHERE `ResponsibleID` = ''__member_id__'' AND `Status`=''Active''');
@@ -6992 +6992 @@
 
 CREATE TABLE `ProfilesTrack` (
-  `Member` bigint(8) unsigned NOT NULL default '0',
+  `ID` bigint(8) unsigned NOT NULL default '0',
   `Profile` bigint(8) unsigned NOT NULL default '0',
-  `Arrived` date NOT NULL default '0000-00-00',
+  `When` date NOT NULL default '0000-00-00',
   `Hide` tinyint(4) NOT NULL default '0',
-  UNIQUE KEY `Member_2` (`Member`,`Profile`),
-  KEY `Member` (`Member`),
+  UNIQUE KEY `Member_2` (`ID`,`Profile`),
+  KEY `Member` (`ID`),
   KEY `Profile` (`Profile`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 
 --