DELETE FROM custom_npc WHERE id=555;
DELETE FROM custom_npcaidata WHERE npcId=555;
DELETE FROM custom_spawnlist WHERE npc_templateid=555;
REPLACE custom_npc SELECT * FROM npc WHERE id=18544;
REPLACE custom_npcaidata SELECT * FROM npcaidata WHERE npcId=18544;
UPDATE IGNORE custom_npc SET id=555,serverSidename=1,name='Buffer',serverSideTitle=1,title='Rin4a''s Custom',type='L2Npc' WHERE id=18544;
UPDATE IGNORE custom_npcaidata SET npcId=555,canMove=0 WHERE npcId=18544;
INSERT INTO custom_spawnlist SET location='giran',count=1,npc_templateid=555,locx=81078,locy=147827,locz=-3469,respawn_delay=60;

DROP TABLE IF EXISTS `Rin4aBuf_buff_list`;
-- DROP TABLE IF EXISTS `Rin4aBuf_scheme_contents`;
-- DROP TABLE IF EXISTS `Rin4aBuf_scheme_list`;

CREATE TABLE `Rin4aBuf_buff_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `buff_class` int(2) DEFAULT NULL,
  `buffType` varchar(10) DEFAULT NULL,
  `buffId` int(5) DEFAULT '0',
  `buffLevel` int(5) DEFAULT NULL,
  `forClass` tinyint(1) DEFAULT NULL,
  `canUse` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=136;
CREATE TABLE IF NOT EXISTS `Rin4aBuf_scheme_contents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `scheme_id` int(11) DEFAULT NULL,
  `skill_id` int(8) DEFAULT NULL,
  `skill_level` int(4) DEFAULT NULL,
  `buff_class` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=30;
CREATE TABLE IF NOT EXISTS `Rin4aBuf_scheme_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` varchar(40) DEFAULT NULL,
  `scheme_name` varchar(36) DEFAULT NULL,
  `mod_accepted` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=7;

