CREATE TABLE [dbo].[region]
(
[regionid] [int] NOT NULL,
[regionname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[instancename] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[regionowner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[parentregionid] [int] NULL,
[regiontype] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[parentboxid] [int] NULL,
[namingstandard] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rgnleft] [int] NOT NULL,
[rgnright] [int] NOT NULL,
[rgntop] [int] NOT NULL,
[rgnbottom] [int] NOT 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,
[cloneid] [int] NULL,
[templateregionid] [int] NULL,
[psname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[autosysregion] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [region_idx_04] ON [dbo].[region] ([parentboxid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [region_idx_03] ON [dbo].[region] ([parentregionid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_region] ON [dbo].[region] ([regionid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [region_idx_01] ON [dbo].[region] ([regionname], [instancename]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [region_idx_02] ON [dbo].[region] ([regiontype]) ON [PRIMARY]
GO