Include the view when building share_users.

[xtuple] / enyo-client / extensions / source / sales / database / source / xt / tables / sharetype.sql

diff --git a/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql b/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql
index 2b0ac02..3e343bf 100644 (file)
--- a/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql
+++ b/enyo-client/extensions/source/sales/database/source/xt/tables/sharetype.sql
@@ -25,3 +25,59 @@ insert into xt.sharetype (
   'obj_uuid',
   'username'
 );
+
+-- Contact that is on a Ship To CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_cntct';
+insert into xt.sharetype (
+  sharetype_nsname,
+  sharetype_tblname,
+  sharetype_col_obj_uuid,
+  sharetype_col_username
+) values (
+  'xt',
+  'share_users_shipto_cntct',
+  'obj_uuid',
+  'username'
+);
+
+-- Address that is on a Ship To CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_addr';
+insert into xt.sharetype (
+  sharetype_nsname,
+  sharetype_tblname,
+  sharetype_col_obj_uuid,
+  sharetype_col_username
+) values (
+  'xt',
+  'share_users_shipto_addr',
+  'obj_uuid',
+  'username'
+);
+
+-- Customer that a Ship To is on CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_shipto_cust';
+insert into xt.sharetype (
+  sharetype_nsname,
+  sharetype_tblname,
+  sharetype_col_obj_uuid,
+  sharetype_col_username
+) values (
+  'xt',
+  'share_users_shipto_cust',
+  'obj_uuid',
+  'username'
+);
+
+-- Sales Order CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_cohead';
+insert into xt.sharetype (
+  sharetype_nsname,
+  sharetype_tblname,
+  sharetype_col_obj_uuid,
+  sharetype_col_username
+) values (
+  'xt',
+  'share_users_cohead',
+  'obj_uuid',
+  'username'
+);