首页 发现 帮助
登录
tea
/
kxmall-main
1
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
分支: master
分支列表 标签列表
kxmall-main
/
doc
/
sql
/
increment
/
20250724kxmall3.sql

20250724kxmall3.sql 6.6 KB
永久链接 文件历史 原始文件

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 
  1. ALTER TABLE `kx_user` 
    2. 

  2. ADD COLUMN `invite_code` varchar(10) NULL COMMENT '邀请码' AFTER `gender`;
    3. 

  3. 

  4. 

  5. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1944765043400839169, '分销管理', 0, 11, 'promoter', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'fenxiao', 'admin', '2025-07-14 22:24:53', 'admin', '2025-07-14 22:24:53', '');
    6. 

  6. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1944765454224527361, '分销配置', 1944765043400839169, 1, 'promoterConfig', 'system/promoter/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-14 22:26:31', 'admin', '2025-07-14 22:26:31', '');
    7. 

  7. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1947443659049816066, '分销记录', 1944765043400839169, 2, 'promoterBill', 'promoter/userBill/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-22 07:48:45', 'admin', '2025-07-22 07:49:34', '');
    8. 

  8. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1947652092055375873, '提现管理', 1944765043400839169, 3, 'promoterUserExtract', 'promoter/userExtract/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-22 21:36:59', 'admin', '2025-07-22 21:37:05', '');
    9. 

  9. 

  10. 

  11. 

  12. DROP TABLE IF EXISTS `kx_user_extract`;
    13. 

  13. CREATE TABLE `kx_user_extract` (
    14. 

  14.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    15. 

  15.   `uid` bigint(20) unsigned DEFAULT NULL,
    16. 

  16.   `real_name` varchar(64) DEFAULT NULL COMMENT '名称',
    17. 

  17.   `extract_type` varchar(32) DEFAULT 'bank' COMMENT 'bank = 银行卡 alipay = 支付宝wx=微信',
    18. 

  18.   `bank_code` varchar(32) DEFAULT '0' COMMENT '银行卡',
    19. 

  19.   `bank_address` varchar(256) DEFAULT '' COMMENT '开户地址',
    20. 

  20.   `alipay_code` varchar(64) DEFAULT '' COMMENT '支付宝账号',
    21. 

  21.   `extract_price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '提现金额',
    22. 

  22.   `mark` varchar(512) DEFAULT NULL,
    23. 

  23.   `balance` decimal(8,2) unsigned DEFAULT '0.00',
    24. 

  24.   `fail_msg` varchar(128) DEFAULT NULL COMMENT '无效原因',
    25. 

  25.   `fail_time` datetime DEFAULT NULL,
    26. 

  26.   `create_time` datetime DEFAULT NULL COMMENT '添加时间',
    27. 

  27.   `update_time` datetime DEFAULT NULL,
    28. 

  28.   `status` tinyint(2) DEFAULT '0' COMMENT '-1 未通过 0 审核中 1 已提现',
    29. 

  29.   `wechat` varchar(15) DEFAULT NULL COMMENT '微信号',
    30. 

  30.   `is_del` tinyint(1) DEFAULT '0',
    31. 

  31.   `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
    32. 

  32.   `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
    33. 

  33.   PRIMARY KEY (`id`) USING BTREE,
    34. 

  34.   KEY `extract_type` (`extract_type`) USING BTREE,
    35. 

  35.   KEY `status` (`status`) USING BTREE,
    36. 

  36.   KEY `add_time` (`create_time`) USING BTREE,
    37. 

  37.   KEY `openid` (`uid`) USING BTREE,
    38. 

  38.   KEY `fail_time` (`fail_time`) USING BTREE
    39. 

  39. ) ENGINE=InnoDB AUTO_INCREMENT=1946954803066183682 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户提现表';
    40. 

  40. 

  41. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948736717477502977, '报表管理', 0, 12, '/report', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'chart', 'admin', '2025-07-25 21:26:54', 'admin', '2025-07-25 21:30:02', '');
    42. 

  42. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948737465342877698, '报表设计器', 1948736717477502977, 1, 'jimu-report', 'report/jmreport', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 21:29:52', 'admin', '2025-07-25 21:53:44', '');
    43. 

  43. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948737802288095233, '大屏设计器', 1948736717477502977, 2, 'jimu-view', 'report/drag', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 21:31:13', 'admin', '2025-07-25 21:53:56', '');
    44. 

  44. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948741975154888706, '销售报表', 1948736717477502977, 3, '/jmreport/view/542152544408129536', 'report/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 21:47:47', 'admin', '2025-07-25 22:18:33', '');
    45. 

  45. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948750395111116801, '报表示例', 1948736717477502977, 4, '/jmreport/view/590812531803901952', 'report/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 22:21:15', 'admin', '2025-07-25 22:21:15', '');
    46. 

  46. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948750774431387650, '大屏示例', 1948736717477502977, 5, '/drag/share/view/1016994272231608320', 'report/newWindow', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 22:22:45', 'admin', '2025-07-25 22:29:14', '');
    47. 

  47. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948751110395138050, '看板示例', 1948736717477502977, 6, '/drag/share/view/910475721247866880', 'report/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 22:24:05', 'admin', '2025-07-25 22:24:05', '');
    48.