强制数据库编码,防止出现乱码!!
CREATE TABLE `cdb_plugin_lottery_config` (
`id` int(10) unsigned NOT NULL auto_increment,
`key` varchar(20) NOT NULL,
`value` varchar(255) NOT NULL default '0,0,0',
`message` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
)ENGINE=MyISAM CHARACTER SET 'gbk';
INSERT INTO `cdb_plugin_lottery_config` (`id`, `key`, `value`, `message`) VALUES
(1, 'match6', '65536,65536,65536', '恭喜,一等奖'),
(2, 'match5', '256,256,256', '不错啊,二等奖'),
(3, 'match4', '16,16,16', '还好,三等奖'),
(4, 'match3', '4,4,4', 'OK,四等奖'),
(5, 'match2', '2,2,2', '恩,五等奖'),
(6, 'match1', '1,1,1', '呵呵,安慰奖'),
(7, 'match0', '0,0,0', '真遗憾一个都没中'),
(8, 'cost', '1,1,1', ''),
(9, 'maxbuy', '5', ''),
(10, 'allowseewinner', '1', ''),
(11, 'allowsendmsg', '1,1,1,1,1,1', '');
CREATE TABLE `cdb_plugin_lottery_flow` (
`lotteryid` mediumint(8) unsigned NOT NULL auto_increment COMMENT '彩票流水号',
`termid` mediumint(8) unsigned NOT NULL COMMENT '彩票期号',
`uid` mediumint(8) unsigned NOT NULL COMMENT '购买用户ID',
`buytime` date NOT NULL default '0000-00-00' COMMENT '购买时间',
`num1` int(2) unsigned NOT NULL COMMENT '号码1',
`num2` int(2) unsigned NOT NULL COMMENT '号码2',
`num3` int(2) unsigned NOT NULL COMMENT '号码3',
`num4` int(2) unsigned NOT NULL COMMENT '号码4',
`num5` int(2) unsigned NOT NULL COMMENT '号码5',
`num6` int(2) unsigned NOT NULL COMMENT '号码6',
PRIMARY KEY (`lotteryid`)
)ENGINE=MyISAM CHARACTER SET 'gbk';
CREATE TABLE `cdb_plugin_lottery_term` (
`termid` mediumint(8) unsigned NOT NULL auto_increment,
`num1` int(2) unsigned default NULL,
`num2` int(2) unsigned default NULL,
`num3` int(2) unsigned default NULL,
`num4` int(2) unsigned default NULL,
`num5` int(2) unsigned default NULL,
`num6` int(2) unsigned default NULL,
`seldout` mediumint(8) unsigned NOT NULL,
`run` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`termid`)
)ENGINE=MyISAM CHARACTER SET 'gbk';
[ 本帖最后由 safol 于 2008-8-21 18:56 编辑 ] |
|