· 6 years ago · Mar 16, 2019, 04:14 AM
1DROP TABLE IF EXISTS `odin_sea`.`characters`;
2CREATE TABLE `odin_sea`.`characters` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `accountid` int(11) NOT NULL DEFAULT '0',
5 `world` tinyint(1) NOT NULL DEFAULT '0',
6 `name` varchar(13) NOT NULL DEFAULT '',
7 `level` int(3) unsigned NOT NULL DEFAULT '0',
8 `exp` int(11) NOT NULL DEFAULT '0',
9 `str` int(5) NOT NULL DEFAULT '0',
10 `dex` int(5) NOT NULL DEFAULT '0',
11 `luk` int(5) NOT NULL DEFAULT '0',
12 `int` int(5) NOT NULL DEFAULT '0',
13 `hp` int(5) NOT NULL DEFAULT '0',
14 `mp` int(5) NOT NULL DEFAULT '0',
15 `maxhp` int(5) NOT NULL DEFAULT '0',
16 `maxmp` int(5) NOT NULL DEFAULT '0',
17 `meso` int(11) NOT NULL DEFAULT '0',
18 `hpApUsed` int(5) NOT NULL DEFAULT '0',
19 `job` int(5) NOT NULL DEFAULT '0',
20 `skincolor` tinyint(1) NOT NULL DEFAULT '0',
21 `gender` tinyint(1) NOT NULL DEFAULT '0',
22 `fame` int(5) NOT NULL DEFAULT '0',
23 `hair` int(11) NOT NULL DEFAULT '0',
24 `face` int(11) NOT NULL DEFAULT '0',
25 `demonMarking` int(11) NOT NULL DEFAULT '0',
26 `ap` int(5) NOT NULL DEFAULT '0',
27 `map` int(11) NOT NULL DEFAULT '0',
28 `spawnpoint` int(3) NOT NULL DEFAULT '0',
29 `gm` int(3) NOT NULL DEFAULT '0',
30 `party` int(11) NOT NULL DEFAULT '0',
31 `buddyCapacity` int(3) NOT NULL DEFAULT '25',
32 `createdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
33 `guildid` int(10) unsigned NOT NULL DEFAULT '0',
34 `guildrank` tinyint(1) unsigned NOT NULL DEFAULT '5',
35 `allianceRank` tinyint(1) unsigned NOT NULL DEFAULT '5',
36 `guildContribution` int(11) NOT NULL DEFAULT '0',
37 `pets` varchar(13) NOT NULL DEFAULT '-1,-1,-1',
38 `sp` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0',
39 `subcategory` int(11) NOT NULL DEFAULT '0',
40 `rank` int(11) NOT NULL DEFAULT '1',
41 `rankMove` int(11) NOT NULL DEFAULT '0',
42 `jobRank` int(11) NOT NULL DEFAULT '1',
43 `jobRankMove` int(11) NOT NULL DEFAULT '0',
44 `marriageId` int(11) NOT NULL DEFAULT '0',
45 `familyid` int(11) NOT NULL DEFAULT '0',
46 `seniorid` int(11) NOT NULL DEFAULT '0',
47 `junior1` int(11) NOT NULL DEFAULT '0',
48 `junior2` int(11) NOT NULL DEFAULT '0',
49 `currentrep` int(11) NOT NULL DEFAULT '0',
50 `totalrep` int(11) NOT NULL DEFAULT '0',
51 `gachexp` int(11) NOT NULL DEFAULT '0',
52 `fatigue` tinyint(4) NOT NULL DEFAULT '0',
53 `charm` mediumint(7) NOT NULL DEFAULT '0',
54 `craft` mediumint(7) NOT NULL DEFAULT '0',
55 `charisma` mediumint(7) NOT NULL DEFAULT '0',
56 `will` mediumint(7) NOT NULL DEFAULT '0',
57 `sense` mediumint(7) NOT NULL DEFAULT '0',
58 `insight` mediumint(7) NOT NULL DEFAULT '0',
59 `totalWins` int(11) NOT NULL DEFAULT '0',
60 `totalLosses` int(11) NOT NULL DEFAULT '0',
61 `pvpExp` int(11) NOT NULL DEFAULT '0',
62 `pvpPoints` int(11) NOT NULL DEFAULT '0',
63 `friendshipPoints` int(11) NOT NULL DEFAULT '0',
64 `JoeJoe` mediumint(7) NOT NULL DEFAULT '0',
65 `Hermonniny` mediumint(7) NOT NULL DEFAULT '0',
66 `LittleDragon` mediumint(7) NOT NULL DEFAULT '0',
67 `Ika` mediumint(7) NOT NULL DEFAULT '0',
68 PRIMARY KEY (`id`),
69 KEY `accountid` (`accountid`),
70 KEY `id` (`id`),
71 KEY `guildid` (`guildid`),
72 KEY `familyid` (`familyid`),
73 KEY `marriageId` (`marriageId`),
74 KEY `seniorid` (`seniorid`)
75) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;