mirror of https://github.com/coder/coder.git
29 lines
671 B
SQL
29 lines
671 B
SQL
CREATE TYPE new_audit_action AS ENUM (
|
|
'create',
|
|
'write',
|
|
'delete',
|
|
'start',
|
|
'stop'
|
|
);
|
|
|
|
CREATE TYPE new_resource_type AS ENUM (
|
|
'organization',
|
|
'template',
|
|
'template_version',
|
|
'user',
|
|
'workspace',
|
|
'git_ssh_key',
|
|
'api_key',
|
|
'group',
|
|
'workspace_build'
|
|
);
|
|
|
|
ALTER TABLE audit_logs
|
|
ALTER COLUMN action TYPE new_audit_action USING (action::text::new_audit_action),
|
|
ALTER COLUMN resource_type TYPE new_resource_type USING (resource_type::text::new_resource_type);
|
|
|
|
DROP TYPE audit_action;
|
|
ALTER TYPE new_audit_action RENAME TO audit_action;
|
|
DROP TYPE resource_type;
|
|
ALTER TYPE new_resource_type RENAME TO resource_type;
|