图书馆业务信息系统1

CREATE TABLE BookInfo ( bookid int(4) NOT NULL UNIQUE , bookname varchar(100) , pubname varchar(100) , bookauthor varchar(50) , series varchar(50) , ISBN varchar(50) , SearchNO varchar(50) , PubDate smalldatetime(4) , Price float(8) , Barcode varchar(50) ); CREATE TABLE LendInfo (