It was working before I changed a Integer Not Null to Integer on the scores table.
The error is "E/SQLiteLog﹕ (1) near "(": syntax error"
And the statement in question is -
CREATE TABLE "runs" ("_id" INTEGER PRIMARY KEY, "run_number" INTEGER NOT NULL, "total_time" REAL, "stroop_on" INTEGER NOT NULL, "successful" INTEGER NOT NULL, "successful_run_number" INTEGER NOT NULL, "training_run" INTEGER NOT NULL, "score_id" INTEGER NOT NULL, FOREIGN_KEY (score_id) REFERENCES scores(_id));
Aucun commentaire:
Enregistrer un commentaire