diff options
| author | Amir Sarabadani <Ladsgroup@gmail.com> | 2020-12-23 04:59:12 +0100 |
|---|---|---|
| committer | Amir Sarabadani <Ladsgroup@gmail.com> | 2021-01-09 16:07:54 +0100 |
| commit | c33876f834bffee3de59b93b5dfd9c54bd760d8b (patch) | |
| tree | 483b359c7a16c27e0e3bd39712d5018b9c755d32 /maintenance/postgres/archives/patch-update_sequences.sql | |
| parent | 5cfdb13c0f75c03ef442f477dae49148f866c1c1 (diff) | |
| download | mediawikicore-c33876f834bffee3de59b93b5dfd9c54bd760d8b.tar.gz mediawikicore-c33876f834bffee3de59b93b5dfd9c54bd760d8b.zip | |
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
Diffstat (limited to 'maintenance/postgres/archives/patch-update_sequences.sql')
| -rw-r--r-- | maintenance/postgres/archives/patch-update_sequences.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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'); |