web_shopmarket项目所需数据库

/*
Navicat MySQL Data Transfer

Source Server Version : 50711
Source Host           : localhost:3306
Source Database       : store

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

Date: 2018-07-27 08:34:10
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `category`
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `cid` varchar(50) NOT NULL,
  `cname` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', '手机数码');
INSERT INTO `category` VALUES ('2', '电脑办公');
INSERT INTO `category` VALUES ('3', '家具家居');
INSERT INTO `category` VALUES ('4', '鞋靴箱包');
INSERT INTO `category` VALUES ('5', '图书音像');
INSERT INTO `category` VALUES ('6', '母婴孕婴');
INSERT INTO `category` VALUES ('7', '汽车用品');
INSERT INTO `category` VALUES ('8', '运动户外');

-- ----------------------------
-- Table structure for `orderitem`
-- ----------------------------
DROP TABLE IF EXISTS `orderitem`;
CREATE TABLE `orderitem` (
  `itemid` varchar(50) NOT NULL,
  `count` int(11) DEFAULT NULL,
  `subtotal` double(10,0) DEFAULT NULL,
  `pid` varchar(50) DEFAULT NULL,
  `oid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`itemid`),
  KEY `fk_0001` (`pid`),
  KEY `fk_0002` (`oid`),
  CONSTRAINT `fk_0001` FOREIGN KEY (`pid`) REFERENCES `product` (`pid`),
  CONSTRAINT `fk_0002` FOREIGN KEY (`oid`) REFERENCES `orders` (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of orderitem
-- ----------------------------
INSERT INTO `orderitem` VALUES ('51c8f254-1320-49e5-9610-d778d77a87b8', '1', '10288', '39', '6b37b4ce-a350-4a5b-8fe7-af760f1793b1');
INSERT INTO `orderitem` VALUES ('cb453b60-e8a3-4f88-9c00-74e93cf0ca4f', '1', '10288', '39', '484f5fb9-e4d9-4cd9-aec8-52821e989d41');

-- ----------------------------
-- Table structure for `orders`
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `oid` varchar(50) NOT NULL,
  `ordertime` datetime DEFAULT NULL,
  `total` double(10,0) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `address` varchar(30) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `uid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('484f5fb9-e4d9-4cd9-aec8-52821e989d41', '2018-07-26 18:36:10', '10288', '1', '沈阳', 'tom', '123654897', '3fbf7a13-6d4b-4754-8c06-104378472574');
INSERT INTO `orders` VALUES ('6b37b4ce-a350-4a5b-8fe7-af760f1793b1', '2018-07-26 18:14:12', '10288', '0', null, null, null, null);

-- ----------------------------
-- Table structure for `product`
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `pid` varchar(50) NOT NULL DEFAULT '',
  `pname` varchar(50) DEFAULT NULL,
  `market_price` double DEFAULT NULL,
  `shop_price` double DEFAULT NULL,
  `pimage` varchar(200) DEFAULT NULL,
  `pdate` date DEFAULT NULL,
  `is_hot` int(11) DEFAULT NULL,
  `pdesc` varchar(255) DEFAULT NULL,
  `pflag` int(11) DEFAULT NULL,
  `cid` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`pid`),
  KEY `sfk_0001` (`cid`),
  CONSTRAINT `sfk_0001` FOREIGN KEY (`cid`) REFERENCES `category` (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES ('1', '小米 4c 标准版', '1399', '1299', 'products/1/c_0001.jpg', '2015-11-02', '1', '小米 4c 标准版 全网通 白色 移动联通电信4G手机 双卡双待', '0', '1');
INSERT INTO `product` VALUES ('10', '华为 Ascend Mate7', '2699', '2599', 'products/1/c_0010.jpg', '2015-11-02', '1', '华为 Ascend Mate7 月光银 移动4G手机 双卡双待双通6英寸高清大屏，纤薄机身，智能超八核，按压式指纹识别！!选择下方“移动老用户4G飞享合约”，无需换号，还有话费每月返还！', '0', '1');
INSERT INTO `product` VALUES ('100', '星空 几米', '41.5', '24', 'products/5/B_018.jpg', '2018-07-10', '1', 'null', '0', '5');
INSERT INTO `product` VALUES ('102', '向左走向右走 几米', '22.9', '12', 'products/5/B_019.jpg', '2018-07-10', '1', 'null', '0', '5');
INSERT INTO `product` VALUES ('103', '纯棉婴儿衣服新生儿礼盒套装', '288', '110', 'products/6/M_001.jpg', '2018-07-08', '1', 'null', '0', '6');
INSERT INTO `product` VALUES ('104', '思贝优 婴儿奶瓶消毒器带烘干暖奶二合一', '169', '89', 'products/6/M_002.jpg', '2018-07-08', '1', 'null', '0', '6');
INSERT INTO `product` VALUES ('105', '婴儿礼盒套装春夏新生儿用品满月礼物', '155', '59', 'products/6/M_003.jpg', '2018-07-08', '1', 'null', '0', '6');
INSERT INTO `product` VALUES ('106', '初生婴儿用品礼盒新生儿衣服夏季套装大全', '156', '59', 'products/6/M_004.jpg', '2018-07-08', '1', 'null', '0', '6');
INSERT INTO `product` VALUES ('107', '婴儿秋装外出衣服', '69', '30', 'products/6/M_005.jpg', '2018-07-08', '1', 'null', '0', '6');
INSERT INTO `product` VALUES ('108', '婴儿连体衣宝宝长袖爬服连帽卡通拉链外出服柔软哈衣', '65', '23', 'products/6/M_006.jpg', '2018-07-08', '1', 'null', '0', '6');
INSERT INTO `product` VALUES ('109', '恩尼诺玻璃奶瓶新生儿宽口径硅胶防摔保护套带手柄吸管宝宝喝水', '198', '89', 'products/6/M_007.jpg', '2018-07-08', '1', 'null', '0', '6');
INSERT INTO `product` VALUES ('11', 'vivo X5Pro', '2399', '2298', 'products/1/c_0014.jpg', '2015-11-02', '1', '移动联通双4G手机 3G运存版 极光白【购机送蓝牙耳机+蓝牙自拍杆】新升级3G运行内存·双2.5D弧面玻璃·眼球识别技术', '0', '1');
INSERT INTO `product` VALUES ('110', '智能恒温新生儿奶瓶玻璃宽口径防胀气户外便携式保温奶瓶带吸管', '368', '190', 'products/6/M_008.jpg', '2018-07-08', '1', 'null', '0', '6&#