as well. Also remember to do deleted_images, not just images.
vhost character varying NOT NULL,
event character varying NOT NULL,
filename character varying NOT NULL,
vhost character varying NOT NULL,
event character varying NOT NULL,
filename character varying NOT NULL,
- width integer DEFAULT -1 NOT NULL,
- height integer DEFAULT -1 NOT NULL,
+ width integer,
+ height integer,
uploadedby character varying NOT NULL,
"date" timestamp without time zone,
takenby character varying NOT NULL,
uploadedby character varying NOT NULL,
"date" timestamp without time zone,
takenby character varying NOT NULL,
vhost character varying,
event character varying NOT NULL,
filename character varying NOT NULL,
vhost character varying,
event character varying NOT NULL,
filename character varying NOT NULL,
- width integer DEFAULT -1 NOT NULL,
- height integer DEFAULT -1 NOT NULL,
+ width integer,
+ height integer,
uploadedby character varying,
"date" timestamp without time zone,
takenby character varying NOT NULL,
uploadedby character varying,
"date" timestamp without time zone,
takenby character varying NOT NULL,
ALTER TABLE images ALTER COLUMN height SET DEFAULT NULL;
UPDATE images SET width=NULL,height=NULL WHERE width=-1 OR height=-1;
ALTER TABLE images ADD CONSTRAINT width_height_nullity CHECK ((width IS NULL) = (height IS NULL));
ALTER TABLE images ALTER COLUMN height SET DEFAULT NULL;
UPDATE images SET width=NULL,height=NULL WHERE width=-1 OR height=-1;
ALTER TABLE images ADD CONSTRAINT width_height_nullity CHECK ((width IS NULL) = (height IS NULL));
+
+ALTER TABLE deleted_images ALTER COLUMN width DROP NOT NULL;
+ALTER TABLE deleted_images ALTER COLUMN height DROP NOT NULL;
+ALTER TABLE deleted_images ALTER COLUMN width SET DEFAULT NULL;
+ALTER TABLE deleted_images ALTER COLUMN height SET DEFAULT NULL;
+UPDATE deleted_images SET width=NULL,height=NULL WHERE width=-1 OR height=-1;
+ALTER TABLE deleted_images ADD CONSTRAINT width_height_nullity CHECK ((width IS NULL) = (height IS NULL));