【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:jsp_library.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
# Database : `jsp_library`
# --------------------------------------------------------
#
# Table structure for table `borrowrec`
#
DROP TABLE IF EXISTS borrowrec;
CREATE TABLE borrowrec (
borrowRecNumber int(10) NOT NULL auto_increment,
itemCallNumber varchar(20) NOT NULL default '0',
staffIDBorrow varchar(10) NOT NULL default '',
staffIDReturn varchar(10) default NULL,
borrowerID varchar(10) NOT NULL default '0',
borrowerEmail varchar(50) NOT NULL default '',
borrowDate date NOT NULL default '0000-00-00',
dueDate date NOT NULL default '0000-00-00',
returnDate date default '0000-00-00',
borrowStatus varchar(10) NOT NULL default '0',
PRIMARY KEY (borrowRecNumber),
UNIQUE KEY BorrowRefNumber (borrowRecNumber),
KEY BorrowRefNumber_2 (borrowRecNumber)
) TYPE=MyISAM;
#
# Dumping data for table `borrowrec`
#
# --------------------------------------------------------
#
# Table structure for table `libraryitem`
#
DROP TABLE IF EXISTS libraryitem;
CREATE TABLE libraryitem (
itemRecNumber int(11) NOT NULL auto_increment,
itemCallNumber varchar(20) NOT NULL default '',
itemCategory varchar(40) NOT NULL default '',
itemSubject varchar(40) NOT NULL default '',
itemMediaType varchar(25) NOT NULL default '',
itemLanguage varchar(25) NOT NULL default '',
itemTitle varchar(150) NOT NULL default '',
itemBriefDesc varchar(200) default NULL,
itemAuthor varchar(200) default NULL,
itemKeyword varchar(100) NOT NULL default '',
itemPublisherName varchar(30) default NULL,
itemISBN varchar(15) default NULL,
itemLength varchar(6) default NULL,
itemYear varchar(4) default NULL,
itemTotQuantity int(3) NOT NULL default '0',
itemTotReserve int(3) NOT NULL default '0',
itemTotAvailable int(3) NOT NULL default '0',
itemTotBorrow int(3) NOT NULL default '0',
PRIMARY KEY (itemRecNumber),
UNIQUE KEY itemCallNumber (itemCallNumber),
UNIQUE KEY itemTitle (itemTitle)
) TYPE=MyISAM;
#
# Dumping data for table `libraryitem`
#
INSERT INTO libraryitem (itemRecNumber, itemCallNumber, itemCategory, itemSubject, itemMediaType, itemLanguage, itemTitle, itemBriefDesc, itemAuthor, itemKeyword, itemPublisherName, itemISBN, itemLength, itemYear, itemTotQuantity, itemTotReserve, itemTotAvailable, itemTotBorrow) VALUES (8, 'C209-B001-1', 'Computing', 'Web Development', 'Book', 'English', 'Professional JSP', '
JSP development book', 'Karl Avedal, Danny Ayers, Timothy Briggs', 'JSP, Servlet, Java, Web, Programming', 'Wrox', '1861003625', '600', '2000', 2, 0, 2, 0),
(9, 'B101-B001-9', 'Business', 'CRM', 'Book', 'English', 'CRM at the Speed of Light: Capturing and Keeping Customers in Internet Real Time', 'A book about Customer Relationship Management', 'Paul Greenberg', 'CRM, Business, Internet', 'McGraw-Hill', '0072127821', '600', '2001', 2, 0, 2, 0),
(11, 'B101-B001-11', 'Business', 'CRM', 'Book', 'English', 'E-loyalty: How to keep customer coming back to your web site', 'About Customer Loyalty', 'Ellen Reid Smith', 'Loyalty, CRM', 'Harperbusiness', '0066620708', '600', '2000', 2, 0, 2, 0),
(15, 'C203-B001-15', 'Computing', 'Computer Graphics', 'Book', 'Chinese', 'Photoshop character art 100 example', 'Teach U how to create 100 type of art type character using photoshop', 'Than Sia Lin', 'photoshop', 'people electronic mailing', '7115071039', '230', '1998', 2, 0, 2, 0),
(16, 'B106-B001-16', 'Business', 'Information Systems', 'Book', 'English', 'The Road Ahead', 'A vision from bill gate', 'Bill Gate', 'Microsoft, bill gate, IT', 'Viking', '0670772895', '282', '1995', 2, 0, 2, 0),
(17, 'B106-B001-17', 'Business', 'Information Systems', 'Book', 'English', 'The Skin of Culture: Investigating the new electronic reality', 'Description of the future life and culture in digital age', 'De Kerckhove', 'Future, culture, electronic', 'somerville', '1895897459', '223', '1995', 1, 0, 1, 0),
(18, 'A103-B001-18', 'Arts', 'English Literature', 'Book', 'English', 'Harry Potter and the goblet of fire', 'The 3th book for Harry Potter', 'J.K.Rowling', 'Harry Potter, Magic', 'Bloomsbury', '0747550999', '636', '2001', 1, 0, 1, 0),
(19, 'C208-B001-19', 'Computing', 'Telecommunication', 'Book', 'English', 'Business Data Communications', 'Telecommunication usages in business', 'William Stallings, Richard Van Slyke', 'Business, Communication, Telecommunication', 'Prentic