Currently I'm following tutorial for android database creation on youtube at channel ProgrammingKnowledge, however, it works only for one table, while I need to have 3 tables in the database, and can't get my way around it. This is the code I currently have.
public class DatabaseHelper extends SQLiteOpenHelper < //database name declaration public static final String DATABASE_NAME = "museum.db"; public static final String TABLE_NAME = "exponent_table"; public static final String COL_1 = "ID"; public static final String COL_2 = "TITLE"; public static final String COL_3 = "STORY"; public static final String COL_4 = "AUTHOR"; public static final String COL_5 = "DATE"; public DatabaseHelper(Context context) < super(context, DATABASE_NAME, null, 1); SQLiteDatabase db= this.getWritableDatabase(); //will create database and table, just for checking, will be replaced >@Override public void onCreate(SQLiteDatabase db) < //creating tables . db.execSQL("create table "+TABLE_NAME+" (ID INTEGER PRIMARY KEY AUTOINCREMENT, TITLE TEXT, STORY TEXT, AUTHOR TEXT, DATE STRING)"); >@Override public void onUpgrade(SQLiteDatabase db, int i, int i1) < db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME); onCreate(db); >> I have seen something similar on the link: Multi-table database SQLite android But still do not understand.