4fQ0Jh1z

1def create():
2    open()
3    cursor.execute('''PRAGMA foreign_keys=on''')
4
5
6    do('''CREATE TABLE IF NOT EXISTS quiz (
7           id INTEGER PRIMARY KEY,
8           name VARCHAR)''')
9
10
11    do('''CREATE TABLE IF NOT EXISTS question (
12               id INTEGER PRIMARY KEY,
13               question VARCHAR,
14               answer VARCHAR,
15               wrong1 VARCHAR,
16               wrong2 VARCHAR,
17               wrong3 VARCHAR)''')
18
19
20    do('''CREATE TABLE IF NOT EXISTS quiz_content (
21               id INTEGER PRIMARY KEY,
22               quiz_id INTEGER,
23               question_id INTEGER,
24               FOREIGN KEY (quiz_id) REFERENCES quiz (id),
25               FOREIGN KEY (question_id) REFERENCES question (id) )''')
26    close()
27