findtheti.me/migrations/20240108085633_FixEventSnowflakeId.sql
2024-01-08 20:09:26 +02:00

8 lines
No EOL
233 B
SQL

ALTER TABLE events.event
DROP COLUMN IF EXISTS snowflake_if;
ALTER TABLE events.event
ADD COLUMN IF NOT EXISTS snowflake_id VARCHAR(255) NOT NULL;
ALTER TABLE events.event
ADD CONSTRAINT UQ_event_snowflake_id UNIQUE (snowflake_id);