static int DBpatch_2030087(void)
{
if (SUCCEED != check_data_uniqueness("usrgrp", "name"))
return FAIL;
return DBcreate_index("usrgrp", "usrgrp_1", "name", 1);
}
static int DBpatch_2030081(void)
{
if (SUCCEED != check_data_uniqueness("scripts", "name"))
return FAIL;
return DBcreate_index("scripts", "scripts_3", "name", 1);
}
static int DBpatch_2030083(void)
{
if (SUCCEED != check_data_uniqueness("slideshows", "name"))
return FAIL;
return DBcreate_index("slideshows", "slideshows_1", "name", 1);
}
static int DBpatch_2030077(void)
{
if (SUCCEED != check_data_uniqueness("maintenances", "name"))
return FAIL;
return DBcreate_index("maintenances", "maintenances_2", "name", 1);
}
static int DBpatch_2030078(void)
{
if (SUCCEED != check_data_uniqueness("media_type", "description"))
return FAIL;
return DBcreate_index("media_type", "media_type_1", "description", 1);
}
static int DBpatch_2030076(void)
{
if (SUCCEED != check_data_uniqueness("images", "name"))
return FAIL;
return DBcreate_index("images", "images_1", "name", 1);
}
static int DBpatch_2030072(void)
{
if (SUCCEED != check_data_uniqueness("graph_theme", "description"))
return FAIL;
return DBcreate_index("graph_theme", "graph_theme_1", "description", 1);
}
static int DBpatch_2030070(void)
{
if (SUCCEED != check_data_uniqueness("globalmacro", "macro"))
return FAIL;
return DBcreate_index("globalmacro", "globalmacro_1", "macro", 1);
}
static int DBpatch_2030089(void)
{
if (SUCCEED != check_data_uniqueness("users", "alias"))
return FAIL;
return DBcreate_index("users", "users_1", "alias", 1);
}
static int DBpatch_2030091(void)
{
if (SUCCEED != check_data_uniqueness("valuemaps", "name"))
return FAIL;
return DBcreate_index("valuemaps", "valuemaps_1", "name", 1);
}
static int DBpatch_2030067(void)
{
if (SUCCEED != check_data_uniqueness("actions", "name"))
return FAIL;
return DBcreate_index("actions", "actions_2", "name", 1);
}
static int DBpatch_2030068(void)
{
if (0 != (program_type & ZBX_PROGRAM_TYPE_PROXY))
{
/* "name" is empty on proxy side, because it is not synchronized between server and proxy */
/* in 2.2, and should therefore be filled with unique values to create a unique index. */
if (ZBX_DB_OK > DBexecute("update drules set name=druleid"))
return FAIL;
}
if (SUCCEED != check_data_uniqueness("drules", "name"))
return FAIL;
return DBcreate_index("drules", "drules_2", "name", 1);
}
static int DBpatch_2010145(void)
{
return DBcreate_index("item_discovery", "item_discovery_2", "parent_itemid", 0);
}
static int DBpatch_2010144(void)
{
return DBcreate_index("graph_discovery", "graph_discovery_2", "parent_graphid", 0);
}
static int DBpatch_2010143(void)
{
return DBcreate_index("nodes", "nodes_1", "masterid", 0);
}
static int DBpatch_2010142(void)
{
return DBcreate_index("maintenances_windows", "maintenances_windows_2", "timeperiodid", 0);
}
static int DBpatch_2010141(void)
{
return DBcreate_index("maintenances_groups", "maintenances_groups_2", "groupid", 0);
}
static int DBpatch_2010140(void)
{
return DBcreate_index("maintenances_hosts", "maintenances_hosts_2", "hostid", 0);
}
static int DBpatch_2010049(void)
{
return DBcreate_index("escalations", "escalations_1", "actionid,triggerid,itemid,escalationid", 1);
}
static int DBpatch_2010015(void)
{
return DBcreate_index("httptest", "httptest_2", "hostid,name", 1);
}
static int DBpatch_2010171(void)
{
return DBcreate_index("group_prototype", "group_prototype_1", "hostid", 0);
}
static int DBpatch_2010146(void)
{
return DBcreate_index("trigger_discovery", "trigger_discovery_2", "parent_triggerid", 0);
}
static int DBpatch_2010147(void)
{
return DBcreate_index("application_template", "application_template_2", "templateid", 0);
}
static int DBpatch_2010135(void)
{
return DBcreate_index("sysmaps_elements", "sysmaps_elements_5", "iconid_maintenance", 0);
}
static int DBpatch_2010191(void)
{
return DBcreate_index("events", "events_2", "source,object,clock", 0);
}
static int DBpatch_2010136(void)
{
return DBcreate_index("sysmaps_links", "sysmaps_links_1", "sysmapid", 0);
}
static int DBpatch_2010016(void)
{
return DBcreate_index("httptest", "httptest_4", "templateid", 0);
}
static int DBpatch_2010138(void)
{
return DBcreate_index("sysmaps_links", "sysmaps_links_3", "selementid2", 0);
}
static int DBpatch_2010077(void)
{
return DBcreate_index("application_template", "application_template_1", "applicationid,templateid", 1);
}
static int DBpatch_2010139(void)
{
return DBcreate_index("sysmaps_link_triggers", "sysmaps_link_triggers_2", "triggerid", 0);
}