From c33876f834bffee3de59b93b5dfd9c54bd760d8b Mon Sep 17 00:00:00 2001
From: Amir Sarabadani <Ladsgroup@gmail.com>
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

