RKtBNdtt

1/*
2MySQL Data Transfer
3Source Host: localhost
4Source Database: l2j
5Target Host: localhost
6Target Database: l2j
7Date: 11/15/2017 2:52:24 PM
8*/
9
10SET FOREIGN_KEY_CHECKS=0;
11-- ----------------------------
12-- Table structure for npc_to_pc_polymorph
13-- ----------------------------
14DROP TABLE IF EXISTS `npc_to_pc_polymorph`;
15CREATE TABLE `npc_to_pc_polymorph` (
16  `spawn` int(9) NOT NULL DEFAULT '0',
17  `template` int(9) NOT NULL DEFAULT '0',
18  `name` varchar(35) DEFAULT NULL,
19  `title` varchar(35) DEFAULT NULL,
20  `class_id` int(3) NOT NULL DEFAULT '0',
21  `female` int(1) NOT NULL DEFAULT '0',
22  `hair_style` int(1) NOT NULL DEFAULT '0',
23  `hair_color` int(1) NOT NULL DEFAULT '0',
24  `face` int(1) NOT NULL DEFAULT '0',
25  `name_color` int(7) NOT NULL DEFAULT '0',
26  `title_color` int(7) NOT NULL DEFAULT '0',
27  `noble` int(1) NOT NULL DEFAULT '0',
28  `hero` int(1) NOT NULL DEFAULT '0',
29  `pvp` int(1) NOT NULL DEFAULT '0',
30  `karma` int(7) NOT NULL DEFAULT '0',
31  `wpn_enchant` int(7) NOT NULL DEFAULT '0',
32  `right_hand` int(7) NOT NULL DEFAULT '0',
33  `left_hand` int(7) NOT NULL DEFAULT '0',
34  `gloves` int(7) NOT NULL DEFAULT '0',
35  `chest` int(7) NOT NULL DEFAULT '0',
36  `legs` int(7) NOT NULL DEFAULT '0',
37  `feet` int(7) NOT NULL DEFAULT '0',
38  `hair` int(7) NOT NULL DEFAULT '0',
39  `hair2` int(7) NOT NULL DEFAULT '0',
40  `pledge` int(2) NOT NULL DEFAULT '0',
41  `cw_level` int(3) NOT NULL DEFAULT '0',
42  `clan_id` int(9) NOT NULL DEFAULT '0',
43  `ally_id` int(9) NOT NULL DEFAULT '0',
44  `clan_crest` int(9) NOT NULL DEFAULT '0',
45  `ally_crest` int(9) NOT NULL DEFAULT '0',
46  `rnd_class` int(1) NOT NULL DEFAULT '0',
47  `rnd_appearance` int(1) NOT NULL DEFAULT '0',
48  `rnd_weapon` int(1) NOT NULL DEFAULT '0',
49  `rnd_armor` int(1) NOT NULL DEFAULT '0',
50  `max_rnd_enchant` int(7) NOT NULL DEFAULT '0',
51  KEY `spawn` (`spawn`),
52  KEY `template` (`template`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8;
54
55-- ----------------------------
56-- Records 
57-- ----------------------------
58INSERT INTO `npc_to_pc_polymorph` VALUES ('4512143', '0', 'Test', 'Test', '1', '0', '1', '1', '1', '1', '1', '1', '1', '500', '0', '25', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');