[dbo].[mdb_version]

Property	Value
Row Count	1
Created	9:07:33 PM Friday, December 05, 2008
Last Modified	9:07:33 PM Friday, December 05, 2008

Property

Value

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_mdb_version: mdbmajorversion\mdbminorversion$	mdbmajorversion	int	4
$Cluster Primary Key pk_mdb_version: mdbmajorversion\mdbminorversion$	mdbminorversion	int	4
	buildnumber	int	4
	releasedate	datetime	8
	installdate	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_mdb_version: mdbmajorversion\mdbminorversion$

mdbmajorversion

int

$Cluster Primary Key pk_mdb_version: mdbmajorversion\mdbminorversion$

mdbminorversion

int

buildnumber

int

releasedate

datetime

installdate

datetime

	Name	Columns	Unique
$Cluster Primary Key pk_mdb_version: mdbmajorversion\mdbminorversion$	pk_mdb_version	mdbmajorversion, mdbminorversion

Name

Columns

Unique

$Cluster Primary Key pk_mdb_version: mdbmajorversion\mdbminorversion$

pk_mdb_version

mdbmajorversion, mdbminorversion

Type	Action	Owning Principal
Grant	Select	public
Grant	Select	ca_itrm_group
Grant	Select	upmuser_group
Grant	Select	ca_itrm_group_ams

Type

Action

Owning Principal

Grant

Select

public

Grant

Select

ca_itrm_group

Grant

Select

upmuser_group

Grant

Select

ca_itrm_group_ams

SQL Script

CREATE TABLE [dbo].[mdb_version]
(
[mdbmajorversion] [int] NOT NULL,
[mdbminorversion] [int] NOT NULL,
[buildnumber] [int] NOT NULL,
[releasedate] [datetime] NOT NULL,
[installdate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[mdb_version] ADD CONSTRAINT [pk_mdb_version] PRIMARY KEY CLUSTERED ([mdbmajorversion], [mdbminorversion]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[mdb_version] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[mdb_version] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[mdb_version] TO [public]
GRANT SELECT ON  [dbo].[mdb_version] TO [upmuser_group]
GO