From fe9ddf26982c165d7972c8f013e430d80e912dc1 Mon Sep 17 00:00:00 2001
From: Benjamin Franzke <bfr@qbus.de>
Date: Wed, 18 Feb 2015 19:08:17 +0100
Subject: Create a table for authors

..and links the publication by id
---
 update.sql | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'update.sql')

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;
-- 
cgit