GAuUfm0J

1
2SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
3SET time_zone = "+00:00";
4
5
6
7CREATE TABLE IF NOT EXISTS `Book` (
8  `book_id` int(5) NOT NULL,
9  `name_de` varchar(60) COLLATE utf8_bin NOT NULL,
10  `name_en` varchar(60) COLLATE utf8_bin NOT NULL,
11  `genre` varchar(60) NOT NULL,
12  `num_sites` int(5) NOT NULL,
13  `author` varchar(60) NOT NULL,
14  `buying_price` int(5) NOT NULL,
15  `selling_price` int(5) NOT NULL
16) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=101;
17
18
19--
20-- Daten für Tabelle `Book`
21--
22
23
24
25INSERT INTO `Book` (`book_id`, `name_de`, `name_en`, `genre`, `num_sites`, `author`, `buying_price`, `selling_price`) VALUES
26(1,'Figuren In Meinem Garten','Figures In My Garden','Mystery',609,'Wallace Fleming',6,19),
27(2,'Harmonie Von Morgen','Harmony Of Tomorrow','Nonfiction',428,'William Miranda',7,19),
28(3,'Bringers Und Diebe','Bringers And Thieves','Drama',236,'Randall Reilly',20,20),
29(4,'Koenigin Des Sonnenscheins','Queen Of Sunshine','Children',84,'Randall Thompson',16,28),
30(5,'Kuss Der Hoffnung','Kiss Of Hope','Romance',160,'Chad Brooks',21,35),
31(6,'Fiends und Kreaturen','Fiends And Creatures','Horror',141,'Frank Logan',18,19),
32(7,'Schwein Waehrend Meiner Reise','Pig During My Travel','Humor',338,'Brad Davis',22,34),
33(8,'Mistresses In Den Bergen','Mistresses In The Mountain','Romance',90,'Johnny Nicholson',11,27),
34(9,'Tapferkeit im Westen','Bravery At The West','Drama',480,'Connor Whitehead',22,36),
35(10,'Baeume der Hoelle','Trees Of Hell','Nonfiction',280,'John Vaughn',10,12),
36(11,'Sweeties der Freude','Sweeties Of Joy','Romance',261,'Hannah Scott',9,26),
37(12,'Studenten Und Tiere','Students And Animals','Horror',139,'Bessie Dudley',20,20),
38(13,'Statue Unseres Schicksals','Statue Of Our Destiny','Sci-Fi',617,'Randall Thompson',22,32),
39(14,'Autos Des Westens','Cars Of The West','Nonfiction',41,'Julia Hawkins',6,8),
40(15,'Riesen Von Der Daemmerung','Giant Of Twilight','Adventures',87,'Jeanne Russell',21,26),
41(16,'Ratte Des Sees','Rat Of The Lake','Mystery',98,'Hannah Scott',18,33),
42(17,'Erfinder des Endes','Inventors Of The End','Drama',79,'Olivia Fox',16,33),
43(18,'Schicksal Von Romance','Destiny Of Romance','Romance',71,'Cassandra Cross',21,40),
44(19,'Geraeusche hinter Ihnen','Noises Behind You','Horror',77,'Erika Stout',7,23),
45(20,'Offizierprogramm','Officer Program','Humor',30,'Haley Merritt',18,33),
46(21,'Gott ohne Zeit','God Without Time','Romance',299,'Coralie Carrel',9,17),
47(22,'Zurueck Zu Meinem Vati','Back To My Dad','Children',37,'Noemi Charrier',16,29),
48(23,'Design Von Stein','Design Of Stone','Adventures',479,'Margaux Girardot',9,9),
49(24,'Begleiter Mit Einem Hut','Companion With A Hat','Humor',110,'Aline Dubuisson',5,20),
50(25,'Pilze Der Hoehlen','Fungi Of The Caves','Nonfiction',374,'Lucile Noir',17,19),
51(26,'Soldat In Der Zukunft','Soldier In The Future','Sci-Fi',304,'Jeanne Russell',15,34),
52(27,'Geheimnisse Waehrend Der Nacht','Secrets During The Night','Humor',231,'Xuwicha Sasiprapa',16,22),
53(28,'Cyborgs und Veteranen','Cyborgs And Veterans','Sci-Fi',184,'Punngarm Chatwilai',14,32),
54(29,'Tod eines Sturms','Death Of A Storm','Mystery',388,'Nuccia Inzerillo',9,14),
55(30,'Monde Und Monde','Moons And Moons','Nonfiction',530,'Khiew Wan Patalung',9,11),
56(31,'Soldaten Mit Geld','Soldiers With Money','Drama',605,'Hannah Scott',9,19),
57(32,'Auslaender Und Schmetterlinge','Foreigners And Butterflies','Romance',176,'Emmanuel Hector',10,27),
58(33,'Sklave Mit Schulden','Slave With Debt','Drama',371,'Michel Battier',6,21),
59(34,'Tag Im Weltraum','Day In Space','Children',419,'Loup Garnier',23,29),
60(35,'Lieber Mit Blonden Haaren','Dear With Blond Hair','Romance',47,'Gerard Vidal',9,10),
61(36,'Frauen Der Leere','Women Of The Void','Fantasy',570,'Francois Durand',22,22),
62(37,'Geier Mit Faeulnis','Vulture With Rotten Skin','Horror',250,'Hannah Scott',17,24),
63(38,'Huehner Und Tiger','Chickens And Tigers','Children',235,'Maurice Charbonneau',8,22),
64(39,'Suche nach dem Koenig','Searching For The King','Adventures',601,'Amadou Parmentier',7,15),
65(40,'Zerstoeren der Dunkelheit','Destroying The Darkness','Adventures',198,'Bruno Pretre',20,38),
66(41,'Menschen Und Schlangen','Humans And Serpents','Fantasy',368,'Emmanuel Hector',10,20),
67(42,'Gier Von Droiden','Greed Of Droids','Sci-Fi',244,'Hippolyte Michaux',10,15),
68(43,'Feiern der Nebel','Celebrating The Mists','Sci-Fi',375,'Randall Thompson',11,22),
69(44,'Hurt in der Leere','Hurt In The Void','Horror',460,'Dagoberto Petrarca',20,30),
70(45,'Baum Des Berges','Tree Of The Mountain','Horror',599,'Monaldo Di Paola',9,23),
71(46,'Zerstoerung ohne Verlangen','Destruction Without Desire','Drama',436,'Amintore Chiaverini',11,24),
72(47,'Erwachen In Den Sternen','Awakening In The Stars','Romance',423,'Gianbattista Gugliuzza',21,26),
73(48,'Katzen Einer Kreatur','Cats Of A Creature','Mystery',94,'Evasio Giovannelli',21,32),
74(49,'Katze Und Fische','Cat And Fish','Humor',541,'Amina Sortino',7,9),
75(50,'Eindringlinge und Bestien','Intruders And Beasts','Sci-Fi',484,'Gioia Scarpitti',9,17),
76(51,'Gefaehrten Und Priester','Companions And Priests','Mystery',239,'Egizia Lodico',12,18),
77(52,'Babys Meines Landes','Babies Of My Land','Children',26,'Alessandra Anselmi',18,33),
78(53,'Erben Von Regenbogen','Heir Of Rainbows','Fantasy',118,'Liberata Tusa',16,27),
79(54,'Schutz am Dschungel','Shelter At The Jungle','Fantasy',451,'Nuccia Inzerillo',13,30),
80(55,'Schild Der Nacht','Shield Of The Night','Fantasy',185,'Babila Chiappone',19,26),
81(56,'Foos und Gefaehrten','Foes And Companions','Adventures',512,'Francesca Michelotti',10,23),
82(57,'Schaf Des Holzes','Sheep Of Wood','Children',285,'Paavali Karvonen',4,7),
83(58,'Schloss Mit Schulden','Castle With Debt','Drama',190,'Alessandra Torcivia',21,37),
84(59,'Dummkoepfe ohne Grenzen','Fools Without Limits','Nonfiction',355,'Mario Stock',4,15),
85(60,'Freiwilliger Krieg','Volunteers Of War','Sci-Fi',55,'Matthaeus Weide',10,13),
86(61,'Wuetend In Meiner Vergangenheit','Mad In My Past','Horror',462,'Albwin Hanisch',7,22),
87(62,'Jungen Die Laecheln','Boys Who Smiles','Horror',151,'Hanns Ritschel',11,25),
88(63,'Pilot Der Ehre','Pilot Of Honor','Sci-Fi',221,'Hannah Scott',20,36),
89(64,'Maedchen Mit Geld','Girl With Money','Adventures',363,'Christian Ungar',5,7),
90(65,'Freunde des Weltraums','Friends Of Outer Space','Sci-Fi',87,'Theophilus Wilhelm',15,30),
91(66,'Kinder Und Figuren','Children And Figures','Mystery',98,'Kunz Kesselring',21,31),
92(67,'Meanner Der Leere','Men Of The Void','Fantasy',400,'Francois Durand',13,18),
93(68,'Dachboden Im Wald','Attic In The Forest','Children',406,'Konstantin Koettner',13,17),
94(69,'Verbrecher Und Hund','Criminal And Dog','Humor',219,'Nuccia Inzerillo',6,18),
95(70,'Kinder Des Steins','Children Of Stone','Adventures',447,'Mathilde Lindenlaub',18,25),
96(71,'Verlassen Durch Meine Aktionen','Abandoned By My Actions','Mystery',39,'Eva Neumann',16,22),
97(72,'Elfen und Kobolde','Elves And Goblins','Fantasy',145,'Randall Thompson',8,25),
98(73,'Maenner Im Nebel','Men In The Fog','Horror',568,'Rosemarie Maurer',13,32),
99(74,'Feinde Und Dinosaurier','Enemies And Dinosaurs','Nonfiction',145,'Rachel Osswald',23,36),
100(75,'Katzen Des Lebens','Cats Of Life','Children',187,'Annina Gutfreund',22,36),
101(76,'Aufgeregt durch meine Vergangenheit','Excited By My Past','Romance',327,'Louise Handke',9,15),
102(77,'Langweilig bei meinem Bruder','Boring At My Brother','Children',405,'Annegret Bartram',10,12),
103(78,'Ehrgeiz meines Projektes','Ambition Of My Project','Humor',437,'Nuccia Inzerillo',18,22),
104(79,'Elektrizitaet Des Landes','Electricity Of The Country','Humor',449,'Fabricio Carvalho',6,9),
105(80,'Gelaechter Im Dachboden','Laughter In The Attic','Horror',558,'Randall Thompson',16,22),
106(81,'Sekte der Finsternis','Sect Of Darkness','Mystery',393,'Tiago Macedo',17,33),
107(82,'Lachen am Koenig','Laughing At The King','Drama',511,'Renato Brando',10,19),
108(83,'Skelette Der Sterne','Skeletons Of The Stars','Fantasy',532,'Ilvaro Fonseca',20,22),
109(84,'Ritter Und Valentinsgruss','Knights And Valentines','Romance',570,'Breno Rios',7,17),
110(85,'Feind Einer Malerei','Enemy Of A Painting','Mystery',86,'Pedro Dias',16,22),
111(86,'Fisch Im Ausland','Fish Abroad','Humor',570,'Nuccia Inzerillo',18,28),
112(87,'Geholfen durch die Streiche','Helped By The Pranks','Humor',175,'Rodolfo Menezes',22,40),
113(88,'Koenige Und Hasen','Kings And Bunnies','Children',77,'Randall Thompson',19,23),
114(89,'Sieg unseres Schicksals','Victory Of Our Destiny','Sci-Fi',383,'Iida Kauppila',14,25),
115(90,'Geheimnis Der Wissenschaft','Mystery Of Science','Nonfiction',488,'Tarvo Leinonen',16,21),
116(91,'Wolken Des Letzten','Clouds Of The Past','Mystery',398,'Heikki Nykuenen',7,7),
117(92,'Familie der Vergangenheit','Family Of The Past','Fantasy',387,'Paavali Karvonen',15,23),
118(93,'Geier Des Universums','Vultures Of The Universe','Nonfiction',516,'Anssi Maijala',7,13),
119(94,'Stellvertreter des Leidens','Deputy Of Suffering','Drama',379,'Elmo Hannula',8,24),
120(95,'Elf Des Endes','Elf Of The End','Fantasy',293,'Paavali Karvonen',19,25),
121(96,'Hilfreiche Ausbildung','Helpful Education','Nonfiction',275,'Randall Thompson',8,24),
122(97,'Frucht Der Leere','Fruit Of The Void','Adventures',275,'Joni Hietala',8,21),
123(98,'Engel Und Unterstuetzer','Angels And Supporters','Drama',52,'Akseli Koivula',15,26),
124(99,'Metzger und Nachkommen','Butchers And Descendants','Adventures',31,'Aku Kauko',5,13),
125(100,'Verschwinden Auf Dem Land','Vanish At The Country','Fantasy',71,'Nuccia Inzerillo',8,24);
126
127
128ALTER TABLE `Book`
129 ADD PRIMARY KEY (`book_id`);
130--
131-- Tabellenstruktur für Tabelle `SubsidiaryBook`
132--
133CREATE TABLE IF NOT EXISTS `SubsidiaryBook` (
134  `id` int(11) NOT NULL,
135  `book_id` int(11) NOT NULL,
136  `subsidiary_id` int(11) NOT NULL,
137  `num_own` int(11) NOT NULL,
138  `num_sell` int(11) NOT NULL
139) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=201 ;
140
141
142INSERT INTO `SubsidiaryBook` (`id`,`book_id`, `subsidiary_id`, `num_own`, `num_sell`) VALUES
143(1,1,1,240,19),
144(2,2,1,925,734),
145(3,3,1,241,111),
146(4,4,1,842,792),
147(5,5,1,753,494),
148(6,6,1,902,816),
149(7,7,1,0,0),
150(8,8,1,0,0),
151(9,9,1,46,0),
152(10,10,1,580,391),
153(11,11,1,899,874),
154(12,12,1,608,410),
155(13,13,1,217,0),
156(14,14,1,332,181),
157(15,15,1,805,613),
158(16,16,1,886,590),
159(17,17,1,930,738),
160(18,18,1,815,791),
161(19,19,1,86,0),
162(20,20,1,1,0),
163(21,21,1,300,35),
164(22,22,1,139,15),
165(23,23,1,655,357),
166(24,24,1,489,476),
167(25,25,1,569,495),
168(26,26,1,436,299),
169(27,27,1,773,695),
170(28,28,1,729,676),
171(29,29,1,355,280),
172(30,30,1,491,322),
173(31,31,1,120,10),
174(32,32,1,0,0),
175(33,33,1,303,109),
176(34,34,1,725,699),
177(35,35,1,46,0),
178(36,36,1,66,0),
179(37,37,1,526,354),
180(38,38,1,457,256),
181(39,39,1,303,69),
182(40,40,1,719,611),
183(41,41,1,0,0),
184(42,42,1,472,308),
185(43,43,1,859,831),
186(44,44,1,197,10),
187(45,45,1,49,0),
188(46,46,1,207,0),
189(47,47,1,767,615),
190(48,48,1,33,0),
191(49,49,1,830,788),
192(50,50,1,480,460),
193(51,51,1,323,98),
194(52,52,1,382,334),
195(53,53,1,147,4),
196(54,54,1,544,536),
197(55,55,1,438,162),
198(56,56,1,78,0),
199(57,57,1,8,0),
200(58,58,1,579,303),
201(59,59,1,590,382),
202(60,60,1,801,558),
203(61,61,1,299,122),
204(62,62,1,348,56),
205(63,63,1,618,450),
206(64,64,1,881,775),
207(65,65,1,821,793),
208(66,66,1,929,743),
209(67,67,1,947,686),
210(68,68,1,697,489),
211(69,69,1,674,563),
212(70,70,1,0,0),
213(71,71,1,546,248),
214(72,72,1,564,409),
215(73,73,1,662,401),
216(74,74,1,803,740),
217(75,75,1,460,322),
218(76,76,1,0,0),
219(77,77,1,574,514),
220(78,78,1,104,0),
221(79,79,1,605,311),
222(80,80,1,28,0),
223(81,81,1,147,0),
224(82,82,1,514,276),
225(83,83,1,120,48),
226(84,84,1,158,70),
227(85,85,1,772,662),
228(86,86,1,26,0),
229(87,87,1,108,0),
230(88,88,1,108,14),
231(89,89,1,489,351),
232(90,90,1,974,764),
233(91,91,1,342,254),
234(92,92,1,0,0),
235(93,93,1,748,661),
236(94,94,1,282,38),
237(95,95,1,423,286),
238(96,96,1,169,57),
239(97,97,1,0,0),
240(98,98,1,745,637),
241(99,99,1,682,604),
242(100,100,1,734,615),
243(101,1,2,607,429),
244(102,2,2,756,508),
245(103,3,2,115,6),
246(104,4,2,453,408),
247(105,5,2,540,441),
248(106,6,2,936,689),
249(107,7,2,474,294),
250(108,8,2,313,210),
251(109,9,2,394,205),
252(110,10,2,473,334),
253(111,11,2,447,165),
254(112,12,2,550,389),
255(113,13,2,683,659),
256(114,14,2,154,111),
257(115,15,2,698,569),
258(116,16,2,195,135),
259(117,17,2,49,0),
260(118,18,2,795,756),
261(119,19,2,142,0),
262(120,20,2,915,847),
263(121,21,2,685,564),
264(122,22,2,213,12),
265(123,23,2,856,766),
266(124,24,2,478,187),
267(125,25,2,315,312),
268(126,26,2,915,650),
269(127,27,2,152,130),
270(128,28,2,240,183),
271(129,29,2,595,438),
272(130,30,2,768,477),
273(131,31,2,610,463),
274(132,32,2,659,516),
275(133,33,2,691,419),
276(134,34,2,90,0),
277(135,35,2,966,830),
278(136,36,2,829,671),
279(137,37,2,609,394),
280(138,38,2,183,0),
281(139,39,2,142,56),
282(140,40,2,287,83),
283(141,41,2,214,117),
284(142,42,2,703,461),
285(143,43,2,602,558),
286(144,44,2,263,88),
287(145,45,2,857,707),
288(146,46,2,496,389),
289(147,47,2,0,0),
290(148,48,2,351,249),
291(149,49,2,752,746),
292(150,50,2,855,785),
293(151,51,2,843,719),
294(152,52,2,301,106),
295(153,53,2,145,118),
296(154,54,2,503,447),
297(155,55,2,612,391),
298(156,56,2,0,0),
299(157,57,2,0,0),
300(158,58,2,12,0),
301(159,59,2,173,153),
302(160,60,2,614,391),
303(161,61,2,72,59),
304(162,62,2,302,95),
305(163,63,2,929,779),
306(164,64,2,190,59),
307(165,65,2,0,0),
308(166,66,2,859,801),
309(167,67,2,2,0),
310(168,68,2,55,45),
311(169,69,2,470,305),
312(170,70,2,633,424),
313(171,71,2,457,207),
314(172,72,2,870,697),
315(173,73,2,101,0),
316(174,74,2,750,453),
317(175,75,2,247,189),
318(176,76,2,512,225),
319(177,77,2,499,465),
320(178,78,2,285,93),
321(179,79,2,189,0),
322(180,80,2,588,315),
323(181,81,2,99,0),
324(182,82,2,175,0),
325(183,83,2,846,720),
326(184,84,2,602,461),
327(185,85,2,411,259),
328(186,86,2,15,0),
329(187,87,2,685,391),
330(188,88,2,799,503),
331(189,89,2,46,0),
332(190,90,2,580,561),
333(191,91,2,0,0),
334(192,92,2,847,667),
335(193,93,2,578,535),
336(194,94,2,713,607),
337(195,95,2,328,305),
338(196,96,2,777,618),
339(197,97,2,179,159),
340(198,98,2,589,399),
341(199,99,2,938,795),
342(200,100,2,444,241),
343(201,1,3,196,167),
344(202,2,3,740,720),
345(203,3,3,381,199),
346(204,4,3,689,472),
347(205,5,3,948,879),
348(206,6,3,53,0),
349(207,7,3,152,50),
350(208,8,3,432,324),
351(209,9,3,845,662),
352(210,10,3,763,506),
353(211,11,3,961,784),
354(212,12,3,73,0),
355(213,13,3,491,338),
356(214,14,3,595,341),
357(215,15,3,482,274),
358(216,16,3,501,460),
359(217,17,3,56,0),
360(218,18,3,0,0),
361(219,19,3,358,328),
362(220,20,3,791,574),
363(221,21,3,587,336),
364(222,22,3,71,0),
365(223,23,3,790,636),
366(224,24,3,617,450),
367(225,25,3,579,366),
368(226,26,3,791,558),
369(227,27,3,525,402),
370(228,28,3,538,368),
371(229,29,3,503,204),
372(230,30,3,247,0),
373(231,31,3,0,0),
374(232,32,3,5,0),
375(233,33,3,245,198),
376(234,34,3,389,159),
377(235,35,3,930,690),
378(236,36,3,0,0),
379(237,37,3,537,522),
380(238,38,3,882,842),
381(239,39,3,160,0),
382(240,40,3,412,138),
383(241,41,3,0,0),
384(242,42,3,143,0),
385(243,43,3,944,768),
386(244,44,3,500,382),
387(245,45,3,522,470),
388(246,46,3,283,280),
389(247,47,3,95,0),
390(248,48,3,201,98),
391(249,49,3,461,325),
392(250,50,3,234,36),
393(251,51,3,604,364),
394(252,52,3,336,150),
395(253,53,3,414,168),
396(254,54,3,589,573),
397(255,55,3,934,748),
398(256,56,3,311,108),
399(257,57,3,841,609),
400(258,58,3,470,433),
401(259,59,3,155,0),
402(260,60,3,941,761),
403(261,61,3,585,314),
404(262,62,3,323,118),
405(263,63,3,564,463),
406(264,64,3,7,0),
407(265,65,3,278,230),
408(266,66,3,766,603),
409(267,67,3,609,475),
410(268,68,3,263,69),
411(269,69,3,158,0),
412(270,70,3,603,337),
413(271,71,3,306,253),
414(272,72,3,526,413),
415(273,73,3,611,344),
416(274,74,3,77,0),
417(275,75,3,266,0),
418(276,76,3,271,76),
419(277,77,3,343,153),
420(278,78,3,86,0),
421(279,79,3,426,166),
422(280,80,3,220,205),
423(281,81,3,30,0),
424(282,82,3,16,0),
425(283,83,3,304,115),
426(284,84,3,869,631),
427(285,85,3,471,419),
428(286,86,3,632,353),
429(287,87,3,73,30),
430(288,88,3,24,0),
431(289,89,3,152,36),
432(290,90,3,497,214),
433(291,91,3,85,0),
434(292,92,3,818,555),
435(293,93,3,971,787),
436(294,94,3,53,49),
437(295,95,3,794,676),
438(296,96,3,618,519),
439(297,97,3,369,330),
440(298,98,3,772,556),
441(299,99,3,51,0),
442(300,100,3,516,463),
443(301,1,4,430,158),
444(302,2,4,902,684),
445(303,3,4,672,565),
446(304,4,4,0,0),
447(305,5,4,447,445),
448(306,6,4,696,580),
449(307,7,4,401,286),
450(308,8,4,263,140),
451(309,9,4,411,226),
452(310,10,4,405,264),
453(311,11,4,869,628),
454(312,12,4,340,296),
455(313,13,4,756,491),
456(314,14,4,723,591),
457(315,15,4,396,346),
458(316,16,4,254,156),
459(317,17,4,652,422),
460(318,18,4,730,684),
461(319,19,4,125,0),
462(320,20,4,949,748),
463(321,21,4,756,597),
464(322,22,4,622,545),
465(323,23,4,150,0),
466(324,24,4,566,422),
467(325,25,4,392,318),
468(326,26,4,847,801),
469(327,27,4,953,770),
470(328,28,4,695,481),
471(329,29,4,890,760),
472(330,30,4,605,448),
473(331,31,4,0,0),
474(332,32,4,851,590),
475(333,33,4,542,380),
476(334,34,4,142,41),
477(335,35,4,871,621),
478(336,36,4,778,712),
479(337,37,4,599,420),
480(338,38,4,994,961),
481(339,39,4,845,619),
482(340,40,4,166,93),
483(341,41,4,873,615),
484(342,42,4,532,284),
485(343,43,4,59,0),
486(344,44,4,374,361),
487(345,45,4,780,777),
488(346,46,4,0,0),
489(347,47,4,708,683),
490(348,48,4,747,449),
491(349,49,4,635,449),
492(350,50,4,787,490),
493(351,51,4,577,532),
494(352,52,4,725,482),
495(353,53,4,0,0),
496(354,54,4,674,610),
497(355,55,4,816,802),
498(356,56,4,89,0),
499(357,57,4,258,253),
500(358,58,4,422,233),
501(359,59,4,714,420),
502(360,60,4,728,449),
503(361,61,4,483,445),
504(362,62,4,282,247),
505(363,63,4,747,686),
506(364,64,4,830,798),
507(365,65,4,718,689),
508(366,66,4,858,719),
509(367,67,4,655,607),
510(368,68,4,720,527),
511(369,69,4,201,43),
512(370,70,4,644,374),
513(371,71,4,441,314),
514(372,72,4,690,558),
515(373,73,4,691,565),
516(374,74,4,88,0),
517(375,75,4,529,241),
518(376,76,4,728,440),
519(377,77,4,3,0),
520(378,78,4,102,69),
521(379,79,4,957,816),
522(380,80,4,296,269),
523(381,81,4,33,0),
524(382,82,4,858,718),
525(383,83,4,364,150),
526(384,84,4,515,332),
527(385,85,4,313,182),
528(386,86,4,755,658),
529(387,87,4,96,0),
530(388,88,4,267,171),
531(389,89,4,274,61),
532(390,90,4,430,333),
533(391,91,4,18,0),
534(392,92,4,0,0),
535(393,93,4,531,361),
536(394,94,4,960,792),
537(395,95,4,421,391),
538(396,96,4,231,167),
539(397,97,4,63,0),
540(398,98,4,934,804),
541(399,99,4,467,233),
542(400,100,4,576,476),
543(401,1,5,286,119),
544(402,2,5,855,691),
545(403,3,5,332,84),
546(404,4,5,245,133),
547(405,5,5,772,738),
548(406,6,5,116,67),
549(407,7,5,660,487),
550(408,8,5,133,0),
551(409,9,5,834,813),
552(410,10,5,149,115),
553(411,11,5,431,425),
554(412,12,5,112,0),
555(413,13,5,72,0),
556(414,14,5,131,0),
557(415,15,5,769,548),
558(416,16,5,69,0),
559(417,17,5,91,71),
560(418,18,5,347,87),
561(419,19,5,631,419),
562(420,20,5,660,364),
563(421,21,5,0,0),
564(422,22,5,595,519),
565(423,23,5,104,0),
566(424,24,5,265,62),
567(425,25,5,893,852),
568(426,26,5,51,0),
569(427,27,5,274,113),
570(428,28,5,19,9),
571(429,29,5,638,429),
572(430,30,5,631,396),
573(431,31,5,270,97),
574(432,32,5,906,740),
575(433,33,5,114,0),
576(434,34,5,473,390),
577(435,35,5,247,0),
578(436,36,5,22,0),
579(437,37,5,251,136),
580(438,38,5,426,176),
581(439,39,5,308,53),
582(440,40,5,970,725),
583(441,41,5,255,167),
584(442,42,5,888,836),
585(443,43,5,720,524),
586(444,44,5,256,0),
587(445,45,5,57,0),
588(446,46,5,144,0),
589(447,47,5,536,396),
590(448,48,5,136,78),
591(449,49,5,770,720),
592(450,50,5,727,543),
593(451,51,5,4,0),
594(452,52,5,927,666),
595(453,53,5,892,714),
596(454,54,5,323,227),
597(455,55,5,675,552),
598(456,56,5,319,61),
599(457,57,5,147,0),
600(458,58,5,432,339),
601(459,59,5,202,60),
602(460,60,5,296,139),
603(461,61,5,792,668),
604(462,62,5,683,400),
605(463,63,5,653,525),
606(464,64,5,848,699),
607(465,65,5,242,147),
608(466,66,5,806,705),
609(467,67,5,971,783),
610(468,68,5,920,777),
611(469,69,5,782,556),
612(470,70,5,260,67),
613(471,71,5,756,486),
614(472,72,5,0,0),
615(473,73,5,864,809),
616(474,74,5,311,164),
617(475,75,5,580,447),
618(476,76,5,633,514),
619(477,77,5,520,248),
620(478,78,5,898,661),
621(479,79,5,0,0),
622(480,80,5,219,0),
623(481,81,5,0,0),
624(482,82,5,289,166),
625(483,83,5,73,33),
626(484,84,5,798,754),
627(485,85,5,452,247),
628(486,86,5,779,503),
629(487,87,5,194,0),
630(488,88,5,324,75),
631(489,89,5,0,0),
632(490,90,5,985,703),
633(491,91,5,782,499),
634(492,92,5,36,20),
635(493,93,5,803,697),
636(494,94,5,330,224),
637(495,95,5,702,528),
638(496,96,5,808,698),
639(497,97,5,313,279),
640(498,98,5,176,39),
641(499,99,5,322,79),
642(500,100,5,852,723),
643(501,1,6,0,0),
644(502,2,6,639,366),
645(503,3,6,785,658),
646(504,4,6,888,805),
647(505,5,6,519,452),
648(506,6,6,283,17),
649(507,7,6,982,912),
650(508,8,6,208,130),
651(509,9,6,652,479),
652(510,10,6,1,0),
653(511,11,6,606,521),
654(512,12,6,723,662),
655(513,13,6,870,637),
656(514,14,6,272,226),
657(515,15,6,380,178),
658(516,16,6,644,622),
659(517,17,6,811,608),
660(518,18,6,418,292),
661(519,19,6,788,660),
662(520,20,6,172,0),
663(521,21,6,462,354),
664(522,22,6,668,654),
665(523,23,6,669,495),
666(524,24,6,156,15),
667(525,25,6,361,163),
668(526,26,6,311,130),
669(527,27,6,436,149),
670(528,28,6,907,713),
671(529,29,6,952,730),
672(530,30,6,132,0),
673(531,31,6,45,0),
674(532,32,6,59,0),
675(533,33,6,323,120),
676(534,34,6,618,567),
677(535,35,6,166,49),
678(536,36,6,492,233),
679(537,37,6,387,286),
680(538,38,6,303,139),
681(539,39,6,580,283),
682(540,40,6,147,33),
683(541,41,6,6,0),
684(542,42,6,42,0),
685(543,43,6,549,341),
686(544,44,6,761,732),
687(545,45,6,288,250),
688(546,46,6,577,324),
689(547,47,6,45,41),
690(548,48,6,601,504),
691(549,49,6,358,354),
692(550,50,6,374,130),
693(551,51,6,576,559),
694(552,52,6,14,0),
695(553,53,6,369,228),
696(554,54,6,623,346),
697(555,55,6,62,0),
698(556,56,6,354,308),
699(557,57,6,307,202),
700(558,58,6,893,869),
701(559,59,6,139,0),
702(560,60,6,815,522),
703(561,61,6,478,284),
704(562,62,6,373,96),
705(563,63,6,528,380),
706(564,64,6,709,649),
707(565,65,6,898,753),
708(566,66,6,530,332),
709(567,67,6,6,0),
710(568,68,6,137,0),
711(569,69,6,481,241),
712(570,70,6,605,556),
713(571,71,6,486,300),
714(572,72,6,747,570),
715(573,73,6,403,293),
716(574,74,6,318,84),
717(575,75,6,826,593),
718(576,76,6,0,0),
719(577,77,6,506,271),
720(578,78,6,820,614),
721(579,79,6,697,653),
722(580,80,6,592,321),
723(581,81,6,449,243),
724(582,82,6,196,46),
725(583,83,6,649,394),
726(584,84,6,256,18),
727(585,85,6,375,246),
728(586,86,6,102,0),
729(587,87,6,291,281),
730(588,88,6,885,633),
731(589,89,6,222,191),
732(590,90,6,448,295),
733(591,91,6,0,0),
734(592,92,6,904,903),
735(593,93,6,484,448),
736(594,94,6,95,0),
737(595,95,6,298,85),
738(596,96,6,233,142),
739(597,97,6,731,528),
740(598,98,6,490,314),
741(599,99,6,701,698),
742(600,100,6,246,170),
743(601,1,7,287,162),
744(602,2,7,393,243),
745(603,3,7,327,257),
746(604,4,7,520,322),
747(605,5,7,307,300),
748(606,6,7,304,189),
749(607,7,7,911,830),
750(608,8,7,598,359),
751(609,9,7,488,286),
752(610,10,7,813,664),
753(611,11,7,60,0),
754(612,12,7,234,166),
755(613,13,7,811,788),
756(614,14,7,232,202),
757(615,15,7,49,0),
758(616,16,7,906,634),
759(617,17,7,149,113),
760(618,18,7,578,578),
761(619,19,7,770,718),
762(620,20,7,552,360),
763(621,21,7,407,234),
764(622,22,7,508,266),
765(623,23,7,368,287),
766(624,24,7,797,632),
767(625,25,7,961,940),
768(626,26,7,772,686),
769(627,27,7,559,430),
770(628,28,7,520,443),
771(629,29,7,598,572),
772(630,30,7,11,0),
773(631,31,7,100,0),
774(632,32,7,249,73),
775(633,33,7,171,56),
776(634,34,7,729,703),
777(635,35,7,846,624),
778(636,36,7,473,419),
779(637,37,7,384,287),
780(638,38,7,0,0),
781(639,39,7,474,364),
782(640,40,7,122,0),
783(641,41,7,785,494),
784(642,42,7,174,58),
785(643,43,7,596,376),
786(644,44,7,806,637),
787(645,45,7,90,30),
788(646,46,7,560,291),
789(647,47,7,805,508),
790(648,48,7,529,334),
791(649,49,7,152,27),
792(650,50,7,29,0),
793(651,51,7,0,0),
794(652,52,7,802,653),
795(653,53,7,933,849),
796(654,54,7,275,170),
797(655,55,7,678,626),
798(656,56,7,493,425),
799(657,57,7,573,569),
800(658,58,7,495,380),
801(659,59,7,585,532),
802(660,60,7,490,259),
803(661,61,7,577,536),
804(662,62,7,456,394),
805(663,63,7,521,483),
806(664,64,7,291,0),
807(665,65,7,490,433),
808(666,66,7,507,494),
809(667,67,7,839,669),
810(668,68,7,196,48),
811(669,69,7,693,396),
812(670,70,7,523,505),
813(671,71,7,982,931),
814(672,72,7,718,646),
815(673,73,7,155,0),
816(674,74,7,555,530),
817(675,75,7,188,130),
818(676,76,7,302,207),
819(677,77,7,707,494),
820(678,78,7,323,300),
821(679,79,7,0,0),
822(680,80,7,381,228),
823(681,81,7,641,516),
824(682,82,7,389,192),
825(683,83,7,151,63),
826(684,84,7,345,336),
827(685,85,7,542,404),
828(686,86,7,841,549),
829(687,87,7,451,216),
830(688,88,7,188,136),
831(689,89,7,68,0),
832(690,90,7,405,341),
833(691,91,7,818,717),
834(692,92,7,767,506),
835(693,93,7,789,723),
836(694,94,7,208,155),
837(695,95,7,410,290),
838(696,96,7,771,558),
839(697,97,7,310,49),
840(698,98,7,726,711),
841(699,99,7,613,536),
842(700,100,7,733,570),
843(701,1,8,359,70),
844(702,2,8,35,0),
845(703,3,8,792,736),
846(704,4,8,111,0),
847(705,5,8,394,288),
848(706,6,8,892,676),
849(707,7,8,174,0),
850(708,8,8,952,785),
851(709,9,8,226,64),
852(710,10,8,63,0),
853(711,11,8,106,0),
854(712,12,8,630,512),
855(713,13,8,115,0),
856(714,14,8,429,378),
857(715,15,8,360,169),
858(716,16,8,750,725),
859(717,17,8,107,0),
860(718,18,8,428,170),
861(719,19,8,835,592),
862(720,20,8,285,214),
863(721,21,8,102,0),
864(722,22,8,316,316),
865(723,23,8,90,36),
866(724,24,8,377,364),
867(725,25,8,828,761),
868(726,26,8,888,681),
869(727,27,8,730,696),
870(728,28,8,763,505),
871(729,29,8,467,192),
872(730,30,8,862,617),
873(731,31,8,815,535),
874(732,32,8,702,657),
875(733,33,8,160,0),
876(734,34,8,172,0),
877(735,35,8,93,69),
878(736,36,8,569,392),
879(737,37,8,22,0),
880(738,38,8,214,106),
881(739,39,8,486,364),
882(740,40,8,262,234),
883(741,41,8,890,822),
884(742,42,8,441,217),
885(743,43,8,45,0),
886(744,44,8,598,336),
887(745,45,8,436,268),
888(746,46,8,165,146),
889(747,47,8,355,141),
890(748,48,8,0,0),
891(749,49,8,726,461),
892(750,50,8,661,516),
893(751,51,8,108,83),
894(752,52,8,65,0),
895(753,53,8,774,653),
896(754,54,8,0,0),
897(755,55,8,317,24),
898(756,56,8,700,684),
899(757,57,8,698,558),
900(758,58,8,873,674),
901(759,59,8,418,163),
902(760,60,8,164,0),
903(761,61,8,42,0),
904(762,62,8,741,451),
905(763,63,8,661,548),
906(764,64,8,799,654),
907(765,65,8,3,0),
908(766,66,8,0,0),
909(767,67,8,354,182),
910(768,68,8,297,91),
911(769,69,8,410,249),
912(770,70,8,384,203),
913(771,71,8,406,352),
914(772,72,8,398,236),
915(773,73,8,87,0),
916(774,74,8,220,0),
917(775,75,8,766,536),
918(776,76,8,349,270),
919(777,77,8,4,0),
920(778,78,8,0,0),
921(779,79,8,0,0),
922(780,80,8,213,0),
923(781,81,8,71,9),
924(782,82,8,67,34),
925(783,83,8,102,60),
926(784,84,8,633,585),
927(785,85,8,0,0),
928(786,86,8,810,614),
929(787,87,8,432,261),
930(788,88,8,641,540),
931(789,89,8,259,7),
932(790,90,8,527,257),
933(791,91,8,850,745),
934(792,92,8,180,76),
935(793,93,8,523,507),
936(794,94,8,283,61),
937(795,95,8,249,185),
938(796,96,8,347,130),
939(797,97,8,349,238),
940(798,98,8,389,174),
941(799,99,8,549,429),
942(800,100,8,176,0),
943(801,1,9,281,255),
944(802,2,9,437,229),
945(803,3,9,41,23),
946(804,4,9,83,64),
947(805,5,9,186,48),
948(806,6,9,527,367),
949(807,7,9,565,493),
950(808,8,9,0,0),
951(809,9,9,428,291),
952(810,10,9,809,716),
953(811,11,9,324,104),
954(812,12,9,219,158),
955(813,13,9,134,0),
956(814,14,9,735,509),
957(815,15,9,475,411),
958(816,16,9,314,103),
959(817,17,9,231,0),
960(818,18,9,158,54),
961(819,19,9,107,50),
962(820,20,9,220,37),
963(821,21,9,848,824),
964(822,22,9,101,5),
965(823,23,9,275,0),
966(824,24,9,377,337),
967(825,25,9,806,759),
968(826,26,9,745,633),
969(827,27,9,497,268),
970(828,28,9,954,666),
971(829,29,9,832,547),
972(830,30,9,482,279),
973(831,31,9,316,185),
974(832,32,9,280,194),
975(833,33,9,0,0),
976(834,34,9,571,487),
977(835,35,9,341,187),
978(836,36,9,225,207),
979(837,37,9,934,707),
980(838,38,9,410,406),
981(839,39,9,537,320),
982(840,40,9,562,294),
983(841,41,9,719,545),
984(842,42,9,774,637),
985(843,43,9,458,282),
986(844,44,9,168,78),
987(845,45,9,284,169),
988(846,46,9,613,492),
989(847,47,9,7,0),
990(848,48,9,698,647),
991(849,49,9,599,585),
992(850,50,9,472,245),
993(851,51,9,885,612),
994(852,52,9,0,0),
995(853,53,9,0,0),
996(854,54,9,305,135),
997(855,55,9,526,294),
998(856,56,9,461,354),
999(857,57,9,156,25),
1000(858,58,9,236,174),
1001(859,59,9,506,303),
1002(860,60,9,336,164),
1003(861,61,9,552,365),
1004(862,62,9,929,721),
1005(863,63,9,0,0),
1006(864,64,9,843,724),
1007(865,65,9,200,21),
1008(866,66,9,35,0),
1009(867,67,9,945,938),
1010(868,68,9,904,683),
1011(869,69,9,130,52),
1012(870,70,9,750,700),
1013(871,71,9,905,674),
1014(872,72,9,268,220),
1015(873,73,9,571,293),
1016(874,74,9,322,184),
1017(875,75,9,0,0),
1018(876,76,9,625,504),
1019(877,77,9,0,0),
1020(878,78,9,209,0),
1021(879,79,9,157,0),
1022(880,80,9,570,318),
1023(881,81,9,735,660),
1024(882,82,9,684,435),
1025(883,83,9,177,83),
1026(884,84,9,666,423),
1027(885,85,9,540,484),
1028(886,86,9,103,0),
1029(887,87,9,528,450),
1030(888,88,9,301,42),
1031(889,89,9,464,184),
1032(890,90,9,683,636),
1033(891,91,9,471,366),
1034(892,92,9,534,238),
1035(893,93,9,501,270),
1036(894,94,9,0,0),
1037(895,95,9,550,272),
1038(896,96,9,981,686),
1039(897,97,9,501,245),
1040(898,98,9,925,877),
1041(899,99,9,284,85),
1042(900,100,9,680,563),
1043(901,1,10,111,0),
1044(902,2,10,279,37),
1045(903,3,10,969,872),
1046(904,4,10,101,76),
1047(905,5,10,729,554),
1048(906,6,10,45,0),
1049(907,7,10,383,225),
1050(908,8,10,780,502),
1051(909,9,10,661,416),
1052(910,10,10,42,0),
1053(911,11,10,249,200),
1054(912,12,10,45,39),
1055(913,13,10,140,0),
1056(914,14,10,765,720),
1057(915,15,10,760,690),
1058(916,16,10,957,914),
1059(917,17,10,908,777),
1060(918,18,10,192,153),
1061(919,19,10,656,656),
1062(920,20,10,647,527),
1063(921,21,10,195,0),
1064(922,22,10,613,592),
1065(923,23,10,0,0),
1066(924,24,10,542,347),
1067(925,25,10,61,38),
1068(926,26,10,82,20),
1069(927,27,10,45,0),
1070(928,28,10,107,0),
1071(929,29,10,24,0),
1072(930,30,10,560,393),
1073(931,31,10,530,243),
1074(932,32,10,105,34),
1075(933,33,10,763,496),
1076(934,34,10,95,0),
1077(935,35,10,37,36),
1078(936,36,10,74,0),
1079(937,37,10,34,0),
1080(938,38,10,15,0),
1081(939,39,10,141,0),
1082(940,40,10,462,227),
1083(941,41,10,257,0),
1084(942,42,10,321,58),
1085(943,43,10,280,115),
1086(944,44,10,77,0),
1087(945,45,10,457,377),
1088(946,46,10,471,203),
1089(947,47,10,666,440),
1090(948,48,10,74,0),
1091(949,49,10,384,112),
1092(950,50,10,137,90),
1093(951,51,10,943,927),
1094(952,52,10,407,176),
1095(953,53,10,0,0),
1096(954,54,10,336,116),
1097(955,55,10,729,607),
1098(956,56,10,627,554),
1099(957,57,10,272,239),
1100(958,58,10,629,578),
1101(959,59,10,759,758),
1102(960,60,10,860,714),
1103(961,61,10,643,439),
1104(962,62,10,658,382),
1105(963,63,10,834,677),
1106(964,64,10,55,0),
1107(965,65,10,346,242),
1108(966,66,10,813,567),
1109(967,67,10,213,93),
1110(968,68,10,251,214),
1111(969,69,10,0,0),
1112(970,70,10,160,0),
1113(971,71,10,735,495),
1114(972,72,10,154,0),
1115(973,73,10,0,0),
1116(974,74,10,395,288),
1117(975,75,10,274,0),
1118(976,76,10,667,560),
1119(977,77,10,192,132),
1120(978,78,10,279,100),
1121(979,79,10,156,106),
1122(980,80,10,450,409),
1123(981,81,10,404,260),
1124(982,82,10,538,440),
1125(983,83,10,412,282),
1126(984,84,10,674,571),
1127(985,85,10,565,534),
1128(986,86,10,338,286),
1129(987,87,10,204,0),
1130(988,88,10,329,217),
1131(989,89,10,274,168),
1132(990,90,10,810,715),
1133(991,91,10,719,469),
1134(992,92,10,554,469),
1135(993,93,10,862,838),
1136(994,94,10,448,326),
1137(995,95,10,351,208),
1138(996,96,10,381,159),
1139(997,97,10,409,395),
1140(998,98,10,878,625),
1141(999,99,10,280,92),
1142(1000,100,10,22,0),
1143(1001,1,11,408,394),
1144(1002,2,11,177,0),
1145(1003,3,11,704,453),
1146(1004,4,11,300,150),
1147(1005,5,11,40,0),
1148(1006,6,11,637,423),
1149(1007,7,11,291,232),
1150(1008,8,11,303,136),
1151(1009,9,11,475,295),
1152(1010,10,11,854,566),
1153(1011,11,11,626,391),
1154(1012,12,11,249,57),
1155(1013,13,11,545,273),
1156(1014,14,11,846,782),
1157(1015,15,11,709,588),
1158(1016,16,11,504,418),
1159(1017,17,11,800,606),
1160(1018,18,11,323,302),
1161(1019,19,11,0,0),
1162(1020,20,11,183,102),
1163(1021,21,11,928,876),
1164(1022,22,11,130,0),
1165(1023,23,11,0,0),
1166(1024,24,11,476,374),
1167(1025,25,11,378,329),
1168(1026,26,11,505,452),
1169(1027,27,11,603,389),
1170(1028,28,11,742,488),
1171(1029,29,11,756,742),
1172(1030,30,11,119,0),
1173(1031,31,11,171,56),
1174(1032,32,11,239,201),
1175(1033,33,11,23,0),
1176(1034,34,11,19,0),
1177(1035,35,11,159,154),
1178(1036,36,11,95,0),
1179(1037,37,11,351,304),
1180(1038,38,11,923,636),
1181(1039,39,11,422,146),
1182(1040,40,11,562,550),
1183(1041,41,11,31,2),
1184(1042,42,11,362,70),
1185(1043,43,11,0,0),
1186(1044,44,11,641,355),
1187(1045,45,11,736,675),
1188(1046,46,11,781,604),
1189(1047,47,11,194,137),
1190(1048,48,11,834,620),
1191(1049,49,11,94,0),
1192(1050,50,11,0,0),
1193(1051,51,11,647,379),
1194(1052,52,11,298,88),
1195(1053,53,11,665,537),
1196(1054,54,11,837,709),
1197(1055,55,11,136,0),
1198(1056,56,11,162,0),
1199(1057,57,11,732,705),
1200(1058,58,11,505,265),
1201(1059,59,11,824,565),
1202(1060,60,11,0,0),
1203(1061,61,11,611,552),
1204(1062,62,11,878,807),
1205(1063,63,11,532,360),
1206(1064,64,11,358,330),
1207(1065,65,11,795,793),
1208(1066,66,11,771,769),
1209(1067,67,11,884,721),
1210(1068,68,11,467,225),
1211(1069,69,11,609,605),
1212(1070,70,11,357,356),
1213(1071,71,11,605,551),
1214(1072,72,11,816,625),
1215(1073,73,11,454,236),
1216(1074,74,11,855,635),
1217(1075,75,11,86,77),
1218(1076,76,11,426,281),
1219(1077,77,11,373,280),
1220(1078,78,11,0,0),
1221(1079,79,11,785,701),
1222(1080,80,11,982,965),
1223(1081,81,11,393,123),
1224(1082,82,11,170,0),
1225(1083,83,11,782,541),
1226(1084,84,11,354,101),
1227(1085,85,11,649,528),
1228(1086,86,11,30,0),
1229(1087,87,11,315,74),
1230(1088,88,11,721,634),
1231(1089,89,11,400,375),
1232(1090,90,11,526,450),
1233(1091,91,11,833,632),
1234(1092,92,11,402,323),
1235(1093,93,11,651,625),
1236(1094,94,11,807,663),
1237(1095,95,11,314,28),
1238(1096,96,11,785,643),
1239(1097,97,11,715,443),
1240(1098,98,11,0,0),
1241(1099,99,11,107,94),
1242(1100,100,11,170,75),
1243(1101,1,12,291,0),
1244(1102,2,12,0,0),
1245(1103,3,12,25,0),
1246(1104,4,12,575,398),
1247(1105,5,12,642,600),
1248(1106,6,12,362,193),
1249(1107,7,12,798,671),
1250(1108,8,12,357,347),
1251(1109,9,12,557,477),
1252(1110,10,12,720,503),
1253(1111,11,12,9,0),
1254(1112,12,12,20,0),
1255(1113,13,12,74,58),
1256(1114,14,12,658,617),
1257(1115,15,12,686,589),
1258(1116,16,12,567,458),
1259(1117,17,12,347,109),
1260(1118,18,12,248,245),
1261(1119,19,12,989,942),
1262(1120,20,12,477,280),
1263(1121,21,12,891,849),
1264(1122,22,12,811,806),
1265(1123,23,12,153,0),
1266(1124,24,12,913,681),
1267(1125,25,12,696,417),
1268(1126,26,12,694,692),
1269(1127,27,12,492,341),
1270(1128,28,12,709,571),
1271(1129,29,12,589,545),
1272(1130,30,12,440,427),
1273(1131,31,12,368,139),
1274(1132,32,12,737,653),
1275(1133,33,12,780,622),
1276(1134,34,12,762,757),
1277(1135,35,12,389,153),
1278(1136,36,12,554,306),
1279(1137,37,12,948,915),
1280(1138,38,12,577,315),
1281(1139,39,12,534,440),
1282(1140,40,12,848,673),
1283(1141,41,12,347,294),
1284(1142,42,12,253,144),
1285(1143,43,12,19,0),
1286(1144,44,12,653,542),
1287(1145,45,12,235,157),
1288(1146,46,12,509,266),
1289(1147,47,12,868,731),
1290(1148,48,12,423,270),
1291(1149,49,12,838,773),
1292(1150,50,12,17,11),
1293(1151,51,12,147,108),
1294(1152,52,12,0,0),
1295(1153,53,12,596,443),
1296(1154,54,12,147,0),
1297(1155,55,12,277,75),
1298(1156,56,12,318,196),
1299(1157,57,12,493,424),
1300(1158,58,12,25,0),
1301(1159,59,12,520,309),
1302(1160,60,12,697,433),
1303(1161,61,12,468,403),
1304(1162,62,12,297,47),
1305(1163,63,12,762,716),
1306(1164,64,12,893,692),
1307(1165,65,12,850,780),
1308(1166,66,12,442,351),
1309(1167,67,12,0,0),
1310(1168,68,12,816,777),
1311(1169,69,12,474,431),
1312(1170,70,12,556,280),
1313(1171,71,12,0,0),
1314(1172,72,12,281,267),
1315(1173,73,12,679,388),
1316(1174,74,12,632,613),
1317(1175,75,12,52,0),
1318(1176,76,12,480,203),
1319(1177,77,12,196,9),
1320(1178,78,12,35,0),
1321(1179,79,12,110,0),
1322(1180,80,12,161,71),
1323(1181,81,12,786,563),
1324(1182,82,12,920,886),
1325(1183,83,12,256,82),
1326(1184,84,12,737,506),
1327(1185,85,12,121,0),
1328(1186,86,12,389,111),
1329(1187,87,12,850,664),
1330(1188,88,12,350,145),
1331(1189,89,12,160,0),
1332(1190,90,12,616,465),
1333(1191,91,12,754,655),
1334(1192,92,12,270,106),
1335(1193,93,12,304,230),
1336(1194,94,12,899,681),
1337(1195,95,12,843,765),
1338(1196,96,12,185,74),
1339(1197,97,12,271,216),
1340(1198,98,12,697,566),
1341(1199,99,12,88,0),
1342(1200,100,12,812,571),
1343(1201,1,13,864,801),
1344(1202,2,13,919,873),
1345(1203,3,13,897,844),
1346(1204,4,13,246,22),
1347(1205,5,13,835,687),
1348(1206,6,13,203,129),
1349(1207,7,13,351,251),
1350(1208,8,13,478,357),
1351(1209,9,13,726,691),
1352(1210,10,13,397,322),
1353(1211,11,13,358,340),
1354(1212,12,13,111,0),
1355(1213,13,13,531,414),
1356(1214,14,13,541,371),
1357(1215,15,13,782,553),
1358(1216,16,13,259,87),
1359(1217,17,13,846,791),
1360(1218,18,13,32,0),
1361(1219,19,13,318,172),
1362(1220,20,13,681,573),
1363(1221,21,13,803,647),
1364(1222,22,13,749,515),
1365(1223,23,13,96,0),
1366(1224,24,13,560,540),
1367(1225,25,13,456,387),
1368(1226,26,13,707,543),
1369(1227,27,13,113,100),
1370(1228,28,13,637,534),
1371(1229,29,13,424,130),
1372(1230,30,13,375,266),
1373(1231,31,13,294,242),
1374(1232,32,13,485,201),
1375(1233,33,13,172,0),
1376(1234,34,13,809,759),
1377(1235,35,13,0,0),
1378(1236,36,13,699,449),
1379(1237,37,13,624,560),
1380(1238,38,13,148,87),
1381(1239,39,13,248,0),
1382(1240,40,13,529,469),
1383(1241,41,13,568,555),
1384(1242,42,13,572,388),
1385(1243,43,13,64,0),
1386(1244,44,13,230,201),
1387(1245,45,13,411,327),
1388(1246,46,13,922,695),
1389(1247,47,13,525,418),
1390(1248,48,13,53,0),
1391(1249,49,13,584,368),
1392(1250,50,13,216,36),
1393(1251,51,13,294,14),
1394(1252,52,13,264,105),
1395(1253,53,13,452,438),
1396(1254,54,13,0,0),
1397(1255,55,13,706,489),
1398(1256,56,13,872,688),
1399(1257,57,13,792,773),
1400(1258,58,13,504,416),
1401(1259,59,13,447,325),
1402(1260,60,13,422,264),
1403(1261,61,13,326,278),
1404(1262,62,13,962,663),
1405(1263,63,13,356,286),
1406(1264,64,13,377,119),
1407(1265,65,13,505,223),
1408(1266,66,13,785,691),
1409(1267,67,13,551,393),
1410(1268,68,13,734,689),
1411(1269,69,13,0,0),
1412(1270,70,13,358,88),
1413(1271,71,13,29,0),
1414(1272,72,13,343,256),
1415(1273,73,13,841,634),
1416(1274,74,13,898,859),
1417(1275,75,13,258,164),
1418(1276,76,13,103,48),
1419(1277,77,13,343,44),
1420(1278,78,13,393,257),
1421(1279,79,13,417,202),
1422(1280,80,13,385,346),
1423(1281,81,13,463,287),
1424(1282,82,13,524,228),
1425(1283,83,13,540,400),
1426(1284,84,13,863,685),
1427(1285,85,13,812,657),
1428(1286,86,13,791,732),
1429(1287,87,13,801,565),
1430(1288,88,13,309,161),
1431(1289,89,13,0,0),
1432(1290,90,13,482,260),
1433(1291,91,13,83,34),
1434(1292,92,13,0,0),
1435(1293,93,13,588,382),
1436(1294,94,13,0,0),
1437(1295,95,13,883,776),
1438(1296,96,13,746,710),
1439(1297,97,13,456,374),
1440(1298,98,13,606,528),
1441(1299,99,13,414,222),
1442(1300,100,13,612,523),
1443(1301,1,14,29,3),
1444(1302,2,14,916,905),
1445(1303,3,14,651,476),
1446(1304,4,14,364,105),
1447(1305,5,14,515,255),
1448(1306,6,14,198,30),
1449(1307,7,14,652,455),
1450(1308,8,14,805,685),
1451(1309,9,14,700,612),
1452(1310,10,14,644,395),
1453(1311,11,14,657,547),
1454(1312,12,14,475,293),
1455(1313,13,14,595,495),
1456(1314,14,14,672,562),
1457(1315,15,14,251,208),
1458(1316,16,14,43,0),
1459(1317,17,14,598,422),
1460(1318,18,14,0,0),
1461(1319,19,14,313,27),
1462(1320,20,14,380,105),
1463(1321,21,14,232,0),
1464(1322,22,14,710,476),
1465(1323,23,14,255,173),
1466(1324,24,14,825,623),
1467(1325,25,14,408,352),
1468(1326,26,14,959,861),
1469(1327,27,14,895,652),
1470(1328,28,14,591,414),
1471(1329,29,14,453,307),
1472(1330,30,14,222,217),
1473(1331,31,14,349,90),
1474(1332,32,14,555,376),
1475(1333,33,14,297,108),
1476(1334,34,14,582,487),
1477(1335,35,14,460,242),
1478(1336,36,14,174,88),
1479(1337,37,14,213,83),
1480(1338,38,14,205,195),
1481(1339,39,14,736,691),
1482(1340,40,14,415,391),
1483(1341,41,14,838,732),
1484(1342,42,14,364,343),
1485(1343,43,14,190,181),
1486(1344,44,14,101,0),
1487(1345,45,14,375,281),
1488(1346,46,14,965,810),
1489(1347,47,14,0,0),
1490(1348,48,14,824,678),
1491(1349,49,14,846,648),
1492(1350,50,14,661,603),
1493(1351,51,14,434,413),
1494(1352,52,14,0,0),
1495(1353,53,14,381,140),
1496(1354,54,14,402,229),
1497(1355,55,14,574,342),
1498(1356,56,14,417,240),
1499(1357,57,14,953,785),
1500(1358,58,14,986,788),
1501(1359,59,14,838,620),
1502(1360,60,14,0,0),
1503(1361,61,14,826,622),
1504(1362,62,14,174,82),
1505(1363,63,14,754,502),
1506(1364,64,14,843,826),
1507(1365,65,14,150,18),
1508(1366,66,14,497,395),
1509(1367,67,14,644,391),
1510(1368,68,14,381,248),
1511(1369,69,14,504,233),
1512(1370,70,14,633,613),
1513(1371,71,14,286,14),
1514(1372,72,14,418,198),
1515(1373,73,14,43,0),
1516(1374,74,14,748,512),
1517(1375,75,14,425,390),
1518(1376,76,14,357,216),
1519(1377,77,14,636,459),
1520(1378,78,14,415,319),
1521(1379,79,14,30,0),
1522(1380,80,14,609,536),
1523(1381,81,14,755,528),
1524(1382,82,14,825,787),
1525(1383,83,14,393,267),
1526(1384,84,14,52,0),
1527(1385,85,14,27,0),
1528(1386,86,14,657,467),
1529(1387,87,14,466,210),
1530(1388,88,14,334,231),
1531(1389,89,14,901,785),
1532(1390,90,14,210,100),
1533(1391,91,14,332,251),
1534(1392,92,14,336,330),
1535(1393,93,14,747,531),
1536(1394,94,14,227,149),
1537(1395,95,14,300,141),
1538(1396,96,14,249,147),
1539(1397,97,14,56,0),
1540(1398,98,14,576,553),
1541(1399,99,14,654,644),
1542(1400,100,14,0,0),
1543(1401,1,15,255,36),
1544(1402,2,15,605,582),
1545(1403,3,15,106,14),
1546(1404,4,15,391,192),
1547(1405,5,15,373,265),
1548(1406,6,15,233,24),
1549(1407,7,15,451,357),
1550(1408,8,15,97,0),
1551(1409,9,15,171,150),
1552(1410,10,15,554,296),
1553(1411,11,15,106,0),
1554(1412,12,15,156,96),
1555(1413,13,15,602,321),
1556(1414,14,15,857,584),
1557(1415,15,15,383,89),
1558(1416,16,15,472,209),
1559(1417,17,15,385,149),
1560(1418,18,15,79,0),
1561(1419,19,15,899,646),
1562(1420,20,15,347,177),
1563(1421,21,15,918,623),
1564(1422,22,15,751,479),
1565(1423,23,15,546,346),
1566(1424,24,15,23,0),
1567(1425,25,15,743,613),
1568(1426,26,15,689,538),
1569(1427,27,15,649,383),
1570(1428,28,15,125,0),
1571(1429,29,15,0,0),
1572(1430,30,15,141,34),
1573(1431,31,15,0,0),
1574(1432,32,15,807,639),
1575(1433,33,15,0,0),
1576(1434,34,15,654,492),
1577(1435,35,15,796,656),
1578(1436,36,15,280,0),
1579(1437,37,15,38,0),
1580(1438,38,15,605,337),
1581(1439,39,15,860,583),
1582(1440,40,15,615,340),
1583(1441,41,15,337,45),
1584(1442,42,15,405,366),
1585(1443,43,15,0,0),
1586(1444,44,15,90,0),
1587(1445,45,15,452,388),
1588(1446,46,15,956,720),
1589(1447,47,15,708,609),
1590(1448,48,15,885,694),
1591(1449,49,15,91,0),
1592(1450,50,15,326,237),
1593(1451,51,15,293,107),
1594(1452,52,15,776,503),
1595(1453,53,15,592,456),
1596(1454,54,15,352,259),
1597(1455,55,15,158,137),
1598(1456,56,15,376,159),
1599(1457,57,15,840,580),
1600(1458,58,15,879,819),
1601(1459,59,15,507,283),
1602(1460,60,15,620,353),
1603(1461,61,15,809,511),
1604(1462,62,15,714,599),
1605(1463,63,15,511,243),
1606(1464,64,15,937,909),
1607(1465,65,15,444,178),
1608(1466,66,15,248,68),
1609(1467,67,15,155,100),
1610(1468,68,15,252,250),
1611(1469,69,15,129,0),
1612(1470,70,15,401,339),
1613(1471,71,15,431,249),
1614(1472,72,15,729,438),
1615(1473,73,15,272,103),
1616(1474,74,15,925,638),
1617(1475,75,15,561,336),
1618(1476,76,15,909,664),
1619(1477,77,15,560,401),
1620(1478,78,15,773,621),
1621(1479,79,15,0,0),
1622(1480,80,15,411,347),
1623(1481,81,15,783,513),
1624(1482,82,15,316,306),
1625(1483,83,15,575,314),
1626(1484,84,15,934,912),
1627(1485,85,15,530,383),
1628(1486,86,15,423,158),
1629(1487,87,15,47,0),
1630(1488,88,15,212,166),
1631(1489,89,15,686,654),
1632(1490,90,15,694,465),
1633(1491,91,15,330,236),
1634(1492,92,15,655,595),
1635(1493,93,15,583,384),
1636(1494,94,15,882,724),
1637(1495,95,15,370,180),
1638(1496,96,15,617,388),
1639(1497,97,15,662,659),
1640(1498,98,15,937,876),
1641(1499,99,15,891,788),
1642(1500,100,15,888,677),
1643(1501,1,16,870,642),
1644(1502,2,16,464,354),
1645(1503,3,16,261,0),
1646(1504,4,16,828,779),
1647(1505,5,16,16,0),
1648(1506,6,16,738,452),
1649(1507,7,16,282,63),
1650(1508,8,16,488,312),
1651(1509,9,16,216,142),
1652(1510,10,16,632,381),
1653(1511,11,16,0,0),
1654(1512,12,16,374,374),
1655(1513,13,16,0,0),
1656(1514,14,16,517,241),
1657(1515,15,16,888,738),
1658(1516,16,16,149,41),
1659(1517,17,16,132,25),
1660(1518,18,16,445,182),
1661(1519,19,16,507,270),
1662(1520,20,16,266,29),
1663(1521,21,16,69,0),
1664(1522,22,16,600,399),
1665(1523,23,16,398,285),
1666(1524,24,16,9,0),
1667(1525,25,16,722,430),
1668(1526,26,16,772,687),
1669(1527,27,16,64,0),
1670(1528,28,16,817,638),
1671(1529,29,16,925,830),
1672(1530,30,16,114,0),
1673(1531,31,16,49,0),
1674(1532,32,16,379,358),
1675(1533,33,16,596,327),
1676(1534,34,16,100,0),
1677(1535,35,16,730,719),
1678(1536,36,16,539,306),
1679(1537,37,16,671,378),
1680(1538,38,16,127,0),
1681(1539,39,16,856,717),
1682(1540,40,16,0,0),
1683(1541,41,16,523,484),
1684(1542,42,16,319,259),
1685(1543,43,16,444,174),
1686(1544,44,16,262,0),
1687(1545,45,16,594,379),
1688(1546,46,16,598,592),
1689(1547,47,16,28,0),
1690(1548,48,16,134,117),
1691(1549,49,16,127,102),
1692(1550,50,16,688,661),
1693(1551,51,16,578,527),
1694(1552,52,16,784,761),
1695(1553,53,16,459,253),
1696(1554,54,16,818,618),
1697(1555,55,16,334,290),
1698(1556,56,16,0,0),
1699(1557,57,16,355,174),
1700(1558,58,16,906,780),
1701(1559,59,16,0,0),
1702(1560,60,16,719,517),
1703(1561,61,16,547,481),
1704(1562,62,16,193,176),
1705(1563,63,16,134,40),
1706(1564,64,16,181,92),
1707(1565,65,16,263,132),
1708(1566,66,16,18,0),
1709(1567,67,16,578,541),
1710(1568,68,16,630,577),
1711(1569,69,16,36,0),
1712(1570,70,16,306,302),
1713(1571,71,16,614,398),
1714(1572,72,16,318,183),
1715(1573,73,16,131,0),
1716(1574,74,16,198,99),
1717(1575,75,16,376,82),
1718(1576,76,16,255,47),
1719(1577,77,16,263,0),
1720(1578,78,16,946,653),
1721(1579,79,16,798,519),
1722(1580,80,16,393,278),
1723(1581,81,16,91,56),
1724(1582,82,16,596,364),
1725(1583,83,16,811,638),
1726(1584,84,16,359,262),
1727(1585,85,16,309,156),
1728(1586,86,16,414,276),
1729(1587,87,16,490,213),
1730(1588,88,16,578,577),
1731(1589,89,16,811,774),
1732(1590,90,16,221,0),
1733(1591,91,16,0,0),
1734(1592,92,16,496,276),
1735(1593,93,16,920,813),
1736(1594,94,16,288,68),
1737(1595,95,16,0,0),
1738(1596,96,16,572,338),
1739(1597,97,16,777,563),
1740(1598,98,16,629,600),
1741(1599,99,16,165,85),
1742(1600,100,16,40,0);
1743ALTER TABLE `SubsidiaryBook`
1744 ADD PRIMARY KEY (`id`);
1745
1746--
1747-- Tabellenstruktur für Tabelle `Subsidiary`
1748--
1749CREATE TABLE IF NOT EXISTS `Subsidiary` (
1750  `subsidiary_id` int(11) NOT NULL,
1751  `name` varchar(255) NOT NULL,
1752  `location` varchar(255) NOT NULL
1753) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=17 ;
1754
1755
1756INSERT INTO `Subsidiary` (`subsidiary_id`,`name`, `location`) VALUES
1757(1,'Imaginetworks','Koswistan'),
1758(2,'Leopardworks','Whuesia'),
1759(3,'Triumphoods','Sniytan'),
1760(4,'Cosmic Library','Dufrait'),
1761(5,'Cloudcast','Oblary'),
1762(6,'Surge Records','Cuswayae'),
1763(7,'Radiantelligence','Oskax'),
1764(8,'Quick Rooster Media','Smuaque'),
1765(9,'Tucan Productions','Duskines'),
1766(10,'Tiny Mermaid Arts','Eglela'),
1767(11,'Spring Harbor Bilbiotheca','Stua Scela'),
1768(12,'Sphinx Brews','Kagluaton'),
1769(13,'Amazonhive','Stua Scela'),
1770(14,'Globalworld','Strauw Fren'),
1771(15,'Royal Library','Abros'),
1772(16,'Celestial Library','Dufrait');
1773
1774
1775ALTER TABLE `Subsidiary`
1776 ADD PRIMARY KEY (`subsidiary_id`);