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 / F2143_msfpcui.dll / BINARY / 25055 < prev    next >
Text File  |  2010-06-15  |  768b  |  20 lines
  1. IF OBJECT_ID ('tblTrafficSummary', 'u') IS NULL
  2. BEGIN
  3.     CREATE TABLE [dbo].[tblTrafficSummary](
  4.         [Interval] [int] NULL,
  5.         [CacheHits] [bigint] NULL,
  6.         [CachedRequests] [bigint] NULL,
  7.         [NonCachedRequests] [bigint] NULL,
  8.         [CachedProcessingTime] [bigint] NULL,
  9.         [NonCachedProcessingTime] [bigint] NULL,
  10.         [TotalBytes] [bigint] NULL,
  11.         [WebRequests] [bigint] NULL,
  12.         [Requests] [bigint] NULL,
  13.         [MaxConcurrentConnectionsPerMinute] [bigint] NULL,
  14.         [Date] [datetime] NULL
  15.     ) ON [PRIMARY]
  16.  
  17.     EXECUTE dbo.ISA_spDuplicateEmptyTable 'tblTrafficSummary', 'tblTrafficSummary_Daily', 0
  18.     EXECUTE dbo.ISA_spDuplicateEmptyTable 'tblTrafficSummary', 'tblTrafficSummary_Monthly', 0
  19. END
  20.