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 / 25140 < prev    next >
Text File  |  2010-06-15  |  623b  |  20 lines
  1. IF OBJECT_ID ('tblUrlfSummary', 'u') IS NULL
  2. BEGIN
  3.     CREATE TABLE [dbo].[tblUrlfSummary](
  4.     [UrlCategoryID] [int] NULL,
  5.     [CategorizationReason] [int] NULL,
  6.     [Action] [int] NULL,
  7.     [UrlfMatched] [char] NULL,
  8.     [Requests] [bigint] NULL,
  9.     [BytesIn] [bigint] NULL,
  10.     [BytesOut] [bigint] NULL,
  11.     [TotalBytes] [bigint] NULL,
  12.     [Date] [datetime] NULL,
  13.     [ServerName] [nvarchar](32) NULL
  14.     ) ON [PRIMARY]
  15.  
  16.     EXECUTE dbo.ISA_spDuplicateEmptyTable 'tblUrlfSummary', 'tblUrlfSummary_Daily', 0
  17.     EXECUTE dbo.ISA_spDuplicateEmptyTable 'tblUrlfSummary', 'tblUrlfSummary_Monthly', 0
  18.  
  19. END
  20.