PluralKit/crates/migrate/data/migrations/50.sql
alyssa 47c5990218 chore: move migrations to rust
also adds some basic test seed data
2025-07-24 01:36:04 +00:00

11 lines
No EOL
394 B
SQL

-- database version 50
-- change proxy switch config to an enum
alter table system_config
alter column proxy_switch drop default,
alter column proxy_switch type int
using case when proxy_switch then 1 else 0 end,
alter column proxy_switch set default 0,
add constraint proxy_switch_check check (proxy_switch = ANY (ARRAY[0,1,2]));
update info set schema_version = 50;