blob: 7ae6aab33899b5b858e69dd6efeaf71316dcb311 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
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,
password_hash VARCHAR(100) NOT NULL,
created_at TIMESTAMP
WITH
TIME ZONE DEFAULT NOW(),
updated_at TIMESTAMP
WITH
TIME ZONE DEFAULT NOW()
);
|