AmFMiUHA

1CREATE 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
11INSERT INTO `messages` (`id`, `user_id`, `node_id`, `reciever_id`, `created`, `modified`) VALUES
12(1, 1, 1, 15, '2011-12-07 00:00:00', '2011-12-07 02:00:00'),
13(2, 15, 1, 1, '2011-12-07 02:00:00', '2011-12-07 02:00:00'),
14(3, 15, 2, 1, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
15(4, 1, 2, 15, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
16(5, 1, 3, 18, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
17(6, 18, 3, 1, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
18(7, 1, 4, 18, '2011-12-07 12:00:00', '2011-12-07 12:00:00'),
19(8, 18, 4, 1, '2011-12-07 12:00:00', '2011-12-07 12:00:00');
20
21
22CREATE TABLE IF NOT EXISTS `nodes` (
23  `id` int(11) unsigned NOT NULL auto_increment,
24  `message` text NOT NULL,
25  `author_id` int(11) unsigned NOT NULL,
26  `read` tinyint(1) default NULL,
27  `created` datetime default NULL,
28  `modified` datetime default NULL,
29  PRIMARY KEY  (`id`)
30) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
31
32INSERT INTO `nodes` (`id`, `message`, `author_id`, `read`, `created`, `modified`) VALUES
33(1, 'Hi! How are you ? dude wanna meet up this weekend ?', 1, 0, '2011-12-07 02:00:00', '2011-12-07 02:00:00'),
34(2, 'Sure. wanna go to Mangalore Pearl to eat Neer Dosa..', 15, 0, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
35(3, 'Hi How are u Buddy ? Long time no see...', 1, 0, '2011-12-07 11:00:00', '2011-12-07 11:00:00'),
36(4, 'yeah. are you back in town ? i think we should meet up man. its been ages ....', 18, 0, '2011-12-07 12:00:00', '2011-12-07 12:00:00');
37
38
39CREATE TABLE IF NOT EXISTS `users` (
40  `id` int(11) unsigned NOT NULL auto_increment,
41  `first_name` varchar(255) default NULL,
42  `last_name` varchar(255) default NULL,
43  `email` varchar(255) default NULL,
44  `password` varchar(40) default NULL,
45  `username` varchar(255) default NULL,
46  `birthday` date default NULL,
47  `gender` varchar(255) default NULL,
48  `city_id` int(11) unsigned NOT NULL,
49  `status` varchar(255) NOT NULL,
50  `created` datetime default NULL,
51  `modified` datetime default NULL,
52  PRIMARY KEY  (`id`)
53) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;