Hi I want to log our ISA server logs to mySQL
I need to create a table using the .sql file supplied by Microsoft. (Following below) The last script is as I am trying to recreate it. I can recreate everything fine, but I have two problems. Problem 1 There is a # in the last two field names Problem 2 I don't understand the "ON PRIMARY" statement in the index creation. Thanks Ewan Sadie ______________________________________________________________________ _______ MICROSOFT SCRIPT ______________________________________________________________________ _______ CREATE TABLE WebProxyLog ( [ClientIP] varchar(32), [ClientUserName] nvarchar(32), [ClientAgent] varchar(128), [ClientAuthenticate] varchar(5), [logDate] datetime, [logTime] datetime, [service] varchar(16), [servername] nvarchar(32), [referredserver] varchar(32), [DestHost] varchar(255), [DestHostIP] varchar(32), [DestHostPort] int, [processingtime] int, [bytesrecvd] int, [bytessent] int, [protocol] varchar(12), [transport] varchar(8), [operation] varchar(8), [uri] varchar(255), [mimetype] varchar(32), [objectsource] varchar(12), [resultcode] int, [CacheInfo] int, [rule#1] nvarchar(128), [rule#2] nvarchar(128) ) CREATE INDEX [IX_WebProxyLog_Date] ON [WebProxyLog]([logDate]) ON [PRIMARY] GO CREATE INDEX [IX_WebProxyLog_DateTime] ON [WebProxyLog]([logDate], [logTime]) ON [PRIMARY] GO __________________________________________________________ MY SCRIPT __________________________________________________________ CREATE TABLE WebProxyLog ( ClientIP varchar(32), ClientUserName varchar(32), ClientAgent varchar(128), ClientAuthenticate varchar(5), logDate datetime, logTime datetime, service varchar(16), servername varchar(32), referredserver varchar(32), DestHost varchar(255), DestHostIP varchar(32), DestHostPort int, processingtime int, bytesrecvd int, bytessent int, protocol varchar(12), transport varchar(8), operation varchar(8), uri varchar(255), mimetype varchar(32), objectsource varchar(12), resultcode int, CacheInfo int, rule#1 varchar(128), rule#2 varchar(128) ); CREATE INDEX IX_WebProxyLog_Date ON WebProxyLog(logDate); CREATE INDEX IX_WebProxyLog_DateTime ON WebProxyLog(logDate, logTime); _______________________________________________________________ http://www.webmail.co.za the South-African free email service --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
