/*
 Navicat MySQL Data Transfer

 Source Server         : str
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : book

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 18/09/2021 13:48:13
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `adminId` int NOT NULL COMMENT '主键',
  `adminName` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '管理员名称',
  `adminPwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '管理员密码',
  PRIMARY KEY (`adminId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '无爱', '40bd001563085fc35165329ea1ff5c5ecbdbbeef');
INSERT INTO `admin` VALUES (2, '陈', '40bd001563085fc35165329ea1ff5c5ecbdbbeef');
INSERT INTO `admin` VALUES (3, '冯', '40bd001563085fc35165329ea1ff5c5ecbdbbeef');

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book`  (
  `bid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `bname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书名称',
  `author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者',
  `price` decimal(8, 2) NULL DEFAULT NULL COMMENT '定价',
  `press` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版社',
  `publishtime` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版时间',
  `cid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属分类ID',
  `image_b` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小图路径',
  `orderBy` int NOT NULL AUTO_INCREMENT COMMENT '序号，用来排序',
  `salesvol` int NULL DEFAULT NULL,
  PRIMARY KEY (`bid`) USING BTREE,
  INDEX `orderBy`(`orderBy`) USING BTREE,
  INDEX `FK_t_book_t_category`(`cid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 108 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('000A18FDB38F470DBE9CD0972BADB23F', 'Java Web整合开发实战$基于Struts 2+Hibernate+Spring（99个应用实例，4个项目开发案例，15.5小时配套教学视频，超值DVD光盘含大量开发资源。一本书搞定SSH框架整合开发！）', '贾蓓', 79.80, '清华大学出版社', '2013-7-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23268958-1_b.jpg', 16, 90);
INSERT INTO `book` VALUES ('0BE0707984014E66BD9F34F534FCE0F7', 'OSGi实战$【OSGi规范制定者亲自撰写 汇集Apache项目技术实战经验】', 'Richard', 99.00, '人民邮电出版社', '2013-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22938396-1_b.jpg', 58, 18);
INSERT INTO `book` VALUES ('0EE8A0AE69154287A378FB110FF2C780', 'Java核心技术$：卷Ⅰ基础知识（原书第8版）', '昊斯特曼', 98.00, '机械工业出版社', '2008-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20285763-1_b.jpg', 12, 54);
INSERT INTO `book` VALUES ('113D0D1BB9174DD19A7DE7E2B37F677F', 'Java7入门经典$（跟编程导师Ivor Horton学Java 预计到货日期9月初）', '霍尔顿', 118.00, '清华大学出版社', '2012-8-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22813026-1_b.jpg', 94, 23);
INSERT INTO `book` VALUES ('1286B13F0EA54E4CB75434762121486A', 'Java核心技术 $卷I：基础知识(第9版·英文版)(上、下册)', '霍斯特曼', 109.00, '人民邮电出版社', '2013-7-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23280479-1_b.jpg', 65, 11);
INSERT INTO `book` VALUES ('13EBF9B1FDE346A683A1C45BD6773ECB', 'Java开发实战1200例$（第Ⅱ卷）（史上最全的“编程实例”类图书，代码分析、实例速查、练习巩固的绝好帮手）', '无', 99.00, '清华大学出版社', '0', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/21110930-1_b.jpg', 83, 76);
INSERT INTO `book` VALUES ('1A15DC5E8A014A58862ED741D579B530', 'Java深入解析$——透析Java本质的36个话题', '梁勇', 49.00, '电子工业出版社', '2013-11-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23363997-1_b.jpg', 86, 49);
INSERT INTO `book` VALUES ('210A3DCA429049C78B623C3986BEB136', 'JavaScript经典教程套装$：JavaScript高级程序设计(第3版)+JavaScript DOM编程艺术(第2版)(套装共2册)(超值附赠《码农》光盘1张)', 'Nicholas C. Zakas', 148.00, '人民邮电出版社', '2013-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23224089-1_b.jpg', 93, 47);
INSERT INTO `book` VALUES ('22234CECF15F4ECB813F0B433DDA5365', 'JavaScript从入门到精通$（附光盘1张）（连续8月JavaScript类全国零售排行前2名，13小时视频，400个经典实例、369项面试真题、138项测试史上最全资源库）', '明日科技', 69.80, '清华大学出版社', '2012-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22862057-1_b.jpg', 20, 30);
INSERT INTO `book` VALUES ('230A00EC22BF4A1DBA87C64800B54C8D', 'Struts2技术内幕$：深入解析Struts架构设计与实现原理', '陆舟', 69.00, '机械工业出版社', '2012-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22577578-1_b.jpg', 56, 20);
INSERT INTO `book` VALUES ('260F8A3594F741C1B0EB69616F65045B', 'Tomcat与Java Web开发技术详解$（第2版）(含光盘1张)', '孙卫琴', 79.50, '电子工业出版社', '2009-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20420983-1_b.jpg', 74, 68);
INSERT INTO `book` VALUES ('28A03D28BAD449659A77330BE35FCD65', 'JAVA核心技术卷II$：高级特性（原书第8版）', '霍斯特曼', 118.00, '机械工业出版社', '2008-12-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20446562-1_b.jpg', 18, 43);
INSERT INTO `book` VALUES ('2EE1A20A6AF742E387E18619D7E3BB94', 'Java虚拟机并发编程$(Java并发编程领域的里程碑之作，资深Java技术专家、并发编程专家、敏捷开发专家和Jolt大奖得主撰写，Amazon五星畅销书)', 'Venkat Subramaniam', 59.00, '机械工业出版社', '2013-5-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23239786-1_b.jpg', 54, 22);
INSERT INTO `book` VALUES ('33ACF97A9A374352AE9F5E89BB791262', '基于MVC的JavaScript$ Web富应用开发$', '麦卡劳', 59.00, '电子工业出版社', '2012-5-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22757564-1_b.jpg', 34, 34);
INSERT INTO `book` VALUES ('37F75BEAE1FE46F2B14674923F1E7987', '数据结构与算法分析$Java语言描述 第2版', '韦斯', 55.00, '机械工业出版社', '2009-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20417467-1_b.jpg', 32, 32);
INSERT INTO `book` VALUES ('39F1D0803E8F4592AE1245CACE683214', 'Java程序员修炼之道$', '埃文斯', 89.00, '人民邮电出版社', '2013-8-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23301847-1_b.jpg', 36, 57);
INSERT INTO `book` VALUES ('3AE5C8B976B6448A9D3A155C1BDE12BC', '深入理解Java虚拟机$:JVM高级特性与最佳实践（超级畅销书，6个月5次印刷，从实践角度解析JVM工作原理，Java程序员必备）', '周志明', 69.00, '机械工业出版社', '0', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/21108671-1_b.jpg', 66, 47);
INSERT INTO `book` VALUES ('3DD187217BF44A99B86DD18A4DC628BA', 'Java核心技术$ 卷1 基础知识（原书第9版）', '霍斯特曼，科内尔', 119.00, '机械工业出版社', '2014-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23362142-1_b.jpg', 9, 80);
INSERT INTO `book` VALUES ('3E1990E19989422E9DA735978CB1E4CE', 'Effective Java中文版(第2版)$', '布洛克', 52.00, '机械工业出版社', '2009-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20459091-1_b.jpg', 25, 423);
INSERT INTO `book` VALUES ('400D94DE5A0742B3A618FC76DF107183', 'JavaScript宝典（第7版）$（配光盘）', '古德曼', 128.00, '清华大学出版社', '2013-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23169892-1_b.jpg', 88, 32);
INSERT INTO `book` VALUES ('4491EA4832E04B8B94F334B71E871983', 'Java语言程序设计$：进阶篇（原书第8版）', '梁勇', 79.00, '机械工业出版社', '2011-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/21117631-1_b.jpg', 48, 43);
INSERT INTO `book` VALUES ('48BBFBFC07074ADE8CC906A45BE5D9A6', 'JavaScript权威指南（第6版）$（淘宝前端团队倾情翻译！经典权威的JavaScript犀牛书！第6版特别涵盖了HTML5和ECMAScript5！）（经典巨著，当当独家首发）', '弗兰纳根', 139.00, '机械工业出版社', '2012-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22722790-1_b.jpg', 4, 59);
INSERT INTO `book` VALUES ('49D98E7916B94232862F7DCD1B0BAB66', 'HTML5+JavaScript动画基础$', '兰贝塔', 69.00, '人民邮电出版社', '2013-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23266633-1_b.jpg', 51, 25);
INSERT INTO `book` VALUES ('4A9574F03A6B40C1B2A437237C17DEEC', 'Spring实战(第3版)$（In Action系列中最畅销的Spring图书，近十万读者学习Spring的共同选择）', 'Craig Walls', 59.00, '人民邮电出版社', '2013-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23254532-1_b.jpg', 11, 42);
INSERT INTO `book` VALUES ('4BF6D97DD18A4B77B8DED9B057577F8F', 'Java Web从入门到精通$（附光盘1张）（连续8月Java类全国零售排行前2名，27小时视频，951个经典实例、369项面试真题、596项测试史上最全资源库）', '明日科技', 69.80, '清华大学出版社', '2012-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22862056-1_b.jpg', 23, 26);
INSERT INTO `book` VALUES ('4C3331CAD5A5453787A94B8D7CCEAA29', 'Java Web整合开发王者归来$（JSP+Servlet+Struts+Hibernate+Spring）（配光盘', '刘京华', 99.80, '清华大学出版社', '2010-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20756351-1_b_1.jpg', 17, 0);
INSERT INTO `book` VALUES ('4C696BB1A1E44792ADD2293A640BFAA3', '天龙八部', '金庸大大', 40.70, '人民邮电出版社', '2013-6-1', '75CA11D9AC7F4F8D91E22023E8668800', 'book_img/F2232B99DEC84A718EA72DB9745E78E4_13123_b.jpg', 97, NULL);
INSERT INTO `book` VALUES ('4D20D2450B084113A331D909FF4975EB', 'jQuery实战(第2版)$(畅销书升级版，掌握Web开发利器必修宝典)', 'Bear Bibeault　Yehuda Katz ', 69.00, '人民邮电出版社', '2012-3-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22638286-1_b.jpg', 79, 67);
INSERT INTO `book` VALUES ('4E44405DAFB7413E8A13BBFFBEE73AC7', 'JavaScript经典实例$', '鲍尔斯', 78.00, '中国电力出版社', '2012-3-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22692811-1_b.jpg', 68, 54);
INSERT INTO `book` VALUES ('504FB999B0444B339907090927FDBE8A', '深入浅出ExtJS(第3版)$', '徐会生', 69.00, '人民邮电出版社', '2013-10-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23351049-1_b.jpg', 71, 34);
INSERT INTO `book` VALUES ('52077C8423B645A9BADA96A5E0B14422', 'Spring源码深度解析$', '郝佳', 69.00, '人民邮电出版社', '2013-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23329703-1_b.jpg', 52, 24);
INSERT INTO `book` VALUES ('52B0EDFF966E4A058BDA5B18EEC698C4', '亮剑Java Web项目开发案例导航$(含DVD光盘1张)', '朱雪琴', 69.00, '电子工业出版社', '2012-3-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22623766-1_b.jpg', 81, 43);
INSERT INTO `book` VALUES ('5315DA60D24042889400AD4C93A37501', 'Spring 3.x企业应用开发实战$(含CD光盘1张)', '陈雄华', 90.00, '电子工业出版社', '2012-2-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22605701-1_b.jpg', 24, 94);
INSERT INTO `book` VALUES ('54DBDE68FB9B4397A0714FB9AEFC4261', 'guo', 'Craig Walls', 9.00, '人民邮电出版社', '2013-6-1', '2', 'book_img/D9FC394C46BF4FCFB43FB7D0DB0C6FC0_.jpg', 106, NULL);
INSERT INTO `book` VALUES ('56B1B7D8CD8740B098677C7216A673C4', '疯狂 Java 程序员的基本修养$（《疯狂Java讲义》最佳拍档，扫清知识死角，夯实基本功）', '李刚', 59.00, '电子工业出版社', '2013-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23042420-1_b.jpg', 89, 73);
INSERT INTO `book` VALUES ('57B6FF1B89C843C38BA39C717FA557D6', '了不起的Node.js$: 将JavaScript进行到底（Web开发首选实时 跨多服务器 高并发）', 'Guillermo Rauch', 79.00, '电子工业出版社', '2014-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23368351-1_b.jpg', 8, 589);
INSERT INTO `book` VALUES ('5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通$（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', '明日科技', 59.80, '清华大学出版社', '2012-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22862060-1_b.jpg', 1, 2);
INSERT INTO `book` VALUES ('5C68141786B84A4CB8929A2415040739', 'JavaScript高级程序设计$(第3版)(JavaScript技术名著，国内JavasScript第一书，销量超过8万册)', 'Nicholas C. Zakas', 99.00, '人民邮电出版社', '2012-3-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22628333-1_b.jpg', 5, 43);
INSERT INTO `book` VALUES ('5EDB981339C342ED8DB17D5A198D50DC', 'Java程序性能优化$', '葛一鸣', 59.00, '清华大学出版社', '2012-10-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22881618-1_b.jpg', 27, 34);
INSERT INTO `book` VALUES ('6398A7BA400D40258796BCBB2B256068', 'JavaScript设计模式$', 'Addy Osmani', 49.00, '人民邮电出版社', '2013-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23266635-1_b.jpg', 40, 675);
INSERT INTO `book` VALUES ('676B56A612AF4E968CF0F6FFE289269D', 'JavaScript和jQuery实战手册$（原书第2版）', '麦克法兰', 99.00, '机械工业出版社', '2013-3-11', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23201813-1_b.jpg', 42, 32);
INSERT INTO `book` VALUES ('7917F5B19A0948FD9551932909328E4E', 'Java项目开发案例全程实录$（第2版）（配光盘）（软件项目开发全程实录丛书）', '明日科技', 69.80, '清华大学出版社', '2011-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20991549-1_b.jpg', 64, 12);
INSERT INTO `book` VALUES ('7C0C785FFBEC4DEC802FA36E8B0BC87E', '深入分析Java Web技术内幕$', '许令波', 69.00, '电子工业出版社', '2012-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22881803-1_b.jpg', 50, 26);
INSERT INTO `book` VALUES ('7CD79C20258F477AB841518D9312E843', 'Java程序员面试宝典$（第三版）', '欧立奇', 49.00, '电子工业出版社', '2013-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23348683-1_b.jpg', 44, 65);
INSERT INTO `book` VALUES ('7D7FE81293124793BDB2C6FF1F1C943D', '21天学通Java$(第6版)（中文版累计销量超30000册）', 'Rogers Cadenhead', 55.00, '人民邮电出版社', '2013-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23219731-1_b.jpg', 46, 98);
INSERT INTO `book` VALUES ('7FD7F50B15F74248AA769798909F8653', 'Java网络编程$（第3版）——O’Reilly Java系列', '哈诺德', 85.00, '中国电力出版社', '2005-11-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/9062293-1_b.jpg', 35, 34);
INSERT INTO `book` VALUES ('819FF56E4423462394E6F83882F78975', '学通Java Web的24堂课$（配光盘）（软件开发羊皮卷）', '陈丹丹', 79.80, '清华大学出版社', '2011-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/21118835-1_b.jpg', 91, 45);
INSERT INTO `book` VALUES ('81FADA99309342F4978D5C680B0C6E8C', 'Java入门很简单$（配光盘）（入门很简单丛书）（打开Java编程之门 Java技术网推荐）', '李世民', 59.80, '清华大学出版社', '2012-8-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22839309-1_b.jpg', 85, 432);
INSERT INTO `book` VALUES ('89A57D099EA14026A5C3D10CFC10C22C', 'Java 2实用教程$（第4版）（21世纪高等学校计算机基础实用规划教材）', '耿祥义', 39.50, '清华大学出版社', '2012-8-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22844118-1_b.jpg', 73, 67);
INSERT INTO `book` VALUES ('8A5B4042D5B14D6B87A34DABF327387F', 'Java核心技术$ 卷II：高级特性(第9版·英文版)(上、下册)', '霍斯特曼', 119.00, '人民邮电出版社', '2013-7-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23280478-1_b.jpg', 57, 19);
INSERT INTO `book` VALUES ('8DD0ADF2665B40899E09ED2983DC3F7B', 'jQuery权威指南$（被公认的权威的、易学的jQuery实战教程，多次重印，热销中）', '陶国荣', 59.00, '机械工业出版社', '2011-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/21006995-1_b.jpg', 75, 43);
INSERT INTO `book` VALUES ('8E16D59BA4C34374A68029AE877613C4', '轻量级Java EE企业应用实战$（第3版）：Struts 2＋Spring 3＋Hibernate整合开发(含CD光盘1张)', '李刚', 99.00, '电子工业出版社', '2012-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22685703-1_b.jpg', 6, 76);
INSERT INTO `book` VALUES ('8F1520F2CED94C679433B9C109E791CB', 'Java从入门到精通$（实例版）（附光盘1张）（连续8月Java类全国零售排行前2名，14小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', '明日科技', 69.80, '清华大学出版社', '2012-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22862061-1_b.jpg', 49, 76);
INSERT INTO `book` VALUES ('90E423DBE56042838806673DB3E86BD3', 'Spring技术内幕（第2版）$（畅销书全新升级，Spring类图书销量桂冠，从宏观和微观两个角度解析Spring架构设计和实现原理）', '计文柯', 69.00, '机械工业出版社', '2012-2-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22606836-1_b.jpg', 45, 56);
INSERT INTO `book` VALUES ('926B8F31C5D04F61A72F66679A0CCFFD', 'JavaScript编程精解$（华章程序员书库）（JavaScript之父高度评价并强力推荐，系统学习JS首选！）', '哈弗贝克', 49.00, '械工业出版社', '2012-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22873894-1_b.jpg', 70, 34);
INSERT INTO `book` VALUES ('95AACC68D64D4D67B1E33E9EAC22B885', 'Head First Java（中文版）$（JAVA经典畅销书 生动有趣 轻松学好JAVA）', '塞若', 79.00, '中国电力出版社', '2007-2-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/9265169-1_b.jpg', 13, 98);
INSERT INTO `book` VALUES ('97437DAD03FA456AA7D6154614A43B55', '网页制作从入门到精通$HTML、CSS、JavaScript（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', '刘西杰', 49.00, '人民邮电出版社', '2012-12-24', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22928649-1_b.jpg', 3, 23);
INSERT INTO `book` VALUES ('9923901FBF124623BC707920D8936BC8', 'JavaScript DOM编程艺术(第2版)$', '基思', 49.00, '人民邮电出版社', '2011-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/21049601-1_b.jpg', 28, 96);
INSERT INTO `book` VALUES ('99BF63AC12AD48FCB673F1820888964E', 'Java Web开发实战1200例$（第Ⅱ卷）（史上最全的“编程实例”类图书，代码分析、实例速查、练习巩固的绝好帮手）', '无', 99.00, '清华大学出版社', '0', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/21110929-1_b.jpg', 78, 97);
INSERT INTO `book` VALUES ('9D257176A6934CB79427CEC37E69249F', '疯狂Ajax讲义$（第3版）--jQuery/Ext JS/Prototype/DWR企业应用前端开发实战(含CD光盘1张)（畅销书升级版，企业应用前端开发实战指南）', '李刚', 79.00, '电子工业出版社', '2013-2-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23184673-1_b.jpg', 53, 23);
INSERT INTO `book` VALUES ('9FBD51A7C02D4F5B9862CD2EBBF5CA04', 'Flash ActionScript 3.0全站互动设计$', '刘欢 ', 69.80, '人民邮电出版社', '2012-10-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22886581-1_b.jpg', 96, 106);
INSERT INTO `book` VALUES ('9FF423101836438F874035A48498CF45', 'Java编程思想$（英文版·第4版）', '埃克尔 ', 79.00, '机械工业出版社', '2007-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/9288920-1_b.jpg', 31, 56);
INSERT INTO `book` VALUES ('A3D464D1D1344ED5983920B472826730', 'Java Web开发详解$：XML+DTD+XML Schema+XSLT+Servlet 3 0+JSP 2 2深入剖析与实例应用(含CD光盘1张)', '孙鑫', 119.00, '电子工业出版社', '2012-5-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22788412-1_b.jpg', 60, 16);
INSERT INTO `book` VALUES ('A46A0F48A4F649AE9008B38EA48FAEBA', 'Java编程全能词典$(含DVD光盘2张)', '明日科技', 98.00, '电子工业出版社', '2010-3-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20813806-1_b.jpg', 90, 103);
INSERT INTO `book` VALUES ('A5A6F27DCD174614850B26633A0B4605', 'JavaScript模式$', '斯特凡洛夫', 38.00, '中国电力出版社', '2012-7-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22819430-1_b.jpg', 61, 15);
INSERT INTO `book` VALUES ('A7220EF174704012830E066FDFAAD4AD', 'Spring 3.0就这么简单$（国内原创的Java敏捷开发图书，展现作者Spring原创开源项目ROP开发的全过程，所有项目工程均以Maven组织）', '陈雄华', 59.00, '人民邮电出版社', '2013-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22938474-1_b.jpg', 77, 49);
INSERT INTO `book` VALUES ('A7EFD99367C9434682A790635D3C5FDF', 'Java Web技术整合应用与项目实战$（JSP+Servlet+Struts2+Hibernate+Spring3）', '张志锋', 98.00, '清华大学出版社', '2013-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23266270-1_b.jpg', 92, 104);
INSERT INTO `book` VALUES ('A8EF76FD21A645109538614DEA85F3F7', 'Java语言程序设计$：基础篇（原书第8版）', '梁勇', 75.00, '机械工业出版社', '2011-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/21122188-1_b.jpg', 30, 59);
INSERT INTO `book` VALUES ('AD6EA79CCB8240AAAF5B292AD7E5DCAA', 'jQuery Mobile权威指南$（根据jQuery Mobile最新版本撰写的权威参考书！全面讲解jQuery Mobile的所有功能、特性、使用方法和开发技巧）', '陶国荣', 59.00, '机械工业出版社', '2012-8-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22847009-1_b.jpg', 38, 34);
INSERT INTO `book` VALUES ('AE0935F13A214436B8599DE285A86220', 'JavaScript基础教程$(第8版)(经典JavaScript入门书 涵盖Ajax和jQuery)', 'Tom Negrino　Dori Smith', 69.00, '人民邮电出版社', '2012-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22717349-1_b.jpg', 37, 95);
INSERT INTO `book` VALUES ('AF28ED8F692C4288B32CF411CBDBFC23', '经典Java EE企业应用实战$——基于WebLogic/JBoss的JSF+EJB 3+JPA整合开发(含CD光盘1张)', '无', 79.00, '电子工业出版社', '2010-8-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20928547-1_b.jpg', 55, 21);
INSERT INTO `book` VALUES ('B329A14DDEF8455F82B3FDF25821D2BB', '名师讲坛—Java Web开发实战经典基础篇$（JSP、Servlet、Struts、Ajax）（32小时全真课堂培训，视频超级给力！390项实例及分析，北京魔乐科技培训中心Java Web全部精华）', '李兴华', 69.80, '清华大学出版社', '2010-8-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20915948-1_b.jpg', 22, 24);
INSERT INTO `book` VALUES ('B7A7DA7A94E54054841EED1F70C3027C', '锋利的jQuery(第2版)$(畅销书升级版，增加jQuery Mobile和性能优化)', '单东林', 49.00, '人民邮电出版社', '2012-7-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22786088-1_b.jpg', 10, 89);
INSERT INTO `book` VALUES ('BD1CB005E4A04DCA881DA8689E21D4D0', 'jQuery UI开发指南$', 'Eric Sarrion', 39.00, '人民邮电出版社', '2012-12-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22910975-1_b.jpg', 63, 13);
INSERT INTO `book` VALUES ('C23E6E8A6DB94E27B6E2ABD39DC21AF5', 'JavaScript:The Good Parts(影印版）$', '克罗克福特', 28.00, '东南大学出版社', '2009-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20412979-1_b.jpg', 95, 105);
INSERT INTO `book` VALUES ('C3CF52B3ED2D4187A16754551488D733', 'Java从入门到精通$（附光盘）', '魔乐科技', 59.00, '人民邮电出版社', '2010-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20810282-1_b.jpg', 29, 57);
INSERT INTO `book` VALUES ('C86D3F6FACB449BEBD940D9307ED4A47', '编写高质量代码：改善Java程序的151个建议$(从语法、程序设计和架构、工具和框架、编码风格、编程思想5个方面探讨编写高质量Java代码的技巧、禁忌和最佳实践)', '秦小波', 59.00, '机械工业出版社', '2012-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22579686-1_b.jpg', 84, 100);
INSERT INTO `book` VALUES ('CB0AB3654945411EA69F368D0EA91A00', 'JavaScript语言精粹$（修订版）', '道格拉斯·克罗克福德', 49.00, '电子工业出版社', '2012-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22872884-1_b.jpg', 33, 21);
INSERT INTO `book` VALUES ('CD913617EE964D0DBAF20C60076D32FB', '名师讲坛Java开发实战经典$（配光盘）（60小时全真课堂培训，视频超级给力！790项实例及分析，北京魔乐科技培训中心Java全部精华）', '李兴华', 79.80, '清华大学出版社', '2009-8-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20637368-1_b_2.jpg', 19, 12);
INSERT INTO `book` VALUES ('CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想$（第4版）', '布鲁斯.艾克尔', 108.00, '机械工业出版社', '2007-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/9317290-1_b.jpg', 2, 90);
INSERT INTO `book` VALUES ('CF5546769F2842DABB2EF7A00D51F255', 'jQuery开发从入门到精通$（配套视频327节，中小实例232个，实战案例7个商品详情手册11部，网页模版83类）（附1DVD）', '袁江', 79.80, '清华大学出版社', '2013-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23263012-1_b.jpg', 43, 24);
INSERT INTO `book` VALUES ('D0DA36CEE42549FFB299B7C7129761D5', 'Java应用架构设计$：模块化模式与OSGi(全球资深Java技术专家的力作，系统、全面地讲解如何将模块化设计思想引入开发中，涵盖18个有助于实现模块化软件架构的模式)', '克内恩席尔德', 69.00, '机械工业出版社', '2013-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23339643-1_b.jpg', 26, 459);
INSERT INTO `book` VALUES ('D0E69F85ACAB4C15BB40966E5AA545F1', 'Java并发编程实战$（第16届Jolt大奖提名图书，Java并发编程必读佳作', 'Brian Goetz', 69.00, '机械工业出版社', '2012-2-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22606835-1_b.jpg', 15, 79);
INSERT INTO `book` VALUES ('D2ABA8B06C524632846F27C34568F3CE', 'Java 经典实例$', '达尔文', 98.00, '中国电力出版社', '2009-2-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20500255-1_b.jpg', 62, 14);
INSERT INTO `book` VALUES ('D8723405BA054C13B52357B8F6AEEC24', '深入理解Java虚拟机$：JVM高级特性与最佳实践$（第2版）', '周志明', 79.00, '机械工业出版社', '2013-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23259731-1_b.jpg', 14, 12);
INSERT INTO `book` VALUES ('DC36FD53A1514312A0A9ADD53A583886', 'JavaScript异步编程：设计快速响应的网络应用$【掌握JavaScript异步编程必杀技，让代码更具响应度！ 】', 'Trevor Burnham ', 32.00, '人民邮电出版社', '2013-6-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23252196-1_b.jpg', 72, 47);
INSERT INTO `book` VALUES ('DCB64DF0084E486EBF173F729A3A630A', 'Java设计模式$(第2版)', 'Steven John Metsker', 75.00, '电子工业出版社', '2012-9-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22868759-1_b.jpg', 76, 34);
INSERT INTO `book` VALUES ('DEE7BDC7E0E343149E3C3601D2658171', '疯狂HTML 5/CSS 3/JavaScript讲义$(含CD光盘1张)', '李刚', 69.00, '电子工业出版社', '2012-5-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22783904-1_b.jpg', 21, 98);
INSERT INTO `book` VALUES ('DF4E74EEE89B43229BB8212F0B858C38', '精通Hibernate：Java对象持久化技术详解$（第2版）(含光盘1张)', '孙卫琴', 75.00, '电子工业出版社', '2010-2-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20773347-1_b.jpg', 39, 25);
INSERT INTO `book` VALUES ('E4F184188C8B4C7BB32D4E76603426AC', '疯狂Java讲义$（第2版，附光盘）', '李刚', 109.00, '电子工业出版社', '2012-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22588603-1_b.jpg', 7, 98);
INSERT INTO `book` VALUES ('EA695342393C4BE48B831FA5E6B0E5C4', '编写可维护的JavaScript《JavaScript高级程序设计》$作者Nicholas Zakas最新力作，构建编码风格手册，帮助开发团队从“游击队”走向“正规军”）', 'Nicholas C. Zakas', 55.00, '人民邮电出版社', '2013-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23200995-1_b.jpg', 59, 17);
INSERT INTO `book` VALUES ('F0E34313BF304CCEBF198BD4E05307B8', 'jQuery Cookbook中文版$（jQuery之父鼎力推荐，社区数十位专家倾情力作', 'jQuery社区专家组', 69.00, '人民邮电出版社', '2013-5-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23219358-1_b.jpg', 87, 101);
INSERT INTO `book` VALUES ('F6162799E913423EA5CB57BEC65AB1E9', 'JUnit实战$(第2版)', '塔凯文', 79.00, '人民邮电出版社', '2012-4-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22633574-1_b.jpg', 80, 98);
INSERT INTO `book` VALUES ('F693239BC3B3444C8538ABE7411BB38E', 'Java Web典型模块与项目实战大全$（配光盘）', '常建功', 99.50, '清华大学出版社', '2011-1-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/20988080-1_b.jpg', 41, 59);
INSERT INTO `book` VALUES ('F78C94641DB4475BBA1E72A07DF9B3AE', 'JAVA面向对象编程$', '孙卫琴 ', 65.80, '电子工业出版社', '2006-7-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/9186890-1_b.jpg', 69, 19);
INSERT INTO `book` VALUES ('FC232CD9B6E6411BBBB1A5B781D2C3C9', 'Java与模式$(含盘)（超多实例和习题，详解设计原则与设计模式）', '阎宏', 88.00, '电子工业出版社', '2002-10-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/696673-1_b.jpg', 67, 21);
INSERT INTO `book` VALUES ('FEC3740CF30E442A94021911A25EF0D7', 'Spring攻略(第2版)$(Spring攻略(第2版))', 'Gary Mak　Josh Long　Daniel Rubio', 128.00, '人民邮电出版社', '2012-3-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/22623020-1_b.jpg', 82, 99);
INSERT INTO `book` VALUES ('FFABBED1E5254BC0B2726EC4ED8ACCDA', '深入理解OSGi$：Equinox原理、应用与最佳实践（《深入理解Java虚拟机》作者新作！全面解读最新OSGi R5.0规范，深入讲解OSGi原理和服务，以及Equinox框架的用法和原理）', '周志明', 79.00, '机械工业出版社', '2013-2-1', '5F79D0D246AD4216AC04E9C5FAB3199E', 'book_img/23179003-1_b.jpg', 47, 657);

-- ----------------------------
-- Table structure for booktype
-- ----------------------------
DROP TABLE IF EXISTS `booktype`;
CREATE TABLE `booktype`  (
  `cid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `cname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称',
  `desc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类描述',
  `orderBy` int NOT NULL AUTO_INCREMENT COMMENT '序号，用来排序',
  PRIMARY KEY (`cid`) USING BTREE,
  UNIQUE INDEX `cname`(`cname`) USING BTREE,
  INDEX `orderBy`(`orderBy`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of booktype
-- ----------------------------
INSERT INTO `booktype` VALUES ('2', '办公室用书2', '办公室用书', 2);
INSERT INTO `booktype` VALUES ('3', '图形 图像 多媒体', '图形图像多媒体', 3);
INSERT INTO `booktype` VALUES ('4', '操作系统/系统开发', '操作系统/系统开发', 4);
INSERT INTO `booktype` VALUES ('458795C27E7346A8A5F1B942319297E0', '系统开发', '系统开发分类', 29);
INSERT INTO `booktype` VALUES ('4D01FFF0CB94468EA907EF42780668AB', '购买指南 组装指南 维修', '购买指南 组装指南 维修分类', 18);
INSERT INTO `booktype` VALUES ('5', '数据库', '数据库', 5);
INSERT INTO `booktype` VALUES ('56AD72718C524147A2485E5F4A95A062', '3DS MAX', '3DS MAX分类', 21);
INSERT INTO `booktype` VALUES ('57DE3C2DDA784B81844029A28217698C', 'Dreamweaver', 'Dreamweaver分类', 24);
INSERT INTO `booktype` VALUES ('5F79D0D246AD4216AC04E9C5FAB3199E', 'Java Javascript', 'Java Javascript分类', 10);
INSERT INTO `booktype` VALUES ('6', '网络与数据通讯', '网络与数据通讯', 6);
INSERT INTO `booktype` VALUES ('65640549B80E40B1981CDEC269BFFCAD', 'Photoshop', 'Photoshop分类', 20);
INSERT INTO `booktype` VALUES ('65830AB237EF428BAE9B7ADC78A8D1F6', 'Unix', 'Unix分类', 28);
INSERT INTO `booktype` VALUES ('757BDAB506A445EC8DEDA4CE04303B9F', '网页设计', '网页设计分类', 22);
INSERT INTO `booktype` VALUES ('75CA11D9AC7F4F8D91E22023E8668800', '金庸武侠小说全集', 'This is some English books.', 37);
INSERT INTO `booktype` VALUES ('84ECE401C2904DBEA560D04A581A66D9', 'HTML XML', 'HTML XML分类', 13);
INSERT INTO `booktype` VALUES ('922E6E2DB04143D39C9DDB26365B3EE8', 'C C++ VC VC++', 'C C++ VC VC++分类', 12);
INSERT INTO `booktype` VALUES ('96F209F79DB242E9B99CC1B98FAB01DB', '数据库理论', '数据库理论分类', 33);
INSERT INTO `booktype` VALUES ('A9CFBED0F77746C5BD751F2502FAB2CD', '电子商务 电子政务', '电子商务 电子政务分类', 35);
INSERT INTO `booktype` VALUES ('B4708342491541A49BEADC43185BA3A9', '金庸武侠', '金庸武侠小说', 36);
INSERT INTO `booktype` VALUES ('B596ECE0F9BF40288F40A66B35551806', 'Flush', 'Flush分类', 23);
INSERT INTO `booktype` VALUES ('B92ED191DBE647BE8F75721FB231E207', '因特网 电子邮件', '因特网 电子邮件分类', 19);
INSERT INTO `booktype` VALUES ('C3F9FAAF4EA64857ACFAB0D9C8D0E446', 'PHP', 'PHP分类', 14);
INSERT INTO `booktype` VALUES ('C4DD8CA232864B31A367EE135D86382C', '计算机初级入门', '计算机初级入门分类', 17);
INSERT INTO `booktype` VALUES ('C8E274EE5C99499080A98E24F0BD2E03', '.NET', '.NET分类', 15);
INSERT INTO `booktype` VALUES ('D45D96DA359A4FEAB3AB4DCF2157FC06', 'JSP', 'JSP分类', 11);
INSERT INTO `booktype` VALUES ('DCAD0384A6444C048951C7B36C5D96EE', 'Flash', 'Flash分类', 25);
INSERT INTO `booktype` VALUES ('E9C537D12E7646E5A9E4BBEC7D5C5A8A', '程序设计', '程序设计分类', 39);
INSERT INTO `booktype` VALUES ('F4FBD087EB054CA1896093F172AC33D9', '数据仓库与数据挖掘', '数据仓库与数据挖掘分类', 30);
INSERT INTO `booktype` VALUES ('F5C091B3967442A2B35EFEFC4EF8746F', '微软Office', '微软Office分类', 16);
INSERT INTO `booktype` VALUES ('FAB7B7F7084F4D57A0808ADC61117683', 'Windows', 'Windows分类', 26);

-- ----------------------------
-- Table structure for cartitem
-- ----------------------------
DROP TABLE IF EXISTS `cartitem`;
CREATE TABLE `cartitem`  (
  `cartItemId` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `quantity` int NULL DEFAULT NULL COMMENT '数量',
  `bid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书ID',
  `uid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',
  `orderBy` int NOT NULL AUTO_INCREMENT COMMENT '序号，用来排序',
  PRIMARY KEY (`cartItemId`) USING BTREE,
  INDEX `orderBy`(`orderBy`) USING BTREE,
  INDEX `FK_t_cartitem_t_user`(`uid`) USING BTREE,
  INDEX `FK_t_cartitem_t_book`(`bid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of cartitem
-- ----------------------------
INSERT INTO `cartitem` VALUES ('0C5EE5EDFD89486EA98260771CB2FC89', 3, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'xxx', 18);
INSERT INTO `cartitem` VALUES ('270E69BE51AC47A883DE355666E7350B', 1, 'CE01F15D435A4C51B0AD8202A318DCA7', 'xxx', 22);
INSERT INTO `cartitem` VALUES ('6363C796EF6741E3B715DE6382A2715F', 1, '97437DAD03FA456AA7D6154614A43B55', 'xxx', 19);

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order`  (
  `oid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `ordertime` date NULL DEFAULT NULL COMMENT '下单时间',
  `total` decimal(10, 2) NULL DEFAULT NULL COMMENT '合计金额',
  `status` int NULL DEFAULT NULL COMMENT '订单状态',
  `address` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收获地址',
  `uid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',
  PRIMARY KEY (`oid`) USING BTREE,
  INDEX `FK_t_order_t_user`(`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of order
-- ----------------------------
INSERT INTO `order` VALUES ('058F48DA33694C6D8F5C2C13F3D26CEA', '2013-12-26', 95.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('065056EFA3914273B6B266A2414A38FA', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('0A1F4C5BDE754277B984D1E7E763051D', '2014-01-16', 41.30, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('0AA6D2E046DB4EF2804C90EF6F7C2429', '2016-11-18', 148.70, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('0ADCEE0510844D2697E7A5C0903A8D3B', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('0B657B624D8D4B919B7E5F175AA90530', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('0CA1A9B0287C43B2AA9435F11F237E9B', '2014-02-06', 41.30, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('0CD9939DC9AE4DA2A12F772293F55A4B', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('0FBC5F415EF94161AF2937A07EFD8DE8', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('0FD72F77655D43E2B7989892E965864D', '2013-12-30', 88.70, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('148668BE43754CE2B64A0AC999C5A2D5', '2014-01-16', 148.70, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('159B58B3BBCB4069A550BF1A358B4905', '2014-02-07', 41.30, 3, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('15A89AB272394F359EA26A2E15F13405', '2013-12-30', 74.50, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('161A05BEBBAA468199131EAD175CCFEA', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('1AFEC52D72C74266A6E36F83F9910B4F', '2014-01-16', 74.50, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('1D640078E4A64AC987FEA7299B57A2F6', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('2AFD7DC9619548BA8727464D77AFB9C2', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('2D9FF0BFB82842CFAA4B623D5997BF1F', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('303E12F4821A4B3F9DB97B23947220C7', '2013-12-26', 82.10, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('3143492834294128ADCFD1DAC3530396', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('32739173C1E247558358B1A8FE9FE012', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('33D163070CE74936966AE177F3E09B20', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('35E47895604541258BDB95C79FAA0FF6', '2021-09-18', 99.00, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', 'xxx');
INSERT INTO `order` VALUES ('3F0B39529DBD48C2A542EEBDE7A6FA03', '2016-12-13', 108.30, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('49127E9642C5474FA8F2139204DE571C', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('4B49D55D2CD34DB480A2CDF1A78858E8', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('553AFF48D76A48AD89ED3FE8F7E2F587', '2013-12-26', 109.00, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('5668668DAB1F4406819D37881BC5D5B1', '2014-01-02', 95.30, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('57197A448F9A4F15B76B1ED1EB3A15E6', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('574A31876CA246D4A10C0600EF5CF8A5', '2014-02-06', 74.50, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('57856B1A295B437CA0F7991540897B47', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('59A15DD3A0704508B1C2BC9B682A329F', '2014-02-07', 68.30, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('5D39377E88E049F8BA19173BAFF295CB', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('5FB1E131DD294CBBA34FE93228DF2F02', '2014-01-16', 279.10, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('605B9D163C1345B6A636D80720794CE8', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('6504C742FE65413494E028E714D4D609', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('673170D78D9D4EE6AE083167CFB81C1A', '2014-02-06', 68.30, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('674878FE6CAB48918DB4A9688262FBD5', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('6C921E50C3E54EA0AFD8CC4B661963AD', '2014-02-07', 41.30, 3, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('7237A47B1B5B4A78822D662AE01671B6', '2014-02-08', 115.80, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('75B7D65D4F5A43CD83605FDE38D7E10C', '2014-01-01', 149.00, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('7858221EA1DF4B318A632A9C1CD3E1F7', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('7B3FA2910C9149829AB1EF3A39C4785F', '2013-12-31', 74.50, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('8BB662E4C0444BC88F1DBE82584595BC', '2013-12-31', 33.80, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('8FE1F57194DF430A8E3866C88756C6ED', '2016-12-08', 225.40, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('93576BB2F43C47F89B4DD7B91F5DF5E3', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('96C6D91D916E472681EEC37B1770DE87', '2013-12-31', 67.60, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('9721A3FBC37D490588AEE02F761744E2', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('984468779C164A6098A7FE7EECE9E273', '2014-01-16', 41.30, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('9E1C0A9FDF1F49B18FA0BFA33E132BDD', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('A2DB4A7B4EA640ADA63F22A7E8311F4B', '2014-01-16', 148.70, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('AC1336F20CD848F78A44D3409ED53393', '2021-09-18', 99.00, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', 'xxx');
INSERT INTO `order` VALUES ('B62C7C1BA61C47C4BCEC4BE96897A72C', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('B69C6849120D4B28A6CCF99351B88575', '2014-02-05', 366.00, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('BB7789E41C524030832B7E5E426633E7', '2014-02-05', 115.80, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('BD1BD9AB58B1413FA0BDC0AACCC8C65F', '2013-12-26', 81.40, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('BDB995AF80D34716ABB9D10CB6962F87', '2013-12-27', 32.90, 3, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('BE24BB4187B1472AA08E206BF8B0ABF7', '2013-12-30', 47.60, 3, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('C0841F4DFE7A43BFB183E4E82AE7914C', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('C3178A812ECE4629A6BE23F02416C4FD', '2016-12-15', 101.20, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('C34F025EF6BB4B88A8409B00A0ABC891', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('C411DDB464BF49C092117055C412A1CD', '2016-11-18', 273.20, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('C4A1E40F2F514684BCD97F9EE76A701F', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('C6F8379F9E3E4F8381763B54E5BF986C', '2014-02-07', 41.30, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('CBB735CB5F084C1BB80FF5998F811E63', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('CE537015382640E1AE15B9A8FD08B9EE', '2013-12-26', 41.30, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('D929BD17AB374B49B61B93AF9A194D1A', '2013-12-31', 82.10, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('DD5135AEDA2E464BAF52DEC4727E2A3D', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('E106BFE7029C485D95A124C733BCC539', '2014-01-16', 41.30, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('E36C274D315047BBB5704161115C2AF9', '2016-11-18', 150.40, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('E3A1EB6D0543489F9729B2B5BC5DB365', '2014-01-02', 115.50, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('E6EEEB39CECC4089BC65142BADCC4FC3', '2013-12-26', 73.60, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('E891D2A05DA6485EB7E12436E8FB3107', '2014-02-06', 162.90, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('E8AE477323214E99AB48BA38052BE974', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('EA4DC50E547149E3A48B14E6711DF1BD', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('EC3696A4C443494A9B8DD6E8A9B82072', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('ECB47FBA81F64751B7AC89CCB8DDFD09', '2014-02-06', 41.30, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('EDC9F39D490E424BA799E7BD4BED9D09', '2014-01-01', 74.50, 4, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('EE1F00D88FDC44BD966AF05C1F7FABE0', '2013-12-26', 68.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('F64FD5E198BB4114AB091034C5C6D8B7', '2014-01-16', 41.30, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('F7E603F5179348B9BC3417B9BFB8558D', '2014-02-07', 41.30, 2, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '531D8A16D524478D86F8A115FE95D93F');
INSERT INTO `order` VALUES ('FAC08EE0DF2C4487A6FA2B11B343307E', '2013-12-26', 340.70, 1, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', '32DB3700D2564254982BC58B0E4D95BC');
INSERT INTO `order` VALUES ('FEAC10AB4DE343CB87A6B4BF8BF3D3C6', '2016-11-18', 148.70, 5, '安徽省 蚌埠市 龙子湖区 大学城 陈某某', 'C7D439BB678B4FF2B293937A6877AB32');

-- ----------------------------
-- Table structure for orderitem
-- ----------------------------
DROP TABLE IF EXISTS `orderitem`;
CREATE TABLE `orderitem`  (
  `orderItemId` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `quantity` int NULL DEFAULT NULL COMMENT '数量',
  `subtotal` decimal(8, 2) NULL DEFAULT NULL COMMENT '小计',
  `bid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书ID',
  `bname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书名称',
  `currPrice` decimal(8, 2) NULL DEFAULT NULL COMMENT '图书当前价',
  `image_b` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书小图路径',
  `oid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属订单ID',
  PRIMARY KEY (`orderItemId`) USING BTREE,
  INDEX `FK_t_orderitem_t_order`(`oid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of orderitem
-- ----------------------------
INSERT INTO `orderitem` VALUES ('01D2DF3E5BB34E9F9D2477180C8D94D3', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'C0841F4DFE7A43BFB183E4E82AE7914C');
INSERT INTO `orderitem` VALUES ('01E58D4FB7964805A1557A5EF2677586', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '7B3FA2910C9149829AB1EF3A39C4785F');
INSERT INTO `orderitem` VALUES ('06AD3253E7EA415B828D1299462DE812', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '159B58B3BBCB4069A550BF1A358B4905');
INSERT INTO `orderitem` VALUES ('0844DB419E91407FAE223E3ED6B63707', 1, 82.10, '3DD187217BF44A99B86DD18A4DC628BA', 'Java核心技术 卷1 基础知识（原书第9版）', 82.10, 'book_img/23362142-1_b.jpg', 'D929BD17AB374B49B61B93AF9A194D1A');
INSERT INTO `orderitem` VALUES ('0AD49A1C760E4EA2B29ADC32E306C2D5', 1, 47.60, 'D0E69F85ACAB4C15BB40966E5AA545F1', 'Java并发编程实战（第16届Jolt大奖提名图书，Java并发编程必读佳作', 47.60, 'book_img/22606835-1_b.jpg', 'BD1BD9AB58B1413FA0BDC0AACCC8C65F');
INSERT INTO `orderitem` VALUES ('0F8620EDA20642D1B6CF6D2768086B0A', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'F7E603F5179348B9BC3417B9BFB8558D');
INSERT INTO `orderitem` VALUES ('0F8FCF81AE4D402892AD73C11477B971', 3, 204.90, '5C68141786B84A4CB8929A2415040739', 'JavaScript高级程序设计(第3版)(JavaScript技术名著，国内JavasScript第一书，销量超过8万册)', 68.30, 'book_img/22628333-1_b.jpg', '5FB1E131DD294CBBA34FE93228DF2F02');
INSERT INTO `orderitem` VALUES ('0FDE8F9F0C1D4B65AE470BC63783FBF5', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '984468779C164A6098A7FE7EECE9E273');
INSERT INTO `orderitem` VALUES ('10C2D433E7704AC6A0CB74EBDB1B0AEC', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'FAC08EE0DF2C4487A6FA2B11B343307E');
INSERT INTO `orderitem` VALUES ('1154012AEBB746A7B9CA7BD07B96C599', 2, 82.60, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通$（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '8FE1F57194DF430A8E3866C88756C6ED');
INSERT INTO `orderitem` VALUES ('14128D56EBDE44A2935F0D12EA5DBB03', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '574A31876CA246D4A10C0600EF5CF8A5');
INSERT INTO `orderitem` VALUES ('1B48E8AA75BC4F569306702A33A7CCD5', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'E8AE477323214E99AB48BA38052BE974');
INSERT INTO `orderitem` VALUES ('1B6B185D53AB44798EE74AE33439BB1A', 2, 67.60, 'B7A7DA7A94E54054841EED1F70C3027C', '锋利的jQuery(第2版)(畅销书升级版，增加jQuery Mobile和性能优化)', 33.80, 'book_img/22786088-1_b.jpg', '96C6D91D916E472681EEC37B1770DE87');
INSERT INTO `orderitem` VALUES ('1BF158F7D2E24DC3AE8AD4748A125F7F', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'E106BFE7029C485D95A124C733BCC539');
INSERT INTO `orderitem` VALUES ('1D529CD78B34458D96D03F9FB9E8DDC5', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'EC3696A4C443494A9B8DD6E8A9B82072');
INSERT INTO `orderitem` VALUES ('1D5352893B8F421CAD3DCCA2623671CA', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '0ADCEE0510844D2697E7A5C0903A8D3B');
INSERT INTO `orderitem` VALUES ('201B6C66CA654A3BA1CDC344F2D3FC11', 4, 273.20, '8E16D59BA4C34374A68029AE877613C4', '轻量级Java EE企业应用实战$（第3版）：Struts 2＋Spring 3＋Hibernate整合开发(含CD光盘1张)', 68.30, 'book_img/22685703-1_b.jpg', 'C411DDB464BF49C092117055C412A1CD');
INSERT INTO `orderitem` VALUES ('2659227EFA5C4FF49B4C9E0E5FF3CDAD', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '1D640078E4A64AC987FEA7299B57A2F6');
INSERT INTO `orderitem` VALUES ('26D125337FB146FD923620A8E7C87556', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', 'HTML、CSS、JavaScript网页制作从入门到精通（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', 'E6EEEB39CECC4089BC65142BADCC4FC3');
INSERT INTO `orderitem` VALUES ('26FFD473E4654C27B59BDB404E3982C5', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '605B9D163C1345B6A636D80720794CE8');
INSERT INTO `orderitem` VALUES ('2754A72B64774B03A6FF5E08233D5445', 1, 95.30, '48BBFBFC07074ADE8CC906A45BE5D9A6', 'JavaScript权威指南（第6版）（淘宝前端团队倾情翻译！经典权威的JavaScript犀牛书！第6版特别涵盖了HTML5和ECMAScript5！）（经典巨著，当当独家首发）', 95.30, 'book_img/22722790-1_b.jpg', 'E891D2A05DA6485EB7E12436E8FB3107');
INSERT INTO `orderitem` VALUES ('285F32EA770A4F9593537FEAC1B8705A', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'CBB735CB5F084C1BB80FF5998F811E63');
INSERT INTO `orderitem` VALUES ('2953F9C5BC6F4475AE3AD52B921B6875', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '0FD72F77655D43E2B7989892E965864D');
INSERT INTO `orderitem` VALUES ('29E8A4EEA3914F16BE2287DC95AC14CD', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '15A89AB272394F359EA26A2E15F13405');
INSERT INTO `orderitem` VALUES ('2CFE01CE0DC04BB18EB9D3D0ACE72EE3', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通$（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '0AA6D2E046DB4EF2804C90EF6F7C2429');
INSERT INTO `orderitem` VALUES ('2DFCFFF13ACC4AFBBDCACC9970F2E393', 1, 68.30, '8E16D59BA4C34374A68029AE877613C4', '轻量级Java EE企业应用实战$（第3版）：Struts 2＋Spring 3＋Hibernate整合开发(含CD光盘1张)', 68.30, 'book_img/22685703-1_b.jpg', 'C3178A812ECE4629A6BE23F02416C4FD');
INSERT INTO `orderitem` VALUES ('2E3E86265EC34D8F9907F52044AE2DD2', 1, 47.40, '95AACC68D64D4D67B1E33E9EAC22B885', 'Head First Java（中文版）（JAVA经典畅销书 生动有趣 轻松学好JAVA）', 47.40, 'book_img/9265169-1_b.jpg', '0FD72F77655D43E2B7989892E965864D');
INSERT INTO `orderitem` VALUES ('2EC79387485D42F699DFAC6CF2CFF26A', 2, 82.60, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'E3A1EB6D0543489F9729B2B5BC5DB365');
INSERT INTO `orderitem` VALUES ('346BFB39E1524650A695DEAD8397F811', 2, 150.40, '1286B13F0EA54E4CB75434762121486A', 'Java核心技术 卷I：基础知识(第9版·英文版)(上、下册)', 75.20, 'book_img/23280479-1_b.jpg', 'FAC08EE0DF2C4487A6FA2B11B343307E');
INSERT INTO `orderitem` VALUES ('35B0B801D25845D8B76B61DD3CD5759A', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'B62C7C1BA61C47C4BCEC4BE96897A72C');
INSERT INTO `orderitem` VALUES ('37D26DB2F215411E8BFB761D61769021', 1, 47.60, 'AE0935F13A214436B8599DE285A86220', 'JavaScript基础教程(第8版)(经典JavaScript入门书 涵盖Ajax和jQuery)', 47.60, 'book_img/22717349-1_b.jpg', 'BE24BB4187B1472AA08E206BF8B0ABF7');
INSERT INTO `orderitem` VALUES ('38132C2B0A8E4A7499A4A00A2C68D342', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', 'HTML、CSS、JavaScript网页制作从入门到精通（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', '148668BE43754CE2B64A0AC999C5A2D5');
INSERT INTO `orderitem` VALUES ('3C585F544A494041AE75375D1CE8F086', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'A2DB4A7B4EA640ADA63F22A7E8311F4B');
INSERT INTO `orderitem` VALUES ('3DA0F5E8A5F34755A7254783B2A2C002', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '0FBC5F415EF94161AF2937A07EFD8DE8');
INSERT INTO `orderitem` VALUES ('44AF075EF3BD4DBEB55C23C1930CB3B7', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', 'HTML、CSS、JavaScript网页制作从入门到精通（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', '5FB1E131DD294CBBA34FE93228DF2F02');
INSERT INTO `orderitem` VALUES ('45DC477BDB284FC6BA6A1254B41D1144', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想$（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '3F0B39529DBD48C2A542EEBDE7A6FA03');
INSERT INTO `orderitem` VALUES ('4A53FDF198474C16A0D4028CC9C1532B', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '674878FE6CAB48918DB4A9688262FBD5');
INSERT INTO `orderitem` VALUES ('4ABE8B2691F84258AE4B79EF14068920', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'C4A1E40F2F514684BCD97F9EE76A701F');
INSERT INTO `orderitem` VALUES ('4AD70581ED09443DBE176C341D7B51BA', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '93576BB2F43C47F89B4DD7B91F5DF5E3');
INSERT INTO `orderitem` VALUES ('4F8776C84CF241AF9C4FB5BF8282E870', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '5D39377E88E049F8BA19173BAFF295CB');
INSERT INTO `orderitem` VALUES ('50C4D3F0F28A4648BF89BD18C7931B60', 1, 95.30, '48BBFBFC07074ADE8CC906A45BE5D9A6', 'JavaScript权威指南（第6版）（淘宝前端团队倾情翻译！经典权威的JavaScript犀牛书！第6版特别涵盖了HTML5和ECMAScript5！）（经典巨著，当当独家首发）', 95.30, 'book_img/22722790-1_b.jpg', '058F48DA33694C6D8F5C2C13F3D26CEA');
INSERT INTO `orderitem` VALUES ('59C13A2A03C448098F20E5DC07B6D1D9', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '6504C742FE65413494E028E714D4D609');
INSERT INTO `orderitem` VALUES ('5AD3850D25D143C6B54FBD84890A15EB', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '148668BE43754CE2B64A0AC999C5A2D5');
INSERT INTO `orderitem` VALUES ('5B17BD28CDAA4E4F98C5AAC48BCEB7BB', 1, 82.10, '3DD187217BF44A99B86DD18A4DC628BA', 'Java核心技术 卷1 基础知识（原书第9版）', 82.10, 'book_img/23362142-1_b.jpg', '303E12F4821A4B3F9DB97B23947220C7');
INSERT INTO `orderitem` VALUES ('5B5DC1333EFD465DBDCC590B2B45E5E7', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想$（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'FEAC10AB4DE343CB87A6B4BF8BF3D3C6');
INSERT INTO `orderitem` VALUES ('5DADDF8045D7408DA4C9AAD9694AF5BF', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '2D9FF0BFB82842CFAA4B623D5997BF1F');
INSERT INTO `orderitem` VALUES ('5DF78D39DA9947048EED4F38DE027CEB', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '9721A3FBC37D490588AEE02F761744E2');
INSERT INTO `orderitem` VALUES ('5F6DAEB9C7E64DAB890320C0255B0242', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '0CA1A9B0287C43B2AA9435F11F237E9B');
INSERT INTO `orderitem` VALUES ('60060AAF98F747559DDD07B30B22E711', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', '网页制作从入门到精通$HTML、CSS、JavaScript（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', 'C3178A812ECE4629A6BE23F02416C4FD');
INSERT INTO `orderitem` VALUES ('65CFB83DF1CC4052B0D6657D2B444188', 1, 95.30, '48BBFBFC07074ADE8CC906A45BE5D9A6', 'JavaScript权威指南（第6版）（淘宝前端团队倾情翻译！经典权威的JavaScript犀牛书！第6版特别涵盖了HTML5和ECMAScript5！）（经典巨著，当当独家首发）', 95.30, 'book_img/22722790-1_b.jpg', 'B69C6849120D4B28A6CCF99351B88575');
INSERT INTO `orderitem` VALUES ('6C6ECD46FE1549E5BF2B41242AED8F33', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', '网页制作从入门到精通$HTML、CSS、JavaScript（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', 'FEAC10AB4DE343CB87A6B4BF8BF3D3C6');
INSERT INTO `orderitem` VALUES ('6EED5522BFCC42FC9B6496FEE15C4AA4', 1, 99.00, '8E16D59BA4C34374A68029AE877613C4', '轻量级Java EE企业应用实战$（第3版）：Struts 2＋Spring 3＋Hibernate整合开发(含CD光盘1张)', 99.00, 'book_img/22685703-1_b.jpg', 'AC1336F20CD848F78A44D3409ED53393');
INSERT INTO `orderitem` VALUES ('6F4239EBB3D84A29911AEF08B16C4B78', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '0A1F4C5BDE754277B984D1E7E763051D');
INSERT INTO `orderitem` VALUES ('72EA834FBF6F4FD3B43D4586B7E5B2E4', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'BB7789E41C524030832B7E5E426633E7');
INSERT INTO `orderitem` VALUES ('79A5CCB6ED5E4ABBA2ADCD9E93103302', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '32739173C1E247558358B1A8FE9FE012');
INSERT INTO `orderitem` VALUES ('7EE1C6B23024423889741ADD3ECB2999', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通$（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'FEAC10AB4DE343CB87A6B4BF8BF3D3C6');
INSERT INTO `orderitem` VALUES ('83C053FBB2B0479F86F8194AD9BB5411', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '7237A47B1B5B4A78822D662AE01671B6');
INSERT INTO `orderitem` VALUES ('85DA1674B58C450291901E923B13B53C', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'DD5135AEDA2E464BAF52DEC4727E2A3D');
INSERT INTO `orderitem` VALUES ('87BE2F926AF5401595CECDF656752E96', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '0CD9939DC9AE4DA2A12F772293F55A4B');
INSERT INTO `orderitem` VALUES ('882D2D4A06B645AC9DE56B60622EC4E8', 1, 82.10, '3DD187217BF44A99B86DD18A4DC628BA', 'Java核心技术 卷1 基础知识（原书第9版）', 82.10, 'book_img/23362142-1_b.jpg', '553AFF48D76A48AD89ED3FE8F7E2F587');
INSERT INTO `orderitem` VALUES ('8BEA49FAE0924D05BD5903325BFB4E0A', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'CE537015382640E1AE15B9A8FD08B9EE');
INSERT INTO `orderitem` VALUES ('8C75EAC8C39845FE8D7540F208D31F86', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', 'HTML、CSS、JavaScript网页制作从入门到精通（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', 'A2DB4A7B4EA640ADA63F22A7E8311F4B');
INSERT INTO `orderitem` VALUES ('8D9E5FBADD584B9B8B1E54CE09DFAC83', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想$（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '8FE1F57194DF430A8E3866C88756C6ED');
INSERT INTO `orderitem` VALUES ('914175F8FB55422BB407DD0AC9DB3D63', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'F64FD5E198BB4114AB091034C5C6D8B7');
INSERT INTO `orderitem` VALUES ('93069308B4C04E16A9D1EE7B8EFEEBA6', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '57856B1A295B437CA0F7991540897B47');
INSERT INTO `orderitem` VALUES ('942BE069B7B345BAA5D4FE19E2D87C12', 2, 65.80, '97437DAD03FA456AA7D6154614A43B55', 'HTML、CSS、JavaScript网页制作从入门到精通（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', 'B69C6849120D4B28A6CCF99351B88575');
INSERT INTO `orderitem` VALUES ('9979731BC91D43B690E8ECD51DCC0F77', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '7237A47B1B5B4A78822D662AE01671B6');
INSERT INTO `orderitem` VALUES ('9C6DE8585579400B8F91311FE472FF30', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '4B49D55D2CD34DB480A2CDF1A78858E8');
INSERT INTO `orderitem` VALUES ('9CC5C541D4DF4C209EED96F8D62233EF', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '33D163070CE74936966AE177F3E09B20');
INSERT INTO `orderitem` VALUES ('9E1D7EF000E440608281DE20DADB2AD9', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '1AFEC52D72C74266A6E36F83F9910B4F');
INSERT INTO `orderitem` VALUES ('9F7734B0571F49F488ED6C07D350B58B', 1, 33.80, 'B7A7DA7A94E54054841EED1F70C3027C', '锋利的jQuery(第2版)$(畅销书升级版，增加jQuery Mobile和性能优化)', 33.80, 'book_img/22786088-1_b.jpg', '3F0B39529DBD48C2A542EEBDE7A6FA03');
INSERT INTO `orderitem` VALUES ('A00770D667394EAD9DC8599FA025046C', 1, 68.30, '8E16D59BA4C34374A68029AE877613C4', '轻量级Java EE企业应用实战（第3版）：Struts 2＋Spring 3＋Hibernate整合开发(含CD光盘1张)', 68.30, 'book_img/22685703-1_b.jpg', 'EE1F00D88FDC44BD966AF05C1F7FABE0');
INSERT INTO `orderitem` VALUES ('A12B5835A2AA416491E59A1F470B03DF', 1, 95.30, '48BBFBFC07074ADE8CC906A45BE5D9A6', 'JavaScript权威指南（第6版）（淘宝前端团队倾情翻译！经典权威的JavaScript犀牛书！第6版特别涵盖了HTML5和ECMAScript5！）（经典巨著，当当独家首发）', 95.30, 'book_img/22722790-1_b.jpg', '5668668DAB1F4406819D37881BC5D5B1');
INSERT INTO `orderitem` VALUES ('A4938F10E31243FCBEDDBF762F887F12', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'C6F8379F9E3E4F8381763B54E5BF986C');
INSERT INTO `orderitem` VALUES ('A5CA013362854C7FBF1267670DDA659A', 3, 204.90, '5C68141786B84A4CB8929A2415040739', 'JavaScript高级程序设计(第3版)(JavaScript技术名著，国内JavasScript第一书，销量超过8万册)', 68.30, 'book_img/22628333-1_b.jpg', 'B69C6849120D4B28A6CCF99351B88575');
INSERT INTO `orderitem` VALUES ('A804D19B50F049A3AD3919E2C597F4CB', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', '网页制作从入门到精通$HTML、CSS、JavaScript（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', '0AA6D2E046DB4EF2804C90EF6F7C2429');
INSERT INTO `orderitem` VALUES ('A997875748344933AA3371BA5F280B95', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '148668BE43754CE2B64A0AC999C5A2D5');
INSERT INTO `orderitem` VALUES ('AA10E8BEFD744C2DBCDC7E85C11044C4', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'EA4DC50E547149E3A48B14E6711DF1BD');
INSERT INTO `orderitem` VALUES ('AA2BC081EBFE40D889671C95A8B63A66', 1, 40.70, '4A9574F03A6B40C1B2A437237C17DEEC', 'Spring实战(第3版)（In Action系列中最畅销的Spring图书，近十万读者学习Spring的共同选择）', 40.70, 'book_img/23254532-1_b.jpg', 'E6EEEB39CECC4089BC65142BADCC4FC3');
INSERT INTO `orderitem` VALUES ('ADE5E6CE66DF4C97901D1CF64BD5D4F9', 1, 99.00, '8E16D59BA4C34374A68029AE877613C4', '轻量级Java EE企业应用实战$（第3版）：Struts 2＋Spring 3＋Hibernate整合开发(含CD光盘1张)', 99.00, 'book_img/22685703-1_b.jpg', '35E47895604541258BDB95C79FAA0FF6');
INSERT INTO `orderitem` VALUES ('B57029A4B38C48619E951EA3AAA62B5D', 1, 67.60, '0EE8A0AE69154287A378FB110FF2C780', 'Java核心技术：卷Ⅰ基础知识（原书第8版）', 67.60, 'book_img/20285763-1_b.jpg', 'E891D2A05DA6485EB7E12436E8FB3107');
INSERT INTO `orderitem` VALUES ('B93CD7AC6B3C4044AE8186279C33803B', 1, 26.90, 'BD1CB005E4A04DCA881DA8689E21D4D0', 'jQuery UI开发指南', 26.90, 'book_img/22910975-1_b.jpg', '553AFF48D76A48AD89ED3FE8F7E2F587');
INSERT INTO `orderitem` VALUES ('C01A7D87FC924BAD8D3A4255BE415D14', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '7858221EA1DF4B318A632A9C1CD3E1F7');
INSERT INTO `orderitem` VALUES ('C08547828C9445648F049ABC6127768D', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', 'HTML、CSS、JavaScript网页制作从入门到精通（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', 'E3A1EB6D0543489F9729B2B5BC5DB365');
INSERT INTO `orderitem` VALUES ('C2DC9CDECD724065A6ABE92C693B4F75', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'ECB47FBA81F64751B7AC89CCB8DDFD09');
INSERT INTO `orderitem` VALUES ('C3575A8B7DED44B3937237DD6795FD46', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '6C921E50C3E54EA0AFD8CC4B661963AD');
INSERT INTO `orderitem` VALUES ('C3BDE3E9E6CD48F6B0DDDB4720106689', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '3143492834294128ADCFD1DAC3530396');
INSERT INTO `orderitem` VALUES ('C4B479673E0E454580A3B47747B954E7', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '5FB1E131DD294CBBA34FE93228DF2F02');
INSERT INTO `orderitem` VALUES ('C588A712ADFD4D8282A328E49CBD01FB', 1, 32.90, '97437DAD03FA456AA7D6154614A43B55', 'HTML、CSS、JavaScript网页制作从入门到精通（两万读者的选择，经久不衰的超级畅销书最新升级版！网页制作学习者入门必读经典！）', 32.90, 'book_img/22928649-1_b.jpg', 'BDB995AF80D34716ABB9D10CB6962F87');
INSERT INTO `orderitem` VALUES ('CA8CEF8D4C5647748A96A3684663B70E', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '065056EFA3914273B6B266A2414A38FA');
INSERT INTO `orderitem` VALUES ('D544F15EEE69445B9BD10FF04253896E', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '9E1C0A9FDF1F49B18FA0BFA33E132BDD');
INSERT INTO `orderitem` VALUES ('D7D28ECCBDE546BCB20435EF057DC299', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想$（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '0AA6D2E046DB4EF2804C90EF6F7C2429');
INSERT INTO `orderitem` VALUES ('D7D546DB926B4FA9805524752279F923', 1, 33.80, '9923901FBF124623BC707920D8936BC8', 'JavaScript DOM编程艺术(第2版)', 33.80, 'book_img/21049601-1_b.jpg', '8BB662E4C0444BC88F1DBE82584595BC');
INSERT INTO `orderitem` VALUES ('DC77C023E9AC45ADB40FEB67AC230DA2', 2, 150.40, 'E4F184188C8B4C7BB32D4E76603426AC', '疯狂Java讲义$（第2版，附光盘）', 75.20, 'book_img/22588603-1_b.jpg', 'E36C274D315047BBB5704161115C2AF9');
INSERT INTO `orderitem` VALUES ('DD20B0599B3949BA84CDE6EB778C1178', 1, 68.30, '8E16D59BA4C34374A68029AE877613C4', '轻量级Java EE企业应用实战$（第3版）：Struts 2＋Spring 3＋Hibernate整合开发(含CD光盘1张)', 68.30, 'book_img/22685703-1_b.jpg', '8FE1F57194DF430A8E3866C88756C6ED');
INSERT INTO `orderitem` VALUES ('E1FDF0B54C4741639C5A9E33A0923177', 1, 33.80, 'B7A7DA7A94E54054841EED1F70C3027C', '锋利的jQuery(第2版)(畅销书升级版，增加jQuery Mobile和性能优化)', 33.80, 'book_img/22786088-1_b.jpg', 'BD1BD9AB58B1413FA0BDC0AACCC8C65F');
INSERT INTO `orderitem` VALUES ('E35724F886094E5AB2076A690EC28917', 1, 68.30, '8E16D59BA4C34374A68029AE877613C4', '轻量级Java EE企业应用实战（第3版）：Struts 2＋Spring 3＋Hibernate整合开发(含CD光盘1张)', 68.30, 'book_img/22685703-1_b.jpg', '59A15DD3A0704508B1C2BC9B682A329F');
INSERT INTO `orderitem` VALUES ('E3EF277FBBEB4AB4B5FB0AB187C9E635', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'EDC9F39D490E424BA799E7BD4BED9D09');
INSERT INTO `orderitem` VALUES ('ED5722353C0A4F15A11B28A5A9B2745A', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '57197A448F9A4F15B76B1ED1EB3A15E6');
INSERT INTO `orderitem` VALUES ('EE61A6CCC02148F68DF99293F2EEE88F', 1, 68.30, '5C68141786B84A4CB8929A2415040739', 'JavaScript高级程序设计(第3版)(JavaScript技术名著，国内JavasScript第一书，销量超过8万册)', 68.30, 'book_img/22628333-1_b.jpg', '673170D78D9D4EE6AE083167CFB81C1A');
INSERT INTO `orderitem` VALUES ('EFCAF77235D94975A095027562F643C5', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'BB7789E41C524030832B7E5E426633E7');
INSERT INTO `orderitem` VALUES ('F1C3FC9D6AAE406ABA251689B8ACC291', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', 'C34F025EF6BB4B88A8409B00A0ABC891');
INSERT INTO `orderitem` VALUES ('F49964DAE525431C94ED66D96E053301', 2, 149.00, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'FAC08EE0DF2C4487A6FA2B11B343307E');
INSERT INTO `orderitem` VALUES ('F7074572D71A454097B9019B7D5897FA', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '161A05BEBBAA468199131EAD175CCFEA');
INSERT INTO `orderitem` VALUES ('F84DB5D9AD0441FE81A52DCCCAC0EEA1', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '2AFD7DC9619548BA8727464D77AFB9C2');
INSERT INTO `orderitem` VALUES ('F9AD99717BDF4DD481FF35CC2A11B2D3', 1, 41.30, '5C4A6F0F4A3B4672AD8C5F89BF5D37D2', 'Java从入门到精通（第3版）（附光盘1张）（连续8月Java类全国零售排行前2名，32小时视频，732个经典实例、369项面试真题、616项测试史上最全资源库）', 41.30, 'book_img/22862060-1_b.jpg', '0B657B624D8D4B919B7E5F175AA90530');
INSERT INTO `orderitem` VALUES ('FBA39DB6CA63434B988D5329F029B2BB', 2, 149.00, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '75B7D65D4F5A43CD83605FDE38D7E10C');
INSERT INTO `orderitem` VALUES ('FBC88A01EE934A92BB83F8865CF44457', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', '49127E9642C5474FA8F2139204DE571C');
INSERT INTO `orderitem` VALUES ('FFB980C9F3844E9085A134EC339F0979', 1, 74.50, 'CE01F15D435A4C51B0AD8202A318DCA7', 'Java编程思想（第4版）', 74.50, 'book_img/9317290-1_b.jpg', 'A2DB4A7B4EA640ADA63F22A7E8311F4B');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `uid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `loginname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名',
  `loginpass` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `status` tinyint(1) NULL DEFAULT NULL COMMENT '激活状态',
  `activationCode` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '激活码，唯一的',
  `sex` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  PRIMARY KEY (`uid`) USING BTREE,
  UNIQUE INDEX `loginname`(`loginname`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('32DB3700D2564254982BC58B0E4D95BC', 'liSi', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'itcast_cxf@126.com', 1, '15682E9C4D2849E2AB5D8AFF55D2F7BA87126B0EF55A45C6A136E3CAA90D60F2', '');
INSERT INTO `user` VALUES ('4DE7E4D829A54D4FAB150B7451407198', 'defq', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'itcast_cxf@soh.com', 0, 'D00FAA82457748FF8C1B912042E615B39F3602053E154181B98CDD48D9ECFC96', '');
INSERT INTO `user` VALUES ('531D8A16D524478D86F8A115FE95D93F', 'zhangSan', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'itcast_cxf@163.com', 1, 'FCF142D04C4A420992FF4E7BAC92C1E58AF905F1A46B4818BB455BD925E52DDD', '');
INSERT INTO `user` VALUES ('55790D9C1A1845738E6D93866A148C7E', 'wangWu', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'itcast_cxf@sina.com', 1, '659903B3D5FF4576B82425A593962DFE64B6137EBE934AE5AE19F614E71F4549', '');
INSERT INTO `user` VALUES ('6B19CCE5703D404BB7498398D396B445', 'yosebook', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'lddisabug@163.com', 1, '744722AD05B14515BB1F480FCE900A240FB6F10329B343CEA87022D1AE5007F4', NULL);
INSERT INTO `user` VALUES ('9CC972DFA2D4481F89841A46FD1B3E7B', 'abc', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'itcast_cxf@qq.com', 0, 'D7CEB3DE44364749A4807D98F8B2F63017FDFED9FFC842B6BBC64E20698FED5F', '');
INSERT INTO `user` VALUES ('B50ADE921BF14F6EB5331777B1874763', 'aabb', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'abc@abc.cn', 0, '10032D0DFD2B49DC98CA9739F929656B6819FA1C10EC44F8A95206D0C3D62094', '');
INSERT INTO `user` VALUES ('BD18193A4F3D4B028387F802BEB70304', 'caocao', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'caocao@qq.com', 1, '6CD84E8D75C54AB9BABFC44148F01B555C60B93AD86348A9BDCB9CC7D43FCAA7', '男');
INSERT INTO `user` VALUES ('C7D439BB678B4FF2B293937A6877AB32', '美女姐姐', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'lddisabug@126.com', 1, '97270BB425724EC3BD33336A6CF336DAC158571229604BEE9FECDD55A9454C91', NULL);
INSERT INTO `user` VALUES ('x', 'liubei', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'liuBei@163.com', 1, 'x', '');
INSERT INTO `user` VALUES ('xx', 'guanyu', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'guanYu@163.com', 1, 'xx', '');
INSERT INTO `user` VALUES ('xxx', 'zsss', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'zhangFei@163.com', 1, 'xxx', '');
INSERT INTO `user` VALUES ('xxxx', 'zhaoyun', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'zhaoYun@163.com', 1, 'xxxx', '');

SET FOREIGN_KEY_CHECKS = 1;