[info] The account table set up!

[runiker]

here is the account table just
save in notpad as a .sql file and
extract into the database

 
/*
MySQL Data Transfer
Source Host: legionwow.servegame.org
Source Database: serve
Target Host: legionwow.servegame.org
Target Database: serve
Date: 1/28/2008 6:36:01 PM
*/
SET FOREIGN_KEY_CHECKS=0;
 
-- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (
  `acct` bigint(20) unsigned NOT NULL auto_increment,
  `login` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `password` varchar(28) collate utf8_unicode_ci NOT NULL default '',
  `gm` varchar(27) collate utf8_unicode_ci NOT NULL default '',
  `banned` int(1) unsigned NOT NULL default '0',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `lastip` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `flags` int(11) unsigned NOT NULL default '0',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  `muted` int(30) NOT NULL default '0',
  PRIMARY KEY  (`acct`,`login`),
  UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

hope this helps the ppl whos db is missing it lol
im gald to help!