X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fpr0n.sql;fp=sql%2Fpr0n.sql;h=5fd04e7e9da4872719e7b1cbe9eaf257b0d53077;hp=0bca09ae79eb41c16ad6231f1c2bc06416171962;hb=4c7426477a73edd5ad88bfebda56575019d5ca06;hpb=82b2e541984df6f697a5a73f2faaa99e40dfc832 diff --git a/sql/pr0n.sql b/sql/pr0n.sql index 0bca09a..5fd04e7 100644 --- a/sql/pr0n.sql +++ b/sql/pr0n.sql @@ -23,8 +23,8 @@ CREATE TABLE images ( 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, @@ -39,8 +39,8 @@ CREATE TABLE deleted_images ( 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,