/*
Navicat MySQL Data Transfer

Source Server         : 朱超
Source Server Version : 50732
Source Host           : 101.37.174.73:3306
Source Database       : chatgpt

Target Server Type    : MYSQL
Target Server Version : 50732
File Encoding         : 65001

Date: 2023-05-25 20:11:50
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for aichallenge
-- ----------------------------
DROP TABLE IF EXISTS `aichallenge`;
CREATE TABLE `aichallenge` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `question_content` text,
  `roles` varchar(255) DEFAULT NULL,
  `related` int(255) DEFAULT NULL,
  `above_content` text,
  `answers` text,
  `times` datetime DEFAULT NULL,
  `score` varchar(255) DEFAULT NULL,
  `gpt_token` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `dialogue_id` varchar(255) DEFAULT NULL,
  `dialog_order` varchar(255) DEFAULT NULL,
  `conversation_status` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `edited` datetime DEFAULT NULL,
  `editor` varchar(255) DEFAULT NULL,
  `deleted` varchar(255) DEFAULT NULL,
  `gptrole` varchar(255) DEFAULT NULL COMMENT '用户和机器',
  `username` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for dialogue
-- ----------------------------
DROP TABLE IF EXISTS `dialogue`;
CREATE TABLE `dialogue` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `question_content` text,
  `roles` varchar(255) DEFAULT NULL,
  `related` int(255) DEFAULT NULL,
  `above_content` text,
  `answers` text,
  `times` datetime DEFAULT NULL,
  `score` varchar(255) DEFAULT NULL,
  `gpt_token` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `dialogue_id` varchar(255) DEFAULT NULL,
  `dialog_order` varchar(255) DEFAULT NULL,
  `conversation_status` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `edited` datetime DEFAULT NULL,
  `editor` varchar(255) DEFAULT NULL,
  `deleted` varchar(255) DEFAULT NULL,
  `gptrole` varchar(255) DEFAULT NULL COMMENT '用户和机器',
  `username` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for login
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(255) DEFAULT NULL,
  `verification_code` varchar(255) DEFAULT NULL,
  `token` varchar(500) CHARACTER SET utf8mb4 DEFAULT NULL,
  `blacklist` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `visits_number` bigint(20) DEFAULT NULL,
  `registration_time` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `edited` datetime DEFAULT NULL,
  `editor` varchar(255) DEFAULT NULL,
  `deleted` varchar(255) DEFAULT NULL,
  `roles` varchar(255) DEFAULT NULL,
  `mins` int(255) DEFAULT NULL,
  `access_token` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `expires_in` int(11) DEFAULT NULL,
  `refresh_token` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  `scopes` varchar(255) DEFAULT NULL,
  `unionid` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for orderlist
-- ----------------------------
DROP TABLE IF EXISTS `orderlist`;
CREATE TABLE `orderlist` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(255) DEFAULT NULL,
  `merchant_number` varchar(255) DEFAULT NULL,
  `payee` varchar(255) DEFAULT NULL,
  `order_time` datetime DEFAULT NULL,
  `money` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `order_account` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_type` varchar(255) DEFAULT NULL,
  `payment_status` int(11) DEFAULT NULL,
  `refund_amount` varchar(255) DEFAULT NULL,
  `user_terminal_id` varchar(255) DEFAULT NULL,
  `device_number` varchar(255) DEFAULT NULL,
  `preferential_situation` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `edited` datetime DEFAULT NULL,
  `editor` varchar(255) DEFAULT NULL,
  `deleted` varchar(255) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=282 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for questionnaire
-- ----------------------------
DROP TABLE IF EXISTS `questionnaire`;
CREATE TABLE `questionnaire` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `creator` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `edited` datetime DEFAULT NULL,
  `editor` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `deleted` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `age` varchar(20) DEFAULT NULL,
  `occupation` varchar(150) CHARACTER SET utf8mb4 DEFAULT NULL,
  `getways` varchar(200) CHARACTER SET utf8mb4 DEFAULT NULL,
  `phone_number` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for vip
-- ----------------------------
DROP TABLE IF EXISTS `vip`;
CREATE TABLE `vip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(255) DEFAULT NULL,
  `membership_level` int(255) DEFAULT NULL,
  `remaining_frequency` varchar(255) DEFAULT NULL,
  `left_times` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `expired` int(11) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `user_status` varchar(255) DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `edited` datetime DEFAULT NULL,
  `editor` varchar(255) DEFAULT NULL,
  `deleted` varchar(255) DEFAULT NULL,
  `questionnaire_statues` varchar(100) DEFAULT NULL,
  `aichallenge_statues` varchar(100) DEFAULT NULL,
  `expiry_time` datetime DEFAULT NULL,
  `purchase_times` varchar(255) DEFAULT NULL,
  `total_times` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;