modified sql 20140213-2

[zither/ds-zither.git] / database / postgres / monitoring_table.sql

diff --git a/database/postgres/monitoring_table.sql b/database/postgres/monitoring_table.sql
index 46b446b..a803b8e 100644 (file)
--- a/database/postgres/monitoring_table.sql
+++ b/database/postgres/monitoring_table.sql
@@ -1,5 +1,4 @@
 
-
 CREATE TABLE monitoring_table (
        uukey_in       int not null,
        msnumber_in    int not null,
@@ -19,4 +18,21 @@ CREATE TABLE monitoring_table (
        mukey_in       serial
 );
 
+COMMENT ON TABLE monitoring_table IS '';
+COMMENT ON COLUMN monitoring_table.uukey_in IS '';
+COMMENT ON COLUMN monitoring_table.msnumber_in IS '';
+COMMENT ON COLUMN monitoring_table.moproto_in IS '';
+COMMENT ON COLUMN monitoring_table.serverkey_in IS '';
+COMMENT ON COLUMN monitoring_table.modport_in IS '';
+COMMENT ON COLUMN monitoring_table.mailprno_in IS '';
+COMMENT ON COLUMN monitoring_table.mailreno_in IS '';
+COMMENT ON COLUMN monitoring_table.mostat_in IS '';
+COMMENT ON COLUMN monitoring_table.msps_in IS '';
+COMMENT ON COLUMN monitoring_table.premsps_in IS '';
+COMMENT ON COLUMN monitoring_table.moextime_lin IS '';
+COMMENT ON COLUMN monitoring_table.expitime_lin IS '';
+COMMENT ON COLUMN monitoring_table.modhost_ch1024 IS '';
+COMMENT ON COLUMN monitoring_table.moptions_ch256 IS '';
+COMMENT ON COLUMN monitoring_table.moinfo_ch1024 IS '';
+COMMENT ON COLUMN monitoring_table.mukey_in IS '';