CREATE TABLE pw_hack_xqqiandao (
	`uid` int(10) unsigned NOT NULL default '0',
	`qdxq` tinyint(1) NOT NULL default '0',
	`qdbkid` smallint(6) unsigned NOT NULL default '0',
	`toflower` varchar(15) NOT NULL default '',
	
	`daynums` tinyint(1) unsigned NOT NULL default '0',
	`mdays` int(5) unsigned NOT NULL default '0',
	`mnums` int(5) unsigned NOT NULL default '0',
	`lmdays` int(5) unsigned NOT NULL default '0',
	`lmnums` int(5) unsigned NOT NULL default '0',
	`totaldays` int(5) unsigned NOT NULL default '0',
	`totalnums` int(5) unsigned NOT NULL default '0',

	`qdtime` int(10) unsigned NOT NULL default '0',
	`remind` tinyint(1) NOT NULL default '0',
	`lremind` tinyint(1) NOT NULL default '0',

	`todayxq1` int(5) unsigned NOT NULL default '0',
	`todayxq2` int(5) unsigned NOT NULL default '0',
	`todayxq3` int(5) unsigned NOT NULL default '0',
	`todayxq4` int(5) unsigned NOT NULL default '0',
	`todayxq5` int(5) unsigned NOT NULL default '0',
	`todayxq6` int(5) unsigned NOT NULL default '0',
	`todayxq7` int(5) unsigned NOT NULL default '0',

	`monthxq1` int(5) unsigned NOT NULL default '0',
	`monthxq2` int(5) unsigned NOT NULL default '0',
	`monthxq3` int(5) unsigned NOT NULL default '0',
	`monthxq4` int(5) unsigned NOT NULL default '0',
	`monthxq5` int(5) unsigned NOT NULL default '0',
	`monthxq6` int(5) unsigned NOT NULL default '0',
	`monthxq7` int(5) unsigned NOT NULL default '0',

	`lastmonthxq1` int(5) unsigned NOT NULL default '0',
	`lastmonthxq2` int(5) unsigned NOT NULL default '0',
	`lastmonthxq3` int(5) unsigned NOT NULL default '0',
	`lastmonthxq4` int(5) unsigned NOT NULL default '0',
	`lastmonthxq5` int(5) unsigned NOT NULL default '0',
	`lastmonthxq6` int(5) unsigned NOT NULL default '0',
	`lastmonthxq7` int(5) unsigned NOT NULL default '0',

	`totalxq1` int(8) unsigned NOT NULL default '0',
	`totalxq2` int(8) unsigned NOT NULL default '0',
	`totalxq3` int(8) unsigned NOT NULL default '0',
	`totalxq4` int(8) unsigned NOT NULL default '0',
	`totalxq5` int(8) unsigned NOT NULL default '0',
	`totalxq6` int(8) unsigned NOT NULL default '0',
	`totalxq7` int(8) unsigned NOT NULL default '0',

	`dltime` int(10) unsigned NOT NULL default '0',
	`jlnums` int(5) unsigned NOT NULL default '0',
  PRIMARY KEY (`uid`),
  KEY `qdtime` (`qdtime`),
  KEY `dltime` (`dltime`)
) ENGINE=MyISAM;

CREATE TABLE pw_hack_xqqiandaobk (
	`qdbkid` smallint(6) unsigned NOT NULL default '0',

	`days` int(5) unsigned NOT NULL default '0',
	`daynums` int(5) unsigned NOT NULL default '0',
	`mdays` int(5) unsigned NOT NULL default '0',
	`mnums` int(5) unsigned NOT NULL default '0',
	`lmdays` int(5) unsigned NOT NULL default '0',
	`lmnums` int(5) unsigned NOT NULL default '0',
	`totaldays` int(10) unsigned NOT NULL default '0',
	`totalnums` int(10) unsigned NOT NULL default '0',

	`todayxq1` int(10) unsigned NOT NULL default '0',
	`todayxq2` int(10) unsigned NOT NULL default '0',
	`todayxq3` int(10) unsigned NOT NULL default '0',
	`todayxq4` int(10) unsigned NOT NULL default '0',
	`todayxq5` int(10) unsigned NOT NULL default '0',
	`todayxq6` int(10) unsigned NOT NULL default '0',
	`todayxq7` int(10) unsigned NOT NULL default '0',

	`monthxq1` int(10) unsigned NOT NULL default '0',
	`monthxq2` int(10) unsigned NOT NULL default '0',
	`monthxq3` int(10) unsigned NOT NULL default '0',
	`monthxq4` int(10) unsigned NOT NULL default '0',
	`monthxq5` int(10) unsigned NOT NULL default '0',
	`monthxq6` int(10) unsigned NOT NULL default '0',
	`monthxq7` int(10) unsigned NOT NULL default '0',

	`lastmonthxq1` int(10) unsigned NOT NULL default '0',
	`lastmonthxq2` int(10) unsigned NOT NULL default '0',
	`lastmonthxq3` int(10) unsigned NOT NULL default '0',
	`lastmonthxq4` int(10) unsigned NOT NULL default '0',
	`lastmonthxq5` int(10) unsigned NOT NULL default '0',
	`lastmonthxq6` int(10) unsigned NOT NULL default '0',
	`lastmonthxq7` int(10) unsigned NOT NULL default '0',

	`totalxq1` int(10) unsigned NOT NULL default '0',
	`totalxq2` int(10) unsigned NOT NULL default '0',
	`totalxq3` int(10) unsigned NOT NULL default '0',
	`totalxq4` int(10) unsigned NOT NULL default '0',
	`totalxq5` int(10) unsigned NOT NULL default '0',
	`totalxq6` int(10) unsigned NOT NULL default '0',
	`totalxq7` int(10) unsigned NOT NULL default '0',
	PRIMARY KEY  (`qdbkid`)
) ENGINE=MyISAM;
