diff options
| author | Ammarpad <ammarpad@yahoo.com> | 2021-02-03 06:25:30 +0100 |
|---|---|---|
| committer | Ammarpad <ammarpad@yahoo.com> | 2021-02-03 06:57:12 +0100 |
| commit | 4fe97dfd8b3d438541e27b220e29b7695272e688 (patch) | |
| tree | fb42bea6735284096387bac4920886c6f35c4256 /maintenance/postgres/archives/patch-uploadstash.sql | |
| parent | 9c9245d4a7a799f722d86c2b24489ae9e9a45e61 (diff) | |
| download | mediawikicore-4fe97dfd8b3d438541e27b220e29b7695272e688.tar.gz mediawikicore-4fe97dfd8b3d438541e27b220e29b7695272e688.zip | |
Postgres: Drop some pre-1.25 upgrade schema updates (part 1)
These are not clearly marked per release as they're in MysqlUpdater
until we reach 1.23 release, and I am not sure whether they're truly
in chronological order. Some of the files dropped here exists for Mysql
and here is there corresponding versions there, the rest do not exist
there.
* patch-page_restrictions.sql --1.10
* patch-protected_titles.sql --1.12
* patch-page_props.sql --1.13
* patch-category.sql --1.13
* patch-updatelog.sql --1.13
* patch-change_tag.sql --1.15
* patch-user_properties.sql --1.16
* patch-log_search.sql --1.16
* patch-l10n_cache.sql -- 1.16
* patch-iwlinks.sql -- 1.17
* patch-module_deps.sql -- 1.17
* patch-uploadstash.sql -1.18
* patch-user_former_groups.sql --1.18
* patch-sites.sql --1.21
These have no corresponding files
* patch-querycachetwo.sql
* patch-redirect.sql
Bug: T272199
Change-Id: I42830ffe8eb3ccad9b1f55d9f2629b388806335b
Diffstat (limited to 'maintenance/postgres/archives/patch-uploadstash.sql')
| -rw-r--r-- | maintenance/postgres/archives/patch-uploadstash.sql | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/maintenance/postgres/archives/patch-uploadstash.sql b/maintenance/postgres/archives/patch-uploadstash.sql deleted file mode 100644 index 8fd9fb99e832..000000000000 --- a/maintenance/postgres/archives/patch-uploadstash.sql +++ /dev/null @@ -1,24 +0,0 @@ -CREATE SEQUENCE uploadstash_us_id_seq; -CREATE TYPE media_type AS ENUM ('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE'); - -CREATE TABLE uploadstash ( - us_id INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('uploadstash_us_id_seq'), - us_user INTEGER, - us_key TEXT, - us_orig_path TEXT, - us_path TEXT, - us_source_type TEXT, - us_timestamp TIMESTAMPTZ, - us_status TEXT, - us_size INTEGER, - us_sha1 TEXT, - us_mime TEXT, - us_media_type media_type DEFAULT NULL, - us_image_width INTEGER, - us_image_height INTEGER, - us_image_bits INTEGER -); - -CREATE INDEX us_user_idx ON uploadstash (us_user); -CREATE UNIQUE INDEX us_key_idx ON uploadstash (us_key); -CREATE INDEX us_timestamp_idx ON uploadstash (us_timestamp); |