package com.weather.yogurt.lifequery.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by Yogurt on 16/7/3.
 */
public class DatabaseOpenHelper extends SQLiteOpenHelper{

    /*
       电话归属地建表语句
     */
    public static final String CREATE_TELEPHONE_HOME_OWNERSHIP="create table TelephoneHomeOwnership("
            +"id integer primary key autoincrement,"
            +"telephone_number text"
            +"telephone_search_date text)";
    /*
      IP地址建表语句
    */
    public static final String CREATE_IP_ADDRESS="create table IpAddress("
            +"id integer primary key autoincrement,"
            +"ip_address text"
            +"ip_address_search_date text)";
    /*
      Apple序列号建表语句
    */
    public static final String CREATE_APPLE_SERIAL_NUMBER="create table AppleSerialNumber("
            +"id integer primary key autoincrement,"
            +"apple_serial_number text"
            +"apple_serial_number_search_date text)";
    /*
      AppleIMEI建表语句
    */
    public static final String CREATE_APPLE_IMEI_NUMBER="create table AppleIMEINumber("
            +"id integer primary key autoincrement,"
            +"apple_imei_number text"
            +"apple_imei_number_search_date text)";
    /*
      快递建表语句
    */
    public static final String CREATE_EXPRESS="create table Express("
            +"id integer primary key autoincrement,"
            +"express_number text"
            +"express_search_date text)";
    /*
      银行卡建表语句
    */
    public static final String CREATE_BANK_CARD="create table BankCard("
            +"id integer primary key autoincrement,"
            +"bank_card_number text"
            +"bank_card_search_date text)";
    /*
      股票建表语句
    */
    public static final String CREATE_SHARES="create table Shares("
            +"id integer primary key autoincrement,"
            +"shares text"
            +"shares_search_date text)";
    /*
      火车票建表语句
    */
    public static final String CREATE_TRAIN_TICKETS="create table TrainTickets("
            +"id integer primary key autoincrement,"
            +"train_tickets_number text"
            +"train_tickets_search_date text)";
    /*
      邮编建表语句
    */
    public static final String CREATE_ZIP_CODE="create table ZipCode("
            +"id integer primary key autoincrement,"
            +"zip_code_number text"
            +"zip_code_search_date text)";
    /*
      汇率建表语句
    */
    public static final String CREATE_EXCHANGE_RATE="create table ExchangeRate("
            +"id integer primary key autoincrement,"
            +"exchange_rate text"
            +"exchange_rate_search_date text)";
    /*
      商标建表语句
    */
    public static final String CREATE_TRADEMARK="create table Trademark("
            +"id integer primary key autoincrement,"
            +"trademark text"
            +"trademark_search_date text)";
    /*
      景点名票建表语句 去哪儿网
    */
    public static final String CREATE_ATTRACTIONSTICKETS_PRICE="create table AttractionsTickets("
            +"id integer primary key autoincrement,"
            +"attractions_name text"
            +"attractions_search_date text)";
    /*
      万年历建表语句
    */
    public static final String CREATE_PERPETUAL_CALENDAR="create table PerpetualCalendar\n("
            +"id integer primary key autoincrement,"
            +"perpetual_calendar text"
            +"perpetual_calendar_search_date text)";


    public DatabaseOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

@@ -3700,16 +3700,570 @@
 se db) %7B
+%0A        db.execSQL(CREATE_TELEPHONE_HOME_OWNERSHIP);%0A        db.execSQL(CREATE_IP_ADDRESS);%0A        db.execSQL(CREATE_APPLE_SERIAL_NUMBER);%0A        db.execSQL(CREATE_APPLE_IMEI_NUMBER);%0A        db.execSQL(CREATE_EXPRESS);%0A        db.execSQL(CREATE_BANK_CARD);%0A        db.execSQL(CREATE_SHARES);%0A        db.execSQL(CREATE_TRAIN_TICKETS);%0A        db.execSQL(CREATE_ZIP_CODE);%0A        db.execSQL(CREATE_EXCHANGE_RATE);%0A        db.execSQL(CREATE_TRADEMARK);%0A        db.execSQL(CREATE_ATTRACTIONSTICKETS_PRICE);%0A        db.execSQL(CREATE_PERPETUAL_CALENDAR);
 %0A%0A    %7D%0A

create all tables