From fe9d8f21bbdfb442b8233b4627a0c67dc458a8bd Mon Sep 17 00:00:00 2001 From: Joshua Tolley Date: Fri, 26 Nov 2010 10:22:01 -0700 Subject: Import from CVS --- pgsnmpd.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 pgsnmpd.sql (limited to 'pgsnmpd.sql') diff --git a/pgsnmpd.sql b/pgsnmpd.sql new file mode 100644 index 0000000..c38dfca --- /dev/null +++ b/pgsnmpd.sql @@ -0,0 +1,11 @@ +CREATE TABLE pgsnmpd_rdbmsDbTable ( + -- ideally this would reference pg_database.oid, but pgsql won't allow such a reference + database_oid OID PRIMARY KEY, + vendor_name VARCHAR(255) DEFAULT 'PostgreSQL Global Development Group', + contact_name VARCHAR(255), + last_backup TIMESTAMPTZ); + +CREATE TABLE pgsnmpd_rdbmsSrvTable ( + vendor_name VARCHAR(255) DEFAULT 'PostgreSQL Global Development Group', + product_name VARCHAR(255) DEFAULT 'PostgreSQL', + contact_name VARCHAR(255)); -- cgit v1.2.3