/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50560
Source Host : localhost:3306
Source Schema : db_librarysys
Target Server Type : MySQL
Target Server Version : 50560
File Encoding : 65001
Date: 25/12/2018 22:24:29
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for tb_bookcase
-- ----------------------------
DROP TABLE IF EXISTS `tb_bookcase`;
CREATE TABLE `tb_bookcase` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`Column_3` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of tb_bookcase
-- ----------------------------
INSERT INTO `tb_bookcase` VALUES (3, 'A架', NULL);
INSERT INTO `tb_bookcase` VALUES (4, 'B架', NULL);
INSERT INTO `tb_bookcase` VALUES (5, '最代码', NULL);
-- ----------------------------
-- Table structure for tb_bookinfo
-- ----------------------------
DROP TABLE IF EXISTS `tb_bookinfo`;
CREATE TABLE `tb_bookinfo` (
`barcode` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`bookname` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`typeid` int(10) UNSIGNED DEFAULT NULL,
`author` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`translator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`ISBN` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`price` float(8, 2) DEFAULT NULL,
`page` int(10) UNSIGNED DEFAULT NULL,
`bookcase` int(10) UNSIGNED DEFAULT NULL,
`inTime` date DEFAULT NULL,
`operator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`del` tinyint(1) DEFAULT 0,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of tb_bookinfo
-- ----------------------------
INSERT INTO `tb_bookinfo` VALUES ('9787302047230', 'Java学习指南', 1, '***', '11', '7-302', 39.00, 440, 3, '2007-11-22', 'tsoft', 0, 1);
INSERT INTO `tb_bookinfo` VALUES ('jk', 'kjkj', 1, '***', '', '7-302', 12.00, 0, 1, '2007-11-22', 'tsoft', 1, 2);
INSERT INTO `tb_bookinfo` VALUES ('9787115157690', 'JSP啊', 1, '***', '', '978-7', 89.00, 816, 3, '2007-11-23', 'tsoft', 0, 3);
INSERT INTO `tb_bookinfo` VALUES ('123', '额', 1, '11', '11', '7-302', 11.00, 11, 1, '2007-12-18', 'tsoft', 1, 5);
INSERT INTO `tb_bookinfo` VALUES ('001', '建筑测试', 4, '做做', '的', '7-302', 11.00, 11, 4, '2013-05-03', 'java1234', 0, 6);
-- ----------------------------
-- Table structure for tb_booktype
-- ----------------------------
DROP TABLE IF EXISTS `tb_booktype`;
CREATE TABLE `tb_booktype` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`typename` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`days` int(10) UNSIGNED DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of tb_booktype
-- ----------------------------
INSERT INTO `tb_booktype` VALUES (1, '计算机类', 30);
INSERT INTO `tb_booktype` VALUES (3, '文学类', 35);
INSERT INTO `tb_booktype` VALUES (4, '建筑类', 20);
INSERT INTO `tb_booktype` VALUES (5, '最代码网站图书', 11);
-- ----------------------------
-- Table structure for tb_borrow
-- ----------------------------
DROP TABLE IF EXISTS `tb_borrow`;
CREATE TABLE `tb_borrow` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`readerid` int(10) UNSIGNED DEFAULT NULL,
`bookid` int(10) DEFAULT NULL,
`borrowTime` date DEFAULT NULL,
`backTime` date DEFAULT NULL,
`operator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`ifback` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of tb_borrow
-- ----------------------------
INSERT INTO `tb_borrow` VALUES (1, 1, 1, '2007-11-22', '2007-12-22', 'tsoft', 1);
INSERT INTO `tb_borrow` VALUES (2, 1, 3, '2007-11-26', '2007-12-26', 'tsoft', 0);
INSERT INTO `tb_borrow` VALUES (3, 1, 1, '2007-11-26', '2007-12-26', 'tsoft', 0);
INSERT INTO `tb_borrow` VALUES (4, 3, 6, '2007-12-29', '2007-01-08', 'Tsoft', 0);
INSERT INTO `tb_borrow` VALUES (5, 3, 1, '2007-12-29', '2008-01-28', 'Tsoft', 0);
INSERT INTO `tb_borrow` VALUES (6, 3, 3, '2007-12-29', '2008-01-28', 'Tsoft', 1);
INSERT INTO `tb_borrow` VALUES (7, 1, 6, '2013-05-03', '2013-05-23', 'java1234', 1);
INSERT INTO `tb_borrow` VALUES (8, 1, 6, '2013-05-03', '2013-05-23', 'java1234', 1);
INSERT INTO `tb_borrow` VALUES (9, 1, 6, '2013-05-03', '2013-05-23', 'java1234', 1);
INSERT INTO `tb_borrow` VALUES (10, 1, 1, '2013-05-03', '2013-06-02', 'java1234', 0);
-- ----------------------------
-- Table structure for tb_giveback
-- ----------------------------
DROP TABLE IF EXISTS `tb_giveback`;
CREATE TABLE `tb_giveback` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`readerid` int(11) DEFAULT NULL,
`bookid` int(11) DEFAULT NULL,
`backTime` date DEFAULT NULL,
`operator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of tb_giveback
-- ----------------------------
INSERT INTO `tb_giveback` VALUES (1, 1, 1, '2007-11-22', 'tsoft');
INSERT INTO `tb_giveback` VALUES (2, 3, 3, '2007-01-03', 'Tsoft');
INSERT INTO `tb_giveback` VALUES (3, 1, 6, '2013-05-03', 'java1234');
INSERT INTO `tb_giveback` VALUES (4, 1, 6, '2013-05-03', 'java1234');
INSERT INTO `tb_giveback` VALUES (5, 1, 6, '2013-05-03', 'java1234');
-- ----------------------------
-- Table structure for tb_library
-- ----------------------------
DROP TABLE IF EXISTS `tb_library`;
CREATE TABLE `tb_library` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`libraryname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`curator` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`createDate` date DEFAULT NULL,
`introduce` text CHARACTER SET utf8 COLLATE utf8_general_ci,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of tb_library
-- ----------------------------
INSERT INTO `tb_library` VALUES (1, '是', '最代码', '13520109202', 'zuidaima@qq.com', 'zuidaima@qq.com', 'http://www.zuidaima.com', '2008-05-06', 'http://www.zuidaima.com');
-- ----------------------------
-- Table structure for tb_manager
-- ----------------------------
DROP TABLE IF EXISTS `tb_manager`;
CREATE TABLE `tb_manager` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`PWD` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGIN
