-- product_sys_cache_config
ALTER TABLE product_sys_cache_config add pagesize int(20) DEFAULT null comment '每页记录数';
INSERT INTO `product_sys_datamodel_field` (`field_id`, `uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES (4990, '2a9335b8-c213-4a65-9be5-017d3c695102', 'product_sys_cache_config', 'pagesize', '每页记录数', 'int', 20, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '每页记录数');
-- product_sys_timed_task
ALTER TABLE product_sys_timed_task add open_transaction int(4) default null  comment '开启事务 0 否 1 是';
INSERT INTO `product_sys_datamodel_field` (`uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES ( '8318de86-e725-4ae8-8e82-be9cf0f84a65', 'product_sys_timed_task', 'open_transaction', '开启事务 0 否 1 是', 'int', 4, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 1, '2022-11-26 17:05:02', 1, '2022-11-26 17:01:10', NULL, '开启事务 ');


update `product_sys_functions` set client_type_uuid='Web';

update `product_sys_function_buttons` set client_type_uuid ='Web';


ALTER TABLE `product_sys_portals_sub` 	MODIFY	`portal_uuid`	varchar	(80)		DEFAULT	NULL		COMMENT	 '关联主表（门户表uuid）'		,	ADD	`x`	int	(4)		DEFAULT	NULL		COMMENT	 'x'		,	ADD	`y`	int	(4)		DEFAULT	NULL		COMMENT	 'y'		,	ADD	`h`	int	(4)		DEFAULT	NULL		COMMENT	 'h'		,	ADD	`w`	int	(4)		DEFAULT	NULL		COMMENT	 'w';

INSERT INTO `product_sys_datamodel_field` ( `uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES ( '83080de2-7750-412c-b320-e59e2615eda3', 'product_sys_portals_sub', 'x', 'x', 'int', 4, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, '2023-03-23 16:58:37', NULL, 'x');
INSERT INTO `product_sys_datamodel_field` ( `uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES ( 'fa291363-bd3f-4714-af51-91db380bbf01', 'product_sys_portals_sub', 'y', 'y', 'int', 4, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, '2023-03-23 16:58:37', NULL, 'y');
INSERT INTO `product_sys_datamodel_field` ( `uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES ( '59787e88-b3d9-4b70-b8b1-c8d68ab07ddb', 'product_sys_portals_sub', 'h', 'h', 'int', 4, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, '2023-03-23 16:58:37', NULL, 'h');
INSERT INTO `product_sys_datamodel_field` ( `uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES ( '09e2a757-6049-4064-8575-f54ed6f0bdaa', 'product_sys_portals_sub', 'w', 'w', 'int', 4, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 1, NULL, NULL, '2023-03-23 16:58:37', NULL, 'w');




ALTER TABLE product_sys_pages add icon VARCHAR(30) default null comment '图标',add color VARCHAR(40) default null comment '颜色',add column_type VARCHAR(20) default null comment '栏目类型';


INSERT INTO `product_sys_datamodel_field` (`uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES ( 'c9eac1ca-4702-4f0a-8aa8-42519410ff83', 'product_sys_pages', 'color', '颜色', 'string', 40, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '颜色');
INSERT INTO `product_sys_datamodel_field` ( `uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES ('e4e6ec73-37ec-446b-be35-dabe639c731a', 'product_sys_pages', 'icon', '图标', 'string', 30, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '图标');
INSERT INTO `product_sys_datamodel_field` (`uuid`, `table_uuid`, `field_name`, `field_description`, `field_type`, `field_length`, `field_unit`, `is_required`, `is_unique`, `is_international`, `is_filter`, `field_format`, `related_table`, `field_relation_table`, `created_by`, `updated_utc_datetime`, `updated_by`, `created_utc_datetime`, `field_reference`, `field_show_name`) VALUES ( '34e787d3-a17b-4870-b0da-281f6d2a0de9', 'product_sys_pages', 'column_type', '栏目类型', 'string', 20, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '栏目类型');



delete FROM product_sys_link where function_uuid in ('0792396e-813e-4f78-80fb-b7dfbdd12813','d3cc9383-f370-4b48-8b9b-f28c765fdf76');

INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( '6b8aec73-a611-4e1d-87af-d8501e5e9fb4', 0, '0792396e-813e-4f78-80fb-b7dfbdd12813', 'd20c1b78-8be1-4495-b47b-b6ecd6b111b9', 0, '6d163d15-e380-4714-b940-17934dc046e5', 2, '2021-05-20 16:11:39', 1, '2023-03-02 15:09:33', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( '0c5e82ba-4274-4ea2-bf8a-4658803fc0d2', 0, '0792396e-813e-4f78-80fb-b7dfbdd12813', '6d163d15-e380-4714-b940-17934dc046e5', 2, '7053aa07-ff8c-4131-85d6-2148d5715f42', 1, '2021-05-20 16:11:39', 1, '2023-03-02 15:09:33', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( 'cae72858-e3fa-421a-9a23-ea9cff9cb38b', 0, '0792396e-813e-4f78-80fb-b7dfbdd12813', '6d163d15-e380-4714-b940-17934dc046e5', 2, '626cca3d-c1eb-4f3b-a918-cc8cfb8a556b', 1, '2021-05-20 16:11:39', 1, '2023-03-02 15:09:33', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( '83589227-550d-4c2d-89a5-9ab6b78de066', 0, '0792396e-813e-4f78-80fb-b7dfbdd12813', '6d163d15-e380-4714-b940-17934dc046e5', 2, 'ae10907e-a698-4ffb-af69-3836320b6d40', 1, '2021-05-20 16:11:39', 1, '2023-03-02 15:09:33', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( 'a300b88d-b264-4e31-972e-3e89d29a04dd', 0, '0792396e-813e-4f78-80fb-b7dfbdd12813', '6d163d15-e380-4714-b940-17934dc046e5', 2, '7d7de611-3e5e-4399-9d8a-39d3a03883b4', 1, '2021-05-20 16:11:39', 1, '2023-03-02 15:09:33', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( '371aa035-5100-4500-9e42-db5cc0026040', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'b95baa44-8cea-4228-8108-51886492d0bb', 0, 'ab6f61e5-695b-4475-b5a9-10cc6e0ec1a1', 2, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( '586b4c53-1b84-42c7-abf2-f47114400903', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'ab6f61e5-695b-4475-b5a9-10cc6e0ec1a1', 2, '244f7d2c-9108-4c14-956e-53fc626764e8', 1, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( 'e05ad050-e843-41cd-8769-dbfdf899289d', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', '1ed56922-2352-44ad-a2aa-851e2057afcc', 1, 'b95baa44-8cea-4228-8108-51886492d0bb', 0, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( 'e88e1c98-79d0-4730-b61b-2351a2894590', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', '69b6fe13-6ce5-4ed9-836b-90cd5e64b87f', 1, 'b95baa44-8cea-4228-8108-51886492d0bb', 0, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( '5f9823b9-8e5a-4aa1-8f08-dc839c1bce28', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'ab6f61e5-695b-4475-b5a9-10cc6e0ec1a1', 2, '96f9f2c1-ec0f-433c-af38-78ef7c861149', 1, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( 'e11a221e-3ff0-403f-aa12-d2dac0d5d1eb', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', '96f9f2c1-ec0f-433c-af38-78ef7c861149', 1, 'b5f04483-828e-4e39-9ce9-a553f2c94228', 2, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( 'f5863135-ccdb-40cd-bb49-21ddb766d3e1', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'b5f04483-828e-4e39-9ce9-a553f2c94228', 2, '69b6fe13-6ce5-4ed9-836b-90cd5e64b87f', 1, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( '3e4d2191-69aa-43cd-96a5-f27bad7f0473', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'b5f04483-828e-4e39-9ce9-a553f2c94228', 2, '1ed56922-2352-44ad-a2aa-851e2057afcc', 1, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( 'c52bee82-0b0b-4b2b-9193-24e642e5322b', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', '8c00edbf-e6ba-43a0-ba55-fcc4e9ff10b9', 1, 'e49dce5c-0c30-4c8f-a777-3f42cd7261f6', 2, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( 'ceb9e169-d540-4b36-8ec1-8f1ff84cf931', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'e49dce5c-0c30-4c8f-a777-3f42cd7261f6', 2, '69b6fe13-6ce5-4ed9-836b-90cd5e64b87f', 1, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);
INSERT INTO `product_sys_link` ( `uuid`, `link_type`, `function_uuid`, `line_from`, `from_type`, `line_to`, `to_type`, `created_utc_datetime`, `created_by`, `updated_utc_datetime`, `updated_by`, `terminal_type`) VALUES ( '127fc77e-966c-4a57-bd4c-59698d7d5062', 0, 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'e49dce5c-0c30-4c8f-a777-3f42cd7261f6', 2, '1ed56922-2352-44ad-a2aa-851e2057afcc', 1, '2021-05-17 15:20:31', 1, '2023-03-06 10:47:02', 1, 1);




delete FROM product_sys_mvc_page where function_uuid in ('0792396e-813e-4f78-80fb-b7dfbdd12813','d3cc9383-f370-4b48-8b9b-f28c765fdf76');

INSERT INTO `product_sys_mvc_page` ( `uuid`, `function_uuid`, `page_name`, `page_url`, `page_uuid`, `page_element_disabled`, `import_js`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `top_location`, `left_location`, `flow_uuid`, `from_param_key`, `tree_data`, `tree_data_type`, `page_type`, `flow_title`, `face_uuid`, `page_open_with`, `terminal_type`) VALUES ( '6d163d15-e380-4714-b940-17934dc046e5', '0792396e-813e-4f78-80fb-b7dfbdd12813', '菜单列表', 'system/menu/index', '', 0, '', 1, '2021-03-10 10:40:28', 1, '2023-03-02 15:09:33', '172px', '115px', '', '', '', NULL, 1, '', NULL, 0, 1);
INSERT INTO `product_sys_mvc_page` ( `uuid`, `function_uuid`, `page_name`, `page_url`, `page_uuid`, `page_element_disabled`, `import_js`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `top_location`, `left_location`, `flow_uuid`, `from_param_key`, `tree_data`, `tree_data_type`, `page_type`, `flow_title`, `face_uuid`, `page_open_with`, `terminal_type`) VALUES ( 'ab6f61e5-695b-4475-b5a9-10cc6e0ec1a1', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', '模块功能列表', 'system/moduleFunction/index', '', 0, '', 1, '2021-03-10 10:56:54', 1, '2023-03-06 10:47:02', '103px', '0px', '', '', '', NULL, 1, '', NULL, 0, 1);
INSERT INTO `product_sys_mvc_page` ( `uuid`, `function_uuid`, `page_name`, `page_url`, `page_uuid`, `page_element_disabled`, `import_js`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `top_location`, `left_location`, `flow_uuid`, `from_param_key`, `tree_data`, `tree_data_type`, `page_type`, `flow_title`, `face_uuid`, `page_open_with`, `terminal_type`) VALUES ( 'b5f04483-828e-4e39-9ce9-a553f2c94228', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', '功能修改页面', 'tool/ef/mvc', '', 0, '', 138, '2021-03-23 01:43:57', 1, '2023-03-06 10:47:02', '68px', '355px', '', '', '', NULL, 0, '', NULL, 0, 1);
INSERT INTO `product_sys_mvc_page` ( `uuid`, `function_uuid`, `page_name`, `page_url`, `page_uuid`, `page_element_disabled`, `import_js`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `top_location`, `left_location`, `flow_uuid`, `from_param_key`, `tree_data`, `tree_data_type`, `page_type`, `flow_title`, `face_uuid`, `page_open_with`, `terminal_type`) VALUES ( 'e49dce5c-0c30-4c8f-a777-3f42cd7261f6', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', '功能新增页面', 'tool/ef/mvc', '', 0, '', 138, '2021-03-23 01:46:42', 1, '2023-03-06 10:47:02', '273px', '598px', '', '', '', NULL, 0, '', NULL, 0, 1);


DELETE FROM product_sys_function_buttons where function_uuid in ('0792396e-813e-4f78-80fb-b7dfbdd12813','d3cc9383-f370-4b48-8b9b-f28c765fdf76');

INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '626cca3d-c1eb-4f3b-a918-cc8cfb8a556b', '0792396e-813e-4f78-80fb-b7dfbdd12813', 'add_menu', '新增', '', 2, 'checkbox', '', '', 2, '1', '', 1, NULL, '', 'add', 'Web', '', '298px', '354px', 'addMenu', '', '0', '162149829870228d7PV5644', NULL, 0, NULL, NULL, NULL, NULL, 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '7053aa07-ff8c-4131-85d6-2148d5715f42', '0792396e-813e-4f78-80fb-b7dfbdd12813', 'delete', '删除', '', 2, 'el-icon-delete', 'uuid', '', 2, '1', '', 4, NULL, '', 'delete', 'Web', '', '329px', '100px', 'deleteMenu', '', '0', '1621498298712598VdBK459', NULL, 1, NULL, '#ff0000', NULL, NULL, 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '7d7de611-3e5e-4399-9d8a-39d3a03883b4', '0792396e-813e-4f78-80fb-b7dfbdd12813', 'update', '修改', '', 2, 'el-icon-edit', 'uuid', '', 2, '1', '', 2, NULL, '', 'update', 'Web', '', '214px', '350px', 'updateMenu', '', '0', '162149829871836Zq2R0210', NULL, 0, NULL, '#66bae5', NULL, NULL, 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( 'ae10907e-a698-4ffb-af69-3836320b6d40', '0792396e-813e-4f78-80fb-b7dfbdd12813', 'view', '查看', '', 2, 'el-icon-view', 'uuid', '', 2, '1', '', 3, NULL, '', 'view', 'Web', '', '106px', '353px', 'viewDetail', '', '0', '162149829873021ZH09I133', NULL, 0, NULL, '#6282e7', NULL, NULL, 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( 'd20c1b78-8be1-4495-b47b-b6ecd6b111b9', '0792396e-813e-4f78-80fb-b7dfbdd12813', '入口', '入口', '', 1, '', '', '', 1, '1', '', NULL, NULL, '', 'main', 'Web', '', '49px', '0px', '', '/api/system/menu/list-menu', '', '162149829873268tJ1i0666', NULL, 0, NULL, NULL, NULL, NULL, 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '8c00edbf-e6ba-43a0-ba55-fcc4e9ff10b9', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'add_function', '新增功能', '', 2, 'button', '', '', 2, '1', '', 1, NULL, '', 'add', 'Web', '', '275px', '352px', '', '', '0', '162123602873439K9zl1160', NULL, 0, NULL, NULL, NULL, 'tricode_parent', 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '244f7d2c-9108-4c14-956e-53fc626764e8', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'delete', '删除', '', 2, 'el-icon-delete', 'uuid', '', 2, '1', '', 10, NULL, '', 'delete', 'Web', '', '253px', '0px', 'handleDelete', '', '0', '1621236028835365tvQ7254', NULL, 1, NULL, '#ff0000', NULL, NULL, 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( 'b95baa44-8cea-4228-8108-51886492d0bb', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'main', '入口', '', 1, '', '', '', 1, '1', '', NULL, NULL, '', 'main', 'Web', '', '28px', '33px', '', '/api/modules/list-module', '', '162123602888636OK223705', NULL, 0, NULL, NULL, NULL, NULL, 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '1ed56922-2352-44ad-a2aa-851e2057afcc', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'return', '返回', '', 2, 'button', '', '', 2, '1', '', 4, NULL, '', 'back', 'Web', '', '2px', '814px', '', '', '0', '1621236028980182DkhY617', NULL, 0, NULL, NULL, NULL, 'tricode_parent', 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '69b6fe13-6ce5-4ed9-836b-90cd5e64b87f', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'save_func', '保存', '', 2, 'checkbox', '', '', 2, '1', '', 1, NULL, '', 'save', 'Web', '', '148px', '526px', 'save', '', '0', '162123602900896TMHDG406', NULL, 0, NULL, NULL, NULL, 'tricode_parent', 1);
INSERT INTO `product_sys_function_buttons` (`uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '96f9f2c1-ec0f-433c-af38-78ef7c861149', 'd3cc9383-f370-4b48-8b9b-f28c765fdf76', 'update_func', '修改功能', '', 2, 'el-icon-edit', 'uuid', '', 2, '1', '', 4, NULL, '', 'update', 'Web', '', '208px', '356px', '', '', '0', '16212360291428144uSZ321', NULL, 0, NULL, '#66bae5', NULL, 'tricode_parent', 1);

-- 不需要的视图
DELETE FROM product_sys_datamodel_table where table_name='product_sys_button_link_v';

delete from product_sys_datamodel_field where table_uuid='product_sys_button_link_v';

drop view if exists product_sys_button_link_v;

-- 门户
truncate table `product_sys_portals_sub`;

INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2117, '4ee0e65d-9fdf-4d25-932e-0df660837168', '00000000-0000-0000-0000-000000000000', '910155fc-c44e-4f30-b2df-45de8d3b4863', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2, 5);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2118, '9dfc3f64-5b95-49e1-a0f7-7fa7bd304ebc', '00000000-0000-0000-0000-000000000000', '740e682a-1268-402b-9c3c-03dde0b14a8f', NULL, NULL, NULL, NULL, NULL, NULL, 5, 0, 2, 5);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2119, '0f000211-f74c-44bd-a0fa-48ab1ab37fb0', '00000000-0000-0000-0000-000000000000', 'ca8a5419-22aa-41ca-8f4b-59b4ae68b2d4', NULL, NULL, NULL, NULL, NULL, NULL, 10, 0, 2, 5);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2120, 'bd597b01-fe30-4cc2-a55d-3d4f41cb3a13', '00000000-0000-0000-0000-000000000000', 'b1e18ff5-4aac-453f-b9cb-1320c372221e', NULL, NULL, NULL, NULL, NULL, NULL, 15, 0, 8, 9);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2121, 'ebb1a1b3-fbca-4c72-b41e-c0e4ba07715d', '00000000-0000-0000-0000-000000000000', 'ac87aca0-73a8-4151-8ce5-1e2f5e22b2b3', NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 6, 15);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2122, 'bfa1e24e-b7fb-4bf8-9229-23ed8f2e72fd', '00000000-0000-0000-0000-000000000000', '27f578f8-ccba-4fe3-913d-317911cc9c04', NULL, NULL, NULL, NULL, NULL, NULL, 0, 8, 6, 24);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2123, '6ba98e44-c585-4124-9b6a-d6f8656b2d2f', '8f3a1106-b0be-407a-a047-914ac455aa6b', '740e682a-1268-402b-9c3c-03dde0b14a8f', NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, 4, 6);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2124, '1c2bcdd6-0f13-4c46-b3e5-87a31fdb122c', '8f3a1106-b0be-407a-a047-914ac455aa6b', 'ca8a5419-22aa-41ca-8f4b-59b4ae68b2d4', NULL, NULL, NULL, NULL, NULL, NULL, 11, 0, 4, 6);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2125, '77a84547-bd83-464b-9c74-e6f48f04d4fb', '8f3a1106-b0be-407a-a047-914ac455aa6b', 'a5d94845-e63c-4835-b501-a9af00de8ee0', NULL, NULL, NULL, NULL, NULL, NULL, 2, 4, 4, 6);
INSERT INTO `product_sys_portals_sub` (`id`, `uuid`, `portal_uuid`, `page_uuid`, `org_level_uuid`, `portal_person`, `page_left_top_X`, `page_left_top_Y`, `page_right_botton_X`, `page_right_botton_Y`, `x`, `y`, `h`, `w`) VALUES (2126, '6ab31ce9-5240-4ed1-8732-d7bc943cfbf8', '8f3a1106-b0be-407a-a047-914ac455aa6b', '740e682a-1268-402b-9c3c-03dde0b14a8f', NULL, NULL, NULL, NULL, NULL, NULL, 11, 4, 4, 6);


