Skip to content

Instantly share code, notes, and snippets.

@Dillie-O
Created November 29, 2012 17:27
Show Gist options
  • Save Dillie-O/4170581 to your computer and use it in GitHub Desktop.
Save Dillie-O/4170581 to your computer and use it in GitHub Desktop.
Log4Net Create SQLite DB Table Code
CREATE TABLE [log4net]
(
[id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[appdomain] varchar,
[aspnetcache] varchar,
[aspnetcontext] varchar,
[aspnetrequest] varchar,
[aspnetsession] varchar,
[date] datetime,
[exception] varchar,
[file] varchar,
[identity] varchar,
[location] varchar,
[level] varchar,
[line] integer,
[logger] varchar,
[message] varchar,
[method] varchar,
[ndc] varchar,
[property] varchar,
[stacktrace] varchar,
[stacktracedetail] varchar,
[timestamp] bigint,
[thread] varchar,
[type] varchar,
[username] varchar,
[utcdate] datetime,
[appfree1] varchar,
[appfree2] varchar,
[appfree3] varchar);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment