QuickCalculation/user_pay1.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 本地mysql8.0 root 123456
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3307
 Source Schema         : user_pay

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 11/06/2024 21:45:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_video_user
-- ----------------------------
DROP TABLE IF EXISTS `t_video_user`;
CREATE TABLE `t_video_user`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `video_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `video_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_video_user
-- ----------------------------
INSERT INTO `t_video_user` VALUES ('17105270031232', '超级心算速算技巧赏析', '/file/7320e0a7bf8847a7a1c54accd12d37a1.png', '/file/a016266b86504057a5fb4acecf4bb4b8.mp4', '/file/491511a9887e4af686d1b35a9a81ee3b.png', '<p>1，位数为5相同两位数相乘公式：15×15＝225。</p><p>2，任意数x9的公式：4×9＝36。</p><p>3，任意两位数x11的公式：25×11＝2（2+5）5＝275</p>', '2024-03-18 21:46:11', '2024-03-16 02:23:23');
INSERT INTO `t_video_user` VALUES ('17105270034412', '超级心算速算技巧赏析', '/file/7320e0a7bf8847a7a1c54accd12d37a1.png', '/file/a016266b86504057a5fb4acecf4bb4b8.mp4', '/file/491511a9887e4af686d1b35a9a81ee3b.png', '<p>1，位数为5相同两位数相乘公式：15×15＝225。</p><p>2，任意数x9的公式：4×9＝36。</p><p>3，任意两位数x11的公式：25×11＝2（2+5）5＝275</p>', '2024-03-18 21:46:11', '2024-03-16 02:23:23');
INSERT INTO `t_video_user` VALUES ('17105270034422', '超级心算速算技巧赏析', '/file/7320e0a7bf8847a7a1c54accd12d37a1.png', '/file/a016266b86504057a5fb4acecf4bb4b8.mp4', '/file/491511a9887e4af686d1b35a9a81ee3b.png', '<p>1，位数为5相同两位数相乘公式：15×15＝225。</p><p>2，任意数x9的公式：4×9＝36。</p><p>3，任意两位数x11的公式：25×11＝2（2+5）5＝275</p>', '2024-03-18 21:46:11', '2024-03-16 02:23:23');
INSERT INTO `t_video_user` VALUES ('17105270034432', '超级心算速算技巧赏析', '/file/7320e0a7bf8847a7a1c54accd12d37a1.png', '/file/a016266b86504057a5fb4acecf4bb4b8.mp4', '/file/491511a9887e4af686d1b35a9a81ee3b.png', '<p>1，位数为5相同两位数相乘公式：15×15＝225。</p><p>2，任意数x9的公式：4×9＝36。</p><p>3，任意两位数x11的公式：25×11＝2（2+5）5＝275</p>', '2024-03-18 21:46:11', '2024-03-16 02:23:23');

