CREATE TABLE `cdb_lottery` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`isadmin` int(10) NOT NULL default '0',
`lottery` int(10) NOT NULL default '0',
`timing` int(10) NOT NULL default '0',
`times` int(10) NOT NULL default '0',
`finalno` int(10) NOT NULL default '0',
`buytime` int(10) NOT NULL default '0',
`winner` varchar(15) NOT NULL default '',
`total` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
INSERT INTO cdb_lottery (username,isadmin,lottery,timing,times,finalno,winner)
VALUES('0','1','0','0','0','0','0')
DROP TABLE IF EXISTS cdb_lottery;
CREATE TABLE `cdb_lottery` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`isadmin` int(10) NOT NULL default '0',
`lottery` int(10) NOT NULL default '0',
`timing` int(10) NOT NULL default '0',
`times` int(10) NOT NULL default '0',
`finalno` int(10) NOT NULL default '0',
`buytime` int(10) NOT NULL default '0',
`winner` varchar(15) NOT NULL default '',
`total` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=gbk;
INSERT INTO cdb_lottery (username,isadmin,lottery,timing,times,finalno,winner)
VALUES('0','1','0','0','0','0','0')