[wize_one]

this is a snipet from my account table. you can use it if you want.
also if you are running dr2 make sure you have run 0.5.2-update.sql, or if your running dr3 make sure you have run jan24_update.sql.

#
# Table structure for table account
#

DROP TABLE IF EXISTS `account`;

CREATE TABLE `account` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`charname` varchar(64) NOT NULL default '',
`packencrypt` blob NOT NULL,
`sharedplat` int(11) NOT NULL default '0',
`password` varchar(50) NOT NULL default '',
`status` int(5) NOT NULL default '0',
`lsaccount_id` int(11) unsigned default NULL,
`gmspeed` tinyint(3) unsigned NOT NULL default '0',
`revoked` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `lsaccount_id` (`lsaccount_id`)
) TYPE=MyISAM;


#
# Dumping data for table account
#

INSERT INTO `account` VALUES (1,'eqemu','','',5000,'eqemu',255,NULL,1,0);