     preview character varying(255),
     fullsize character varying(255),
     label character varying(255),
-    posted timestamp without time zone NOT NULL,
+    posted timestamp with time zone DEFAULT now() NOT NULL,
     reserved_by uuid,
     deviation_id character varying(7),
     lock boolean DEFAULT false NOT NULL

    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
);


