08374e7984
* feat: db users: admin -> windmill_admin, app -> windmill_user * clean up * backend tests * backend tests * backend tests * lock roles in first migration * check if user is superuser too * add init-db * add init-db
14 lines
412 B
SQL
14 lines
412 B
SQL
-- Add up migration script here
|
|
|
|
CREATE TYPE WORKSPACE_KEY_KIND AS ENUM ('cloud');
|
|
|
|
CREATE TABLE workspace_key (
|
|
workspace_id VARCHAR(50) NOT NULL REFERENCES workspace(id),
|
|
kind WORKSPACE_KEY_KIND NOT NULL,
|
|
key VARCHAR(255) NOT NULL DEFAULT 'changeme',
|
|
PRIMARY KEY (workspace_id, kind)
|
|
);
|
|
|
|
INSERT INTO workspace_key SELECT id as workspace_id, 'cloud' as kind, 'changeme' as key FROM workspace;
|
|
|