Re: cakephp Messaging sysytem

sure

CREATE TABLE IF NOT EXISTS `comm_conversations` (
`id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime NOT NULL,
`last_message_id` int(10) unsigned NOT NULL DEFAULT '0',
`allow_add` tinyint(1) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `comm_conversation_messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`conversation_id` char(36) COLLATE utf8_unicode_ci NOT NULL,
`user_id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`attachment_id` int(10) unsigned NOT NULL DEFAULT '0',
`message` text COLLATE utf8_unicode_ci NOT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=109 ;

CREATE TABLE IF NOT EXISTS `comm_conversation_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`conversation_id` char(36) COLLATE utf8_unicode_ci NOT NULL,
`user_id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0=ok,
1=deleted,2=removed',
`last_view` int(10) unsigned NOT NULL DEFAULT '0',
`created` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `conversation_id` (`conversation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=110 ;

On 23 Feb., 21:31, Josh <josha...@gmail.com> wrote:
> Hey euromark,
>
> That looks like exactly what I'm trying to do.  Could you also let us know
> what columns are in each table?  I'm sort of following your logic, but not
> 100% and I think seeing the table columns would help a lot.
>
> ~Josh

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php