· 8 years ago · Mar 13, 2018, 07:22 AM
1DROP TABLE IF EXISTS `characters`;
2
3CREATE TABLE `characters` (
4 `character_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
5 `account_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
6 `galaxy_id` int(5) unsigned NOT NULL DEFAULT '0',
7 `firstname` varchar(15) NOT NULL DEFAULT '',
8 `surname` varchar(20) DEFAULT NULL,
9 `appearance` mediumtext NOT NULL,
10 `professions` varbinary(110) NOT NULL,
11 `race` tinyint(2) NOT NULL DEFAULT '0',
12 `gender` tinyint(1) NOT NULL DEFAULT '0',
13 `lots` int(2) NOT NULL DEFAULT '10',
14 `credits_inv` int(11) unsigned DEFAULT '10000',
15 `credits_bank` int(11) unsigned DEFAULT '0',
16 `guild` smallint(5) NOT NULL,
17 `x` float(10,6) DEFAULT NULL,
18 `y` float(10,6) DEFAULT NULL,
19 `z` float(10,6) DEFAULT NULL,
20 `zoneid` int(10) DEFAULT NULL,
21 `planet_id` int(2) DEFAULT NULL,
22 `lfg` tinyint(1) DEFAULT '0',
23 `helper` tinyint(1) DEFAULT '0',
24 `roleplayer` tinyint(1) DEFAULT '0',
25 `faction_id` int(4) unsigned DEFAULT NULL,
26 `archived` tinyint(1) DEFAULT '0',
27 `scale` float(4,2) DEFAULT '1.00',
28 `biography` text NOT NULL,
29 `appearancelen` int(11) NOT NULL DEFAULT '0',
30 `infofield` text NOT NULL,
31 `hair` text NOT NULL,
32 `hairData` text NOT NULL,
33 `hairDataLen` int(8) NOT NULL DEFAULT '0',
34 `playermodel` text NOT NULL,
35 `CRC` bigint(20) NOT NULL DEFAULT '0',
36 `Title` tinytext NOT NULL,
37 `parentid` bigint(20) NOT NULL DEFAULT '0',
38 `itemShift` int(11) NOT NULL DEFAULT '100',
39 `Health` mediumint(8) unsigned NOT NULL DEFAULT '900',
40 `Strength` mediumint(8) unsigned NOT NULL DEFAULT '450',
41 `Constitution` mediumint(8) unsigned NOT NULL DEFAULT '450',
42 `Action` mediumint(8) unsigned NOT NULL DEFAULT '900',
43 `Quickness` mediumint(8) unsigned NOT NULL DEFAULT '450',
44 `Stamina` mediumint(8) unsigned NOT NULL DEFAULT '450',
45 `Mind` mediumint(8) unsigned NOT NULL DEFAULT '900',
46 `Focus` mediumint(8) unsigned NOT NULL DEFAULT '450',
47 `Willpower` mediumint(8) unsigned NOT NULL DEFAULT '450',
48 `HealthWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
49 `StrengthWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
50 `ConstitutionWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
51 `ActionWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
52 `QuicknessWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
53 `StaminaWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
54 `MindWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
55 `FocusWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
56 `WillpowerWounds` mediumint(8) unsigned NOT NULL DEFAULT '0',
57 `BattleFatigue` mediumint(8) unsigned NOT NULL DEFAULT '0',
58 `PvpRating` smallint(5) unsigned NOT NULL DEFAULT '1200',
59 `adminLevel` smallint(2) unsigned NOT NULL DEFAULT '4',
60 `guildpermission` tinyint(3) unsigned NOT NULL DEFAULT '0',
61 `public` tinyint(1) unsigned NOT NULL DEFAULT '0',
62 `factionStatus` tinyint(1) unsigned NOT NULL DEFAULT '0',
63 `factionRank` tinyint(1) unsigned NOT NULL DEFAULT '0',
64 `experience` text NOT NULL,
65 `posture` tinyint(1) unsigned NOT NULL DEFAULT '0',
66 `timeOfDeath` bigint(20) unsigned NOT NULL DEFAULT '0',
67 `currentMissionKeys` text,
68 `finishedMissionKeys` text,
69 `cloningFacility` bigint(20) NOT NULL DEFAULT '0',
70 `home_location` tinyint(3) unsigned DEFAULT NULL,
71 `bank_location` tinyint(3) unsigned DEFAULT NULL,
72 `jedi_trainer` int(11) DEFAULT '0',
73 `usedHolocronCount` int(11) DEFAULT '0',
74 `shrinesMeditatedAt` int(11) DEFAULT '0',
75 `jediState` int(10) unsigned DEFAULT '0',
76 `badgesNeeded` text NOT NULL,
77 `creaturesNeeded` text NOT NULL,
78 `jediVis` int(11) DEFAULT '0',
79 `lastJediHint` bigint(20) unsigned NOT NULL DEFAULT '0',
80 `language` text NOT NULL,
81 `randomizeCreatures` int(11) NOT NULL DEFAULT '1',
82 PRIMARY KEY (`character_id`),
83 KEY `acc_id` (`account_id`),
84 KEY `gid` (`guild`)
85) ENGINE=MyISAM AUTO_INCREMENT=363470 DEFAULT CHARSET=latin1;