CREATE TABLE `characters` (
`obj_id` int(11) NOT NULL,
`char_name` varchar(35) NOT NULL,
`level` int(2) NOT NULL DEFAULT 1,
`maxHp` int(11) NOT NULL,
`curHp` int(11) NOT NULL,
`maxCp` int(11) NOT NULL,
`curCp` int(11) NOT NULL,
`maxMp` int(11) NOT NULL,
`curMp` int(11) NOT NULL,
`face` tinyint(1) NOT NULL,
`hairStyle` tinyint(1) NOT NULL,
`hairColor` tinyint(1) NOT NULL,
`sex` tinyint(1) NOT NULL,
`heading` int(11) NOT NULL,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`z` int(11) NOT NULL,
`exp` bigint(20) unsigned NOT NULL DEFAULT 0,
`sp` int(11) NOT NULL DEFAULT 0,
`karma` int(11) NOT NULL DEFAULT 0,
`pvpkills` int(11) NOT NULL DEFAULT 0,
`pkkills` int(11) NOT NULL DEFAULT 0,
`clanid` int(11) NOT NULL DEFAULT 0,
`race` tinyint(1) NOT NULL,
`classid` tinyint(3) NOT NULL,
`base_class` tinyint(3) NOT NULL,
`online` tinyint(1) NOT NULL DEFAULT 0,
`lastAccess` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`obj_id`)
);
- race — 0–4 (Human, Elf, DElf, Orc, Dwarf).
- classid — ID текущего класса.
- base_class — на C1 = classid (т.к. сабклассов ещё нет).