mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
10 lines
371 B
SQL
10 lines
371 B
SQL
CREATE TABLE provisioner_keys (
|
|
id uuid PRIMARY KEY,
|
|
created_at timestamptz NOT NULL,
|
|
organization_id uuid NOT NULL REFERENCES organizations (id) ON DELETE CASCADE,
|
|
name varchar(64) NOT NULL,
|
|
hashed_secret bytea NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX provisioner_keys_organization_id_name_idx ON provisioner_keys USING btree (organization_id, lower(name));
|