327 lines
11 KiB
Plaintext
327 lines
11 KiB
Plaintext
--权限按钮
|
||
truncate table T_FM_ROLE_MENU_PERM_BTN
|
||
go
|
||
delete T_FM_ROLE_MENU_PERM
|
||
go
|
||
|
||
--菜单
|
||
truncate table T_PF_MENU
|
||
go
|
||
delete T_PF_BTN
|
||
go
|
||
|
||
--列表页查询
|
||
truncate table T_PF_QUERY
|
||
go
|
||
delete T_PF_FORM_QUERY
|
||
go
|
||
|
||
--//列表
|
||
|
||
delete T_FM_USER_C_C_EDIT_H_COL
|
||
go
|
||
delete T_FM_USER_C_C_EDIT
|
||
go
|
||
delete T_FM_USER_CUSTOM_CONFIG_H_COL
|
||
go
|
||
delete T_FM_USER_CUSTOM_CONFIG_H_TAB
|
||
go
|
||
delete T_FM_USER_C_C_QUERY_FIELD
|
||
go
|
||
delete T_FM_USER_C_C_QUERY
|
||
go
|
||
delete T_FM_USER_CUSTOM_CONFIG
|
||
go
|
||
|
||
|
||
delete T_PF_COLUMN
|
||
go
|
||
delete T_FM_USER_C_C_TABLE
|
||
go
|
||
delete T_PF_TABLE_PARAMS
|
||
go
|
||
delete T_FM_USER_CUSTOM_CONFIG_H_TAB
|
||
go
|
||
delete T_PF_PAGE_TABLE
|
||
go
|
||
|
||
--编辑
|
||
delete T_PF_EDIT_COLUMN_FILTER
|
||
go
|
||
delete T_PF_EDIT_COLUMN_FILL_MAP_D
|
||
go
|
||
delete T_PF_EDIT_COLUMN_FILL_MAP
|
||
go
|
||
delete T_FM_USER_C_C_EDIT_H_COL
|
||
go
|
||
delete T_PF_EDIT_COLUMN
|
||
go
|
||
--编辑 填充区域
|
||
delete T_PF_PAGE_EDIT_PANEL
|
||
go
|
||
delete T_FM_USER_C_C_EDIT
|
||
go
|
||
delete T_PF_PAGE_EDIT
|
||
go
|
||
|
||
--表单
|
||
delete T_PF_PAGE_CUSTOM
|
||
go
|
||
delete T_PF_TREE_COLUMN
|
||
go
|
||
delete T_PF_PAGE_TREE
|
||
go
|
||
delete T_PF_SYS_LOG
|
||
go
|
||
delete T_FM_USER_C_C_QUERY_FIELD
|
||
go
|
||
delete T_FM_USER_C_C_QUERY
|
||
go
|
||
|
||
/****新****/
|
||
delete T_PF_FLOW_INSTANCE_OPER_HIS
|
||
go
|
||
delete T_PF_FLOW_INSTANCE_TRANS_HIS
|
||
go
|
||
delete T_PF_FLOW_INSTANCE
|
||
go
|
||
delete T_PF_FLOW_SCHEME
|
||
go
|
||
|
||
|
||
delete T_PF_PAGE_CHART_PARAM
|
||
go
|
||
delete T_PF_PAGE_CHART
|
||
go
|
||
/****新****/
|
||
|
||
delete T_PF_FORM
|
||
go
|
||
|
||
|
||
--OrgId 插入
|
||
--数据插入
|
||
insert into T_FM_ORGANIZATION
|
||
select * from mh_db.dbo.T_FM_ORGANIZATION where ID='B043B28B-BBC3-C452-6052-4FBA1457ABFA'
|
||
|
||
--delete T_FM_ORGANIZATION where ID='B043B28B-BBC3-C452-6052-4FBA1457ABFA'--最后执行语句
|
||
|
||
--数据插入
|
||
insert into T_PF_FORM
|
||
select * from mh_db.dbo.T_PF_FORM
|
||
|
||
|
||
--/****新****/
|
||
|
||
|
||
insert into T_PF_FLOW_SCHEME
|
||
select * from mh_db.dbo.T_PF_FLOW_SCHEME
|
||
|
||
insert into T_PF_PAGE_CHART
|
||
select * from mh_db.dbo.T_PF_PAGE_CHART
|
||
|
||
insert into T_PF_PAGE_CHART_PARAM
|
||
select * from mh_db.dbo.T_PF_PAGE_CHART_PARAM
|
||
|
||
|
||
insert into T_PF_FLOW_INSTANCE
|
||
select * from mh_db.dbo.T_PF_FLOW_INSTANCE
|
||
|
||
insert into T_PF_FLOW_INSTANCE_OPER_HIS
|
||
select * from mh_db.dbo.T_PF_FLOW_INSTANCE_OPER_HIS
|
||
|
||
insert into T_PF_FLOW_INSTANCE_TRANS_HIS
|
||
select * from mh_db.dbo.T_PF_FLOW_INSTANCE_TRANS_HIS
|
||
|
||
--/****新****/
|
||
|
||
|
||
|
||
--insert into T_FM_USER_C_C_QUERY
|
||
--select [ID], [USER_CUSTOM_CONFIG_ID], [PAGE_FORM_ID], [TITLE], [IS_DEFAULT], [IS_DELETED], [ORG_ID], [ENTITY_ORG_TPYE], [FORM_ID], [FLOW_STATUS], [FLOW_SEND_STATUS], [FLOW_ID], [CREATE_TIME], [MODIFY_TIME], null [CREATER_ID],null [MODIFIER_ID] from mh_db.dbo.T_FM_USER_C_C_QUERY
|
||
|
||
--insert into T_FM_USER_C_C_QUERY_FIELD
|
||
--select * from mh_db.dbo.T_FM_USER_C_C_QUERY_FIELD
|
||
|
||
--insert into T_PF_SYS_LOG
|
||
--select * from mh_db.dbo.T_PF_SYS_LOG
|
||
|
||
insert into T_PF_PAGE_TREE
|
||
select * from mh_db.dbo.T_PF_PAGE_TREE
|
||
|
||
insert into T_PF_TREE_COLUMN
|
||
select * from mh_db.dbo.T_PF_TREE_COLUMN
|
||
|
||
insert into T_PF_PAGE_CUSTOM
|
||
select * from mh_db.dbo.T_PF_PAGE_CUSTOM
|
||
|
||
--编辑
|
||
insert into T_PF_PAGE_EDIT
|
||
select * from mh_db.dbo.T_PF_PAGE_EDIT --如果不行 直接拉取表单的列，demo如下
|
||
--select [ID], [PAGE_FORM_ID], [CODE], [EDIT_NAME], [LABEL_NAME], [API_URL], [IS_CONTAINS_NAV], [SEND_TYPE], [WIDTH], [HEIGTH], [QUERY_API_URL], [QUERY_SEND_TYPE], [BATCH_QUERY_API], [BATCH_UPDATE_API], [RELATION_FIELD], [NAV_PROPERTY], [IS_DETAIL_REQUIRED], [CODE_FIELD_NAME], [CODE_RULE_TYPE], [NAV_ROW_CLASS_FILTER], [SORT_FIELDS], [SORT_ORDERS], [CUSTOM_PARAMS], [SUB_TABLE_CONDITION], [PARENT_COPY_FIELD], [CHILD_SET_FIELD], [NUM], [IS_PERMIT_ADD_ROW], [IS_PERMIT_DEL_ROW], [EDIT_PAGE_ENTITY_ORG_TYPE], [IS_SUB_ADD_BTN_DISABLED], [IS_SUB_DELETE_BTN_DISABLED], [SHOW_CHECK], [PARAM_SCHEME_ID], [SRC_ID], [IS_DELETED], [ORG_ID], [ENTITY_ORG_TPYE], [FORM_ID], [FLOW_STATUS], [FLOW_SEND_STATUS], [FLOW_ID], [CREATE_TIME], [MODIFY_TIME], [CREATER_ID], [MODIFIER_ID], [PARENT_ID], [TEXT], [IS_LEAF], [DEFAULT_PAGE_SIZE], [IS_PAGE] from mh_db.dbo.T_PF_PAGE_EDIT
|
||
|
||
--insert into T_FM_USER_C_C_EDIT
|
||
--select * from mh_db.dbo.T_FM_USER_C_C_EDIT
|
||
|
||
insert into T_PF_PAGE_EDIT_PANEL
|
||
select * from mh_db.dbo.T_PF_PAGE_EDIT_PANEL
|
||
|
||
insert into T_PF_EDIT_COLUMN
|
||
select * from mh_db.dbo.T_PF_EDIT_COLUMN --如果不行 直接拉取表单的列，demo如下
|
||
--select [ID], [CODE], [PAGE_EDIT_ID], [FIELD_NAME], [IS_TABLE_COLUMN], [LABEL], [IS_DEFAULT], [IS_CUSTOM], [TYPE_NAME], [REQUIRED], [EDITABLE], [PERMIT_EDITABLE], [FORMAT], [INPUT_DATA_API], [INPUT_ID_FIELD], [IS_ONLY_CHECK_LEAF], [INPUT_DATA_LEVEL], [INPUT_FILTER_FIELD], [INPUT_SORT_FIELD], [INPUT_SORT_ORDER], [INPUT_LABEL_FIELD], [INPUT_SHOW_FIELD], [INPUT_NAV_FIELD], [INPUT_SAVE_FIELD], [SELECTD_LABEL_FIELD], [INPUT_FILTER_ORG_TYPE], [IS_IGNORE_TENANT], [INPUT_KEEP_VALUE_BY_NO_SRC], [QUERY_FORMAT], [ENUM], [CONTROL_TYPE], [VALIDATA_TYPE], [NUM], [MIN_LEN], [MAX_LEN], [VERIFY_MSG], [SHOW_FORM_CODE], [SHOW_ID_FIELD], [PAGE_EDIT_PANEL_ID], [IS_CAN_BATCH_EDIT], [EDIT_FORM_CODE], [EDIT_FORM_FILTER], [EDIT_FORM_FILTER_VALUE], [CASE], [WIDTH], [REMARK], [DEFAULT_VALUE], [PROMPT_INFO], [VERIFY_EXPRESS], [VERIFY_TYPE], [VERIFY_ERROR_INFO], [IS_COPY], [CODE_RULE_TYPE], [SRC_ID], [IS_RULE], [IS_DELETED], [ORG_ID], [ENTITY_ORG_TPYE], [FORM_ID], [FLOW_STATUS], [FLOW_SEND_STATUS], [FLOW_ID], [CREATE_TIME], [MODIFY_TIME], [CREATER_ID], [MODIFIER_ID], [HEIGHT], [SHOW_TYPE], [IS_CHECK_MAX], [IS_CHECK_MIN], [MAX_VAL], [MIN_VAL], [STEP] from mh_db.dbo.T_PF_EDIT_COLUMN
|
||
|
||
insert into T_PF_EDIT_COLUMN_FILL_MAP
|
||
select * from mh_db.dbo.T_PF_EDIT_COLUMN_FILL_MAP
|
||
|
||
insert into T_PF_EDIT_COLUMN_FILL_MAP_D
|
||
select * from mh_db.dbo.T_PF_EDIT_COLUMN_FILL_MAP_D
|
||
|
||
|
||
|
||
insert into T_FM_USER_CUSTOM_CONFIG
|
||
select * from mh_db.dbo.T_FM_USER_CUSTOM_CONFIG
|
||
|
||
insert into T_FM_USER_C_C_EDIT
|
||
select * from mh_db.dbo.T_FM_USER_C_C_EDIT
|
||
|
||
insert into T_FM_USER_C_C_EDIT_H_COL
|
||
select * from mh_db.dbo.T_FM_USER_C_C_EDIT_H_COL
|
||
|
||
|
||
|
||
|
||
--//列表
|
||
insert into T_PF_PAGE_TABLE
|
||
select * from mh_db.dbo.T_PF_PAGE_TABLE
|
||
|
||
insert into T_FM_USER_CUSTOM_CONFIG_H_TAB
|
||
select * from mh_db.dbo.T_FM_USER_CUSTOM_CONFIG_H_TAB
|
||
|
||
|
||
|
||
|
||
insert into T_FM_USER_CUSTOM_CONFIG_H_COL
|
||
select * from mh_db.dbo.T_FM_USER_CUSTOM_CONFIG_H_COL
|
||
|
||
insert into T_FM_USER_C_C_QUERY
|
||
select * from mh_db.dbo.T_FM_USER_C_C_QUERY
|
||
|
||
|
||
insert into T_FM_USER_C_C_QUERY_FIELD
|
||
select * from mh_db.dbo.T_FM_USER_C_C_QUERY_FIELD
|
||
|
||
insert into T_FM_USER_C_C_EDIT_H_COL
|
||
select * from mh_db.dbo.T_FM_USER_C_C_EDIT_H_COL
|
||
|
||
insert into T_PF_EDIT_COLUMN_FILTER
|
||
select * from mh_db.dbo.T_PF_EDIT_COLUMN_FILTER
|
||
|
||
|
||
|
||
|
||
|
||
----//列表
|
||
--insert into T_PF_PAGE_TABLE
|
||
--select * from mh_db.dbo.T_PF_PAGE_TABLE
|
||
|
||
--insert into T_FM_USER_CUSTOM_CONFIG_H_TAB
|
||
--select * from mh_db.dbo.T_FM_USER_CUSTOM_CONFIG_H_TAB
|
||
|
||
insert into T_PF_TABLE_PARAMS
|
||
select * from mh_db.dbo.T_PF_TABLE_PARAMS
|
||
|
||
--insert into T_FM_USER_C_C_TABLE
|
||
--select * from mh_db.dbo.T_FM_USER_C_C_TABLE
|
||
|
||
insert into T_PF_COLUMN
|
||
select * from mh_db.dbo.T_PF_COLUMN
|
||
|
||
|
||
|
||
--列表页查询
|
||
insert into T_PF_FORM_QUERY
|
||
select * from mh_db.dbo.T_PF_FORM_QUERY
|
||
|
||
insert into T_PF_QUERY
|
||
select * from mh_db.dbo.T_PF_QUERY
|
||
|
||
--菜单
|
||
insert into T_PF_BTN
|
||
select * from mh_db.dbo.T_PF_BTN
|
||
|
||
insert into T_PF_MENU
|
||
select * from mh_db.dbo.T_PF_MENU order by MENU_FORM_ID,IS_LEAF
|
||
|
||
--权限按钮
|
||
insert into T_FM_ROLE --(具体分析是否重复 修改对应人员关联角色)
|
||
select * from mh_db.dbo.T_FM_ROLE where ID not in(select ID from T_FM_ROLE)
|
||
|
||
insert into T_FM_ROLE_MENU_PERM
|
||
select * from mh_db.dbo.T_FM_ROLE_MENU_PERM
|
||
|
||
insert into T_FM_ROLE_MENU_PERM_BTN
|
||
select * from mh_db.dbo.T_FM_ROLE_MENU_PERM_BTN
|
||
|
||
--OrgId更新
|
||
select top 1 ORG_ID from T_FM_USER
|
||
|
||
--权限按钮
|
||
update T_FM_ROLE_MENU_PERM set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_ROLE set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_ROLE_MENU_PERM_BTN set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
--菜单
|
||
update T_PF_MENU set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_BTN set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
|
||
--列表页查询
|
||
update T_PF_QUERY set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_FORM_QUERY set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
|
||
--//列表
|
||
update T_PF_COLUMN set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_C_C_TABLE set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_TABLE_PARAMS set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_CUSTOM_CONFIG_H_TAB set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_PAGE_TABLE set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
|
||
--编辑
|
||
update T_PF_EDIT_COLUMN_FILTER set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_EDIT_COLUMN_FILL_MAP_D set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_EDIT_COLUMN_FILL_MAP set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_C_C_EDIT_H_COL set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_EDIT_COLUMN set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
--编辑 填充区域
|
||
update T_PF_PAGE_EDIT_PANEL set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_C_C_EDIT set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_PAGE_EDIT set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
|
||
--表单
|
||
update T_PF_PAGE_CUSTOM set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_TREE_COLUMN set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_PAGE_TREE set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_SYS_LOG set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_C_C_QUERY_FIELD set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_C_C_QUERY set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_FORM set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
|
||
|
||
--不懂是啥 反正插入了就 修改
|
||
update T_FM_USER_C_C_EDIT_H_COL set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_C_C_EDIT set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_CUSTOM_CONFIG_H_COL set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_CUSTOM_CONFIG_H_TAB set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_C_C_QUERY_FIELD set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_C_C_QUERY set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_FM_USER_CUSTOM_CONFIG set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_FLOW_SCHEME set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_PAGE_CHART set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_PAGE_CHART_PARAM set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_FLOW_INSTANCE set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_FLOW_INSTANCE_OPER_HIS set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
update T_PF_FLOW_INSTANCE_TRANS_HIS set ORG_ID ='3EFD5276-632B-E379-9FF3-7A7546591FCA'
|
||
|
||
|
||
--最后执行语句
|
||
delete T_FM_ORGANIZATION where ID='B043B28B-BBC3-C452-6052-4FBA1457ABFA'
|
||
|