blob: 89163783212684f0ab51a8277544dd2c7acd11fd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
-- +goose Up
CREATE TABLE IF NOT EXISTS trusted_users (
trusting_user_id INT NOT NULL REFERENCES users (id),
trusted_user_id INT NOT NULL REFERENCES users (id),
trusted_public_key BLOB NOT NULL,
PRIMARY KEY (trusting_user_id, trusted_user_id)
);
CREATE TABLE IF NOT EXISTS blocked_users (
blocking_user_id INT NOT NULL REFERENCES users (id),
blocked_user_id INT NOT NULL REFERENCES users (id),
PRIMARY KEY (blocking_user_id, blocked_user_id)
);
-- +goose Down
DROP TABLE IF EXISTS trusted_users;
DROP TABLE IF EXISTS blocked_users;
|
