[dbo].[CMSPERSONALIZATIONDATA]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:13:48 AM Wednesday, March 07, 2007
Last Modified	11:13:52 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:13:48 AM Wednesday, March 07, 2007

Last Modified

11:13:52 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
	UECHECKEDOUT	int	4
	UECHECKEDOUTTIME	datetime	8
$Cluster Primary Key UE107d798c7e2: UEDBID\UEPORINSTANCEID$	UEDBID	int	4
	UEMODTIME	datetime	8
	UENUMEMPTYREQUIRED	int	4
$Cluster Primary Key UE107d798c7e2: UEDBID\UEPORINSTANCEID$	UEPORINSTANCEID	nvarchar(255)	510
	UEPUBSTAGE	int	4
	UEPUBTIME	datetime	8
	UEATTRIBUTENAME	varchar(255)	255
	UEBOOLEANVALUE	bit	1
	UEDATACOLUMNNAME	varchar(255)	255
	UEDBIDLVALUE	varchar(1000)	1000
	UEDBIDVALUE	int	4
	UEINTVALUE	int	4
	UETEXTSTORYVALUE	varchar(8000)	8000
	UETEXTVALUE	varchar(255)	255
	UEUSERDBID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

UECHECKEDOUT

int

UECHECKEDOUTTIME

datetime

$Cluster Primary Key UE107d798c7e2: UEDBID\UEPORINSTANCEID$

UEDBID

int

UEMODTIME

datetime

UENUMEMPTYREQUIRED

int

$Cluster Primary Key UE107d798c7e2: UEDBID\UEPORINSTANCEID$

UEPORINSTANCEID

nvarchar(255)

510

UEPUBSTAGE

int

UEPUBTIME

datetime

UEATTRIBUTENAME

varchar(255)

255

UEBOOLEANVALUE

bit

UEDATACOLUMNNAME

varchar(255)

255

UEDBIDLVALUE

varchar(1000)

1000

UEDBIDVALUE

int

UEINTVALUE

int

UETEXTSTORYVALUE

varchar(8000)

8000

UETEXTVALUE

varchar(255)

255

UEUSERDBID

int

	Name	Columns	Unique
$Cluster Primary Key UE107d798c7e2: UEDBID\UEPORINSTANCEID$	UE107d798c7e2	UEDBID, UEPORINSTANCEID

Name

Columns

Unique

$Cluster Primary Key UE107d798c7e2: UEDBID\UEPORINSTANCEID$

UE107d798c7e2

UEDBID, UEPORINSTANCEID

Type	Action	Owning Principal
Grant	Delete	portaldba_group
Grant	Insert	portaldba_group
Grant	Select	portaldba_group
Grant	Update	portaldba_group

Type

Action

Owning Principal

Grant

Delete

portaldba_group

Grant

Insert

portaldba_group

Grant

Select

portaldba_group

Grant

Update

portaldba_group

SQL Script

CREATE TABLE [dbo].[CMSPERSONALIZATIONDATA]
(
[UECHECKEDOUT] [int] NULL,
[UECHECKEDOUTTIME] [datetime] NULL,
[UEDBID] [int] NOT NULL,
[UEMODTIME] [datetime] NULL,
[UENUMEMPTYREQUIRED] [int] NULL,
[UEPORINSTANCEID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UEPUBSTAGE] [int] NULL,
[UEPUBTIME] [datetime] NULL,
[UEATTRIBUTENAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UEBOOLEANVALUE] [bit] NULL,
[UEDATACOLUMNNAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEDBIDLVALUE] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEDBIDVALUE] [int] NULL,
[UEINTVALUE] [int] NULL,
[UETEXTSTORYVALUE] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UETEXTVALUE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEUSERDBID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CMSPERSONALIZATIONDATA] ADD CONSTRAINT [UE107d798c7e2] PRIMARY KEY CLUSTERED ([UEDBID], [UEPORINSTANCEID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[CMSPERSONALIZATIONDATA] TO [portaldba_group]
GRANT INSERT ON  [dbo].[CMSPERSONALIZATIONDATA] TO [portaldba_group]
GRANT DELETE ON  [dbo].[CMSPERSONALIZATIONDATA] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[CMSPERSONALIZATIONDATA] TO [portaldba_group]
GO