-- SEQUENCE: public.favdocs_id_seq

-- DROP SEQUENCE public.favdocs_id_seq;

CREATE SEQUENCE public.favdocs_id_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 9223372036854775807
    CACHE 1;

ALTER SEQUENCE public.favdocs_id_seq
    OWNER TO postgres;

GRANT ALL ON SEQUENCE public.favdocs_id_seq TO dorisuser WITH GRANT OPTION;

GRANT ALL ON SEQUENCE public.favdocs_id_seq TO postgres;




-- Table: public.favdocs

-- DROP TABLE public.favdocs;

CREATE TABLE public.favdocs
(
    id bigint NOT NULL DEFAULT nextval('favdocs_id_seq'::regclass),
    rowid integer NOT NULL,
    userrefid integer NOT NULL,
    type integer NOT NULL,
    last timestamp with time zone NOT NULL,
    CONSTRAINT pk_favdoc PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.favdocs
    OWNER to postgres;

GRANT ALL ON TABLE public.favdocs TO postgres;

GRANT ALL ON TABLE public.favdocs TO dorisuser WITH GRANT OPTION;
-- Index: ix_favdocs_rowid

-- DROP INDEX public.ix_favdocs_rowid;

CREATE INDEX ix_favdocs_rowid
    ON public.favdocs USING btree
    (rowid ASC NULLS LAST)
    TABLESPACE pg_default;
-- Index: ix_favdocs_type

-- DROP INDEX public.ix_favdocs_type;

CREATE INDEX ix_favdocs_type
    ON public.favdocs USING btree
    (type ASC NULLS LAST)
    TABLESPACE pg_default;
-- Index: ix_favdocs_userrefid

-- DROP INDEX public.ix_favdocs_userrefid;

CREATE INDEX ix_favdocs_userrefid
    ON public.favdocs USING btree
    (userrefid ASC NULLS LAST)
    TABLESPACE pg_default;