CREATE SEQUENCE video_report_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER TABLE public.video_report_id_seq OWNER TO unahrajvideo;

 CREATE TABLE video_report (
    id INTEGER DEFAULT NEXTVAL('video_report_id_seq'::regclass) NOT NULL,
    video_id INTEGER NOT NULL,
    user_id INTEGER,
    reason CHARACTER VARYING(16) NOT NULL,
    email CHARACTER VARYING(64) NOT NULL,
    info text,
    "timestamp" TIMESTAMP WITHOUT TIME zone DEFAULT now() NOT NULL
);

ALTER TABLE public.video_report OWNER TO unahrajvideo;

CREATE INDEX video_id_report ON video_report USING btree (video_id);