diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/alerts.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/alerts.sql | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql b/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql new file mode 100644 index 00000000..19230ecb --- /dev/null +++ b/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql @@ -0,0 +1,29 @@ +CREATE TABLE alerts_tmp ( + alertid bigint unsigned DEFAULT '0' NOT NULL, + actionid bigint unsigned DEFAULT '0' NOT NULL, + triggerid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint unsigned DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + mediatypeid bigint unsigned DEFAULT '0' NOT NULL, + sendto varchar(100) DEFAULT '' NOT NULL, + subject varchar(255) DEFAULT '' NOT NULL, + message blob DEFAULT '' NOT NULL, + status integer DEFAULT '0' NOT NULL, + retries integer DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, + repeats integer DEFAULT '0' NOT NULL, + maxrepeats integer DEFAULT '0' NOT NULL, + nextcheck integer DEFAULT '0' NOT NULL, + delay integer DEFAULT '0' NOT NULL, + PRIMARY KEY (alertid) +) ENGINE=InnoDB ; +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 * from alerts; +drop table alerts; +alter table alerts_tmp rename alerts; |