r21956 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r21955‎ | r21956 | r21957 >
Date:15:22, 7 May 2007
Author:greg
Status:old
Tags:
Comment:
Add new columns to oldimage table.
Modified paths:
  • /trunk/phase3/maintenance/postgres/tables.sql (modified) (history)
  • /trunk/phase3/maintenance/updaters.inc (modified) (history)

Diff [purge]

Index: trunk/phase3/maintenance/postgres/tables.sql
@@ -262,7 +262,12 @@
263263 oi_description TEXT,
264264 oi_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL,
265265 oi_user_text TEXT NOT NULL,
266 - oi_timestamp TIMESTAMPTZ NOT NULL
 266+ oi_timestamp TIMESTAMPTZ NOT NULL,
 267+ oi_metadata BYTEA NOT NULL,
 268+ oi_media_type TEXT NULL,
 269+ oi_major_mime TEXT NOT NULL DEFAULT 'unknown',
 270+ oi_minor_mime TEXT NOT NULL DEFAULT 'unknown',
 271+ oi_deleted CHAR NOT NULL DEFAULT '0'
267272 );
268273 CREATE INDEX oi_name ON oldimage (oi_name);
269274
Index: trunk/phase3/maintenance/updaters.inc
@@ -1196,6 +1196,11 @@
11971197 array("logging", "log_params", "TEXT"),
11981198 array("mwuser", "user_editcount", "INTEGER"),
11991199 array("mwuser", "user_newpass_time", "TIMESTAMPTZ"),
 1200+ array("oldimage", "oi_metadata", "BYTEA NOT NULL"),
 1201+ array("oldimage", "oi_media_type", "TEXT NOT NULL"),
 1202+ array("oldimage", "oi_major_mime", "TEXT NOT NULL DEFAULT 'unknown'"),
 1203+ array("oldimage", "oi_minor_mime", "TEXT NOT NULL DEFAULT 'unknown'"),
 1204+ array("oldimage", "oi_deleted", "CHAR NOT NULL DEFAULT '0'"),
12001205 array("page_restrictions", "pr_id", "INTEGER NOT NULL UNIQUE DEFAULT nextval('pr_id_val')"),
12011206 array("recentchanges", "rc_deleted", "INTEGER NOT NULL DEFAULT 0"),
12021207 array("recentchanges", "rc_log_action", "TEXT"),