create table AccessRecord
(
	id integer not null
		constraint AccessRecord_pk
			primary key autoincrement,
	AccessUrl nvarchar(1000),
	ClientIp nvarchar(300),
	ContentType nvarchar(500),
	Duration integer,
	StartTime datetime,
	Ticks integer,
	Method nvarchar(50),
	Referrer nvarchar(1000),
	UserAgent nvarchar(500),
	Identity nvarchar(500),
	ControllerName nvarchar(100),
	ActionName nvarchar(100)
);

create unique index AccessRecord_id_uindex
	on AccessRecord (id);