   `friend_from` int(10) NOT NULL DEFAULT '0',
   `friend_to` int(10) NOT NULL DEFAULT '0',
   `friend_value` smallint(3) NOT NULL DEFAULT '0',
+  `friend_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   UNIQUE KEY `friend_type` (`friend_type`,`friend_from`,`friend_to`),
-  KEY `friend_type_2` (`friend_type`,`friend_to`)
+  KEY `friend_type_3` (`friend_type`,`friend_to`,`friend_date`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 

/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `votes` (
  `vote_id` int(20) NOT NULL AUTO_INCREMENT,
  `vote_type` enum('links','comments','posts') CHARACTER SET utf8 NOT NULL DEFAULT 'links',
  `vote_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `vote_link_id` int(20) NOT NULL DEFAULT '0',
  `vote_user_id` int(20) NOT NULL DEFAULT '0',

--
-- Host: localhost    Database: meneame
-- ------------------------------------------------------
-- Server version	5.1.37-1ubuntu5.5-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
