xiaochen
/
water


			
				
					
						
						
							12345678910111213141516171819202122232425262728
							-- User and fund management menus. Safe to run repeatedly.
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT 0, CONVERT(0xE794A8E688B7E7AEA1E79086 USING utf8mb4), 'UserManagement', NULL, 1, '/user-management', NULL, NULL, 'ri:group-line', 85, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE `path` = '/user-management' AND `delete_time` IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/user-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE794A8E688B7E58897E8A1A8 USING utf8mb4), 'UserList', NULL, 2, 'user-list', '/user-management/user-list', NULL, 'ri:list-check-2', 100, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/user-management/user-list' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/user-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE794A8E688B7E68A95E8AF89 USING utf8mb4), 'UserComplaints', NULL, 2, 'complaints', '/user-management/complaints', NULL, 'ri:chat-1-line', 90, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/user-management/complaints' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/user-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE794A8E688B7E58F8DE9A688 USING utf8mb4), 'UserFeedback', NULL, 2, 'feedback', '/user-management/feedback', NULL, 'ri:message-2-line', 80, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/user-management/feedback' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/user-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE794A8E688B7E794BBE5838F USING utf8mb4), 'UserAvatars', NULL, 2, 'avatars', '/user-management/avatars', NULL, 'ri:profile-line', 70, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/user-management/avatars' AND delete_time IS NULL);

INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT 0, CONVERT(0xE8B584E98791E7AEA1E79086 USING utf8mb4), 'FundManagement', NULL, 1, '/fund-management', NULL, NULL, 'ri:money-cny-circle-line', 84, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE `path` = '/fund-management' AND `delete_time` IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/fund-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE4BBA3E79086E68F90E78EB0 USING utf8mb4), 'AgentWithdrawal', NULL, 2, 'agent-withdrawal', '/fund-management/agent-withdrawal', NULL, 'ri:bank-card-line', 100, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/fund-management/agent-withdrawal' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/fund-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE59586E688B7E68F90E78EB0 USING utf8mb4), 'MerchantWithdrawal', NULL, 2, 'merchant-withdrawal', '/fund-management/merchant-withdrawal', NULL, 'ri:bank-card-line', 90, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/fund-management/merchant-withdrawal' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/fund-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE794A8E688B7E68F90E78EB0 USING utf8mb4), 'UserWithdrawal', NULL, 2, 'user-withdrawal', '/fund-management/user-withdrawal', NULL, 'ri:bank-card-line', 80, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/fund-management/user-withdrawal' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/fund-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE585A5E59CBAE8B4B9E8AEB0E5BD95 USING utf8mb4), 'EntryRecords', NULL, 2, 'entry-records', '/fund-management/entry-records', NULL, 'ri:file-list-3-line', 70, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/fund-management/entry-records' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/fund-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE58585E580BCE8AEB0E5BD95 USING utf8mb4), 'RechargeRecords', NULL, 2, 'recharge-records', '/fund-management/recharge-records', NULL, 'ri:money-cny-box-line', 60, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/fund-management/recharge-records' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/fund-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE98080E68ABCE7AEA1E79086 USING utf8mb4), 'RefundManagement', NULL, 2, 'refund-management', '/fund-management/refund-management', NULL, 'ri:refund-2-line', 50, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/fund-management/refund-management' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/fund-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE4BC9AE59198E5BC80E9809AE8AEB0E5BD95 USING utf8mb4), 'MemberActivationRecords', NULL, 2, 'member-activation-records', '/fund-management/member-activation-records', NULL, 'ri:vip-crown-line', 40, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/fund-management/member-activation-records' AND delete_time IS NULL);