-- Sequence: log_gmao_logs_gmao_seq

-- DROP SEQUENCE log_gmao_logs_gmao_seq;

CREATE SEQUENCE log_gmao_logs_gmao_seq
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;
  

-- Table: logs_gmao

-- DROP TABLE logs_gmao;

CREATE TABLE logs_gmao
(
  id_log_gmao integer NOT NULL DEFAULT nextval('log_gmao_logs_gmao_seq'::regclass),
  domaine character varying(100),
  action character varying(1000),
  user_log character varying(200),
  date_log timestamp without time zone NOT NULL,
  CONSTRAINT log_gmao_pkey PRIMARY KEY (id_log_gmao)
)
WITH (
  OIDS=FALSE
);

ALTER TABLE logs_gmao OWNER TO postgres;

ALTER TABLE log_gmao_logs_gmao_seq OWNER TO postgres;