blob: c22cc19910b470000360ade14ac364dae35dfe13 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
-- +goose Up
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
public_key BLOB NOT NULL UNIQUE,
description TEXT NOT NULL DEFAULT '',
is_public_dm BOOLEAN NOT NULL CHECK (is_public_dm IN (false, true)) DEFAULT true,
is_deleted BOOLEAN NOT NULL CHECK (is_deleted IN (false, true)) DEFAULT false
);
CREATE TABLE IF NOT EXISTS user_data (
user_id INTEGER PRIMARY KEY REFERENCES users(id),
data TEXT NOT NULL
);
-- +goose Down
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS user_data;
|
