INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Raoh"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Raoh') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2077, 2944, 3803, 4542, 4543, 4544, 4545, 6564,); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Toki"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Toki') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (476, 500, 2345, 2493, 4930, 5735, 6500, 7620, 7730); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Satsuki Yumiduka"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Satsuki Yumiduka') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2631, 3241, 3242, 4522, 5009, 6518, 6779, 7006, 7401); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Aoko Aozaki"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Aoko Aozaki') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (560, 561, 2621, 2622, 3449, 4511, 6728, 6843, 7438); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Gustab Munchausen"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Gustab Munchausen') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (774, 954, 1389, 2292, 2293, 2294, 2903, 4157, 4269); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Rock Howard"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Rock Howard') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (41, 305, 1143, 1398, 2816, 3854, 3855, 4480, 4552, 4747, 4748, 4750, 4751, 4752, 4758, 4760, 5250); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Ultraman"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Ultraman') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (5844, 7290, 8386, 8392, 8395, 8397, 8398, 7290, 8386, 8392, 8393, 8398, 9726, 9728, 5840, 5844, 7290, 8387, 8395, 8397); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Shana"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Shana') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (10934, 10990,); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Ken"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Ken') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (957, 1359, 1673, 1760, 2331, 2536, 2953, 2954, 2955, 2956, 3906, 3916, 4215, 4356, 5093, 5111, 5497, 6113, 6644, 6866, 7040, 7041, 7098, 7315, 7775); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Ryu"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Ryu') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (1763, 3112, 3880, 4839, 4855, 4856, 4857, 4860,5104, 5119, 5230, 6885, 6993, 6994); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Sean Matsuda"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Sean Matsuda') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (5052, 5347, 7009, 5052, 5053, 5347, 7009); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Hisui"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Hisui') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (462, 2422, 2468, 2625, 2674, 3414, 3606, 3650, 4144, 4325, 4517, 5791, 5960); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Adelheid Bernstein"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Adelheid Bernstein') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (336, 337, 338, 339, 340, 341, 342, 1935, 1936, 2334, 3867, 4188, 6384); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Shiki Nanaya"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Shiki Nanaya') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (757, 1851, 2523, 2524, 2628, 2726, 3851, 4030, 4031, 4032, 4033, 4034, 4143, 4866, 5178, 5182, 5183, 5429, 6746, 6781, 6782, 7398, 7402, 7666, 7669, 7791, 7883, 8058, 8352, 8404, 8499, 8769, 8904, 8926, 8962, 9228,); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Michael Roa Valdamjong"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Michael Roa Valdamjong') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (30, 921, 1903, 4521, 4713); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Yuri Sakazaki"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Yuri Sakazaki') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (76, 2804, 4785, 5545, 6257, 6259, 6260, 6714, 10214); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Kung Fu Man"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Kung Fu Man') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (279, 370, 437, 1080, 1459, 1529, 2475, 2592, 2746, 2963, 2965, 2992, 4107, 6137, 6494, 6734, 6749, 7323, 8087, 8182); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Fei Long"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Fei Long') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (126, 5403, 5669, 9441,); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Balrog"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Balrog') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (156, 782, 1284, 1597); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Shikyoh"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Shikyoh') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (50, 3581); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Mai Kawasumi"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Mai Kawasumi') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (253, 4004, 4005, 4476, 4662, 4666); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Ayu Tsukimiya"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Ayu Tsukimiya') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (241, 578, 604, 688, 731, 732); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Kanna"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Kanna') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (249, 2047, 2884, 6053, 7473, 7629, 8819,); // ? INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Len"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Len') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (321,478,3127,3330,534,645,1855,2061,2104,2854,3273,3296,3297,3298,3318,3394,3829,3997,4189,4313,4382,4389,4514,4729,4876,5028,5039,5363,7342,97,2338,172, 7869,); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Kim Kaphwan"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Kim Kaphwan') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (6484,6486,9512,4580,6921,6435,10541,11071,2983,11176,2989,1561,9251,2677,2986,2987,10687); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Geese Howard"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Geese Howard') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN ( 8790,6580,1744,2590,6791,3978,9114,5299,11206,10741,3326,2072,7206,11058,7736,8159,4587,2060,2064,2065,2067,2068,2069,4121,7477,5777,9651,10692,7119,2066,2070,8241,10665,11441,2071); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Cell"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Cell') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN ( 6427,1073,7905,1071,1072,1654,5835,2555); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Magaki"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Magaki') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (3438,7458,1608,9262,11133,2383,2507,10298,3439,4877,3440,11524,1608,1945,2507,3438,3439,3440,3576,4877,6111,7343,7458,8013,8489,9262,9263,10298,11133,11524); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (27, "Doremy Sweet"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Doremy Sweet') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11373); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Reimu Hakurei') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11232); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Youmu Konpaku') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11227); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Nitori Kawashiro') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11341); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Suwako Moriya') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11351); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Koakuma') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11196); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Momiji Inubashiri') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11204); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Reisen') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11405); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Tenshi Hinanawi') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11315); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Daiyousei') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11396); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Kyo Kusanagi') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (747,1197,1767,3218,3221,3239,4091,4929,5851,6605,6755,6929,9044,9057,9374,9570,9681,9892,9989,10475,10920,11179,11321); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "K-Dash"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'K-Dash') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (6979,11471,11453,11128,11065,11066,10651,10703,10875,10786,10723,10595,10538,10326,10340,9882,10122,10095,9853,9883,9779,9505,9543,8922,9518,9408,9040,8983,8923,8921,9048,8413,8917,8930,7747,7720,8273,7793,8436,8343,8481,8115,7748,7637,7751,7356,7356,7336,6979,6687,6525,6492,10651,10122,2810,11066,9518,8917,7748,9883,9367,8983,7720,9040,9601,10703,2818,542,11128,881,2806,10095,8930,11499,2807,8127,11453,3252,2809,10538,10723,6525,2808,3260,9882,11065,7793,7356,8343,7747,5816,6687,6027,542,881,915,964,1790,2807,2810,2934,2974,3252,5430,5816,6084,6979,7170,7356,7375,7682,7720,7749,8112,8127,8273,8343,8413,8436,8724,8917,8921,8922,8923,8930,9408,9518,9543,9601,9779,9859,10095,10326,10538,10651,10786,10875,11066,11429,11453); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Zero"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Zero') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (87,326,591,988,1194,1331,2433,2935,4117,4187,4561,5315,5358,5922,5970,6349,6350,6351,6815,11086,87,326,988,1194,1331,2433,4117,4561,5358,6349,6817,8096,8522,8531,9581,9647,9732,9756,10363,10951,11086,11201); // Up UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Iori Yagami') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (10634); // Up UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Orochi Mizuchi') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11326); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Nakoruru"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Nakoruru') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (7230,10506,10556,6825,8498,10100,3899,4015,6959,6583,9550,4014,6634); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Kohaku"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Kohaku') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2626,8032,6428,9102,3074,1326,6750,6517,9599,9783,6537,7754,3077,3075,3076,9786); // Up UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Rugal Bernstein') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (6481); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Guile"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Guile') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2275,2277,4989,5062,5096,5100,2279,2813,5062,6498,6897); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Jotaro Kujo"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Jotaro Kujo') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (231, 1575, 2737, 2738); // ? INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Kula Diamond"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Kula Diamond') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (199, 2526,1222,1304,6573,1761,2485,3166,9043,11075,10639,200,9004,3167,8132,3168,3162,3169,9891,9285,3161,9751,6682,3253,9531,10205,4724,8005,6542,6639,8014,7876,9250,1222,1248,1761,3166,4724,4775,5482,5832,6152,6573,7876,8363,10320,11075,200,374,375,376,477,502,1222,1248,1761,2142,2485,2647,2648,3161,3162,3164,3165,3166,3167,3168,3253,3626,4593,4724,5047,5482,5832,6152,568,695,697,1766,2432,3160,3626,5174,10348,477,568,695,697,1766,2432,3160,3626,5174,5252,5253); // The Last Blade INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Kaede"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Kaede') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2827,15,6821,6581,2828,14,2830,10918,4872,3981,44,11450,6092,11168); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Shiki Tohno"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Shiki Tohno') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2632,2728,4523,5181,5724,6519,6643,6678,6783); // ? INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Shiki Tohno"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Shiki Tohno') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2632,2728,4523,5181,5724,6519,6643,6678,6783); // ? INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Goenitz"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Goenitz') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2192,3089,1230,2188,6409,2189,2190,2191,2192,3089,3437,3495,4212,5564,5565,6022,6557,6766,2188,9091,7732,2191,2189,10693,9281,9671,9972,7333,10725,6557,3437,3495,6766,4212,9931,2190,5564,7817,6022,6409); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Athena Asamiya"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Athena Asamiya') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (671,672,678,680,1454,677,679,1333,7441,7678,7929,8439,665,669,671,672,673,678,3247,5350,6346,672,678,680,1454,677,679,1333,7441,7678,7929,8439,675,9810); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Zangief"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Zangief') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (56,1293,3259,3602,3607,5286,6301,6305); // KOF2001 INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Igniz"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Igniz') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (2563,298,6510,2567,2565,3356,10101,2566,7076,9243,10793,6169,298,415,1942,2563,2565,2566,2567,3356,3763); // The Last Blade 2 INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Zantetsu"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Zantetsu') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (6405,6313,6792,9187); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Kasen Ibaraki') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11476); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Sanae Kochiya') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11360); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Marisa Kirisame') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11463); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Koakuma') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11368); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Ryougi Shiki"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Ryougi Shiki') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11446,11275,10450,2727,4836,5897,6631,6778,6991,7400,7643,7825,7826); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Arcueid Brunestud"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Arcueid Brunestud') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11428); INSERT INTO BaseNames(BaseNames_SID, BaseNames_Name) VALUES (0, "Archetype Earth"); UPDATE CHARACTERS INNER JOIN BaseNames ON (BaseNames_Name = 'Archetype Earth') SET Char_BID = BaseNames_ID WHERE CHAR_ID IN (11418);