drop database bookstore;
create database bookstore character set utf8;
use bookstore;
create table customer(
customerId varchar(20) primary key,
customerPwd varchar(40) not null,
customerEmail varchar(40) not null,
customerRegTime timestamp default now(),
customerName varchar(20),
customerTel varchar(20),
customerPost varchar(20),
customerAddress varchar(40),
customerLevel int default 1
);
create table book(
bookId varchar(40) primary key,
bookName varchar(40),
bookAuthority varchar(40),
bookPublisher varchar(40),
bookDate varchar(40),
bookPrice float(11,2),
bookDiscount float(11,2),
bookText text,
bookType varchar(10),
detailType varchar(10),
bookStock int default 1,
isSelling int default 1,
isNew int default 1,
isRecommend int default 1,
bookPhoto varchar(80),
bookSellNumber int
);
create table bookType(
bookId varchar(40) primary key,
bookType varchar(10)
);
create table orders(
orderId varchar(40) primary key,
customerId varchar(20),
orderStatus int default 0,
orderMoney float(11,2),
orderDate timestamp default now()
);
create table orderDetail(
orderId varchar(40),
bookId varchar(40),
bookName varchar(40),
bookNumber int,
bookMoney float(11,2)
);
create table admin(
adminId int primary key auto_increment,
adminName varchar(20),
adminPwd varchar(40) default "123456",
adminTel varchar(20),
adminLevel int default 0,
adminEmail varchar(40)
);
create table favourite(
customerId varchar(20),
bookId varchar(40)
);
alter table orderDetail add constraint pk_orderDetail_orderId foreign key(orderId) references orders(orderId);
alter table orders add constraint pk_orders_customerId foreign key(customerId) references customer(customerId);
/*alter table orderDetail add constraint pk_orderDetail_bookId foreign key(bookId) references book(bookId);*/
/*insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("aaaaa","aaaaa","aaaaa@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("bbbbb","bbbbb","bbbbb@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("ccccc","ccccc","ccccc@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("ddddd","ddddd","ddddd@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("eeeee","eeeee","eeeee@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("fffff","fffff","fffff@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("ggggg","ggggg","ddddd@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("hhhhh","hhhhh","ddddd@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("iiiii","iiiii","ddddd@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime) values("jjjjj","jjjjj","ddddd@163.com",default);
insert into customer(customerId,customerPwd,customerEmail,customerRegTime,customerName) values("ttttt","ttttt","ddddd@163.com",default,"张已");
*/
insert into admin values(default,"张星伟","zxw","15912345678",1,"24kb8@163.com");
insert into admin values(default,"张一","zxw","15912345678",default,"24kb8@163.com");
insert into admin values(default,"张星伟","zxw","15912345678",1,"24kb8@163.com");
insert into admin values(default,"张二","zxw","15912345678",default,"24kb8@163.com");
insert into admin values(default,"张三","zxw","15912345678",default,"24kb8@163.com");
insert into admin values(default,"张四","zxw","15912345678",default,"24kb8@163.com");
insert into admin values(default,"张五","zxw","15912345678",default,"24kb8@163.com");
insert into book values("9787512606425","东城西咎","蓝药师","团结出版社","2012-4-1",56.00,0.71,"首部娱乐业王朝的长篇批判","小说","哲学",50,default,default,default,"/book/xiaoshuo/dcxj.bmp",34);
insert into book values("9787802259812","橘子不是唯一的水果","(英)温特森","新星出版社","2010-7-1",25.00,0.65,"惠特布莱德首作奖获奖作品","小说","哲学",50,default,default,default,"/book/xiaoshuo/jzbswydsg.bmp",24);
insert into book values("9787533932312","老人与海","(美)海明威","浙江文艺出版社","2012-1-1",22.00,0.65,"海明威逝世五十周年纪念版","小说","哲学",50,default,default,default,"/book/xiaoshuo/lryh.bmp",21);
insert into book values("20920367","莲花","安妮宝贝","万卷出版社","2010-1-1",25.00,0.60,"摄影珍藏版","小说","青春",50,default,default,default,"/book/xiaoshuo/lh.bmp",18);
insert into book values("22569765","马克斯.弗里施小说作品","马克斯.弗里施","重庆大学出版社","2012-1-1",88.00,0.72,"最接近诗的德语文学经典作品","小说","史诗",50,default,default,default,"/book/xiaoshuo/mksslsxs.bmp",16);
insert into book values("9787540451240","男人帮","唐俊","湖南文艺出版社","2011-10-1",40.00,0.55,"恋爱中的男人到底是怎么想的?","小说","青春",50,default,default,default,"/book/xiaoshuo/nrb.bmp",62);
insert into book values("9787562462224","青衣","毕飞宇","重庆大学出版社","2011-8-1",29.00,0.61,"第八届矛盾文学奖得主,电视剧<青衣>原著","小说","青春",50,default,default,default,"/book/xiaoshuo/qy.bmp",35);
insert into book values("9787806811825","消失的地平线","希尔顿","上海社会科学院出版社","2003-4-1",48.00,0.60,"","小说","哲学",50,default,default,default,"/book/xiaoshuo/xsddpx.bmp",32);
insert into book values("9787539946474","小情敌","艾米","江苏文艺出版社","2011-4-1",28.00,0.65,"<山楂树之恋>之后,艾米写给所有家庭的爱之书","小说","青春",50,default,default,default,"/book/xiaoshuo/xqd.bmp",30);
insert into book values("9787544721417","最后一次说爱你","(美)米尔尼","译林出版社","2011-9-1",28.00,0.54,"美国纯爱疗伤小说天王最新力作","小说","青春",50,default,default,default,"/book/xiaoshuo/zhycsan.bmp",12);
insert into book values ("9787521702035","美国语文","张建鹏","中国妇女出版社","2011-5-1",118.00,0.59,"600多名读者热评,精装留学版","教育","语文",50,default,default,default,"/book/jiaoyu/mgyw.bmp",5);
insert into book values ("9787535164377","丁丁上学记","刘雷","湖北教育出版社","2011-3-1",53.60,0.49,"小学生最佳学习方法原创读本","教育","读物",50,default,default,default,"/book/jiaoyu/ddsx.bmp",6);
insert into book values ("20841112","火柴棒医生手记","周尔晋","合肥工业大学出版社","2010-5-1",84.00,0.61,"人体药库学三部曲","教育","读物",50,default,default,default,"/book/jiaoyu/hcbyssj.bmp",8);
insert into book values ("9787504357991","让你的英语口语不再雷死人","(加)马特","中国广播电视出版社","2009-5-1",20.00,0.71,"网络独家奉献","教育","英语",50,default,default,default,"/book/jiaoyu/rndyykybzlr.bmp",12);
insert into book values ("9787530859742","我爱写作文","李锡琴","天津科学技术出版社","2010-9-1",25.80,0.58,"小学生牛牛提高写作能力的36个趣味故事","教育","语文",50,default,default,default,"/book/jiaoyu/waxzw.bmp",2);
insert into book values ("9787540685430","我教儿子学作文","肖复兴","广东教育出版社","2011-12-1",28.00,0.59,"最新版—中国教育学会家教专业委员会特别推荐","教育","语文",50,default,default,default,"/book/jiaoyu/wjezxzw.bmp",2);
insert into book values ("9787213044083","大败局","吴晓波","浙江人民出版社","2010-12-1",80.00,0.55,"十周年套装纪念版","经管","商战",50,default,default,default,"/book/jingguan/dbj.bmp",35);
insert into book values ("9787511507327","不做经济白痴","李鹏鹏","人民日报出版社","2012-1-1",36.00,0.54,"我最想知道的108个经济常识","经管","经济",50,default,default,default,"/book/jingguan/bzjjbc.bmp",24);
insert into book values ("9787203075219","操盘之王III","王晓","山西任命出版社发行部","2012-3-1",77.70,0.69,"图霸天下","经管","股票",50,default,default,default,"/book/jingguan/cpzw.bmp",35);
insert into book values ("9787508631691","创业36条军规","孙陶然","中信出版社","2012-1-1",40.00,0.65,"36位名人联袂点评推荐","经管","管理",50,default,default,default,"/book/jingguan/cy36tjg.bmp",45);
insert into book values ("9787508521718","大商人","傅国涌","五洲传播出版社","20
评论2
最新资源