sxU0hFJr

1Process: com.gregorius.kuufproject, PID: 21197
2    android.database.sqlite.SQLiteException: near "CREATE": syntax error (code 1): , while compiling: CREATE TABLE IF NOT EXISTS Users(id INTEGER PRIMARY KEY AUTOINCREMENT,username TEXT NOT NULL,password TEXT NOT NULL,phone TEXT NOT NULL,gender TEXT NOT NULL,wallet INTEGER NOT NULL,dateOfBirth TEXT NOT NULL)CREATE TABLE IF NOT EXISTS Products (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,minPlayer INTEGER NOT NULL,maxPlayer INTEGER NOT NULL,price INTEGER NOT NULL,latitude INTEGER NOT NULL,longitude INTEGER NOT NULL)CREATE TABLE IF NOT EXISTS Transactions (id INTEGER PRIMARY KEY AUTOINCREMENT,userId INTEGER NOT NULL,productId INTEGER NOT NULL,transactionDate TEXT NOT NULLFOREIGN KEY (userId) REFERENCES Users (id) ON DELETE CASCADE ON UPDATE CASCADE,FOREIGN KEY (productId) REFERENCES Products (id) ON DELETE CASCADE ON UPDATE CASCADE)
3        at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
4        at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
5        at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
6        at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
7        at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
8        at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
9        at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1677)
10        at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1608)
11        at com.gregorius.kuufproject.DBHelper.onCreate(DBHelper.java:83)
12        at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:294)
13        at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:194)
14        at com.gregorius.kuufproject.UsersTableHelper.insert(UsersTableHelper.java:15)
15        at com.gregorius.kuufproject.RegisterActivity$2.onClick(RegisterActivity.java:119)
16        at android.view.View.performClick(View.java:6256)
17        at com.google.android.material.button.MaterialButton.performClick(MaterialButton.java:1119)
18        at android.view.View$PerformClick.run(View.java:24701)
19        at android.os.Handler.handleCallback(Handler.java:789)
20        at android.os.Handler.dispatchMessage(Handler.java:98)
21        at android.os.Looper.loop(Looper.java:164)
22        at android.app.ActivityThread.main(ActivityThread.java:6541)
23        at java.lang.reflect.Method.invoke(Native Method)
24        at com.android.internal.os.Zygote$MethodAndArgsCaller.run(Zygote.java:240)
25        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:767)