ddl.sql

DROP SCHEMA public CASCADE;

CREATE SCHEMA public
  AUTHORIZATION snmp;

CREATE TABLE walk
(
  id    BIGSERIAL PRIMARY KEY     NOT NULL,
  host  INET                      NOT NULL,
  start TIMESTAMP DEFAULT now() NOT NULL,
  stop  TIMESTAMP
);
CREATE TABLE getresponse
(
  id                BIGSERIAL PRIMARY KEY      NOT NULL,
  object_identifier BYTEA                      NOT NULL,
  tag               BYTEA                      NOT NULL,
  value             BYTEA,
  host              INET                       NOT NULL,
  timestamp         TIMESTAMP DEFAULT now() NOT NULL,
  walk              BIGINT,
  CONSTRAINT getresponse_walk_id_fk FOREIGN KEY (walk) REFERENCES walk (id)
);
CREATE INDEX getresponse_object_identifier_index ON getresponse (tag); -- Schema: public

GRANT ALL ON SCHEMA public TO snmp;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO snmp;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO snmp;