database/db_library.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

# MySQL-Front 5.0  (Build 1.0)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: db_library
# ------------------------------------------------------
# Server version 5.0.67-community-nt

#
# Table structure for table tb_bookcase
#

DROP TABLE IF EXISTS `tb_bookcase`;
CREATE TABLE `tb_bookcase` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) default NULL,
  `Column_3` char(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;
INSERT INTO `tb_bookcase` VALUES (3,'书架1',NULL);
INSERT INTO `tb_bookcase` VALUES (4,'书架2',NULL);

#
# Table structure for table tb_bookinfo
#

DROP TABLE IF EXISTS `tb_bookinfo`;
CREATE TABLE `tb_bookinfo` (
  `barcode` varchar(30) default NULL,
  `bookname` varchar(70) default NULL,
  `typeid` int(10) unsigned default NULL,
  `author` varchar(30) default NULL,
  `translator` varchar(30) default NULL,
  `ISBN` varchar(20) 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) default NULL,
  `del` tinyint(1) default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=gb2312;
INSERT INTO `tb_bookinfo` VALUES ('9787302047230','Java 2 实用教程',1,'shuanyulin','ceshi','978-7',39,440,4,'2007-11-22','tsoft',1,1);
INSERT INTO `tb_bookinfo` VALUES ('jk','kjkj',1,'***','','7-302',12,0,1,'2007-11-22','tsoft',1,2);
INSERT INTO `tb_bookinfo` VALUES ('9787115157690','JSP程序开发范例',1,'***','','978-7',89,816,3,'2007-11-23','tsoft',1,3);
INSERT INTO `tb_bookinfo` VALUES ('123','事实',1,'11','11','7-302',11,11,1,'2007-12-18','tsoft',1,5);
INSERT INTO `tb_bookinfo` VALUES ('9787302047492','DHTML动态网页制作',3,'shuangyulin','ceshi','7-302',45,221,4,'2009-04-25','admin',1,7);
INSERT INTO `tb_bookinfo` VALUES ('9787508614557 ','巴菲特教你读财报',1,'(美)玛丽.巴菲特;戴维.克拉克','李凤','978-6',30,179,3,'2009-12-18','admin',0,8);
INSERT INTO `tb_bookinfo` VALUES ('9787802235281','不抱怨时间:谁说重要事不能明天做',1,'(英)马克.福斯特','于海生','978-5',20,0,3,'2009-12-18','admin',0,9);
INSERT INTO `tb_bookinfo` VALUES ('9787040276985 ','全国硕士研究生入学统一考试英语考试大纲解析:2010年版',1,'本书编写组','','010',32,266,4,'2009-12-18','admin',0,10);
INSERT INTO `tb_bookinfo` VALUES ('9787300087993','新托业词汇必备',8,'(韩)文德','付莉','010',58,515,3,'2009-12-18','admin',0,11);

#
# Table structure for table tb_booktype
#