|
Revision 899
(checked in by goldoraf, 2 years ago)
|
Finished notifier demo app
|
| Line | |
|---|
| 1 |
CREATE TABLE `favorites` ( |
|---|
| 2 |
`id` int(10) unsigned NOT NULL auto_increment, |
|---|
| 3 |
`user_id` int(11) NOT NULL, |
|---|
| 4 |
`status_id` int(11) NOT NULL, |
|---|
| 5 |
PRIMARY KEY (`id`) |
|---|
| 6 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| 7 |
|
|---|
| 8 |
CREATE TABLE `friendships` ( |
|---|
| 9 |
`user_id` int(11) NOT NULL, |
|---|
| 10 |
`friend_id` int(11) NOT NULL |
|---|
| 11 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| 12 |
|
|---|
| 13 |
CREATE TABLE `statuses` ( |
|---|
| 14 |
`id` int(11) NOT NULL auto_increment, |
|---|
| 15 |
`text` text, |
|---|
| 16 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
|---|
| 17 |
`sender_id` int(11) default NULL, |
|---|
| 18 |
PRIMARY KEY (`id`) |
|---|
| 19 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| 20 |
|
|---|
| 21 |
CREATE TABLE `users` ( |
|---|
| 22 |
`id` int(11) NOT NULL auto_increment, |
|---|
| 23 |
`name` varchar(50) default NULL, |
|---|
| 24 |
`email` varchar(50) default NULL, |
|---|
| 25 |
`pwd` varchar(20) default NULL, |
|---|
| 26 |
PRIMARY KEY (`id`) |
|---|
| 27 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
