user auth modifide 20140301

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

diff --git a/database/postgres/monitor_server_info_table.sql b/database/postgres/monitor_server_info_table.sql
index 2207328..1fe77af 100644 (file)
--- a/database/postgres/monitor_server_info_table.sql
+++ b/database/postgres/monitor_server_info_table.sql
@@ -1,9 +1,17 @@
 
 CREATE TABLE monitor_server_info_table (
-       erverip_inet    inet not null,
+       serverip_inet   inet not null,
        spnum_in        int  not null,
        serverstat_in   int  not null,
-       serverinfo_tx   text,
+       serverinfo_ch1024   varchar(1024),
        serverkey_in    serial
 );
 
+COMMENT ON TABLE monitor_server_info_table IS 'monitoring server information.';
+COMMENT ON COLUMN monitor_server_info_table.serverip_inet IS 'server ip adress.';
+COMMENT ON COLUMN monitor_server_info_table.spnum_in IS 'server port number.';
+COMMENT ON COLUMN monitor_server_info_table.serverstat_in IS 'server status.';
+COMMENT ON COLUMN monitor_server_info_table.serverinfo_ch1024 IS 'server information.';
+COMMENT ON COLUMN monitor_server_info_table.serverkey_in IS 'monitoring server ID.';
+
+