From 8c228c32e0f59ed26627be6775f96256d96bbcff Mon Sep 17 00:00:00 2001
From: bert hubert <bert.hubert@netherlabs.nl>
Date: Fri, 25 Apr 2014 09:28:58 +0200
Subject: [PATCH] actually insert the comments

---
 pdns/zone2sql.cc | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/pdns/zone2sql.cc b/pdns/zone2sql.cc
index 02cd8e07f..544330ed5 100644
--- a/pdns/zone2sql.cc
+++ b/pdns/zone2sql.cc
@@ -188,6 +188,12 @@ static void emitRecord(const string& zoneName, const string &qname, const string
         sqlstr(qtype)<<", "<<
         sqlstr(stripDotContent(content))<<", "<<ttl<<", "<<prio<<", 0"<<
         " from domains where name="<<toLower(sqlstr(zoneName))<<";\n";
+
+      if(!recordcomment.empty()) {
+        cout<<"insert into comments (domain_id,name,type,modified_at, comment) select id, "<<toLower(sqlstr(zoneName))<<", "<<sqlstr(qtype)<<", "<<time(0)<<", "<<sqlstr(recordcomment)<<" from domains where name="<<toLower(sqlstr(zoneName))<<";\n";
+       
+      }
+
     } else
     {
       cout<<"insert into records (domain_id, name, ordername, auth, type,content,ttl,prio,disabled) select id ,"<<
-- 
2.40.0