From 0d18c9ae280beebb236373bc752462f635085e7f Mon Sep 17 00:00:00 2001 From: masashi Date: Thu, 13 Feb 2014 11:51:26 +0900 Subject: [PATCH] table modifide 20140213-2 --- database/postgres/monitor_plan_table.sql | 28 ++++++++++---------- database/postgres/monitor_server_info_table.sql | 12 ++++----- database/postgres/monitoring_table.sql | 34 ++++++++++++------------- database/postgres/user_auth_table.sql | 32 +++++++++++------------ 4 files changed, 53 insertions(+), 53 deletions(-) diff --git a/database/postgres/monitor_plan_table.sql b/database/postgres/monitor_plan_table.sql index 228bb2e..158a341 100644 --- a/database/postgres/monitor_plan_table.sql +++ b/database/postgres/monitor_plan_table.sql @@ -1,18 +1,18 @@ -CREATE TABLE monitor_plan ( - uukey int not null, - mpsnumber int not null, - moproto int not null, - serverid int not null, - modport int, - mailprno int not null, - mailreno int not null, - invtime int, - sosstat int, - starttime bigint, - stoptime bigint, - modhost char[1024], - mpukey serial +CREATE TABLE monitor_plan_table ( + uukey_in int not null, + mpsnumber_in int not null, + moproto_in int not null, + serverkey_in int not null, + modport_in int, + mailprno_in int not null, + mailreno_in int not null, + invtime_in int, + sosstat_in int, + starttime_lin bigint, + stoptime_lin bigint, + modhost_ch1024 char[1024], + mpukey_in serial ); diff --git a/database/postgres/monitor_server_info_table.sql b/database/postgres/monitor_server_info_table.sql index 9f6ea96..2207328 100644 --- a/database/postgres/monitor_server_info_table.sql +++ b/database/postgres/monitor_server_info_table.sql @@ -1,9 +1,9 @@ -CREATE TABLE monitor_server_info ( - erverip inet not null, - spnum int not null, - serverstat int not null, - serverinfo text, - serverid serial +CREATE TABLE monitor_server_info_table ( + erverip_inet inet not null, + spnum_in int not null, + serverstat_in int not null, + serverinfo_tx text, + serverkey_in serial ); diff --git a/database/postgres/monitoring_table.sql b/database/postgres/monitoring_table.sql index c3967b7..46b446b 100644 --- a/database/postgres/monitoring_table.sql +++ b/database/postgres/monitoring_table.sql @@ -1,22 +1,22 @@ -CREATE TABLE monitoring ( - juukey int not null, - msnumber int not null, - moproto int not null, - serverid int not null, - modport int not null, - mailprno int not null, - mailreno int not null, - mostat int not null, - msps int, - premsps int, - moextime bigint, - expitime bigint, - modhost char[1024], - moptions char[256], - moinfo char[1024], - mukey serial +CREATE TABLE monitoring_table ( + uukey_in int not null, + msnumber_in int not null, + moproto_in int not null, + serverkey_in int not null, + modport_in int not null, + mailprno_in int not null, + mailreno_in int not null, + mostat_in int not null, + msps_in int, + premsps_in int, + moextime_lin bigint, + expitime_lin bigint, + modhost_ch1024 char[1024], + moptions_ch256 char[256], + moinfo_ch1024 char[1024], + mukey_in serial ); diff --git a/database/postgres/user_auth_table.sql b/database/postgres/user_auth_table.sql index 10baf04..d6bc801 100644 --- a/database/postgres/user_auth_table.sql +++ b/database/postgres/user_auth_table.sql @@ -1,20 +1,20 @@ -CREATE TABLE user_auth ( - aastat int not null, - cnum int not null, - eoa1 int not null, - eoa2 int not null, - soip inet, - starttime bigint, - stoptime bigint, - lltime bigint, - detime bigint, - fmaddr char[256] not null, - uname char[128] not null, - pass char[256] not null, - sesid char[256], - makey char[256], - uukey serial +CREATE TABLE user_auth_table ( + aastat_in int not null, + cnum_in int not null, + eoa1_in int not null, + eoa2_in int not null, + soip_inet inet, + starttime_lin bigint, + stoptime_lin bigint, + lltime_lin bigint, + detime_lin bigint, + fmaddr_ch256 char[256] not null, + uname_ch128 char[128] not null, + pass_ch256 char[256] not null, + sesid_ch256 char[256], + makeys_ch256 char[256], + uukey_in serial ); -- 2.11.0