diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/alerts.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/alerts.sql | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql b/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql index 19230ecb..70cfd8ae 100644 --- a/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql +++ b/upgrades/dbpatches/1.3/postgresql/patch/alerts.sql @@ -1,22 +1,22 @@ 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, + 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 blob DEFAULT '' NOT NULL, - status integer DEFAULT '0' NOT NULL, - retries integer DEFAULT '0' 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, - repeats integer DEFAULT '0' NOT NULL, - maxrepeats integer DEFAULT '0' NOT NULL, - nextcheck integer DEFAULT '0' NOT NULL, - delay integer DEFAULT '0' 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); @@ -26,4 +26,4 @@ CREATE INDEX alerts_6 on alerts_tmp (userid); insert into alerts_tmp select * from alerts; drop table alerts; -alter table alerts_tmp rename alerts; +alter table alerts_tmp rename to alerts; |