Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement