diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-28 19:16:46 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-28 19:16:46 +0000 |
| commit | 7d79fcd9d326e2580cb3148a71f1cdfad565c93f (patch) | |
| tree | 700c570ee1b6b93be6379a4613cce9dce8c51bea /upgrades/dbpatches/1.3/postgresql/patch/conditions.sql | |
| parent | f5cf1fe9d024f7c13d0fee840abe4893500ea181 (diff) | |
| download | zabbix-7d79fcd9d326e2580cb3148a71f1cdfad565c93f.tar.gz zabbix-7d79fcd9d326e2580cb3148a71f1cdfad565c93f.tar.xz zabbix-7d79fcd9d326e2580cb3148a71f1cdfad565c93f.zip | |
Better PostgreSQL patches.
git-svn-id: svn://svn.zabbix.com/trunk@3856 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/conditions.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/conditions.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/conditions.sql b/upgrades/dbpatches/1.3/postgresql/patch/conditions.sql index ddf10df4..e0f8f834 100644 --- a/upgrades/dbpatches/1.3/postgresql/patch/conditions.sql +++ b/upgrades/dbpatches/1.3/postgresql/patch/conditions.sql @@ -1,13 +1,13 @@ CREATE TABLE conditions_tmp ( - conditionid bigint unsigned DEFAULT '0' NOT NULL, - actionid bigint unsigned DEFAULT '0' NOT NULL, - conditiontype integer DEFAULT '0' NOT NULL, - operator integer DEFAULT '0' NOT NULL, - value varchar(255) DEFAULT '' NOT NULL, + conditionid bigint DEFAULT '0' NOT NULL, + actionid bigint DEFAULT '0' NOT NULL, + conditiontype integer DEFAULT '0' NOT NULL, + operator integer DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (conditionid) -) ENGINE=InnoDB; +); CREATE INDEX conditions_1 on conditions_tmp (actionid); insert into conditions_tmp select * from conditions; drop table conditions; -alter table conditions_tmp rename conditions; +alter table conditions_tmp rename to conditions; |