| Index: trunk/phase3/maintenance/ora/tables.sql |
| — | — | @@ -244,7 +244,12 @@ |
| 245 | 245 | oi_description CLOB, |
| 246 | 246 | oi_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, |
| 247 | 247 | oi_user_text CLOB NOT NULL, |
| 248 | | - oi_timestamp TIMESTAMP WITH TIME ZONE NOT NULL |
| | 248 | + oi_timestamp TIMESTAMP WITH TIME ZONE NOT NULL, |
| | 249 | + oi_metadata CLOB, |
| | 250 | + oi_media_type VARCHAR(10) DEFAULT NULL, |
| | 251 | + oi_major_mime VARCHAR(11) DEFAULT 'unknown', |
| | 252 | + oi_minor_mime VARCHAR(32) DEFAULT 'unknown', |
| | 253 | + oi_deleted INTEGER DEFAULT 0 NOT NULL |
| 249 | 254 | ); |
| 250 | 255 | CREATE INDEX oi_name ON oldimage (oi_name); |
| 251 | 256 | |