ente/server/migrations/63_add_kex_store.up.sql
2024-03-01 13:37:01 +05:30

7 lines
273 B
SQL

CREATE TABLE IF NOT EXISTS kex_store (
id TEXT UNIQUE PRIMARY KEY NOT NULL,
user_id BIGINT NOT NULL,
wrapped_key TEXT NOT NULL,
added_at BIGINT NOT NULL,
CONSTRAINT fk_kex_store_user_id FOREIGN KEY(user_id) REFERENCES users(user_id) ON DELETE CASCADE
);