Zabbix
Public
Source
FIELD |userdirectory_mediaid |t_id |NULL |NULL |ZBX_NODATA |3|userdirectory_media |userdirectory_mediaid---- Copyright (C) 2001-2025 Zabbix SIA---- This program is free software: you can redistribute it and/or modify it under the terms of-- the GNU Affero General Public License as published by the Free Software Foundation, version 3.---- This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;-- without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.-- See the GNU Affero General Public License for more details.---- You should have received a copy of the GNU Affero General Public License along with this program.-- If not, see <https://www.gnu.org/licenses/>.------ Do not use spaces-- Tables must be sorted to match referential integrity rules--TABLE|role|roleid|ZBX_DATAFIELD |roleid |t_id | |NOT NULL |0FIELD |name |t_varchar(255) |'' |NOT NULL |0FIELD |type |t_integer |'0' |NOT NULL |0FIELD |readonly |t_integer |'0' |NOT NULL |0UNIQUE |1 |nameTABLE|ugset|ugsetid|ZBX_DATAFIELD |ugsetid |t_id | |NOT NULL |0FIELD |hash |t_varchar(64) |'' |NOT NULL |0INDEX |1 |hashTABLE|users|userid|ZBX_DATAFIELD |userid |t_id | |NOT NULL |0FIELD |username |t_varchar(100) |'' |NOT NULL |0FIELD |name |t_varchar(100) |'' |NOT NULL |0FIELD |surname |t_varchar(100) |'' |NOT NULL |0FIELD |passwd |t_varchar(60) |'' |NOT NULL |0FIELD |url |t_varchar(2048)|'' |NOT NULL |0FIELD |autologin |t_integer |'0' |NOT NULL |0FIELD |autologout |t_varchar(32) |'15m' |NOT NULL |0FIELD |lang |t_varchar(7) |'default'|NOT NULL |ZBX_NODATAFIELD |refresh |t_varchar(32) |'30s' |NOT NULL |0FIELD |theme |t_varchar(128) |'default'|NOT NULL |ZBX_NODATAFIELD |attempt_failed |t_integer |0 |NOT NULL |ZBX_NODATAFIELD |attempt_ip |t_varchar(39) |'' |NOT NULL |ZBX_NODATAFIELD |attempt_clock |t_integer |0 |NOT NULL |ZBX_NODATAFIELD |rows_per_page |t_integer |50 |NOT NULL |0FIELD |timezone |t_varchar(50) |'default'|NOT NULL |ZBX_NODATAFIELD |roleid |t_id |NULL |NULL |0 |1|roleFIELD |userdirectoryid |t_id |NULL |NULL |ZBX_NODATA |2|userdirectory |userdirectoryid |RESTRICTFIELD |ts_provisioned |t_time |'0' |NOT NULL |ZBX_NODATAUNIQUE |1 |usernameINDEX |2 |userdirectoryidINDEX |3 |roleidTABLE|maintenances|maintenanceid|ZBX_DATAFIELD |maintenanceid |t_id | |NOT NULL |0FIELD |name |t_varchar(128) |'' |NOT NULL |0FIELD |maintenance_type|t_integer |'0' |NOT NULL |0FIELD |description |t_shorttext |'' |NOT NULL |0FIELD |active_since |t_integer |'0' |NOT NULL |0FIELD |active_till |t_integer |'0' |NOT NULL |0FIELD |tags_evaltype |t_integer |'0' |NOT NULL |0INDEX |1 |active_since,active_tillUNIQUE |2 |nameTABLE|hgset|hgsetid|ZBX_TEMPLATEFIELD |hgsetid |t_id | |NOT NULL |0FIELD |hash |t_varchar(64) |'' |NOT NULL |0INDEX |1 |hashTABLE|hosts|hostid|ZBX_TEMPLATEFIELD |hostid |t_id | |NOT NULL |0FIELD |proxyid |t_id | |NULL |0 |1|proxy |proxyid |RESTRICTFIELD |host |t_varchar(128) |'' |NOT NULL |ZBX_PROXYFIELD |status |t_integer |'0' |NOT NULL |ZBX_PROXYFIELD |ipmi_authtype |t_integer |'-1' |NOT NULL |ZBX_PROXYFIELD |ipmi_privilege |t_integer |'2' |NOT NULL |ZBX_PROXYFIELD |ipmi_username |t_varchar(16) |'' |NOT NULL |ZBX_PROXYFIELD |ipmi_password |t_varchar(20) |'' |NOT NULL |ZBX_PROXYFIELD |maintenanceid |t_id | |NULL |ZBX_NODATA |2|maintenances | |RESTRICTFIELD |maintenance_status|t_integer |'0' |NOT NULL |ZBX_NODATAFIELD |maintenance_type|t_integer |'0' |NOT NULL |ZBX_NODATAFIELD |maintenance_from|t_integer |'0' |NOT NULL |ZBX_NODATAFIELD |name |t_varchar(128) |'' |NOT NULL |ZBX_PROXYFIELD |flags |t_integer |'0' |NOT NULL |0FIELD |templateid |t_id | |NULL |0 |3|hosts |hostid |RESTRICTFIELD |description |t_shorttext |'' |NOT NULL |0FIELD |tls_connect |t_integer |'1' |NOT NULL |ZBX_PROXYFIELD |tls_accept |t_integer |'1' |NOT NULL |ZBX_PROXYFIELD |tls_issuer |t_varchar(1024)|'' |NOT NULL |ZBX_PROXY