g3GdaREE

1CREATE TABLE IF NOT EXISTS users (
2    id SERIAL PRIMARY KEY,
3    nickname VARCHAR(128) UNIQUE NOT NULL,
4    email VARCHAR(128) UNIQUE NOT NULL,
5    password_hash CHAR(80) NOT NULL
6);
7
8CREATE TABLE IF NOT EXISTS videos (
9    id SERIAL PRIMARY KEY,
10    hash CHAR(44) UNIQUE NOT NULL,
11    name VARCHAR(512) NOT NULL,
12    description VARCHAR(2048) NOT NULL,
13    viewed INTEGER NOT NULL,
14    owner SERIAL REFERENCES users ON DELETE SET NULL
15);