#!/usr/bin/python 
# coding: utf-8
import config
dbname_fix="USER"
tablename_fix="t_mail"
db_count=10
table_count=10
for i in range (db_count):
	db_name= "%s_%s_%01d"%(config.server_index,dbname_fix,i)
	for j in range(table_count):
		print """
		drop table if exists %s.%s_%01d;create table %s.%s_%01d(
				`idx` bigint(18) unsigned not null comment '邮件idx',
				`uid` bigint(18) unsigned not null default '0' comment '玩家id',
				`state` tinyint(4) unsigned not null default '0' comment '邮件状态(0:未读，1:已读)',
				`mail_id`int(11) unsigned not null default '0' comment '配置表中的mail_id',
				`attachment` varchar(1024) not null default '' comment '邮件附件',
				`bin_data` blob default NULL,
				`time` int(11) unsigned not null default '0' comment '邮件过期时间',
				primary key (idx, uid)
				)engine=innodb auto_increment=10001 default charset=utf8; 
		""" %(db_name,tablename_fix,j,db_name,tablename_fix,j)