diff options
| author | Pierre Schmitz <pierre@archlinux.de> | 2007-09-14 13:18:58 +0200 |
|---|---|---|
| committer | Pierre Schmitz <pierre@archlinux.de> | 2007-09-14 13:18:58 +0200 |
| commit | 8f416baead93a48e5799e44b8bd2e2c4859f4e04 (patch) | |
| tree | cd47ac55eb80a39e3225e8b4f3161b88ea16c2cf /maintenance/ora/tables.sql | |
| parent | d7d08bd1a17618c7d77a6b9b2989e9f7293d6ed6 (diff) | |
auf Version 1.11 aktualisiert; Login-Bug behoben
Diffstat (limited to 'maintenance/ora/tables.sql')
| -rw-r--r-- | maintenance/ora/tables.sql | 16 |
1 files changed, 11 insertions, 5 deletions
diff --git a/maintenance/ora/tables.sql b/maintenance/ora/tables.sql index d2436e1d..6d4b8ed5 100644 --- a/maintenance/ora/tables.sql +++ b/maintenance/ora/tables.sql @@ -226,7 +226,7 @@ CREATE TABLE image ( img_media_type CLOB, img_major_mime CLOB DEFAULT 'unknown', img_minor_mime CLOB DEFAULT 'unknown', - img_description CLOB NOT NULL, + img_description CLOB, img_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, img_user_text CLOB NOT NULL, img_timestamp TIMESTAMP WITH TIME ZONE @@ -236,7 +236,7 @@ CREATE INDEX img_timestamp_idx ON image (img_timestamp); CREATE TABLE oldimage ( oi_name VARCHAR(255) NOT NULL REFERENCES image(img_name), - oi_archive_name VARCHAR(255) NOT NULL, + oi_archive_name VARCHAR(255), oi_size INTEGER NOT NULL, oi_width INTEGER NOT NULL, oi_height INTEGER NOT NULL, @@ -244,9 +244,15 @@ 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 -); -CREATE INDEX oi_name ON oldimage (oi_name); + 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_timestamp ON oldimage (oi_name,oi_timestamp); +CREATE INDEX oi_name_archive_name ON oldimage (oi_name,oi_archive_name); CREATE SEQUENCE filearchive_fa_id_seq; CREATE TABLE filearchive ( |