/*
Navicat MySQL Data Transfer

Source Server         : 180.76.119.18
Source Server Version : 50529
Source Host           : localhost:3306
Source Database       : app

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

Date: 2020-12-23 10:28:20
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT '女',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('3', '1', '1', 'http://127.0.0.1:3000/public/img/admin/1607439721046-405.jpg', '男');
INSERT INTO `admin` VALUES ('7', '2', '2', 'http://127.0.0.1:3000/public/img/admin/1607440321485-203.jpg', '男');

-- ----------------------------
-- Table structure for `card`
-- ----------------------------
DROP TABLE IF EXISTS `card`;
CREATE TABLE `card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `comm` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of card
-- ----------------------------
INSERT INTO `card` VALUES ('2', '手套', '[{\"id\":1,\"name\":\"衣服\",\"number\":1}]');
INSERT INTO `card` VALUES ('3', '手套', '[{\"id\":2,\"name\":\"裤子\",\"number\":1},{\"id\":1,\"name\":\"衣服\",\"number\":1}]');
INSERT INTO `card` VALUES ('5', 'user', '[{\"id\":2,\"name\":\"裤子\",\"number\":1},{\"id\":3,\"name\":\"裙子\",\"number\":1},{\"id\":4,\"name\":\"上衣\",\"number\":1}]');
INSERT INTO `card` VALUES ('7', '1111', '[{\"id\":2,\"name\":\"裤子\",\"number\":1},{\"id\":4,\"name\":\"上衣\",\"number\":7},{\"id\":3,\"name\":\"裙子\",\"number\":3}]');
INSERT INTO `card` VALUES ('8', '1111', '[{\"id\":2,\"name\":\"裤子\",\"number\":1},{\"id\":3,\"name\":\"裙子\",\"number\":1},{\"id\":4,\"name\":\"上衣\",\"number\":1}]');
INSERT INTO `card` VALUES ('9', '1111', '[{\"id\":3,\"name\":\"裙子\",\"number\":5},{\"id\":4,\"name\":\"上衣\",\"number\":1}]');
INSERT INTO `card` VALUES ('10', '1111', '[{\"id\":3,\"name\":\"裙子\",\"number\":3},{\"id\":4,\"name\":\"上衣\",\"number\":1}]');

-- ----------------------------
-- Table structure for `commodity`
-- ----------------------------
DROP TABLE IF EXISTS `commodity`;
CREATE TABLE `commodity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `urlList` varchar(9999) DEFAULT NULL,
  `porice` varchar(255) DEFAULT NULL,
  `info` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of commodity
-- ----------------------------
INSERT INTO `commodity` VALUES ('2', '裤子', 'https://img.alicdn.com/imgextra/i4/356060330/O1CN01NcwTaj1EJBKjRTST3_!!0-item_pic.jpg_430x430q90.jpg', '[\"https://img.alicdn.com/imgextra/i4/356060330/O1CN01NcwTaj1EJBKjRTST3_!!0-item_pic.jpg_430x430q90.jpg\"]', '332', '短下题大大实打实的');
INSERT INTO `commodity` VALUES ('3', '裙子', 'http://127.0.0.1:3000/public/img/admin/1607778251043-gu-feng03.jpg', '[\"http://127.0.0.1:3000/public/img/admin/1607778251043-gu-feng03.jpg\",\"http://127.0.0.1:3000/public/img/admin/1607778251044-gu-feng05.jpg\"]', '3', '裙子');
INSERT INTO `commodity` VALUES ('4', '上衣', 'http://127.0.0.1:3000/public/img/admin/1607778327285-gu-feng01.jpg', '[\"http://127.0.0.1:3000/public/img/admin/1607778327285-gu-feng01.jpg\",\"http://127.0.0.1:3000/public/img/admin/1607778327290-gu-feng02.jpg\"]', '11', '111');

-- ----------------------------
-- Table structure for `swiper`
-- ----------------------------
DROP TABLE IF EXISTS `swiper`;
CREATE TABLE `swiper` (
  `swiperId` int(11) NOT NULL AUTO_INCREMENT,
  `swiperurl` varchar(255) NOT NULL,
  `swiperIndex` int(11) DEFAULT '0',
  `swipertime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`swiperId`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of swiper
-- ----------------------------
INSERT INTO `swiper` VALUES ('28', 'http://127.0.0.1:3000/public/img/admin/1607444112198-1607444112000.jpeg', '31', '2020-12-09 00:15:12');
INSERT INTO `swiper` VALUES ('30', 'http://127.0.0.1:3000/public/img/admin/1607444083197-1607444083000.jpeg', '30', '2020-12-09 00:15:06');
INSERT INTO `swiper` VALUES ('31', 'http://127.0.0.1:3000/public/img/admin/1607443091297-gu-feng03.jpg', '28', '2020-12-09 00:14:23');
INSERT INTO `swiper` VALUES ('32', 'http://127.0.0.1:3000/public/img/user/swiper/1607778398212-506.jpg', '32', '2020-12-12 21:06:38');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `userTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`userId`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'user', '123456', '[email protected]', '2020-12-12 14:30:58');
INSERT INTO `user` VALUES ('4', '1111', '1111', '[email protected]', '2020-12-13 19:41:37');
INSERT INTO `user` VALUES ('5', '123456', '123456', '[email protected]', '2020-12-23 10:18:13');