CREATE TABLE [dbo].[INFOTXT]
(
[DOMAINID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[ITPRID] [int] NOT NULL,
[ITNAMEID] [int] NOT NULL,
[ITROOTID] [int] NULL,
[ITRTNMID] [int] NULL,
[ITPRNMID] [int] NULL,
[ITIDX] [int] NULL,
[ITTYPE] [int] NULL,
[ITVAL] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITPVAL] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITDATE] [int] NULL,
[ITLOCK] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[INFOTXT] ADD CONSTRAINT [INFOTXT_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [ITPRID], [ITNAMEID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOTXT_SK2] ON [dbo].[INFOTXT] ([ITNAMEID], [ITPRNMID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOTXT_SK6] ON [dbo].[INFOTXT] ([ITROOTID], [ITPRNMID], [ITDATE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOTXT_SK3] ON [dbo].[INFOTXT] ([ITROOTID], [ITRTNMID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOTXT_SK1] ON [dbo].[INFOTXT] ([ITVAL]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [INFOTXT_SK5] ON [dbo].[INFOTXT] ([UNITID]) ON [PRIMARY]
GO