2016-04-14.sql
38.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
/******************************删除****************************************************************************/
delete from pl_dynamic_field_data where df_id in(
select df_id from pl_dynamic_field
where dt_id in (select dt_id from pl_dynamic_table where ds_id ='ea9fc1d8-05b6-432f-a72f-a760f351bc7d')
);
delete from pl_dynamic_field
where dt_id in (select dt_id from pl_dynamic_table where ds_id ='ea9fc1d8-05b6-432f-a72f-a760f351bc7d');
delete from pl_dynamic_table where ds_id ='ea9fc1d8-05b6-432f-a72f-a760f351bc7d';
delete from pl_dynamic_select where ds_id ='ea9fc1d8-05b6-432f-a72f-a760f351bc7d';
/*************************************查询****************************************************/
INSERT INTO pl_dynamic_select (ds_id, ds_name, ds_describe, ds_create_time) VALUES ('ea9fc1d8-05b6-432f-a72f-a760f351bc7d', '顾客查询', '顾客-顾客列表', '2016-04-07 14:18:53');
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('514a4a3c-cfd8-4464-a659-e397349f9706', 'ea9fc1d8-05b6-432f-a72f-a760f351bc7d', '帐套与顾客关联表', 'crm_customer_account', 1, null, null, 1, 1, null, null);
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', 'ea9fc1d8-05b6-432f-a72f-a760f351bc7d', '顾客表', 'crm_customer', 3, null, '${thisTable}.CST_ID=${masterTable}.CST_ID', 1, 2, null, null);
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('3f97b890-838f-4abb-a38a-38d5d4f73a47', 'ea9fc1d8-05b6-432f-a72f-a760f351bc7d', '顾客-微信表', 'crm_customer_weixin', 3, null, '${thisTable}.CST_ID=${masterTable}.CST_ID', 1, 3, null, null);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('88420735-f6ca-4cbe-b637-9e2ee82e0e3d', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '顾客ID', null, 'CST_ID', true, 1, 1, 1, 1, false, 1, null, 1, null, null, null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 1, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('5aecc71f-e3a6-4b5f-a60a-b1eaaf8cc9e2', '514a4a3c-cfd8-4464-a659-e397349f9706', '帐套ID', null, 'act_id', false, 4, 1, 1, 1, true, 1, null, 1, null, null, null, null, false, '37', null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 1, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('c8bc0630-ce01-41f6-9f42-c908b0736760', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '顾客类型', null, 'CST_TYPE', false, 1, 1, 1, 21, false, 1, null, 1, null, null, null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 3, 1, 'SELECT codeExt code, IF(codeExt = 1,''会员'',''粉丝'') name FROM vQueryVarItem where vaCode=''valid''', null, null, 2, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('384fa6b2-79eb-4dfa-8d63-b03e3670f82d', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '姓名/会员名', null, 'CST_NAME', false, 1, 1, 1, 1, false, 1, null, 1, 'CONCAT(LAST_NAME,FIRST_NAME)', 'locate(${CST_NAME},CONCAT(LAST_NAME,FIRST_NAME))>0', null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 3, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('a5eae80e-ba25-4412-a22d-dabdcac600d9', '3f97b890-838f-4abb-a38a-38d5d4f73a47', '昵称', null, 'NICK_NAME', false, 1, 1, 1, 1, false, 1, null, 1, null, 'locate(${NICK_NAME},${thisTable}.NICK_NAME)>0', null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 4, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('dcefc2ec-011e-441a-a59e-012132e4179e', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '手机', null, 'PHONE', false, 1, 1, 1, 1, false, 1, null, 1, null, 'locate(${PHONE},${thisTable}.PHONE)>0', null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 5, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('9d067b35-38e1-41ff-a4fb-c6394c14b441', '3f97b890-838f-4abb-a38a-38d5d4f73a47', 'OPEN ID', null, 'OPEN_ID', false, 1, 1, 1, 1, false, 1, null, 1, null, null, null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, true, 6, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('117865f0-5feb-4c7f-89c7-09b7e7d3eb55', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '邮箱', null, 'EMAIL', false, 1, 1, 1, 1, false, 1, null, 1, null, null, null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 7, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('0035a530-30c4-4975-85bc-9f219c126d70', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '入会日期', null, 'REG_TIME', false, 1, 1, 4, 31, false, 1, null, 1, null, 'DATE_FORMAT(${thisTable}.REG_TIME,''%Y-%m-%d'')=${REG_TIME}', null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 8, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('aeee4c9b-5b00-4f9b-b35a-8ffc5dc904d4', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '归并', null, 'MERGED', false, 4, 1, 1, 1, true, 1, null, 1, null, null, null, null, false, '0', null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 9, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('df6f231a-2b93-418e-9364-4b62a92dffde', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '姓', null, 'FIRST_NAME', false, 1, 1, 1, 1, true, 1, null, 1, null, null, null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 10, false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('e7e29908-8aaf-4557-8821-de6d40a9d11e', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '名', null, 'LAST_NAME', false, 1, 1, 1, 1, true, 1, null, 1, null, null, null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 11, false, false);
/******************************删除****************************************************************************/
delete from pl_dynamic_field_data where df_id in(
select df_id from pl_dynamic_field
where dt_id in (select dt_id from pl_dynamic_table where ds_id ='9fec211b-3c8f-459b-a5eb-3204331abda0')
);
delete from pl_dynamic_field
where dt_id in (select dt_id from pl_dynamic_table where ds_id ='9fec211b-3c8f-459b-a5eb-3204331abda0');
delete from pl_dynamic_table where ds_id ='9fec211b-3c8f-459b-a5eb-3204331abda0';
delete from pl_dynamic_select where ds_id ='9fec211b-3c8f-459b-a5eb-3204331abda0';
/******************************添加****************************************************************************/
INSERT INTO pl_dynamic_select (ds_id, ds_name, ds_describe, ds_create_time) VALUES ('9fec211b-3c8f-459b-a5eb-3204331abda0', '积点调整单次表', NULL, NULL);
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('92a49b0f-f70c-4124-8330-4e484210688e', '9fec211b-3c8f-459b-a5eb-3204331abda0', '积点调整单次表', 'crm_point_adjust_detail', '1', NULL, NULL, '1', '1', NULL, NULL);
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('2c445502-e018-49ff-bc8a-32f6ae3059b8', '9fec211b-3c8f-459b-a5eb-3204331abda0', '顾客表', 'crm_customer', '2', NULL, 't1.CST_ID = t2.CST_ID', '1', '2', NULL, NULL);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('c75b792f-be20-408f-88ad-e0369bccf84e', '2c445502-e018-49ff-bc8a-32f6ae3059b8', '顾客昵称', NULL, 'CST_NAME', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('d40dd16f-9eb3-4985-90fa-65b4a15427f6', '2c445502-e018-49ff-bc8a-32f6ae3059b8', '顾客手机', NULL, 'PHONE', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('0a34e8bd-c2ac-493d-90a1-6998e0a9deec', '92a49b0f-f70c-4124-8330-4e484210688e', '调整状态', NULL, 'STATUS', '\0', '1', '1', '1', '1', '', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('3452a934-8377-4d8b-8190-23ace4ee9485', '92a49b0f-f70c-4124-8330-4e484210688e', '关联单据号', NULL, 'ORDER_ID', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, '', NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('55de168f-bfbd-4586-9be7-826e918fdd4d', '92a49b0f-f70c-4124-8330-4e484210688e', '积点调整值', NULL, 'POINTS', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('581a4dd0-ce02-4d9d-bd86-277191c8ae6f', '92a49b0f-f70c-4124-8330-4e484210688e', '结果备注', NULL, 'RESULT_MEMO', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('61f219de-8d5e-434b-818b-e937f08e9aeb', '92a49b0f-f70c-4124-8330-4e484210688e', '有效期结束时间', NULL, 'E_TIME', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('6921b56b-c360-4467-8a38-e55eecd12491', '92a49b0f-f70c-4124-8330-4e484210688e', '关联主表ID', NULL, 'ADJ_ID', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, 't1.ADJ_ID=${ADJ_ID}', NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('75722332-c89a-4abf-992d-849e47c69605', '92a49b0f-f70c-4124-8330-4e484210688e', '备注', NULL, 'REMARK', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('dd87e6c9-ba7b-41ab-afd5-22c6101e5a20', '92a49b0f-f70c-4124-8330-4e484210688e', '积点调整次表Id', NULL, 'ID', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '');
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('ece8980b-b36e-4ac5-82da-b8da9a7977d3', '92a49b0f-f70c-4124-8330-4e484210688e', '顾客iD', NULL, 'CST_ID', '\0', '1', '1', '1', '1', '\0', '1', NULL, '1', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', '\0', '\0');
/**推送通道-微信公众号DELETE********************************************************************************************************/
DELETE FROM pl_dynamic_field WHERE dt_id in(SELECT dt_id FROM pl_dynamic_table WHERE ds_id='ac82b1a1-2cc8-4213-b07f-ed6cbc6ef082' ORDER BY dt_sort);
DELETE FROM pl_dynamic_table WHERE ds_id='ac82b1a1-2cc8-4213-b07f-ed6cbc6ef082' ORDER BY dt_sort;
DELETE FROM pl_dynamic_select WHERE ds_id='ac82b1a1-2cc8-4213-b07f-ed6cbc6ef082';
DELETE FROM pl_dynamic_field_data WHERE df_id='0dd5291b-3efa-493e-8f72-1dbb01c8fd24';
DELETE FROM pl_dynamic_field_data WHERE df_id='cb813ed3-5c9c-4530-bfcd-b49fa7f9a672';
/**推送通道-微信公众号INSERT********************************************************************************************************/
INSERT INTO pl_dynamic_select (ds_id, ds_name, ds_describe, ds_create_time) VALUES ('ac82b1a1-2cc8-4213-b07f-ed6cbc6ef082', '推送通道-微信公众号', NULL, NULL);
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('1e1c676b-8b30-4bc7-ab44-f2990805b0d9', 'ac82b1a1-2cc8-4213-b07f-ed6cbc6ef082', '微信公众号', 'crm_wxgzh', '1', NULL, NULL, '1', '1', NULL, NULL);
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('1ec28a60-ae71-4885-93f6-6a9043a47976', 'ac82b1a1-2cc8-4213-b07f-ed6cbc6ef082', '推送通道', 'smMsgChannel', '3', NULL, 't2.GZH_ID = t1.GZH_ID AND t2.mcType = 3', '1', '2', NULL, NULL);
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('d3b05b61-5d98-42ad-9cbe-cec70d241d82', 'ac82b1a1-2cc8-4213-b07f-ed6cbc6ef082', '用户平台', 'smPlatform', '3', NULL, 't3.plId = t2.plId', '1', '3', NULL, NULL);
INSERT INTO pl_dynamic_table (dt_id, ds_id, dt_name, dt_tablename, dt_type, dt_ref_select, dt_on, dt_relation, dt_sort, dt_create_time, dt_update_time) VALUES ('de05e939-d5e0-4d21-9988-b9ff191d829c', 'ac82b1a1-2cc8-4213-b07f-ed6cbc6ef082', '经营主体', 'mtBizEntity', '3', NULL, 't4.beId = t2.beId', '1', '4', NULL, NULL);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('0dd5291b-3efa-493e-8f72-1dbb01c8fd24', '1e1c676b-8b30-4bc7-ab44-f2990805b0d9', '认证状态', NULL, 'VERIFY', false, '1', '1', '1', '21', false, '1', NULL, NULL, NULL, NULL, NULL, '不限', NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '4', false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('5b265ede-03a9-43a1-ad48-588368391ecb', '1e1c676b-8b30-4bc7-ab44-f2990805b0d9', '公众号ID', NULL, 'GZH_ID', true, '1', '1', '1', '1', false, '1', NULL, NULL, NULL, 'locate(${GZH_ID},${masterTable}.GZH_ID)>0', NULL, '不限', NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '3', false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('63976bf7-a579-4c3e-8970-8f172558d1c8', '1e1c676b-8b30-4bc7-ab44-f2990805b0d9', '原始ID', NULL, 'USER_NAME', false, '1', '1', '1', '1', false, '1', NULL, NULL, NULL, 'locate(${USER_NAME},${masterTable}.USER_NAME)>0', NULL, '不限', NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '2', false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('85a54f18-d00b-43db-9fc1-8348b5d990a0', '1e1c676b-8b30-4bc7-ab44-f2990805b0d9', '头像', NULL, 'HEAD_IMG', false, '1', '1', '1', '1', true, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', false, true);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('c0823a03-324e-4778-9ede-a812576bc57a', '1e1c676b-8b30-4bc7-ab44-f2990805b0d9', '名称', NULL, 'NICK_NAME', false, '1', '1', '1', '1', false, '1', NULL, NULL, NULL, 'locate(${NICK_NAME},${masterTable}.NICK_NAME)>0', NULL, '不限', NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('cb813ed3-5c9c-4530-bfcd-b49fa7f9a672', '1e1c676b-8b30-4bc7-ab44-f2990805b0d9', '公众号类型', NULL, 'GZH_TYPE', false, '1', '1', '1', '21', true, '1', NULL, NULL, NULL, NULL, NULL, '不限', NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', false, true);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('f3bf925d-5c62-41c3-87fd-d3fd6fe693d9', '1ec28a60-ae71-4885-93f6-6a9043a47976', '通道ID', NULL, 'mcId', false, '1', '1', '1', '1', true, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '1', false, true);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('c8656546-fc4b-47cb-b405-cc549d4debba', 'd3b05b61-5d98-42ad-9cbe-cec70d241d82', '配置平台', NULL, 'plName', false, '1', '1', '1', '1', false, '1', NULL, NULL, NULL, 'locate(${plName},${masterTable}.plName)>0', NULL, '不限', NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '5', false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('c0db1c1b-10f7-4197-9495-d905ef1bc505', 'de05e939-d5e0-4d21-9988-b9ff191d829c', '经营主体', NULL, 'beName', false, '1', '1', '1', '1', false, '1', NULL, NULL, NULL, 'locate(${beName},${masterTable}.beName)>0', NULL, '不限', NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '6', false, false);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('34bf2364-815f-4517-972b-06284e88cb2b', '1ec28a60-ae71-4885-93f6-6a9043a47976', '经营主体ID', NULL, 'beId', false, '1', '1', '1', '1', true, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '7', false, true);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('618ad9a1-f330-489a-aa10-bb1d78fe7cec', '1ec28a60-ae71-4885-93f6-6a9043a47976', '平台ID', NULL, 'plId', false, '1', '1', '1', '1', true, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '8', false, true);
INSERT INTO pl_dynamic_field (df_id, dt_id, df_name, df_field_asname, df_field_name, df_primary, df_type, df_group, df_data_type, df_filter_type, df_filter_hidden, df_select_type, df_ref_select, df_ref_type, df_select_format, df_where_format, df_having_format, df_empty_tips, df_notnull, df_defval, df_regex, df_regex_error, df_width, df_decimals, df_maxvalue, df_minvalue, df_maxlength, df_minlength, df_temp_text, df_temp_sql, df_data_use_type, df_data_show_type, df_data_sql, df_orderby, df_group_concat, df_sort, df_disable, df_select_hidden) VALUES ('591a6602-c569-4bdd-b94b-060653d1f98d', '1e1c676b-8b30-4bc7-ab44-f2990805b0d9', '过滤条件', NULL, 'filter', false, '4', '1', '1', '1', true, '1', NULL, '1', NULL, 'CASE WHEN ${filter}= 1 THEN 1 = 1 WHEN ${filter}<> 1 THEN t2.beId IN (\r\n SELECT t5.beId FROM smPlatform t6 LEFT JOIN mtBizEntity t5 ON t6.beId = t5.beId\r\n WHERE t6.plId = ( SELECT plId FROM smUsers WHERE usId =${filter} ) ) END', NULL, NULL, NULL, '${userId}', NULL, NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, '9', false, true);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('4f4030e7-48a5-4c1e-b78f-56e5d81ecdee', '0dd5291b-3efa-493e-8f72-1dbb01c8fd24', '-1', '未认证', NULL, NULL, NULL);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('96329f31-b4d4-4584-9a87-8aaab9584742', '0dd5291b-3efa-493e-8f72-1dbb01c8fd24', '1', '新浪微博认证', NULL, NULL, NULL);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('9bed5374-d25d-4436-9961-c4b37fdf2bdd', '0dd5291b-3efa-493e-8f72-1dbb01c8fd24', '2', '腾讯微博认证', NULL, NULL, NULL);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('37065c3f-241d-4f6a-863e-eaeb661a2518', '0dd5291b-3efa-493e-8f72-1dbb01c8fd24', '3', '已资质认证通过但还未通过名称认证', NULL, NULL, NULL);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('39c05e8b-2995-461d-a208-72e5d4b2112a', '0dd5291b-3efa-493e-8f72-1dbb01c8fd24', '4', '已资质认证通过、还未通过名称认证，但通过了新浪微博认证', NULL, NULL, NULL);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('5304de35-e120-4882-bc21-46de4fde3178', '0dd5291b-3efa-493e-8f72-1dbb01c8fd24', '5', '已资质认证通过、还未通过名称认证，但通过了腾讯微博认证', NULL, NULL, NULL);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('bc499960-aa7a-494c-9875-b3e1fa0b1a25', 'cb813ed3-5c9c-4530-bfcd-b49fa7f9a672', '0', '订阅号', NULL, NULL, NULL);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('34881927-7c6d-4fdd-9d47-cf2768e27583', 'cb813ed3-5c9c-4530-bfcd-b49fa7f9a672', '1', '历史老帐号升级后的订阅号', NULL, NULL, NULL);
INSERT INTO pl_dynamic_field_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('834db8e3-2c0e-4262-bde7-2d71410d0452', 'cb813ed3-5c9c-4530-bfcd-b49fa7f9a672', '2', '服务号', NULL, NULL, NULL);
/*经营主体编辑*/
INSERT INTO smMenuAction (meaId, meId, meaCode, meaName, meaSort) VALUES (94, 11, 'edit', '编辑', 2);
INSERT INTO smMenuActionPlatType (meaId, pltId) VALUES (94, 1);
INSERT INTO smMenuActionPlatType (meaId, pltId) VALUES (94, 2);
INSERT INTO smMenuActionPlatType (meaId, pltId) VALUES (94, 3);
/*INSERT INTO smRoleMenuAction (roId, meaId) VALUES (1, 74);*/