1 files changed, 0 insertions, 43 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/items.sql b/upgrades/dbpatches/1.3/postgresql/patch/items.sql
deleted file mode 100644
index f34aac7d..00000000
--- a/upgrades/dbpatches/1.3/postgresql/patch/items.sql
+++ /dev/null
@@ -1,43 +0,0 @@
-CREATE TABLE items_tmp (
-	itemid		bigint DEFAULT '0'	NOT NULL,
-	type		integer		DEFAULT '0'	NOT NULL,
-	snmp_community	varchar(64)		DEFAULT ''	NOT NULL,
-	snmp_oid	varchar(255)		DEFAULT ''	NOT NULL,
-	snmp_port	integer		DEFAULT '161'	NOT NULL,
-	hostid		bigint DEFAULT '0'	NOT NULL,
-	description	varchar(255)		DEFAULT ''	NOT NULL,
-	key_		varchar(255)		DEFAULT ''	NOT NULL,
-	delay		integer		DEFAULT '0'	NOT NULL,
-	history		integer		DEFAULT '90'	NOT NULL,
-	trends		integer		DEFAULT '365'	NOT NULL,
-	nextcheck	integer		DEFAULT '0'	NOT NULL,
-	lastvalue	varchar(255)			NULL,
-	lastclock	integer			NULL,
-	prevvalue	varchar(255)			NULL,
-	status		integer		DEFAULT '0'	NOT NULL,
-	value_type	integer		DEFAULT '0'	NOT NULL,
-	trapper_hosts	varchar(255)		DEFAULT ''	NOT NULL,
-	units		varchar(10)		DEFAULT ''	NOT NULL,
-	multiplier	integer		DEFAULT '0'	NOT NULL,
-	delta		integer		DEFAULT '0'	NOT NULL,
-	prevorgvalue	varchar(255)			NULL,
-	snmpv3_securityname		varchar(64)		DEFAULT ''	NOT NULL,
-	snmpv3_securitylevel		integer		DEFAULT '0'	NOT NULL,
-	snmpv3_authpassphrase		varchar(64)		DEFAULT ''	NOT NULL,
-	snmpv3_privpassphrase		varchar(64)		DEFAULT ''	NOT NULL,
-	formula		varchar(255)		DEFAULT '0'	NOT NULL,
-	error		varchar(128)		DEFAULT ''	NOT NULL,
-	lastlogsize	integer		DEFAULT '0'	NOT NULL,
-	logtimefmt	varchar(64)		DEFAULT ''	NOT NULL,
-	templateid	bigint DEFAULT '0'	NOT NULL,
-	valuemapid	bigint DEFAULT '0'	NOT NULL,
-	delay_flex	varchar(255)		DEFAULT ''	NOT NULL,
-	PRIMARY KEY (itemid)
-);
-CREATE UNIQUE INDEX items_1 on items_tmp (hostid,key_);
-CREATE INDEX items_2 on items_tmp (nextcheck);
-CREATE INDEX items_3 on items_tmp (status);
-
-insert into items_tmp select *,'' from items;
-drop table items;
-alter table items_tmp rename to items;