mirror of
https://github.com/memohai/Memoh.git
synced 2026-04-27 07:16:19 +09:00
KasuganoSora
18 lines
1.1 KiB
SQL
18 lines
1.1 KiB
SQL
-- 0064_revert_local_to_web
|
|
-- Revert channel_type 'local' back to 'web' to match updated adapter constants.
|
|
-- The original 0056 migration merged web/cli → local; this undoes that change.
|
|
|
|
-- For channel_identities with unique constraint on (channel_type, channel_subject_id):
|
|
-- delete 'local' rows that would conflict with existing 'web' rows, then update the rest.
|
|
DELETE FROM channel_identities WHERE channel_type = 'local' AND channel_subject_id IN (
|
|
SELECT channel_subject_id FROM channel_identities WHERE channel_type = 'web'
|
|
);
|
|
UPDATE channel_identities SET channel_type = 'web' WHERE channel_type = 'local';
|
|
|
|
-- These tables don't have the same unique constraint, safe to update directly.
|
|
UPDATE user_channel_bindings SET channel_type = 'web' WHERE channel_type = 'local';
|
|
UPDATE bot_channel_configs SET channel_type = 'web' WHERE channel_type = 'local';
|
|
UPDATE channel_identity_bind_codes SET channel_type = 'web' WHERE channel_type = 'local';
|
|
UPDATE bot_channel_routes SET channel_type = 'web' WHERE channel_type = 'local';
|
|
UPDATE bot_sessions SET channel_type = 'web' WHERE channel_type = 'local';
|