From 726584287a721d22a0287e62a37e14c81e01b454 Mon Sep 17 00:00:00 2001 From: tobi Date: Fri, 13 Jun 2025 16:05:00 +0200 Subject: [bugfix] Remove hardcoded "public" db schema assumption (#4269) This pull request closes https://codeberg.org/superseriousbusiness/gotosocial/issues/4257 by removing the hardcoded "public" schema assumption in the database migrations. Tested on a local postgres with both the default public schema, and with the connection string (gotosocial schema) mentioned in the issue. Both seem to work OK! Reviewed-on: https://codeberg.org/superseriousbusiness/gotosocial/pulls/4269 Co-authored-by: tobi Co-committed-by: tobi --- .../20231128140847_remove_duplicate_indices.go | 26 +++++++++++----------- 1 file changed, 13 insertions(+), 13 deletions(-) (limited to 'internal/db/bundb/migrations/20231128140847_remove_duplicate_indices.go') diff --git a/internal/db/bundb/migrations/20231128140847_remove_duplicate_indices.go b/internal/db/bundb/migrations/20231128140847_remove_duplicate_indices.go index 486a42229..b51731b0d 100644 --- a/internal/db/bundb/migrations/20231128140847_remove_duplicate_indices.go +++ b/internal/db/bundb/migrations/20231128140847_remove_duplicate_indices.go @@ -48,79 +48,79 @@ func init() { { old: "new_accounts_pkey", new: "accounts_pkey", - table: "public.accounts", + table: "accounts", columns: []string{"id"}, }, { old: "new_accounts_uri_key", new: "accounts_uri_key", - table: "public.accounts", + table: "accounts", columns: []string{"uri"}, }, { old: "new_accounts_url_key", new: "accounts_url_key", - table: "public.accounts", + table: "accounts", columns: []string{"url"}, }, { old: "new_accounts_inbox_uri_key", new: "accounts_inbox_uri_key", - table: "public.accounts", + table: "accounts", columns: []string{"inbox_uri"}, }, { old: "new_accounts_outbox_uri_key", new: "accounts_outbox_uri_key", - table: "public.accounts", + table: "accounts", columns: []string{"outbox_uri"}, }, { old: "new_accounts_following_uri_key", new: "accounts_following_uri_key", - table: "public.accounts", + table: "accounts", columns: []string{"following_uri"}, }, { old: "new_accounts_followers_uri_key", new: "accounts_followers_uri_key", - table: "public.accounts", + table: "accounts", columns: []string{"followers_uri"}, }, { old: "new_accounts_featured_collection_uri_key", new: "accounts_featured_collection_uri_key", - table: "public.accounts", + table: "accounts", columns: []string{"featured_collection_uri"}, }, { old: "new_accounts_public_key_uri_key", new: "accounts_public_key_uri_key", - table: "public.accounts", + table: "accounts", columns: []string{"public_key_uri"}, }, { old: "new_emojis_pkey1", new: "emojis_pkey", - table: "public.emojis", + table: "emojis", columns: []string{"id"}, }, { old: "new_emojis_uri_key1", new: "emojis_uri_key", - table: "public.emojis", + table: "emojis", columns: []string{"uri"}, }, { old: "new_status_faves_pkey", new: "status_faves_pkey", - table: "public.status_faves", + table: "status_faves", columns: []string{"id"}, }, { old: "new_status_faves_uri_key", new: "status_faves_uri_key", - table: "public.status_faves", + table: "status_faves", columns: []string{"uri"}, }, } { -- cgit v1.2.3