From 39aa3d526d2843ade7d5631ec00f4a22a0b82d1b Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Mon, 7 May 2007 15:22:20 +0000 Subject: [PATCH] Add new columns to oldimage table. --- maintenance/postgres/tables.sql | 7 ++++++- maintenance/updaters.inc | 5 +++++ 2 files changed, 11 insertions(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 1c7c42dcb0..448dfa7cf7 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -262,7 +262,12 @@ CREATE TABLE oldimage ( oi_description TEXT, oi_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, oi_user_text TEXT NOT NULL, - oi_timestamp TIMESTAMPTZ NOT NULL + oi_timestamp TIMESTAMPTZ NOT NULL, + oi_metadata BYTEA NOT NULL, + oi_media_type TEXT NULL, + oi_major_mime TEXT NOT NULL DEFAULT 'unknown', + oi_minor_mime TEXT NOT NULL DEFAULT 'unknown', + oi_deleted CHAR NOT NULL DEFAULT '0' ); CREATE INDEX oi_name ON oldimage (oi_name); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index bca43f16ef..8ad4f4b16b 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1196,6 +1196,11 @@ function do_postgres_updates() { array("logging", "log_params", "TEXT"), array("mwuser", "user_editcount", "INTEGER"), array("mwuser", "user_newpass_time", "TIMESTAMPTZ"), + array("oldimage", "oi_metadata", "BYTEA NOT NULL"), + array("oldimage", "oi_media_type", "TEXT NOT NULL"), + array("oldimage", "oi_major_mime", "TEXT NOT NULL DEFAULT 'unknown'"), + array("oldimage", "oi_minor_mime", "TEXT NOT NULL DEFAULT 'unknown'"), + array("oldimage", "oi_deleted", "CHAR NOT NULL DEFAULT '0'"), array("page_restrictions", "pr_id", "INTEGER NOT NULL UNIQUE DEFAULT nextval('pr_id_val')"), array("recentchanges", "rc_deleted", "INTEGER NOT NULL DEFAULT 0"), array("recentchanges", "rc_log_action", "TEXT"), -- 2.20.1