mig-import missed a clause for deleting from the itemtypes table
[migration-tools.git] / kmig.d / bin / mig-import
index 4483c23..e94e5d0 100755 (executable)
@@ -446,7 +446,6 @@ sub restore_itemtypes {
     my $sth = $dbh->prepare($query);
     $sth->execute();
 
-
     $query = "DELETE FROM authorised_values WHERE category = 'ITEMTYPECAT'";
     $sth = $dbh->prepare($query);
     $sth->execute();
@@ -455,6 +454,10 @@ sub restore_itemtypes {
     $sth = $dbh->prepare($query);
     $sth->execute();
 
+    $query = "DELETE FROM itemtypes WHERE 1 = 1";
+    $sth = $dbh->prepare($query);
+    $sth->execute();
+
     foreach my $node ($dom->findnodes('/document/authorised_values/value')) {
         my $category = sql_str($node->findvalue('./category'));
         my $authvalue = sql_str($node->findvalue('./authvalue'));