X-Git-Url: http://git.osdn.net/view?a=blobdiff_plain;f=database%2Fpostgres%2Fmonitoring_table.sql;h=a803b8e640ff51a58f7610146c18376fe047b193;hb=5b20afad3126191b3a10e535411eea6287676555;hp=46b446b1be7180c546f4fa248dea528e1609c538;hpb=0d18c9ae280beebb236373bc752462f635085e7f;p=zither%2Fds-zither.git 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 '';