diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-11-22 10:44:38 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-11-22 10:44:38 +0000 |
| commit | ef96e6db41641268e255003d3df11c27e0b64302 (patch) | |
| tree | 5080d07bf55b30aeda18c7b7c4df07c37ce95870 /create/postgresql/schema.sql | |
| parent | eb4a518831c9e714c040bd5836ad0bb430a8149a (diff) | |
| download | zabbix-ef96e6db41641268e255003d3df11c27e0b64302.tar.gz zabbix-ef96e6db41641268e255003d3df11c27e0b64302.tar.xz zabbix-ef96e6db41641268e255003d3df11c27e0b64302.zip | |
- reverted multiple server patch. SQL scripts. (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2342 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 680e4319..358f8b43 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -25,7 +25,6 @@ CREATE TABLE hosts ( hostid serial, - serverid int4 DEFAULT '1' NOT NULL, host varchar(64) DEFAULT '' NOT NULL, useip int4 DEFAULT '0' NOT NULL, ip varchar(15) DEFAULT '127.0.0.1' NOT NULL, @@ -36,12 +35,10 @@ CREATE TABLE hosts ( error varchar(128) DEFAULT '' NOT NULL, available int4 DEFAULT '0' NOT NULL, PRIMARY KEY (hostid) - FOREIGN KEY (serverid) REFERENCES servers ); CREATE INDEX hosts_status on hosts (status); CREATE UNIQUE INDEX hosts_host on hosts (host); -CREATE INDEX hosts_server on hosts (serverid); -- -- Table structure for table 'items' @@ -54,7 +51,6 @@ CREATE TABLE items ( snmp_oid varchar(255) DEFAULT '' NOT NULL, snmp_port int4 DEFAULT '161' NOT NULL, hostid int4 NOT NULL, - serverid int4 DEFAULT '1' NOT NULL, description varchar(255) DEFAULT '' NOT NULL, key_ varchar(64) DEFAULT '' NOT NULL, delay int4 DEFAULT '0' NOT NULL, @@ -83,14 +79,12 @@ CREATE TABLE items ( logtimefmt varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (itemid), FOREIGN KEY (hostid) REFERENCES hosts - FOREIGN KEY (serverid) REFERENCES servers ); CREATE UNIQUE INDEX items_hostid_key on items (hostid,key_); --CREATE INDEX items_hostid on items (hostid); CREATE INDEX items_nextcheck on items (nextcheck); CREATE INDEX items_status on items (status); -CREATE INDEX items_server on items (serverid); -- -- Table structure for table 'config' @@ -748,17 +742,4 @@ CREATE TABLE autoreg ( PRIMARY KEY (id) ); --- --- Table structure for table 'servers' --- - -CREATE TABLE servers ( - serverid serial - host varchar(64) DEFAULT '' NOT NULL, - ip varchar(15) DEFAULT '127.0.0.1' NOT NULL, - port int4 DEFAULT '0' NOT NULL, - PRIMARY KEY (serverid), - PRIMARY KEY (serverid) -); - VACUUM ANALYZE; |