longfei
/
72crm-11.0-PHP
Прати 1
Волим 0
Креирај огранак 0
Код Дискусије 0 Захтеви за спајање 0 Издања 0 Вики Activity
58 Комити
1 Грана
Грана: master
Гране Ознаке
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
72crm-11.0-PHP/update_sql_20210626.sql

update_sql_20210626.sql 29KB
Пермалинк Историја Датотека

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240 
  1. INSERT INTO`5kcrm_admin_rule` (`types`, `title`, `name`, `level`, `pid`, `status`) VALUES ('2', '编辑团队成员', 'teamSave', '3', '50', '1');

  2. INSERT INTO`5kcrm_admin_rule` (`types`, `title`, `name`, `level`, `pid`, `status`) VALUES ('2', '编辑团队成员', 'teamSave', '3', '22', '1');

  3. ALTER TABLE `5kcrm_crm_receivables` ADD COLUMN `ro_user_id` varchar(500) NOT NULL DEFAULT '' COMMENT '只读权限';

  4. ALTER TABLE `5kcrm_crm_receivables` ADD COLUMN `rw_user_id` varchar(500) NOT NULL DEFAULT '' COMMENT '读写权限';

  5. ALTER TABLE `5kcrm_admin_system_log` MODIFY COLUMN `target_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '被操作对象的名称' AFTER `log_id`;

  6. ALTER TABLE `5kcrm_admin_operation_log` MODIFY COLUMN `target_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '被操作对象' AFTER `log_id`;

  7. ALTER TABLE `5kcrm_admin_operation_log` MODIFY COLUMN `action_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '操作';

  8. ALTER TABLE `5kcrm_admin_action_log` MODIFY COLUMN `target_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '被操作对象';

  9. ALTER TABLE `5kcrm_admin_field` ADD COLUMN `style_percent` tinyint(4) unsigned NOT NULL DEFAULT 100 COMMENT '字段宽度百分比：25、50、75、100';

  10. ALTER TABLE `5kcrm_admin_field` ADD COLUMN `form_position` varchar(20) NULL COMMENT '字段位置 0:2，第一个数字表示列，第二个数字表示行';

  11. ALTER TABLE `5kcrm_admin_field` ADD COLUMN `precisions` tinyint(4) unsigned NULL COMMENT '1、小数的精度，允许的最大小数位数，默认为null，表示不启用小数。2、也包含其他数据选项，如：明细表格的显示方式';

  12. ALTER TABLE `5kcrm_admin_field` ADD COLUMN `max_num_restrict` varchar(30) NULL COMMENT '数字类字段的最大数，所填写的数字不能大于这个字段的值，默认为null';

  13. ALTER TABLE `5kcrm_admin_field` ADD COLUMN `min_num_restrict` varchar(30) NULL COMMENT '数字类字段的最小数，所填写的数字不能小于这个字段的值，默认为null';

  14. ALTER TABLE `5kcrm_admin_field` ADD COLUMN `remark` varchar(64) NULL COMMENT '字段说明';

  15. ALTER TABLE `5kcrm_admin_field` ADD COLUMN `options` longtext NULL COMMENT '如果类型是选项，此处不能为空，多个选项以，隔开，此处的数据是用于控制其他字段是否显示的逻辑表单';

  16. ALTER TABLE `5kcrm_admin_field` ADD COLUMN `formAssistId` int(10) null COMMENT '逻辑表单相关，由前端生成';

  17. ALTER TABLE `5kcrm_oa_examine_data` MODIFY COLUMN `value` longtext DEFAULT NULL COMMENT '字段内容';

  18. CREATE TABLE `5kcrm_admin_field_extend` (

  19.     `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,

  20.     `types` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模块：crm_leads、crm_customer、crm_contacts、crm_business、crm_contract、crm_receivables、crm_product、crm_receivables_plan、crm_visit、oa_examine',

  21.     `field` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名称',

  22.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详细内容',

  23.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '生成时间',

  24.     PRIMARY KEY (`id`) USING BTREE,

  25.     UNIQUE INDEX `field_types`(`field`, `types`) USING BTREE,

  26.     UNIQUE INDEX `field`(`field`) USING BTREE

  27. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '自定义字段扩展表' ROW_FORMAT = Dynamic;

  28. CREATE TABLE `5kcrm_crm_leads_data`  (

  29.     `leads_id` int(10) UNSIGNED NOT NULL COMMENT '线索表ID',

  30.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  31.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  32.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  33. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '线索表扩展字段数据' ROW_FORMAT = Dynamic;

  34. CREATE TABLE `5kcrm_crm_customer_data`  (

  35.     `customer_id` int(10) UNSIGNED NOT NULL COMMENT '客户表ID',

  36.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  37.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  38.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  39. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户表扩展字段数据' ROW_FORMAT = Dynamic;

  40. CREATE TABLE `5kcrm_crm_contacts_data`  (

  41.     `contacts_id` int(10) UNSIGNED NOT NULL COMMENT '联系人表ID',

  42.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  43.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  44.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  45. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '联系人表扩展字段数据' ROW_FORMAT = Dynamic;

  46. CREATE TABLE `5kcrm_crm_business_data`  (

  47.     `business_id` int(10) UNSIGNED NOT NULL COMMENT '商机表ID',

  48.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  49.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  50.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  51. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商机表扩展字段数据' ROW_FORMAT = Dynamic;

  52. CREATE TABLE `5kcrm_crm_contract_data`  (

  53.     `contract_id` int(10) UNSIGNED NOT NULL COMMENT '合同表ID',

  54.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  55.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  56.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  57. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '合同表扩展字段数据' ROW_FORMAT = Dynamic;

  58. CREATE TABLE `5kcrm_crm_receivables_data`  (

  59.     `receivables_id` int(10) UNSIGNED NOT NULL COMMENT '回款表ID',

  60.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  61.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  62.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  63. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '回款表扩展字段数据' ROW_FORMAT = Dynamic;

  64. CREATE TABLE `5kcrm_crm_visit_data`  (

  65.     `visit_id` int(10) UNSIGNED NOT NULL COMMENT '回访表ID',

  66.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  67.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  68.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  69. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '回访表扩展字段数据' ROW_FORMAT = Dynamic;

  70. CREATE TABLE `5kcrm_crm_product_data`  (

  71.     `product_id` int(10) UNSIGNED NOT NULL COMMENT '产品表ID',

  72.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  73.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  74.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  75. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品表扩展字段数据' ROW_FORMAT = Dynamic;

  76. CREATE TABLE `5kcrm_crm_invoice_data`  (

  77.     `invoice_id` int(10) UNSIGNED NOT NULL COMMENT '发票表ID',

  78.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  79.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  80.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  81. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '发票表扩展字段数据' ROW_FORMAT = Dynamic;

  82. CREATE TABLE `5kcrm_crm_receivables_plan_data`  (

  83.     `plan_id` int(10) UNSIGNED NOT NULL COMMENT '发票表ID',

  84.     `field` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名',

  85.     `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '字段内容',

  86.     `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间'

  87. ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '回款计划表扩展字段数据' ROW_FORMAT = Dynamic;

  88. CREATE TABLE `5kcrm_oa_log_favour`  (

  89.     `favour_id` int(11) NOT NULL AUTO_INCREMENT,

  90.     `log_id` int(11) NOT NULL,

  91.     `user_id` int(11) NULL DEFAULT NULL COMMENT '点赞人id',

  92.     `status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态 0禁用 1显示',

  93.     PRIMARY KEY (`favour_id`) USING BTREE

  94. ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '点赞记录表' ROW_FORMAT = Dynamic;

  95. INSERT INTO `5kcrm_admin_scene` (`types`, `name`, `user_id`, `order_id`, `data`, `is_hide`, `type`, `bydata`, `create_time`, `update_time`) VALUES ('crm_product', '上架的产品', 0, 0, NULL, 0, 1, 'put_on_shelves', 1623240292, 1623240292);

  96. INSERT INTO `5kcrm_admin_scene` (`types`, `name`, `user_id`, `order_id`, `data`, `is_hide`, `type`, `bydata`, `create_time`, `update_time`) VALUES ('crm_product', '下架的产品', 0, 0, NULL, 0, 1, 'pull_off_shelves', 1623240292, 1623240292);

  97. DELETE FROM `5kcrm_admin_scene` WHERE `name` like '我参与%';

  98. ALTER TABLE `5kcrm_crm_contract` MODIFY COLUMN `expire_remind` tinyint(1) NOT NULL DEFAULT 1  COMMENT '是否提醒合同到期：1提醒；0提醒';

  99. ALTER TABLE `5kcrm_crm_business` MODIFY COLUMN `expire_remind` tinyint(1) NOT NULL DEFAULT 1  COMMENT '是否提醒：1提醒；0提醒';

  100. DELETE FROM `5kcrm_admin_field` WHERE `types` = 'crm_receivables_plan' AND `field` = 'file';

  101. ALTER TABLE `5kcrm_crm_customer_pool_field_setting` ADD COLUMN `is_null` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否必填：1必填，0不是必填';

  102. ALTER TABLE `5kcrm_crm_customer_pool_field_setting` ADD COLUMN `is_unique` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否唯一：1唯一，0不唯一';

  103. UPDATE `5kcrm_crm_customer_pool_field_setting` SET `is_null` = 1, `is_unique` = 1 WHERE `field_name` = 'name' AND `name` = '客户名称';

  104. CREATE TABLE `5kcrm_app_navigation`  (

  105.     `p_id` int(11) NOT NULL AUTO_INCREMENT,

  106.     `data` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据集',

  107.     `create_user_id` int(11) NOT NULL COMMENT '创建人',

  108.     PRIMARY KEY (`p_id`) USING BTREE

  109. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '手机端导航数据表' ROW_FORMAT = Dynamic;

  110. INSERT INTO `5kcrm_admin_field`(`types`, `types_id`, `field`, `name`, `form_type`, `default_value`, `max_length`, `is_unique`, `is_null`, `input_tips`, `setting`, `order_id`, `operating`, `create_time`, `update_time`, `type`, `relevant`, `is_hidden`, `style_percent`, `form_position`, `precisions`, `max_num_restrict`, `min_num_restrict`, `remark`, `options`, `formAssistId`)

  111. VALUES ('crm_invoice', 0, 'invoice_apple_number', '发票申请编号', 'text', '', 0, 1, 1, '', '', 0, 1, 1553788800, 1553788800, 0, NULL, 0, 100, '0,0', null, null, null, null, null, 1001);

  112. INSERT INTO `5kcrm_admin_field`( `types`, `types_id`, `field`, `name`, `form_type`, `default_value`, `max_length`, `is_unique`, `is_null`, `input_tips`, `setting`, `order_id`, `operating`, `create_time`, `update_time`, `type`, `relevant`, `is_hidden`, `style_percent`, `form_position`, `precisions`, `max_num_restrict`, `min_num_restrict`, `remark`, `options`, `formAssistId`)

  113. VALUES ( 'crm_invoice', 0, 'customer_id', '客户名称', 'customer', '', 0, 0, 1, '', '', 0, 3, 1553788800, 1553788800, 0, NULL, 0, 100, '1,0', null, null, null, null, null, 1002);

  114. INSERT INTO `5kcrm_admin_field`(`types`, `types_id`, `field`, `name`, `form_type`, `default_value`, `max_length`, `is_unique`, `is_null`, `input_tips`, `setting`, `order_id`, `operating`, `create_time`, `update_time`, `type`, `relevant`, `is_hidden`, `style_percent`, `form_position`, `precisions`, `max_num_restrict`, `min_num_restrict`, `remark`, `options`, `formAssistId`)

  115. VALUES ( 'crm_invoice', 0, 'contract_id', '合同编号', 'contract', '', 0, 0, 1, '', '', 0, 1, 1553788800, 1553788800, 0, NULL, 0, 100, '2,0', null, null, null, null, null, 1003);

  116. INSERT INTO `5kcrm_admin_field`( `types`, `types_id`, `field`, `name`, `form_type`, `default_value`, `max_length`, `is_unique`, `is_null`, `input_tips`, `setting`, `order_id`, `operating`, `create_time`, `update_time`, `type`, `relevant`, `is_hidden`, `style_percent`, `form_position`, `precisions`, `max_num_restrict`, `min_num_restrict`, `remark`, `options`, `formAssistId`)

  117. VALUES ( 'crm_invoice', 0, 'contract_money', '合同金额', 'floatnumber', '', 0, 0, 1, '元', '', 0, 1, 1553788800, 1553788800, 0, NULL, 0, 100, '3,0', null, null, null, null, null, 1004);

  118. INSERT INTO `5kcrm_admin_field`( `types`, `types_id`, `field`, `name`, `form_type`, `default_value`, `max_length`, `is_unique`, `is_null`, `input_tips`, `setting`, `order_id`, `operating`, `create_time`, `update_time`, `type`, `relevant`, `is_hidden`, `style_percent`, `form_position`, `precisions`, `max_num_restrict`, `min_num_restrict`, `remark`, `options`, `formAssistId`)

  119. VALUES ( 'crm_invoice', 0, 'invoice_date', '开票日期', 'date', '', 0, 0, 0, '', '', 0, 1, 1553788800, 1553788800, 0, NULL, 0, 100, '4,0', null, null, null, null, null, 1005);

  120. INSERT INTO `5kcrm_admin_field`( `types`, `types_id`, `field`, `name`, `form_type`, `default_value`, `max_length`, `is_unique`, `is_null`, `input_tips`, `setting`, `order_id`, `operating`, `create_time`, `update_time`, `type`, `relevant`, `is_hidden`, `style_percent`, `form_position`, `precisions`, `max_num_restrict`, `min_num_restrict`, `remark`, `options`, `formAssistId`)

  121. VALUES ( 'crm_invoice', 0, 'invoice_money', '开票金额', 'floatnumber', '', 0, 0, 1, '元', '', 0, 1, 1553788800, 1553788800, 0, NULL, 0, 100, '5,0', null, null, null, null, null, 1006);

  122. INSERT INTO `5kcrm_admin_field`(`types`, `types_id`, `field`, `name`, `form_type`, `default_value`, `max_length`, `is_unique`, `is_null`, `input_tips`, `setting`, `order_id`, `operating`, `create_time`, `update_time`, `type`, `relevant`, `is_hidden`, `style_percent`, `form_position`, `precisions`, `max_num_restrict`, `min_num_restrict`, `remark`, `options`, `formAssistId`)

  123. VALUES ( 'crm_invoice', 0, 'invoice_type', '开票类型', 'select', '', 0, 0, 1, '', '增值税专用发票\n增值税普通发票\n国税通用机打发票\n地税通用机打发票\n收据', 0, 3, 1553788800, 1553788800, 0, NULL, 0, 100, '6,0', null, null, null, null, null, 1007);

  124. INSERT INTO `5kcrm_admin_field`( `types`, `types_id`, `field`, `name`, `form_type`, `default_value`, `max_length`, `is_unique`, `is_null`, `input_tips`, `setting`, `order_id`, `operating`, `create_time`, `update_time`, `type`, `relevant`, `is_hidden`, `style_percent`, `form_position`, `precisions`, `max_num_restrict`, `min_num_restrict`, `remark`, `options`, `formAssistId`)

  125. VALUES ('crm_invoice', 0, 'remark', '备注', 'textarea', '', 0, 0, 0, '', NULL, 1, 1, 1620874670, 1620874670, 0, NULL, 0, 100, '7,0', null, null, null, null, null, 1008);

  126. INSERT INTO `5kcrm_admin_scene`( `types`, `name`, `user_id`, `order_id`, `data`, `is_hide`, `type`, `bydata`, `create_time`, `update_time`) VALUES ( 'crm_business', '进行中的商机', 0, 0, NULL, 0, 1, 'go_business', 1546272000, 1546272000);

  127. INSERT INTO `5kcrm_admin_scene` ( `types`, `name`, `user_id`, `order_id`, `data`, `is_hide`, `type`, `bydata`, `create_time`, `update_time` )VALUES( 'crm_invoice', '全部发票', 0, 0, '', 0, 1, 'all', 1546272000, 1546272000 );

  128. INSERT INTO `5kcrm_admin_scene` ( `types`, `name`, `user_id`, `order_id`, `data`, `is_hide`, `type`, `bydata`, `create_time`, `update_time` )VALUES( 'crm_invoice', '我负责的发票', 0, 0, '', 0, 1, 'me', 1546272000, 1546272000 );

  129. INSERT INTO `5kcrm_admin_scene` ( `types`, `name`, `user_id`, `order_id`, `data`, `is_hide`, `type`, `bydata`, `create_time`, `update_time` )VALUES( 'crm_invoice', '下属负责的发票', 0, 0, '', 0, 1, 'sub', 1546272000, 1546272000 );

  130. CREATE TABLE `5kcrm_crm_team`  (

  131.     `team_id` int(11) NOT NULL AUTO_INCREMENT,

  132.     `types` tinyint(4) NOT NULL COMMENT '模块 1 客户 2联系人 3商机 4合同 5回款 ',

  133.     `target_id` int(11) NOT NULL COMMENT '团队成员所属对象id',

  134.     `target_time` int(11) NULL DEFAULT NULL COMMENT '截止到期时间',

  135.     `team_user_id` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '团队用户id',

  136.     `auth` tinyint(2) NOT NULL COMMENT '1 只读权限 2读写权限',

  137.     PRIMARY KEY (`team_id`) USING BTREE

  138. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '团队成员截止时间' ROW_FORMAT = Dynamic;

  139. INSERT INTO `5kcrm_admin_rule` (`types`, `title`, `name`, `level`, `pid`, `status`) VALUES ('0', '角色权限查看', 'ruleList', '3', '112', '1');

  140. CREATE TABLE `5kcrm_admin_group_auth` (

  141.     `id` int(11) NOT NULL AUTO_INCREMENT,

  142.     `group_id` int(11) NOT NULL COMMENT '角色id',

  143.     `auth_group_id` varchar(100) NOT NULL COMMENT '角色授权的 角色id',

  144.     PRIMARY KEY (`id`) USING BTREE

  145. ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色权限查看配置表';

  146. ALTER TABLE `5kcrm_admin_field` MODIFY COLUMN `operating` int(10) NOT NULL DEFAULT '0' COMMENT '0改删，1改，2删，3无';

  147. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_leads';

  148. UPDATE `5kcrm_admin_field` SET `operating` = '189', `formAssistId` = 1001 WHERE `types` = 'crm_leads' AND `field` = 'name';

  149. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1002 WHERE `types` = 'crm_leads' AND `field` = 'source';

  150. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1003 WHERE `types` = 'crm_leads' AND `field` = 'industry';

  151. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1004 WHERE `types` = 'crm_leads' AND `field` = 'level';

  152. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1005 WHERE `types` = 'crm_leads' AND `field` = 'telephone';

  153. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1006 WHERE `types` = 'crm_leads' AND `field` = 'mobile';

  154. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1007 WHERE `types` = 'crm_leads' AND `field` = 'email';

  155. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1008 WHERE `types` = 'crm_leads' AND `field` = 'detail_address';

  156. UPDATE `5kcrm_admin_field` SET `operating` = '63', `formAssistId` = 1009 WHERE `types` = 'crm_leads' AND `field` = 'next_time';

  157. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1010 WHERE `types` = 'crm_leads' AND `field` = 'remark';

  158. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_customer';

  159. UPDATE `5kcrm_admin_field` SET `operating` = '189', `formAssistId` = 1001 WHERE `types` = 'crm_customer' AND `field` = 'name';

  160. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1002 WHERE `types` = 'crm_customer' AND `field` = 'industry';

  161. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1003 WHERE `types` = 'crm_customer' AND `field` = 'level';

  162. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1004 WHERE `types` = 'crm_customer' AND `field` = 'source';

  163. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1005 WHERE `types` = 'crm_customer' AND `field` = 'telephone';

  164. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1006 WHERE `types` = 'crm_customer' AND `field` = 'mobile';

  165. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1007 WHERE `types` = 'crm_customer' AND `field` = 'email';

  166. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1008 WHERE `types` = 'crm_customer' AND `field` = 'website';

  167. UPDATE `5kcrm_admin_field` SET `operating` = '63', `formAssistId` = 1009 WHERE `types` = 'crm_customer' AND `field` = 'next_time';

  168. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1010 WHERE `types` = 'crm_customer' AND `field` = 'remark';

  169. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1011 WHERE `types` = 'crm_customer' AND `field` = 'deal_status';

  170. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_contacts';

  171. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1001 WHERE `types` = 'crm_contacts' AND `field` = 'name';

  172. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1002 WHERE `types` = 'crm_contacts' AND `field` = 'customer_id';

  173. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1003 WHERE `types` = 'crm_contacts' AND `field` = 'mobile';

  174. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1004 WHERE `types` = 'crm_contacts' AND `field` = 'telephone';

  175. UPDATE `5kcrm_admin_field` SET `operating` = '190', `formAssistId` = 1005 WHERE `types` = 'crm_contacts' AND `field` = 'decision';

  176. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1006 WHERE `types` = 'crm_contacts' AND `field` = 'post';

  177. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1007 WHERE `types` = 'crm_contacts' AND `field` = 'email';

  178. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1008 WHERE `types` = 'crm_contacts' AND `field` = 'detail_address';

  179. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1009 WHERE `types` = 'crm_contacts' AND `field` = 'sex';

  180. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1010 WHERE `types` = 'crm_contacts' AND `field` = 'next_time';

  181. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1011 WHERE `types` = 'crm_contacts' AND `field` = 'remark';

  182. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_business';

  183. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1001 WHERE `types` = 'crm_business' AND `field` = 'name';

  184. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1002 WHERE `types` = 'crm_business' AND `field` = 'customer_id';

  185. UPDATE `5kcrm_admin_field` SET `operating` = '19', `formAssistId` = 1003 WHERE `types` = 'crm_business' AND `field` = 'type_id';

  186. UPDATE `5kcrm_admin_field` SET `operating` = '19', `formAssistId` = 1004 WHERE `types` = 'crm_business' AND `field` = 'status_id';

  187. UPDATE `5kcrm_admin_field` SET `operating` = '189', `formAssistId` = 1005 WHERE `types` = 'crm_business' AND `field` = 'money';

  188. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1006 WHERE `types` = 'crm_business' AND `field` = 'deal_date';

  189. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1007 WHERE `types` = 'crm_business' AND `field` = 'remark';

  190. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_contract';

  191. UPDATE `5kcrm_admin_field` SET `operating` = '177', `formAssistId` = 1001 WHERE `types` = 'crm_contract' AND `field` = 'num';

  192. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1002 WHERE `types` = 'crm_contract' AND `field` = 'name';

  193. UPDATE `5kcrm_admin_field` SET `operating` = '149', `formAssistId` = 1003 WHERE `types` = 'crm_contract' AND `field` = 'customer_id';

  194. UPDATE `5kcrm_admin_field` SET `operating` = '159', `formAssistId` = 1004 WHERE `types` = 'crm_contract' AND `field` = 'business_id';

  195. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1006 WHERE `types` = 'crm_contract' AND `field` = 'order_date';

  196. UPDATE `5kcrm_admin_field` SET `operating` = '189', `formAssistId` = 1006 WHERE `types` = 'crm_contract' AND `field` = 'money';

  197. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1007 WHERE `types` = 'crm_contract' AND `field` = 'start_time';

  198. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1008 WHERE `types` = 'crm_contract' AND `field` = 'end_time';

  199. UPDATE `5kcrm_admin_field` SET `operating` = '159', `formAssistId` = 1009 WHERE `types` = 'crm_contract' AND `field` = 'contacts_id';

  200. UPDATE `5kcrm_admin_field` SET `operating` = '159', `formAssistId` = 1010 WHERE `types` = 'crm_contract' AND `field` = 'order_user_id';

  201. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1011 WHERE `types` = 'crm_contract' AND `field` = 'remark';

  202. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_receivables';

  203. UPDATE `5kcrm_admin_field` SET `operating` = '177', `formAssistId` = 1001 WHERE `types` = 'crm_receivables' AND `field` = 'number';

  204. UPDATE `5kcrm_admin_field` SET `operating` = '153', `formAssistId` = 1002 WHERE `types` = 'crm_receivables' AND `field` = 'customer_id';

  205. UPDATE `5kcrm_admin_field` SET `operating` = '159', `formAssistId` = 1003 WHERE `types` = 'crm_receivables' AND `field` = 'contract_id';

  206. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1004 WHERE `types` = 'crm_receivables' AND `field` = 'return_time';

  207. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1005 WHERE `types` = 'crm_receivables' AND `field` = 'return_type';

  208. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1006 WHERE `types` = 'crm_receivables' AND `field` = 'money';

  209. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1007 WHERE `types` = 'crm_receivables' AND `field` = 'plan_id';

  210. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1008 WHERE `types` = 'crm_receivables' AND `field` = 'remark';

  211. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_receivables_plan';

  212. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1001 WHERE `types` = 'crm_receivables_plan' AND `field` = 'customer_id';

  213. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1002 WHERE `types` = 'crm_receivables_plan' AND `field` = 'contract_id';

  214. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1003 WHERE `types` = 'crm_receivables_plan' AND `field` = 'money';

  215. UPDATE `5kcrm_admin_field` SET `operating` = '183', `formAssistId` = 1004 WHERE `types` = 'crm_receivables_plan' AND `field` = 'return_date';

  216. UPDATE `5kcrm_admin_field` SET `operating` = '0', `formAssistId` = 1005 WHERE `types` = 'crm_receivables_plan' AND `field` = 'return_type';

  217. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1006 WHERE `types` = 'crm_receivables_plan' AND `field` = 'remind';

  218. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1007 WHERE `types` = 'crm_receivables_plan' AND `field` = 'remark';

  219. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_visit';

  220. UPDATE `5kcrm_admin_field` SET `operating` = '177', `formAssistId` = 1001 WHERE `types` = 'crm_visit' AND `field` = 'number';

  221. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1002 WHERE `types` = 'crm_visit' AND `field` = 'visit_time';

  222. UPDATE `5kcrm_admin_field` SET `operating` = '149', `formAssistId` = 1003 WHERE `types` = 'crm_visit' AND `field` = 'owner_user_id';

  223. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1004 WHERE `types` = 'crm_visit' AND `field` = 'shape';

  224. UPDATE `5kcrm_admin_field` SET `operating` = '149', `formAssistId` = 1005 WHERE `types` = 'crm_visit' AND `field` = 'customer_id';

  225. UPDATE `5kcrm_admin_field` SET `operating` = '159', `formAssistId` = 1006 WHERE `types` = 'crm_visit' AND `field` = 'contacts_id';

  226. UPDATE `5kcrm_admin_field` SET `operating` = '159', `formAssistId` = 1007 WHERE `types` = 'crm_visit' AND `field` = 'contract_id';

  227. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1008 WHERE `types` = 'crm_visit' AND `field` = 'satisfaction';

  228. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1009 WHERE `types` = 'crm_visit' AND `field` = 'feedback';

  229. UPDATE `5kcrm_admin_field` SET `operating` = '255' WHERE `types` = 'crm_product';

  230. UPDATE `5kcrm_admin_field` SET `operating` = '177', `formAssistId` = 1001 WHERE `types` = 'crm_product' AND `field` = 'name';

  231. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1002 WHERE `types` = 'crm_product' AND `field` = 'category_id';

  232. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1003 WHERE `types` = 'crm_product' AND `field` = 'num';

  233. UPDATE `5kcrm_admin_field` SET `operating` = '144', `formAssistId` = 1004 WHERE `types` = 'crm_product' AND `field` = 'status';

  234. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1005 WHERE `types` = 'crm_product' AND `field` = 'unit';

  235. UPDATE `5kcrm_admin_field` SET `operating` = '181', `formAssistId` = 1006 WHERE `types` = 'crm_product' AND `field` = 'price';

  236. UPDATE `5kcrm_admin_field` SET `operating` = '191', `formAssistId` = 1007 WHERE `types` = 'crm_product' AND `field` = 'description';

  237. UPDATE `5kcrm_admin_field` SET `operating` = '0' WHERE `types` = 'oa_examine';

  238. DELETE FROM `5kcrm_admin_field` WHERE `field` = 'deal_status' AND `types` = 'crm_customer';

  239. ALTER TABLE `5kcrm_crm_invoice` ADD COLUMN `contract_money` decimal(18,2) DEFAULT '0.00' COMMENT '合同金额';

  240. INSERT INTO `5kcrm_admin_group` (`pid`, `title`, `rules`, `remark`, `status`, `type`, `types`, `system`) VALUES (9, '管理项目', ',141,142,143,', '', 1, 0, 0, 0);