2016-04-19.sql
13.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
alter table smUsDataItem add column usdStatus int not null comment '1: 可见范围的条件 2:可编辑范围';
alter table smUsDataItem add column usdText varchar(500) null comment '描述信息';
/******************************删除****************************************************************************/
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 ='99f54539-c5aa-40c3-9ced-ab943a441b99')
);
delete from pl_dynamic_field
where dt_id in (select dt_id from pl_dynamic_table where ds_id ='99f54539-c5aa-40c3-9ced-ab943a441b99');
delete from pl_dynamic_table where ds_id ='99f54539-c5aa-40c3-9ced-ab943a441b99';
delete from pl_dynamic_select where ds_id ='99f54539-c5aa-40c3-9ced-ab943a441b99';
/******************************添加****************************************************************************/
INSERT INTO pl_dynamic_select (ds_id, ds_name, ds_describe, ds_create_time) VALUES ('99f54539-c5aa-40c3-9ced-ab943a441b99', '顾客移动平台', 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 ('57d22c3d-1dc4-46f9-8111-ad44a5882dbb', '99f54539-c5aa-40c3-9ced-ab943a441b99', '微信公众号', '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 ('f8a470b6-fafb-4f5f-ae70-a4da85d15060', '99f54539-c5aa-40c3-9ced-ab943a441b99', '推送通道', 'smMsgChannel', 2, null, '${thisTable}.GZH_ID = ${masterTable}.GZH_ID AND ${thisTable}.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 ('f5134c13-a11e-4bfe-96cc-9c7f09c5174d', '99f54539-c5aa-40c3-9ced-ab943a441b99', '微信公众号类型', 'pl_dynamic_field_data', 3, null, '${masterTable}.GZH_TYPE=${thisTable}.dfd_code and ${thisTable}.df_id=''f6fb28fd-2683-4b36-b053-3ba0f96f7ce5''', 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 ('3aa6aacd-51ef-4e12-a4bb-ef0d5b1de856', '57d22c3d-1dc4-46f9-8111-ad44a5882dbb', '编号', null, 'GZH_ID', true, 1, 1, 1, 1, false, 1, null, 1, null, 'locate(${GZH_ID},${masterTable}.GZH_ID)>0', 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 ('f6fb28fd-2683-4b36-b053-3ba0f96f7ce5', '57d22c3d-1dc4-46f9-8111-ad44a5882dbb', '类型', null, 'GZH_TYPE', false, 4, 1, 2, 21, 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, 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 ('0dc16639-9ecb-4fbd-8b48-bc840cc67643', 'f5134c13-a11e-4bfe-96cc-9c7f09c5174d', '类型', 'GZH_TYPE', 'dfd_name', false, 3, 1, 2, 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 ('c92256db-2391-49d2-a7c6-854446c5791f', '57d22c3d-1dc4-46f9-8111-ad44a5882dbb', '昵称', null, 'NICK_NAME', false, 1, 1, 1, 1, false, 1, null, 1, null, 'locate(${NICK_NAME},${masterTable}.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 ('10b8e81d-cea6-4be1-a955-90f2bdd10718', '57d22c3d-1dc4-46f9-8111-ad44a5882dbb', '图片', null, 'HEAD_IMG', false, 3, 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_data (dfd_id, df_id, dfd_code, dfd_name, dfd_ext, dfd_group, dfd_parent) VALUES ('205c02e2-8ecf-411a-a1d6-27ca8f38c3fd', 'f6fb28fd-2683-4b36-b053-3ba0f96f7ce5', '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 ('26a326c4-2dd2-488a-b296-2d8284f0d546', 'f6fb28fd-2683-4b36-b053-3ba0f96f7ce5', '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 ('2d70dde7-9035-4245-a265-e2c4d4457819', 'f6fb28fd-2683-4b36-b053-3ba0f96f7ce5', '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 ('39670158-ed19-46d8-a363-f32c9c082c09', 'f6fb28fd-2683-4b36-b053-3ba0f96f7ce5', '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 ('43a4f885-a6aa-496d-a090-c2b4add8a5f8', 'f6fb28fd-2683-4b36-b053-3ba0f96f7ce5', '-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 ('d289be9e-726f-40cd-ad8c-b3175af93c5e', 'f6fb28fd-2683-4b36-b053-3ba0f96f7ce5', '2', '腾讯微博认证', null, null, null);
/******************************删除****************************************************************************/
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 ='d3f29dd6-d085-45b9-b83d-c8dc07c095df')
);
delete from pl_dynamic_field
where dt_id in (select dt_id from pl_dynamic_table where ds_id ='d3f29dd6-d085-45b9-b83d-c8dc07c095df');
delete from pl_dynamic_table where ds_id ='d3f29dd6-d085-45b9-b83d-c8dc07c095df';
delete from pl_dynamic_select where ds_id ='d3f29dd6-d085-45b9-b83d-c8dc07c095df';
/******************************添加****************************************************************************/
INSERT INTO pl_dynamic_select (ds_id, ds_name, ds_describe, ds_create_time) VALUES ('d3f29dd6-d085-45b9-b83d-c8dc07c095df', 'CRM帐套查询', 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 ('92a1dc61-8dda-4a75-8d2d-db3e582da6e0', 'd3f29dd6-d085-45b9-b83d-c8dc07c095df', 'CRM帐套表', 'crm_account_set', 1, null, null, 1, 1, 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 ('595e0bce-00fc-4568-ac43-b1f937e99139', '92a1dc61-8dda-4a75-8d2d-db3e582da6e0', '账套ID', null, 'ACT_ID', true, 3, 1, 2, 11, 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, 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 ('1e3bac18-6f5d-47ea-b053-da0c63dde45b', '92a1dc61-8dda-4a75-8d2d-db3e582da6e0', '账套代号', null, 'ACT_CODE', false, 1, 1, 1, 1, false, 1, null, 1, null, '', null, null, false, null, null, null, 120, 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 ('74ccc346-dc43-4013-a66b-260cec407753', '92a1dc61-8dda-4a75-8d2d-db3e582da6e0', '账套名称', null, 'ACT_NAME', false, 1, 1, 1, 1, false, 1, null, 1, null, 'locate(${ACT_NAME},${masterTable}.ACT_NAME)>0', null, null, false, null, null, null, 300, 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 ('0937b361-d6d7-4bcf-8a0f-1bb670ac457d', '92a1dc61-8dda-4a75-8d2d-db3e582da6e0', '主管平台ID', null, 'PTF_ID', false, 4, 1, 2, 11, true, 1, null, 1, null, null, null, null, false, '${platId}', null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 4, 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 ('981b911a-c178-4263-aefe-b115171f3711', '92a1dc61-8dda-4a75-8d2d-db3e582da6e0', '是否可用', null, 'ENABLE', false, 4, 1, 2, 11, true, 1, null, 1, null, null, null, null, false, '1', null, null, 100, null, null, null, null, null, null, null, 1, 1, null, null, null, 5, false, true);