[dbo].[harversiondelta]

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

Property

Value

Row Count

Created

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

Last Modified

11:09:57 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKharversiondelta: childversiondataid\parentversiondataid$	childversiondataid	int	4
$Cluster Primary Key XPKharversiondelta: childversiondataid\parentversiondataid$	parentversiondataid	int	4
	deltasize	int	4
	versiondelta	image	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKharversiondelta: childversiondataid\parentversiondataid$

childversiondataid

int

$Cluster Primary Key XPKharversiondelta: childversiondataid\parentversiondataid$

parentversiondataid

int

deltasize

int

versiondelta

image

max

	Name	Columns	Unique
$Cluster Primary Key XPKharversiondelta: childversiondataid\parentversiondataid$	XPKharversiondelta	childversiondataid, parentversiondataid
	harversiondelta_parent	parentversiondataid

Name

Columns

Unique

$Cluster Primary Key XPKharversiondelta: childversiondataid\parentversiondataid$

XPKharversiondelta

childversiondataid, parentversiondataid

harversiondelta_parent

parentversiondataid

Name	Delete	Columns
HARVERSIONDELTA_CHIDID_FK	Cascade	childversiondataid->[dbo].[harversiondata].[versiondataobjid]

Name

Delete

Columns

HARVERSIONDELTA_CHIDID_FK

Cascade

childversiondataid->[dbo].[harversiondata].[versiondataobjid]

Type	Action	Owning Principal
Grant	Delete	harvest_group
Grant	Insert	harvest_group
Grant	Select	harvest_group
Grant	Update	harvest_group
Grant	Select	harvest_rep

Type

Action

Owning Principal

Grant

Delete

harvest_group

Grant

Insert

harvest_group

Grant

Select

harvest_group

Grant

Update

harvest_group

Grant

Select

harvest_rep

SQL Script

CREATE TABLE [dbo].[harversiondelta]
(
[childversiondataid] [int] NOT NULL,
[parentversiondataid] [int] NOT NULL,
[deltasize] [int] NOT NULL,
[versiondelta] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[harversiondelta] ADD CONSTRAINT [XPKharversiondelta] PRIMARY KEY CLUSTERED ([childversiondataid], [parentversiondataid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [harversiondelta_parent] ON [dbo].[harversiondelta] ([parentversiondataid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harversiondelta] ADD CONSTRAINT [HARVERSIONDELTA_CHIDID_FK] FOREIGN KEY ([childversiondataid]) REFERENCES [dbo].[harversiondata] ([versiondataobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harversiondelta] TO [harvest_group]
GRANT INSERT ON  [dbo].[harversiondelta] TO [harvest_group]
GRANT DELETE ON  [dbo].[harversiondelta] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harversiondelta] TO [harvest_group]
GRANT SELECT ON  [dbo].[harversiondelta] TO [harvest_rep]
GO