Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Jan 5th, 2012  |  syntax: None  |  size: 0.97 KB  |  views: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  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');
clone this paste RAW Paste Data