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. */
9 sql = "select schemaname, viewname " +
11 "where schemaname in ('xm','sys', 'xt');";
13 result = plv8.execute(sql);
14 for (i = 0; i < result.length; i++) {
15 viewname = result[i].viewname;
16 schemaname = result[i].schemaname;
17 plv8.execute('drop view if exists ' + schemaname + '.' + viewname + ' cascade;');
20 plv8.execute("alter table xt.orm disable trigger orm_did_change;");
21 plv8.execute("delete from xt.orm where orm_json ~ '\"isSystem\":true';");
22 plv8.execute("alter table xt.orm enable trigger orm_did_change;");