/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50500
Source Host : localhost:3306
Source Database : market
Target Server Type : MYSQL
Target Server Version : 50500
File Encoding : 65001
Date: 2022-06-17 14:32:43
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `tbl_admin`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_admin`;
CREATE TABLE `tbl_admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`realname` varchar(20) DEFAULT NULL,
`role` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `for1` (`role`),
CONSTRAINT `for1` FOREIGN KEY (`role`) REFERENCES `tbl_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_admin
-- ----------------------------
INSERT INTO tbl_admin VALUES ('1', 'admin', '1', '张三', '1');
-- ----------------------------
-- Table structure for `tbl_booktype`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_booktype`;
CREATE TABLE `tbl_booktype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_booktype
-- ----------------------------
INSERT INTO tbl_booktype VALUES ('1', '童话类');
INSERT INTO tbl_booktype VALUES ('2', '天文类');
INSERT INTO tbl_booktype VALUES ('3', '文学类');
-- ----------------------------
-- Table structure for `tbl_car_wangdapao`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_car_wangdapao`;
CREATE TABLE `tbl_car_wangdapao` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`photopath` varchar(255) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`count` int(11) DEFAULT NULL,
`type` varchar(10) DEFAULT NULL,
`author` varchar(10) DEFAULT NULL,
`htype` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_car_wangdapao
-- ----------------------------
-- ----------------------------
-- Table structure for `tbl_car_wangwu`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_car_wangwu`;
CREATE TABLE `tbl_car_wangwu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`photopath` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`count` int(11) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`htype` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_car_wangwu
-- ----------------------------
-- ----------------------------
-- Table structure for `tbl_car_zhangsan`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_car_zhangsan`;
CREATE TABLE `tbl_car_zhangsan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`photopath` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`count` int(11) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`htype` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_car_zhangsan
-- ----------------------------
-- ----------------------------
-- Table structure for `tbl_clothtype`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_clothtype`;
CREATE TABLE `tbl_clothtype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_clothtype
-- ----------------------------
INSERT INTO tbl_clothtype VALUES ('1', '男装');
INSERT INTO tbl_clothtype VALUES ('2', '女装');
-- ----------------------------
-- Table structure for `tbl_consumer`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_consumer`;
CREATE TABLE `tbl_consumer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`realname` varchar(255) DEFAULT NULL,
`sex` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`telephone` int(11) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`photopath` varchar(255) DEFAULT NULL,
`birthday` varchar(20) DEFAULT NULL,
`date` date DEFAULT NULL,
`roleid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `for5` (`roleid`),
CONSTRAINT `for5` FOREIGN KEY (`roleid`) REFERENCES `tbl_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_consumer
-- ----------------------------
INSERT INTO tbl_consumer VALUES ('1', 'zhangsan', '111', '张三', '女', '山东省菏泽市牡丹区', '1221', '2323@163.com', 'img/userImg/img4.jpg', '2000-00-00', '2022-05-26', '1');
INSERT INTO tbl_consumer VALUES ('3', 'wangwu', '111', '王五', '男', '山东省聊城市', '521521', '2323@163.com', 'img/userImg/img3.jpg', '2000-00-00', '2022-05-29', '1');
INSERT INTO tbl_consumer VALUES ('4', 'wangdapao', '123', '王大炮', '女', '山东省济南市', '521521', '2323@163.com', 'img/userImg/img4.jpg', '2000-00-00', '2022-06-03', '1');
-- ----------------------------
-- Table structure for `tbl_fruitstype`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_fruitstype`;
CREATE TABLE `tbl_fruitstype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_fruitstype
-- ----------------------------
INSERT INTO tbl_fruitstype VALUES ('1', '热带类');
INSERT INTO tbl_fruitstype VALUES ('2', '温带类');
-- ----------------------------
-- Table structure for `tbl_htype`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_htype`;
CREATE TABLE `tbl_htype` (
`htypeid` int(11) NOT NULL AUTO_INCREMENT,
`htype` varchar(255) DEFAULT NULL,
PRIMARY KEY (`htypeid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_htype
-- ----------------------------
INSERT INTO tbl_htype VALUES ('1', '书籍');
INSERT INTO tbl_htype VALUES ('2', '衣装');
INSERT INTO tbl_htype VALUES ('3', '水果');
-- ----------------------------
-- Table structure for `tbl_order`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_order`;
CREATE TABLE `tbl_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`photopath` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`count` int(11) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`htype` varchar(11) DEFAULT NULL,
`stateid` int(11) DEFAULT NULL,
`userid` int(11) DEFAULT NULL,
`flag` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ff1` (`stateid`),
KEY `ff2` (`userid`),
CONSTRAINT `ff1` FOREIGN KEY (`stateid`) REFERENCES `tbl_state` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ff2` FOREIGN KEY (`userid`) REFERENCES `tbl_consumer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tbl_order
-- ----------------------------
-- ----------------------------
-- Table structure for `tbl_role`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_role`;
CREATE TABLE `tbl_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- --------------------
评论0