DROP INDEX IF EXISTS VCLib.UIX_T_ENTITIES_EntName_Schema;
CREATE UNIQUE INDEX UIX_T_ENTITIES_EntName_Schema ON VCLib.T_ENTITIES (EntName,	"schema");

DROP INDEX IF EXISTS VCLib.UIX_T_LOGIN_Login_AuthenticationType;
create unique index UIX_T_LOGIN_Login_AuthenticationType on vclib.t_login (lower("login"),	AuthenticationType);

DROP INDEX IF EXISTS VCLib.UIX_T_WEB_APP_Name;
CREATE UNIQUE INDEX UIX_T_WEB_APP_Name ON VCLib.T_WEB_APP ( Name ASC );

DROP INDEX IF EXISTS VCLib.UIX_T_ENTITIES_WEB_ALIAS_Alias_WebApp;
CREATE UNIQUE INDEX UIX_T_ENTITIES_WEB_ALIAS_Alias_WebApp ON VCLib.T_ENTITIES_WEB_ALIAS ( Alias ASC, WebApp ASC );

DROP INDEX IF EXISTS VCLib.UIX_T_DTO_MODEL_WebApp_Entities_Name;
CREATE UNIQUE INDEX UIX_T_DTO_MODEL_WebApp_Entities_Name ON VCLib.T_DTO_MODEL ( Entities ASC, Name ASC, WebApp ASC );

DROP INDEX IF EXISTS VCLib.UIX_T_SHORTCUTCOMMAND_UserId_CommandName_FormType_Context;
create unique index UIX_T_SHORTCUTCOMMAND_UserId_CommandName_FormType_Context on VCLib.T_SHORTCUTCOMMAND (UserId, CommandName, FormType, Context);

DROP INDEX IF EXISTS VCLib.UIX_T_HOLDER_PARAMETER_Holder_ParameterName;
create unique index UIX_T_HOLDER_PARAMETER_Holder_ParameterName on VCLib.T_HOLDER_PARAMETER (Holder ASC, ParameterName ASC);

DROP INDEX IF EXISTS VCLib.UIX_T_MACHINE_CONFIG_MachineName;
CREATE UNIQUE INDEX UIX_T_MACHINE_CONFIG_MachineName ON VCLib.T_MACHINE_CONFIG ( MachineName ASC );
