[dbo].[clone]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:06 AM Wednesday, March 07, 2007
Last Modified	11:09:35 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
cloneid	int	4
templateid	int	4
name	varchar(255)	255
parentregionid	int	4
parentboxid	int	4
cloneleft	int	4
cloneright	int	4
clonetop	int	4
clonebottom	int	4
lastsynctime	int	4
checkoutsid	varchar(100)	100
checkoutname	varchar(100)	100
instancename	varchar(8)	8
owner	varchar(255)	255
description	varchar(255)	255
psname	varchar(255)	255

Name	Columns	Unique
baseidx_clone	cloneid

SQL Script

CREATE TABLE [dbo].[clone]
(
[cloneid] [int] NOT NULL,
[templateid] [int] NULL,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[parentregionid] [int] NULL,
[parentboxid] [int] NULL,
[cloneleft] [int] NULL,
[cloneright] [int] NULL,
[clonetop] [int] NULL,
[clonebottom] [int] NULL,
[lastsynctime] [int] NULL,
[checkoutsid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[checkoutname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[instancename] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[owner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[psname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_clone] ON [dbo].[clone] ([cloneid]) ON [PRIMARY]
GO