database/jspmxsypcgxthsg9279ccmysql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50160
Source Host           : localhost:3306
Source Database       : jspmxsypcgxthsg9279ccmysql

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

Date: 2021-03-05 16:29:13
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `allusers`
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `cx` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('1', 'hsg', 'hsg', '超级管理员', '2021-03-05 16:28:07');

-- ----------------------------
-- Table structure for `caigoujilu`
-- ----------------------------
DROP TABLE IF EXISTS `caigoujilu`;
CREATE TABLE `caigoujilu` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `caigoudanhao` varchar(50) DEFAULT NULL,
  `shangpinbianhao` varchar(50) DEFAULT NULL,
  `shangpinmingcheng` varchar(50) DEFAULT NULL,
  `leibie` varchar(50) DEFAULT NULL,
  `kucun` varchar(50) DEFAULT NULL,
  `jiage` varchar(50) DEFAULT NULL,
  `caigoushuliang` varchar(50) DEFAULT NULL,
  `caigoujine` varchar(50) DEFAULT NULL,
  `caigouhetong` varchar(50) DEFAULT NULL,
  `jingbanren` varchar(50) DEFAULT NULL,
  `beizhu` varchar(255) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of caigoujilu
-- ----------------------------
INSERT INTO `caigoujilu` VALUES ('1', '355000510834', '353592472420', 'B手机', 'A类', '60', '62', '100', '6200', 'upload/1.zipupload/1.zipupload/1.zipupload/1.zip', '003', '无', '2021-03-05 16:28:07');
INSERT INTO `caigoujilu` VALUES ('2', '355049664868', '353585024009', 'G鼠标', 'Z类', '97', '62', '52', '3224', 'upload/1.zip', '030', 'abc', '2021-03-05 16:28:07');
INSERT INTO `caigoujilu` VALUES ('3', '355000510834', '353585024009', 'E牙刷', 'K类', '96', '41', '78', '3198', 'upload/1.zip', '031', '无', '2021-03-05 16:28:07');
INSERT INTO `caigoujilu` VALUES ('4', '355020129333', '353592472420', 'F牙膏', 'X类', '97', '62', '100', '6200', 'upload/1.zip', '011', '无', '2021-03-05 16:28:07');