Files
xamxam/app/migrations/applied/032_channel_name.sql

8 lines
470 B
SQL

-- Migration 032: Change peertube_settings.channel_id to channel_name.
-- Channel is now identified by its full handle (name@host) instead of numeric ID.
-- The ID is resolved via the PeerTube API at upload time.
ALTER TABLE peertube_settings ADD COLUMN channel_name TEXT NOT NULL DEFAULT '';
-- Copy existing values if any (unlikely to have useful data since channel_id=1 is the default)
-- Drop is not supported; channel_id column will be ignored by the application.