static void Test()
{
SqlServer sql = new SqlServer();
sql.CreateAccountTable(true);
PlayerData data = new PlayerData();
data._accountName = "1";
data._nickName = "11";
data._blockIdsInUse = new int[] { 1
// , 2, 3
};
sql.Register(data, "1");
data._accountName = "2";
data._nickName = "22";
data._blockIdsInUse = new int[] { 3
// , 4, 5
};
sql.Register(data, "1");
sql.CreateAssetTable(true);
AssetData a = new AssetData();
a._accountName = "1";
a._gold = 10;
a._blocks = new int[] { 1, 2, 3 };
a._blockBoards = new int[] { 0, 1, 2 };
a._boards = new int[] { 0, 1, 2 };
a._persons = new int[] { 0, 1, 2 };
sql.ChangeAsset(a);
a._accountName = "2";
a._gold = 10;
a._blocks = new int[] { 3, 4, 5 };
a._blockBoards = new int[] { 0 };
a._boards = new int[] { 0 };
a._persons = new int[] { 0, 2 };
sql.ChangeAsset(a);
//var s = sql.GetAssetData("1");
//sql.CreateAccountTable();
}