private void createTable()
{
string query = "CREATE TABLE IF NOT EXISTS " + UPGRADE_TABLE_NAME + " ( " +
UNIT_ID + INTEGER + NOT_NULL + SEPARATOR +
LEVEL + INTEGER + NOT_NULL + SEPARATOR +
GROUND_ATTACK_PLUS + INTEGER + SEPARATOR +
AIR_ATTACK_PLUS + INTEGER + SEPARATOR +
HEALTH_PLUS + INTEGER + SEPARATOR +
PRICE + INTEGER + SEPARATOR +
MIN_USER_LEVEL + INTEGER + SEPARATOR +
PRIMARY_KEY + "(" + UNIT_ID + SEPARATOR + LEVEL + ")" +
" ) ";
// while (SQLManager.instance == null)
// {
// yield return new WaitForEndOfFrame();
// }
sqlManager.execute(query);
}
public void createTable()
{
string query = "CREATE TABLE IF NOT EXISTS " + UNIT_TABLE_NAME + " ( " +
UNIT_ID_COL + INTEGER + NOT_NULL + PRIMARY_KEY + SEPARATOR +
UNIT_NAME_COL + VARCHAR + NOT_NULL + SEPARATOR +
UNIT_POWER_SPAWN_COL + INTEGER + SEPARATOR +
UNIT_POWER_MOVE_COL + INTEGER + SEPARATOR +
UNIT_POWER_ATTACK_COL + INTEGER + SEPARATOR +
UNIT_POWER_REGEN_COL + FLOAT + SEPARATOR +
UNIT_AIR_DAMAGE_COL + INTEGER + SEPARATOR +
UNIT_GROUND_DAMAGE_COL + INTEGER + SEPARATOR +
UNIT_ARMOR_PRICISING_DAMAGE_POINT + FLOAT + SEPARATOR +
UNIT_SPLASH_DAMAGE_POINT_COL + INTEGER + SEPARATOR +
UNIT_HEALTH_COL + INTEGER + SEPARATOR +
UNIT_IS_ARMORED_COL + BOOLEAN + SEPARATOR +
UNIT_IS_GROUND_COL + BOOLEAN + SEPARATOR +
UNIT_IS_LOCKED_COL + BOOLEAN + SEPARATOR +
UNIT_IS_IN_DECK_COL + BOOLEAN + SEPARATOR +
UNIT_WIDTH_COL + FLOAT + SEPARATOR +
UNIT_HEIGHT_COL + FLOAT + SEPARATOR +
UNIT_VISION_COL + INTEGER + SEPARATOR +
UNIT_REQUIRED_LEVEL_COL + INTEGER + SEPARATOR +
UNIT_COIN_COST + INTEGER + SEPARATOR +
UNIT_CURRENT_LEVEL_COL + INTEGER + SEPARATOR +
UNIT_LAST_MODIFIED_COL + INTEGER + SEPARATOR +
UNIT_MOVE_SPEED_COL + INTEGER + SEPARATOR +
UNIT_DESCRIPTION_COL + VARCHAR + SEPARATOR +
UNIT_IS_VEHICLE_COL + BOOLEAN + SEPARATOR +
UNIT_SHOT_PER_TURN + INTEGER +
//SEPARATOR +
//UNIT_NUMBER_OF_STATE_IMAGES + INTEGER + SEPARATOR +
//UNIT_NUMBER_OF_DIRECTIONS + INTEGER +
" ) ";
sqlManager.execute(query);
}