summaryrefslogtreecommitdiff
path: root/update.sql
diff options
context:
space:
mode:
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;