/*
Navicat MySQL Data Transfer

Source Server         : 123
Source Server Version : 50721
Source Host           : localhost:3306
Source Database       : shopdb

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

Date: 2023-05-04 14:43:07
*/

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', '农产品');

-- ----------------------------
-- Table structure for orderitem
-- ----------------------------
DROP TABLE IF EXISTS `orderitem`;
CREATE TABLE `orderitem` (
  `itemid` varchar(50) NOT NULL,
  `count` int(11) DEFAULT NULL,
  `subtotal` double 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 ('185108c3-e608-43e2-bb82-6a070f325a19', '1', '2599', '10', '199aa772-4cff-4ad7-9938-4bc4db09dc1c');
INSERT INTO `orderitem` VALUES ('21af706a-feac-44f6-9f13-063acb6e6aae', '1', '2499', '13', '1b0c6e12-776f-4ef9-890b-d93cf3fad619');
INSERT INTO `orderitem` VALUES ('2a832c69-fcd4-426b-a8d9-85014650a4a9', '1', '3888', '24', 'e2a13628-565f-49da-8e7d-4c8ea06ddc58');
INSERT INTO `orderitem` VALUES ('2f466641-1733-4f90-938d-1a73e5426900', '1', '2599', '10', '4b73374b-54a1-4e90-8cd1-bbd48a5ce6f0');
INSERT INTO `orderitem` VALUES ('38561648-d21a-4d57-a6ab-faebbc3e54bc', '1', '3888', '24', '9bd09235-ca4a-437c-b4f6-fae7c40670b4');
INSERT INTO `orderitem` VALUES ('43e5a6fd-6550-4ee0-9eae-743f0a1a68be', '1', '2599', '10', 'fa3c1ec2-da1d-4088-b5c7-9f0e9ab0a82d');
INSERT INTO `orderitem` VALUES ('481779c2-72f5-4a50-9a57-f103711a20ff', '1', '4087', '16', '7f1a2492-02f8-4040-ab5e-46706335e944');
INSERT INTO `orderitem` VALUES ('4c20246e-3d4c-49c2-ab15-01be72ee3559', '1', '3888', '24', '5f393877-844b-48a6-b12c-e59732846412');
INSERT INTO `orderitem` VALUES ('4e236c45-3fc1-4a9f-96f7-42378ff913f3', '1', '4199', '33', '29cc8856-ef5e-4cfa-b1e0-2caf18f7afd8');
INSERT INTO `orderitem` VALUES ('50699252-2d1a-4c74-8dea-35d7078fd6ad', '1', '3888', '24', '4d55e267-2718-4016-8acf-0f26d3a6afbe');
INSERT INTO `orderitem` VALUES ('52189841-6093-4055-81b0-b145fb468cf5', '1', '2599', '10', 'd01f0b37-5343-487e-8566-923ed10e1d81');
INSERT INTO `orderitem` VALUES ('55d7ae5c-7d97-4d2b-a65a-f7f356021e5f', '1', '1699', '23', 'd62049bb-c551-4c2e-8d05-3b5b45e61d52');
INSERT INTO `orderitem` VALUES ('5a137f94-79bf-4974-8686-957284b2e32c', '1', '3888', '24', '7c44cc95-c4ba-4f05-9605-7ae4c0485d34');
INSERT INTO `orderitem` VALUES ('5bbeb379-7233-42a5-8b17-81d046553ec7', '2', '7776', '24', '6dee6b4e-b006-407e-a998-339ac0a43855');
INSERT INTO `orderitem` VALUES ('60ba8195-6557-4c23-b886-fe9436c0a0c8', '1', '2499', '13', '7fb71d3e-b964-49c8-ac78-bac47f0211c5');
INSERT INTO `orderitem` VALUES ('650c8206-84e0-473c-8340-e6442d3004f5', '1', '2499', '13', '0aa76bdc-f0a2-43c9-a8ca-7c6e0cbf2378');
INSERT INTO `orderitem` VALUES ('6c6db5f1-3817-42d6-b62c-26f084d83301', '1', '2499', '13', 'dc02b8e9-54b3-4ad4-a3a7-4acf7c9889c2');
INSERT INTO `orderitem` VALUES ('735e9658-30db-4329-860c-38961739fa91', '3', '4194', '7', '359d5222-6f78-4a23-898c-38f8a9c11651');
INSERT INTO `orderitem` VALUES ('7400ba50-5df7-4fc8-b0b1-8e9b5510ea14', '1', '2499', '13', '2b7b52a5-fecf-4b73-9f41-78c007888840');
INSERT INTO `orderitem` VALUES ('815c7f27-c95f-4a5b-b284-4bf97e4d4dab', '50', '129950', '10', 'a5249f14-a3a5-4bc2-b57e-707ba2f199fb');
INSERT INTO `orderitem` VALUES ('86dc9934-5abc-44c4-acea-386782f46163', '1', '2499', '13', 'f2981c81-7dc1-48f3-97f7-75cd8d6c5a48');
INSERT INTO `orderitem` VALUES ('8d453298-f952-4f4d-aa00-317d2a68e3bc', '1', '2499', '13', '780ee84a-a8c0-4b96-980b-8086aeda21cf');
INSERT INTO `orderitem` VALUES ('a4f635ee-5b59-4d07-9e6f-da40a9a4d21a', '1', '1699', '23', 'e1671db0-c874-45a3-b15e-f9b4bcfac40c');
INSERT INTO `orderitem` VALUES ('a9c6320b-a926-417a-8085-fa6cd391df43', '1', '6688', '32', '7e637f63-0a3b-49e0-a467-42df4e3fc350');
INSERT INTO `orderitem` VALUES ('b240dcff-e669-44d5-80fc-892b1e7e357b', '1', '2499', '13', '2bcd7b6a-0177-449c-aaed-cfa7a2dcd800');
INSERT INTO `orderitem` VALUES ('c7a137dc-2d92-42fd-82e0-85cc22e35aed', '1', '2599', '10', '07559d7d-5820-4fd5-9d93-ec7b083553b6');
INSERT INTO `orderitem` VALUES ('d4013128-295b-4755-be74-4b950e9bccaf', '1', '2298', '11', 'e12ad470-4192-4106-b6a4-01a0d7193579');
INSERT INTO `orderitem` VALUES ('d79513bd-3006-492d-8836-6a95c76a25e0', '1', '2599', '10', 'e12ad470-4192-4106-b6a4-01a0d7193579');
INSERT INTO `orderitem` VALUES ('da420660-10d6-4002-abd9-82756742c32d', '1', '2499', '13', '6d892ce2-6f9d-408e-ad1b-2151e77bcc71');
INSERT INTO `orderitem` VALUES ('dbe5a74a-c5d4-490b-ac9a-229cf96c2cbe', '1', '1299', '1', '9634ffc3-077d-4821-b0d1-35f60696b317');
INSERT INTO `orderitem` VALUES ('df297cdf-dd4e-4d6d-895c-eed0ac5903ee', '1', '3888', '24', 'aa54244b-f5ba-43c8-a839-a4e639deb724');
INSERT INTO `orderitem` VALUES ('dfe582e7-19a9-42c3-bdf9-8bbfb0fb6437', '1', '2298', '11', '9ea64c66-46ac-4229-8c24-2696cc6a5801');
INSERT INTO `orderitem` VALUES ('e42c094f-47e8-45a8-b839-f97c9b2b32c4', '1', '2599', '10', '646465ef-30c2-45dc-ae29-a256012117bc');
INSERT INTO `orderitem` VALUES ('e4875c5f-ab12-4a06-907b-b089e1ec0591', '1', '4199', '33', 'eb85e446-ea3c-463c-a118-2f6837944e0b');
INSERT INTO `orderitem` VALUES ('e8229695-8eac-46ec-a579-a408e5762639', '1', '3888', '24', 'e6977f47-baa8-4128-a548-ede1c7ed78a1');
INSERT INTO `orderitem` VALUES ('f2c4a0ca-69b6-446f-a712-5cf407c3112c', '1', '2499', '13', '4196597c-d07f-40d6-a868-b4ecbe747796');

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

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('07559d7d-5820-4fd5-9d93-ec7b083553b6', '2019-11-05 14:41:25', '2599', '1', '广东省东莞市', '张三', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('0aa76bdc-f0a2-43c9-a8ca-7c6e0cbf2378', '2021-12-25 15:59:54', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('1496bad7-d3b9-40af-b8f2-e484d7dda631', '2021-12-25 16:19:10', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('199aa772-4cff-4ad7-9938-4bc4db09dc1c', '2022-10-31 10:56:27', '2599', '1', '', 'bbb', '1111', '769dbdf9-e4d3-423e-9f14-d37f5b0f77fa', null);
INSERT INTO `orders` VALUES ('1b0c6e12-776f-4ef9-890b-d93cf3fad619', '2021-12-25 16:17:54', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('29cc8856-ef5e-4cfa-b1e0-2caf18f7afd8', '2019-11-05 16:31:47', '4199', '1', '广东省东莞市', 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('2b7b52a5-fecf-4b73-9f41-78c007888840', '2023-03-21 18:56:42', '2499', '1', 'aaa', '小王', 'aaa', 'f55b7d3a352a4f0782c910b2c70f1ea4', null);
INSERT INTO `orders` VALUES ('2bcd7b6a-0177-449c-aaed-cfa7a2dcd800', '2021-12-30 14:40:10', '2499', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('359d5222-6f78-4a23-898c-38f8a9c11651', '2022-09-15 13:01:54', '4194', '1', 'gunn', 'da王', '15712344823', 'f55b7d3a352a4f0782c910b2c70f1ea4', null);
INSERT INTO `orders` VALUES ('4196597c-d07f-40d6-a868-b4ecbe747796', '2021-12-30 15:18:11', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('4b73374b-54a1-4e90-8cd1-bbd48a5ce6f0', '2021-12-24 14:48:22', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('4d55e267-2718-4016-8acf-0f26d3a6afbe', '2021-12-25 16:19:01', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('5f393877-844b-48a6-b12c-e59732846412', '2021-12-24 15:21:31', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('646465ef-30c2-45dc-ae29-a256012117bc', '2022-01-01 20:01:10', '2599', '0', '', 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('6b3eefa5-db86-4aa9-8c3b-df6a254d8ae9', '2021-12-24 15:26:25', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('6d892ce2-6f9d-408e-ad1b-2151e77bcc71', '2021-12-30 15:30:53', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('6dee6b4e-b006-407e-a998-339ac0a43855', '2021-12-27 06:44:43', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('780ee84a-a8c0-4b96-980b-8086aeda21cf', '2021-12-30 15:04:47', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('7c44cc95-c4ba-4f05-9605-7ae4c0485d34', '2021-12-25 16:04:14', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('7e637f63-0a3b-49e0-a467-42df4e3fc350', '2019-11-05 15:38:39', '6688', '4', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', '苹果手机一般般');
INSERT INTO `orders` VALUES ('7f1a2492-02f8-4040-ab5e-46706335e944', '2019-11-05 15:32:32', '4087', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('7fb71d3e-b964-49c8-ac78-bac47f0211c5', '2021-12-27 17:37:14', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('9634ffc3-077d-4821-b0d1-35f60696b317', '2021-12-30 15:36:46', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('9765435', '2021-12-23 00:00:00', '266', '0', '中大南方', 'zhangsan', '110', '67305618-b58e-4b8d-9a97-a918a3ac20d1', '');
INSERT INTO `orders` VALUES ('9bd09235-ca4a-437c-b4f6-fae7c40670b4', '2021-12-25 16:20:46', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('9ea64c66-46ac-4229-8c24-2696cc6a5801', '2023-04-04 12:13:57', '2298', '1', '', '小王', '', 'f55b7d3a352a4f0782c910b2c70f1ea4', null);
INSERT INTO `orders` VALUES ('a5249f14-a3a5-4bc2-b57e-707ba2f199fb', '2023-04-04 12:07:52', '129950', '1', 'dddddddddd', '小王', '1234648484', 'f55b7d3a352a4f0782c910b2c70f1ea4', null);
INSERT INTO `orders` VALUES ('aa54244b-f5ba-43c8-a839-a4e639deb724', '2021-12-25 16:19:16', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('b6f1bfb5-08e9-40aa-bab3-0266553446c5', '2021-12-27 06:44:32', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('bc37fe10-7f6c-4559-b100-abbab4b45c1f', '2021-12-25 16:20:41', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('d01f0b37-5343-487e-8566-923ed10e1d81', '2019-11-05 17:21:43', '2599', '4', '广东创新职院', '王五', '12345678910', '67305618-b58e-4b8d-9a97-a918a3ac20d1', '华为挺不错！！！！');
INSERT INTO `orders` VALUES ('d4df7d8c-acdb-4511-a313-1d06df4c03ae', '2021-12-25 16:19:07', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('d62049bb-c551-4c2e-8d05-3b5b45e61d52', '2022-10-31 10:57:42', '0', '1', '11', 'bbb', '1111', '769dbdf9-e4d3-423e-9f14-d37f5b0f77fa', null);
INSERT INTO `orders` VALUES ('dc02b8e9-54b3-4ad4-a3a7-4acf7c9889c2', '2023-03-21 16:43:22', '0', '0', null, '小王', '15712344823', 'f55b7d3a352a4f0782c910b2c70f1ea4', null);
INSERT INTO `orders` VALUES ('e12ad470-4192-4106-b6a4-01a0d7193579', '2021-12-27 06:52:26', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('e1671db0-c874-45a3-b15e-f9b4bcfac40c', '2021-12-30 14:40:19', '1699', '1', '', 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('e2a13628-565f-49da-8e7d-4c8ea06ddc58', '2021-12-25 15:50:11', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('e6977f47-baa8-4128-a548-ede1c7ed78a1', '2021-12-24 15:26:42', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('eb85e446-ea3c-463c-a118-2f6837944e0b', '2021-12-29 01:06:40', '4199', '0', '', 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);
INSERT INTO `orders` VALUES ('f2981c81-7dc1-48f3-97f7-75cd8d6c5a48', '2023-03-21 16:44:34', '2499', '1', 'aa', '小王', 'aaa', 'f55b7d3a352a4f0782c910b2c70f1ea4', null);
INSERT INTO `orders` VALUES ('fa3c1ec2-da1d-4088-b5c7-9f0e9ab0a82d', '2021-12-27 06:44:27', '0', '0', null, 'aaa', '15723689921', '373eb242933b4f5ca3bd43503c34668b', null);

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `pid` varchar(50) NOT NULL,
  `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(50) 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 ('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 ('12', '努比亚（nubia）My 布拉格', '1899', '1799', 'products/1/c_0013.jpg', '2015-11-02', '0', '努比亚（nubia）My 布拉格 银白 移动联通4G手机 双卡双待【嗨11，下单立减100】金属机身，快速充电！布拉格相机全新体验！', '0', '1');
INSERT INTO `product` VALUES ('13', '华为 麦芒4', '2599', '2499', 'products/1/c_0012.jpg', '2015-11-02', '1', '华为 麦芒4 晨曦金 全网通版4G手机 双卡双待金属机身 2.5D弧面屏 指纹解锁 光学防抖', '0', '1');
INSERT INTO `product` VALUES ('14', 'vivo X5M', '1899', '1799', 'products/1/c_0011.jpg', '2015-11-02', '0', 'vivo X5M 移动4G手机 双卡双待 香槟金【购机送蓝牙耳机+蓝牙自拍杆】5.0英寸大屏显示·八核双卡双待·Hi-Fi移动KTV', '0', '1');
INSERT INTO `product` VALUES ('15', 'Apple iPhone 6 (A1586)', '4399', '4288', 'products/1/c_0015.jpg', '2015-11-02', '1', 'Apple iPhone 6 (A1586) 16GB 金色 移动联通电信4G手机长期省才是真的省！点击购机送费版，月月送话费，月月享优惠，畅享4G网络，就在联通4G！', '0', '1');
INSERT INTO `product` VALUES ('16', '华为 HUAWEI Mate S 臻享版', '4200', '4087', 'products/1/c_0016.jpg', '2015-11-03', '0', '华为 HUAWEI Mate S 臻享版 手机 极昼金 移动联通双4G(高配)满星评价即返30元话费啦；买就送电源+清水套+创意手机支架；优雅弧屏，mate7升级版', '0', '1');
INSERT INTO `product` VALUES ('17', '索尼(SONY) E6533 Z3+', '4099', '3999', 'products/1/c_0017.jpg', '2015-11-02', '0', '索尼(SONY) E6533 Z3+ 双卡双4G手机 防水防尘 涧湖绿索尼z3专业防水 2070万像素 移动联通双4G', '0', '1');
INSERT INTO `product` VALUES ('18', 'HTC One M9+', '3599', '3499', 'products/1/c_0018.jpg', '2015-11-02', '0', 'HTC One M9+（M9pw） 金银汇 移动联通双4G手机5.2英寸，8核CPU，指纹识别，UltraPixel超像素前置相机+2000万/200万后置双镜头相机！降价特卖，惊喜不断！', '0', '1');
INSERT INTO `product` VALUES ('19', 'HTC Desire 826d 32G 臻珠白', '1599', '1469', 'products/1/c_0020.jpg', '2015-11-02', '1', '后置1300万+UltraPixel超像素前置摄像头+【双】前置扬声器+5.5英寸【1080p】大屏！', '0', '1');
INSERT INTO `product` VALUES ('2', '中兴 AXON', '2899', '2699', 'products/1/c_0002.jpg', '2015-11-05', '1', '中兴 AXON 天机 mini 压力屏版 B2015 华尔金 移动联通电信4G 双卡双待', '0', '1');
INSERT INTO `product` VALUES ('20', '小米 红米2A 增强版 白色', '649', '549', 'products/1/c_0019.jpg', '2015-11-02', '0', '新增至2GB 内存+16GB容量！4G双卡双待，联芯 4 核 1.5GHz 处理器！', '0', '1');
INSERT INTO `product` VALUES ('21', '魅族 魅蓝note2 16GB 白色', '1099', '999', 'products/1/c_0021.jpg', '2015-11-02', '0', '现货速抢，抢完即止！5.5英寸1080P分辨率屏幕，64位八核1.3GHz处理器，1300万像素摄像头，双色温双闪光灯！', '0', '1');
INSERT INTO `product` VALUES ('22', '三星 Galaxy S5 (G9008W) 闪耀白', '2099', '1999', 'products/1/c_0022.jpg', '2015-11-02', '1', '5.1英寸全高清炫丽屏，2.5GHz四核处理器，1600万像素', '0', '1');
INSERT INTO `product` VALUES ('23', 'sonim XP7700 4G手机', '1799', '1699', 'products/1/c_0023.jpg', '2015-11-09', '1', '三防智能手机 移动/联通双4G 安全 黑黄色 双4G美国军工IP69 30天长待机 3米防水防摔 北斗', '0', '1');
INSERT INTO `product` VALUES ('24', '努比亚（nubia）Z9精英版 金色', '3988', '3888', 'products/1/c_0024.jpg', '2015-11-02', '1', '移动联通电信4G手机 双卡双待真正的无边框！金色尊贵版！4GB+64GB大内存！', '0', '1');
INSERT INTO `product` VALUES ('25', 'Apple iPhone 6 Plus (A1524) 16GB 金色', '5188', '4988', 'products/1/c_0025.jpg', '2015-11-02', '0', 'Apple iPhone 6 Plus (A1524) 16GB 金色 移动联通电信4G手机 硬货 硬实力', '0', '1');
INSERT INTO `product` VALUES ('26', 'Apple iPhone 6s (A1700) 64G 玫瑰金色', '6388', '6088', 'products/1/c_0026.jpg', '2015-11-02', '0', 'Apple iPhone 6 Plus (A1524) 16GB 金色 移动联通电信4G手机 硬货 硬实力', '0', '1');
INSERT INTO `product` VALUES ('27', '三星 Galaxy Note5（N9200）32G版', '5588', '5388', 'products/1/c_0027.jpg', '2015-11-02', '0', '旗舰机型！5.7英寸大屏，4+32G内存！不一样的SPen更优化的浮窗指令！赠无线充电板！', '0', '1');
INSERT INTO `product` VALUES ('28', '三星 Galaxy S6 Edge+（G9280）32G版 铂光金', '5999', '5888', 'products/1/c_0028.jpg', '2015-11-02', '0', '赠移动电源+自拍杆+三星OTG金属U盘+无线充电器+透明保护壳', '0', '1');
INSERT INTO `product` VALUES ('29', 'LG G4（H818）陶瓷白 国际版', '3018', '2978', 'products/1/c_0029.jpg', '2015-11-02', '0', '李敏镐代言，F1.8大光圈1600万后置摄像头，5.5英寸2K屏，3G+32G内存，LG年度旗舰机！', '0', '1');
INSERT INTO `product` VALUES ('3', '华为荣耀6', '1599', '1499', 'products/1/c_0003.jpg', '2015-11-02', '0', '荣耀 6 (H60-L01) 3GB内存标准版 黑色 移动4G手机', '0', '1');
INSERT INTO `product` VALUES ('30', '微软(Microsoft) Lumia 640 LTE DS (RM-1113)', '1099', '999', 'products/1/c_0030.jpg', '2015-11-02', '0', '微软首款双网双卡双4G手机，5.0英寸高清大屏，双网双卡双4G！', '0', '1');
INSERT INTO `product` VALUES ('31', '宏碁（acer）ATC705-N50 台式电脑', '2399', '2299', 'products/1/c_0031.jpg', '2015-11-02', '0', '爆款直降，满千减百，品质宏碁，特惠来袭，何必苦等11.11，早买早便宜！', '0', '2');
INSERT INTO `product` VALUES ('32', 'Apple MacBook Air MJVE2CH/A 13.3英寸', '6788', '6688', 'products/1/c_0032.jpg', '2015-11-02', '0', '宽屏笔记本电脑 128GB 闪存', '0', '2');
INSERT INTO `product` VALUES ('33', '联想（ThinkPad） 轻薄系列E450C(20EH0001CD)', '4399', '4199', 'products/1/c_0033.jpg', '2015-11-02', '0', '联想（ThinkPad） 轻薄系列E450C(20EH0001CD)14英寸笔记本电脑(i5-4210U 4G 500G 2G独显 Win8.1)', '0', '2');
INSERT INTO `product` VALUES ('34', '联想（Lenovo）小新V3000经典版', '4599', '4499', 'products/1/c_0034.jpg', '2015-11-02', '0', '14英寸超薄笔记本电脑（i7-5500U 4G 500G+8G SSHD 2G独显 全高清屏）黑色满1000減100，狂减！火力全开，横扫3天！', '0', '2');
INSERT INTO `product` VALUES ('35', '华硕（ASUS）经典系列R557LI', '3799', '3699', 'products/1/c_0035.jpg', '2015-11-02', '0', '15.6英寸笔记本电脑（i5-5200U 4G 7200转500G 2G独显 D刻 蓝牙 Win8.1 黑色）', '0', '2');
INSERT INTO `product` VALUES ('36', '华硕（ASUS）X450J', '4599', '4399', 'products/1/c_0036.jpg', '2015-11-02', '0', '14英寸笔记本电脑 （i5-4200H 4G 1TB GT940M 2G独显 蓝牙4.0 D刻 Win8.1 黑色）', '0', '2');
INSERT INTO `product` VALUES ('37', '戴尔（DELL）灵越 飞匣3000系列', '3399', '3299', 'products/1/c_0037.jpg', '2015-11-03', '0', ' Ins14C-4528B 14英寸笔记本（i5-5200U 4G 500G GT820M 2G独显 Win8）黑', '0', '2');
INSERT INTO `product` VALUES ('38', '惠普(HP)WASD 暗影精灵', '5699', '5499', 'products/1/c_0038.jpg', '2015-11-02', '0', '15.6英寸游戏笔记本电脑(i5-6300HQ 4G 1TB+128G SSD GTX950M 4G独显 Win10)', '0', '2');
INSERT INTO `product` VALUES ('39', 'Apple 配备 Retina 显示屏的 MacBook', '11299', '10288', 'products/1/c_0039.jpg', '2015-11-02', '0', 'Pro MF840CH/A 13.3英寸宽屏笔记本电脑 256GB 闪存', '0', '2');
INSERT INTO `product` VALUES ('4', '联想 P1', '2199', '1999', 'products/1/c_0004.jpg', '2015-11-02', '0', '联想 P1 16G 伯爵金 移动联通4G手机充电5分钟，通话3小时！科技源于超越！品质源于沉淀！5000mAh大电池！高端商务佳配！', '0', '1');
INSERT INTO `product` VALUES ('40', '机械革命（MECHREVO）MR X6S-M', '6799', '6599', 'products/1/c_0040.jpg', '2015-11-02', '0', '15.6英寸游戏本(I7-4710MQ 8G 64GSSD+1T GTX960M 2G独显 IPS屏 WIN7)黑色', '0', '2');
INSERT INTO `product` VALUES ('41', '神舟（HASEE） 战神K660D-i7D2', '5699', '5499', 'products/1/c_0041.jpg', '2015-11-02', '0', '15.6英寸游戏本(i7-4710MQ 8G 1TB GTX960M 2G独显 1080P)黑色', '0', '2');
INSERT INTO `product` VALUES ('42', '微星（MSI）GE62 2QC-264XCN', '6199', '5999', 'products/1/c_0042.jpg', '2015-11-02', '0', '15.6英寸游戏笔记本电脑（i5-4210H 8G 1T GTX960MG DDR5 2G 背光键盘）黑色', '0', '2');
INSERT INTO `product` VALUES ('43', '雷神（ThundeRobot）G150S', '5699', '5499', 'products/1/c_0043.jpg', '2015-11-02', '0', '15.6英寸游戏本 ( i7-4710MQ 4G 500G GTX950M 2G独显 包无亮点全高清屏) 金', '0', '2');
INSERT INTO `product` VALUES ('44', '惠普（HP）轻薄系列 HP', '3199', '3099', 'products/1/c_0044.jpg', '2015-11-02', '0', '15-r239TX 15.6英寸笔记本电脑（i5-5200U 4G 500G GT820M 2G独显 win8.1）金属灰', '0', '2');
INSERT INTO `product` VALUES ('45', '未来人类（Terrans Force）T5', '10999', '9899', 'products/1/c_0045.jpg', '2015-11-02', '0', '15.6英寸游戏本（i7-5700HQ 16G 120G固态+1TB GTX970M 3G GDDR5独显）黑', '0', '2');
INSERT INTO `product` VALUES ('46', '戴尔（DELL）Vostro 3800-R6308 台式电脑', '3299', '3199', 'products/1/c_0046.jpg', '2015-11-02', '0', '（i3-4170 4G 500G DVD 三年上门服务 Win7）黑', '0', '2');
INSERT INTO `product` VALUES ('47', '联想（Lenovo）H3050 台式电脑', '5099', '4899', 'products/1/c_0047.jpg', '2015-11-11', '0', '（i5-4460 4G 500G GT720 1G独显 DVD 千兆网卡 Win10）23英寸', '0', '2');
INSERT INTO `product` VALUES ('48', 'Apple iPad mini 2 ME279CH/A', '2088', '1888', 'products/1/c_0048.jpg', '2015-11-02', '0', '（配备 Retina 显示屏 7.9英寸 16G WLAN 机型 银色）', '0', '2');
INSERT INTO `product` VALUES ('49', '小米（MI）7.9英寸平板', '1399', '1299', 'products/1/c_0049.jpg', '2015-11-02', '0', 'WIFI 64GB（NVIDIA Tegra K1 2.2GHz 2G 64G 2048*1536视网膜屏 800W）白色', '0', '2');
INSERT INTO `product` VALUES ('5', '摩托罗拉 moto x（x+1）', '1799', '1699', 'products/1/c_0005.jpg', '2015-11-01', '0', '摩托罗拉 moto x（x+1）(XT1085) 32GB 天然竹 全网通4G手机11月11天！MOTO X震撼特惠来袭！1699元！带你玩转黑科技！天然材质，原生流畅系统！', '0', '1');
INSERT INTO `product` VALUES ('50', 'Apple iPad Air 2 MGLW2CH/A', '2399', '2299', 'products/1/c_0050.jpg', '2015-11-12', '0', '（9.7英寸 16G WLAN 机型 银色）', '0', '2');
INSERT INTO `product` VALUES ('6', '魅族 MX5 16GB 银黑色', '1899', '1799', 'products/1/c_0006.jpg', '2015-11-02', '0', '魅族 MX5 16GB 银黑色 移动联通双4G手机 双卡双待送原厂钢化膜+保护壳+耳机！5.5英寸大屏幕，3G运行内存，2070万+500万像素摄像头！长期省才是真的省！', '0', '1');
INSERT INTO `product` VALUES ('7', '三星 Galaxy On7', '1499', '1398', 'products/1/c_0007.jpg', '2015-11-14', '0', '三星 Galaxy On7（G6000）昂小七 金色 全网通4G手机 双卡双待新品火爆抢购中！京东尊享千元良机！5.5英寸高清大屏！1300+500W像素！评价赢30元话费券！', '0', '1');
INSERT INTO `product` VALUES ('8', 'NUU NU5', '1288', '1190', 'products/1/c_0008.jpg', '2015-11-02', '0', 'NUU NU5 16GB 移动联通双4G智能手机 双卡双待 晒单有礼 晨光金香港品牌 2.5D弧度前后钢化玻璃 随机附赠手机套+钢化贴膜 晒单送移动电源+蓝牙耳机', '0', '1');
INSERT INTO `product` VALUES ('9', '乐视（Letv）乐1pro（X800）', '2399', '2299', 'products/1/c_0009.jpg', '2015-11-02', '0', '乐视（Letv）乐1pro（X800）64GB 金色 移动联通4G手机 双卡双待乐视生态UI+5.5英寸2K屏+高通8核处理器+4GB运行内存+64GB存储+1300万摄像头！', '0', '1');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uid` varchar(50) NOT NULL,
  `username` varchar(20) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `code` varchar(64) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('373eb242933b4f5ca3bd43503c34668b', 'ccc', 'ccc', 'aaa', 'bbb@store.com', '15723689921', '2015-11-04', '男', '0', '9782f3e837ff422b9aee8b6381ccf927bdd9d2ced10d48f4ba4b9f187edf7738', null);
INSERT INTO `user` VALUES ('3ca76a75e4f64db2bacd0974acc7c897', 'bb', 'bb', '张三', 'bbb@store.com', '15723689921', '1990-02-01', '男', '0', '1258e96181a9457987928954825189000bae305094a042d6bd9d2d35674684e6', null);
INSERT INTO `user` VALUES ('62145f6e66ea4f5cbe7b6f6b954917d3', 'cc', 'cc', '张三', 'bbb@store.com', '15723689921', '2015-11-03', '男', '0', '19f100aa81184c03951c4b840a725b6a98097aa1106a4a38ba1c29f1a496c231', null);
INSERT INTO `user` VALUES ('67305618-b58e-4b8d-9a97-a918a3ac20d1', 'lisi', '123456', '李四', '516464@faf.com', '15464665', '2017-06-14', '女', '0', null, '广东创新职院');
INSERT INTO `user` VALUES ('769dbdf9-e4d3-423e-9f14-d37f5b0f77fa', '111', '111', 'bbb', '111@136.com', '1111', '2011-01-11', '女', '0', null, '');
INSERT INTO `user` VALUES ('c95b15a864334adab3d5bb6604c6e1fc', 'bbb', 'bbb', '老王', 'bbb@store.com', '15712344823', '2000-02-01', '男', '0', '71a3a933353347a4bcacff699e6baa9c950a02f6b84e4f6fb8404ca06febfd6f', null);
INSERT INTO `user` VALUES ('f55b7d3a352a4f0782c910b2c70f1ea4', 'aaa', 'aaa', '小王', 'aaa@store.com', '15712344823', '2000-02-01', '男', '1', null, null);