Index: trunk/phase3/maintenance/postgres/tables.sql |
— | — | @@ -262,7 +262,12 @@ |
263 | 263 | oi_description TEXT, |
264 | 264 | oi_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, |
265 | 265 | 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' |
267 | 272 | ); |
268 | 273 | CREATE INDEX oi_name ON oldimage (oi_name); |
269 | 274 | |
Index: trunk/phase3/maintenance/updaters.inc |
— | — | @@ -1196,6 +1196,11 @@ |
1197 | 1197 | array("logging", "log_params", "TEXT"), |
1198 | 1198 | array("mwuser", "user_editcount", "INTEGER"), |
1199 | 1199 | 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'"), |
1200 | 1205 | array("page_restrictions", "pr_id", "INTEGER NOT NULL UNIQUE DEFAULT nextval('pr_id_val')"), |
1201 | 1206 | array("recentchanges", "rc_deleted", "INTEGER NOT NULL DEFAULT 0"), |
1202 | 1207 | array("recentchanges", "rc_log_action", "TEXT"), |