23 lines
572 B
SQL
23 lines
572 B
SQL
CREATE TABLE IF NOT EXISTS fluxer.admin_api_keys (
|
|
key_id bigint,
|
|
key_hash text,
|
|
name text,
|
|
created_by_user_id bigint,
|
|
created_at timestamp,
|
|
last_used_at timestamp,
|
|
expires_at timestamp,
|
|
version int,
|
|
PRIMARY KEY (key_id)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS fluxer.admin_api_keys_by_creator (
|
|
created_by_user_id bigint,
|
|
key_id bigint,
|
|
created_at timestamp,
|
|
name text,
|
|
expires_at timestamp,
|
|
last_used_at timestamp,
|
|
version int,
|
|
PRIMARY KEY (created_by_user_id, key_id)
|
|
) WITH CLUSTERING ORDER BY (key_id DESC);
|