XT6DGV9m

1    public static final String QUESTION_TABLE_CREATE =
2
3            "CREATE TABLE IF NOT EXISTS QUESTION (" +
4
5                    "idQuestion   INTEGER PRIMARY KEY AUTOINCREMENT, " +
6                    "Qestion TEXT, " +
7                    "idQuizz INTEGER, " +
8                    "FOREIGN KEY(idQuizz) REFERENCES Quizz(idQuizz)); ";
9
10    public static final String REPONSE_TABLE_CREATE =
11
12            "CREATE TABLE IF NOT EXISTS  REPONSE (" +
13                    "idReponse INTEGER PRIMARY KEY AUTOINCREMENT, " +
14                    "idQuestion INTEGER NOT NULL, " +
15                    "Reponse TEXT, " +
16                    "ReponseVraie INTEGER, " +
17                    "FOREIGN KEY(idQuestion) REFERENCES QUESTION(id)); ";
18
19    public static final String QUIZZ_TABLE_CREATE =
20
21            "CREATE TABLE IF NOT EXISTS QUIZZ (" +
22
23                    "idQuizz  INTEGER NOT NULL, " +
24
25                    "NomQuizz TEXT" +
26
27                    "); ";