[dbo].[revocationrequest]

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

Name	Data Type	Max Length (Bytes)
requestid	int	4
country	varchar(50)	50
organisation	varchar(50)	50
orgunit	varchar(50)	50
name	varchar(50)	50
emailaddress	varchar(50)	50
serialnumber	varchar(50)	50
reason	varchar(50)	50
passphrase	varchar(50)	50
phonenumber	varchar(50)	50
reqreason	varchar(300)	300

	Name	Columns	Unique
	XPKrevocationrequest	requestid

Name	Columns
$revoc_r00003df100000000	requestid->[dbo].[request_pki].[requestid]

SQL Script

CREATE TABLE [dbo].[revocationrequest]
(
[requestid] [int] NOT NULL,
[country] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[organisation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[orgunit] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[emailaddress] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[serialnumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[reason] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[passphrase] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[phonenumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[reqreason] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[revocationrequest] ADD CONSTRAINT [XPKrevocationrequest] PRIMARY KEY CLUSTERED ([requestid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[revocationrequest] ADD CONSTRAINT [$revoc_r00003df100000000] FOREIGN KEY ([requestid]) REFERENCES [dbo].[request_pki] ([requestid])
GO