From 661b514403d8d872ede8ae9ad656ec7173399551 Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Wed, 31 Mar 2021 00:29:53 +0300 Subject: move Flyway resources back to resources/ --- src/main/resources/db/migration/V1.5__Drop acct index.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 src/main/resources/db/migration/V1.5__Drop acct index.sql (limited to 'src/main/resources/db/migration/V1.5__Drop acct index.sql') diff --git a/src/main/resources/db/migration/V1.5__Drop acct index.sql b/src/main/resources/db/migration/V1.5__Drop acct index.sql new file mode 100644 index 00000000..58757d88 --- /dev/null +++ b/src/main/resources/db/migration/V1.5__Drop acct index.sql @@ -0,0 +1,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`; \ No newline at end of file -- cgit v1.2.3