X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=enyo-client%2Fdatabase%2Fsource%2Fdelete_system_orms.sql;h=66ea97675d5361b0e6440f522203a4df0ce0a8b3;hb=6f3e82ba3f1b8ec449de7b2d7154eddb55a0be6b;hp=79e2b31e996856a5dbc777cf1b0552e038b8e78e;hpb=8c5b966332a20878a9f3a63711f35da1dfe5a5a3;p=xtuple diff --git a/enyo-client/database/source/delete_system_orms.sql b/enyo-client/database/source/delete_system_orms.sql index 79e2b31e9..66ea97675 100644 --- a/enyo-client/database/source/delete_system_orms.sql +++ b/enyo-client/database/source/delete_system_orms.sql @@ -1,10 +1,10 @@ -DO $$ +do $$ /* Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple. - See www.xm.ple.com/CPAL for the full text of the software license. */ + See www.xtuple.com/CPAL for the full text of the software license. */ - plv8.execute("select xt.js_init()"); - plv8.execute("alter table xt.orm disable trigger orm_did_change"); + plv8.execute("select xt.js_init();"); + plv8.execute("alter table xt.orm disable trigger orm_did_change;"); plv8.execute("delete from xt.orm where orm_json ~ '\"isSystem\":true';"); - plv8.execute("alter table xt.orm enable trigger orm_did_change"); + plv8.execute("alter table xt.orm enable trigger orm_did_change;"); $$ language plv8;