#!/usr/bin/python 
# coding: utf-8
import config
dbname_fix="USER"
tablename_fix="t_friend"
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',
				friend_uid bigint(18) unsigned not null default 0 comment '好友id',
				nick char(32) not null default '' comment '昵称',
				status int(11) unsigned not null comment 'E_FRIEND_STATE 0:离线,1:在线,2:申请',
				primary key (uid,friend_uid)
				)engine=innodb default charset=utf8; 
		""" %(db_name,tablename_fix,j,db_name,tablename_fix,j)