uni/COMP2400/dropa3.sql

-- DROP ROLES

DROP ROLE u4137129_researcher;
DROP ROLE u4137129_administrator;
DROP ROLE u4137129_editor;

-- DROP VIEWS

DROP VIEW Books;
DROP VIEW JournalArticles;

DROP VIEW publications_by_author;
DROP VIEW articles_by_keyword;
DROP VIEW researcher_by_institution;
DROP VIEW institution_publications;
DROP VIEW publication_by_institution;
DROP VIEW monograph_by_institution;
DROP VIEW author_by_institution;

DROP VIEW editor_journal;
DROP VIEW editor_journalsubscription;
DROP VIEW editor_article;
DROP VIEW editor_articlekeywords;
DROP VIEW editor_publication;
DROP VIEW editor_authorship;

DROP VIEW editor_mailinglist;
DROP VIEW editor_subscriptions;

DROP VIEW article_toc;
DROP VIEW article_keywords;
1	-- DROP ROLES
2
3	DROP ROLE u4137129_researcher;
4	DROP ROLE u4137129_administrator;
5	DROP ROLE u4137129_editor;
6
7	-- DROP VIEWS
8
9	DROP VIEW Books;
10	DROP VIEW JournalArticles;
11
12	DROP VIEW publications_by_author;
13	DROP VIEW articles_by_keyword;
14	DROP VIEW researcher_by_institution;
15	DROP VIEW institution_publications;
16	DROP VIEW publication_by_institution;
17	DROP VIEW monograph_by_institution;
18	DROP VIEW author_by_institution;
19
20	DROP VIEW editor_journal;
21	DROP VIEW editor_journalsubscription;
22	DROP VIEW editor_article;
23	DROP VIEW editor_articlekeywords;
24	DROP VIEW editor_publication;
25	DROP VIEW editor_authorship;
26
27	DROP VIEW editor_mailinglist;
28	DROP VIEW editor_subscriptions;
29
30	DROP VIEW article_toc;
31	DROP VIEW article_keywords;