Version 2 (modified by 17 years ago) (diff) | ,
---|
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;
update
http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=titles&container=titles&filename=/tmp/ismi/titles.xml http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=authors&container=authors&filename=/tmp/ismi/authors.xml http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=aliases&container=aliases&filename=/tmp/ismi/aliases.xml http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=city&container=city&filename=/tmp/ismi/city.xml http://ismi/islamicMS/islamicMS/database/importXMLFileAccess?table=collection&container=collection&filename=/tmp/ismi/collection.xml