proc to clone a/t event definitions
authorJason Etheridge <jason@esilibrary.com>
Tue, 3 Feb 2015 17:13:21 +0000 (12:13 -0500)
committerJason Etheridge <jason@esilibrary.com>
Tue, 3 Feb 2015 17:13:21 +0000 (12:13 -0500)
commit2db3025cacf2d60d016ae0759ff2ac39f36a3d92
tree3dd20dccaa45797f9caf2d8e9b82719f931dbce6
parente36038ee87bb072712e2d36321d3389e1ca52118
proc to clone a/t event definitions

ubuntudeskfx=# SELECT * FROM migration_tools.duplicate_template(5,'{3,4}');
INFO:  created atevdef with id = 112
INFO:  created atevdef with id = 113
INFO:  -- UPDATE action_trigger.event_definition SET active = CASE WHEN id = 5 THEN FALSE ELSE TRUE END WHERE id in (5,112,113);
 duplicate_template
--------------------

(1 row)

ubuntudeskfx=# UPDATE action_trigger.event_definition SET active = CASE WHEN id = 5 THEN FALSE ELSE TRUE END WHERE id in (5,112,113);
UPDATE 3

Signed-off-by: Jason Etheridge <jason@esilibrary.com>
sql/base/base.sql