Add share_user support to shiphead.
authorBen Thompson <ben@xtuple.com>
Fri, 9 May 2014 23:09:45 +0000 (19:09 -0400)
committerBen Thompson <ben@xtuple.com>
Fri, 9 May 2014 23:09:45 +0000 (19:09 -0400)
enyo-client/database/source/manifest.js
enyo-client/database/source/public/tables/shiphead.sql [new file with mode: 0644]

index a986adc..b0f4e0c 100644 (file)
@@ -44,6 +44,7 @@
     "public/tables/prj.sql",
     "public/tables/prjtask.sql",
     "public/tables/quitem.sql",
+    "public/tables/shiphead.sql",
     "public/tables/shiptoinfo.sql",
     "public/tables/todoitem.sql",
     "public/tables/usrpref.sql",
diff --git a/enyo-client/database/source/public/tables/shiphead.sql b/enyo-client/database/source/public/tables/shiphead.sql
new file mode 100644 (file)
index 0000000..4cd93c6
--- /dev/null
@@ -0,0 +1,4 @@
+-- add uuid column here because there are views that need this
+select xt.add_column('shiphead','obj_uuid', 'uuid', 'default xt.uuid_generate_v4()', 'public');
+select xt.add_inheritance('shiphead', 'xt.obj');
+select xt.add_constraint('shiphead', 'shiphead_obj_uuid','unique(obj_uuid)', 'public');