-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.sql
70 lines (53 loc) · 1.6 KB
/
database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
CREATE DATABASE newsfeeds;
-- CREATE TABLE newnews(
-- n_id SERIAL PRIMARY KEY,
-- title VARCHAR(255),
-- description VARCHAR(255),
-- image VARCHAR(255)
-- );
CREATE TABLE user1(
user_id UUID DEFAULT uuid_generate_v4(),
user_name VARCHAR(255) NOT NULL,
user_email VARCHAR(255) NOT NULL UNIQUE,
user_password VARCHAR(255) NOT NULL,
PRIMARY KEY (user_id)
);
CREATE TABLE newslistings(
news_id SERIAL,
user_id UUID,
title VARCHAR(255),
description VARCHAR(255),
image VARCHAR(255),
PRIMARY KEY (news_id),
FOREIGN KEY (user_id) REFERENCES user1(user_id)
);
--insert users
INSERT INTO users (user_name, user_email, user_password) VALUES ('Mannawar', 'mannawar@gmail.com', 'secret');
-- CREATE TABLE todo(
-- todo_id SERIAL,
-- user_id UUID ,
-- description VARCHAR(255),
-- PRIMARY KEY (todo_id),
-- FOREIGN KEY (user_id) REFERENCES users(user_id)
-- );
-- CREATE DATABASE authtodolist;
--users
-- CREATE TABLE users(
-- user_id UUID DEFAULT uuid_generate_v4(),
-- user_name VARCHAR(255) NOT NULL,
-- user_email VARCHAR(255) NOT NULL UNIQUE,
-- user_password VARCHAR(255) NOT NULL,
-- PRIMARY KEY (user_id)
-- );
--todos
-- CREATE TABLE todos(
-- todo_id SERIAL,
-- user_id UUID,
-- description VARCHAR(255) NOT NULL,
-- PRIMARY KEY (todo_id),
-- FOREIGN KEY (user_id) REFERENCES users(user_id)
-- );
--fake users data
-- insert into users (user_name, user_email, user_password) values ('Jacob', 'jacob@gmail.com', 'kthl8822');
-- --fake todos data
-- insert into todos (user_id, description) values ('60dc16dd-c7f1-4fde-827a-90c0e101555c', 'clean room');