Stuff

CREATE TABLE ilog.logs_week
(
  logs_week_id integer NOT NULL,
  logs_week_host character varying(128) NOT NULL,
  logs_week_facility character varying(45) NOT NULL,
  logs_week_priority character varying(45) NOT NULL,
  logs_week_level character varying(45) NOT NULL,
  logs_week_tag character varying(45) NOT NULL,
  logs_week_program character varying(45) NOT NULL,
  logs_week_message text NOT NULL,
  logs_week_timestamp timestamp without time zone NOT NULL DEFAULT now(),
  logs_week_datetime timestamp without time zone NOT NULL,
  CONSTRAINT pkey_log_week_id PRIMARY KEY (logs_week_id)
)
WITH (OIDS=FALSE);
ALTER TABLE ilog.logs_week OWNER TO ilog;


TRIGGER:


BEGIN
INSERT INTO ilog.logs_week 
(
 logs_week_host,
 logs_week_facility,
 logs_week_priority,
 logs_week_level,
 logs_week_tag,
 logs_week_program,
 logs_week_message,
 logs_week_timestamp,
 logs_week_datetime
)
VALUES
(
 NEW.logs_day_host,
 NEW.logs_day_facility,
 NEW.logs_day_priority,
 NEW.logs_day_level,
 NEW.logs_day_tag,
 NEW.logs_day_program,
 NEW.logs_day_message,
 NEW.logs_day_timestamp,
 NEW.logs_day_datetime 
);
END;