V1_22__guild_role_id.sql (350B)
1 DELETE FROM guild_role; 2 ALTER TABLE guild_role ADD COLUMN IF NOT EXISTS discord_id VARCHAR(30) UNIQUE NOT NULL; 3 ALTER TABLE guild_role DROP COLUMN IF EXISTS name; 4 5 DELETE FROM guild_event_dmer; 6 ALTER TABLE guild_event_dmer ADD COLUMN IF NOT EXISTS discord_user_id VARCHAR(30) UNIQUE NOT NULL; 7 ALTER TABLE guild_event_dmer DROP COLUMN IF EXISTS name;