Create a table for authors

..and links the publication by id

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;