modified sql 20140213-2

diff --git a/database/postgres/monitor_plan_table.sql b/database/postgres/monitor_plan_table.sql
index 158a341..be868f0 100644 (file)
--- a/database/postgres/monitor_plan_table.sql
+++ b/database/postgres/monitor_plan_table.sql
@@ -15,4 +15,18 @@ CREATE TABLE monitor_plan_table (
        mpukey_in      serial
 );
 
+COMMENT ON TABLE monitor_plan_table IS '';
+COMMENT ON COLUMN monitor_plan_table.uukey_in IS '';
+COMMENT ON COLUMN monitor_plan_table.mpsnumber_in IS '';
+COMMENT ON COLUMN monitor_plan_table.moproto_in IS '';
+COMMENT ON COLUMN monitor_plan_table.serverkey_in IS '';
+COMMENT ON COLUMN monitor_plan_table.modport_in IS '';
+COMMENT ON COLUMN monitor_plan_table.mailprno_in IS '';
+COMMENT ON COLUMN monitor_plan_table.mailreno_in IS '';
+COMMENT ON COLUMN monitor_plan_table.invtime_in IS '';
+COMMENT ON COLUMN monitor_plan_table.sosstat_in IS '';
+COMMENT ON COLUMN monitor_plan_table.starttime_lin IS '';
+COMMENT ON COLUMN monitor_plan_table.stoptime_lin IS '';
+COMMENT ON COLUMN monitor_plan_table.modhost_ch1024 IS '';
+COMMENT ON COLUMN monitor_plan_table.mpukey_in IS '';
 

diff --git a/database/postgres/monitor_server_info_table.sql b/database/postgres/monitor_server_info_table.sql
index 2207328..32f2b0c 100644 (file)
--- a/database/postgres/monitor_server_info_table.sql
+++ b/database/postgres/monitor_server_info_table.sql
@@ -7,3 +7,11 @@ CREATE TABLE monitor_server_info_table (
        serverkey_in    serial
 );
 
+COMMENT ON TABLE monitor_server_info_table IS '';
+COMMENT ON COLUMN monitor_server_info_table.erverip_inet IS '';
+COMMENT ON COLUMN monitor_server_info_table.spnum_in IS '';
+COMMENT ON COLUMN monitor_server_info_table.serverstat_in IS '';
+COMMENT ON COLUMN monitor_server_info_table.serverinfo_tx IS '';
+COMMENT ON COLUMN monitor_server_info_table.serverkey_in IS '';
+
+

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 '';
 

diff --git a/database/postgres/user_auth_table.sql b/database/postgres/user_auth_table.sql
index d6bc801..637fc36 100644 (file)
--- a/database/postgres/user_auth_table.sql
+++ b/database/postgres/user_auth_table.sql
@@ -17,4 +17,20 @@ CREATE TABLE user_auth_table (
        uukey_in      serial
 );
 
+COMMENT ON TABLE user_auth_table IS '';
+COMMENT ON COLUMN user_auth_table.aastat_in IS '';
+COMMENT ON COLUMN user_auth_table.cnum_in IS '';
+COMMENT ON COLUMN user_auth_table.eoa1_in IS '';
+COMMENT ON COLUMN user_auth_table.eoa2_in IS '';
+COMMENT ON COLUMN user_auth_table.soip_inet IS '';
+COMMENT ON COLUMN user_auth_table.starttime_lin IS '';
+COMMENT ON COLUMN user_auth_table.stoptime_lin IS '';
+COMMENT ON COLUMN user_auth_table.lltime_lin IS '';
+COMMENT ON COLUMN user_auth_table.detime_lin IS '';
+COMMENT ON COLUMN user_auth_table.fmaddr_ch256 IS '';
+COMMENT ON COLUMN user_auth_table.uname_ch128 IS '';
+COMMENT ON COLUMN user_auth_table.pass_ch256 IS '';
+COMMENT ON COLUMN user_auth_table.sesid_ch256 IS '';
+COMMENT ON COLUMN user_auth_table.makeys_ch256 IS '';
+COMMENT ON COLUMN user_auth_table.uukey_in IS '';