asQKTd7P

1-- 
2DROP DATABASE IF EXISTS SycamoreDB; -- DELTE THIS LATER
3CREATE DATABASE IF NOT EXISTS SycamoreDB;
4USE SycamoreDB;
5CREATE TABLE IF NOT EXISTS User (
6	user_id INT PRIMARY KEY AUTO_INCREMENT,
7    name VARCHAR(100) NOT NULL,
8    email VARCHAR(64) NOT NULL,
9    img_url VARCHAR(200) NOT NULL -- store default picture location if no Google profile pic
10);
11
12INSERT INTO User (name, email, img_url)
13	VALUES ('tommy trojan', 'tt@usc.edu', 'photo.jpg');
14
15CREATE TABLE IF NOT EXISTS Events (
16	event_id INT PRIMARY KEY AUTO_INCREMENT,
17    FOREIGN KEY fk1(user_id) REFERENCES User(user_id),
18    date INT NOT NULL,
19    title VARCHAR(45) NOT NULL,
20    summary VARCHAR(45) -- can be null
21);
22
23CREATE TABLE IF NOT EXISTS Followers (
24	relationship_id INT PRIMARY KEY AUTO_INCREMENT, -- could be thought of as an edge between two nodes (users)
25    FOREIGN KEY fk2(user_id) REFERENCES User(user_id), -- references the user who is being followed
26    FOREIGN KEY fk3(follower_id) REFERENCES User(user_id) -- references the follower's user_id
27);