     initiator uuid,
     reftype character varying(20) NOT NULL,
     refid integer,
-    "timestamp" timestamp without time zone NOT NULL,
+    "timestamp" timestamp with time zone DEFAULT now() NOT NULL,
     ip character varying(255)
 );
 

    fullsize character varying(255) NOT NULL,
    label character varying(255) NOT NULL,
    requested_by uuid,
    posted timestamp without time zone NOT NULL,
    reserved_by uuid,
    deviation_id character varying(7),
    lock boolean DEFAULT false NOT NULL,
    reserved_at timestamp without time zone
);



    name character varying(20) NOT NULL,
    role character varying(10) DEFAULT 'user'::character varying NOT NULL,
    avatar_url character varying(255) NOT NULL,
    signup_date timestamp with time zone DEFAULT now() NOT NULL
);


