CREATE UNIQUE INDEX [UIX_T_WEB_APP_Name] ON [VCLib].[T_WEB_APP] ( [Name] ASC )
go

CREATE UNIQUE INDEX [UIX_T_ENTITIES_WEB_ALIAS_Alias_WebApp] ON [VCLib].[T_ENTITIES_WEB_ALIAS] ( [Alias] ASC, [WebApp] ASC)
go

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[VCLib].[T_DTO_MODEL]') AND name = N'IX_T_DTO_MODEL_Entities_Name_uq')
DROP INDEX [IX_T_DTO_MODEL_Entities_Name_uq] ON [VCLib].[T_DTO_MODEL]
GO
CREATE UNIQUE INDEX [UIX_T_DTO_MODEL_WebApp_Entities_Name] ON [VCLib].[T_DTO_MODEL] ( [Entities] ASC, [Name] ASC, [WebApp] ASC )
go
