Latest version of mysql table, by request:
CREATE TABLE `dplogin_accounts` (
`id` int UNSIGNED NOT NULL auto_increment,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`pwhash` char(32) NOT NULL,
`tempkey` char(32) NOT NULL,
`name` varchar(32) NOT NULL,
`email` varchar(255) NOT NULL default '',
`realname` varchar(64) NOT NULL default '',
`activationnum` INT UNSIGNED NOT NULL,
`flags` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
INDEX (email(8))
) COMMENT='Account' AUTO_INCREMENT=1;
CREATE TABLE `dplogin_names` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`name` varchar(32) NOT NULL default '',
`playerid` int UNSIGNED NOT NULL,
`flags` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
INDEX (name(8)),
INDEX (playerid)
) COMMENT='Name to ID remap';
CREATE TABLE `dplogin_clans` (
`id` int UNSIGNED NOT NULL auto_increment,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`name` varchar(64) NOT NULL default '',
`tag` varchar(16) NOT NULL default '',
`website` varchar(255) NOT NULL default '',
`ircchan` varchar(32) NOT NULL default '',
PRIMARY KEY (`id`)
) COMMENT='Account' AUTO_INCREMENT=1;
CREATE TABLE `dplogin_clanmembers` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`clanid` int UNSIGNED NOT NULL,
`playerid` int UNSIGNED NOT NULL,
`flags` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
INDEX (clanid),
INDEX (playerid)
) COMMENT='Name to ID remap' AUTO_INCREMENT=1;
CREATE TABLE `dplogin_ips` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
`ip` varchar(16) NOT NULL default 'BADIP',
PRIMARY KEY (`id`)
) COMMENT='IP Tracking Table' AUTO_INCREMENT=1;
CREATE TABLE `dplogin_hardwareids` (
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
`hardwareid` char(32) NOT NULL default 'BADHWID',
`hardwareidtype` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
) COMMENT='IP Tracking Table' AUTO_INCREMENT=1;
CREATE TABLE `dplogin_connectinfo` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`playerid` INT UNSIGNED NOT NULL,
`ipid` INT UNSIGNED NOT NULL,
`hardwareid1` INT UNSIGNED NOT NULL,
`hardwareid2` INT UNSIGNED NOT NULL,
`hardwareid3` INT UNSIGNED NOT NULL,
`hardwareid4` INT UNSIGNED NOT NULL,
`hardwareid5` INT UNSIGNED NOT NULL,
`hardwareid6` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
) COMMENT='Maps acconuts to IPs and hardware IDs.' AUTO_INCREMENT=1;
CREATE TABLE `dplogin_reservednames` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(32),
`flags` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
) COMMENT='Protected names that nobody can register.' AUTO_INCREMENT=1;
INSERT INTO dplogin_reservednames (name,flags) VALUES ('newbie[0-9]*','1');