new project 20081124 0354.sql

一套网上书店系统采用JAVABEAN+SERVLET+JSP

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.51a-community-nt


/*!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 */;

/*!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' */;


--
-- Create schema dangbook
--

CREATE DATABASE IF NOT EXISTS dangbook;
USE dangbook;

--
-- Definition of table `admin`
--

DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin`
--

/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` (`id`,`name`,`password`) VALUES 
 (1,'111111','111111');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;


--
-- Definition of table `author`
--

DROP TABLE IF EXISTS `author`;
CREATE TABLE `author` (
  `aid` int(10) unsigned NOT NULL auto_increment,
  `authorname` varchar(45) NOT NULL,
  `introduction` longtext NOT NULL,
  PRIMARY KEY  (`aid`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `author`
--

/*!40000 ALTER TABLE `author` DISABLE KEYS */;
INSERT INTO `author` (`aid`,`authorname`,`introduction`) VALUES 
 (1,'当年明月','该作者是一个具有古风气息的作者，他潇洒的写作风格得到很多女性的亲睐'),
 (2,'fdsa',''),
 (3,'ffff',''),
 (4,'ffffs',''),
 (5,'aaaaa',''),
 (6,'bbbbbbbbb',''),
 (7,'ccccccccccc',''),
 (8,'ddddd',''),
 (9,'fdsafdsafdsa',''),
 (10,'fdsafdsafdsas',''),
 (11,'fdsafdsafdsasa',''),
 (12,'fdsafdsafdsasaa',''),
 (13,'fdsafdsafdsasaaa',''),
 (16,'ddd',''),
 (18,'few','');
/*!40000 ALTER TABLE `author` ENABLE KEYS */;


--
-- Definition of table `bookconcem`
--

DROP TABLE IF EXISTS `bookconcem`;
CREATE TABLE `bookconcem` (
  `cid` int(10) unsigned NOT NULL auto_increment,
  `concemname` varchar(45) NOT NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bookconcem`
--

/*!40000 ALTER TABLE `bookconcem` DISABLE KEYS */;
INSERT INTO `bookconcem` (`cid`,`concemname`) VALUES 
 (1,'中国海关出版社'),
 (2,'北京大学出版社'),
 (3,'经济科学出版社'),
 (4,'中国财经经济出版社'),
 (5,'经济管理出版社'),
 (6,'中信出版社'),
 (7,'共和联动出版公司'),
 (8,'北京时代光华图书有限公司'),
 (9,'光明书架（图书）有限公司'),
 (10,'北京新曲线出版咨询公司'),
 (11,'21世纪出版社'),
 (12,'重庆出版社'),
 (13,'贵州人名出版社'),
 (14,'接力出版社'),
 (15,'北京科学技术出版社'),
 (16,'新蕾出版社'),
 (17,'明天出版社'),
 (18,'四川少年儿童出版社'),
 (19,'东方音像电子出版社'),
 (20,'北京汉唐之道图书出版社'),
 (21,'上海交通大学出版社'),
 (22,'同济大学出版社'),
 (23,'中国建筑书店有限责任公司'),
 (24,'海豚传媒股份有限公司'),
 (25,'人民教育出版社'),
 (26,'北京正清文化艺术责任有限公司'),
 (27,'湖南少年儿童出版社'),
 (28,'博集天卷'),
 (29,'人民军医出版社'),
 (30,'武汉现代外国语言文学研究所'),
 (31,'中国福利会出版社'),
 (32,'重庆大学出版社'),
 (33,'中国医学科技出版社'),
 (34,'长沙无量文化公司'),
 (35,'中州古籍出版社'),
 (36,'北京东方青鸟图书有限公司'),
 (37,'中国纺织出版社'),
 (38,'金爵文化公司'),
 (39,'北京于都时代图书有限公司'),
 (40,'南京东南大学出版社'),
 (41,'昆明洪盛图书有限公司'),
 (43,'请在这里选择出版社');
/*!40000 ALTER TABLE `bookconcem` ENABLE KEYS */;


--
-- Definition of table `books`
--

DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
  `bid` int(10) unsigned NOT NULL auto_increment,
  `bookname` varchar(45) NOT NULL,
  `bcid` int(10) unsigned default NULL,
  `isbn` varchar(45) NOT NULL,
  `publishtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `price` double NOT NULL,
  `clickcount` int(10) unsigned NOT NULL,
  `free` double NOT NULL,
  `description` longtext NOT NULL,
  `aid` int(10) unsigned NOT NULL,
  `point` int(10) unsigned NOT NULL,
  `cover` varchar(45) NOT NULL,
  `tid` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`bid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `books`
--

/*!40000 ALTER TABLE `books` DISABLE KEYS */;
INSERT INTO `books` (`bid`,`bookname`,`bcid`,`isbn`,`publishtime`,`price`,`clickcount`,`free`,`description`,`aid`,`point`,`cover`,`tid`) VALUES 
 (2,'ewrre',1,'4r32r3','2008-11-24 03:40:42',34,0,3,'<p>&nbsp;fds</p>',16,100,'8822012_m[1].jpg',3),
 (3,'当年明月',2,'43243','2008-11-24 03:40:43',43,0,3,'<p>&nbsp;fdsafd</p>',17,100,'8783815_m[1].jpg',3),
 (5,'fds',17,'324','2008-11-13 00:00:00',43,0,3,'<p>&nbsp;safds</p>',18,100,'8822012_m[1].jpg',3);
/*!40000 ALTER TABLE `books` ENABLE KEYS */;


--
-- Definition of table `onetype`
--

DROP TABLE IF EXISTS `onetype`;
CREATE TABLE `onetype` (
  `oid` int(10) unsigned NOT NULL auto_increment,
  `typename` varchar(45) NOT NULL,
  PRIMARY KEY  USING BTREE (`oid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `onetype`
--

/*!40000 ALTER TABLE `onetype` DISABLE KEYS */;
INSERT INTO `onetype` (`oid`,`typename`) VALUES 
 (1,'小说'),
 (2,'文艺'),
 (3,'青春'),
 (4,'励志'),
 (5,'少儿'),
 (6,'生活'),
 (7,'人文社科'),
 (8,'管理'),
 (9,'个人理财'),
 (10,'科技'),
 (11,'教育'),
 (12,'工具书'),
 (13,'国外原版书');
/*!40000 ALTER TABLE `onetype` ENABLE KEYS */;


--
-- Definition of table `twotype`
--

DROP TABLE IF EXISTS `twotype`;
CREATE TABLE `twotype` (
  `tid` int(10) unsigned NOT NULL auto_increment,
  `typename` varchar(45) NOT NULL,
  `oid` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `twotype`
--

/*!40000 ALTER TABLE `twotype` DISABLE KEYS */;
INSERT INTO `twotype` (`tid`,`typename`,`oid`) VALUES 
 (1,'悬疑',1),
 (2,'武侠',1),
 (3,'言情',1),
 (4,'官场',1),
 (5,'历史',1),
 (6,'财经',1),
 (7,'军事',1),
 (8,'作品集',1),
 (9,'世界名著',1),
 (10,'港台',1),
 (11,'文学',2),
 (12,'传记',2),
 (13,'艺术',2),
 (14,'摄影',2),
 (15,'设计',2),
 (16,'美术',2),
 (17,'音乐',2),
 (18,'青春文学',3),
 (19,'娱乐/偶像',3),
 (20,'动漫',3),
 (21,'幽默',3),
 (22,'日韩漫画',3),
 (23,'修养',4),
 (24,'成功',4),
 (25,'求职',4),
 (26,'职场',4),
 (27,'沟通',4),
 (28,'礼仪',4),
 (29,'调节',4),
 (30,'0-2',5),
 (31,'3-6',5),
 (32,'7-10',5),
 (33,'11-14',5),
 (34,'文学',5),
 (35,'科普/百科',5),
 (36,'图画书',5),
 (37,'启蒙',5),
 (38,'美食',6),
 (39,'旅游',6),
 (40,'地图',6),
 (41,'保健',6),
 (42,'体育',6),
 (43,'瑜伽',6),
 (44,'美丽装扮',6),
 (45,'装潢',6),
 (46,'育儿',6),
 (47,'家庭教育',6),
 (48,'两性',6),
 (49,'炒股',6),
 (50,'家居/休闲',6),
 (51,'宠物',6),
 (52,'手工',6),
 (53,'收藏鉴赏',6),
 (54,'游戏',6),
 (55,'占卜',6),
 (56,'文化',7),
 (57,'历史',7),
 (58,'哲学/宗教',7),
 (59,'古籍',7),
 (60,'政治/军事',7),
 (61,'法律',7),
 (62,'经济',7),
 (63,'社会科学',7),
 (64,'心理学',7),
 (65,'教育学',7),
 (66,'新闻传播出版',7),
 (67,'管理',8),
 (68,'营销',8),
 (69,'战略',8),
 (70,'会计',8),
 (71,'投资',8),
 (72,'商业史传',8),
 (73,'运作',8),
 (74,'创业',8),
 (75,'人力资源',8),
 (76,'证劵/股票',9),
 (77,'基金',9),
 (78,'期货',9),
 (79,'外汇',9),
 (80,'保险',9),
 (81,'彩票',9),
 (82,'购物置业',9),
 (83,'纳税',9),
 (84,'投资指南',9),
 (85,'科普',10),
 (86,'建筑',10),
 (87,'医学',10),
 (88,'计算机',10),
 (89,'农业',10),
 (90,'自然科学',10),
 (91,'工业技术',10),
 (92,'通信',10),
 (93,'电工',10),
 (94,'机械',10),
 (95,'环境',10),
 (96,'水利水电',10),
 (97,'金属工艺',10),
 (98,'汽车交通',10),
 (99,'轻工',10),
 (100,'化工',10),
 (101,'标准',10),
 (102,'教材',11),
 (103,'中小学教辅',11),
 (104,'外语',11),
 (105,'考试',11);
/*!40000 ALTER TABLE `twotype` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;