INSERT INTO `Rin4aBuf_buff_list` VALUES ('1', '0', 'buff', '1036', '2', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('2', '0', 'buff', '1040', '3', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('3', '0', 'buff', '1043', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('4', '0', 'buff', '1044', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('5', '0', 'buff', '1045', '6', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('6', '0', 'buff', '1047', '4', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('7', '0', 'buff', '1048', '6', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('8', '0', 'buff', '1059', '3', '1', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('9', '0', 'buff', '1068', '3', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('10', '0', 'buff', '1077', '3', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('11', '0', 'buff', '1085', '3', '1', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('12', '0', 'buff', '1086', '2', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('13', '0', 'buff', '1087', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('14', '0', 'buff', '1204', '2', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('15', '0', 'buff', '1240', '3', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('16', '0', 'buff', '1242', '3', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('17', '0', 'buff', '1243', '6', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('18', '0', 'buff', '1257', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('19', '0', 'buff', '1268', '4', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('20', '0', 'buff', '1303', '2', '1', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('21', '0', 'buff', '1304', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('22', '0', 'buff', '1307', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('23', '0', 'buff', '1311', '6', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('24', '0', 'buff', '1397', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('25', '0', 'buff', '1460', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('26', '0', 'buff', '1232', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('27', '0', 'buff', '1238', '3', '3', '0');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('28', '0', 'special', '1323', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('29', '0', 'special', '1388', '3', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('30', '0', 'special', '1389', '3', '1', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('31', '1', 'song', '264', '1', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('32', '1', 'song', '265', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('33', '1', 'song', '266', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('34', '1', 'song', '267', '1', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('35', '1', 'song', '268', '1', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('36', '1', 'song', '269', '1', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('37', '1', 'song', '270', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('38', '1', 'song', '304', '1', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('39', '1', 'song', '305', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('40', '1', 'song', '306', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('41', '1', 'song', '308', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('42', '1', 'song', '349', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('43', '1', 'song', '363', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('44', '1', 'song', '364', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('45', '1', 'song', '529', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('46', '1', 'song', '764', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('47', '1', 'song', '914', '1', '3', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('48', '2', 'dance', '271', '1', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('49', '2', 'dance', '272', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('50', '2', 'dance', '273', '1', '1', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('51', '2', 'dance', '274', '1', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('52', '2', 'dance', '275', '1', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('53', '2', 'dance', '276', '1', '1', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('54', '2', 'dance', '277', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('55', '2', 'dance', '307', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('56', '2', 'dance', '309', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('57', '2', 'dance', '310', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('58', '2', 'dance', '311', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('59', '2', 'dance', '365', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('60', '2', 'dance', '366', '1', '3', '0');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('61', '2', 'dance', '530', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('62', '2', 'dance', '765', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('63', '2', 'dance', '915', '1', '3', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('64', '3', 'resist', '1461', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('65', '3', 'chant', '1002', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('66', '3', 'chant', '1006', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('67', '3', 'chant', '1007', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('68', '3', 'chant', '1009', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('69', '3', 'chant', '1251', '2', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('70', '3', 'chant', '1252', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('71', '3', 'chant', '1253', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('72', '3', 'chant', '1284', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('73', '3', 'chant', '1308', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('74', '3', 'chant', '1309', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('75', '3', 'chant', '1310', '4', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('76', '3', 'chant', '1362', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('77', '3', 'special', '1499', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('78', '3', 'special', '1500', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('79', '3', 'special', '1501', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('80', '3', 'special', '1502', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('81', '3', 'special', '1503', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('82', '3', 'special', '1504', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('83', '3', 'special', '1519', '1', '3', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('84', '4', 'others', '825', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('85', '4', 'others', '826', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('86', '4', 'others', '827', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('87', '4', 'others', '828', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('88', '4', 'others', '829', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('89', '4', 'others', '830', '1', '3', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('90', '5', 'others', '834', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('91', '5', 'others', '1442', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('92', '5', 'others', '1443', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('93', '5', 'others', '1444', '1', '3', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('94', '6', 'cubic', '67', '7', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('95', '6', 'cubic', '10', '8', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('96', '6', 'cubic', '22', '7', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('97', '6', 'cubic', '33', '8', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('98', '6', 'cubic', '278', '6', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('99', '6', 'cubic', '449', '4', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('100', '6', 'cubic', '1279', '9', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('101', '6', 'cubic', '1280', '9', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('102', '6', 'cubic', '1281', '9', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('103', '6', 'cubic', '1328', '8', '3', '0');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('104', '6', 'cubic', '1329', '9', '3', '0');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('105', '6', 'cubic', '1330', '8', '3', '0');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('106', '6', 'cubic', '779', '1', '3', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('107', '7', 'special', '1062', '2', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('108', '7', 'special', '1355', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('109', '7', 'special', '1356', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('110', '7', 'special', '1357', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('111', '7', 'special', '1363', '1', '0', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('112', '7', 'special', '1413', '1', '1', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('114', '7', 'special', '1457', '1', '3', '0');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('115', '7', 'special', '4699', '13', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('116', '7', 'special', '4700', '13', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('117', '7', 'special', '4702', '13', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('118', '7', 'special', '4703', '13', '3', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('119', '8', 'resist', '1032', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('120', '8', 'resist', '1033', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('121', '8', 'resist', '1035', '4', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('122', '8', 'resist', '1078', '6', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('123', '8', 'resist', '1182', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('124', '8', 'resist', '1189', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('125', '8', 'resist', '1191', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('126', '8', 'resist', '1259', '4', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('127', '8', 'resist', '1352', '1', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('128', '8', 'resist', '1353', '1', '2', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('129', '8', 'resist', '1354', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('130', '8', 'resist', '1392', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('131', '8', 'resist', '1393', '3', '3', '1');

INSERT INTO `Rin4aBuf_buff_list` VALUES ('132', '8', 'overlord', '1003', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('133', '8', 'overlord', '1004', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('134', '8', 'overlord', '1005', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('135', '8', 'overlord', '1008', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('136', '8', 'overlord', '1249', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('137', '8', 'overlord', '1250', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('138', '8', 'overlord', '1260', '3', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('139', '8', 'overlord', '1261', '2', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('140', '8', 'overlord', '1282', '2', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('141', '8', 'overlord', '1364', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('142', '8', 'overlord', '1365', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('143', '8', 'overlord', '1415', '1', '3', '1');
INSERT INTO `Rin4aBuf_buff_list` VALUES ('144', '8', 'overlord', '1416', '1', '3', '1');