From 8a3a29a08c14dbcd76004bbe5e4434dd326aeb54 Mon Sep 17 00:00:00 2001 From: River Tarnell Date: Mon, 7 May 2007 14:59:52 +0000 Subject: [PATCH] update --- maintenance/ora/tables.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/maintenance/ora/tables.sql b/maintenance/ora/tables.sql index 7b8dc80a3d..bbdb62ac51 100644 --- a/maintenance/ora/tables.sql +++ b/maintenance/ora/tables.sql @@ -244,7 +244,12 @@ CREATE TABLE oldimage ( oi_description CLOB, oi_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, oi_user_text CLOB NOT NULL, - oi_timestamp TIMESTAMP WITH TIME ZONE NOT NULL + oi_timestamp TIMESTAMP WITH TIME ZONE NOT NULL, + oi_metadata CLOB, + oi_media_type VARCHAR(10) DEFAULT NULL, + oi_major_mime VARCHAR(11) DEFAULT 'unknown', + oi_minor_mime VARCHAR(32) DEFAULT 'unknown', + oi_deleted INTEGER DEFAULT 0 NOT NULL ); CREATE INDEX oi_name ON oldimage (oi_name); -- 2.20.1