diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/actions.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/actions.sql b/upgrades/dbpatches/1.3/postgresql/patch/actions.sql index 36042556..6a9c5778 100644 --- a/upgrades/dbpatches/1.3/postgresql/patch/actions.sql +++ b/upgrades/dbpatches/1.3/postgresql/patch/actions.sql @@ -8,11 +8,12 @@ CREATE TABLE actions_tmp ( repeatdelay integer DEFAULT '600' NOT NULL, source integer DEFAULT '0' NOT NULL, actiontype integer DEFAULT '0' NOT NULL, + evaltype integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, scripts text DEFAULT '' NOT NULL, PRIMARY KEY (actionid) ); -insert into actions_tmp select * from actions; +insert into actions_tmp select actionid,userid,subject,message,recipient,maxrepeats,repeatdelay,source,actiontype,0,status,scripts from actions; drop table actions; alter table actions_tmp rename to actions; |