UQhYCwTN

1How to add second table in database in sqlite?
2private static final String DATABASE_CREATE = "create table IF NOT EXISTS "
3        + TABLE_SUBJECT + "( " + COLUMN_ID
4        + " integer primary key autoincrement, " 
5        + COLUMN_SUBJECT + " text not null, "
6        + COLUMN_CHAPTER + " text, "
7        + COLUMN_QUESTION + " text not null,"
8        + COLUMN_OPTIONA + " text not null,"
9        + COLUMN_OPTIONB + " text not null,"
10        + COLUMN_OPTIONC + " text not null,"
11        + COLUMN_OPTIOND + " text not null,"
12        + COLUMN_CORRECT + " text not null,"
13        + COLUMN_CONFIRM + " text not null);";
14
15    private static final String DATABASE_CREATE1 = "create table IF NOT EXISTS "
16    + TABLE_CHAPTER + "( " + COLUMN_ID
17    + " integer primary key autoincrement, " 
18    + COLUMN_SUBJECT + " text not null, "
19    + COLUMN_CHAPTER + " text, "
20    + COLUMN_QUESTION + " text not null,"
21    + COLUMN_OPTIONA + " text not null,"
22    + COLUMN_OPTIONB + " text not null,"
23    + COLUMN_OPTIONC + " text not null,"
24    + COLUMN_OPTIOND + " text not null,"
25    + COLUMN_CORRECT + " text not null,"
26    + COLUMN_CONFIRM + " text not null);";
27
28public MySQLiteHelper open() throws SQLException 
29{
30    db = this.getWritableDatabase();
31    return this;
32}
33
34public MySQLiteHelper(Context context)
35{
36    super(context, DATABASE_NAME, null, DATABASE_VERSION);
37
38}
39
40
41@Override
42public void onCreate(SQLiteDatabase database) {
43
44    database.execSQL(DATABASE_CREATE);
45    database.execSQL(DATABASE_CREATE1);
46
47}
48	
4903-21 18:31:06.551: ERROR/Database(8255): Error inserting chapter=paging correctoption=shadow copy craete a duplicate copy of page subject=operating system question=what is shadow copy? optiona=shadow copy craete a duplicate copy of page confirm=YES optionb=sahdow copy create paging  optionc=shadow copy delete duplicate page optiond=shadow copy delete original and create shadow copy
5003-21 18:31:06.551: ERROR/Database(8255): android.database.sqlite.SQLiteException: no such table: chapter: , while compiling: INSERT INTO chapter(chapter, correctoption, subject, question, optiona, confirm, optionb, optionc, optiond) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?);
5103-21 18:31:06.551: ERROR/Database(8255):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
5203-21 18:31:06.551: ERROR/Database(8255):     at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
5303-21 18:31:06.551: ERROR/Database(8255):     at   android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
5403-21 18:31:06.551: ERROR/Database(8255):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
5503-21 18:31:06.551: ERROR/Database(8255):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:41)
5603-21 18:31:06.551: ERROR/Database(8255):     at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1149)
5703-21 18:31:06.551: ERROR/Database(8255):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1569)
5803-21 18:31:06.551: ERROR/Database(8255):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1426)
5903-21 18:31:06.551: ERROR/Database(8255):     at com.example.examguide.MySQLiteHelper.insertChapterData(MySQLiteHelper.java:212)
6003-21 18:31:06.551: ERROR/Database(8255):     at com.example.examguide.ObjectiveAddActivity$2.onClick(ObjectiveAddActivity.java:155)
61	
62database.execSQL(DATABASE_CREATE1);
63database.execSQL(DATABASE_CREATE2);
64	
65@Override
66public void onUpgrade (SQLiteDatabase db, int oldVersion, int newVersion) {
67    db.executeSQL(DATABASE_CREATE2);
68}
69	
70private static final String ALERT_DATABASE="alerts.db";
71
72//Database Version of Alert System  
73private static final int ALERT_DATABASE_VERSION=1;
74
75//Create alert_type table 
76private static final String CREATE_ALERT_TYPE="CREATE TABLE "
77        +ALERT_TYPE+"( "+ALERT_TYPE_ID+" INTEGER PRIMARY KEY AUTOINCREMENT,"
78        +ALERT_TYPE_NAME+" TEXT,"+ALERT_TYPE_TONE+" VARCHAR)";  
79
80
81private static final String CREATE_ALERT_INFORMATION="CREATE TABLE "
82        +ALERT_INFO+"( "+ALERT_INFO_ID+" INTEGER PRIMARY KEY AUTOINCREMENT,"
83        +ALERT_INFO_TITLE+" TEXT,"
84        +ALERT_INFO_DATE+" VARCHAR,"
85        +ALERT_INFO_TIME+" VARCHAR,"
86        +ALERT_INFO_DESCRIPTION+" VARCHAR,"
87        +ALERT_INFO_TYPE_ID+" VARCHAR)";
88
89
90public AlertDatabase(Context context) {
91    super(context, ALERT_DATABASE, null, ALERT_DATABASE_VERSION);
92    // TODO Auto-generated constructor stub
93}
94@Override
95public void onCreate(SQLiteDatabase alertdatabase){
96    alertdatabase.execSQL(CREATE_ALERT_TYPE);
97    alertdatabase.execSQL(CREATE_ALERT_INFORMATION);
98}
99	
100@Override
101public void onUpgrade (SQLiteDatabase db, int oldVersion, int newVersion) {
102    // Create the string for the second table creation
103    db.executeSQL(DATABASE_CREATE_SECOND_TABLE);
104}