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 23be6e3..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
@@ -1,25 +1,83 @@
--- Customer CRM Account's users.\r
-insert into xt.sharetype (\r
-  sharetype_nsname,\r
-  sharetype_tblname,\r
-  sharetype_col_obj_uuid,\r
-  sharetype_col_username\r
-) values (\r
-  'xt',\r
-  'share_users_cust',\r
-  'obj_uuid',\r
-  'username'\r
-);\r
-\r
--- Ship To CRM Account's users.\r
-insert into xt.sharetype (\r
-  sharetype_nsname,\r
-  sharetype_tblname,\r
-  sharetype_col_obj_uuid,\r
-  sharetype_col_username\r
-) values (\r
-  'xt',\r
-  'share_users_shipto',\r
-  'obj_uuid',\r
-  'username'\r
-);\r
+-- Customer CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_cust';
+insert into xt.sharetype (
+  sharetype_nsname,
+  sharetype_tblname,
+  sharetype_col_obj_uuid,
+  sharetype_col_username
+) values (
+  'xt',
+  'share_users_cust',
+  'obj_uuid',
+  'username'
+);
+
+-- Ship To CRM Account's users.
+delete from xt.sharetype where sharetype_tblname = 'share_users_shipto';
+insert into xt.sharetype (
+  sharetype_nsname,
+  sharetype_tblname,
+  sharetype_col_obj_uuid,
+  sharetype_col_username
+) values (
+  'xt',
+  'share_users_shipto',
+  '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'
+);