#!/usr/bin/python
# coding: utf-8
import config
dbname_fix="USER"
tablename_fix="t_yesterday_btl_rank"
db_name= "%s_%s"%(config.server_index, dbname_fix)

print """
DROP TABLE IF EXISTS %s.%s;CREATE TABLE %s.%s (
        type int(11) NOT NULL comment'类型',
        uid bigint(18) unsigned not null comment'用户id',       
		win_cnt int(11) NOT NULL,
		exp int(11) NOT NULL,
        tim int(11) NOT NULL,
        PRIMARY KEY(type, uid)
        )engine=innodb default charset=utf8;
""" % (db_name, tablename_fix, db_name,tablename_fix)