Summary of migrations from 0.16.0 to 0.17.0 (approximate)

0.17.0_migrations.sql

CREATE TABLE IF NOT EXISTS "conversations" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "other_account_ids" VARCHAR, "other_accounts_key" VARCHAR NOT NULL, "thread_id" CHAR(26) NOT NULL, "last_status_id" CHAR(26) NOT NULL, "read" BOOLEAN DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "conversations_account_id_last_status_id_uniq" UNIQUE ("account_id", "last_status_id"), CONSTRAINT "conversations_thread_id_account_id_other_accounts_key_uniq" UNIQUE ("account_id", "other_accounts_key", "thread_id"));
CREATE TABLE IF NOT EXISTS "conversation_to_statuses" ("conversation_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, CONSTRAINT "conversation_to_statuses_conversation_id_status_id_uniq" UNIQUE ("conversation_id", "status_id"));
CREATE INDEX IF NOT EXISTS "conversations_account_id_idx" ON "conversations" ("account_id");
CREATE INDEX IF NOT EXISTS "conversations_last_status_id_idx" ON "conversations" ("last_status_id");
ALTER TABLE "media_attachments" DROP COLUMN "file_updated_at";
ALTER TABLE "media_attachments" DROP COLUMN "thumbnail_updated_at";
CREATE TABLE IF NOT EXISTS "worker_tasks" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "worker_type" INTEGER NOT NULL, "task_data" BLOB NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp);
ALTER TABLE "statuses" ADD COLUMN "interaction_policy" JSONB;
ALTER TABLE "statuses" ADD COLUMN "pending_approval" BOOLEAN NOT NULL DEFAULT false;
ALTER TABLE "statuses" ADD COLUMN "approved_by_uri" varchar;
ALTER TABLE "account_settings" ADD COLUMN "interaction_policy_direct" JSONB;
ALTER TABLE "account_settings" ADD COLUMN "interaction_policy_mutuals_only" JSONB;
ALTER TABLE "account_settings" ADD COLUMN "interaction_policy_followers_only" JSONB;
ALTER TABLE "account_settings" ADD COLUMN "interaction_policy_unlocked" JSONB;
ALTER TABLE "account_settings" ADD COLUMN "interaction_policy_public" JSONB;
ALTER TABLE "statuses" DROP COLUMN "likeable";
ALTER TABLE "statuses" DROP COLUMN "replyable";
ALTER TABLE "statuses" DROP COLUMN "boostable";
CREATE INDEX IF NOT EXISTS "statuses_pending_approval_idx" ON "statuses" ("pending_approval");
CREATE INDEX IF NOT EXISTS "status_faves_pending_approval_idx" ON "status_faves" ("pending_approval");
CREATE TABLE IF NOT EXISTS "advanced_migrations" ("id" VARCHAR NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "state_json" BLOB, "finished" BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"));
ALTER TABLE "media_attachments" ADD "type_new" INTEGER NOT NULL DEFAULT 0;
UPDATE "media_attachments" SET "type_new" = 3 WHERE ("type" = 'Video');
UPDATE "media_attachments" SET "type_new" = 0 WHERE ("type" = 'Unknown');
UPDATE "media_attachments" SET "type_new" = 2 WHERE ("type" = 'Audio');
UPDATE "media_attachments" SET "type_new" = 1 WHERE ("type" = 'Image');
UPDATE "media_attachments" SET "type_new" = 1 WHERE ("type" = 'Gifv');
ALTER TABLE "media_attachments" DROP COLUMN "type";
ALTER TABLE "media_attachments" RENAME COLUMN "type_new" TO "type";
UPDATE "media_attachments" SET "url" = '', "file_path" = '', "file_content_type" = '', "file_file_size" = 0, "thumbnail_path" = '', "thumbnail_content_type" = '', "thumbnail_file_size" = 0, "thumbnail_url" = '' WHERE ("type" = 0);
UPDATE "emojis" SET "image_path" = '', "image_url" = '', "image_file_size" = 0, "image_content_type" = '', "image_static_path" = '', "image_static_url" = '', "image_static_file_size" = 0, "image_static_content_type" = '' WHERE ("image_url" = '') OR ("image_path" = '');
UPDATE "statuses" AS "status" SET content = NULL, content_warning = NULL, text = NULL, language = NULL, sensitive = FALSE WHERE (boost_of_id IS NOT NULL);
CREATE TABLE IF NOT EXISTS "followed_tags" ("account_id" CHAR(26) NOT NULL, "tag_id" CHAR(26) NOT NULL, PRIMARY KEY ("account_id", "tag_id"));
DROP TABLE IF EXISTS "interaction_approvals";
CREATE TABLE IF NOT EXISTS "interaction_requests" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "status_id" CHAR(26) NOT NULL, "target_account_id" CHAR(26) NOT NULL, "interacting_account_id" CHAR(26) NOT NULL, "interaction_uri" VARCHAR NOT NULL, "interaction_type" INTEGER NOT NULL, "accepted_at" timestamptz, "rejected_at" timestamptz, "uri" VARCHAR, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("interaction_uri"), UNIQUE ("uri"));
CREATE INDEX IF NOT EXISTS "interaction_requests_target_account_id_idx" ON "interaction_requests" ("target_account_id");
CREATE INDEX IF NOT EXISTS "interaction_requests_interacting_account_id_idx" ON "interaction_requests" ("interacting_account_id");
CREATE INDEX IF NOT EXISTS "interaction_requests_status_id_idx" ON "interaction_requests" ("status_id");
SELECT "status"."created_at", "status"."in_reply_to_id", "status"."boost_of_id", "status"."in_reply_to_account_id", "status"."boost_of_account_id", "status"."account_id", "status"."uri" FROM "statuses" AS "status" WHERE ("pending_approval" = TRUE);
SELECT "status_fave"."created_at", "status_fave"."status_id", "status_fave"."target_account_id", "status_fave"."account_id", "status_fave"."uri" FROM "status_faves" AS "status_fave" WHERE ("pending_approval" = TRUE);
CREATE TABLE IF NOT EXISTS "sin_bin_statuses" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "uri" VARCHAR NOT NULL, "url" VARCHAR, "domain" VARCHAR, "account_uri" VARCHAR NOT NULL, "in_reply_to_uri" VARCHAR, "content" VARCHAR, "attachment_links" VARCHAR, "mention_target_ur_is" VARCHAR, "emoji_links" VARCHAR, "poll_options" VARCHAR, "content_warning" VARCHAR, "visibility" VARCHAR NOT NULL, "sensitive" BOOLEAN NOT NULL DEFAULT false, "language" VARCHAR, "activity_streams_type" VARCHAR NOT NULL, PRIMARY KEY ("id"), UNIQUE ("id"), UNIQUE ("uri"));
CREATE INDEX IF NOT EXISTS "sin_bin_statuses_domain_idx" ON "sin_bin_statuses" ("domain");
CREATE INDEX IF NOT EXISTS "sin_bin_statuses_in_reply_to_uri_idx" ON "sin_bin_statuses" ("in_reply_to_uri");
CREATE INDEX IF NOT EXISTS "sin_bin_statuses_account_uri_idx" ON "sin_bin_statuses" ("account_uri");
ALTER TABLE "account_settings" ADD "web_visibility" TEXT NOT NULL DEFAULT 'public';
CREATE INDEX IF NOT EXISTS "interaction_requests_accepted_at_idx" ON "interaction_requests" ("accepted_at");
CREATE INDEX IF NOT EXISTS "interaction_requests_rejected_at_idx" ON "interaction_requests" ("rejected_at");
UPDATE "statuses" SET "pending_approval" = FALSE WHERE ("pending_approval" IS NULL);
UPDATE "status_faves" SET "pending_approval" = FALSE WHERE ("pending_approval" IS NULL);

No promises this will work for anyone, it's just a summary of migration statements from 0.16.0 to 0.17.0, taken from the trace logs when running the testrig.