/*
 * Clean up section
 * The queries performed in the section will remove depreciated tables and columns
 */

SELECT '1. Update equipment IDs.' AS '';
-- Use this file to place all items to bank and add new inventory layout.
CREATE TABLE IF NOT EXISTS `openrsc_reindexer`
(
    `old_catalogID` int(10) UNSIGNED    DEFAULT NULL,
    `catalogID`     int(10) UNSIGNED    DEFAULT NULL,
    `noted`         tinyint(1) UNSIGNED DEFAULT 0,
    PRIMARY KEY (`old_catalogID`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8;

INSERT INTO `openrsc_reindexer` (`old_catalogID`, `catalogID`, `noted`)
VALUES (0, 0, 0),
       (1, 1, 0),
       (2, 2, 0),
       (3, 3, 0),
       (4, 4, 0),
       (5, 5, 0),
       (6, 6, 0),
       (7, 7, 0),
       (8, 8, 0),
       (9, 9, 0),
       (10, 10, 0),
       (11, 11, 0),
       (12, 12, 0),
       (13, 13, 0),
       (14, 14, 0),
       (15, 15, 0),
       (16, 16, 0),
       (17, 17, 0),
       (18, 18, 0),
       (19, 19, 0),
       (20, 20, 0),
       (21, 21, 0),
       (22, 22, 0),
       (23, 23, 0),
       (24, 24, 0),
       (25, 25, 0),
       (26, 26, 0),
       (27, 27, 0),
       (28, 28, 0),
       (29, 29, 0),
       (30, 30, 0),
       (31, 31, 0),
       (32, 32, 0),
       (33, 33, 0),
       (34, 34, 0),
       (35, 35, 0),
       (36, 36, 0),
       (37, 37, 0),
       (38, 38, 0),
       (39, 39, 0),
       (40, 40, 0),
       (41, 41, 0),
       (42, 42, 0),
       (43, 43, 0),
       (44, 44, 0),
       (45, 45, 0),
       (46, 46, 0),
       (47, 47, 0),
       (48, 48, 0),
       (49, 49, 0),
       (50, 50, 0),
       (51, 51, 0),
       (52, 52, 0),
       (53, 53, 0),
       (54, 54, 0),
       (55, 55, 0),
       (56, 56, 0),
       (57, 57, 0),
       (58, 58, 0),
       (59, 59, 0),
       (60, 60, 0),
       (61, 61, 0),
       (62, 62, 0),
       (63, 63, 0),
       (64, 64, 0),
       (65, 65, 0),
       (66, 66, 0),
       (67, 67, 0),
       (68, 68, 0),
       (69, 69, 0),
       (70, 70, 0),
       (71, 71, 0),
       (72, 72, 0),
       (73, 73, 0),
       (74, 74, 0),
       (75, 75, 0),
       (76, 76, 0),
       (77, 77, 0),
       (78, 78, 0),
       (79, 79, 0),
       (80, 80, 0),
       (81, 81, 0),
       (82, 82, 0),
       (83, 83, 0),
       (84, 84, 0),
       (85, 85, 0),
       (86, 86, 0),
       (87, 87, 0),
       (88, 88, 0),
       (89, 89, 0),
       (90, 90, 0),
       (91, 91, 0),
       (92, 92, 0),
       (93, 93, 0),
       (94, 94, 0),
       (95, 95, 0),
       (96, 96, 0),
       (97, 97, 0),
       (98, 98, 0),
       (99, 99, 0),
       (100, 100, 0),
       (101, 101, 0),
       (102, 102, 0),
       (103, 103, 0),
       (104, 104, 0),
       (105, 105, 0),
       (106, 106, 0),
       (107, 107, 0),
       (108, 108, 0),
       (109, 109, 0),
       (110, 110, 0),
       (111, 111, 0),
       (112, 112, 0),
       (113, 113, 0),
       (114, 114, 0),
       (115, 115, 0),
       (116, 116, 0),
       (117, 117, 0),
       (118, 118, 0),
       (119, 119, 0),
       (120, 120, 0),
       (121, 121, 0),
       (122, 122, 0),
       (123, 123, 0),
       (124, 124, 0),
       (125, 125, 0),
       (126, 126, 0),
       (127, 127, 0),
       (128, 128, 0),
       (129, 129, 0),
       (130, 130, 0),
       (131, 131, 0),
       (132, 132, 0),
       (133, 133, 0),
       (134, 134, 0),
       (135, 135, 0),
       (136, 136, 0),
       (137, 137, 0),
       (138, 138, 0),
       (139, 139, 0),
       (140, 140, 0),
       (141, 141, 0),
       (142, 142, 0),
       (143, 143, 0),
       (144, 144, 0),
       (145, 145, 0),
       (146, 146, 0),
       (147, 147, 0),
       (148, 148, 0),
       (149, 149, 0),
       (150, 150, 0),
       (151, 151, 0),
       (152, 152, 0),
       (153, 153, 0),
       (154, 154, 0),
       (155, 155, 0),
       (156, 156, 0),
       (157, 157, 0),
       (158, 158, 0),
       (159, 159, 0),
       (160, 160, 0),
       (161, 161, 0),
       (162, 162, 0),
       (163, 163, 0),
       (164, 164, 0),
       (165, 165, 0),
       (166, 166, 0),
       (167, 167, 0),
       (168, 168, 0),
       (169, 169, 0),
       (170, 170, 0),
       (171, 171, 0),
       (172, 172, 0),
       (173, 173, 0),
       (174, 174, 0),
       (175, 175, 0),
       (176, 176, 0),
       (177, 177, 0),
       (178, 178, 0),
       (179, 179, 0),
       (180, 180, 0),
       (181, 181, 0),
       (182, 182, 0),
       (183, 183, 0),
       (184, 184, 0),
       (185, 185, 0),
       (186, 186, 0),
       (187, 187, 0),
       (188, 188, 0),
       (189, 189, 0),
       (190, 190, 0),
       (191, 191, 0),
       (192, 192, 0),
       (193, 193, 0),
       (194, 194, 0),
       (195, 195, 0),
       (196, 196, 0),
       (197, 197, 0),
       (198, 198, 0),
       (199, 199, 0),
       (200, 200, 0),
       (201, 201, 0),
       (202, 202, 0),
       (203, 203, 0),
       (204, 204, 0),
       (205, 205, 0),
       (206, 206, 0),
       (207, 207, 0),
       (208, 208, 0),
       (209, 209, 0),
       (210, 210, 0),
       (211, 211, 0),
       (212, 212, 0),
       (213, 213, 0),
       (214, 214, 0),
       (215, 215, 0),
       (216, 216, 0),
       (217, 217, 0),
       (218, 218, 0),
       (219, 219, 0),
       (220, 220, 0),
       (221, 221, 0),
       (222, 222, 0),
       (223, 223, 0),
       (224, 224, 0),
       (225, 225, 0),
       (226, 226, 0),
       (227, 227, 0),
       (228, 228, 0),
       (229, 229, 0),
       (230, 230, 0),
       (231, 231, 0),
       (232, 232, 0),
       (233, 233, 0),
       (234, 234, 0),
       (235, 235, 0),
       (236, 236, 0),
       (237, 237, 0),
       (238, 238, 0),
       (239, 239, 0),
       (240, 240, 0),
       (241, 241, 0),
       (242, 242, 0),
       (243, 243, 0),
       (244, 244, 0),
       (245, 245, 0),
       (246, 246, 0),
       (247, 247, 0),
       (248, 248, 0),
       (249, 249, 0),
       (250, 250, 0),
       (251, 251, 0),
       (252, 252, 0),
       (253, 253, 0),
       (254, 254, 0),
       (255, 255, 0),
       (256, 256, 0),
       (257, 257, 0),
       (258, 258, 0),
       (259, 259, 0),
       (260, 260, 0),
       (261, 261, 0),
       (262, 262, 0),
       (263, 263, 0),
       (264, 264, 0),
       (265, 265, 0),
       (266, 266, 0),
       (267, 267, 0),
       (268, 268, 0),
       (269, 269, 0),
       (270, 270, 0),
       (271, 271, 0),
       (272, 272, 0),
       (273, 273, 0),
       (274, 274, 0),
       (275, 275, 0),
       (276, 276, 0),
       (277, 277, 0),
       (278, 278, 0),
       (279, 279, 0),
       (280, 280, 0),
       (281, 281, 0),
       (282, 282, 0),
       (283, 283, 0),
       (284, 284, 0),
       (285, 285, 0),
       (286, 286, 0),
       (287, 287, 0),
       (288, 288, 0),
       (289, 289, 0),
       (290, 290, 0),
       (291, 291, 0),
       (292, 292, 0),
       (293, 293, 0),
       (294, 294, 0),
       (295, 295, 0),
       (296, 296, 0),
       (297, 297, 0),
       (298, 298, 0),
       (299, 299, 0),
       (300, 300, 0),
       (301, 301, 0),
       (302, 302, 0),
       (303, 303, 0),
       (304, 304, 0),
       (305, 305, 0),
       (306, 306, 0),
       (307, 307, 0),
       (308, 308, 0),
       (309, 309, 0),
       (310, 310, 0),
       (311, 311, 0),
       (312, 312, 0),
       (313, 313, 0),
       (314, 314, 0),
       (315, 315, 0),
       (316, 316, 0),
       (317, 317, 0),
       (318, 318, 0),
       (319, 319, 0),
       (320, 320, 0),
       (321, 321, 0),
       (322, 322, 0),
       (323, 323, 0),
       (324, 324, 0),
       (325, 325, 0),
       (326, 326, 0),
       (327, 327, 0),
       (328, 328, 0),
       (329, 329, 0),
       (330, 330, 0),
       (331, 331, 0),
       (332, 332, 0),
       (333, 333, 0),
       (334, 334, 0),
       (335, 335, 0),
       (336, 336, 0),
       (337, 337, 0),
       (338, 338, 0),
       (339, 339, 0),
       (340, 340, 0),
       (341, 341, 0),
       (342, 342, 0),
       (343, 343, 0),
       (344, 344, 0),
       (345, 345, 0),
       (346, 346, 0),
       (347, 347, 0),
       (348, 348, 0),
       (349, 349, 0),
       (350, 350, 0),
       (351, 351, 0),
       (352, 352, 0),
       (353, 353, 0),
       (354, 354, 0),
       (355, 355, 0),
       (356, 356, 0),
       (357, 357, 0),
       (358, 358, 0),
       (359, 359, 0),
       (360, 360, 0),
       (361, 361, 0),
       (362, 362, 0),
       (363, 363, 0),
       (364, 364, 0),
       (365, 365, 0),
       (366, 366, 0),
       (367, 367, 0),
       (368, 368, 0),
       (369, 369, 0),
       (370, 370, 0),
       (371, 371, 0),
       (372, 372, 0),
       (373, 373, 0),
       (374, 374, 0),
       (375, 375, 0),
       (376, 376, 0),
       (377, 377, 0),
       (378, 378, 0),
       (379, 379, 0),
       (380, 380, 0),
       (381, 381, 0),
       (382, 382, 0),
       (383, 383, 0),
       (384, 384, 0),
       (385, 385, 0),
       (386, 386, 0),
       (387, 387, 0),
       (388, 388, 0),
       (389, 389, 0),
       (390, 390, 0),
       (391, 391, 0),
       (392, 392, 0),
       (393, 393, 0),
       (394, 394, 0),
       (395, 395, 0),
       (396, 396, 0),
       (397, 397, 0),
       (398, 398, 0),
       (399, 399, 0),
       (400, 400, 0),
       (401, 401, 0),
       (402, 402, 0),
       (403, 403, 0),
       (404, 404, 0),
       (405, 405, 0),
       (406, 406, 0),
       (407, 407, 0),
       (408, 408, 0),
       (409, 409, 0),
       (410, 410, 0),
       (411, 411, 0),
       (412, 412, 0),
       (413, 413, 0),
       (414, 414, 0),
       (415, 415, 0),
       (416, 416, 0),
       (417, 417, 0),
       (418, 418, 0),
       (419, 419, 0),
       (420, 420, 0),
       (421, 421, 0),
       (422, 422, 0),
       (423, 423, 0),
       (424, 424, 0),
       (425, 425, 0),
       (426, 426, 0),
       (427, 427, 0),
       (428, 428, 0),
       (429, 429, 0),
       (430, 430, 0),
       (431, 431, 0),
       (432, 432, 0),
       (433, 433, 0),
       (434, 434, 0),
       (435, 435, 0),
       (436, 436, 0),
       (437, 437, 0),
       (438, 438, 0),
       (439, 439, 0),
       (440, 440, 0),
       (441, 441, 0),
       (442, 442, 0),
       (443, 443, 0),
       (444, 444, 0),
       (445, 445, 0),
       (446, 446, 0),
       (447, 447, 0),
       (448, 448, 0),
       (449, 449, 0),
       (450, 450, 0),
       (451, 451, 0),
       (452, 452, 0),
       (453, 453, 0),
       (454, 454, 0),
       (455, 455, 0),
       (456, 456, 0),
       (457, 457, 0),
       (458, 458, 0),
       (459, 459, 0),
       (460, 460, 0),
       (461, 461, 0),
       (462, 462, 0),
       (463, 463, 0),
       (464, 464, 0),
       (465, 465, 0),
       (466, 466, 0),
       (467, 467, 0),
       (468, 468, 0),
       (469, 469, 0),
       (470, 470, 0),
       (471, 471, 0),
       (472, 472, 0),
       (473, 473, 0),
       (474, 474, 0),
       (475, 475, 0),
       (476, 476, 0),
       (477, 477, 0),
       (478, 478, 0),
       (479, 479, 0),
       (480, 480, 0),
       (481, 481, 0),
       (482, 482, 0),
       (483, 483, 0),
       (484, 484, 0),
       (485, 485, 0),
       (486, 486, 0),
       (487, 487, 0),
       (488, 488, 0),
       (489, 489, 0),
       (490, 490, 0),
       (491, 491, 0),
       (492, 492, 0),
       (493, 493, 0),
       (494, 494, 0),
       (495, 495, 0),
       (496, 496, 0),
       (497, 497, 0),
       (498, 498, 0),
       (499, 499, 0);
INSERT INTO `openrsc_reindexer` (`old_catalogID`, `catalogID`, `noted`)
VALUES (500, 500, 0),
       (501, 501, 0),
       (502, 502, 0),
       (503, 503, 0),
       (504, 504, 0),
       (505, 505, 0),
       (506, 506, 0),
       (507, 507, 0),
       (508, 508, 0),
       (509, 509, 0),
       (510, 510, 0),
       (511, 511, 0),
       (512, 512, 0),
       (513, 513, 0),
       (514, 514, 0),
       (515, 515, 0),
       (516, 516, 0),
       (517, 517, 0),
       (518, 518, 0),
       (519, 519, 0),
       (520, 520, 0),
       (521, 521, 0),
       (522, 522, 0),
       (523, 523, 0),
       (524, 524, 0),
       (525, 525, 0),
       (526, 526, 0),
       (527, 527, 0),
       (528, 528, 0),
       (529, 529, 0),
       (530, 530, 0),
       (531, 531, 0),
       (532, 532, 0),
       (533, 533, 0),
       (534, 534, 0),
       (535, 535, 0),
       (536, 536, 0),
       (537, 537, 0),
       (538, 538, 0),
       (539, 539, 0),
       (540, 540, 0),
       (541, 541, 0),
       (542, 542, 0),
       (543, 543, 0),
       (544, 544, 0),
       (545, 545, 0),
       (546, 546, 0),
       (547, 547, 0),
       (548, 548, 0),
       (549, 549, 0),
       (550, 550, 0),
       (551, 551, 0),
       (552, 552, 0),
       (553, 553, 0),
       (554, 554, 0),
       (555, 555, 0),
       (556, 556, 0),
       (557, 557, 0),
       (558, 558, 0),
       (559, 559, 0),
       (560, 560, 0),
       (561, 561, 0),
       (562, 562, 0),
       (563, 563, 0),
       (564, 564, 0),
       (565, 565, 0),
       (566, 566, 0),
       (567, 567, 0),
       (568, 568, 0),
       (569, 569, 0),
       (570, 570, 0),
       (571, 571, 0),
       (572, 572, 0),
       (573, 573, 0),
       (574, 574, 0),
       (575, 575, 0),
       (576, 576, 0),
       (577, 577, 0),
       (578, 578, 0),
       (579, 579, 0),
       (580, 580, 0),
       (581, 581, 0),
       (582, 582, 0),
       (583, 583, 0),
       (584, 584, 0),
       (585, 585, 0),
       (586, 586, 0),
       (587, 587, 0),
       (588, 588, 0),
       (589, 589, 0),
       (590, 590, 0),
       (591, 591, 0),
       (592, 592, 0),
       (593, 593, 0),
       (594, 594, 0),
       (595, 595, 0),
       (596, 596, 0),
       (597, 597, 0),
       (598, 598, 0),
       (599, 599, 0),
       (600, 600, 0),
       (601, 601, 0),
       (602, 602, 0),
       (603, 603, 0),
       (604, 604, 0),
       (605, 605, 0),
       (606, 606, 0),
       (607, 607, 0),
       (608, 608, 0),
       (609, 609, 0),
       (610, 610, 0),
       (611, 611, 0),
       (612, 612, 0),
       (613, 613, 0),
       (614, 614, 0),
       (615, 615, 0),
       (616, 616, 0),
       (617, 617, 0),
       (618, 618, 0),
       (619, 619, 0),
       (620, 620, 0),
       (621, 621, 0),
       (622, 622, 0),
       (623, 623, 0),
       (624, 624, 0),
       (625, 625, 0),
       (626, 626, 0),
       (627, 627, 0),
       (628, 628, 0),
       (629, 629, 0),
       (630, 630, 0),
       (631, 631, 0),
       (632, 632, 0),
       (633, 633, 0),
       (634, 634, 0),
       (635, 635, 0),
       (636, 636, 0),
       (637, 637, 0),
       (638, 638, 0),
       (639, 639, 0),
       (640, 640, 0),
       (641, 641, 0),
       (642, 642, 0),
       (643, 643, 0),
       (644, 644, 0),
       (645, 645, 0),
       (646, 646, 0),
       (647, 647, 0),
       (648, 648, 0),
       (649, 649, 0),
       (650, 650, 0),
       (651, 651, 0),
       (652, 652, 0),
       (653, 653, 0),
       (654, 654, 0),
       (655, 655, 0),
       (656, 656, 0),
       (657, 657, 0),
       (658, 658, 0),
       (659, 659, 0),
       (660, 660, 0),
       (661, 661, 0),
       (662, 662, 0),
       (663, 663, 0),
       (664, 664, 0),
       (665, 665, 0),
       (666, 666, 0),
       (667, 667, 0),
       (668, 668, 0),
       (669, 669, 0),
       (670, 670, 0),
       (671, 671, 0),
       (672, 672, 0),
       (673, 673, 0),
       (674, 674, 0),
       (675, 675, 0),
       (676, 676, 0),
       (677, 677, 0),
       (678, 678, 0),
       (679, 679, 0),
       (680, 680, 0),
       (681, 681, 0),
       (682, 682, 0),
       (683, 683, 0),
       (684, 684, 0),
       (685, 685, 0),
       (686, 686, 0),
       (687, 687, 0),
       (688, 688, 0),
       (689, 689, 0),
       (690, 690, 0),
       (691, 691, 0),
       (692, 692, 0),
       (693, 693, 0),
       (694, 694, 0),
       (695, 695, 0),
       (696, 696, 0),
       (697, 697, 0),
       (698, 698, 0),
       (699, 699, 0),
       (700, 700, 0),
       (701, 701, 0),
       (702, 702, 0),
       (703, 703, 0),
       (704, 704, 0),
       (705, 705, 0),
       (706, 706, 0),
       (707, 707, 0),
       (708, 708, 0),
       (709, 709, 0),
       (710, 710, 0),
       (711, 711, 0),
       (712, 712, 0),
       (713, 713, 0),
       (714, 714, 0),
       (715, 715, 0),
       (716, 716, 0),
       (717, 717, 0),
       (718, 718, 0),
       (719, 719, 0),
       (720, 720, 0),
       (721, 721, 0),
       (722, 722, 0),
       (723, 723, 0),
       (724, 724, 0),
       (725, 725, 0),
       (726, 726, 0),
       (727, 727, 0),
       (728, 728, 0),
       (729, 729, 0),
       (730, 730, 0),
       (731, 731, 0),
       (732, 732, 0),
       (733, 733, 0),
       (734, 734, 0),
       (735, 735, 0),
       (736, 736, 0),
       (737, 737, 0),
       (738, 738, 0),
       (739, 739, 0),
       (740, 740, 0),
       (741, 741, 0),
       (742, 742, 0),
       (743, 743, 0),
       (744, 744, 0),
       (745, 745, 0),
       (746, 746, 0),
       (747, 747, 0),
       (748, 748, 0),
       (749, 749, 0),
       (750, 750, 0),
       (751, 751, 0),
       (752, 752, 0),
       (753, 753, 0),
       (754, 754, 0),
       (755, 755, 0),
       (756, 756, 0),
       (757, 757, 0),
       (758, 758, 0),
       (759, 759, 0),
       (760, 760, 0),
       (761, 761, 0),
       (762, 762, 0),
       (763, 763, 0),
       (764, 764, 0),
       (765, 765, 0),
       (766, 766, 0),
       (767, 767, 0),
       (768, 768, 0),
       (769, 769, 0),
       (770, 770, 0),
       (771, 771, 0),
       (772, 772, 0),
       (773, 773, 0),
       (774, 774, 0),
       (775, 775, 0),
       (776, 776, 0),
       (777, 777, 0),
       (778, 778, 0),
       (779, 779, 0),
       (780, 780, 0),
       (781, 781, 0),
       (782, 782, 0),
       (783, 783, 0),
       (784, 784, 0),
       (785, 785, 0),
       (786, 786, 0),
       (787, 787, 0),
       (788, 788, 0),
       (789, 789, 0),
       (790, 790, 0),
       (791, 791, 0),
       (792, 792, 0),
       (793, 793, 0),
       (794, 794, 0),
       (795, 795, 0),
       (796, 796, 0),
       (797, 797, 0),
       (798, 798, 0),
       (799, 799, 0),
       (800, 800, 0),
       (801, 801, 0),
       (802, 802, 0),
       (803, 803, 0),
       (804, 804, 0),
       (805, 805, 0),
       (806, 806, 0),
       (807, 807, 0),
       (808, 808, 0),
       (809, 809, 0),
       (810, 810, 0),
       (811, 811, 0),
       (812, 812, 0),
       (813, 813, 0),
       (814, 814, 0),
       (815, 815, 0),
       (816, 816, 0),
       (817, 817, 0),
       (818, 818, 0),
       (819, 819, 0),
       (820, 820, 0),
       (821, 821, 0),
       (822, 822, 0),
       (823, 823, 0),
       (824, 824, 0),
       (825, 825, 0),
       (826, 826, 0),
       (827, 827, 0),
       (828, 828, 0),
       (829, 829, 0),
       (830, 830, 0),
       (831, 831, 0),
       (832, 832, 0),
       (833, 833, 0),
       (834, 834, 0),
       (835, 835, 0),
       (836, 836, 0),
       (837, 837, 0),
       (838, 838, 0),
       (839, 839, 0),
       (840, 840, 0),
       (841, 841, 0),
       (842, 842, 0),
       (843, 843, 0),
       (844, 844, 0),
       (845, 845, 0),
       (846, 846, 0),
       (847, 847, 0),
       (848, 848, 0),
       (849, 849, 0),
       (850, 850, 0),
       (851, 851, 0),
       (852, 852, 0),
       (853, 853, 0),
       (854, 854, 0),
       (855, 855, 0),
       (856, 856, 0),
       (857, 857, 0),
       (858, 858, 0),
       (859, 859, 0),
       (860, 860, 0),
       (861, 861, 0),
       (862, 862, 0),
       (863, 863, 0),
       (864, 864, 0),
       (865, 865, 0),
       (866, 866, 0),
       (867, 867, 0),
       (868, 868, 0),
       (869, 869, 0),
       (870, 870, 0),
       (871, 871, 0),
       (872, 872, 0),
       (873, 873, 0),
       (874, 874, 0),
       (875, 875, 0),
       (876, 876, 0),
       (877, 877, 0),
       (878, 878, 0),
       (879, 879, 0),
       (880, 880, 0),
       (881, 881, 0),
       (882, 882, 0),
       (883, 883, 0),
       (884, 884, 0),
       (885, 885, 0),
       (886, 886, 0),
       (887, 887, 0),
       (888, 888, 0),
       (889, 889, 0),
       (890, 890, 0),
       (891, 891, 0),
       (892, 892, 0),
       (893, 893, 0),
       (894, 894, 0),
       (895, 895, 0),
       (896, 896, 0),
       (897, 897, 0),
       (898, 898, 0),
       (899, 899, 0),
       (900, 900, 0),
       (901, 901, 0),
       (902, 902, 0),
       (903, 903, 0),
       (904, 904, 0),
       (905, 905, 0),
       (906, 906, 0),
       (907, 907, 0),
       (908, 908, 0),
       (909, 909, 0),
       (910, 910, 0),
       (911, 911, 0),
       (912, 912, 0),
       (913, 913, 0),
       (914, 914, 0),
       (915, 915, 0),
       (916, 916, 0),
       (917, 917, 0),
       (918, 918, 0),
       (919, 919, 0),
       (920, 920, 0),
       (921, 921, 0),
       (922, 922, 0),
       (923, 923, 0),
       (924, 924, 0),
       (925, 925, 0),
       (926, 926, 0),
       (927, 927, 0),
       (928, 928, 0),
       (929, 929, 0),
       (930, 930, 0),
       (931, 931, 0),
       (932, 932, 0),
       (933, 933, 0),
       (934, 934, 0),
       (935, 935, 0),
       (936, 936, 0),
       (937, 937, 0),
       (938, 938, 0),
       (939, 939, 0),
       (940, 940, 0),
       (941, 941, 0),
       (942, 942, 0),
       (943, 943, 0),
       (944, 944, 0),
       (945, 945, 0),
       (946, 946, 0),
       (947, 947, 0),
       (948, 948, 0),
       (949, 949, 0),
       (950, 950, 0),
       (951, 951, 0),
       (952, 952, 0),
       (953, 953, 0),
       (954, 954, 0),
       (955, 955, 0),
       (956, 956, 0),
       (957, 957, 0),
       (958, 958, 0),
       (959, 959, 0),
       (960, 960, 0),
       (961, 961, 0),
       (962, 962, 0),
       (963, 963, 0),
       (964, 964, 0),
       (965, 965, 0),
       (966, 966, 0),
       (967, 967, 0),
       (968, 968, 0),
       (969, 969, 0),
       (970, 970, 0),
       (971, 971, 0),
       (972, 972, 0),
       (973, 973, 0),
       (974, 974, 0),
       (975, 975, 0),
       (976, 976, 0),
       (977, 977, 0),
       (978, 978, 0),
       (979, 979, 0),
       (980, 980, 0),
       (981, 981, 0),
       (982, 982, 0),
       (983, 983, 0),
       (984, 984, 0),
       (985, 985, 0),
       (986, 986, 0),
       (987, 987, 0),
       (988, 988, 0),
       (989, 989, 0),
       (990, 990, 0),
       (991, 991, 0),
       (992, 992, 0),
       (993, 993, 0),
       (994, 994, 0),
       (995, 995, 0),
       (996, 996, 0),
       (997, 997, 0),
       (998, 998, 0),
       (999, 999, 0);
INSERT INTO `openrsc_reindexer` (`old_catalogID`, `catalogID`, `noted`)
VALUES (1000, 1000, 0),
       (1001, 1001, 0),
       (1002, 1002, 0),
       (1003, 1003, 0),
       (1004, 1004, 0),
       (1005, 1005, 0),
       (1006, 1006, 0),
       (1007, 1007, 0),
       (1008, 1008, 0),
       (1009, 1009, 0),
       (1010, 1010, 0),
       (1011, 1011, 0),
       (1012, 1012, 0),
       (1013, 1013, 0),
       (1014, 1014, 0),
       (1015, 1015, 0),
       (1016, 1016, 0),
       (1017, 1017, 0),
       (1018, 1018, 0),
       (1019, 1019, 0),
       (1020, 1020, 0),
       (1021, 1021, 0),
       (1022, 1022, 0),
       (1023, 1023, 0),
       (1024, 1024, 0),
       (1025, 1025, 0),
       (1026, 1026, 0),
       (1027, 1027, 0),
       (1028, 1028, 0),
       (1029, 1029, 0),
       (1030, 1030, 0),
       (1031, 1031, 0),
       (1032, 1032, 0),
       (1033, 1033, 0),
       (1034, 1034, 0),
       (1035, 1035, 0),
       (1036, 1036, 0),
       (1037, 1037, 0),
       (1038, 1038, 0),
       (1039, 1039, 0),
       (1040, 1040, 0),
       (1041, 1041, 0),
       (1042, 1042, 0),
       (1043, 1043, 0),
       (1044, 1044, 0),
       (1045, 1045, 0),
       (1046, 1046, 0),
       (1047, 1047, 0),
       (1048, 1048, 0),
       (1049, 1049, 0),
       (1050, 1050, 0),
       (1051, 1051, 0),
       (1052, 1052, 0),
       (1053, 1053, 0),
       (1054, 1054, 0),
       (1055, 1055, 0),
       (1056, 1056, 0),
       (1057, 1057, 0),
       (1058, 1058, 0),
       (1059, 1059, 0),
       (1060, 1060, 0),
       (1061, 1061, 0),
       (1062, 1062, 0),
       (1063, 1063, 0),
       (1064, 1064, 0),
       (1065, 1065, 0),
       (1066, 1066, 0),
       (1067, 1067, 0),
       (1068, 1068, 0),
       (1069, 1069, 0),
       (1070, 1070, 0),
       (1071, 1071, 0),
       (1072, 1072, 0),
       (1073, 1073, 0),
       (1074, 1074, 0),
       (1075, 1075, 0),
       (1076, 1076, 0),
       (1077, 1077, 0),
       (1078, 1078, 0),
       (1079, 1079, 0),
       (1080, 1080, 0),
       (1081, 1081, 0),
       (1082, 1082, 0),
       (1083, 1083, 0),
       (1084, 1084, 0),
       (1085, 1085, 0),
       (1086, 1086, 0),
       (1087, 1087, 0),
       (1088, 1088, 0),
       (1089, 1089, 0),
       (1090, 1090, 0),
       (1091, 1091, 0),
       (1092, 1092, 0),
       (1093, 1093, 0),
       (1094, 1094, 0),
       (1095, 1095, 0),
       (1096, 1096, 0),
       (1097, 1097, 0),
       (1098, 1098, 0),
       (1099, 1099, 0),
       (1100, 1100, 0),
       (1101, 1101, 0),
       (1102, 1102, 0),
       (1103, 1103, 0),
       (1104, 1104, 0),
       (1105, 1105, 0),
       (1106, 1106, 0),
       (1107, 1107, 0),
       (1108, 1108, 0),
       (1109, 1109, 0),
       (1110, 1110, 0),
       (1111, 1111, 0),
       (1112, 1112, 0),
       (1113, 1113, 0),
       (1114, 1114, 0),
       (1115, 1115, 0),
       (1116, 1116, 0),
       (1117, 1117, 0),
       (1118, 1118, 0),
       (1119, 1119, 0),
       (1120, 1120, 0),
       (1121, 1121, 0),
       (1122, 1122, 0),
       (1123, 1123, 0),
       (1124, 1124, 0),
       (1125, 1125, 0),
       (1126, 1126, 0),
       (1127, 1127, 0),
       (1128, 1128, 0),
       (1129, 1129, 0),
       (1130, 1130, 0),
       (1131, 1131, 0),
       (1132, 1132, 0),
       (1133, 1133, 0),
       (1134, 1134, 0),
       (1135, 1135, 0),
       (1136, 1136, 0),
       (1137, 1137, 0),
       (1138, 1138, 0),
       (1139, 1139, 0),
       (1140, 1140, 0),
       (1141, 1141, 0),
       (1142, 1142, 0),
       (1143, 1143, 0),
       (1144, 1144, 0),
       (1145, 1145, 0),
       (1146, 1146, 0),
       (1147, 1147, 0),
       (1148, 1148, 0),
       (1149, 1149, 0),
       (1150, 1150, 0),
       (1151, 1151, 0),
       (1152, 1152, 0),
       (1153, 1153, 0),
       (1154, 1154, 0),
       (1155, 1155, 0),
       (1156, 1156, 0),
       (1157, 1157, 0),
       (1158, 1158, 0),
       (1159, 1159, 0),
       (1160, 1160, 0),
       (1161, 1161, 0),
       (1162, 1162, 0),
       (1163, 1163, 0),
       (1164, 1164, 0),
       (1165, 1165, 0),
       (1166, 1166, 0),
       (1167, 1167, 0),
       (1168, 1168, 0),
       (1169, 1169, 0),
       (1170, 1170, 0),
       (1171, 1171, 0),
       (1172, 1172, 0),
       (1173, 1173, 0),
       (1174, 1174, 0),
       (1175, 1175, 0),
       (1176, 1176, 0),
       (1177, 1177, 0),
       (1178, 1178, 0),
       (1179, 1179, 0),
       (1180, 1180, 0),
       (1181, 1181, 0),
       (1182, 1182, 0),
       (1183, 1183, 0),
       (1184, 1184, 0),
       (1185, 1185, 0),
       (1186, 1186, 0),
       (1187, 1187, 0),
       (1188, 1188, 0),
       (1189, 1189, 0),
       (1190, 1190, 0),
       (1191, 1191, 0),
       (1192, 1192, 0),
       (1193, 1193, 0),
       (1194, 1194, 0),
       (1195, 1195, 0),
       (1196, 1196, 0),
       (1197, 1197, 0),
       (1198, 1198, 0),
       (1199, 1199, 0),
       (1200, 1200, 0),
       (1201, 1201, 0),
       (1202, 1202, 0),
       (1203, 1203, 0),
       (1204, 1204, 0),
       (1205, 1205, 0),
       (1206, 1206, 0),
       (1207, 1207, 0),
       (1208, 1208, 0),
       (1209, 1209, 0),
       (1210, 1210, 0),
       (1211, 1211, 0),
       (1212, 1212, 0),
       (1213, 1213, 0),
       (1214, 1214, 0),
       (1215, 1215, 0),
       (1216, 1216, 0),
       (1217, 1217, 0),
       (1218, 1218, 0),
       (1219, 1219, 0),
       (1220, 1220, 0),
       (1221, 1221, 0),
       (1222, 1222, 0),
       (1223, 1223, 0),
       (1224, 1224, 0),
       (1225, 1225, 0),
       (1226, 1226, 0),
       (1227, 1227, 0),
       (1228, 1228, 0),
       (1229, 1229, 0),
       (1230, 1230, 0),
       (1231, 1231, 0),
       (1232, 1232, 0),
       (1233, 1233, 0),
       (1234, 1234, 0),
       (1235, 1235, 0),
       (1236, 1236, 0),
       (1237, 1237, 0),
       (1238, 1238, 0),
       (1239, 1239, 0),
       (1240, 1240, 0),
       (1241, 1241, 0),
       (1242, 1242, 0),
       (1243, 1243, 0),
       (1244, 1244, 0),
       (1245, 1245, 0),
       (1246, 1246, 0),
       (1247, 1247, 0),
       (1248, 1248, 0),
       (1249, 1249, 0),
       (1250, 1250, 0),
       (1251, 1251, 0),
       (1252, 1252, 0),
       (1253, 1253, 0),
       (1254, 1254, 0),
       (1255, 1255, 0),
       (1256, 1256, 0),
       (1257, 1257, 0),
       (1258, 1258, 0),
       (1259, 1259, 0),
       (1260, 1260, 0),
       (1261, 1261, 0),
       (1262, 1262, 0),
       (1263, 1263, 0),
       (1264, 1264, 0),
       (1265, 1265, 0),
       (1266, 1266, 0),
       (1267, 1267, 0),
       (1268, 1268, 0),
       (1269, 1269, 0),
       (1270, 1270, 0),
       (1271, 1271, 0),
       (1272, 1272, 0),
       (1273, 1273, 0),
       (1274, 1274, 0),
       (1275, 1275, 0),
       (1276, 1276, 0),
       (1277, 1277, 0),
       (1278, 1278, 0),
       (1279, 1279, 0),
       (1280, 1280, 0),
       (1281, 1281, 0),
       (1282, 1282, 0),
       (1283, 1283, 0),
       (1284, 1284, 0),
       (1285, 1285, 0),
       (1286, 1286, 0),
       (1287, 1287, 0),
       (1288, 1288, 0),
       (1289, 1289, 0),
      (2135, 1290, 0),
      (2136, 1291, 0),
      (2137, 1292, 0),
      (2138, 1293, 0),
      (2139, 1294, 0),
      (2140, 1295, 0),
      (2141, 1296, 0),
      (2142, 1297, 0),
      (2143, 1298, 0),
      (2258, 1299, 0),
      (2260, 1300, 0),
      (2262, 1301, 0),
      (2264, 1302, 0),
      (2266, 1303, 0),
      (2268, 1304, 0),
      (2270, 1305, 0),
      (2272, 1306, 0),
      (2274, 1307, 0),
      (2276, 1308, 0),
      (2278, 1309, 0),
      (2280, 1310, 0),
      (2282, 1311, 0),
      (2284, 1312, 0),
      (2285, 1313, 0),
      (2286, 1314, 0),
      (2288, 1315, 0),
      (2290, 1316, 0),
      (2292, 1317, 0),
      (2294, 1318, 0),
      (2296, 1319, 0),
      (2298, 1320, 0),
      (2300, 1321, 0),
      (2302, 1322, 0),
      (2304, 1323, 0),
      (2306, 1324, 0),
      (2308, 1325, 0),
      (2310, 1326, 0),
      (2312, 1327, 0),
      (2314, 1328, 0),
      (2316, 1329, 0),
      (2321, 1330, 0),
      (2323, 1331, 0),
      (2325, 1332, 0),
      (2327, 1333, 0),
      (2329, 1334, 0),
      (2331, 1335, 0),
      (2333, 1336, 0),
      (2335, 1337, 0),
      (2337, 1338, 0),
      (2339, 1339, 0),
      (2341, 1340, 0),
      (2343, 1341, 0),
      (2345, 1342, 0),
      (2347, 1343, 0),
      (2349, 1344, 0),
      (2351, 1345, 0),
      (2353, 1346, 0),
      (2355, 1347, 0),
      (2357, 1348, 0),
      (2359, 1349, 0),
      (2361, 1350, 0),
      (2363, 1351, 0),
      (2365, 1352, 0),
      (2367, 1353, 0),
      (2369, 1354, 0),
      (2371, 1355, 0),
      (2373, 1356, 0),
      (2375, 1357, 0),
      (2377, 1358, 0),
      (2379, 1359, 0),
      (2381, 1360, 0),
      (2383, 1361, 0),
      (2385, 1362, 0),
      (2386, 1363, 0),
      (2387, 1364, 0),
      (2388, 1365, 0),
      (2390, 1366, 0),
      (2391, 1367, 0),
      (2392, 1368, 0),
      (2394, 1369, 0),
      (2395, 1370, 0),
      (2397, 1371, 0),
      (2399, 1372, 0),
      (2105, 1373, 0),
      (2111, 1374, 0),
      (2401, 1375, 0),
      (2402, 1376, 0),
      (2403, 1377, 0),
      (2404, 1378, 0),
      (2406, 1379, 0);

ALTER TABLE `openrsc_itemstatuses` ADD COLUMN `playerID` int(10) UNSIGNED DEFAULT 0;

UPDATE `openrsc_equipped`
JOIN `openrsc_reindexer` ON openrsc_equipped.id = openrsc_reindexer.old_catalogID
SET openrsc_equipped.id = openrsc_reindexer.catalogID
WHERE openrsc_equipped.id = openrsc_reindexer.old_catalogID;

UPDATE `openrsc_auctions`
JOIN `openrsc_reindexer` ON openrsc_auctions.itemID = openrsc_reindexer.old_catalogID
SET openrsc_auctions.itemID = openrsc_reindexer.catalogID
WHERE openrsc_auctions.itemID = openrsc_reindexer.old_catalogID;

DROP TABLE `openrsc_reindexer`;

INSERT INTO `openrsc_itemstatuses` (`catalogID`, `amount`, `playerID`)
SELECT `id`, `amount`, `playerID`
FROM `openrsc_equipped`
WHERE `playerID` > 0;

UPDATE `openrsc_equipped`
JOIN `openrsc_itemstatuses` ON openrsc_equipped.id = openrsc_itemstatuses.catalogID
SET openrsc_equipped.id = openrsc_itemstatuses.itemID
WHERE openrsc_itemstatuses.playerID = openrsc_equipped.playerID;

ALTER TABLE `openrsc_itemstatuses` DROP COLUMN IF EXISTS `playerID`;

ALTER TABLE `openrsc_equipped` CHANGE IF EXISTS `id` `itemID` int(10) UNSIGNED NOT NULL;
ALTER TABLE `openrsc_equipped` DROP COLUMN IF EXISTS `amount`;
ALTER TABLE `openrsc_equipped` DROP COLUMN IF EXISTS `dbid`;

SELECT '2. Truncate bank presets.' AS '';

TRUNCATE `openrsc_bankpresets`;

/*
 * Itemdef additions
 *  Adds custom items to the itemdef table
 */

SELECT '3. Add new item defs.' AS '';

REPLACE INTO `openrsc_itemdef` (`id`, `name`, `description`, `command`, `isFemaleOnly`, `isMembersOnly`, `isStackable`, `isUntradable`, `isWearable`, `appearanceID`, `wearableID`, `wearSlot`, `requiredLevel`, `requiredSkillID`, `armourBonus`, `weaponAimBonus`, `weaponPowerBonus`, `magicBonus`, `prayerBonus`, `basePrice`, `isNoteable`) VALUES
        (1290, 'Ironman helm', 'For just a rather very independent scaper.', '', 0, 0, 0, 1, 1, 318, 33, 0, 1, 1, 6, 0, 0, 0, 0, 154, 1),
        (1291, 'Ironman platebody', 'Take it off and what are you?', '', 0, 0, 0, 1, 1, 319, 322, 1, 1, 1, 20, 0, 0, 0, 0, 560, 1),
        (1292, 'Ironman platelegs', 'Take it off and what are you?', '', 0, 0, 0, 1, 1, 320, 644, 2, 1, 1, 10, 0, 0, 0, 0, 280, 1),
        (1293, 'Ultimate ironman helm', 'For Just A Rather Very Independent Scaper.', '', 0, 0, 0, 1, 1, 321, 33, 0, 1, 1, 6, 0, 0, 0, 0, 154, 1),
        (1294, 'Ultimate ironman platebody', 'Take it off and what are you?', '', 0, 0, 0, 1, 1, 322, 322, 1, 1, 1, 20, 0, 0, 0, 0, 560, 1),
        (1295, 'Ultimate ironman platelegs', 'Take it off and what are you?', '', 0, 0, 0, 1, 1, 323, 644, 2, 1, 1, 10, 0, 0, 0, 0, 280, 1),
        (1296, 'Hardcore ironman helm', 'For those who stand alone.', '', 0, 0, 0, 1, 1, 324, 33, 0, 1, 1, 6, 0, 0, 0, 0, 154, 1),
        (1297, 'Hardcore ironman platebody', 'Take it off and what are you?', '', 0, 0, 0, 1, 1, 325, 322, 1, 1, 1, 20, 0, 0, 0, 0, 560, 1),
        (1298, 'Hardcore ironman platelegs', 'Take it off and what are you?', '', 0, 0, 0, 1, 1, 326, 644, 2, 1, 1, 10, 0, 0, 0, 0, 280, 1),
        (1299, 'Rune essence', 'An uncharged runestone', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1300, 'Air talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1301, 'Mind talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1302, 'Water talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1303, 'Earth talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1304, 'Fire talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1305, 'Body talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1306, 'Cosmic talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1307, 'Chaos talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1308, 'Nature talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1309, 'Law talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1310, 'Death talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1311, 'Blood talisman', 'A mysterious power emanates from this talisman...', 'Locate', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1312, 'Research package', 'This contains some vital research results. bank for the equivalent item.', '', 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
        (1313, 'Research notes', 'These make no sense at all.', '', 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
        (1314, 'Ring of recoil', 'An uncharged ring.', 'Check,Break', 0, 1, 0, 0, 1, 0, 1200, 13, 0, 0, 0, 0, 0, 0, 0, 900, 1),
        (1315, 'Ring of splendor', 'An uncharged ring.', '', 0, 1, 0, 0, 1, 0, 1200, 13, 0, 0, 0, 0, 0, 0, 0, 1275, 1),
        (1316, 'Ring of forging', 'An uncharged ring.', 'Check,Break', 0, 1, 0, 0, 1, 0, 1200, 13, 0, 0, 0, 0, 0, 0, 0, 2025, 1),
        (1317, 'Ring of life', 'An uncharged ring.', '', 0, 1, 0, 0, 1, 0, 1200, 13, 0, 0, 0, 0, 0, 0, 0, 3525, 1),
        (1318, 'Ring of wealth', 'An uncharged ring.', '', 0, 1, 0, 0, 1, 0, 1200, 13, 0, 0, 0, 0, 0, 0, 0, 17625, 1),
        (1319, 'Ring of avarice', 'An uncharged ring.', '', 0, 1, 0, 0, 1, 0, 1200, 13, 0, 0, 0, 0, 0, 0, 0, 17625, 1),
        (1320, 'Dwarven ring', 'An uncharged ring.', 'Check,Break', 0, 1, 0, 0, 1, 0, 1200, 13, 0, 0, 0, 0, 0, 0, 0, 400, 1),
        (1321, 'Opal ring', 'A valuable ring', '', 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 1050, 1),
        (1322, 'White wolf mask', 'Awooo', '', 0, 0, 0, 0, 1, 291, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1323, 'Blood wolf mask', 'Awooo', '', 0, 0, 0, 0, 1, 292, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1324, 'Black wolf mask', 'Awooo', '', 0, 0, 0, 0, 1, 293, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1325, 'Pink wolf mask', 'Awooo', '', 0, 0, 0, 0, 1, 294, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1326, 'White unicorn mask', 'Im so fluffy Im gonne die!!', '', 0, 0, 0, 0, 1, 287, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1327, 'Blood unicorn mask', 'Im so fluffy Im gonne die!!', '', 0, 0, 0, 0, 1, 288, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1328, 'Black unicorn mask', 'Im so fluffy Im gonne die!!', '', 0, 0, 0, 0, 1, 289, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1329, 'Pink unicorn mask', 'Im so fluffy Im gonne die!!', '', 0, 0, 0, 0, 1, 290, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1330, 'Trick or treat cracker', 'Use on another player to pull it', '', 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 1, 1),
        (1331, 'Fox mask', 'Struttin like a fox', '', 0, 0, 0, 0, 1, 387, 32, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1),
        (1332, 'Christmas cape', 'A cape worn on the holidays', '', 0, 0, 0, 0, 1, 395, 2048, 11, 1, 1, 0, 0, 0, 0, 0, 3, 1),
        (1333, 'Santa\'s hat with beard', 'It\'s a santa claus\' hat with a beard!', '', 0, 0, 0, 0, 1, 398, 32, 5, 1, 1, 0, 0, 0, 0, 0, 160, 1),
        (1334, 'Christmas Apron', 'An apron for the festivities', '', 0, 0, 0, 0, 1, 394, 1024, 8, 1, 1, 0, 0, 0, 0, 0, 2, 1),
        (1335, 'Glass of milk', 'A glass of tasty milk', 'drink', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1336, 'Cane cookie', 'A tasty holiday cookie', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1337, 'Star cookie', 'A tasty holiday cookie', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1338, 'Tree cookie', 'A tasty holiday cookie', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1339, 'Santa\'s Gloves', 'These keep Santa\'s hands warm', '', 0, 0, 0, 0, 1, 400, 256, 10, 1, 1, 0, 0, 0, 0, 0, 6, 1),
        (1340, 'Santa\'s Mittens', 'Santa\'s favorite mittens', '', 0, 0, 0, 0, 1, 399, 256, 10, 1, 1, 0, 0, 0, 0, 0, 6, 1),
        (1341, 'Santa\'s suit', 'A suit full of joy', '', 0, 0, 0, 0, 1, 396, 64, 6, 1, 1, 0, 0, 0, 0, 0, 8, 1),
        (1342, 'Santa\'s suit', 'A suit full of joy', '', 0, 0, 0, 0, 1, 397, 644, 2, 1, 1, 0, 0, 0, 0, 0, 8, 1),
        (1343, 'Santa\'s hat', 'It\'s a santa claus\' hat', '', 0, 0, 0, 0, 1, 401, 32, 5, 1, 1, 0, 0, 0, 0, 0, 160, 1),
        (1344, 'Antlers with red-nose', 'Im Rudolph the reindeer!!!', '', 0, 0, 0, 0, 1, 402, 32, 5, 1, 1, 0, 0, 0, 0, 0, 3, 1),
        (1345, 'Beverage glass', 'A glass left after a tasty drink', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1),
        (1346, 'dragon 2-handed Sword', 'A massive sword', '', 0, 0, 0, 0, 1, 403, 8216, 4, 60, 0, 0, 99, 99, 0, 0, 5000000, 1),
        (1347, 'King Black Dragon scale', 'Taken from a monstrous beast', '', 0, 1, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 2500, 1),
        (1348, 'red apple', 'Seems tasty!', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1),
        (1349, 'grapefruit', 'It\'s very fresh', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1350, 'papaya', 'Seems very tasty!', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1351, 'coconut', 'It can be cut up with a machette', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1352, 'Red Cabbage', 'Yuck I don\'t like cabbage', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1),
        (1353, 'Corn', 'Some fresh picked corn', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1354, 'White Pumpkin', 'Wonder how it tastes', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1355, 'Fruit Picker', 'Useful for picking trees better', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 1),
        (1356, 'Hand Shovel', 'This will help get yield from bushes and allotments', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 1),
        (1357, 'Herb Clippers', 'Useful for picking up herbs out there', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 1),
        (1358, 'Watering Can', 'It\'s a watering can', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 1),
        (1359, 'grapefruit slices', 'It\'s very fresh', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1360, 'Diced grapefruit', 'Fresh chunks of grapefruit', 'eat', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1361, 'Half coconut', 'Looks like some great coconut', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1),
        (1362, 'Teddy Body', 'A fluffy teddy body', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0),
        (1363, 'Teddy Head', 'A fluffy teddy head', '', 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0),
        (1364, 'Teddy', 'A fluffy teddy', '', 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0),
        (1365, 'Dragon bar', 'it\'s a bar of dragon metal', '', 0, 1, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 100000, 1),
        (1366, 'Chipped Dragon Scale', 'a piece of dragon scale', '', 0, 1, 1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 500, 0),
        (1367, 'Dragon Metal Chain', 'a loop of dragon metal', '', 0, 1, 1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 1000, 0),
        (1368, 'Dragon Scale Mail', 'a dragon chain mail reinforced with dragon scales', '', 0, 0, 0, 0, 1, 404, 64, 6, 60, 1, 95, 10, 6, 0, 0, 1500000, 1),
        (1369, 'Dwarf Smithy Note', 'Details how to make the Dragon Scale Mail', 'read', 0, 1, 0, 1, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 1, 0),
        (1370, 'Leather chaps', 'They seem like decent protection', '', 0, 0, 0, 0, 1, 426, 644, 2, 1, 1, 4, 0, 0, 0, 0, 14, 1),
        (1371, 'Leather top', 'A stylish leather top', '', 1, 0, 0, 0, 1, 427, 322, 1, 1, 1, 10, 0, 0, 0, 0, 21, 1),
        (1372, 'Leather skirt', 'A ladies skirt made of leather', '', 0, 0, 0, 0, 1, 428, 128, 7, 1, 1, 3, 0, 0, 0, 0, 14, 1),
        (1373, 'Cooking cape', 'The cape worn by the world\'s best chefs', '', 0, 0, 0, 1, 1, 311, 2048, 11, 99, 7, 6, 0, 0, 0, 0, 99000, 0),
        (1374, 'Attack cape', 'The cape worn by masters of attack', '', 0, 0, 0, 1, 1, 315, 2048, 11, 99, 0, 6, 0, 0, 0, 0, 99000, 0),
        (1375, 'Thieving cape', 'The cape worn by masters of thieving', '', 0, 0, 0, 1, 1, 429, 2048, 11, 99, 17, 6, 0, 0, 0, 0, 99000, 0),
        (1376, 'Fletching cape', 'The cape worn by masters of fletching', '', 0, 0, 0, 1, 1, 430, 2048, 11, 99, 9, 6, 0, 0, 0, 0, 99000, 0),
        (1377, 'Mining cape', 'The cape worn by masters of mining', '', 0, 0, 0, 1, 1, 431, 2048, 11, 99, 14, 6, 0, 0, 0, 0, 99000, 0),
        (1378, 'Pestilence Mask', 'You wouldn\'t want to be seen in this! Stay the cabbage home!', '', 0, 0, 0, 0, 1, 432, 32, 5, 1, 1, 0, 0, 0, 0, 0, 0, 1),
        (1379, 'Rubber Chicken Cap', 'Wow. That was some very in-depth research on the chicken or the egg question.', '', 0, 0, 0, 0, 1, 433, 32, 5, 1, 1, 0, 0, 0, 0, 0, 0, 1),
        (1380, 'Fishing cape', 'The cape worn by the best fishermen', '', 0, 0, 0, 1, 1, 310, 2048, 11, 99, 10, 6, 0, 0, 0, 0, 99000, 0),
        (1381, 'Strength cape', 'The cape worn by only the strongest people', '', 0, 0, 0, 1, 1, 385, 2048, 11, 99, 2, 6, 0, 0, 0, 0, 99000, 0),
        (1382, 'Magic cape', 'The cape worn by the most powerful mages', '', 0, 0, 0, 1, 1, 440, 2048, 11, 99, 6, 6, 0, 0, 0, 0, 99000, 0),
        (1383, 'Smithing cape', 'The cape worn by master smiths', '', 0, 0, 0, 1, 1, 384, 2048, 11, 99, 13, 6, 0, 0, 0, 0, 99000, 0),
        (1384, 'Crafting cape', 'The cape worn by master craftworkers', 'Teleport', 0, 0, 0, 1, 1, 441, 2048, 11, 99, 12, 6, 0, 0, 0, 0, 99000, 0);

-- Make arrows wieldable.
UPDATE `openrsc_itemdef` SET `isWearable`=1, `wearableID`=1000, `wearSlot`=12, `requiredLevel`=1, `requiredSkillID`=4 WHERE `id` IN (
    11, 574, 638, 639, 640, 641, 642, 643, 644, 645, 646, 647, 723
);
-- Make bolts wieldable
UPDATE `openrsc_itemdef` SET `isWearable`=1, `wearableID`=1001, `wearSlot`=12, `requiredLevel`=1, `requiredSkillID`=4 WHERE `id` IN (
    190,  592, 786
);

-- Make pickaxes wieldable.
UPDATE `openrsc_itemdef` SET `isWearable`=1, `wearableID`=16, `wearSlot`=4, `requiredLevel`=1, `requiredSkillID`=0, `weaponAimBonus`=0, `weaponPowerBonus`=0 WHERE `id`=156; -- Bronze
UPDATE `openrsc_itemdef` SET `isWearable`=1, `wearableID`=16, `wearSlot`=4, `requiredLevel`=1, `requiredSkillID`=0, `weaponAimBonus`=7, `weaponPowerBonus`=5 WHERE `id`=1258; -- Iron
UPDATE `openrsc_itemdef` SET `isWearable`=1, `wearableID`=16, `wearSlot`=4, `requiredLevel`=5, `requiredSkillID`=0, `weaponAimBonus`=11, `weaponPowerBonus`=8 WHERE `id`=1259; -- Steel
UPDATE `openrsc_itemdef` SET `isWearable`=1, `wearableID`=16, `wearSlot`=4, `requiredLevel`=20, `requiredSkillID`=0, `weaponAimBonus`=16, `weaponPowerBonus`=12 WHERE `id`=1260; -- Mithril
UPDATE `openrsc_itemdef` SET `isWearable`=1, `wearableID`=16, `wearSlot`=4, `requiredLevel`=30, `requiredSkillID`=0, `weaponAimBonus`=23, `weaponPowerBonus`=17 WHERE `id`=1261; -- Adamant
UPDATE `openrsc_itemdef` SET `isWearable`=1, `wearableID`=16, `wearSlot`=4, `requiredLevel`=40, `requiredSkillID`=0, `weaponAimBonus`=36, `weaponPowerBonus`=26 WHERE `id`=1262; -- Rune

-- Custom appearance sprites.
UPDATE `openrsc_itemdef` SET `appearanceID`=(case
    -- Axes
    when id=87 then 230
    when id=12 then 231
    when id=88 then 232
    when id=203 then 233
    when id=204 then 234
    when id=405 then 235
    when id=428 then 236
    -- Kite Shields
    when id=128 then 237
    when id=2 then 238
    when id=129 then 239
    when id=130 then 240
    when id=131 then 241
    when id=404 then 242
    when id=433 then 243
    when id=1278 then 244
    -- Dragon Medium Helmet
    when id=795 then 245
    -- Plated Skirts
    when id=214 then 246
    when id=215 then 247
    when id=225 then 248
    when id=226 then 249
    when id=227 then 250
    when id=406 then 251
    when id=434 then 252
    -- Bows
    when id=188 then 253
    when id=189 then 253
    when id=648 then 254
    when id=649 then 254
    when id=650 then 255
    when id=651 then 255
    when id=652 then 256
    when id=653 then 256
    when id=654 then 257
    when id=655 then 257
    when id=656 then 258
    when id=657 then 258
    -- Short Swords
    when id=66 then 259
    when id=1 then 260
    when id=67 then 261
    when id=68 then 262
    when id=69 then 263
    when id=397 then 264
    when id=424 then 265
    -- Daggers
    when id=62 then 266
    when id=28 then 267
    when id=63 then 268
    when id=64 then 269
    when id=65 then 270
    when id=396 then 271
    when id=423 then 272
    -- Poisoned Daggers
    when id=560 then 273
    when id=559 then 274
    when id=561 then 275
    when id=562 then 276
    when id=563 then 277
    when id=564 then 278
    when id=565 then 279
    -- 2h Swords
    when id=76 then 280
    when id=77 then 281
    when id=78 then 282
    when id=79 then 283
    when id=80 then 284
    when id=81 then 285
    when id=426 then 286
    -- Spears
    when id=1135 then 388
    when id=1136 then 389
    when id=1137 then 390
    when id=1138 then 391
    when id=1139 then 392
    when id=1140 then 393
    -- Necklaces
    when id=289 then 405
    when id=302 then 406
    when id=290 then 407
    when id=303 then 408
    when id=291 then 409
    when id=304 then 410
    when id=292 then 411
    when id=305 then 412
    when id=544 then 413
    when id=597 then 414
    when id=1194 then 415
    when id=852 then 416
    when id=721 then 417
    when id=726 then 418
    when id=782 then 419
    when id=385 then 420
    when id=1028 then 421
	-- Staves
	when id=101 then 422
	when id=102 then 423
	when id=103 then 424
	when id=197 then 425
    -- Battlestaves
    when id=617 then 422
    when id=616 then 423
    when id=618 then 424
    when id=615 then 425
	-- Enchanted Battlestaves
	when id=684 then 422
	when id=683 then 423
	when id=685 then 424
	when id=682 then 425
	-- Pickaxes
	when id=156 then 434
	when id=1258 then 435
	when id=1259 then 436
	when id=1260 then 437
	when id=1261 then 438
	when id=1262 then 439
end) WHERE `id` IN (
    -- Axes
    87, 12, 88, 203, 204, 405, 428,
    -- Kite Shields
    128, 2, 129, 130, 131, 404, 433, 1278,
    -- Dragon Medium Helmet
    795,
    -- Plated Skirts
    214, 215, 225, 226, 227, 406, 434,
    -- Bows
    188, 189, 648, 649, 650, 651, 652, 653, 654, 655, 656, 657,
    -- Short Swords
    66, 1, 67, 68, 69, 397, 424,
    -- Daggers
    62, 28, 63, 64, 65, 396, 423,
    -- Poisoned Daggers
    560, 559, 561, 562, 563, 564, 565,
    -- 2h Swords
    76, 77, 78, 79, 80, 81, 426,
    -- Spears
    1135, 1136, 1137, 1138, 1139, 1140,
    -- Necklaces
    289, 302, 290, 303, 291, 304, 292, 305, 544, 597, 1194, 852, 721, 726, 782, 385, 1028,
	-- Staves
	101, 102, 103, 197,
    -- Battlestaves
    617, 616, 618, 615,
	-- Enchanted Battlestaves
	684, 683, 685, 682,
    -- Pickaxes
    156, 1258, 1259, 1260, 1261, 1262
);



SELECT '4. Add new npc defs.' AS '';

REPLACE INTO `openrsc_npcdef` (`id`, `name`, `description`, `command`, `command2`, `attack`, `strength`, `hits`, `defense`, `ranged`, `combatlvl`, `isMembers`, `attackable`, `aggressive`, `respawnTime`, `sprites1`, `sprites2`, `sprites3`, `sprites4`, `sprites5`, `sprites6`, `sprites7`, `sprites8`, `sprites9`, `sprites10`, `sprites11`, `sprites12`, `hairColour`, `topColour`, `bottomColour`, `skinColour`, `camera1`, `camera2`, `walkModel`, `combatModel`, `combatSprite`, `canEdit`, `roundMode`) VALUES
        (794, 'Auctioneer', 'He gives access to auction house', 'Auction', '', 15, 16, 12, 18, NULL, 15, 0, 0, 0, 30, 0, 1, 2, -1, -1, -1, -1, -1, 46, -1, -1, -1, 16761440, 2, 8409120, 13415270, 145, 230, 6, 6, 5, 0, 0),
        (795, 'Auction Clerk', 'There to help me make my auctions', 'Auction', 'Teleport', 15, 16, 12, 18, NULL, 15, 0, 0, 0, 30, 3, 4, 2, -1, -1, -1, -1, -1, -1, 11, -1, -1, 11167296, 11141375, 11141375, 14415270, 145, 220, 6, 6, 5, 0, 0),
        (796, 'Subscription Vendor', 'Exchange your subscription token to subscription time', '', '', 15, 16, 12, 18, NULL, 15, 0, 0, 0, 30, 3, 4, 2, -1, -1, 77, -1, -1, -1, -1, -1, -1, 16711680, 143190, 143190, 15523536, 145, 220, 6, 6, 5, 0, 0),
        (797, 'Subscription Vendor', 'Exchange your subscription token to subscription time', '', '', 15, 16, 12, 18, NULL, 15, 0, 0, 0, 30, 0, 1, 2, -1, -1, 77, -1, -1, -1, -1, -1, -1, 16711680, 143190, 143190, 15523536, 145, 230, 6, 6, 5, 0, 0),
        (798, 'Gaia', 'The earth queen with a rotten heart', '', '', 78, 79, 79, 80, NULL, 79, 0, 1, 1, 30, 241, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 275, 262, 11, 11, 30, 0, 0),
        (799, 'Iron Man', 'An Iron Man', 'Armour', '', 0, 0, 0, 0, NULL, 0, 0, 0, 0, 45, 0, 319, 320, -1, -1, -1, -1, -1, -1, -1, -1, -1, 6751590, 0, 14, 13415270, 145, 220, 6, 6, 5, 1, 0),
        (800, 'Ultimate Iron Man', 'An Ultimate Iron Man', 'Armour', '', 0, 0, 0, 0, NULL, 0, 0, 0, 0, 45, 0, 322, 323, -1, -1, -1, -1, -1, -1, -1, -1, -1, 11167296, 8, 14, 13415270, 145, 220, 6, 6, 5, 1, 0),
        (801, 'Hardcore Iron Man', 'A Hardcore Iron Man', 'Armour', '', 0, 0, 0, 0, NULL, 0, 0, 0, 0, 45, 324, 325, 326, -1, -1, -1, -1, -1, -1, -1, -1, -1, 11167296, 8, 14, 13415270, 145, 220, 6, 6, 5, 1, 0),
        (802, 'Greatwood', 'A scary hard slamming tree', '', '', 255, 245, 400, 300, NULL, 300, 0, 1, 1, 30, 309, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 345, 410, 11, 11, 30, 0, 0),
        (803, 'Wizard Sedridor', 'An old wizard', 'teleport', '', 0, 0, 0, 0, NULL, 0, 0, 0, 0, 30, 6, 1, 2, -1, -1, 77, 76, 81, -1, -1, -1, -1, 14535816, 255, 255, 15523536, 145, 220, 6, 6, 5, 0, 0),
        (804, 'Scot Ruth', 'A smelly, dirty dwarf', '', '', 20, 17, 16, 20, NULL, 18, 1, 0, 0, 30, 6, 1, 2, -1, -1, -1, 45, -1, -1, -1, -1, 63, 7360576, 3158064, 3158064, 15523536, 121, 176, 6, 6, 5, 0, 0),
        (805, 'Gardener', 'She takes care of the plants around', '', '', 25, 25, 10, 20, NULL, 20, 0, 0, 0, 30, 3, 4, 2, -1, -1, -1, -1, 87, -1, -1, -1, -1, 16753488, 5286432, 10510400, 13415270, 125, 225, 6, 6, 5, 0, 0),
        (806, 'Gramat', 'He looks worried', '', '', 20, 17, 16, 20, NULL, 18, 0, 0, 0, 30, 6, 1, 2, -1, -1, -1, 45, -1, -1, -1, -1, -1, 7360576, 9465888, 13393952, 15523536, 121, 176, 6, 6, 5, 0, 0),
        (807, 'Dwarven Smithy', 'A master of metals', '', '', 20, 17, 16, 20, NULL, 18, 0, 0, 0, 30, 6, 1, 2, -1, -1, -1, 45, -1, -1, -1, -1, -1, 7360576, 9465888, 13393952, 15523536, 121, 176, 6, 6, 5, 0, 0),
        (808, 'Dwarven Youth', 'He is upset', '', '', 20, 17, 16, 20, NULL, 18, 0, 0, 0, 30, 6, 1, 2, -1, -1, -1, 45, -1, -1, -1, -1, -1, 7360576, 9465888, 13393952, 15523536, 121, 176, 6, 6, 5, 0, 0),
        (809, 'Balrog', 'A massive black demon', '', '', 999, 250, 500, 80, NULL, 217, 1, 1, 1, 73, 164, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0, 358, 341, 11, 11, 30, 0, -1),
        (810, 'Silicius', 'A Peaceful monk', '', '', 12, 13, 15, 12, NULL, 13, 1, 0, 0, 30, 6, 1, 2, -1, -1, -1, 83, 87, -1, -1, -1, -1, 16761440, 65535, 255, 15523536, 145, 220, 6, 6, 5, 0, 0),
        (811, 'Robin Banks', 'A master thief', '', '', 34, 32, 37, 33, NULL, 34, 1, 0, 0, 61, 6, 1, 2, -1, 50, -1, 45, -1, 46, -1, -1, -1, 1, 2, 3, 15523536, 150, 230, 6, 6, 5, 0, -1);

DELETE FROM `openrsc_npcdef` WHERE id = 812;


REPLACE INTO `openrsc_npcdrops` (`npcdef_id`, `amount`, `id`, `weight`, `db_index`) VALUES
        (236, '1', 10, 100, 15011),
        (236, '1', 165, 50, 15012),
        (236, '1', 383, 30, 15013),
        (236, '2', 383, 20, 15014),
        (236, '3', 383, 10, 15015),
        (236, '2', 41, 30, 15016),
        (236, '1', 42, 25, 15017),
        (236, '3', 40, 20, 15056),
        (236, '20', 32, 30, 15057),
        (236, '8', 36, 40, 15058),
        (236, '1', 535, 5, 15059),
        (236, '1', 109, 15, 15060),
        (236, '1', 72, 20, 15061),
        (236, '3', 35, 50, 15062),
        (238, '1', 10, 100, 16011),
        (238, '1', 165, 50, 16012),
        (238, '1', 383, 30, 16013),
        (238, '2', 383, 20, 16014),
        (238, '3', 383, 10, 16015),
        (238, '2', 41, 30, 16016),
        (238, '1', 42, 25, 16017),
        (238, '3', 40, 20, 16056),
        (238, '20', 32, 30, 16057),
        (238, '8', 36, 40, 16058),
        (238, '1', 535, 5, 16059),
        (238, '1', 109, 15, 16060),
        (238, '1', 72, 20, 16061),
        (238, '3', 35, 50, 16062),
        (294, '1', 1306, 1, 16112),
        (294, '-1', -1, 49, 16113),
        (318, '1', 1300, 50, 16067),
        (421, '1', 10, 1000, 15094),
        (421, '-1', -1, 2500, 15095),
        (421, '1', 469, 500, 15096),
        (421, '1', 220, 350, 15097),
        (421, '1', 827, 400, 15098),
        (421, '2', 827, 300, 15099),
        (421, '2', 40, 300, 15100),
        (421, '1', 690, 200, 15101),
        (421, '1', 165, 400, 15102),
        (421, '4', 592, 150, 15103),
        (421, '5', 574, 150, 15104),
        (421, '1', 1090, 180, 15105),
        (421, '1', 570, 250, 15106),
        (421, '1', 1088, 300, 15107),
        (421, '1', 569, 200, 15108),
        (421, '1', 1308, 150, 16108),
        (594, '1', 1307, 400, 16105),
        (594, '1', 1308, 250, 16109),
        (311, '1', 1307, 1000, 16098),
        (311, '1', 1308, 1000, 16099),
        (46, '1', 1304, 7500, 16904),
        (57, '1', 1300, 300, 16082),
        (57, '1', 1301, 280, 16083),
        (57, '1', 1302, 335, 16084),
        (57, '1', 1303, 335, 16085),
        (57, '1', 1304, 150, 16086),
        (57, '1', 1305, 150, 16087),
        (60, '1', 1300, 400, 16088),
        (60, '1', 1301, 400, 16089),
        (60, '1', 1302, 550, 16090),
        (60, '1', 1303, 550, 16091),
        (60, '1', 1304, 450, 16092),
        (60, '1', 1305, 450, 16093),
        (61, '1', 1305, 200, 16070),
        (195, '1', 1307, 5770, 16100),
        (787, '1', 1307, 1500, 16102),
        (11, '1', 1303, 356, 16065),
        (81, '1', 1300, 200, 16075),
        (81, '1', 1301, 200, 16076),
        (81, '1', 1302, 150, 16077),
        (81, '1', 1303, 150, 16078),
        (81, '1', 1304, 100, 16079),
        (81, '1', 1305, 100, 16080),
        (158, '1', 1307, 858, 16101),
        (100, '1', 1304, 130, 16071),
        (100, '1', 1305, 243, 16072),
        (45, '1', 1304, 5500, 16095),
        (45, '1', 1307, 2240, 16115),
        (555, '1', 1308, 200, 16110),
        (104, '1', 1307, 350, 16104),
        (65, '1', 1305, 250, 16068),
        (65, '1', 1304, 150, 16069),
        (86, '1', 1303, 370, 16066),
        (67, '1', 1307, 112, 16096),
        (67, '1', 1308, 100, 16097),
        (190, '1', 1307, 1000, 16107),
        (22, '1', 1307, 300, 16103),
        (114, '1', 1301, 300, 16064),
        (270, '1', 1308, 50, 16111),
        (567, '1', 165, 1000, 13927),
        (321, '1', 1304, 1, 16073),
        (321, '1', 1305, 2, 16074),
        (344, '1', 1307, 500, 16106),
        (290, '1', 1306, 900, 16114),
        (809, '1', 1363, 0, 16905);


REPLACE INTO `openrsc_npclocs` (`id`, `startX`, `minX`, `maxX`, `startY`, `minY`, `maxY`, `dbid`) VALUES
        (795, 441, 440, 442, 494, 493, 495, 7568),
        (795, 501, 500, 502, 451, 450, 452, 7569),
        (795, 552, 551, 553, 610, 609, 611, 7570),
        (795, 582, 581, 583, 574, 573, 575, 7571),
        (795, 713, 712, 714, 1450, 1449, 1451, 7572),
        (795, 402, 401, 403, 853, 852, 854, 7573),
        (795, 174, 173, 175, 3527, 3526, 3528, 7574),
        (795, 588, 587, 589, 756, 755, 757, 7575),
        (795, 445, 444, 446, 3370, 3369, 3371, 7578),
        (804, 220, 219, 222, 3281, 3279, 3283, 7579),
        (805, 130, 124, 136, 466, 460, 472, 7580),
        (805, 293, 288, 298, 539, 534, 544, 7581),
        (805, 600, 595, 605, 603, 598, 608, 7582),
        (805, 632, 629, 635, 757, 754, 760, 7583),
        (805, 551, 547, 555, 486, 482, 490, 7584),
        (805, 467, 462, 472, 455, 450, 460, 7585),
        (805, 512, 508, 516, 545, 541, 549, 7586),
        (805, 131, 125, 137, 493, 487, 499, 7587),
        (805, 122, 119, 125, 655, 652, 658, 7588),
        (806, 279, 277, 284, 487, 485, 489, 7589),
        (807, 321, 321, 321, 3423, 3423, 3423, 7590),
        (808, 313, 312, 314, 3431, 3429, 3434, 7591),
        (343, 291, 290, 306, 3444, 3443, 3449, 7592),
        (343, 291, 291, 306, 3445, 3443, 3449, 7593),
        (343, 291, 291, 306, 3446, 3443, 3449, 7594),
        (343, 291, 290, 306, 3446, 3443, 3449, 7595),
        (343, 293, 290, 306, 3446, 3443, 3449, 7596),
        (343, 294, 290, 306, 3446, 3443, 3449, 7597),
        (184, 289, 289, 292, 3430, 3430, 3438, 7598),
        (184, 290, 289, 292, 3430, 3430, 3438, 7599),
        (292, 295, 295, 304, 3428, 3428, 3431, 7600),
        (292, 296, 295, 304, 3428, 3428, 3431, 7601),
        (292, 297, 295, 304, 3428, 3428, 3431, 7602),
        (292, 298, 295, 304, 3428, 3428, 3431, 7603),
        (292, 299, 295, 304, 3428, 3428, 3431, 7604),
        (290, 293, 290, 303, 3417, 3414, 3419, 7605),
        (290, 294, 290, 303, 3417, 3414, 3419, 7606),
        (290, 295, 290, 303, 3417, 3414, 3419, 7607),
        (290, 300, 290, 303, 3414, 3414, 3419, 7608),
        (809, 314, 314, 314, 3422, 3422, 3422, 7609),
        (810, 419, 418, 421, 562, 561, 563, 7610),
        (811, 615, 613, 618, 3496, 3494, 3498, 7611);

DELETE FROM `openrsc_npclocs` WHERE dbid = 7576;
DELETE FROM `openrsc_npclocs` WHERE dbid = 7577;
DELETE FROM `openrsc_npclocs` WHERE dbid = 7612;


REPLACE INTO `openrsc_grounditems` (`id`, `x`, `y`, `amount`, `respawn`, `idx`)
VALUES (1362, 309, 3429, 1, 95, 1117),
       (20, 692, 686, 1, 60, 1118),
       (20, 696, 684, 1, 60, 1119),
       (20, 694, 684, 1, 60, 1120),
       (20, 695, 683, 1, 60, 1121),
       (20, 695, 681, 1, 60, 1122),
       (20, 698, 683, 1, 60, 1123),
       (20, 700, 681, 1, 60, 1124),
       (412, 694, 680, 1, 60, 1125),
       (568, 698, 687, 1, 120, 1126);
