【汇总】数据库设计

`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`)