-
Notifications
You must be signed in to change notification settings - Fork 0
/
BookSqlScript.sql
373 lines (288 loc) · 34.4 KB
/
BookSqlScript.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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
# Dump of table billing_address
# ------------------------------------------------------------
DROP TABLE IF EXISTS `billing_address`;
CREATE TABLE `billing_address` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`billing_address_city` varchar(255) DEFAULT NULL,
`billing_address_country` varchar(255) DEFAULT NULL,
`billing_address_name` varchar(255) DEFAULT NULL,
`billing_address_state` varchar(255) DEFAULT NULL,
`billing_address_street1` varchar(255) DEFAULT NULL,
`billing_address_street2` varchar(255) DEFAULT NULL,
`billing_address_zipcode` varchar(255) DEFAULT NULL,
`order_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKjg6ji2vsfuqlc9vhvy4yi449h` (`order_id`),
CONSTRAINT `FKjg6ji2vsfuqlc9vhvy4yi449h` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table book
# ------------------------------------------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`active` bit(1) NOT NULL,
`author` varchar(255) DEFAULT NULL,
`category` varchar(255) DEFAULT NULL,
`description` text,
`format` varchar(255) DEFAULT NULL,
`in_stock_number` int(11) NOT NULL,
`isbn` int(11) NOT NULL,
`language` varchar(255) DEFAULT NULL,
`list_price` double NOT NULL,
`number_of_pages` int(11) NOT NULL,
`our_price` double NOT NULL,
`publication_date` varchar(255) DEFAULT NULL,
`publisher` varchar(255) DEFAULT NULL,
`shipping_weight` double NOT NULL,
`title` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `book` WRITE;
/*!40000 ALTER TABLE `book` DISABLE KEYS */;
INSERT INTO `book` (`id`, `active`, `author`, `category`, `description`, `format`, `in_stock_number`, `isbn`, `language`, `list_price`, `number_of_pages`, `our_price`, `publication_date`, `publisher`, `shipping_weight`, `title`)
VALUES
(1,b'1','Miles Davis','Arts & Literature','<p><span style=\"color: #333333; font-family: Arial, sans-serif;\">(Guitar Solo). 15 jazzy solo guitar arrangements of Davis classics, including: All Blues * All of You * Blue in Green * Bye Bye Blackbird * Four * Freddie Freeloader * I Could Write a Book * Milestones * Nardis * Nefertiti * Seven Steps to Heaven * So What * Solar * There Is No Greater Love * When I Fall in Love. The CD includes full demos of each piece by Jamie Findlay.</span></p>','paperback',22,634023020,'english',21.95,96,17.51,'2006-02-01','Hal Leonard',12,'Miles Davis for Solo Guitar'),
(2,b'1',' Leonardo Da Vinci','Arts & Literature','<p style=\"margin: 0px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"><strong>An all-new, jewel-like, reader-friendly format gives new life to this relaunch of an international best-seller.</strong></p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"> </p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">Leonardo da Vinci?artist, inventor, and prototypical Renaissance man?is a perennial source of fascination because of his astonishing intellect and boundless curiosity about the natural and man-made world. During his life he created numerous works of art and kept voluminous notebooks that detailed his artistic and intellectual pursuits.</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"> </p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">The collection of writings and art in this magnificent book are drawn from his notebooks. The book organizes his wide range of interests into subjects such as human figures, light and shade, perspective and visual perception, anatomy, botany and landscape, geography, the physical sciences and astronomy, architecture, sculpture, and inventions. Nearly every piece of writing throughout the book is keyed to the piece of artwork it describes.</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"> </p>\r\n<p style=\"margin: -4px 0px 0px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">The writing and art is selected by art historian H. Anna Suh, who provides fascinating commentary and insight into the material, making <em>Leonardo\'s Notebooks</em> an exquisite single-volume compendium celebrating his enduring genius.</p>','paperback',34,1579129463,'english',19.99,448,17.06,'2013-09-24','Black Dog & Leventhal',2,'Leonardo\'s Notebooks: Writing and Art of the Great Master'),
(3,b'1',' Benjamin Spock M.D.','Arts & Literature','<p><span style=\"color: #333333; font-family: Arial, sans-serif;\">Dr. Benjamin Spock is America’s most trusted name in child care and parenting, and his essential guidebook has topped bestseller lists for over sixty-five years. This fully revised and updated edition of the classic manual provides first time and experienced parents the best information about caring for new babies, toddlers, and adolescents in the twenty-first century.</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">All of Dr. Spock’s invaluable, time-tested advice is here, along with the most current medical practices and advances in health care. While still covering key parenting issues like accidents, illnesses and injuries, this edition of the classic also contains the latest on:</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Immunizations</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Nutrition and childhood obesity</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Cultural diversity</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Alternative and non-traditional family structures</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Children’s learning and brain development</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Raising children with special needs</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Environmental health</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Increasingly common disorders such as ADHD, childhood depression, and autism—including medications and behavioral interventions</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">* Children and the media, including screen time, video games, and the internet</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">Updated by leading pediatrician Robert Needlman, the book includes a revised glossary of common medications and a resource guide that compiles the most reliable online resources. This indispensable guide is still the next best thing to Dr. Spock’s #1 rule of parenting: “Trust yourself. You know more than you think you do.”</span></p>','paperback',44,1439189293,'english',12.3,1168,8.71,'2011-12-27','Pocket Books',1,'Dr. Spock\'s Baby and Child Care: 9th Edition'),
(5,b'1',' Danielle Krysa','Arts & Literature','<p><span style=\"color: #333333; font-family: Arial, sans-serif;\">This book is duct tape for the mouth of every artist\'s inner critic. Silencing that stifling voice once and for all, this salve for creatives introduces ten truths they must face in order to defeat self-doubt. Each encouraging chapter deconstructs a pivotal moment on the path to success—fear of the blank page, the dangers of jealousy, sharing work with others—and explains how to navigate roadblock. Packed with helpful anecdotes, thoughts from successful creatives, and practical exercises gleaned from Danielle Krysa\'s years of working with professional and aspiring artists—plus riotously apt illustrations from art world darling Martha Rich—this book arms readers with the most essential tool for their toolbox: the confidence they need to get down to business and make good work.</span></p>','hardcover',65,1452148449,'english',16.95,136,12.55,'2016-10-11','Chronicle Books',14,'Your Inner Critic Is a Big Jerk: And Other Truths About Being Creative'),
(6,b'1',' Loren B. Belker','Management','<p><span style=\"color: #333333; font-family: Arial, sans-serif;\">What\'s a rookie manager to do? Faced with new responsibilities, and in need of quick, dependable guidance, novice managers can\'t afford to learn by trial and error. </span><em style=\"color: #333333; font-family: Arial, sans-serif;\">The First-Time Manager</em><span style=\"color: #333333; font-family: Arial, sans-serif;\"> is the answer, dispensing the bottom-line wisdom they need to succeed. A true management classic, the book covers essential topics such as hiring and firing, leadership, motivation, managing time, dealing with superiors, and much more.</span></p>\r\n<p style=\"margin: 0px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"> </p>\r\n<p><span style=\"color: #333333; font-family: Arial, sans-serif;\">Written in an inviting and accessible style, the revised sixth edition includes new material on increasing employee engagement, encouraging innovation and initiative, helping team members optimize their talents, improving outcomes, and distinguishing oneself as a leader.</span></p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"> </p>\r\n<p><span style=\"color: #333333; font-family: Arial, sans-serif;\">Packed with immediately usable insight on everything from building a team environment to conducting performance appraisals, </span><em style=\"color: #333333; font-family: Arial, sans-serif;\">The First-Time Manager</em><span style=\"color: #333333; font-family: Arial, sans-serif;\"> remains the ultimate guide for anyone starting his or her career in management.</span></p>','paperback',47,814417833,'english',17.95,240,10,'2012-01-03','AMACOM',14,'The First-Time Manager'),
(7,b'1','Dale Carnegie','Management','<p><span style=\"color: #333333; font-family: Arial, sans-serif;\">For more than sixty years the rock-solid, time-tested advice in this book has carried thousands of now famous people up the ladder of success in their business and personal lives.</span></p>\r\n<p style=\"margin: 0px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">Now this previously revised and updated bestseller is available in trade paperback for the first time to help you achieve your maximum potential throughout the next century! Learn:</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">* Three fundamental techniques in handling people</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">* The six ways to make people like you</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">* The twelve ways to win people to you way of thinking</p>\r\n<p style=\"margin: -4px 0px 0px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">* The nine ways to change people without arousing resentment</p>','paperback',54,671027034,'english',16,288,10,'1998-10-01','Pocket Books',7,'How to Win Friends & Influence People'),
(8,b'1',' Bruce Tulgan','Management','<p style=\"margin: 0px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">For more than twenty years, management expert Bruce Tulgan has been asking<em>, “What are the most difficult challenges you face when it comes to managing people?”</em></p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">Regardless of industry or job title, managers cite the same core issues—27 recurring challenges: the superstar whom the manager is afraid of losing, the slacker whom the manager cannot figure out how to motivate, the one with an attitude problem, and the two who cannot get along, to name just a few.</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">It turns out that when things are going wrong in a management relationship, the common denominator is almost always unstructured, low substance, hit-or-miss communication.</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">The real problem is that most managers are “managing on autopilot” without even realizing it—until something goes wrong. And if you are managing on autopilot, then something almost always does.</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"><em>The 27 Challenges Managers Face</em> shows exactly how to break the vicious cycle and gain control of management relationships. No matter what the issue, Tulgan shows that the fundamentals are all you need. The very best managers hold ongoing one-on-one conversations that make expectations clear, track performance, offer feedback, and hold people accountable.</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">For every workplace problem—even the most awkward and difficult—<em>The 27 Challenges Managers Face</em> shows how to tailor conversations to solve situations familiar to every manager. Tulgan offers clear approaches for turning around bad attitudes, reducing friction and conflict, improving low performers, retaining top performers, and even addressing your own personal burnout.</p>\r\n<p style=\"margin: -4px 0px 0px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"><em>The 27 Challenges Managers Face</em> is an indispensable resource for managers at all levels, one anyone managing anyone will want to keep on hand. One challenge at a time, you’ll see how the most effective managers use the fundamentals of management to proactively resolve (nearly) any problem a manager could face. </p>','hardcover',32,111872559,'english',28,256,18.4,'2014-09-09','Jossey-Bass',28,'The 27 Challenges Managers Face: Step-by-Step Solutions to (Nearly) All of Your Management Problems'),
(9,b'1',' Paul Scherz','Engineering','<p style=\"margin: 0px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"><strong>A Fully-Updated, No-Nonsense Guide to Electronics</strong></p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">Advance your electronics knowledge and gain the skills necessary to develop and construct your own functioning gadgets. Written by a pair of experienced engineers and dedicated hobbyists, <em>Practical Electronics for Inventors,</em> Fourth Edition, lays out the essentials and provides step-by-step instructions, schematics, and illustrations. Discover how to select the right components, design and build circuits, use microcontrollers and ICs, work with the latest software tools, and test and tweak your creations. This easy-to-follow book features new instruction on programmable logic, semiconductors, operational amplifiers, voltage regulators, power supplies, digital electronics, and more.<br /> <br /><em>Practical Electronics for Inventors,</em> Fourth Edition, covers:</p>\r\n<ul style=\"padding: 0px; color: #333333; font-family: Arial, sans-serif; margin: 0px 0px 0px !important 20px;\">\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Resistors, capacitors, inductors, and transformers</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Diodes, transistors, and integrated circuits</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Optoelectronics, solar cells, and phototransistors</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Sensors, GPS modules, and touch screens</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Op amps, regulators, and power supplies</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Digital electronics, LCD displays, and logic gates</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Microcontrollers and prototyping platforms</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Combinational and sequential programmable logic</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">DC motors, RC servos, and stepper motors</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Microphones, audio amps, and speakers</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Modular electronics and prototypes</li>\r\n</ul>','paperback',22,1259587541,'english',40,1056,22.9,'2016-03-24','McGraw-Hill Education TAB',5,'Practical Electronics for Inventors, Fourth Edition'),
(10,b'1','Jones & Bartlett Learning','Engineering','<p><span style=\"color: #333333; font-family: Arial, sans-serif;\">Ugly\'s Electrical References, 2014 Edition is designed to be used as an on-the-job reference. Used worldwide by electricians, engineers, contractors, designers, maintenance workers, instructors, and the military; Ugly\'s contains the most commonly required electrical information in an easy-to-read and easy-to-access format. Ugly\'s presents a succinct portrait of the most pertinent information all electricians need at their fingertips, including: mathematical formulas, National Electrical Code tables, wiring configurations, conduit bending, voltage drops, and life-saving first aid procedures.</span></p>','hardcover',12,1449690777,'english',21.95,198,14.93,'2014-03-21','Jones & Bartlett Learning',6,'Ugly\'s Electrical References, 2014 Edition'),
(11,b'1','William Kent Krueger','Fiction','<p><em style=\"color: #333333; font-family: Arial, sans-serif;\">NEW YORK TIMES </em><span style=\"color: #333333; font-family: Arial, sans-serif;\">BESTSELLER</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">WINNER OF THE 2014 EDGAR AWARD FOR BEST NOVEL</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">WINNER OF THE 2014 DILYS AWARD</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">A </span><em style=\"color: #333333; font-family: Arial, sans-serif;\">SCHOOL LIBRARY JOURNAL </em><span style=\"color: #333333; font-family: Arial, sans-serif;\">BEST BOOK OF 2013</span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><em style=\"color: #333333; font-family: Arial, sans-serif;\">“That was it. That was all of it. A grace so ordinary there was no reason at all to remember it. Yet I have never across the forty years since it was spoken forgotten a single word.” </em><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">New Bremen, Minnesota, 1961. The Twins were playing their debut season, ice-cold root beers were selling out at the soda counter of Halderson’s Drugstore, and Hot Stuff comic books were a mainstay on every barbershop magazine rack. It was a time of innocence and hope for a country with a new, young president. But for thirteen-year-old Frank Drum it was a grim summer in which death visited frequently and assumed many forms. Accident. Nature. Suicide. Murder. </span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">Frank begins the season preoccupied with the concerns of any teenage boy, but when tragedy unexpectedly strikes his family—which includes his Methodist minister father; his passionate, artistic mother; Juilliard-bound older sister; and wise-beyond-his-years kid brother—he finds himself thrust into an adult world full of secrets, lies, adultery, and betrayal, suddenly called upon to demonstrate a maturity and gumption beyond his years. </span><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><br style=\"color: #333333; font-family: Arial, sans-serif;\" /><span style=\"color: #333333; font-family: Arial, sans-serif;\">Told from Frank’s perspective forty years after that fateful summer, </span><em style=\"color: #333333; font-family: Arial, sans-serif;\">Ordinary Grace</em><span style=\"color: #333333; font-family: Arial, sans-serif;\"> is a brilliantly moving account of a boy standing at the door of his young manhood, trying to understand a world that seems to be falling apart around him. It is an unforgettable novel about discovering the terrible price of wisdom and the enduring grace of God.</span></p>','paperback',23,1451645856,'english',16,336,10,'2014-03-04','Atria Books',10,'Ordinary Grace'),
(12,b'1',' Herbert Schildt','Programming','<h4 style=\"margin: 0px; padding: 0px 0px 4px; font-family: Arial, sans-serif; text-rendering: optimizeLegibility; color: #333333;\">Essential Java Programming Skills--Made Easy!</h4>\r\n<p style=\"margin: 0px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">Fully updated for Java Platform, Standard Edition 8 (Java SE 8), <em>Java: A Beginner\'s Guide</em>, Sixth Edition gets you started programming in Java right away. Bestselling programming author Herb Schildt begins with the basics, such as how to create, compile, and run a Java program. He then moves on to the keywords, syntax, and constructs that form the core of the Java language. This Oracle Press resource also covers some of Java\'s more advanced features, including multithreaded programming, generics, and Swing. Of course, new Java SE 8 features such as lambda expressions and default interface methods are described. An introduction to JavaFX, Java\'s newest GUI, concludes this step-by-step tutorial.</p>\r\n<p style=\"margin: -4px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"><strong>Designed for Easy Learning:</strong></p>\r\n<ul style=\"margin: 0px 0px 18px 20px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Key Skills & Concepts -- Chapter-opening lists of specific skills covered in the chapter</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Ask the Expert -- Q&A sections filled with bonus information and helpful tips</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Try This -- Hands-on exercises that show you how to apply your skills</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Self Tests -- End-of-chapter quizzes to reinforce your skills</li>\r\n<li style=\"margin: 0px 0px 0px 20px; word-wrap: break-word;\">Annotated Syntax -- Example code with commentary that describes the programming techniques being illustrated</li>\r\n</ul>\r\n<p style=\"margin: 0px 0px 14px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\"> </p>\r\n<p style=\"margin: -4px 0px 0px; padding: 0px; color: #333333; font-family: Arial, sans-serif;\">The book\'s code examples are available FREE for download.</p>','paperback',33,71809252,'english',40,728,20.83,'2014-05-06','McGraw-Hill Education',3,'Java: A Beginner\'s Guide, Sixth Edition');
/*!40000 ALTER TABLE `book` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table book_to_cart_item
# ------------------------------------------------------------
DROP TABLE IF EXISTS `book_to_cart_item`;
CREATE TABLE `book_to_cart_item` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`book_id` bigint(20) DEFAULT NULL,
`cart_item_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK254kg9aacrs8uqa93ijc3garu` (`book_id`),
KEY `FKbdyqr108hc7c06xtem0dhv9mk` (`cart_item_id`),
CONSTRAINT `FK254kg9aacrs8uqa93ijc3garu` FOREIGN KEY (`book_id`) REFERENCES `book` (`id`),
CONSTRAINT `FKbdyqr108hc7c06xtem0dhv9mk` FOREIGN KEY (`cart_item_id`) REFERENCES `cart_item` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table cart_item
# ------------------------------------------------------------
DROP TABLE IF EXISTS `cart_item`;
CREATE TABLE `cart_item` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`qty` int(11) NOT NULL,
`subtotal` decimal(19,2) DEFAULT NULL,
`book_id` bigint(20) DEFAULT NULL,
`order_id` bigint(20) DEFAULT NULL,
`shopping_cart_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKis5hg85qbs5d91etr4mvd4tx6` (`book_id`),
KEY `FKen9v41ihsnhcr0i7ivsd7i84c` (`order_id`),
KEY `FKe89gjdx91fxnmkkssyoim8xfu` (`shopping_cart_id`),
CONSTRAINT `FKe89gjdx91fxnmkkssyoim8xfu` FOREIGN KEY (`shopping_cart_id`) REFERENCES `shopping_cart` (`id`),
CONSTRAINT `FKen9v41ihsnhcr0i7ivsd7i84c` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`),
CONSTRAINT `FKis5hg85qbs5d91etr4mvd4tx6` FOREIGN KEY (`book_id`) REFERENCES `book` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table password_reset_token
# ------------------------------------------------------------
DROP TABLE IF EXISTS `password_reset_token`;
CREATE TABLE `password_reset_token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`expiry_date` datetime DEFAULT NULL,
`token` varchar(255) DEFAULT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK5lwtbncug84d4ero33v3cfxvl` (`user_id`),
CONSTRAINT `FK5lwtbncug84d4ero33v3cfxvl` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table payment
# ------------------------------------------------------------
DROP TABLE IF EXISTS `payment`;
CREATE TABLE `payment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`card_number` varchar(255) DEFAULT NULL,
`cvc` int(11) NOT NULL,
`default_payment` bit(1) NOT NULL,
`expiry_month` int(11) NOT NULL,
`expiry_year` int(11) NOT NULL,
`holder_name` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`order_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKt7a73xusjdnnsuespcitb683h` (`order_id`),
CONSTRAINT `FKt7a73xusjdnnsuespcitb683h` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table role
# ------------------------------------------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`role_id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` (`role_id`, `name`)
VALUES
(0,'ROLE_ADMIN'),
(1,'ROLE_USER');
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table shipping_address
# ------------------------------------------------------------
DROP TABLE IF EXISTS `shipping_address`;
CREATE TABLE `shipping_address` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`shipping_address_city` varchar(255) DEFAULT NULL,
`shipping_address_country` varchar(255) DEFAULT NULL,
`shipping_address_name` varchar(255) DEFAULT NULL,
`shipping_address_state` varchar(255) DEFAULT NULL,
`shipping_address_street1` varchar(255) DEFAULT NULL,
`shipping_address_street2` varchar(255) DEFAULT NULL,
`shipping_address_zipcode` varchar(255) DEFAULT NULL,
`order_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKatbgaqk1hhhhkyyuebylpeh7q` (`order_id`),
CONSTRAINT `FKatbgaqk1hhhhkyyuebylpeh7q` FOREIGN KEY (`order_id`) REFERENCES `user_order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table shopping_cart
# ------------------------------------------------------------
DROP TABLE IF EXISTS `shopping_cart`;
CREATE TABLE `shopping_cart` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`grand_total` decimal(19,2) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK254qp5akhuaaj9n5co4jww3fk` (`user_id`),
CONSTRAINT `FK254qp5akhuaaj9n5co4jww3fk` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `shopping_cart` WRITE;
/*!40000 ALTER TABLE `shopping_cart` DISABLE KEYS */;
INSERT INTO `shopping_cart` (`id`, `grand_total`, `user_id`)
VALUES
(1,NULL,1);
/*!40000 ALTER TABLE `shopping_cart` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table user
# ------------------------------------------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`email` varchar(255) NOT NULL,
`enabled` bit(1) NOT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UK_ob8kqyqqgmefl0aco34akdtpe` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`, `email`, `enabled`, `first_name`, `last_name`, `password`, `phone`, `username`)
VALUES
(1,'JAdams@gmail.com',b'1','John','Adams','$2a$12$GBAs7eP0WMwUV8zGNGYwKO4VyQWsZrpOa1tCQvFs.sLYVbDWzVpUu',NULL,'j'),
(2,'Admin@gmail.com',b'1','Admin','Admin','$2a$12$W1T5RiIBN5Yp8vCQJSKE7uDH/ciVCcg/2z7KgoQ07isze5VJNwhum',NULL,'Admin');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table user_billing
# ------------------------------------------------------------
DROP TABLE IF EXISTS `user_billing`;
CREATE TABLE `user_billing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_billing_city` varchar(255) DEFAULT NULL,
`user_billing_country` varchar(255) DEFAULT NULL,
`user_billing_name` varchar(255) DEFAULT NULL,
`user_billing_state` varchar(255) DEFAULT NULL,
`user_billing_street1` varchar(255) DEFAULT NULL,
`user_billing_street2` varchar(255) DEFAULT NULL,
`user_billing_zipcode` varchar(255) DEFAULT NULL,
`user_payment_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK3v6hd7snyc3g9s72u41k1fydu` (`user_payment_id`),
CONSTRAINT `FK3v6hd7snyc3g9s72u41k1fydu` FOREIGN KEY (`user_payment_id`) REFERENCES `user_payment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table user_order
# ------------------------------------------------------------
DROP TABLE IF EXISTS `user_order`;
CREATE TABLE `user_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`order_date` datetime DEFAULT NULL,
`order_status` varchar(255) DEFAULT NULL,
`order_total` decimal(19,2) DEFAULT NULL,
`shipping_date` datetime DEFAULT NULL,
`shipping_method` varchar(255) DEFAULT NULL,
`billing_address_id` bigint(20) DEFAULT NULL,
`payment_id` bigint(20) DEFAULT NULL,
`shipping_address_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKbaytj4l2p74kc5dp2dcrhucjo` (`billing_address_id`),
KEY `FKqjg5jrh5qwnhl2f9lk7n77454` (`payment_id`),
KEY `FKo2lj94xaujs1se8whlhc37nj7` (`shipping_address_id`),
KEY `FKj86u1x7csa8yd68ql2y1ibrou` (`user_id`),
CONSTRAINT `FKbaytj4l2p74kc5dp2dcrhucjo` FOREIGN KEY (`billing_address_id`) REFERENCES `billing_address` (`id`),
CONSTRAINT `FKj86u1x7csa8yd68ql2y1ibrou` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
CONSTRAINT `FKo2lj94xaujs1se8whlhc37nj7` FOREIGN KEY (`shipping_address_id`) REFERENCES `shipping_address` (`id`),
CONSTRAINT `FKqjg5jrh5qwnhl2f9lk7n77454` FOREIGN KEY (`payment_id`) REFERENCES `payment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table user_payment
# ------------------------------------------------------------
DROP TABLE IF EXISTS `user_payment`;
CREATE TABLE `user_payment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`card_name` varchar(255) DEFAULT NULL,
`card_number` varchar(255) DEFAULT NULL,
`cvc` int(11) NOT NULL,
`default_payment` bit(1) NOT NULL,
`expiry_month` int(11) NOT NULL,
`expiry_year` int(11) NOT NULL,
`holder_name` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK8fb9fr82lb1qk2cw55ito9rk6` (`user_id`),
CONSTRAINT `FK8fb9fr82lb1qk2cw55ito9rk6` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Dump of table user_role
# ------------------------------------------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
`user_role_id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` int(11) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`user_role_id`),
KEY `FKa68196081fvovjhkek5m97n3y` (`role_id`),
KEY `FK859n2jvi8ivhui0rl0esws6o` (`user_id`),
CONSTRAINT `FK859n2jvi8ivhui0rl0esws6o` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
CONSTRAINT `FKa68196081fvovjhkek5m97n3y` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `user_role` WRITE;
/*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`)
VALUES
(1,1,1),
(2,0,2);
/*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table user_shipping
# ------------------------------------------------------------
DROP TABLE IF EXISTS `user_shipping`;
CREATE TABLE `user_shipping` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_shipping_city` varchar(255) DEFAULT NULL,
`user_shipping_country` varchar(255) DEFAULT NULL,
`user_shipping_default` bit(1) NOT NULL,
`user_shipping_name` varchar(255) DEFAULT NULL,
`user_shipping_state` varchar(255) DEFAULT NULL,
`user_shipping_street1` varchar(255) DEFAULT NULL,
`user_shipping_street2` varchar(255) DEFAULT NULL,
`user_shipping_zipcode` varchar(255) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK9hidca5hndj9y0b5jb0xtpn9u` (`user_id`),
CONSTRAINT `FK9hidca5hndj9y0b5jb0xtpn9u` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;