QuizWebsite/drop.sql at master · tjsavage/QuizWebsite · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
USE c_cs108_tjsavage;

DROP TABLE IF EXISTS users;

DROP TABLE IF EXISTS friends_join;

DROP TABLE IF EXISTS friend_requests;

DROP TABLE IF EXISTS messages;

DROP TABLE IF EXISTS challenges;

DROP TABLE IF EXISTS achievementsAwarded;

DROP TABLE IF EXISTS achievements;

DROP TABLE IF EXISTS anouncements;

DROP TABLE IF EXISTS terminated_users;

DROP TABLE IF EXISTS images;

DROP TABLE IF EXISTS quizzes;

DROP TABLE IF EXISTS questions;

DROP TABLE IF EXISTS question_response_questions;

DROP TABLE IF EXISTS fill_in_questions;

DROP TABLE IF EXISTS multiple_choice_questions;

DROP TABLE IF EXISTS multiple_choice_choices;

DROP TABLE IF EXISTS picture_response_questions;

DROP TABLE IF EXISTS answers;

DROP TABLE IF EXISTS quiz_results;