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); }