NHjdgjjZ

1CREATE DATABASE  IF NOT EXISTS `Reddit`;
2USE `Reddit`;
3
4DROP TABLE IF EXISTS Comments;
5DROP TABLE IF EXISTS Subreddit;
6
7CREATE TABLE Subreddit (
8    id VARCHAR(50) NOT NULL,
9    name VARCHAR(50) NOT NULL,
10    PRIMARY KEY (id)
11);
12DROP TABLE IF EXISTS Author;
13CREATE TABLE Author (
14    id int AUTO_INCREMENT NOT NULL,
15    name varchar(50) NOT NULL,
16    PRIMARY KEY (id)
17);
18CREATE TABLE Comments (
19    id VARCHAR(50) NOT NULL,
20    parent_id varchar(50) NOT NULL,
21    link_id VARCHAR(50) NOT NULL,
22    name VARCHAR(50) NOT NULL,
23    author_id int NOT NULL,
24    body LONGTEXT NOT NULL,  
25    subreddit VARCHAR(50) NOT NULL,
26    score int NOT NULL,
27    created_utc DATETIME NOT NULL,
28    PRIMARY KEY (id),  
29    FOREIGN KEY (subreddit) REFERENCES Subreddit(id),
30    FOREIGN KEY (author_id) REFERENCES Author(id)
31   
32);
33