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 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 maintenance/postgres/archives/patch-uploadstash.sql (limited to 'maintenance/postgres/archives/patch-uploadstash.sql') 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); -- cgit v1.2.2