· 8 years ago · Apr 20, 2018, 05:48 PM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9-- --------------------------------------------------------
10
11--
12-- Table structure for table `nbc_book`
13--
14
15DROP TABLE IF EXISTS `nbc_book`;
16CREATE TABLE IF NOT EXISTS `nbc_book` (
17 `bookISBN` varchar(10) NOT NULL default '',
18 `bookTitle` varchar(255) default NULL,
19 `bookYear` varchar(4) default NULL,
20 `pubID` varchar(6) default NULL,
21 `catID` varchar(6) default NULL,
22 `bookPrice` decimal(4,2) default NULL,
23 PRIMARY KEY (`bookISBN`)
24) ENGINE=InnoDB DEFAULT CHARSET=latin1;
25
26--
27-- Dumping data for table `nbc_book`
28--
29
30INSERT INTO `nbc_book` (`bookISBN`, `bookTitle`, `bookYear`, `pubID`, `catID`, `bookPrice`) VALUES
31('0072193883', 'Oracle 9i: Web Development (Oracle Press)', '2000', 'OSBMCG', 'DBWEB', 31.81),
32('0201708574', 'Database Systems: A Practical Approach to Design, Implementation and Management', '2006', 'ADDWES', 'DB', 34.99),
33('0552134635', 'Moving Pictures', '1998', 'CORGI', 'FICT', 5.49),
34('0552134651', 'Witches Abroad', '1999', 'CORGI', 'FICT', 5.59),
35('0596001207', 'CSS Pocket Reference', '2005', 'OREILL', 'WEBDEV', 5.56),
36('059600382X', 'HTML & XHTML: the Definitive Guide', '2001', 'OREILL', 'WEBDEV', 19.95),
37('0596004419', 'Oracle SQL*Plus Pocket Reference', '2006', 'OREILL', 'DB', 5.56),
38('0672326280', 'Sams Teach Yourself Java in 21 Days', '2006', 'SAMS', 'PROG', 14.49),
39('0735619050', 'Visual Basic .NET Step-by-Step', '2007', 'MSPRES', 'PROG', 9.59),
40('0764544004', 'Professional VB.NET 2e', '2006', 'WROX', 'PROG', 21.99),
41('0886313197', 'Oracle PL/SQL Programming, 5th Edition', '2009', 'MSPRES', 'DB', 20.00),
42('1012654901', 'The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling', '2004', 'MSPRES', 'DB', 20.00),
43('1086146848', 'Asterisk: The Future of Telephony, 2nd Edition', '2007', 'MSPRES', 'PROG', 20.00),
44('1098557004', 'Java in a nutshell (5th ed)', '2005', 'MSPRES', 'PROG', 20.00),
45('1128483837', 'Programming ASP.NET 3.5 (4th edition)', '2008', 'MSPRES', 'WEBDEV', 20.00),
46('1151138597', 'Understanding TCP/IP', '2008', 'OREILL', 'NETW', 24.99),
47('1202902579', 'Head First Servlets and JSP, 2nd Edition', '2008', 'MSPRES', 'PROG', 20.00),
48('1202959077', 'Visual modelling with IBM rational software architecture and UML', '2009', 'MSPRES', 'PROG', 20.00),
49('1215671513', 'Ajax Design Patterns', '2006', 'SAMS', 'WEBDEV', 20.00),
50('1234850781', 'XHML & Web 2', '2009', 'SAMS', 'WEB', 14.95),
51('1257055523', 'Java for programmers', '2009', 'MSPRES', 'PROG', 20.00),
52('1270878867', 'XSLT 2.0 Web Development', '2004', 'SAMS', 'WEBDEV', 20.00),
53('1294275728', 'Selling online with Drupal e-commerce', '2008', 'OREILL', 'WEBDEV', 20.00),
54('1359569013', 'Patterns of Enterprise Application Architecture', '2002', 'SAMS', 'PROG', 20.00),
55('1388747028', 'Solid Code: Optimizing the Software Development Life Cycle', '2009', 'MSPRES', 'PROG', 20.00),
56('1442484806', 'Cisco IOS in a nutshell (2nd edition)', '2005', 'MSPRES', 'NETW', 20.00),
57('1448011389', 'HTML, XHTML, & CSS, Sixth Edition: Visual QuickStart Guide', '2006', 'MSPRES', 'WEBDEV', 20.00),
58('1454938470', 'PHP 5 unleashed', '2004', 'MSPRES', 'WEBDEV', 20.00),
59('1462974720', 'Ajax: the definitive guide', '2008', 'OREILL', 'WEBDEV', 20.00),
60('1506341574', 'PHP for Professionals', '2008', 'SAMS', 'DBWEB', 35.75),
61('1535076269', 'Head first PMP : a brain-friendly guide to passing the Project Management Professional Exam(2nd ed)', '2009', 'MSPRES', 'BUS', 20.00),
62('1559510187', 'Programming in objective C 2.0 (2nd ed)', '2003', 'MSPRES', 'PROG', 20.00),
63('1565926102', 'Programming PHP', '2006', 'OREILL', 'WEBDEV', 19.95),
64('1565926919', 'Building Oracle XML Applications', '2004', 'OREILL', 'DBWEB', 22.36),
65('1565926920', 'Visual Basic 6 Professional Step-by-Step', '2006', 'MSPRES', 'PROG', 20.99),
66('1565928628', 'HTTP Pocket Reference', '2004', 'OREILL', 'WEBDEV', 5.56),
67('1590592433', 'Expert One-to-one Oracle', '2007', 'APRES', 'DB', 24.74),
68('1691648973', 'Javascript Frameworks', '2009', 'OREILL', 'PROG', 18.00),
69('1716457298', 'jQuery in action', '2007', 'OREILL', 'WEBDEV', 20.00),
70('1762728680', 'YUI - Yahoo Javascript', '2009', 'MSPRES', 'WEBDEV', 19.99),
71('1791402332', 'JavaScript : the definitive guide (5th ed)', '2006', 'MSPRES', 'WEBDEV', 20.00),
72('186100172X', 'Beginning Visual Basic 6 Objects', '1998', 'WROX', 'PROG', 20.29),
73('1884680365', 'Enterprise Application Development with Flex', '2008', 'SAMS', 'PROG', 20.00),
74('1886313197', 'ActionScript for multiplayer games and virtual worlds', '2009', 'MSPRES', 'PROG', 20.00),
75('1903337089', 'Databases (Computing Study Texts)', '2007', 'CRUCIA', 'DB', 12.00),
76('1954694274', 'XSL-FO', '2002', 'SAMS', 'PROG', 20.00),
77('1957187241', 'The Definitive Guide to Project Management: The fast track to getting the job done on time and on budget, 2nd edition 2008', '2008', 'MSPRES', 'BUS', 20.00),
78('1969335814', 'ActionScript 3.0 Game Programming University', '2007', 'SAMS', 'PROG', 20.00),
79('2027743377', 'Microsoft Office 2007 for Windows: Visual QuickStart Guide', '2007', 'MSPRES', 'BUS', 20.00),
80('2122290991', 'Sams teach yourself java 6 in 21 days', '2007', 'MSPRES', 'PROG', 20.00),
81('2290216917', 'XPath and XML', '2008', 'OREILL', 'DBWEB', 24.95),
82('2372100748', 'Programming in C (3rd edition)', '2004', 'OREILL', 'PROG', 20.00),
83('2386313197', 'Photoshop CS4 (Visual quickpro guide) vol2', '2009', 'MSPRES', 'WEBDEV', 20.00),
84('2486313197', 'Photoshop CS4 (Visual quickpro guide) vol1', '2008', 'MSPRES', 'WEBDEV', 20.00),
85('2586313197', 'Pro Drupal Development, Second Edition', '2008', 'OREILL', 'WEBDEV', 20.00),
86('2686313197', 'Adobe AIR (Adobe Integrated Runtime) with Ajax: Visual QuickPro Guide', '2008', 'SAMS', 'FLEX', 20.00),
87('2694134112', 'Advanced ActionScript 3 with Design Patterns', '2006', 'SAMS', 'FLEX', 20.00),
88('2786313197', 'Web Accessibility: Web Standards and Regulatory Compliance', '2006', 'MSPRES', 'WEBDEV', 20.00),
89('2886313197', 'CSS anthology', '2007', 'OREILL', 'WEBDEV', 20.00),
90('3343877469', 'Ajax with PHP 5', '2007', 'SAMS', 'WEBDEV', 20.00),
91('3440712688', 'Using Drupral', '2008', 'OREILL', 'BUS', 20.00),
92('4086039351', 'PHP and Smarty on Large-Scale Web Development', '2007', 'SAMS', 'WEBDEV', 20.00),
93('4816425101', 'FlexBuilder with AMFPHP', '2009', 'SAMS', 'FLEX', 24.95),
94('4886313197', 'Dreamweaver CS3 for windows and macintosh', '2007', 'MSPRES', 'WEBDEV', 20.00),
95('5063610941', 'Actionscript with PHP', '2006', 'SAMS', 'FLEX', 20.00),
96('5161992541', 'Beginning iPhone Development Exploring the iPhone SDK', '2008', 'MSPRES', 'PROG', 20.00),
97('5631651361', 'Project Managing Software', '2005', 'MSPRES', 'BUS', 34.75),
98('5886313197', 'A GUIDE TO THE PROJECT MANAGEMENT BODY OF KNOWLEDGE', '2008', 'MSPRES', 'BUS', 20.00),
99('6698738241', 'UML distilled (3rd ed)', '2003', 'MSPRES', 'PROG', 20.00),
100('6852120569', 'Building Web Applications with UML Second Edition', '2002', 'SAMS', 'PROG', 20.00),
101('6893500798', 'Unix Not GNU', '2004', 'OREILL', 'PROG', 15.75),
102('7598368395', 'UML and Agile Development', '2009', 'SAMS', 'PROG', 28.90),
103('7886313197', 'A Practical Guide to Linux Commands, Editors, and Shell Programming', '2005', 'SAMS', 'PROG', 20.00),
104('8406317316', 'Adobe Dreamweaver CS3 How-tos : 100 essential techniques', '2007', 'MSPRES', 'WEBDEV', 20.00),
105('8886313197', 'A Practical Guide to Ubuntu Linux', '2007', 'SAMS', 'PROG', 20.00),
106('9265601531', 'OO Design & Development', '2010', 'OREILL', 'PROG', 35.90),
107('9744122522', 'Object-Oriented PHP', '2006', 'SAMS', 'WEBDEV', 20.00),
108('9886313197', 'The Web Application Hacker''s Handbook: Discovering and Exploiting Security Flaws', '2002', 'OREILL', 'WEBDEV', 20.00);
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `nbc_category`
114--
115
116DROP TABLE IF EXISTS `nbc_category`;
117CREATE TABLE IF NOT EXISTS `nbc_category` (
118 `catID` varchar(6) NOT NULL default '',
119 `catDesc` varchar(30) default NULL,
120 PRIMARY KEY (`catID`)
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122
123--
124-- Dumping data for table `nbc_category`
125--
126
127INSERT INTO `nbc_category` (`catID`, `catDesc`) VALUES
128('BUS', 'Business & Commerce'),
129('DB', 'Databases'),
130('DBWEB', 'Databases and Web Development'),
131('FICT', 'Fiction'),
132('FLEX', 'Flex & Flash Programming'),
133('NETW', 'Netorks'),
134('PROG', 'Programming'),
135('SYSD', 'Systems Design'),
136('WEBDEV', 'Web Development');
137
138-- --------------------------------------------------------
139
140--
141-- Table structure for table `nbc_publisher`
142--
143
144DROP TABLE IF EXISTS `nbc_publisher`;
145CREATE TABLE IF NOT EXISTS `nbc_publisher` (
146 `pubID` varchar(6) NOT NULL default '',
147 `pubName` varchar(30) default NULL,
148 `location` varchar(20) default NULL,
149 PRIMARY KEY (`pubID`)
150) ENGINE=InnoDB DEFAULT CHARSET=latin1;
151
152--
153-- Dumping data for table `nbc_publisher`
154--
155
156INSERT INTO `nbc_publisher` (`pubID`, `pubName`, `location`) VALUES
157('ADDWES', 'Addison Wesley', 'UK'),
158('APRES', 'Apress', 'USA'),
159('CORGI', 'Corgi', 'UK'),
160('CRUCIA', 'Crucial', 'UK'),
161('MSPRES', 'Microsoft Press International', 'USA'),
162('OREILL', 'OReilly', 'UK'),
163('OSBMCG', 'Osborne McGraw-Hill', 'USA'),
164('SAMS', 'Sams', 'USA'),
165('WROX', 'Wrox', 'USA');