-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathsampleData.sql
31 lines (29 loc) · 6.39 KB
/
sampleData.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
insert into Category (CategoryId, CategoryName) values (1,'Biography');
insert into Category (CategoryId, CategoryName) values (2,'Business');
insert into Category (CategoryId, CategoryName) values (3,'Computing');
insert into Category (CategoryId, CategoryName) values (4,'Fiction');
insert into Category (CategoryId, CategoryName) values (5,'History');
insert into Category (CategoryId, CategoryName) values (6,'Humour');
insert into Category (CategoryId, CategoryName) values (7,'School');
insert into Category (CategoryId, CategoryName) values (8,'Science and Nature');
insert into Category (CategoryId, CategoryName) values (9,'Sport');
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (1, 4, '504107667-7', 'Face to face composite functionalities', 'Deb Fawdrie', 'morbi non lectus aliquam sit amet diam in magna', 'Conroy, Medhurst and Schaefer', 3, 1998, 96, 56.69);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (2, 2, '016022185-4', 'Devolved uniform hub', 'Daisey Thormann', 'hac habitasse platea dictumst morbi vestibulum velit id pretium iaculis', 'Corkery, Daugherty and Wolf', 2, 2010, 53, 95.6);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (3, 4, '445145562-6', 'Digitized interactive success', 'Katrinka Trewman', 'augue vestibulum ante ipsum primis in', 'Lindgren, Roberts and Langosh', 2, 2006, 71, 11.36);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (4, 8, '639222014-3', 'Seamless non-volatile migration', 'Jenilee Knewstub', 'aliquet pulvinar sed nisl nunc rhoncus dui vel', 'Quigley-Nikolaus', 2, 1997, 77, 31.83);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (5, 6, '812174126-2', 'Assimilated asynchronous paradigm', 'Chaddy Fishbourn', 'ante ipsum primis in faucibus orci', 'Bins Inc', 3, 2004, 27, 58.76);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (6, 5, '247210770-6', 'Organized tangible process improvement', 'Hugh Laudham', 'mattis nibh ligula nec sem duis', 'Littel, Brown and Schroeder', 2, 2012, 66, 79.29);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (7, 4, '799228152-7', 'User-friendly disintermediate installation', 'Robbie Milan', 'elementum in hac habitasse platea dictumst morbi vestibulum', 'Jakubowski Group', 2, 1989, 42, 59.76);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (8, 8, '375250759-4', 'Team-oriented bottom-line info-mediaries', 'Paton MacDuffie', 'turpis enim blandit mi in porttitor', 'Vandervort-Wisoky', 3, 2009, 81, 91.39);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (9, 5, '534037627-3', 'Phased dedicated neural-net', 'Rouvin Roake', 'in faucibus orci luctus et ultrices posuere cubilia', 'Schultz, Gleason and Smitham', 1, 1998, 7, 22.79);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (10, 9, '999479182-6', 'Programmable mission-critical initiative', 'Joyous Josskoviz', 'elementum in hac habitasse platea dictumst morbi vestibulum velit', 'Macejkovic-Kunze', 3, 2008, 59, 89.82);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (11, 5, '554979553-1', 'Proactive client-driven capacity', 'Merrill Belz', 'nunc purus phasellus in felis donec semper sapien a', 'Cartwright-Grady', 3, 2009, 27, 43.3);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (12, 1, '318426141-7', 'Expanded fresh-thinking groupware', 'Yoshiko Tierney', 'scelerisque quam turpis adipiscing lorem vitae mattis nibh ligula nec', 'Nader, Schinner and Murphy', 1, 2005, 4, 10.66);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (13, 4, '533503752-0', 'Universal executive artificial intelligence', 'Rochell Rippon', 'consequat lectus in est risus auctor sed tristique in tempus', 'Goodwin-Sipes', 3, 2002, 66, 58.71);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (14, 6, '325476058-1', 'Reduced interactive paradigm', 'Amerigo Jeays', 'elementum in hac habitasse platea', 'Schiller and Sons', 3, 2002, 51, 85.13);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (15, 6, '835692170-8', 'Synergized exuding data-warehouse', 'Jordan Dashwood', 'proin risus praesent lectus vestibulum quam', 'Boyer, Rogahn and Dooley', 2, 2000, 97, 84.57);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (16, 4, '672080084-1', 'Expanded 5th generation analyzer', 'Gael Pudsall', 'eleifend donec ut dolor morbi vel', 'Ward Inc', 3, 2012, 52, 76.75);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (17, 4, '704713028-4', 'Exclusive secondary interface', 'Hodge Jouning', 'aenean auctor gravida sem praesent id massa id nisl venenatis', 'Dooley Inc', 3, 1993, 21, 84.4);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (18, 4, '178345901-8', 'Total multimedia structure', 'Geri Feathers', 'nullam varius nulla facilisi cras non', 'Bins Group', 2, 1991, 59, 73.26);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (19, 5, '830576462-1', 'Business-focused radical ability', 'Richmond Luckwell', 'cubilia curae nulla dapibus dolor vel est donec odio justo', 'Hodkiewicz, Ebert and Connelly', 3, 1998, 48, 89.1);
insert into Book (BookId, CategoryId, ISBN, Title, Author, Description, Publisher, Edition, Year, Stock, Price) values (20, 5, '150398615-2', 'Business-focused systematic groupware', 'Zorah Hanning', 'congue elementum in hac habitasse platea dictumst morbi vestibulum velit', 'Marks LLC', 2, 1993, 10, 45.69);