Changes between Initial Version and Version 1 of database

Timestamp:

Apr 5, 2007, 2:18:33 PM (17 years ago)

Author:

dwinter

Comment:

--

database

@@ +1 @@
+= Views =
+
+Die folgenden Views sind notwendig:
+
+{{{
+create view title_mss as SELECT a.titleid, a.fulltitle, a.shorttitle, a.arabictitle, a.aunum, a.fulltitle_normal, m.city, m.library, m.collection, m.msnum,m.msid
+   FROM titles a
+   LEFT JOIN mss m ON a.titleid = m.titleid;
+}}}
+
+{{{
+create view author_title_mss as SELECT a.aunum, b.titleid, b.fulltitle, b.shorttitle, b.arabictitle, b.fulltitle_normal, b.city, b.library, b.collection, b.msnum,b.msid
+   FROM authors a
+   LEFT JOIN title_mss b ON a.aunum = b.aunum;
+
+}}}
+{{{
+create view alias_and_name as
+ SELECT authors.aunum, authors.fullname, authors.fullname_normal
+   FROM authors
+UNION 
+ SELECT aliases.aunum, aliases.alias AS fullname, aliases.alias_normal AS fullname_normal
+   FROM aliases;
+}}}