diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/conditions.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/conditions.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/conditions.sql b/upgrades/dbpatches/1.3/postgresql/patch/conditions.sql deleted file mode 100644 index e0f8f834..00000000 --- a/upgrades/dbpatches/1.3/postgresql/patch/conditions.sql +++ /dev/null @@ -1,13 +0,0 @@ -CREATE TABLE conditions_tmp ( - conditionid bigint DEFAULT '0' NOT NULL, - actionid bigint DEFAULT '0' NOT NULL, - conditiontype integer DEFAULT '0' NOT NULL, - operator integer DEFAULT '0' NOT NULL, - value varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (conditionid) -); -CREATE INDEX conditions_1 on conditions_tmp (actionid); - -insert into conditions_tmp select * from conditions; -drop table conditions; -alter table conditions_tmp rename to conditions; |