[dbo].[renewalrequest]

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
newexpirydate	datetime	8
passphrase	varchar(50)	50
phonenumber	varchar(50)	50
reqreason	varchar(300)	300

	Name	Columns	Unique
	XPKrenewalrequest	requestid

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

SQL Script

CREATE TABLE [dbo].[renewalrequest]
(
[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,
[newexpirydate] [datetime] 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].[renewalrequest] ADD CONSTRAINT [XPKrenewalrequest] PRIMARY KEY CLUSTERED ([requestid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[renewalrequest] ADD CONSTRAINT [$renew_r00003dcd00000000] FOREIGN KEY ([requestid]) REFERENCES [dbo].[request_pki] ([requestid])
GO