home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
moodle.waes.ac.uk
/
moodle.waes.ac.uk.zip
/
moodle.waes.ac.uk
/
TMG
/
SP1-TMG-KB981324-AMD64-ENU.msp
/
PCW_CAB_SHFx2
/
F4403_w3proxy.sql
< prev
next >
Wrap
Text File
|
2010-06-15
|
2KB
|
76 lines
IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'sp_batch_insert' AND type = 'P')
exec sp_executesql N'CREATE PROCEDURE sp_batch_insert @tempTableName nvarchar(100), @tableName nvarchar(100) AS
EXECUTE (''INSERT into ['' + @tableName + ''] SELECT * FROM ['' + @tempTableName + '']'')
EXECUTE (''truncate table ['' + @tempTableName + '']'')'
GO
IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'sp_batch_discard' AND type = 'P')
exec sp_executesql N'CREATE PROCEDURE sp_batch_discard @tempTableName nvarchar(100) AS
EXECUTE (''truncate table ['' + @tempTableName + '']'')'
GO
CREATE TABLE WebProxyLog (
[ClientIP] uniqueidentifier,
[ClientUserName] nvarchar(514),
[ClientAgent] varchar(128),
[ClientAuthenticate] smallint,
[logTime] datetime,
[service] smallint,
[servername] nvarchar(32),
[referredserver] varchar(255),
[DestHost] varchar(255),
[DestHostIP] uniqueidentifier,
[DestHostPort] int,
[processingtime] int,
[bytesrecvd] bigint,
[bytessent] bigint,
[protocol] varchar(13),
[transport] varchar(8),
[operation] varchar(24),
[uri] varchar(2048),
[mimetype] varchar(32),
[objectsource] smallint,
[resultcode] int,
[CacheInfo] int,
[rule] nvarchar(128),
[FilterInfo] nvarchar(256),
[SrcNetwork] nvarchar(128),
[DstNetwork] nvarchar(128),
[ErrorInfo] int,
[Action] varchar(32),
[GmtLogTime] datetime,
[AuthenticationServer] varchar(255),
[ipsScanResult] smallint,
[ipsSignature] nvarchar(128),
[ThreatName] varchar(255),
[MalwareInspectionAction] smallint,
[MalwareInspectionResult] smallint,
[UrlCategory] int,
[MalwareInspectionContentDeliveryMethod] smallint,
[UagArrayId] varchar(20),
[UagVersion] int,
[UagModuleId] varchar(20),
[UagId] int,
[UagSeverity] varchar(20),
[UagType] varchar(20),
[UagEventName] varchar(60),
[UagSessionId] varchar(50),
[UagTrunkName] varchar(128),
[UagServiceName] varchar(20),
[UagErrorCode] int,
[MalwareInspectionDuration] int,
[MalwareInspectionThreatLevel] smallint,
[InternalServiceInfo] int,
[ipsApplicationProtocol] nvarchar(128),
[NATAddress] uniqueidentifier,
[UrlCategorizationReason] smallint,
[SessionType] smallint,
[UrlDestHost] varchar(255),
[SrcPort] int,
[SoftBlockAction] nvarchar(128)
)
CREATE CLUSTERED INDEX [IX_WebProxyLog_DateTime] ON [WebProxyLog]([logTime]) ON [PRIMARY]
GO