diff options
Diffstat (limited to 'pgsnmpd.sql')
| -rw-r--r-- | pgsnmpd.sql | 11 |
1 files changed, 11 insertions, 0 deletions
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)); |