[dbo].[mdb_patch]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	262
Created	11:08:04 AM Wednesday, March 07, 2007
Last Modified	9:07:34 PM Friday, December 05, 2008

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

262

Created

11:08:04 AM Wednesday, March 07, 2007

Last Modified

9:07:34 PM Friday, December 05, 2008

Name	Data Type	Max Length (Bytes)
patchnumber	int	4
installdate	datetime	8
servicepacknumber	int	4
mdbmajorversion	int	4
mdbminorversion	int	4
checkpointid	int	4
description	nvarchar(255)	510

Name

Data Type

Max Length (Bytes)

Allow Nulls

patchnumber

int

installdate

datetime

servicepacknumber

int

mdbmajorversion

int

mdbminorversion

int

checkpointid

int

description

nvarchar(255)

510

	Name	Columns	Unique
	$mdb_p_u00004af300000000	patchnumber

Name

Columns

Unique

$mdb_p_u00004af300000000

patchnumber

Name	Columns
$mdb_p_r00004af900000000	checkpointid->[dbo].[mdb_checkpoint].[checkpointid]
$mdb_p_r00004b0d00000000	servicepacknumber->[dbo].[mdb_service_pack].[servicepacknumber]

Name

Columns

$mdb_p_r00004af900000000

checkpointid->[dbo].[mdb_checkpoint].[checkpointid]

$mdb_p_r00004b0d00000000

servicepacknumber->[dbo].[mdb_service_pack].[servicepacknumber]

Type	Action	Owning Principal
Grant	Select	public
Grant	Select	ca_itrm_group
Grant	Select	udmadmin_group
Grant	Select	ca_itrm_group_ams
Grant	Select	cicuser

Type

Action

Owning Principal

Grant

Select

public

Grant

Select

ca_itrm_group

Grant

Select

udmadmin_group

Grant

Select

ca_itrm_group_ams

Grant

Select

cicuser

SQL Script

CREATE TABLE [dbo].[mdb_patch]
(
[patchnumber] [int] NOT NULL,
[installdate] [datetime] NULL,
[servicepacknumber] [int] NULL,
[mdbmajorversion] [int] NULL,
[mdbminorversion] [int] NULL,
[checkpointid] [int] NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[mdb_patch] ADD CONSTRAINT [$mdb_p_u00004af300000000] PRIMARY KEY CLUSTERED ([patchnumber]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[mdb_patch] ADD CONSTRAINT [$mdb_p_r00004af900000000] FOREIGN KEY ([checkpointid]) REFERENCES [dbo].[mdb_checkpoint] ([checkpointid])
GO
ALTER TABLE [dbo].[mdb_patch] ADD CONSTRAINT [$mdb_p_r00004b0d00000000] FOREIGN KEY ([servicepacknumber]) REFERENCES [dbo].[mdb_service_pack] ([servicepacknumber])
GO
GRANT SELECT ON  [dbo].[mdb_patch] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[mdb_patch] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[mdb_patch] TO [cicuser]
GRANT SELECT ON  [dbo].[mdb_patch] TO [public]
GRANT SELECT ON  [dbo].[mdb_patch] TO [udmadmin_group]
GO