From fabf48e0ea518171c9b3e70fd927ee5c6f32fb29 Mon Sep 17 00:00:00 2001 From: River Tarnell Date: Wed, 2 May 2007 01:45:52 +0000 Subject: [PATCH] fields containing empty strings must be nullable in oracle --- maintenance/ora/tables.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/ora/tables.sql b/maintenance/ora/tables.sql index d2436e1d60..7b8dc80a3d 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, -- 2.20.1