create index idx_mtEmployee_coId on mtEmployee(coId);
create index idx_mtEmployee_diId on mtEmployee(diId);
create index idx_mtPost_deId on mtPost(deId);
create index idx_mtDept_coId on mtDept(coId);
create index idx_mtSitePayway_siId on mtSitePayway(siId);
create index idx_mtSitePayway_bepId on mtSitePayway(bepId);
create index idx_mtSitePayway_beaId on mtSitePayway(beaId);
create index idx_mtSiteRange_siId on mtSiteRange(siId);
create index idx_mtSiteRange_chId on mtSiteRange(chId);
create index idx_mtSiteRange_orId on mtSiteRange(orId);
create index idx_mtSite_beId on mtSite(beId);
create index idx_mtSite_diId on mtSite(diId);
create index idx_mtSite_bebId on mtSite(bebId);
create index idx_mtOrganization_beId on mtOrganization(beId);
create index idx_mtOrganization_orlId on mtOrganization(orlId);
create index idx_mtBizChannel_beId on mtBizChannel(beId);
create index idx_mtBizChannel_chId on mtBizChannel(chId);
create index idx_mtBizPayway_bebId on mtBizPayway(bebId);
create index idx_mtBizPayway_cuId on mtBizPayway(cuId);
create index idx_mtBizPayway_beaId on mtBizPayway(beaId);
create index idx_mtBizAccount_bebId on mtBizAccount(bebId);
create index idx_mtBizInvoice_bebId on mtBizInvoice(bebId);
create index idx_mtBizSetOfBook_beId on mtBizSetOfBook(beId);
create index idx_smRole_meId on smRole(pltId);
create index idx_smRole_plId on smRole(plId);
create index idx_smMenuAction_meId on smMenuAction(meId);
create index idx_smUsDataItem_usId on smUsDataItem(usId);
create index idx_smUsDataItem_extId on smUsDataItem(extId);
create index idx_smUsDataItem_extLongId on smUsDataItem(extLongId);
create index idx_smUsPermission_usId on smUsPermission(usId);
create index idx_smUsPermission_chId on smUsPermission(chId);
create index idx_smPhoneLog_emPhone on smPhoneLog (emPhone);
create index idx_smPhoneLog_plId on smPhoneLog (plId);
create index idx_smUsername_emId on smUsername (emId);
create index idx_smUsers_plId on smUsers (plId);
create index idx_smUsers_emId on smUsers (emId);
create index idx_smUsers_laId on smUsers (laId);
create index idx_smPlatMsgChannel_plId on smPlatMsgChannel (plId);
create index idx_smPlatMsgChannel_mcId on smPlatMsgChannel (mcId);
create index idx_smMsgChannel_plCreateId on smMsgChannel (plCreateId);
create index idx_smMsgChannel_beId on smMsgChannel (beId);
create index idx_smPlatformMenuAction_plId on smPlatformMenuAction (plId);
create index idx_smPlatformMenuAction_meaId on smPlatformMenuAction (meaId);
create index idx_smPlatform_pltId on smPlatform (pltId);
create index idx_smPlatformTypeInfo_pltId on smPlatformTypeInfo (pltId,pltType);
create index idx_mtVarItem_vaId on mtVarItem (vaId);
create unique index uidx_mtVariable_ciId on mtVariable (vaCode);
create index idx_mtTown_diId on mtTown (diId);
create index idx_mtDistrict_ciId on mtDistrict (ciId);
create index idx_mtCity_prId on mtCity (prId);
create index dx_mtProvince_coId on mtProvince (coId);


/******************************删除****************************************************************************/
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 ('aeee4c9b-5b00-4f9b-b35a-8ffc5dc904d4', '18c4b85e-e011-4ef1-8ee3-5db28ad47aa7', '归并', null, 'MERGED', false, 4, 1, 1, 1, false, 1, null, 1, null, null, null, null, false, '0', 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, null, null, 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, null, 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, null, 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, null, null, null, false, null, null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 8, false, false);


/**推送通道-微信公众号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 ('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 (
	SELECT t5.beId FROM smPlatform t6 LEFT JOIN mtBizEntity t5 ON t6.beId = t5.beId
	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 (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 ('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 ('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_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);	

DELETE FROM pl_dynamic_field WHERE DF_ID='89481898-91da-42dd-88c4-2add6ac5d476';
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 ('89481898-91da-42dd-88c4-2add6ac5d476', 'ff815225-3da6-4798-ab52-2674ce241228', '创建时间', null, 'REC_TIME', false, 1, 1, 4, 31, false, 2, 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);

DELETE FROM pl_dynamic_field where df_id='0035a530-30c4-4975-85bc-9f219c126d70';
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);