diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-04-12 12:45:57 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-04-12 12:45:57 +0000 |
| commit | c1bd0578e4007addfb567e10b9cfd2ad1b8a927a (patch) | |
| tree | 8c798de9b4dbdfa69c88838d0e0f6ff85ac7b51f /upgrades/dbpatches | |
| parent | 3792fb6ed57211243b5cc0f8ba461867b31d08cb (diff) | |
| download | zabbix-c1bd0578e4007addfb567e10b9cfd2ad1b8a927a.tar.gz zabbix-c1bd0578e4007addfb567e10b9cfd2ad1b8a927a.tar.xz zabbix-c1bd0578e4007addfb567e10b9cfd2ad1b8a927a.zip | |
Removed table autoreg.
git-svn-id: svn://svn.zabbix.com/trunk@3997 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches')
| -rw-r--r-- | upgrades/dbpatches/1.4/mysql/patch/autoreg.sql | 10 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql | 10 |
2 files changed, 0 insertions, 20 deletions
diff --git a/upgrades/dbpatches/1.4/mysql/patch/autoreg.sql b/upgrades/dbpatches/1.4/mysql/patch/autoreg.sql index 9a9861d2..115c591c 100644 --- a/upgrades/dbpatches/1.4/mysql/patch/autoreg.sql +++ b/upgrades/dbpatches/1.4/mysql/patch/autoreg.sql @@ -1,11 +1 @@ -CREATE TABLE autoreg_tmp ( - id bigint unsigned DEFAULT '0' NOT NULL, - priority integer DEFAULT '0' NOT NULL, - pattern varchar(255) DEFAULT '' NOT NULL, - hostid bigint unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (id) -) ENGINE=InnoDB; - -insert into autoreg_tmp select * from autoreg; drop table autoreg; -alter table autoreg_tmp rename autoreg; diff --git a/upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql b/upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql index 5ef888dd..115c591c 100644 --- a/upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql +++ b/upgrades/dbpatches/1.4/postgresql/patch/autoreg.sql @@ -1,11 +1 @@ -CREATE TABLE autoreg_tmp ( - id bigint DEFAULT '0' NOT NULL, - priority integer DEFAULT '0' NOT NULL, - pattern varchar(255) DEFAULT '' NOT NULL, - hostid bigint DEFAULT '0' NOT NULL, - PRIMARY KEY (id) -); - -insert into autoreg_tmp select * from autoreg; drop table autoreg; -alter table autoreg_tmp rename to autoreg; |