CREATE TABLE `ht_users_recharge` ( `recharge_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL COMMENT '充值用户UID' , `recharge_sn` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '充值编号' , `price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '充值金额' , `give_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '购买赠送金额' , `recharge_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '充值类型' , `paid` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否充值 1已充值 0未充值' , `pay_time` int(10) DEFAULT '0' COMMENT '充值支付时间' , `refund_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '退款金额' , `created` int(10) NOT NULL DEFAULT '0' , `modified` int(10) NOT NULL DEFAULT '0' , PRIMARY KEY (`recharge_id`) USING BTREE, UNIQUE KEY `order_id` (`recharge_sn`) USING BTREE, KEY `user_id` (`user_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT= '用户充值记录表' ; CREATE TABLE `ht_users_recharge_record` ( `id` smallint(6) NOT NULL, `keys` varchar(12) NOT NULL DEFAULT '' COMMENT 'IOS下单用' , `title` varchar(30) NOT NULL DEFAULT '' COMMENT '标题' , `price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '充值金额' , `give_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '购买赠送金额' , `unit` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '充值货币单位' , `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1启用 2禁用' , `created` int(10) NOT NULL DEFAULT '0' , `modified` int(10) NOT NULL DEFAULT '0' , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT= '用户充值金额表' ; CREATE TABLE `ht_pay_log` ( `pay_id` int(10) NOT NULL AUTO_INCREMENT, `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '用户ID' , `order_sn` varchar(32) DEFAULT NULL COMMENT '订单编号' , `order_amount` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '金额' , `pay_code` tinyint(1) NOT NULL DEFAULT '1' COMMENT '订单支付方式标识' , `pay_name` varchar(64) NOT NULL DEFAULT '' COMMENT '支付方式名称' , `pay_time` int(10) DEFAULT '0' COMMENT '支付时间' , `pay_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付类型: 1-充值' , `trade_no` varchar(32) NOT NULL DEFAULT '' COMMENT '三方单号' , `is_paid` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已经支付:0-未支付 1-已支付' , `created` int(10) NOT NULL DEFAULT '0' , `modified` int(10) NOT NULL DEFAULT '0' , PRIMARY KEY (`pay_id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT= '订单支付日志表' ; CREATE TABLE `ht_users_bill` ( `bill_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户账单id' , `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户uid' , `link_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '关联id' , `pm` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '2 = 支出 1 = 获得' , `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账单标题' , `category` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '明细种类' , `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '明细类型' , `number` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '明细数字' , `balance` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '剩余' , `mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注' , `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间' , `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 = 待确定 1 = 有效 -1 = 无效' , `created` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间' , `modified` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间' , PRIMARY KEY (`bill_id`) USING BTREE, KEY `create_time` (`create_time`) USING BTREE, KEY `type` (`category`,`type`,`link_id`) USING BTREE, KEY `user_id` (`user_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT= '用户余额账单表' ; |