hYWJXmqy

1CREATE TABLE IF NOT EXISTS tweets
2(
3    id BIGINT PRIMARY KEY,
4    parent_id BIGINT,
5    time TIMESTAMP NOT NULL,
6    likes INTEGER UNSIGNED DEFAULT 0,
7    replies INTEGER UNSIGNED DEFAULT 0,
8    retweets INTEGER UNSIGNED DEFAULT 0,
9    text NVARCHAR(280) NOT NULL
10);
11
12CREATE TABLE IF NOT EXISTS hashtags
13(
14    id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY,
15    text NVARCHAR(280) NOT NULL
16);
17
18CREATE TABLE IF NOT EXISTS author
19(
20    id BIGINT PRIMARY KEY,
21    name NVARCHAR(15) NOT NULL,
22    followers INTEGER UNSIGNED DEFAULT 0,
23    following INTEGER UNSIGNED DEFAULT 0,
24    country NVARCHAR(80),
25    score FLOAT DEFAULT 0
26);
27
28CREATE TABLE IF NOT EXISTS author_tweet
29(
30    author_id BIGINT NOT NULL,
31    tweet_id BIGINT NOT NULL,
32    PRIMARY KEY (author_id, tweet_id)
33);
34
35CREATE TABLE IF NOT EXISTS event_hashtag
36(
37    event_id INTEGER UNSIGNED NOT NULL,
38    hashtag_id INTEGER UNSIGNED NOT NULL,
39    PRIMARY KEY (event_id, hashtag_id)
40);
41
42CREATE TABLE IF NOT EXISTS users 
43( 
44    id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
45    name NVARCHAR(40), 
46    email VARCHAR(320), 
47    password VARCHAR(64) 
48);
49
50CREATE TABLE IF NOT EXISTS user_query 
51(
52    user_id INTEGER UNSIGNED NOT NULL, 
53    query NVARCHAR(280) NOT NULL, 
54    PRIMARY KEY (user_id, query) 
55);
56
57CREATE TABLE IF NOT EXISTS events
58(
59    id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY DEFAULT 0,
60    text NVARCHAR(280) NOT NULL
61);