-- Table: "www-data".accounts_user

-- DROP TABLE "www-data".accounts_user;

CREATE TABLE "www-data".accounts_user
(
    id integer NOT NULL DEFAULT nextval('"www-data".accounts_user_id_seq'::regclass),
    password character varying(128) COLLATE pg_catalog."default" NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    first_name character varying(128) COLLATE pg_catalog."default",
    last_name character varying(128) COLLATE pg_catalog."default",
    email character varying(254) COLLATE pg_catalog."default" NOT NULL,
    phone character varying(30) COLLATE pg_catalog."default",
    registration_key character varying(255) COLLATE pg_catalog."default",
    registration_id character varying(30) COLLATE pg_catalog."default",
    address_id integer,
    company_id integer,
    service_access character varying(20) COLLATE pg_catalog."default" NOT NULL,
    personal_data_access boolean NOT NULL,
    language_code character varying(4) COLLATE pg_catalog."default" NOT NULL,
    rules_accept_date date,
    personal_data_measurement boolean,
    personal_data_producent boolean,
    personal_data_marketing boolean,
    personal_data_other boolean,
    password_change_date date,
    personal_data_communication boolean,
    personal_data_direct_marketing boolean,
    "4pellet_terms" boolean NOT NULL DEFAULT false,
    CONSTRAINT accounts_user_pkey PRIMARY KEY (id),
    CONSTRAINT accounts_user_email_key UNIQUE (email)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE "www-data".accounts_user
    OWNER to "www-data";

-- Index: accounts_user_address_id_idx

-- DROP INDEX "www-data".accounts_user_address_id_idx;

CREATE INDEX accounts_user_address_id_idx
    ON "www-data".accounts_user USING btree
    (address_id)
    TABLESPACE pg_default;

-- Index: accounts_user_company_id_idx

-- DROP INDEX "www-data".accounts_user_company_id_idx;

CREATE INDEX accounts_user_company_id_idx
    ON "www-data".accounts_user USING btree
    (company_id)
    TABLESPACE pg_default;

-- Index: accounts_user_email_1c73dba5_like

-- DROP INDEX "www-data".accounts_user_email_1c73dba5_like;

CREATE INDEX accounts_user_email_1c73dba5_like
    ON "www-data".accounts_user USING btree
    (email COLLATE pg_catalog."default" varchar_pattern_ops)
    TABLESPACE pg_default;

-- Trigger: modifications_history

-- DROP TRIGGER modifications_history ON "www-data".accounts_user;

CREATE TRIGGER modifications_history
    AFTER UPDATE
    ON "www-data".accounts_user
    FOR EACH ROW
    EXECUTE PROCEDURE modlogfunc();

-- Trigger: reg_history

-- DROP TRIGGER reg_history ON "www-data".accounts_user;

CREATE TRIGGER reg_history
    AFTER INSERT
    ON "www-data".accounts_user
    FOR EACH ROW
    EXECUTE PROCEDURE reglogfunc();