jrTnpjbz

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