Q

CREATE TABLE accounts_devices_polldata
(
  poll_entry bigserial NOT NULL,
  device_id int4 NOT NULL,
  poll_time timestamptz NOT NULL DEFAULT now(),
  cmts_status int2 NOT NULL,
  traffic_in int8 NOT NULL,
  traffic_out int8 NOT NULL,
  ds_power numeric(4,2) NOT NULL,
  ds_snr numeric(4,2) NOT NULL,
  tx_power numeric(4,2) NOT NULL
) 
WITH OIDS;
ALTER TABLE accounts_devices_polldata OWNER TO kelvin;
GRANT ALL ON TABLE accounts_devices_polldata TO kelvin;
GRANT SELECT, INSERT ON TABLE accounts_devices_polldata TO GROUP m2_poller;