secondhand.sql

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

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

/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50714
Source Host           : localhost:3306
Source Database       : secondhand

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

Date: 2023-01-07 18:14:54
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for consumer
-- ----------------------------
DROP TABLE IF EXISTS `consumer`;
CREATE TABLE `consumer` (
  `csid` int(11) NOT NULL AUTO_INCREMENT,
  `csnumber` varchar(255) DEFAULT NULL,
  `cspassword` varchar(255) DEFAULT NULL,
  `csname` varchar(255) DEFAULT NULL,
  `cstelphone` varchar(255) DEFAULT NULL,
  `csaddress` varchar(255) DEFAULT NULL,
  `cswechat` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`csid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of consumer
-- ----------------------------
INSERT INTO `consumer` VALUES ('1', 'chenming', '111', '张明的1', '15166862152', '北四路25号', 'zhanghcen');
INSERT INTO `consumer` VALUES ('2', 'zhangchen', '111', '章程', '15166862152', '北四路25号', 'zhangchen256');
INSERT INTO `consumer` VALUES ('3', 'zhangchen1', '111', '章程', '15166862152', '北四路25号', 'zhangchen256');
INSERT INTO `consumer` VALUES ('4', 'chengang', '1111', '陈刚', '15166862152', '北四路25号', 'chengang569');

-- ----------------------------
-- Table structure for controllers
-- ----------------------------
DROP TABLE IF EXISTS `controllers`;
CREATE TABLE `controllers` (
  `ctID` int(11) NOT NULL AUTO_INCREMENT,
  `ctNumber` varchar(255) DEFAULT NULL,
  `ctPassword` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ctID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of controllers
-- ----------------------------
INSERT INTO `controllers` VALUES ('1', 'admin', '1111');

-- ----------------------------
-- Table structure for junk
-- ----------------------------
DROP TABLE IF EXISTS `junk`;