package iphan.pibex.igarassu.ifpe.edu.br.constants;

import com.google.android.gms.maps.model.LatLng;

public class Constants {

    //constante Banco de Dados
    public static final String BD_NOME = "MapaDeIgarassu";
    public static final int VERSAO_BD = 5;
    public static final String TABLE = "location";
    public static final String ID = "_id";
    public static final String NAME = "name";
    public static final String LONGITUDE = "longitude";
    public static final String LATITUDE = "latitude";
    public static final String ADDRESS = "address";
    public static final String DESCRIPTION = "description";
    public static final String CREATE_TABLE =
            "create table " + TABLE + " ( "+
            ID + " integer primary key autoincrement, "+
            NAME + " text not null, " +
            LONGITUDE + " double not null, " +
            LATITUDE + " double not null, " +
            ADDRESS + " text not null, " +
            DESCRIPTION + " text not null" + ")";

    public static final String DROP_TABLE = "drop table "+TABLE+";";
    public static final String SELECT_ALL = "select * from "+TABLE;
    public static final String INSERT_ALL = "insert into "+TABLE+"("
            +NAME+","+LONGITUDE+","+LATITUDE+","+ADDRESS+","+DESCRIPTION+") values(?, ?, ?, ?, ?)";
    public static final String SELECT_FROM_NAME = "select * from "+TABLE+" where "+NAME+" = like %?%";

    //constantes para os tipos de mapa
    public static final int MAP_TYPE_NONE = 0;
    public static final int MAP_TYPE_NORMAL = 1;
    public static final int MAP_TYPE_SATELLITE = 2;
    public static final int MAP_TYPE_TERRAIN = 3;
    public static final int MAP_TYPE_HYBRID = 4;

    //constante SharedPreferences
    public static final String PREF_NAME = "SharedPreferences";

    //constante center location para o mapa
    public static final LatLng CENTER_LOCATION = new LatLng(-7.834195, -34.906142);

}

@@ -188,15 +188,15 @@
 ing 
-BD_NOME
+NAME_DB
  = %22
@@ -248,13 +248,14 @@
 VERS
-AO_BD
+ION_DB
  = 5

Update Constants.java