SQL 29dy.cc [200 03-05-2016]

[rx26386]

sql dump of that site ... 29dy.cc

DROP TABLE IF EXISTS `ff_user`;
CREATE TABLE `ff_user` (
  `userid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `username` char(20) NOT NULL DEFAULT '',
  `password` char(32) NOT NULL DEFAULT '',
  `encrypt` char(6) NOT NULL,
  `nickname` char(20) NOT NULL,
  `regdate` int(10) unsigned NOT NULL DEFAULT '0',
  `lastdate` int(10) unsigned NOT NULL DEFAULT '0',
  `regip` char(15) NOT NULL DEFAULT '',
  `lastip` char(15) NOT NULL DEFAULT '',
  `loginnum` smallint(5) unsigned NOT NULL DEFAULT '0',
  `email` char(32) NOT NULL DEFAULT '',
  `iemail` char(32) NOT NULL,
  `amount` decimal(8,2) unsigned NOT NULL DEFAULT '0.00',
  `islock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `vip` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `point` tinyint(5) DEFAULT '0',
  `groupid` tinyint(1) DEFAULT '0',
  `avatar` tinyint(1) DEFAULT '0',
  `avatar_img` varchar(255) NOT NULL,
  `connectid` varchar(100) DEFAULT NULL,
  `from` varchar(100) DEFAULT NULL,
  `isRemind` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否开通订阅提醒',
  `isstation` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否开通站内订阅提醒',
  PRIMARY KEY (`userid`),
  UNIQUE KEY `username` (`username`),
  KEY `email` (`email`(20)),
  KEY `nickname` (`nickname`),
  KEY `iemail` (`iemail`),
  KEY `avatar_img` (`avatar_img`)
) ENGINE=MyISAM AUTO_INCREMENT=203 DEFAULT CHARSET=utf8;

29dy_cc(2016-5-3)_backup.rar