CREATE TABLE IF NOT EXISTS `messages` ( `id` int(11) unsigned NOT NULL auto_increment, `user_id` int(11) unsigned NOT NULL, `node_id` int(11) unsigned NOT NULL, `reciever_id` int(11) unsigned NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- Dumping data for table `messages` -- INSERT INTO `messages` (`id`, `user_id`, `node_id`, `reciever_id`, `created`, `modified`) VALUES (1, 1, 1, 15, '2011-12-07 00:00:00', '2011-12-07 02:00:00'), (2, 15, 1, 1, '2011-12-07 02:00:00', '2011-12-07 02:00:00'), (3, 15, 2, 1, '2011-12-07 11:00:00', '2011-12-07 11:00:00'), (4, 1, 2, 15, '2011-12-07 11:00:00', '2011-12-07 11:00:00'), (5, 1, 3, 18, '2011-12-07 11:00:00', '2011-12-07 11:00:00'), (6, 18, 3, 1, '2011-12-07 11:00:00', '2011-12-07 11:00:00'), (7, 1, 4, 18, '2011-12-07 12:00:00', '2011-12-07 12:00:00'), (8, 18, 4, 1, '2011-12-07 12:00:00', '2011-12-07 12:00:00');