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/sqlite/tables-generated.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/sqlite/tables-generated.sql')
| -rw-r--r-- | maintenance/sqlite/tables-generated.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/maintenance/sqlite/tables-generated.sql b/maintenance/sqlite/tables-generated.sql index c1d5c3eeff73..85ce0c76269b 100644 --- a/maintenance/sqlite/tables-generated.sql +++ b/maintenance/sqlite/tables-generated.sql @@ -642,3 +642,9 @@ CREATE INDEX fa_deleted_timestamp ON /*_*/filearchive (fa_deleted_timestamp); CREATE INDEX fa_actor_timestamp ON /*_*/filearchive (fa_actor, fa_timestamp); CREATE INDEX fa_sha1 ON /*_*/filearchive (fa_sha1); + + +CREATE TABLE /*_*/text ( + old_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + old_text BLOB NOT NULL, old_flags BLOB NOT NULL +); |