【SQL开源代码栏目提醒】:本文主要为网学会员提供db_book.sql,希望对需要db_book.sql网友有所帮助,学习一下!
-- MySQL dump 10.10
--
-- Host: localhost Database: db_book
-- ------------------------------------------------------
-- Server version 5.0.24a-community-nt-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `tb_admin`
--
DROP TABLE IF EXISTS `tb_admin`;
CREATE TABLE `tb_admin` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`pwd` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tb_admin`
--
/*!40000 ALTER TABLE `tb_admin` DISABLE KEYS */;
LOCK TABLES `tb_admin` WRITE;
INSERT INTO `tb_admin` VALUES (1,'mr','fdb390e945559e74475ed8c8bbb48ca5');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tb_admin` ENABLE KEYS */;
--
-- Table structure for table `tb_bdxz`
--
DROP TABLE IF EXISTS `tb_bdxz`;
CREATE TABLE `tb_bdxz` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(200) default NULL,
`content` mediumtext,
`createtime` datetime default NULL,
`click` int(8) default NULL,
`address` varchar(200) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tb_bdxz`
--
/*!40000 ALTER TABLE `tb_bdxz` DISABLE KEYS */;
LOCK TABLES `tb_bdxz` WRITE;
INSERT INTO `tb_bdxz` VALUES (6,'dd','d','2007-01-29 15:53:29',0,'./admin/upbd/20070129.jpg');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tb_bdxz` ENABLE KEYS */;
--
-- Table structure for table `tb_book`
--
DROP TABLE IF EXISTS `tb_book`;
CREATE TABLE `tb_book` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(200) default NULL,
`addtime` datetime default NULL,
`click` int(8) default NULL,
`bookno` varchar(100) default NULL,
`typeid` int(8) default NULL,
`seriesid` int(8) default NULL,
`tpi` varchar(200) default NULL,
`writer` varchar(200) default NULL,
`booklist` text,
`introduce` mediumtext,
`zishu` int(8) NOT NULL,
`editiontimes` varchar(200) default NULL,
`bookpage` int(8) default NULL,
`price` float default NULL,
`pdate` date default NULL,
`picture` varchar(200) default NULL,
`isnew` int(2) default NULL,
`istuijian` int(2) default NULL,
`easetype` int(2) default NULL,
`isvod` int(2) default NULL,
`yb` int(8) default NULL,
`jh` int(8) default NULL,
`hh` int(8) default NULL,
`address1` varchar(200) default NULL,
`address2` varchar(200) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tb_book`
--
/*!40000 ALTER TABLE `tb_book` DISABLE KEYS */;
LOCK TABLES `tb_book` WRITE;
INSERT INTO `tb_book` VALUES (14,'銆夾SP鏁版嵁搴撳紑鍙戝畬鍏ㄦ墜鍐屻?,'2007-01-29 11:26:34',0,'112-111-22',1,4,'浜烘皯閭數鍑虹増绀?,'dd','11','11',11,'11',11,11,'2001-02-02','./admin/upimages/200701291126344630531.jpg',1,1,0,0,0,0,0,'',''),(15,'銆奃elphi鏁版嵁搴撳紑鍙戝畬鍏ㄦ墜鍐屻?,'2007-01-29 11:27:33',0,'11-20-111',6,1,'浜烘皯閭數鍑虹増绀?,'11','1','1',11,'1',11,11,'2002-03-03','./admin/upimages/200701291127338295043.jpg',1,1,0,0,0,0,0,'./admin/upfiles/200701291127337597340.jpg',''),(12,'銆奐SP鏁版嵁搴撳紑鍙戝畬鍏ㄦ墜鍐屻?,'2007-01-29 11:19:37',3,'1-11-1112',3,6,'浜烘皯閭數鍑虹増绀?,'鏄庢棩绉戞妧','11','111',40000,'1',23,11,'2002-03-03','./admin/upimages/20070129.jpg',1,1,0,0,0,0,0,'./admin/upfiles/20070129.jpg','http://www.dangdang.com'),(16,'銆夾SP瀹屽叏鎵嬪唽銆?,'2007-01-29 11:28:43',0,'11',1,7,'浜烘皯閭數鍑虹増绀?,'11','1','1',111,'11',11,11,'2001-01-02','./admin/upimages/200701291128437743448.jpg',1,1,0,0,0,0,0,'','1'),(17,'銆奃elphi鑼冧緥瀹濆吀銆?,'2007-01-29 11:29:39',1,'112',6,4,'浜烘皯閭數鍑虹増绀?,'d','1','1',11,'1',