#!/usr/bin/python
# coding: utf-8
import config
dbname_fix="USER"
tablename_fix="t_event"
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(
				uid bigint(18) unsigned not null comment'用户id',
				type int(11) unsigned not null comment '类型',
				id bigint(18) unsigned not null comment 'id',
				data bigint(18) unsigned not null comment '数据',
				time int(11) unsigned  not null comment '时间',
				str_data varchar(20480) NOT NULL DEFAULT '' comment '事件数据',
				bin_data blob default NULL,
                primary key (uid,type,id)
				)engine=innodb default charset=utf8;
		""" %(db_name,tablename_fix,j,db_name,tablename_fix,j)