text: /*
   Navicat Premium Data Transfer
  
   Source Server         : marion
   Source Server Type    : MySQL
   Source Server Version : 50732
   Source Host           : localhost:3306
   Source Schema         : demo
  
   Target Server Type    : MySQL
   Target Server Version : 50732
   File Encoding         : 65001
  
   Date: 04/01/2022 15:43:32
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for t_product
  -- ----------------------------
  DROP TABLE IF EXISTS `t_product`;
  CREATE TABLE `t_product` (
    `id` int(11) NOT NULL,
    `title` varchar(255) NOT NULL DEFAULT '' COMMENT '商品名称',
    `inventory` int(10) NOT NULL DEFAULT '0' COMMENT '库存',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for t_user
  -- ----------------------------
  DROP TABLE IF EXISTS `t_user`;
  CREATE TABLE `t_user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `age` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for t_user_asset
  -- ----------------------------
  DROP TABLE IF EXISTS `t_user_asset`;
  CREATE TABLE `t_user_asset` (
    `id` int(11) NOT NULL,
    `uid` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户UID',
    `amount` int(10) NOT NULL DEFAULT '0' COMMENT '余额',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  SET FOREIGN_KEY_CHECKS = 1;
  