Account Query

[RealEmX]

Kurz und knapp:
Hat mal einer kurz den MySQL Query für die Account Tablle?

[Akron_the_black_kinG]

Leider nicht, brauch sie selber

[RealEmX]

Hat sich erledigt XD

Falls ihn noch einer braucht:

CREATE TABLE IF NOT EXISTS `account` (
`id` int(11) 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 '200000',
`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 AUTO_INCREMENT=7570 ;