CREATE TABLE IF NOT EXISTS `characters` (
`channelnum` varchar(255) NOT NULL default '1',
`charname` text NOT NULL,
`level` int(10) NOT NULL default '1',
`class` int(10) NOT NULL default '1',
`sex` int(10) NOT NULL,
`hairstyle` int(10) NOT NULL,
`haircolor` int(10) NOT NULL,
`eyestyle` int(10) NOT NULL,
`stat_str` int(10) NOT NULL default '15',
`stat_sta` int(10) NOT NULL default '15',
`stat_dex` int(10) NOT NULL default '15',
`stat_int` int(10) NOT NULL default '15',
`charslot` int(10) NOT NULL,
`id` int(10) NOT NULL auto_increment,
`posX` int(10) NOT NULL default '6973',
`posY` int(10) NOT NULL default '10',
`posZ` int(10) NOT NULL default '3328',
`guild_id` int(10) NOT NULL default '0',
`posWorldID` int(10) NOT NULL default '1',
`accountname` text NOT NULL,
`penya` int(9) NOT NULL default '1000000000',
`exp` float NOT NULL default '0',
`curhp` int(10) NOT NULL default '10000',
`curmp` int(10) NOT NULL default '10000',
`curfp` int(10) NOT NULL default '10000',
`karma_point` int(10) NOT NULL default '0',
`duel_point` int(10) NOT NULL default '0',
`killing_point` int(10) NOT NULL default '0',
`skills` text NOT NULL default '',
`skill_levels` int(10) NOT NULL default '20',
`fslot1_opcodes` int(10) NOT NULL default '0',
`fslot1_ids` int(10) NOT NULL default '0',
`fslot1_text` text NOT NULL default '',
`fslot2_opcodes` int(10) NOT NULL default '0',
`fslot2_ids` int(10) NOT NULL default '0',
`fslot2_text` text NOT NULL default '',
`fslot3_opcodes` int(10) NOT NULL default '0',
`fslot3_ids` int(10) NOT NULL default '0',
`fslot3_text` text NOT NULL default '',
`fslot4_opcodes` int(10) NOT NULL default '0',
`fslot4_ids` int(10) NOT NULL default '0',
`fslot4_text` text NOT NULL default '',
`hotslot_opcodes` int(10) NOT NULL default '0',
`hotslot_ids` int(10) NOT NULL default '0',
`hotslot_text` text NOT NULL default '',
`flying_level` int(10) NOT NULL default '1',
`flying_exp` float NOT NULL default '0',
`skillpoints` int(3) NOT NULL default '0',
`statpoints` int(3) NOT NULL default '0',
`messenger_state` int(1) NOT NULL default '0',
`posAngle` int(10) NOT NULL default '1',
`sizeMod` int(10) NOT NULL default '1',
`party_id` int(10) NOT NULL default '0',
`buffpet_itemnum` int(10) NOT NULL default '0',
`disposition` int(10) NOT NULL default '0',
`actionslot_opcodes` int(10) NOT NULL default '0',
`actionslot_ids` int(10) NOT NULL default '0',
`actionslot_text` text NOT NULL default '',
`partyDefaultName` text NOT NULL default '',
`canJoinGuildAt` int(10) NOT NULL default '1',
`actionslot_cooldown` int(10) NOT NULL default '0',
`allowViewEquipment` int(10) NOT NULL default '0',
`allowPVPDuelRequests` int(10) NOT NULL default '1',
`fslot5_opcodes` int(10) NOT NULL default '0',
`fslot5_ids` int(10) NOT NULL default '0',
`fslot5_text` text NOT NULL default '',
`fslot6_opcodes` int(10) NOT NULL default '0',
`fslot6_ids` int(10) NOT NULL default '0',
`fslot6_text` text NOT NULL default '',
`fslot7_opcodes` int(10) NOT NULL default '0',
`fslot7_ids` int(10) NOT NULL default '0',
`fslot7_text` text NOT NULL default '',
`fslot8_opcodes` int(10) NOT NULL default '0',
`fslot8_ids` int(10) NOT NULL default '0',
`fslot8_text` text NOT NULL default '',
`bag1_last_until` int(10) NOT NULL default '0',
`bag2_last_until` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;
|