Changes related to make dist.

git-svn-id: svn://svn.zabbix.com/trunk@3938 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 0 insertions, 26 deletions

diff --git a/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql b/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql
deleted file mode 100644
index 413e0ed0..00000000
--- a/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql
+++ /dev/null
@@ -1,26 +0,0 @@
-CREATE TABLE alerts_tmp (
-	alertid		bigint	DEFAULT '0'	NOT NULL,
-	actionid	bigint	DEFAULT '0'	NOT NULL,
-	triggerid	bigint	DEFAULT '0'	NOT NULL,
-	userid		bigint	DEFAULT '0'	NOT NULL,
-	clock		integer	DEFAULT '0'	NOT NULL,
-	mediatypeid	bigint	DEFAULT '0'	NOT NULL,
-	sendto		varchar(100)		DEFAULT ''	NOT NULL,
-	subject		varchar(255)		DEFAULT ''	NOT NULL,
-	message		text	DEFAULT ''	NOT NULL,
-	status		integer	DEFAULT '0'	NOT NULL,
-	retries		integer	DEFAULT '0'	NOT NULL,
-	error		varchar(128)		DEFAULT ''	NOT NULL,
-	nextcheck	integer	DEFAULT '0'	NOT NULL,
-	PRIMARY KEY (alertid)
-);
-CREATE INDEX alerts_1 on alerts_tmp (actionid);
-CREATE INDEX alerts_2 on alerts_tmp (clock);
-CREATE INDEX alerts_3 on alerts_tmp (triggerid);
-CREATE INDEX alerts_4 on alerts_tmp (status,retries);
-CREATE INDEX alerts_5 on alerts_tmp (mediatypeid);
-CREATE INDEX alerts_6 on alerts_tmp (userid);
-
-insert into alerts_tmp select alertid,actionid,triggerid,userid,clock,mediatypeid,sendto,subject,message,status,retries,error,nextcheck from alerts;
-drop table alerts;
-alter table alerts_tmp rename to alerts;