DatabaseCreation: MajStore_DDL_delete.sql

File MajStore_DDL_delete.sql, 1.0 KB (added by 231049, 3 weeks ago)
Line 
1DROP TABLE IF EXISTS Premium_Worker;
2
3DROP TABLE IF EXISTS Payment;
4
5DROP TABLE IF EXISTS Worker_Method;
6
7DROP TABLE IF EXISTS Review_Comment;
8
9DROP TABLE IF EXISTS Review;
10
11DROP TABLE IF EXISTS Post_Specialty;
12
13DROP TABLE IF EXISTS Worker_Specialty;
14
15DROP TABLE IF EXISTS Application;
16
17DROP TABLE IF EXISTS Application_Status;
18
19DROP TABLE IF EXISTS Post_Image;
20
21DROP TABLE IF EXISTS Post;
22
23DROP TABLE IF EXISTS Post_Status;
24
25DROP TABLE IF EXISTS Certificate;
26
27DROP TABLE IF EXISTS Calendar_Event;
28
29DROP TABLE IF EXISTS Work_Day;
30
31DROP TABLE IF EXISTS Calendar;
32
33DROP TABLE IF EXISTS Worker;
34
35DROP TABLE IF EXISTS Notification;
36
37DROP TABLE IF EXISTS User_Role;
38
39DROP TABLE IF EXISTS "User";
40
41DROP TABLE IF EXISTS Payment_Status;
42
43DROP TABLE IF EXISTS Premium_Plan;
44
45DROP TABLE IF EXISTS Payment_Method;
46
47DROP TABLE IF EXISTS Specialty;
48
49DROP TABLE IF EXISTS Day;
50
51DROP TABLE IF EXISTS Role_Permission;
52
53DROP TABLE IF EXISTS Role;
54
55DROP TABLE IF EXISTS Permission;
56
57DROP TABLE IF EXISTS Location;