CREATE TABLE `t_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `code` char(16) NOT NULL DEFAULT '' COMMENT '用户编码',
  `amount` decimal(65,4) DEFAULT '0.0000' COMMENT '人民币余额',
  `invoicable_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT '可开票金额',
  `user_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户名',
  `password` char(40) NOT NULL DEFAULT '' COMMENT '登录密码（SHA1( MD5 (明文密码) + 盐值）',
  `salt` varchar(10) NOT NULL DEFAULT '' COMMENT '盐值',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '图像链接',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '用户类型（1：个人用户（默认）2：企业用户）',
  `phone_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号',
  `email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '电子邮箱',
  `description` text COMMENT '个人介绍',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_deleted` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '是否删除（1：是 2：否）',
  `environment` tinyint(4) NOT NULL DEFAULT '1' COMMENT '环境类型（1：国内 2：国际）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uidx_code` (`code`) USING BTREE COMMENT '用户编码全局唯一'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';



INSERT INTO `avata`.`t_users` ( `code`, `amount`, `invoicable_amount`, `user_name`, `password`, `salt`, `icon`, `type`, `phone_number`, `email`, `description`, `updated_at`, `created_at`, `is_deleted`, `environment` ) VALUES	( 'U2a251Q1L1Q6d1p1', 882415.7391, 200.0000, '宇宙第一帅梅', '9c4b3021dcbe8b89ff188916dde4d5b998c60e56', 'AA9moa', 'upload/avatar/1d2a61b5-c7bd-4880-8ccd-5107c977229f.png', 2, '18851177173', 'xuemei@bianjie.ai', '', '2023-10-18 07:10:50', '2022-05-12 04:02:57', 2, 1 );
INSERT INTO `avata`.`t_users` ( `code`, `amount`, `invoicable_amount`, `user_name`, `password`, `salt`, `icon`, `type`, `phone_number`, `email`, `description`, `updated_at`, `created_at`, `is_deleted`, `environment`) VALUES ('s2q211T151P6i1L1', 100.0000, 0.0000, '奥特曼打小怪兽', '9bb872a06401980265aa023a4bbf0262d578f797', 'wNWNyy', 'upload/avatar/17413c25-6ca9-45da-b413-3b4613b8c4e5.jpeg', 2, '12233334444', '7246@ada.cvsaif', '', '2023-03-31 10:02:33', '2022-06-22 03:39:43', 2, 1);
INSERT INTO `avata`.`t_users` ( `code`, `amount`, `invoicable_amount`, `user_name`, `password`, `salt`, `icon`, `type`, `phone_number`, `email`, `description`, `updated_at`, `created_at`, `is_deleted`, `environment`) VALUES ('J2l2R121v1N6B1p1', 342.0000, 13598.4000, '我滴个乖乖啊', '9dc7dce37a51ee626837a2b1d8e907ad4e5f0a7f', 'mR2Eis', '', 1, '18851177177', '126253@dufh.dna', '', '2023-03-31 10:02:42', '2022-09-19 02:08:28', 2, 1);
INSERT INTO `avata`.`t_users` (`code`, `amount`, `invoicable_amount`, `user_name`, `password`, `salt`, `icon`, `type`, `phone_number`, `email`, `description`, `updated_at`, `created_at`, `is_deleted`, `environment`) VALUES ('U2a251Q1L1Q6d1p2', 230231.0000, 0.0000, 'miuyee', '825afc3b91684ab5fe0ea64c7038b71f50f12ff1', 'kwz2he', '', 2, '18851177178', '12334as5@qq.com', '', '2023-04-03 05:39:29', '2022-11-21 03:20:42', 2, 2);
INSERT INTO `avata`.`t_users` (`code`, `amount`, `invoicable_amount`, `user_name`, `password`, `salt`, `icon`, `type`, `phone_number`, `email`, `description`, `updated_at`, `created_at`, `is_deleted`, `environment`) VALUES ( '52O3J0A2Z103i0D6', 42534.0000, 13598.4000, '宇宙第一帅梅', 'cd6e35d6506f5b9cb926cf0cc321b221f090d69c', 'rKSQ9S', '', 1, '18851177173', 'xuemei@bianjie.ai', '', '2023-04-10 06:07:47', '2023-02-13 06:01:45', 2, 2);


