feel/database.sql at master · Ethorf/feel · GitHub

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
-- CREATE DATABASE authtodo;

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)
);

CREATE TABLE blog_posts(
  post_id SERIAL,
  title VARCHAR(255),
  content TEXT,
  date TEXT,
  PRIMARY KEY (post_id)
);


CREATE TABLE userstest(
  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 events(
  id SERIAL,
  title VARCHAR(255),
  description TEXT,
  event_start TEXT,
  event_end TEXT,
  is_cancelled BOOLEAN,
  PRIMARY KEY (post_id)
);


CREATE TABLE events(id SERIAL, title VARCHAR(255), description TEXT, eventstart TEXT, eventend TEXT, is_cancelled BOOLEAN, PRIMARY KEY (id));