static int DBcreate_dbversion_table(void)
{
const ZBX_TABLE table =
{"dbversion", "", 0,
{
{"mandatory", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0},
{"optional", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0},
{NULL}
}
};
int ret;
DBbegin();
if (SUCCEED == (ret = DBcreate_table(&table)))
{
if (ZBX_DB_OK > DBexecute("insert into dbversion (mandatory,optional) values (%d,%d)",
ZBX_FIRST_DB_VERSION, ZBX_FIRST_DB_VERSION))
{
ret = FAIL;
}
}
DBend(ret);
return ret;
}
static int DBpatch_2010164(void)
{
const ZBX_TABLE table =
{"interface_discovery", "interfaceid", 0,
{
{"interfaceid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"parent_interfaceid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{NULL}
}
};
return DBcreate_table(&table);
}
static int DBpatch_2030005(void)
{
const ZBX_TABLE table =
{"trigger_discovery", "triggerid", 0,
{
{"triggerid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"parent_triggerid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{0}
},
NULL
};
return DBcreate_table(&table);
}
static int DBpatch_2030012(void)
{
const ZBX_TABLE table =
{"graph_discovery_tmp", "", 0,
{
{"graphid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"parent_graphid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{0}
},
NULL
};
return DBcreate_table(&table);
}
static int DBpatch_2010076(void)
{
const ZBX_TABLE table =
{"application_template", "application_templateid", 0,
{
{"application_templateid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"applicationid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"templateid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{NULL}
},
NULL
};
return DBcreate_table(&table);
}
static int DBpatch_2030040(void)
{
const ZBX_TABLE table =
{"ids", "table_name,field_name", 0,
{
{"table_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{"field_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{"nextid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{0}
},
NULL
};
return DBcreate_table(&table);
}
static int DBpatch_2010172(void)
{
const ZBX_TABLE table =
{"group_discovery", "groupid", 0,
{
{"groupid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"parent_group_prototypeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{"lastcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0},
{"ts_delete", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0},
{NULL}
}
};
return DBcreate_table(&table);
}
static int DBpatch_2010167(void)
{
const ZBX_TABLE table =
{"group_prototype", "group_prototypeid", 0,
{
{"group_prototypeid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"hostid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{"groupid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, 0, 0},
{"templateid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, 0, 0},
{NULL}
}
};
return DBcreate_table(&table);
}
static int DBpatch_2030021(void)
{
const ZBX_TABLE table =
{"item_condition", "item_conditionid", 0,
{
{"item_conditionid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"itemid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"operator", "8", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0},
{"macro", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{"value", "", NULL, NULL, 255, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{NULL}
}
};
return DBcreate_table(&table);
}
static int DBpatch_2010158(void)
{
const ZBX_TABLE table =
{"host_discovery", "hostid", 0,
{
{"hostid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{"parent_hostid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, 0, 0},
{"parent_itemid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, 0, 0},
{"host", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{"lastcheck", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0},
{"ts_delete", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0},
{NULL}
}
};
return DBcreate_table(&table);
}
static int DBpatch_2030037(void)
{
const ZBX_TABLE table =
{"ids_tmp", "", 0,
{
{"table_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{"field_name", "", NULL, NULL, 64, ZBX_TYPE_CHAR, ZBX_NOTNULL, 0},
{"nextid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0},
{0}
},
NULL
};
if (ZBX_PROGRAM_TYPE_SERVER == program_type)
return SUCCEED;
return DBcreate_table(&table);
}
