i5EgEXEQ

1package id.ac.uim.kamusit.data.helper;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7public class DatabaseHelper extends SQLiteOpenHelper{
8
9    public static String DATABASE_NAME = "kamus.db";
10
11    public static String TABLE_IT = "it";
12    public static String TABLE_JARINGAN = "jaringan";
13    public static String TABLE_WEB = "web";
14    public static String TABLE_ANDROID = "android";
15    public static String TABLE_RPL = "rpl";
16
17    public static String FIELD_ID = "id";
18    public static String FIELD_WORD = "word";
19    public static String FIELD_TRANSLATE = "translate";
20
21    private static final int DATABASE_VERSION = 1;
22
23    public static String CREATE_TABLE_IT = "create table " + TABLE_IT + " (" +
24            FIELD_ID + " integer primary key autoincrement, " +
25            FIELD_WORD + " text not null, " +
26            FIELD_TRANSLATE + " text not null);";
27
28    public static String CREATE_TABLE_JARINGAN = "create table " + TABLE_JARINGAN + " (" +
29            FIELD_ID + " integer primary key autoincrement, " +
30            FIELD_WORD + " text not null, " +
31            FIELD_TRANSLATE + " text not null);";
32
33    public static String CREATE_TABLE_WEB = "create table " + TABLE_WEB + " (" +
34            FIELD_ID + " integer primary key autoincrement, " +
35            FIELD_WORD + " text not null, " +
36            FIELD_TRANSLATE + " text not null);";
37
38    public static String CREATE_TABLE_ANDROID = "create table " + TABLE_ANDROID + " (" +
39            FIELD_ID + " integer primary key autoincrement, " +
40            FIELD_WORD + " text not null, " +
41            FIELD_TRANSLATE + " text not null);";
42
43    public static String CREATE_TABLE_RPL = "create table " + TABLE_RPL + " (" +
44            FIELD_ID + " integer primary key autoincrement, " +
45            FIELD_WORD + " text not null, " +
46            FIELD_TRANSLATE + " text not null);";
47
48    public DatabaseHelper(Context context) {
49        super(context, DATABASE_NAME, null, DATABASE_VERSION);
50    }
51
52    @Override
53    public void onCreate(SQLiteDatabase db) {
54        db.execSQL(CREATE_TABLE_IT);
55        db.execSQL(CREATE_TABLE_JARINGAN);
56        db.execSQL(CREATE_TABLE_WEB);
57        db.execSQL(CREATE_TABLE_ANDROID);
58        db.execSQL(CREATE_TABLE_RPL);
59    }
60
61    @Override
62    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
63        db.execSQL("DROP TABLE IF EXISTS " + TABLE_IT);
64        db.execSQL("DROP TABLE IF EXISTS " + TABLE_JARINGAN);
65        db.execSQL("DROP TABLE IF EXISTS " + TABLE_WEB);
66        db.execSQL("DROP TABLE IF EXISTS " + TABLE_ANDROID);
67        db.execSQL("DROP TABLE IF EXISTS " + TABLE_RPL);
68        onCreate(db);
69    }
70}