Drop table instead so not null constraints do not conflict.
authorBen Thompson <ben@xtuple.com>
Fri, 9 May 2014 14:11:51 +0000 (10:11 -0400)
committerBen Thompson <ben@xtuple.com>
Fri, 9 May 2014 14:11:51 +0000 (10:11 -0400)
enyo-client/database/source/xt/tables/sordtype.sql

index e4af351..5fd5463 100644 (file)
@@ -16,7 +16,7 @@ select
 select dropIfExists('TRIGGER', 'sordtype_did_change', 'xt');
 
 -- Flush the current table. We rebuild it on each run.
-delete from xt.sordtype;
+drop table if exists xt.sordtype;
 
 -- table definition
 select xt.create_table('sordtype', 'xt');