-- ----------------------------
-- Table structure for t_vip_order
-- ----------------------------
DROP TABLE IF EXISTS `t_vip_order`;
CREATE TABLE `t_vip_order`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `out_trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_goods_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_vip_order
-- ----------------------------
INSERT INTO `t_vip_order` VALUES ('2403062318468827444', '2403062318465208032', '2403062212500022417', '1', '2024-03-06 23:18:47', '2024-03-06 23:18:47');
INSERT INTO `t_vip_order` VALUES ('2403062334444878704', '2403062334441174914', '2403062212500022417', '1', '2024-03-06 23:34:44', '2024-03-06 23:34:44');
INSERT INTO `t_vip_order` VALUES ('2403062337542688627', '2403062337539775040', '2403062212500022417', '1', '2024-03-06 23:37:54', '2024-03-06 23:37:54');
INSERT INTO `t_vip_order` VALUES ('2403071004431486782', '2403071004428194603', '2403062212500022417', '1', '2024-03-07 10:04:43', '2024-03-07 10:04:43');
INSERT INTO `t_vip_order` VALUES ('2403071004558943664', '2403071004555909353', '2403062212500022417', '1', '2024-03-07 10:04:56', '2024-03-07 10:04:56');
INSERT INTO `t_vip_order` VALUES ('2403080159196688797', '2403080159193081105', '2403072209532198692', '1', '2024-03-08 01:59:20', '2024-03-08 01:59:20');
INSERT INTO `t_vip_order` VALUES ('2403091939207388311', '2403091939203815817', '2403072209532198692', '1', '2024-03-09 19:39:21', '2024-03-09 19:39:21');
INSERT INTO `t_vip_order` VALUES ('2403091939222563793', '2403091939219468783', '2403072209532198692', '1', '2024-03-09 19:39:22', '2024-03-09 19:39:22');
INSERT INTO `t_vip_order` VALUES ('2403101258423106225', '2403101258419943379', '2403072216273720351', '1', '2024-03-10 12:58:42', '2024-03-10 12:58:42');
INSERT INTO `t_vip_order` VALUES ('2403101358437006163', '2403101358433845474', '2403072209532198692', '1', '2024-03-10 13:58:44', '2024-03-10 13:58:44');
INSERT INTO `t_vip_order` VALUES ('2403101528557881854', '2403101528554455720', '2403101459300689099', '1', '2024-03-10 15:28:56', '2024-03-10 15:28:56');

-- ----------------------------
-- Table structure for t_vpi_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_vpi_goods`;
CREATE TABLE `t_vpi_goods`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pay_mode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `privilege` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_money` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_vpi_goods
-- ----------------------------
INSERT INTO `t_vpi_goods` VALUES ('2403072209532198692', '一天', '1', '1，享有一天无限制出题<br>2，免费观看所有教学视频', '24', '5', '2024-03-07 22:09:53', '2024-03-09 18:59:07');
INSERT INTO `t_vpi_goods` VALUES ('2403072211527969952', '一个月', '1', '1，享有一月无限制出题<br>2，免费观看所有教学视频', '30', '10', '2024-03-07 22:11:53', '2024-03-09 18:59:03');
INSERT INTO `t_vpi_goods` VALUES ('2403072216273720351', '一年', '1', '1，享有一年无限制出题<br>2，免费观看所有教学视频', '365', '120', '2024-03-07 22:16:27', '2024-03-09 18:58:58');
INSERT INTO `t_vpi_goods` VALUES ('2403101459300689099', 'test', '1', '测试', '24', '0.01', '2024-03-10 14:59:30', '2024-03-10 14:59:30');

-- ----------------------------
-- Table structure for t_vpi_user
-- ----------------------------
DROP TABLE IF EXISTS `t_vpi_user`;
CREATE TABLE `t_vpi_user`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_goods_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_start_date` date NULL DEFAULT NULL,
  `vip_end_date` date NULL DEFAULT NULL,
  `vip_residue_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_vpi_user
-- ----------------------------
INSERT INTO `t_vpi_user` VALUES ('2403062328040220795', '1', '2403062212500022417', '2024-03-06', '2024-04-05', NULL, '2024-03-06 23:28:04', '2024-03-06 23:28:04');
INSERT INTO `t_vpi_user` VALUES ('2403062329248817807', '1', '2403062212500022417', '2024-03-06', '2024-05-05', NULL, '2024-03-06 23:29:25', '2024-03-06 23:29:25');
INSERT INTO `t_vpi_user` VALUES ('2403062335019967508', '2403062312446437443', '2403062212500022417', '2024-03-06', '2024-04-05', NULL, '2024-03-06 23:35:02', '2024-03-06 23:35:02');
INSERT INTO `t_vpi_user` VALUES ('2403062338065923996', '2403062312446437443', '2403062212500022417', '2024-03-06', '2024-05-05', NULL, '2024-03-06 23:38:07', '2024-03-06 23:38:07');
INSERT INTO `t_vpi_user` VALUES ('2403071004522693550', '2403062312446437443', '2403062212500022417', '2024-03-06', '2024-06-04', NULL, '2024-03-07 10:04:52', '2024-03-07 10:04:52');
INSERT INTO `t_vpi_user` VALUES ('2403101529048050386', '2403101118291199130', '2403101459300689099', '2024-03-10', '2024-04-03', NULL, '2024-03-10 15:29:05', '2024-03-10 15:29:05');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `open_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信小程序的openid值',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户类型 1：管理员 2：微信用户',
  `logo_path` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图像路径',
  `account_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `enable` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否启用 true:是 false 否',
  `gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别 1:男 2:女',
  `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地区',
  `birthday` date NULL DEFAULT NULL COMMENT '生日',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_vip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_residue_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip_end_date` date NULL DEFAULT NULL,
  `nation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', '123456', '1', NULL, 'admin', '123123', '123456', '18289387963', '1', '1', '海南海口', '2023-12-16', '2023-12-16 11:42:44', '2024-03-25 00:04:21', '1', '60', '2024-05-05', NULL);
INSERT INTO `users` VALUES ('2403092150397864790', '', '2', '/file/96612b97193d40beb2c1161eaf725d4c.jpg', '测试', '哈哈哈哈', NULL, '15208931719', '1', '1', '澳大利亚', '2024-03-09', '2024-03-09 21:50:40', '2024-03-23 21:58:46', NULL, NULL, NULL, NULL);
INSERT INTO `users` VALUES ('2403101118291199130', '', '2', '/file/1c5b34a29c7b45599684a5cb24a7f9a2.png', '111++**-', '发大财神经典镜头都不给姚贝娜际关系好了没有人做了。', NULL, '15017534446', '1', '1', '1111', '2024-03-10', '2024-03-10 11:18:29', '2024-03-10 15:29:05', '1', '24', '2024-04-03', NULL);

SET FOREIGN_KEY_CHECKS = 1;