diff options
author | mykhailo.dubovskyi | 2018-04-18 15:57:53 +0300 |
---|---|---|
committer | Vitaly Takmazov | 2018-04-20 11:03:47 +0300 |
commit | 842e903d5b987dd23e82a423bddae75acdea0c9c (patch) | |
tree | 59eabfb9969b6cbe00703674f8d3ddb7d2e029e0 /juick-server-jdbc/src/main/resources/schema.sql | |
parent | ef1c674b0dc1979e46e970ad67ccc7a9bb67b001 (diff) |
Like -> Reaction
Diffstat (limited to 'juick-server-jdbc/src/main/resources/schema.sql')
-rw-r--r-- | juick-server-jdbc/src/main/resources/schema.sql | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/juick-server-jdbc/src/main/resources/schema.sql b/juick-server-jdbc/src/main/resources/schema.sql index ec28a456..59c979d5 100644 --- a/juick-server-jdbc/src/main/resources/schema.sql +++ b/juick-server-jdbc/src/main/resources/schema.sql @@ -39,13 +39,21 @@ CREATE TABLE IF NOT EXISTS `facebook` ( `crosspost` tinyint(1) unsigned NOT NULL DEFAULT '1', KEY `user_id` (`user_id`) ); + +CREATE TABLE IF NOT EXISTS `reactions` ( + `like_id` int(10) unsigned NOT NULL, + `description` varchar (100) NOT NULL +); CREATE TABLE IF NOT EXISTS `favorites` ( `user_id` int(10) unsigned NOT NULL, `message_id` int(10) unsigned NOT NULL, `ts` datetime NOT NULL, - UNIQUE KEY `user_id_2` (`user_id`,`message_id`), - KEY `message_id` (`message_id`) + `like_id` int(10), + foreign key (like_id) references reactions(like_id) ); + + + CREATE TABLE IF NOT EXISTS `friends_facebook` ( `user_id` int(10) unsigned NOT NULL, `friend_id` bigint(20) unsigned NOT NULL, |