[dbo].[track

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	73
Created	4:53:08 PM Sunday, February 07, 2010
Last Modified	4:53:08 PM Sunday, February 07, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

4:53:08 PM Sunday, February 07, 2010

Last Modified

4:53:08 PM Sunday, February 07, 2010

Name	Data Type	Max Length (Bytes)	Identity
message_id	int	4	1 - 1
session_id	char(32)	32
eventgroup_id	char(13)	13
username	nvarchar(255)	510
time	datetime	8
querystring	nvarchar(500)	1000
logged	tinyint	1
close_evgroup	tinyint	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

message_id

int

1 - 1

session_id

char(32)

eventgroup_id

char(13)

username

nvarchar(255)

510

time

datetime

querystring

nvarchar(500)

1000

logged

tinyint

close_evgroup

tinyint

	Name	Columns	Unique
	pk_track_msg	message_id

Name

Columns

Unique

pk_track_msg

message_id

SQL Script

CREATE TABLE [dbo].[track_msg]
(
[message_id] [int] NOT NULL IDENTITY(1, 1),
[session_id] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[eventgroup_id] [char] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[username] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[time] [datetime] NOT NULL,
[querystring] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[logged] [tinyint] NOT NULL,
[close_evgroup] [tinyint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[track_msg] ADD CONSTRAINT [pk_track_msg] PRIMARY KEY CLUSTERED ([message_id]) ON [PRIMARY]
GO