[Addanc-developer] Updated Instrumentation Recorder Schema

[Joe G. <joe...@us...>]

See Below - also as an attachment...

--
Joe Griffin
Addanc
Downright Software Collective

Table            Create Table
---------------
---------------------------------------------------------------------------
Instrumentation  CREATE TABLE `Instrumentation` (
                   `instrumentationID` bigint(20) NOT NULL auto_increment,
                   `brickID` text NOT NULL,
                   `testID` text NOT NULL,
                   `scriptID` text NOT NULL,
                   `vcID` text NOT NULL,
                   `pageID` text NOT NULL,
                   `txnID` text NOT NULL,
                   `conStart` double unsigned zerofill default NULL,
                   `conEnd` double unsigned zerofill default NULL,
                   `conTime` double unsigned zerofill default NULL,
                   `sendStart` double unsigned zerofill default NULL,
                   `sendEnd` double unsigned zerofill default NULL,
                   `sendTime` double unsigned zerofill default NULL,
                   `recvStart` double unsigned zerofill default NULL,
                   `recvEnd` double unsigned zerofill default NULL,
                   `recvTime` double unsigned zerofill default NULL,
                   `procStart` double unsigned zerofill default NULL,
                   `procEnd` double unsigned zerofill default NULL,
                   `procTime` double unsigned zerofill default NULL,
                   `txnStart` double unsigned zerofill default NULL,
                   `txnEnd` double unsigned zerofill default NULL,
                   `txnTime` double unsigned zerofill default NULL,
                   `txnSendBytes` bigint(20) unsigned zerofill default NULL,
                   `txnRecvBytes` bigint(20) unsigned zerofill default NULL,
                   `txnHTTPStatus` text,
                   `txnTxnStatus` text,
                   PRIMARY KEY  (`instrumentationID`),
                   KEY `brickID` (`brickID`(25)),
                   KEY `testID` (`testID`(25)),
                   KEY `scriptID` (`scriptID`(25)),
                   KEY `vcID` (`vcID`(25)),
                   KEY `pageID` (`pageID`(25)),
                   KEY `txnID` (`txnID`(25))
                 ) TYPE=MyISAM

------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
sec...@do....
------------------------------------------------------------------------
This mail sent through Downright Software's implementation of HORDE/IMP.
For info, see: http://horde.org/imp/