diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-08-03 12:44:14 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-08-03 12:44:14 +0000 |
| commit | fd2858e086034e8c5b1ffa7320d19e0f5c948017 (patch) | |
| tree | 7450dc452eb18807b29f90d08ac2bcc4ee0e2ad9 /create/postgresql/schema.sql | |
| parent | 7d77c9ce0800352701f414d200d9d51ec7323753 (diff) | |
| download | zabbix-fd2858e086034e8c5b1ffa7320d19e0f5c948017.tar.gz zabbix-fd2858e086034e8c5b1ffa7320d19e0f5c948017.tar.xz zabbix-fd2858e086034e8c5b1ffa7320d19e0f5c948017.zip | |
- PostreSQL related fixes (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@885 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 12868c56..d6e4fedf 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -128,7 +128,8 @@ CREATE TABLE triggers ( PRIMARY KEY (triggerid) ); -CREATE INDEX triggers_istrue on triggers (istrue); +CREATE INDEX triggers_value on triggers (value); +CREATE INDEX triggers_status on triggers (status); -- -- Table structure for table 'trigger_depends' @@ -320,7 +321,7 @@ CREATE TABLE media ( severity int4 DEFAULT '63' NOT NULL, PRIMARY KEY (mediaid), FOREIGN KEY (userid) REFERENCES users, - FOREIGN KEY (mediatypeid) REFERENCES media_type, + FOREIGN KEY (mediatypeid) REFERENCES media_type ); -- @@ -435,7 +436,7 @@ CREATE UNIQUE INDEX services_links_upidownid on services_links (serviceupid, ser CREATE TABLE rights ( rightid serial, - userid int4 DEFAULT '' NOT NULL, + userid int4 DEFAULT '0' NOT NULL, name char(255) DEFAULT '' NOT NULL, permission char(1) DEFAULT '' NOT NULL, id int4, |