NLog - DDL for Log Table and Setting the ConnectionString Programmatically

Question

1:

Is there a create statement for the Database Target Log Table for all the possible fields documented somewhere? I created one by guessing and I could check the source, but it would be handy if the generic SQL was available. I searched StackOverflow and the NLog site, but the SQL I found was dated and contained incorrect field types.

2:

If you're configuring a database target from a nlog.config file, how do you programmatically set the connection string? Something like:

Logger dbLogger = LogManager.GetLogger("dbLogger"); DatabaseTarget t = dbLogger.GetDatabaseTarget; t.ConnectionString = "...";

in application_start.

Thanks in advance.