db_data.sql

使用PHP和MySql完成的简单图书馆信息管理系统

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2008 年 05 月 17 日 03:24
-- 服务器版本: 5.0.45
-- PHP 版本: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- 数据库: `library`
--
CREATE DATABASE `library` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `library`;

-- --------------------------------------------------------

--
-- 表的结构 `admin`
--

CREATE TABLE `admin` (
  `ID` int(11) NOT NULL auto_increment,
  `用户名` varchar(20) NOT NULL,
  `密码` varchar(40) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `用户名` (`用户名`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- 导出表中的数据 `admin`
--

INSERT INTO `admin` (`ID`, `用户名`, `密码`) VALUES
(1, '李莘', 'e70c9e25b5a33777af25e7f8ec9da9481b962dd5'),
(2, 'lishen', 'e70c9e25b5a33777af25e7f8ec9da9481b962dd5'),
(5, 'xujin', '3ccec69ef06c2db79786399d8749180612f07a00'),
(9, 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997');

-- --------------------------------------------------------

--
-- 表的结构 `books`
--

CREATE TABLE `books` (
  `书号` int(11) NOT NULL auto_increment,
  `书名` varchar(50) NOT NULL,
  `作者` varchar(30) NOT NULL,
  `出版社` varchar(20) NOT NULL,
  `出版日期` date NOT NULL,
  `入库日期` date NOT NULL,
  `版次` tinyint(4) NOT NULL,
  `单价` float NOT NULL,
  `内容提要` text NOT NULL,
  `分类号` tinyint(4) NOT NULL,
  `书库号` tinyint(4) NOT NULL,
  PRIMARY KEY  (`书号`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- 导出表中的数据 `books`
--

INSERT INTO `books` (`书号`, `书名`, `作者`, `出版社`, `出版日期`, `入库日期`, `版次`, `单价`, `内容提要`, `分类号`, `书库号`) VALUES
(1, 'GRE词汇逆序记忆', '俞敏洪', '群言出版社', '2005-09-09', '2008-05-15', 5, 15, '最值得拥有的“红宝书”伴侣！', 7, 1),
(2, 'PHP和MySQL Web开发', 'Luke Welling & Laura Thomson', '机械工业出版社', '2007-01-01', '2008-05-18', 1, 78, 'PHP和MySQL Web开发的“圣经”。', 18, 2),
(3, 'C语言程序设计', 'Brian W. Kernighan & Dennis M.', '机械工业出版社', '2007-06-01', '2008-05-12', 16, 30, '全球最经典的C语言教程。', 18, 2),
(7, 'PHP与MySQL5程序设计（第二版）', 'W. Janson Gilmore', '人民邮电出版社', '2007-02-01', '2008-05-13', 2, 79, 'PHP&MySQL开发新圣经\r\nAmazon PHP 畅销书\r\n涵盖最近版PHP5、MySQL5', 18, 2),
(8, 'C程序设计语言', '丹尼斯.里奇&布朗.卡尼汉', '机械工业出版社', '2007-01-03', '2007-01-03', 2, 30, 'C程序设计语言', 18, 2);

-- --------------------------------------------------------

--
-- 表的结构 `category`
--

CREATE TABLE `category` (
  `ID` int(11) NOT NULL auto_increment,
  `分类名称` varchar(30) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

--
-- 导出表中的数据 `category`
--

INSERT INTO `category` (`ID`, `分类名称`) VALUES
(1, '马克思主义、列宁主义、毛泽东思想'),
(2, '哲学'),
(3, '社会科学总论'),
(4, '政治、法律'),
(5, '军事'),
(6, '经济'),
(7, '文化、科学、教育、体育'),
(8, '语言、文字'),
(9, '文学'),
(10, '艺术'),
(11, '历史、地理'),
(12, '自然科学总论'),
(13, '数理科学和化学'),
(14, '天文学、地球科学'),
(15, '生物科学'),
(16, '医药、卫生'),
(17, '农业科学'),
(18, '工业科学'),
(19, '交通运输'),
(20, '航空、航天'),
(21, '环境科学'),
(22, '综合性图书');

-- --------------------------------------------------------

--
-- 表的结构 `lending`
--

CREATE TABLE `lending` (
  `ID` int(11) NOT NULL auto_increment,
  `读者` int(11) NOT NULL,
  `书号` int(11) NOT NULL,
  `操作员` char(30) NOT NULL,
  `借书日期` date NOT NULL,
  `应还日期` date NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- 导出表中的数据 `lending`
--

INSERT INTO `lending` (`ID`, `读者`, `书号`, `操作员`, `借书日期`, `应还日期`) VALUES
(1, 1234597892, 1, 'lishen', '2008-02-16', '2008-03-04'),
(2, 1234597892, 2, 'lishen', '2008-05-16', '2008-03-18'),
(3, 1234597891, 3, 'lishen', '2008-05-17', '2008-05-01'),
(7, 1234597891, 7, 'lishen', '2008-05-17', '2007-05-18'),
(8, 1234597894, 8, 'lishen', '2008-05-17', '2008-01-12');

-- --------------------------------------------------------

--
-- 表的结构 `operation`
--

CREATE TABLE `operation` (
  `ID` int(11) NOT NULL auto_increment,
  `操作员` varchar(30) NOT NULL,
  `时间` datetime NOT NULL,
  `执行操作` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ;

--
-- 导出表中的数据 `operation`
--

INSERT INTO `operation` (`ID`, `操作员`, `时间`, `执行操作`) VALUES
(1, 'lishen', '2008-05-16 17:07:00', '登录成功'),
(2, 'xujin', '2008-05-16 17:10:53', '更新读者信息：1234597892'),
(3, 'lishen', '2008-05-16 17:19:39', '退出登录'),
(4, '李莘', '2008-05-16 17:20:27', '登录成功'),
(5, '李莘', '2008-05-16 17:20:36', '退出登录'),
(6, '李莘', '2008-05-16 17:20:49', '登录成功'),
(7, '李莘', '2008-05-16 18:26:47', '更新图书信息：C程序设计语言'),
(8, '李莘', '2008-05-16 18:42:24', '退出登录'),
(9, 'lishen', '2008-05-16 18:42:30', '登录成功'),
(10, 'lishen', '2008-05-16 18:55:13', '退出登录'),
(11, 'lishen', '2008-05-16 18:55:19', '登录成功'),
(12, 'lishen', '2008-05-16 18:57:24', '退出登录'),
(13, 'lishen', '2008-05-16 18:57:29', '成功登录'),
(14, 'lishen', '2008-05-16 18:57:58', '退出登录'),
(15, 'xujin', '2008-05-16 18:58:04', '登录失败'),
(16, 'lishen', '2008-05-16 18:58:13', '登录成功'),
(17, '', '2008-05-16 19:00:27', '登录失败'),
(18, 'xujin', '2008-05-16 19:00:35', '登录成功'),
(19, 'xujin', '2008-05-16 19:51:19', '更新读者信息：1234597892'),
(20, 'xujin', '2008-05-16 19:56:37', '更新读者信息：1234597892'),
(21, 'xujin', '2008-05-16 19:56:47', '更新读者信息：1234597892'),
(22, 'xujin', '2008-05-16 20:01:44', '插入读者信息：'),
(23, 'xujin', '2008-05-16 20:02:34', '更新读者信息：1234597893'),
(24, 'xujin', '2008-05-16 20:03:29', '插入读者信息：'),
(25, 'xujin', '2008-05-16 20:10:46', '更新读者信息：1234597894'),
(26, 'xujin', '2008-05-16 20:16:15', '更新读者信息：1234597893'),
(27, 'xujin', '2008-05-16 20:16:28', '更新读者信息：1234597893'),
(28, 'xujin', '2008-05-16 20:17:06', '更新读者信息：1234597893'),
(29, 'xujin', '2008-05-16 20:17:11', '更新读者信息：1234597893'),
(30, 'lishen', '2008-05-16 20:18:22', '更新读者信息：1234597893'),
(31, 'lishen', '2008-05-16 20:18:36', '更新读者信息：1234597894'),
(32, 'lishen', '2008-05-16 20:18:50', '更新图书信息：PHP与MySQL5程序设计（第二版）'),
(33, 'xujin', '2008-05-16 20:24:06', '更新读者信息：1234597894'),
(34, 'xujin', '2008-05-16 20:24:11', '更新读者信息：1234597894'),
(35, 'xujin', '2008-05-16 20:24:40', '更新读者信息：1234597890'),
(36, 'xujin', '2008-05-16 20:24:46', '更新读者信息：1234597890'),
(37, 'xujin', '2008-05-16 20:24:56', '更新读者信息：1234597892'),
(38, 'xujin', '2008-05-16 20:25:32', '更新读者信息：1234597892'),
(39, 'lishen', '2008-05-16 20:25:38', '更新图书信息：PHP与MySQL5程序设计（第二版）'),
(40, 'lishen', '2008-05-16 20:25:47', '更新图书信息：PHP与MySQL5程序设计（第二版）'),
(41, 'lishen', '2008-05-16 20:26:00', '更新图书信息：PHP与MySQL5程序设计（第二版）'),
(42, 'xujin', '2008-05-16 20:26:28', '更新读者信息：1234597892'),
(43, 'lishen', '2008-05-16 20:26:52', '更新图书信息：PHP与MySQL5程序设计（第二版）'),
(44, 'xujin', '2008-05-16 20:26:52', '更新读者信息：1234597892'),
(45, 'xujin', '2008-05-16 20:27:50', '退出登录'),
(46, 'xujin', '2008-05-16 20:29:09', '登录成功'),
(47, 'xujin', '2008-05-16 20:29:55', '更新图书信息：PHP与MySQL5程序设计（第二版）'),
(48, 'xujin', '2008-05-16 20:47:22', '登录成功'),
(49, 'lishen', '2008-05-16 22:06:42', '登录成功'),
(50, 'lishen', '2008-05-16 22:06:58', '读者1234597892借书：1'),
(51, 'lishen', '2008-05-16 22:07:16', '读者1234597892借书：2'),
(52, 'lishen', '2008-05-16 22:47:55', '更新读者信息：1234597892'),
(53, 'lishen', '2008-05-16 22:48:12', '更新读者信息：1234597890'),
(54, 'xujin', '2008-05-17 00:49:23', '登录成功'),
(55, 'lishen', '2008-05-17 00:56:56', '登录成功'),
(56, 'lishen', '2008-05-17 01:00:02', '登录成功'),
(57, 'lishen', '2008-05-17 01:00:26', '更新读者信息：1234597892'),
(58, 'lishen', '2008-05-17 10:14:51', '登录成功'),
(59, 'lishen', '2008-05-17 10:16:07', '更新读者信息：1234597891'),
(60, 'lishen', '2008-05-17 10:17:03', '更新读者信息：1234597891'),
(61, 'lishen', '2008-05-17 11:05:55', '添加管理员：admin'),
(62, 'lishen', '2008-05-17 11:05:58', '退出登录'),
(63, 'admin', '2008-05-17 11:06:03', '登录成功'),
(64, 'admin', '2008-05-17 11:06:40', '退出登录'),
(65, 'lishen', '2008-05-17 11:08:02', '登录成功'),
(66, 'lishen', '2008-05-17 11:09:54', '读者1234597891借书：3'),
(67, 'lishen', '2008-05-17 11:10:11', '读者1234597894借书：4'),
(68, 'lishen', '2008-05-17 11:10:19', '读者1234597893借书：5'),
(69, 'lishen', '2008-05-17 11:10:32', '读者1234597894借书：6'),
(70, 'lishen', '2008-05-17 11:10:42', '读者1234597891借书：7'),
(71, 'lishen', '2008-05-17 11:17:35', '读者1234597894借书：8');

-- --------------------------------------------------------

--
-- 表的结构 `readers`
--

CREATE TABLE `readers` (
  `借书证号` int(11) NOT NULL auto_increment,
  `姓名` varchar(20) NOT NULL,
  `性别` char(2) NOT NULL,
  `出生日期` date NOT NULL,
  `身份证号` varchar(20) NOT NULL,
  `单位` varchar(40) default NULL,
  `通讯地址` varchar(50) default NULL,
  `邮政编码` varchar(6) default NULL,
  `联系电话` varchar(20) NOT NULL,
  `办证日期` date NOT NULL,
  `借阅范围` varchar(50) NOT NULL,
  `最多借书册数` int(11) NOT NULL,
  `借书期限` int(11) NOT NULL,
  `照片` varchar(100) default NULL,
  `职业` varchar(10) default NULL,
  PRIMARY KEY  (`借书证号`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1234597895 ;

--
-- 导出表中的数据 `readers`
--

INSERT INTO `readers` (`借书证号`, `姓名`, `性别`, `出生日期`, `身份证号`, `单位`, `通讯地址`, `邮政编码`, `联系电话`, `办证日期`, `借阅范围`, `最多借书册数`, `借书期限`, `照片`, `职业`) VALUES
(1234597890, '李莘', '男', '1987-01-31', '410105098701310010', 'w3232', '3232', '323', '13673978522', '2008-05-05', '1，2，3', 5, 30, NULL, '3232'),
(1234597891, '戴蔚', '男', '2008-05-08', '15478996544', '电子技术学院', '电子技术学院', '123456', '123456', '2008-05-01', '1，3', 3, 1, NULL, '要啥小汽车'),
(1234597892, '李莘', '男', '2008-05-16', '45465464646546', 'coati', '就不告诉你~', '450000', '312321', '2008-05-16', '45645', 5, 2, NULL, '浣熊杀手'),
(1234597893, '侯宏元', '女', '0000-00-00', '4654', '151431', '54654', '131', '1321', '0000-00-00', '1321', 121, 21, NULL, '31'),
(1234597894, '徐进', '男', '2008-05-05', '464564', '3132', '2132', '1321', '3213', '2008-05-16', '45', 454, 56, NULL, '4');

-- --------------------------------------------------------

--
-- 表的结构 `stacks`
--

CREATE TABLE `stacks` (
  `ID` int(11) NOT NULL auto_increment,
  `书库名` varchar(30) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- 导出表中的数据 `stacks`
--

INSERT INTO `stacks` (`ID`, `书库名`) VALUES
(1, '理学院'),
(2, '电子技术学院'),
(3, '信息工程学院'),
(4, '测绘学院'),
(5, '一级机密资料'),
(6, '二级机密资料'),
(7, '三级机密资料');