Gott eh, was man durch nerven nciht alles erreicht
Code:
CREATE TABLE IF NOT EXISTS `account` (
`id` int(12) NOT NULL auto_increment,
`login` varchar(30) NOT NULL default '',
`password` varchar(45) NOT NULL default '',
`real_name` varchar(16) NOT NULL default '',
`social_id` varchar(7) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`phone1` varchar(16) default NULL,
`phone2` varchar(16) default NULL,
`address` varchar(128) default NULL,
`zipcode` varchar(7) NOT NULL default '',
`create_time` datetime NOT NULL default '0000-00-00 00:00:00',
`question1` varchar(48) default NULL,
`answer1` varchar(48) default NULL,
`question2` varchar(48) default NULL,
`answer2` varchar(48) default NULL,
`is_testor` tinyint(1) NOT NULL default '0',
`status` varchar(8) NOT NULL default 'OK',
`securitycode` varchar(192) default '',
`newsletter` tinyint(1) NOT NULL default '0',
`empire` tinyint(4) NOT NULL default '0',
`name_checked` tinyint(1) NOT NULL default '0',
`availDt` datetime NOT NULL default '0000-00-00 00:00:00',
`mileage` int(11) NOT NULL default '0',
`cash` int(11) NOT NULL default '1000000',
`gold_expire` datetime NOT NULL default '0000-00-00 00:00:00',
`silver_expire` datetime NOT NULL default '0000-00-00 00:00:00',
`safebox_expire` datetime NOT NULL default '0000-00-00 00:00:00',
`autoloot_expire` datetime NOT NULL default '0000-00-00 00:00:00',
`fish_mind_expire` datetime NOT NULL default '0000-00-00 00:00:00',
`marriage_fast_expire` datetime NOT NULL default '0000-00-00 00:00:00',
`money_drop_rate_expire` datetime NOT NULL default '0000-00-00 00:00:00',
`ttl_cash` int(11) NOT NULL default '0',
`ttl_mileage` int(11) NOT NULL default '0',
`channel_company` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `login` (`login`),
KEY `social_id` (`social_id`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
einfahc in der account DB ausführen..