数据库/carsellsystemdb.sql

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

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

/*
MySQL Data Transfer
Source Host: localhost
Source Database: carsellsystemdb
Target Host: localhost
Target Database: carsellsystemdb
Date: 2017/8/9 19:04:13
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_buyinfo
-- ----------------------------
CREATE TABLE `t_buyinfo` (
  `buyId` int(11) NOT NULL AUTO_INCREMENT,
  `supplyer` varchar(20) NOT NULL,
  `carname` varchar(20) NOT NULL,
  `model` varchar(50) NOT NULL,
  `price` float DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `total_money` float DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `day` int(11) DEFAULT NULL,
  `date_string` varchar(50) NOT NULL,
  `employeeId` int(11) DEFAULT NULL,
  PRIMARY KEY (`buyId`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for t_car_name
-- ----------------------------
CREATE TABLE `t_car_name` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `car_name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for t_customer
-- ----------------------------
CREATE TABLE `t_customer` (
  `customer_name` varchar(255) NOT NULL,
  `customer_address` varchar(100) NOT NULL,
  `connect_person` varchar(10) NOT NULL,
  `connect_phone` varchar(20) NOT NULL,
  PRIMARY KEY (`customer_name`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Table structure for t_employee
-- ----------------------------
CREATE TABLE `t_employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `address` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;