 CREATE TABLE `chats` (
   `chat_time` int(10) unsigned NOT NULL default '0',
   `chat_uid` int(10) unsigned NOT NULL default '0',
+  `chat_room` enum('all','friends') NOT NULL default 'all',
   `chat_user` char(32) NOT NULL,
   `chat_text` char(255) NOT NULL,
   KEY `chat_time` USING BTREE (`chat_time`)

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2007-01-03 11:22:45

  `friend_from` int(10) NOT NULL default '0',
  `friend_to` int(10) NOT NULL default '0',
  `friend_value` decimal(10,6) NOT NULL default '0.000000',
  UNIQUE KEY `friend_type` (`friend_type`,`friend_from`,`friend_to`),
  KEY `friend_type_2` (`friend_type`,`friend_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
