The tables created with the SQL Script are listed below.
TransactionID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Transactions PRIMARY KEY CLUSTERED ,
ParentTransactionID numeric(18, 0) NULL REFERENCES tbl_Transactions(TransactionID),
TransactionObject varchar (50) NOT NULL
EventID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_EventRules PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
SiteName varchar (50) NULL ,
EventName varchar (50) NULL ,
EventType varchar (50) NULL ,
ConditionValues varchar (1000) NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
ActionID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Actions PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
SiteName varchar (50) NULL ,
EventName varchar (50) NULL ,
ActionType varchar (50) NULL ,
Parameters varchar (1000) NULL ,
IsFailedAction bit NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE,
Details varchar(1000)
AuthenticationID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Authentications PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
RemoteIP varchar (15) NOT NULL ,
RemotePort numeric(18, 0) NULL ,
LocalIP varchar (15) NOT NULL ,
LocalPort numeric(18, 0) NULL ,
Protocol varchar (50) NULL ,
SiteName varchar (50) NULL ,
UserName varchar (50) NULL ,
PasswordHash varchar (500) NULL ,
SettingsLevels varchar (500) NULL ,
ResultID numeric(18, 0) NOT NULL ,
EventID numeric(18, 0) NOT NULL REFERENCES tbl_EventRules(EventID),
TransactionID numeric(18, 0) NOT NULL References tbl_Transactions(TransactionID) ON DELETE CASCADE
GroupID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Groups PRIMARY KEY CLUSTERED,
GroupName varchar (50) NULL ,
AuthenticationID numeric(18, 0) NOT NULL REFERENCES tbl_Authentications(AuthenticationID) ON DELETE CASCADE
CustomCommandID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_CustomCommands PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
SiteName varchar (50) NULL ,
Command varchar (50) NULL ,
CommandParameters varchar (1000) NULL ,
ExecutionTime numeric(18, 0) NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
ProtocolCommandID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ProtocolCommands PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
RemoteIP varchar (15) NULL ,
RemotePort numeric (18,0) NULL ,
LocalIP varchar (15) NULL ,
LocalPort numeric (18,0) NULL ,
Protocol varchar (50) NULL ,
SiteName varchar (50) NULL ,
Command varchar (10) NULL ,
CommandParameters varchar (1000) NULL ,
FileName varchar (500) NULL ,
VirtualFolderName varchar (500) NULL ,
PhysicalFolderName varchar (500) NULL ,
FileSize numeric(18, 0) NULL ,
TransferTime numeric(18, 0) NULL,
BytesTransferred numeric(18, 0) NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
ResultID numeric(18, 0) NOT NULL CONSTRAINT PK_tbl_ResultCodes PRIMARY KEY CLUSTERED,
Description varchar (100) NULL ,
Category varchar (10) NULL
SocketID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_SocketConnections PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
RemoteIP varchar (15) NULL ,
RemotePort numeric (18,0) NULL ,
LocalIP varchar (15) NULL ,
LocalPort numeric(18, 0) NULL ,
SiteName varchar (50) NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
ClientOperationID numeric (18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ClientOperations PRIMARY KEY CLUSTERED ,
Time_stamp datetime NOT NULL ,
Protocol varchar (50) NULL ,
RemoteAddress varchar (50) NULL ,
RemotePort numeric (18, 0) NULL ,
Username varchar (50) NULL ,
RemotePath varchar (500) NULL ,
LocalPath varchar (500) NULL ,
Operation varchar (50) NULL ,
BytesTransferred numeric (18, 0) NULL ,
TransferTime numeric (18, 0) NULL ,
ResultID numeric (18, 0) NOT NULL ,
TransactionID numeric (18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
[AdminCommandID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_AdminCommands PRIMARY KEY CLUSTERED,
[Time_Stamp] [datetime] NULL ,
[TransactionID] [numeric](18, 0) ,
[Login] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Data] [varchar] (7800) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
[PCIViolationID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_PCIViolations PRIMARY KEY CLUSTERED,
[Time_Stamp] [datetime] NULL ,
[ViolationID] [int] NULL ,
[SiteName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SettingsLevel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UserName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Admin] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Reason] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
[ServerInternalEventID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ServerInternalEvents PRIMARY KEY CLUSTERED,
[Time_Stamp] [datetime] NULL ,
[SiteName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SettingsLevel] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UserName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EventName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Parameters] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]