diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-05-12 15:12:34 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-05-12 15:12:34 +0000 |
| commit | 1c61097f8490a7f34f61012c0fc54e38e091a4a4 (patch) | |
| tree | ff4caba28a17d3052447a284cba00f45e97ef558 /create/postgresql/schema.sql | |
| parent | 4182bc6afb20b00fa27a54c67056bb98a58a49bb (diff) | |
| download | zabbix-1c61097f8490a7f34f61012c0fc54e38e091a4a4.tar.gz zabbix-1c61097f8490a7f34f61012c0fc54e38e091a4a4.tar.xz zabbix-1c61097f8490a7f34f61012c0fc54e38e091a4a4.zip | |
- removed unused table stats (Alexei)
- removed all references to escalations (Alexei)
- table audit renamed to auditlog (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2826 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 5df15986..a49e0e68 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -185,10 +185,10 @@ CREATE TABLE users ( CREATE UNIQUE INDEX users_alias on users (alias); -- --- Table structure for table 'audit' +-- Table structure for table 'auditlog' -- -CREATE TABLE audit ( +CREATE TABLE auditlog ( auditid serial, userid int4 DEFAULT '0' NOT NULL, clock int4 DEFAULT '0' NOT NULL, @@ -198,8 +198,8 @@ CREATE TABLE audit ( PRIMARY KEY (auditid) ); -CREATE INDEX audit_userid_clock on audit (userid,clock); -CREATE INDEX audit_clock on audit (clock); +CREATE INDEX auditlog_userid_clock on auditlog (userid,clock); +CREATE INDEX auditlog_clock on auditlog (clock); -- -- Table structure for table 'actions' @@ -633,17 +633,17 @@ CREATE TABLE screens_items ( -- Table structure for table 'stats' -- -CREATE TABLE stats ( - itemid int4 DEFAULT '0' NOT NULL, - year int4 DEFAULT '0' NOT NULL, - month int4 DEFAULT '0' NOT NULL, - day int4 DEFAULT '0' NOT NULL, - hour int4 DEFAULT '0' NOT NULL, - value_max float8 DEFAULT '0.0000' NOT NULL, - value_min float8 DEFAULT '0.0000' NOT NULL, - value_avg float8 DEFAULT '0.0000' NOT NULL, - PRIMARY KEY (itemid,year,month,day,hour) -); +--CREATE TABLE stats ( +-- itemid int4 DEFAULT '0' NOT NULL, +-- year int4 DEFAULT '0' NOT NULL, +-- month int4 DEFAULT '0' NOT NULL, +-- day int4 DEFAULT '0' NOT NULL, +-- hour int4 DEFAULT '0' NOT NULL, +-- value_max float8 DEFAULT '0.0000' NOT NULL, +-- value_min float8 DEFAULT '0.0000' NOT NULL, +-- value_avg float8 DEFAULT '0.0000' NOT NULL, +-- PRIMARY KEY (itemid,year,month,day,hour) +--); -- -- Table structure for table 'usrgrp' |