DELETE FROM pl_dynamic_field WHERE dt_id in(SELECT dt_id FROM pl_dynamic_table WHERE ds_id='2582a029-3902-4934-a206-d638f96d4b08' ORDER BY dt_sort);
DELETE FROM pl_dynamic_table WHERE ds_id='2582a029-3902-4934-a206-d638f96d4b08' ORDER BY dt_sort;
DELETE FROM pl_dynamic_select WHERE ds_id='2582a029-3902-4934-a206-d638f96d4b08';

SELECT * FROM pl_dynamic_select WHERE ds_id='2582a029-3902-4934-a206-d638f96d4b08';
SELECT * FROM pl_dynamic_table WHERE ds_id='2582a029-3902-4934-a206-d638f96d4b08' ORDER BY dt_sort;
SELECT * FROM pl_dynamic_field WHERE dt_id in(SELECT dt_id FROM pl_dynamic_table WHERE ds_id='2582a029-3902-4934-a206-d638f96d4b08' ORDER BY dt_sort);

INSERT INTO `pl_dynamic_select` (`ds_id`, `ds_name`, `ds_describe`, `ds_create_time`) VALUES ('2582a029-3902-4934-a206-d638f96d4b08', '账套-顾客移动平台查询', 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 ('0e3850d0-5ef9-417d-a153-d1abfee4a67a', '2582a029-3902-4934-a206-d638f96d4b08', '微信公众号', '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 ('0494c8fc-d9c6-45b6-bb6e-453b17c351e1', '2582a029-3902-4934-a206-d638f96d4b08', '帐户数据项限制', 'smUsDataItem', '3', NULL, 't2.extStringId = t1.GZH_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 ('8b1dc08a-0171-4d0e-9f43-bf338537731d', '0494c8fc-d9c6-45b6-bb6e-453b17c351e1', '用户ID', NULL, 'usId', false, '4', '1', '1', '1', true, '1', NULL, NULL, NULL, 't2.usId = ${usId}', NULL, NULL, NULL, '${userId}', 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 ('3de5e308-3169-49ab-83d4-bbbd87c142b1', '0e3850d0-5ef9-417d-a153-d1abfee4a67a', '名称', NULL, 'NICK_NAME', false, '1', '1', '1', '1', false, '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, 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 ('b854f110-bcf3-4cc4-bb0a-f56ab043c517', '0e3850d0-5ef9-417d-a153-d1abfee4a67a', '类型', NULL, 'GZH_TYPE', 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 ('e9b80178-085d-4b9b-8822-19d2dc007e00', '0e3850d0-5ef9-417d-a153-d1abfee4a67a', '公众号ID', NULL, 'GZH_ID', true, '1', '1', '1', '1', false, '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, false);