From ba0fc4fa20067528effd4802e53ceeb959640825 Mon Sep 17 00:00:00 2001 From: Pierre Schmitz Date: Thu, 12 Jan 2012 13:42:29 +0100 Subject: Update to MediaWiki 1.18.1 --- .../postgres/archives/patch-uploadstash.sql | 24 +++++++++++++++++++++ .../archives/patch-uploadstash_sequence.sql | 2 ++ maintenance/postgres/tables.sql | 25 ++++++++++++++++++++++ 3 files changed, 51 insertions(+) create mode 100644 maintenance/postgres/archives/patch-uploadstash.sql create mode 100644 maintenance/postgres/archives/patch-uploadstash_sequence.sql (limited to 'maintenance/postgres') diff --git a/maintenance/postgres/archives/patch-uploadstash.sql b/maintenance/postgres/archives/patch-uploadstash.sql new file mode 100644 index 00000000..8fd9fb99 --- /dev/null +++ b/maintenance/postgres/archives/patch-uploadstash.sql @@ -0,0 +1,24 @@ +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); diff --git a/maintenance/postgres/archives/patch-uploadstash_sequence.sql b/maintenance/postgres/archives/patch-uploadstash_sequence.sql new file mode 100644 index 00000000..550b794e --- /dev/null +++ b/maintenance/postgres/archives/patch-uploadstash_sequence.sql @@ -0,0 +1,2 @@ +ALTER TABLE uploadstash RENAME us_id_seq TO uploadstash_us_id_seq; +ALTER TABLE uploadstash ALTER COLUMN us_id SET DEFAULT NEXTVAL('uploadstash_us_id_seq'); diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index ac0258ff..9f6b8049 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -358,6 +358,31 @@ CREATE INDEX fa_dupe ON filearchive (fa_storage_group, fa_storage_key); CREATE INDEX fa_notime ON filearchive (fa_deleted_timestamp); CREATE INDEX fa_nouser ON filearchive (fa_deleted_user); +CREATE SEQUENCE 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('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); + CREATE SEQUENCE recentchanges_rc_id_seq; CREATE TABLE recentchanges ( -- cgit v1.2.3-54-g00ecf