-
Notifications
You must be signed in to change notification settings - Fork 0
/
drop.sql
43 lines (22 loc) · 872 Bytes
/
drop.sql
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
40
41
42
43
DROP PROCEDURE delete_user;
DROP VIEW searchquery;
DROP VIEW mediumdropdown;
DROP VIEW genredropdown;
DROP VIEW selectauthor;
DROP VIEW languagedropdown;
DROP SEQUENCE item_med_seq;
DROP TRIGGER item_medium_aut_incr;
DROP TABLE authored_by CASCADE CONSTRAINTS;
DROP TABLE influenced_by CASCADE CONSTRAINTS;
DROP TABLE borrowed_by CASCADE CONSTRAINTS;
DROP TABLE belongs_to CASCADE CONSTRAINTS;
DROP TABLE phys_book CASCADE CONSTRAINTS;
DROP TABLE audio_book CASCADE CONSTRAINTS;
DROP TABLE lib_item CASCADE CONSTRAINTS;
DROP TABLE lib_section CASCADE CONSTRAINTS;
DROP TABLE author CASCADE CONSTRAINTS;
DROP TABLE user_account CASCADE CONSTRAINTS;
DROP TABLE item_medium CASCADE CONSTRAINTS;
DROP TABLE lib CASCADE CONSTRAINTS;
DROP TABLE lang CASCADE CONSTRAINTS;
DROP TABLE item_genre CASCADE CONSTRAINTS;