CREATE SCHEMA mailer
  AUTHORIZATION tasker;

GRANT ALL ON SCHEMA mailer TO tasker;
GRANT USAGE ON SCHEMA mailer TO tasker_web;

CREATE TABLE mailer.mailer
(
  id serial NOT NULL,
  email character varying(255) NOT NULL,
  reason integer DEFAULT NULL,
  till_date timestamp without time zone DEFAULT NULL,
  response character varying(255),  
  lst_staff_id integer DEFAULT 0,
  process_date timestamp without time zone DEFAULT NULL,
  CONSTRAINT pk_mailer PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE mailer.mailer OWNER TO tasker;
GRANT ALL ON TABLE mailer.mailer TO tasker;
GRANT ALL ON TABLE mailer.mailer TO tasker_web;