· 7 years ago · Dec 14, 2018, 11:36 PM
1CREATE TABLE IF NOT EXISTS `pcharstats` (
2 `CharID` int(10) unsigned NOT NULL default '0',
3 `Strength` smallint(5) unsigned default '0',
4 `Constitution` smallint(5) unsigned default '0',
5 `Agility` smallint(5) unsigned default '0',
6 `Mind` smallint(5) unsigned default '0',
7 `Perception` smallint(5) unsigned default '0',
8 `AttackRating` smallint(5) unsigned default '0',
9 `DefenseRating` smallint(5) unsigned default '0',
10 `BaseDamage` smallint(5) unsigned default '0',
11 `MaxHP` smallint(5) unsigned default '0',
12 `CurrHP` smallint(5) unsigned default '0',
13 `MaxChi` smallint(5) unsigned default '0',
14 `CurrChi` smallint(5) unsigned default '0',
15 `HPRegen` smallint(5) unsigned default '0',
16 `ChiRegen` smallint(5) unsigned default '0',
17 `FireResist` smallint(6) default '0',
18 `ColdResist` smallint(6) default '0',
19 `PoisonResist` smallint(6) default '0',
20 `LightningResist` smallint(6) default '0',
21 `PhysicalResist` smallint(6) default '0',
22 `MovementMode` tinyint(3) unsigned default '0',
23 `Experience` bigint(10) unsigned default '0',
24 `Level` smallint(5) unsigned default '0',
25 `CharGold` int(10) unsigned NOT NULL default '0',
26 `StashGold` int(10) unsigned NOT NULL default '0',
27 `Prestige` smallint(6) default '0',
28 `AttributePoints` smallint(5) unsigned default '0',
29 `StancePoints` smallint(5) unsigned default '0',
30 `PowerPoints` smallint(5) unsigned default '0',
31 `SkillPoints` smallint(5) unsigned default '0',
32 `EntityState` tinyint(3) unsigned default '0',
33 `ActiveWeapon` int(10) unsigned default '0',
34 `ActiveWeaponSlot` tinyint(3) unsigned default '0',
35 `AttackMode` tinyint(3) unsigned default '0',
36 `ElementalAdv` tinyint(3) unsigned default '0',
37 `Gender` tinyint(3) unsigned default '0',
38 `MinUnarmedDamage` tinyint(3) unsigned default '0',
39 `MaxUnarmedDamage` tinyint(3) unsigned default '0',
40 `ClanID` int(10) unsigned default '0',
41 `Job` smallint(5) unsigned default '0',
42 `ElderBrotherID` int(10) unsigned default '0',
43 `PartyID` int(10) unsigned default '0',
44 `TaskChainTag` int(10) unsigned default '0',
45 `ChainStringID` smallint(5) unsigned default '0',
46 `XPPool` int(10) unsigned NOT NULL default '0',
47 `ClanQuit` tinyint(3) unsigned default '0',
48 `LastKillerID` int(10) unsigned default '0',
49 `DuelScore` int(10) unsigned default '0',
50 `LastDuelID` int(10) unsigned default '0',
51 `DuelsWon` smallint(5) unsigned default '0',
52 `DuelsLost` smallint(5) unsigned default '0',
53 `DuelsOffered` smallint(5) unsigned default '0',
54 `DuelsRefused` smallint(5) unsigned default '0',
55 `DuelsInterrupted` smallint(5) unsigned default '0',
56 `NPCKilled` int(10) unsigned default '0',
57 `PCKilled` int(10) unsigned default '0',
58 `PCResus` int(10) unsigned default '0',
59 `RelicStolen` int(10) unsigned default '0',
60 `RelicReturned` int(10) unsigned default '0',
61 `GuildID` int(10) unsigned default '0',
62 `RedPoints` int(10) unsigned default '0',
63 `GreenPoints` int(10) unsigned default '0',
64 `HeroPoints` int(10) unsigned default '0',
65 `WarEventID` int(10) unsigned default '0',
66 `NumChainPowers` tinyint(3) unsigned default '0',
67 `ReadyWeapon` int(10) unsigned default '0',
68 `PKWarning` int(10) unsigned default '0',
69 `WaitPeriod` int(10) unsigned default '0',
70 `ReSpecPoints` tinyint(3) unsigned default '0',
71 `LastResTime` int(10) unsigned default '0',
72 `TeamID` int(10) unsigned default '0',
73 `HeroCount` tinyint(3) unsigned default '0',
74 `LastHeroReset` int(10) unsigned default '0',
75 `MulPerc` int(10) unsigned NOT NULL default '100',
76 PRIMARY KEY (`CharID`)
77) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`pcharstats_0`,`pcharstats_1`,`pcharstats_2`,`pcharstats_3`,`pcharstats_4`,`pcharstats_5`,`pcharstats_6`,`pcharstats_7`,`pcharstats_8`,`pcharstats_9`);