#!/usr/bin/python 
# coding: utf-8
import config
dbname_fix="USER"
tablename_fix="t_furniture"
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',
				furniture_id int(11) unsigned not null comment '家具id',
				x int(11) unsigned not null comment 'x',
				y int(11) unsigned not null comment 'y',
				primary key (uid, furniture_id)
				)engine=innodb default charset=utf8;
		""" %(db_name,tablename_fix,j,db_name,tablename_fix,j)