@@ -0,0 +1,1319 @@
+package com.example.test.coolweather.db;%0A%0Aimport android.content.Context;%0Aimport android.database.sqlite.SQLiteDatabase;%0Aimport android.database.sqlite.SQLiteOpenHelper;%0A%0A/**%0A * Created by test on 8/10/2015.%0A */%0Apublic class CoolWeatherOpenHelper extends SQLiteOpenHelper%7B%0A    private static final String CREATE_PROVINCE = %22create table Province (%22%0A            + %22id integer primary key autoinrement,%22%0A            + %22province_name text, %22%0A            + %22province_code text)%22;%0A%0A    private static final String CREATE_CITY = %22create table City (%22%0A            + %22id integer primary key autoincrement,%22%0A            + %22city_name text,%22%0A            + %22city_code text)%22;%0A%0A    private static final String CREATE_COUNTY = %22create table County (%22%0A            + %22id integer primary key autoincrement,%22%0A            + %22county_name text%22%0A            + %22county_code text)%22;%0A%0A%0A    public CoolWeatherOpenHelper%0A            (Context context, String name, SQLiteDatabase.CursorFactory factory, int version) %7B%0A        super(context, name, factory, version);%0A    %7D%0A%0A    @Override%0A    public void onCreate(SQLiteDatabase db) %7B%0A        db.execSQL(CREATE_PROVINCE);%0A        db.execSQL(CREATE_CITY);%0A        db.execSQL(CREATE_COUNTY);%0A    %7D%0A%0A    @Override%0A    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) %7B%0A%0A    %7D%0A%7D%0A

create table in package db