From c33876f834bffee3de59b93b5dfd9c54bd760d8b Mon Sep 17 00:00:00 2001 From: Amir Sarabadani Date: Wed, 23 Dec 2020 04:59:12 +0100 Subject: Migrate text table to abstract schema For MySQL/Sqlite, drop the table options, they are for MySQL < 5.0 which was released in 2003 and not any use today. For Postgres, rename pagecontent table to text, approved as part of the RFC. Swap order of creating auto-generated tables and manual tables. Bug: T230428 Bug: T164898 Change-Id: Id7510b80beed7a7297353094a57d5e2d4f12fc64 --- maintenance/postgres/archives/patch-update_sequences.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'maintenance/postgres/archives/patch-update_sequences.sql') diff --git a/maintenance/postgres/archives/patch-update_sequences.sql b/maintenance/postgres/archives/patch-update_sequences.sql index 94f7be4fd5d7..ece03c422457 100644 --- a/maintenance/postgres/archives/patch-update_sequences.sql +++ b/maintenance/postgres/archives/patch-update_sequences.sql @@ -1,8 +1,8 @@ ALTER TABLE revision RENAME rev_rev_id_val TO revision_rev_id_seq; ALTER TABLE revision ALTER COLUMN rev_id SET DEFAULT NEXTVAL('revision_rev_id_seq'); -ALTER TABLE pagecontent RENAME text_old_id_val TO text_old_id_seq; -ALTER TABLE pagecontent ALTER COLUMN old_id SET DEFAULT nextval('text_old_id_seq'); +ALTER TABLE text RENAME text_old_id_val TO text_old_id_seq; +ALTER TABLE text ALTER COLUMN old_id SET DEFAULT nextval('text_old_id_seq'); ALTER TABLE category RENAME category_id_seq TO category_cat_id_seq; ALTER TABLE category ALTER COLUMN cat_id SET DEFAULT nextval('category_cat_id_seq'); -- cgit v1.2.3