[dbo].[certificate]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:06 AM Wednesday, March 07, 2007
Last Modified	11:09:06 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
serno	varchar(40)	40
commonname	varchar(200)	200
emailaddress	varchar(50)	50
validfrom	varchar(50)	50
validto	varchar(50)	50
revoked	char(10)	10
timeofinsertion	varchar(50)	50
timeofrevocation	varchar(50)	50
typeofservice	varchar(20)	20
certstring_lo	varbinary(2000)	2000
certstring_hi	varbinary(1000)	1000

	Name	Columns	Unique
	XPKcertificate	serno

SQL Script

CREATE TABLE [dbo].[certificate]
(
[serno] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[commonname] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[emailaddress] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[validfrom] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[validto] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[revoked] [char] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timeofinsertion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timeofrevocation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[typeofservice] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[certstring_lo] [varbinary] (2000) NULL,
[certstring_hi] [varbinary] (1000) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[certificate] ADD CONSTRAINT [XPKcertificate] PRIMARY KEY CLUSTERED ([serno]) ON [PRIMARY]
GO