Merge branch '4_7_x' of https://github.com/xtuple/xtuple into i24559_xtlocks
[xtuple] / enyo-client / database / source / delete_system_orms.sql
1 do $$
2  /* Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
3     See www.xtuple.com/CPAL for the full text of the software license. */
4
5   plv8.execute("select xt.js_init();");
6   plv8.execute("alter table xt.orm disable trigger orm_did_change;");
7   plv8.execute("delete from xt.orm where orm_json ~ '\"isSystem\":true';");
8   plv8.execute("alter table xt.orm enable trigger orm_did_change;");
9
10 $$ language plv8;