Advertisement
Guest User

Untitled

a guest
Jan 5th, 2012
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `messages` (
  2. `id` int(11) unsigned NOT NULL auto_increment,
  3. `user_id` int(11) unsigned NOT NULL,
  4. `node_id` int(11) unsigned NOT NULL,
  5. `reciever_id` int(11) unsigned NOT NULL,
  6. `created` datetime default NULL,
  7. `modified` datetime default NULL,
  8. PRIMARY KEY (`id`)
  9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
  10.  
  11. --
  12. -- Dumping data for table `messages`
  13. --
  14.  
  15. INSERT INTO `messages` (`id`, `user_id`, `node_id`, `reciever_id`, `created`, `modified`) VALUES
  16. (1, 1, 1, 15, '2011-12-07 00:00:00', '2011-12-07 02:00:00'),
  17. (2, 15, 1, 1, '2011-12-07 02:00:00', '2011-12-07 02:00:00'),
  18. (3, 15, 2, 1, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
  19. (4, 1, 2, 15, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
  20. (5, 1, 3, 18, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
  21. (6, 18, 3, 1, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
  22. (7, 1, 4, 18, '2011-12-07 12:00:00', '2011-12-07 12:00:00'),
  23. (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