blob: c3332c81790dacdbbaec2648a1892e929db951dc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
-- +goose Up
CREATE TABLE IF NOT EXISTS networks (
id INTEGER PRIMARY KEY,
owner_id INT NOT NULL REFERENCES users (id),
name TEXT NOT NULL,
icon TEXT NOT NULL,
bg_hex_color TEXT NOT NULL,
fg_hex_color TEXT NOT NULL,
is_public BOOLEAN NOT NULL CHECK (is_public IN (false, true))
);
-- +goose Down
DROP TABLE IF EXISTS networks;
|
