summaryrefslogtreecommitdiff
path: root/update.sql
diff options
context:
space:
mode:
Diffstat (limited to 'update.sql')
-rw-r--r--update.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/update.sql b/update.sql
new file mode 100644
index 0000000..c745643
--- /dev/null
+++ b/update.sql
@@ -0,0 +1,6 @@
+START TRANSACTION;
+DELETE FROM tx_likat_pubs_domain_model_publications;
+LOAD XML LOCAL INFILE './dbxml.xml'
+ INTO TABLE tx_likat_pubs_domain_model_publications
+ ROWS IDENTIFIED BY '<publication>';
+COMMIT;