aboutsummaryrefslogtreecommitdiff
path: root/juick-server/src/main/resources/db/migration/V1.5__Drop acct index.sql
blob: 58757d88cb6af7efc2140f90a503323cba6a10be (plain) (blame)
1
2
3
4
5
6
ALTER TABLE followers ADD COLUMN `acct_migr` char(64) NOT NULL;
UPDATE followers SET `acct_migr` = `acct`;
ALTER TABLE followers DROP COLUMN `acct`;
ALTER TABLE followers ADD COLUMN `acct` char(64) NOT NULL;
UPDATE followers SET `acct` = `acct_migr`;
ALTER TABLE followers DROP COLUMN `acct_migr`;