From 5b20afad3126191b3a10e535411eea6287676555 Mon Sep 17 00:00:00 2001 From: masashi Date: Thu, 13 Feb 2014 16:34:11 +0900 Subject: [PATCH 1/1] modified sql 20140213-2 --- database/postgres/monitor_plan_table.sql | 14 ++++++++++++++ database/postgres/monitor_server_info_table.sql | 8 ++++++++ database/postgres/monitoring_table.sql | 18 +++++++++++++++++- database/postgres/user_auth_table.sql | 16 ++++++++++++++++ 4 files changed, 55 insertions(+), 1 deletion(-) diff --git a/database/postgres/monitor_plan_table.sql b/database/postgres/monitor_plan_table.sql index 158a341..be868f0 100644 --- 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 --- 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 --- 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 --- 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 ''; -- 2.11.0