diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/alerts.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/alerts.sql | 26 |
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; |