use bookstore;

create table bookinfo(id INT not null primary key,title VARCHAR(50) not null,author VARCHAR(50) not null,bookconcern VARCHAR(100) not null,publish_date DATE not null,price FLOAT(4,2) not null,amount SMALLINT,remark VARCHAR(200));

insert into bookinfo values(1,'Java從入門到精通','張三','張三出版社','2004-6-1',34.00,35,null);
insert into bookinfo values(2,'JSP深入編程','李四','李四出版社','2004-10-1',56.00,20,null);
insert into bookinfo values(3,'J2EE高級編程','王五','王五出版社','2005-3-1',78.00,10,null);

create table account(userid VARCHAR(10) not null primary key,balance FLOAT(6,2));
insert account values("甲",500.00);
insert account values("乙",200.00);