CREATE TABLE HIVEMIND_W3SVC_1
  ([ID] uniqueidentifier NOT NULL PRIMARY KEY CLUSTERED ROWGUIDCOL,
   [Source] uniqueidentifier NOT NULL FOREIGN KEY REFERENCES LogSource ([ID]) ON DELETE CASCADE ON UPDATE CASCADE,
   [date-time] datetime NULL,
   [c-ip] int NULL,
   [cs-username] nvarchar(36) NULL,
   [s-sitename] varchar(12) NULL,
   [s-computername] nvarchar(16) NULL,
   [s-ip] int NULL,
   [s-port] int NULL,
   [cs-method] varchar(10) NULL,
   [cs-uri-stem] uniqueidentifier NULL FOREIGN KEY REFERENCES URIStem ([ID]),
   [cs-uri-query] uniqueidentifier NULL FOREIGN KEY REFERENCES URIQuery ([ID]),
   [sc-status] smallint NULL,
   [sc-win32-status] int NULL,
   [sc-bytes] int NULL,
   [cs-bytes] int NULL,
   [time-taken] int NULL,
   [cs-version] varchar(20) NULL,
   [cs-host] uniqueidentifier NULL FOREIGN KEY REFERENCES Host ([ID]),
   [cs(User-Agent)] uniqueidentifier NULL FOREIGN KEY REFERENCES UserAgent ([ID]),
   [cs(Cookie)] uniqueidentifier NULL FOREIGN KEY REFERENCES Cookie ([ID]),
   [cs(Referer)] uniqueidentifier NULL FOREIGN KEY REFERENCES Referer ([ID])
  )