/[cvs.andrew.net.au]/uni/COMP2400/dropa3.sql
ViewVC logotype

Contents of /uni/COMP2400/dropa3.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.11 - (show annotations)
Tue Oct 19 02:16:27 2004 UTC (17 years, 10 months ago) by apollock
Branch: MAIN
CVS Tags: HEAD
Changes since 1.10: +2 -0 lines
Added editor_publication and editor_authorship view definitions

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;

  ViewVC Help
Powered by ViewVC 1.1.22