summaryrefslogtreecommitdiff
path: root/update.sql
diff options
context:
space:
mode:
authorBenjamin Franzke <bfr@qbus.de>2015-02-18 19:08:17 +0100
committerBenjamin Franzke <bfr@qbus.de>2015-02-18 19:08:17 +0100
commitfe9ddf26982c165d7972c8f013e430d80e912dc1 (patch)
tree5a7c07b0533289c2801f5a3409f8c99949febb6f /update.sql
parentbc8b53bc02edef1425d7e7b8f17166e0f27d67bd (diff)
downloadendnote-import-fe9ddf26982c165d7972c8f013e430d80e912dc1.zip
endnote-import-fe9ddf26982c165d7972c8f013e430d80e912dc1.tar.gz
endnote-import-fe9ddf26982c165d7972c8f013e430d80e912dc1.tar.bz2
Create a table for authors
..and links the publication by id
Diffstat (limited to 'update.sql')
-rw-r--r--update.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/update.sql b/update.sql
index c745643..239ac67 100644
--- a/update.sql
+++ b/update.sql
@@ -1,6 +1,10 @@
START TRANSACTION;
DELETE FROM tx_likat_pubs_domain_model_publications;
+DELETE FROM tx_likat_pubs_domain_model_authors;
LOAD XML LOCAL INFILE './dbxml.xml'
INTO TABLE tx_likat_pubs_domain_model_publications
ROWS IDENTIFIED BY '<publication>';
+LOAD XML LOCAL INFILE './dbxml.xml'
+ INTO TABLE tx_likat_pubs_domain_model_authors
+ ROWS IDENTIFIED BY '<author>';
COMMIT;