Android Open Source - Android_Yellow_Pages_App_Content_Provider Search Table

From Project

Back to project page Android_Yellow_Pages_App_Content_Provider.

License

The source code is released under:

Apache License

If you think the Android project Android_Yellow_Pages_App_Content_Provider listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package com.tddrampup.databases;
/*ww  w. j  a  v  a 2  s  .c o  m*/
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

/**
 * Created by: WX009-PC
 * on: 2/27/14.
 */
public class SearchTable {

    public static final String SEARCH_TABLE = "searchTable";
    public static final String COLUMN_ID = "_id";
    public static final String COLUMN_LISTING_ID = "listing_id";
    public static final String COLUMN_NAME = "name";
    public static final String COLUMN_STREET = "street";
    public static final String COLUMN_CITY = "city";
    public static final String COLUMN_MERCHANT_URL = "merchant_url";
    public static final String COLUMN_LATITUDE = "latitude";
    public static final String COLUMN_LONGITUDE = "longitude";

    private static final String DATABASE_CREATE = "create table "
            + SEARCH_TABLE
            + "("
            + COLUMN_ID + " integer primary key autoincrement, "
            + COLUMN_LISTING_ID + " text not null, "
            + COLUMN_NAME + " text not null, "
            + COLUMN_STREET + " text not null, "
            + COLUMN_CITY + " text not null, "
            + COLUMN_MERCHANT_URL + " text not null, "
            + COLUMN_LATITUDE + " text not null, "
            + COLUMN_LONGITUDE + " text not null"
            + ");";

    public static void onCreate(SQLiteDatabase db) {
        db.execSQL(DATABASE_CREATE);
    }

    public static void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        Log.w(ListingsTable.class.getName(), "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data");
        db.execSQL("DROP TABLE IF EXISTS " + SEARCH_TABLE);
        onCreate(db);
    }
}

Java Source Code List