learn("CREATE TABLE IF NOT EXISTS " +

                    "People(" +

                    "PID INTEGER PRIMARY KEY AUTOINCREMENT,"+

                    "nick VARCHAR(16)"+

                     //TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM").

                    "lastspoken CHARACTER(16),"+

                    //The mode the bot was in last time speaking

                    "lastmood varchar(10),"+

                    "timesSpoken INTEGER NOT NULL);");

 

            //Answer questions

            learn("CREATE TABLE IF NOT EXISTS " +

                    "Questions(" +

                    "QID INTEGER PRIMARY KEY AUTOINCREMENT,"+

                     //TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM").

                    "why varchar(255),"+

                    "what varchar(255),"+

                    "how varchar(255),"+

                    "are varchar(255),"+

                    "who varchar(255),"+

                    "where varchar(255),"+

                    "subject varchar(255),"+

                    "answer varchar(255));");

//ERROR: Failed to execute: 'CREATE TABLE IF NOT EXISTS People(PID INTEGER PRIMARY KEY AUTOINCREMENT,nick VARCHAR(16)lastspoken CHARACTER(16),lastmood varchar(10),timesSpoken INTEGER NOT NULL);'

ERROR: java.sql.SQLException: near "lastspoken": syntax error

ERROR: Failed to execute: 'CREATE TABLE IF NOT EXISTS Questions(QID INTEGER PRIMARY KEY AUTOINCREMENT,why varchar(255),what varchar(255),how varchar(255),are varchar(255),who varchar(255),where varchar(255),subject varchar(255),answer varchar(255));'

ERROR: java.sql.SQLException: near "where": syntax error