create table xml

<SqlCommands>
    <!-- ACCOUNT -->
    <SqlCommand name="GetAccountId">SELECT A.Id FROM account A WHERE A.Username = VAR1 AND A.Password = VAR2;</SqlCommand>
    <SqlCommand name="GetAccountHeroes">SELECT A.Name, A.Gender, A.Race, A.World, A.Location, A.Level, A.Position_X, A.Position_Y, A.Position_Z, A.Orientation_W, A.Orientation_X, A.Orientation_Y, A.Orientation_Z FROM hero A WHERE A.Account_Id = VAR1;</SqlCommand>

    <!-- LOCATION -->
    <SqlCommand name="CreateLocation">INSERT INTO location (World, Name, Scene) VALUES(VARIABLES);</SqlCommand>

    <SqlCommand name="GetLocationScene">SELECT A.Scene FROM location A WHERE A.Name = VAR2;</SqlCommand>
    <SqlCommand name="UpdateLocationScene">UPDATE location AS A SET A.Scene = VAR1 WHERE A.Name = VAR2;</SqlCommand>

    <!-- HERO -->
    <SqlCommand name="CreateHero">INSERT INTO hero (Name, Gender, Race, World, Location, Level, Position_X, Position_Y, Position_Z, Orientation_W, Orientation_X, Orientation_Y, Orientation_Z, Account_Id) VALUES(VARIABLES);</SqlCommand>

</SqlCommands>