Files
houston-be/db/migration/000003_add_is_archived_column.up.sql
Gullipalli Chetan Kumar cd207a29c0 TP-43103 : Add houston user columns (#256)
* added new columns in houston user table

* added is archived column
2023-10-20 13:20:33 +05:30

9 lines
341 B
SQL

ALTER TABLE incident_channel
ADD COLUMN IF NOT EXISTS is_archived boolean;
ALTER TABLE IF EXISTS houston_user
ADD COLUMN IF NOT EXISTS is_bot boolean,
ADD COLUMN IF NOT EXISTS email character varying(255),
ADD COLUMN IF NOT EXISTS real_name character varying(100),
ADD COLUMN IF NOT EXISTS image character varying(500);