Thanks man! Perfect.
Dave -----Original Message----- From: Miles J [mailto:[email protected]] Sent: March-16-09 9:02 PM To: CakePHP Subject: Re: User to User request Yeah message tables could be quite tricky. Heres the SQL that I use for my messaging system. user_id = User who sent the message recipient_id = Use who receives it, of course CREATE TABLE IF NOT EXISTS `messages` ( `id` int(11) NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL default '0', `userFolder` enum('inbox','sent','saved','trash','deleted') NOT NULL default 'inbox', `recipient_id` int(10) unsigned NOT NULL default '0', `recipientFolder` enum('inbox','sent','saved','trash','deleted') NOT NULL default 'inbox', `status` enum('read','unread','replied','forwarded') NOT NULL default 'unread', `subject` varchar(35) NOT NULL, `content` text NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `recipient_id` (`recipient_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Internal messages for user to user' AUTO_INCREMENT=1 ; --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
