mysql1
//创建数据库book,并做admin,book,loan_order、press、readers表
drop database book;
create database book;
use book;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`admin_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
`user_name` varchar(10) NOT NULL COMMENT '用户名',
`password` varchar(20) NOT NULL COMMENT '密码',
`name` varchar(20) NOT NULL COMMENT '真实姓名',
`sex` enum('男','女') NOT NULL COMMENT '性别',
`phone_number` char(11) NOT NULL COMMENT '手机号',
`address` varchar(30) NOT NULL COMMENT '现住地址',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='管理员表';
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', '001', '123456', '张璇', '女', '13699657853', '海淀区五路居', '2018-04-10 16:02:02');
INSERT INTO `admin` VALUES ('2', '002', '123456', '刘烨', '男', '18513700000', '海淀区大钟寺', '2018-04-02 16:09:50');
INSERT INTO `admin` VALUES ('3', '003', '123456', '张裕', '男', '18513700001', '昌平区沙河', '2018-04-09 16:10:22');
-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`book_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '图书ID',
`press_id` int(11) NOT NULL COMMENT '出版社ID',
`book_title` varchar(30) NOT NULL COMMENT '书名',
`author` varchar(20) NOT NULL COMMENT '作者',
`number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '库存',
`book_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '图书价格',
`price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '借阅价格',
`state` enum('在库中','已借出') DEFAULT NULL COMMENT '状态',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`book_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='图书表';
-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('1', '1', '培育和践行社会主义核心价值观大学生读本（双色）（含微课）', '李世龙、熊安锋、洪步华', '10', '38.00', '5.00', '在库中', '2018-04-10 16:26:18');
INSERT INTO `book` VALUES ('2', '2', 'E时代大学英语——快速阅读教程4（双色）', '孔来信、贾良彦、刘德华', '10', '35.00', '5.00', '在库中', '2018-04-10 16:28:16');
INSERT INTO `book` VALUES ('3', '3', '线性代数', '王慧、于海波', '10', '33.00', '5.00', '在库中', '2018-04-10 16:31:00');
INSERT INTO `book` VALUES ('4', '4', '经济法基础（双色）', '王维新、康微婧、赵生园', '2', '49.80', '6.00', '在库中', '2018-04-09 16:31:49');
INSERT INTO `book` VALUES ('5', '5', '消防设施操作员初级实操培训教材及习题集', '易兵、李家元', '5', '75.00', '15.00', '在库中', '2018-04-09 16:32:46');
-- ----------------------------
-- Table structure for loan_order
-- ----------------------------
DROP TABLE IF EXISTS `loan_order`;
CREATE TABLE `loan_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单ID',
`order_code` varchar(20) NOT NULL COMMENT '订单号',
`book_id` int(11) NOT NULL COMMENT '图书ID',
`readers_id` int(11) NOT NULL COMMENT '借阅者ID',
`admin_id` int(11) NOT NULL COMMENT '管理员ID',
`deposit` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '押金',
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '借阅费',
`money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实收金额',
`state` enum('借阅中','已归还') DEFAULT NULL COMMENT '状态',
`loaned_time` datetime NOT NULL COMMENT '借出时间',
`return_time` datetime NOT NULL COMMENT '归还时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='借阅订单';
-- ----------------------------
-- Records of loan_order
-- ----------------------------
INSERT INTO `loan_order` VALUES ('1', '15234365041234', '1', '1', '1', '38.00', '5.00', '0.00', '借阅中', '2018-04-11 16:49:47', '0000-00-00 00:00:00');
INSERT INTO `loan_order` VALUES ('2', '15234365951256', '2', '2', '1', '35.00', '5.00', '5.00', '已归还', '2018-04-03 16:50:26', '2018-04-10 16:50:30');
INSERT INTO `loan_order` VALUES ('3', '15234123951256', '3', '3', '2', '33.00', '5.00', '0.00', '借阅中', '2018-04-02 16:53:41', '0000-00-00 00:00:00');
INSERT INTO `loan_order` VALUES ('4', '15234123926856', '4', '4', '2', '50.00', '6.00', '0.00', '借阅中', '2018-04-02 16:54:20', '0000-00-00 00:00:00');
-- ----------------------------
-- Table structure for press
-- ----------------------------
DROP TABLE IF EXISTS `press`;
CREATE TABLE `press` (
`press_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '出版社ID',
`press_title` varchar(20) NOT NULL COMMENT '出版社名称',
PRIMARY KEY (`press_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='出版社';
-- ----------------------------
-- Records of press
-- ----------------------------
INSERT INTO `press` VALUES ('1', '清华大学出版社');
INSERT INTO `press` VALUES ('2', '机械工业出版社');
INSERT INTO `press` VALUES ('3', '电子工业出版社');
INSERT INTO `press` VALUES ('4', '建筑工业出版社');
INSERT INTO `press` VALUES ('5', '人民邮电出版社');
INSERT INTO `press` VALUES ('6', '中国电力出版社');
INSERT INTO `press` VALUES ('7', '中国金融出版社');
INSERT INTO `press` VALUES ('8', '人民教育出版社');
INSERT INTO `press` VALUES ('9', '外语教学与研究出版社');
INSERT INTO `press` VALUES ('10', '机械工业出版社 ');
-- ----------------------------
-- Table structure for readers
-- ----------------------------
DROP TABLE IF EXISTS `readers`;
CREATE TABLE `readers` (
`readers_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '借阅者ID',
`name` varchar(20) NOT NULL COMMENT '姓名',
`id_card` char(18) NOT NULL COMMENT '身份证号码',
`sex` enum('男','女') NOT NULL COMMENT '性别',
`phone_number` char(11) NOT NULL COMMENT '手机号',
`create_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`readers_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='读者表';
-- ----------------------------
-- Records of readers
-- ----------------------------
INSERT INTO `readers` VALUES ('1', '李逍遥', '141023199311240015', '男', '13933697850', '2018-04-02 16:40:21');
INSERT INTO `readers` VALUES ('2', '兆林格', '141024200111232356', '男', '13833652351', '2018-04-09 16:41:16');
INSERT INTO `readers` VALUES ('3', '张勋', '141025200202063315', '男', '13533685612', '2018-04-09 16:41:50');
INSERT INTO `readers` VALUES ('4', '纪清雯', '141024200603051245', '女', '13533685613', '2018-04-02 16:43:22');
INSERT INTO `readers` VALUES ('5', '林娟', '141024200603051246', '女', '13323158896', '2018-04-09 16:43:52');
浙公网安备 33010602011771号