From 4d5c62f966a3cac47537cc9378062e91bc13f50d Mon Sep 17 00:00:00 2001
From: masashi <masashi@ms-n.com>
Date: Tue, 11 Feb 2014 18:46:47 +0900
Subject: [PATCH] I decided the specifications in the database table below.

---
 database/postgres/monitor_plan.sql        | 18 ++++++++++++++++++
 database/postgres/monitor_server_info.sql |  9 +++++++++
 database/postgres/monitoring.sql          | 22 ++++++++++++++++++++++
 database/postgres/user_auth.sql           | 20 ++++++++++++++++++++
 4 files changed, 69 insertions(+)
 create mode 100644 database/postgres/monitor_plan.sql
 create mode 100644 database/postgres/monitor_server_info.sql
 create mode 100644 database/postgres/monitoring.sql
 create mode 100644 database/postgres/user_auth.sql

diff --git a/database/postgres/monitor_plan.sql b/database/postgres/monitor_plan.sql
new file mode 100644
index 0000000..228bb2e
--- /dev/null
+++ b/database/postgres/monitor_plan.sql
@@ -0,0 +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
+);
+
+
diff --git a/database/postgres/monitor_server_info.sql b/database/postgres/monitor_server_info.sql
new file mode 100644
index 0000000..9f6ea96
--- /dev/null
+++ b/database/postgres/monitor_server_info.sql
@@ -0,0 +1,9 @@
+
+CREATE TABLE monitor_server_info (
+	erverip      inet not null,
+	spnum        int  not null,
+	serverstat   int  not null,
+	serverinfo   text,
+	serverid     serial
+);
+
diff --git a/database/postgres/monitoring.sql b/database/postgres/monitoring.sql
new file mode 100644
index 0000000..c3967b7
--- /dev/null
+++ b/database/postgres/monitoring.sql
@@ -0,0 +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
+);
+
+
diff --git a/database/postgres/user_auth.sql b/database/postgres/user_auth.sql
new file mode 100644
index 0000000..10baf04
--- /dev/null
+++ b/database/postgres/user_auth.sql
@@ -0,0 +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
+);
+
+
-- 
2.11.0