dfESFZ9E

1DROP TABLE IF EXISTS users;
2DROP TABLE IF EXISTS quizs;
3DROP TABLE IF EXISTS questions;
4DROP TABLE IF EXISTS answers;
5
6CREATE TABLE users (
7    user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
8    user_name VARCHAR(255) NOT NULL UNIQUE,
9    user_email VARCHAR(255) NOT NULL,
10    user_password VARCHAR(255) NOT NULL
11);
12
13CREATE TABLE quizs (
14    quiz_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
15    quiz_user_id INT NOT NULL REFERENCES users(user_id),
16    quiz_title VARCHAR(255) NOT NULL,
17    quiz_description TEXT,
18    quiz_theme_id INT NOT NULL,
19    quiz_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
20    quiz_updated TIMESTAMP
21);
22
23CREATE TABLE questions (
24    question_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
25    question_quiz_id INT NOT NULL REFERENCES quizs(quiz_id),
26    question_text TEXT NOT NULL,
27    question_required BOOL NOT NULL
28);
29
30CREATE TABLE answers (
31    answer_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
32    answer_question_id INT NOT NULL REFERENCES questions(question_id),
33    answer_text TEXT,
34    answer_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
35);