Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `account` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `login` varchar(30) NOT NULL DEFAULT '',
- `password` varchar(45) NOT NULL DEFAULT '',
- `social_id` varchar(13) NOT NULL DEFAULT '',
- `email` varchar(64) NOT NULL DEFAULT '',
- `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `is_testor` tinyint(1) NOT NULL DEFAULT '0',
- `status` varchar(8) NOT NULL DEFAULT 'OK',
- `securitycode` varchar(192) DEFAULT '',
- `newsletter` tinyint(1) 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 '0',
- `gold_expire` datetime NOT NULL DEFAULT '2016-01-01 01:01:01',
- `silver_expire` datetime NOT NULL DEFAULT '2016-01-01 01:01:01',
- `safebox_expire` datetime NOT NULL DEFAULT '2016-01-01 01:01:01',
- `autoloot_expire` datetime NOT NULL DEFAULT '2016-01-01 01:01:01',
- `fish_mind_expire` datetime NOT NULL DEFAULT '2016-01-01 01:01:01',
- `marriage_fast_expire` datetime NOT NULL DEFAULT '2016-01-01 01:01:01',
- `money_drop_rate_expire` datetime NOT NULL DEFAULT '2016-01-01 01:01:01',
- `total_cash` int(11) NOT NULL DEFAULT '0',
- `total_mileage` int(11) NOT NULL DEFAULT '0',
- `channel_company` varchar(30) DEFAULT '',
- `ip` varchar(255) DEFAULT NULL,
- `coins` int(11) DEFAULT '0',
- `web_admin` int(1) DEFAULT '0',
- `web_ip` varchar(15) DEFAULT NULL,
- `web_aktiviert` varchar(32) DEFAULT NULL,
- `last_play` varchar(32) DEFAULT NULL,
- `iptocountry` varchar(255) DEFAULT NULL,
- `drs` int(11) DEFAULT '0',
- `reason` varchar(256) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `login` (`login`) USING BTREE,
- KEY `social_id` (`social_id`) USING BTREE
- ) ENGINE=MyISAM AUTO_INCREMENT=200 DEFAULT CHARSET=ascii ROW_FORMAT=DYNAMIC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement