source s_dns {
	unix-dgram("/var/packages/DNSServer/target/named/dev/log" optional(yes) create-dirs(no));
};
filter f_dns { program(named); };
parser p_dns {
    csv-parser(columns("DATETIME", "DNSTAG", "CATAGORY", "MODULE", "SEVERITY", "CONTENT")
    delimiters("\t")
	quote-pairs('""')
    flags(escape-none greedy)
    template("${MSG}"));
};

# NOTE: if need change table field, remember to change table definition in SYNODNSLogDBSizeSet(), logmigrate.py
destination d_dns {
	sql(
	        type(sqlite3)
	        database("/var/packages/DNSServer/target/named/var/log/SYNODNSLOGDB")
	        table("logs")
	        columns(
	                "id integer primary key",
	                "time text default NULL",
	                "tag text default NULL",
	                "catagory text default NULL",
	                "module text default NULL",
					"severity integer default 0",
					"content text default NULL"
	        )
	        values(
	                "@@NULL@@",
	                "$DATETIME",
	                "$DNSTAG",
	                "$CATAGORY",
	                "$MODULE",
	                "$SEVERITY",
	                "$CONTENT"
	        )
	        indexes(
	                "time",
	                "catagory",
	                "severity"
	        )
	        null("@@NULL@@")
	);
};
log { source(src);source(s_dns);filter(f_dns);parser(p_dns);destination(d_dns);};