【汇总】数据库设计
`location` tinyint(1) unsigned NOT NULL COMMENT '0,1',`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0,1,2,3',`category_id` tinyint(2) unsigned zerofill NOT NULL COMMENT '类别id',`sort_flag` tinyint(2) NOT NULL COMMENT '汇总分类(0;1;2;-3;-2;-1)',`game_id` tinyint(3) unsigned zerofill NOT NULL COMMENT 'ID', //例如 001 `version` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '版本',`max_online_member` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '最高在线会员人数',`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',`odds_set` char(1) NOT NULL COMMENT '是A, B, ....',`number` char(2) NOT NULL DEFAULT '' COMMENT '球号', `db_suffix` varchar(10) NOT NULL COMMENT '数据库后辍', `user_account` varchar(16) NOT NULL COMMENT '登录账号', `db_host` varchar(20) NOT NULL COMMENT '数据库服务器IP',`user_account` varchar(32) NOT NULL COMMENT '会员账号'`number_name` varchar(50) NOT NULL COMMENT '号码名称',`odds` varchar(150) NOT NULL COMMENT '',`module_name` varchar(256) NOT NULL COMMENT '操作模块',`content` varchar(2000) NOT NULL COMMENT '显示信息',`new_value` varchar(3000) NOT NULL COMMENT '变化后值',`share_self` decimal(15,5) NOT NULL COMMENT '', `odds` decimal(7,3) NOT NULL COMMENT '',`order_status` enum('wait','processing','success','false','part false') NOT NULL DEFAULT 'wait' COMMENT '状态',`draws_date` date NOT NULL COMMENT '期数时间',`add_time` datetime NOT NULL COMMENT '添加时间',`execute_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '插入记录开始时间',`draw_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '开奖时间',`caiji_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '采集时间',`content` text NOT NULL COMMENT '公告内容',PRIMARY KEY (`game_id`,`number`)UNIQUE KEY `sub_draws_id` (`draws_id`,`user_id`,`game_id`,`sort_flag`)UNIQUE KEY `sub_draws_id` (`draws_id`,`user_id`,`sort_flag`,`user_account`)?