blob: ca868937b2cfa13c7f3c594f13fd351f486e250d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE TABLE users (
uuid UUID NOT NULL PRIMARY KEY DEFAULT (uuid_generate_v4()),
name VARCHAR(100) NOT NULL,
email VARCHAR(255) NOT NULL UNIQUE,
session_epoch TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
);
CREATE TABLE credentials (
uuid UUID NOT NULL PRIMARY KEY,
password_hash VARCHAR(100) NOT NULL
);
|