Files
team/server/channels/db/migrations/postgres/000147_create_autotranslation_tables.down.sql
66b169b93c MM-65756 Database Migrations, Indexes and Methods for Auto-Translation (#34047)
* AutoTranslate config settings

* comment out Agents provider

* Add auto translate timeout config validation

* i18n messages for autotranslation config validation

* fix test

* validate url for libreTranslate

* Feedback review

* Admin Console UI for Auto-Translation

* fix admin console conditional section display

* i18n

* removed unintentional change

* update admin.general.localization.autoTranslateProviderDescription newline

* fix lint

* Fix types

* UX feedback review

* fix typo in i18n

* Fix AutoTranslation feature flag

* feedback review

* Fix test default values

* feedback review

* re-add isHidden property to feature discovery

* Database Migrations, Indexes and Methods for Auto-Translation

* i18n

* fix retrylayer and storetest

* Fix search query

* fix lint

* remove the request.CTX and modify Translation model

* fix lint and external url

* Add settings to playwright

* Add empty as a valid value for the Provider

* Update jsonb queries

* Fix queries and add model methods

* fix go lint

* go lint fix 2

* fix db migrations

* feedback review + store cache

* increase migration number

* cleanup autotranslation store cache

* use NULL as objectType for posts

* fix bad merge

* fix tests

* add missing i18n

* Switch prop bags column to boolean

* fix lint

* fix tests

* Remove database search

* use Builder methods

---------

Co-authored-by: BenCookie95 <[email protected]>

Co-authored-by: Hanzo Dev <[email protected]>
2025-11-22 09:32:01 +08:00

21 lines
595 B
SQL

-- Drop users covering index
DROP INDEX IF EXISTS idx_users_id_locale;
-- Drop channels autotranslation index
DROP INDEX IF EXISTS idx_channels_autotranslation_enabled;
-- Drop channelmembers autotranslation index
DROP INDEX IF EXISTS idx_channelmembers_autotranslation_enabled;
-- Drop autotranslation columns
ALTER TABLE channelmembers
DROP COLUMN IF EXISTS autotranslation;
ALTER TABLE channels
DROP COLUMN IF EXISTS autotranslation;
-- Drop translations table indexes
DROP INDEX IF EXISTS idx_translations_updateat;
-- Drop translations table
DROP TABLE IF EXISTS translations;