Home
last modified time | relevance | path

Searched refs:t_host_inventory (Results 1 – 20 of 20) sorted by relevance

/dports/net-mgmt/zabbix3-proxy/zabbix-3.0.32/upgrades/dbpatches/2.0/postgresql/
H A Dpatch.sql518 CREATE TABLE t_host_inventory ( table
595 INSERT INTO t_host_inventory
623 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
625 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
626 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
627 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
632 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
649 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
651 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
698 ALTER TABLE ONLY t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-java/zabbix-3.0.32/upgrades/dbpatches/2.0/postgresql/
H A Dpatch.sql518 CREATE TABLE t_host_inventory ( table
595 INSERT INTO t_host_inventory
623 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
625 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
626 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
627 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
632 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
649 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
651 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
698 ALTER TABLE ONLY t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-server/zabbix-3.0.32/upgrades/dbpatches/2.0/postgresql/
H A Dpatch.sql518 CREATE TABLE t_host_inventory ( table
595 INSERT INTO t_host_inventory
623 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
625 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
626 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
627 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
632 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
649 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
651 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
698 ALTER TABLE ONLY t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-agent/zabbix-3.0.32/upgrades/dbpatches/2.0/postgresql/
H A Dpatch.sql518 CREATE TABLE t_host_inventory ( table
595 INSERT INTO t_host_inventory
623 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
625 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
626 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
627 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
632 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
649 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
651 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
698 ALTER TABLE ONLY t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-frontend/zabbix-3.0.32/upgrades/dbpatches/2.0/postgresql/
H A Dpatch.sql518 CREATE TABLE t_host_inventory ( table
595 INSERT INTO t_host_inventory
623 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
625 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
626 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
627 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
632 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
649 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
651 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
698 ALTER TABLE ONLY t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-proxy/zabbix-3.0.32/upgrades/dbpatches/2.0/mysql/
H A Dpatch.sql512 CREATE TABLE t_host_inventory ( table
589 INSERT INTO t_host_inventory
617 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
619 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
620 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
621 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
626 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
643 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
645 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
692 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-java/zabbix-3.0.32/upgrades/dbpatches/2.0/mysql/
H A Dpatch.sql512 CREATE TABLE t_host_inventory ( table
589 INSERT INTO t_host_inventory
617 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
619 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
620 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
621 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
626 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
643 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
645 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
692 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-frontend/zabbix-3.0.32/upgrades/dbpatches/2.0/mysql/
H A Dpatch.sql512 CREATE TABLE t_host_inventory ( table
589 INSERT INTO t_host_inventory
617 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
619 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
620 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
621 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
626 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
643 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
645 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
692 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-server/zabbix-3.0.32/upgrades/dbpatches/2.0/mysql/
H A Dpatch.sql512 CREATE TABLE t_host_inventory ( table
589 INSERT INTO t_host_inventory
617 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
619 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
620 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
621 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
626 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
643 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
645 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
692 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-agent/zabbix-3.0.32/upgrades/dbpatches/2.0/mysql/
H A Dpatch.sql512 CREATE TABLE t_host_inventory ( table
589 INSERT INTO t_host_inventory
617 UPDATE t_host_inventory SET type='' WHERE type IS NULL;
619 UPDATE t_host_inventory SET name='' WHERE name IS NULL;
620 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL;
621 UPDATE t_host_inventory SET os='' WHERE os IS NULL;
626 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL;
643 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL;
645 UPDATE t_host_inventory SET model='' WHERE model IS NULL;
692 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
[all …]
/dports/net-mgmt/zabbix3-proxy/zabbix-3.0.32/upgrades/dbpatches/2.0/ibm_db2/
H A Dpatch.sql1188 CREATE TABLE t_host_inventory ( table
1266 INSERT INTO t_host_inventory
1295 UPDATE t_host_inventory SET type='' WHERE type IS NULL
1299 UPDATE t_host_inventory SET name='' WHERE name IS NULL
1301 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL
1303 UPDATE t_host_inventory SET os='' WHERE os IS NULL
1313 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL
1347 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL
1443 ALTER TABLE t_host_inventory DROP COLUMN notes_ext
1445 REORG TABLE t_host_inventory
[all …]
/dports/net-mgmt/zabbix3-frontend/zabbix-3.0.32/upgrades/dbpatches/2.0/ibm_db2/
H A Dpatch.sql1188 CREATE TABLE t_host_inventory ( table
1266 INSERT INTO t_host_inventory
1295 UPDATE t_host_inventory SET type='' WHERE type IS NULL
1299 UPDATE t_host_inventory SET name='' WHERE name IS NULL
1301 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL
1303 UPDATE t_host_inventory SET os='' WHERE os IS NULL
1313 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL
1347 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL
1443 ALTER TABLE t_host_inventory DROP COLUMN notes_ext
1445 REORG TABLE t_host_inventory
[all …]
/dports/net-mgmt/zabbix3-java/zabbix-3.0.32/upgrades/dbpatches/2.0/ibm_db2/
H A Dpatch.sql1188 CREATE TABLE t_host_inventory ( table
1266 INSERT INTO t_host_inventory
1295 UPDATE t_host_inventory SET type='' WHERE type IS NULL
1299 UPDATE t_host_inventory SET name='' WHERE name IS NULL
1301 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL
1303 UPDATE t_host_inventory SET os='' WHERE os IS NULL
1313 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL
1347 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL
1443 ALTER TABLE t_host_inventory DROP COLUMN notes_ext
1445 REORG TABLE t_host_inventory
[all …]
/dports/net-mgmt/zabbix3-server/zabbix-3.0.32/upgrades/dbpatches/2.0/ibm_db2/
H A Dpatch.sql1188 CREATE TABLE t_host_inventory ( table
1266 INSERT INTO t_host_inventory
1295 UPDATE t_host_inventory SET type='' WHERE type IS NULL
1299 UPDATE t_host_inventory SET name='' WHERE name IS NULL
1301 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL
1303 UPDATE t_host_inventory SET os='' WHERE os IS NULL
1313 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL
1347 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL
1443 ALTER TABLE t_host_inventory DROP COLUMN notes_ext
1445 REORG TABLE t_host_inventory
[all …]
/dports/net-mgmt/zabbix3-agent/zabbix-3.0.32/upgrades/dbpatches/2.0/ibm_db2/
H A Dpatch.sql1188 CREATE TABLE t_host_inventory ( table
1266 INSERT INTO t_host_inventory
1295 UPDATE t_host_inventory SET type='' WHERE type IS NULL
1299 UPDATE t_host_inventory SET name='' WHERE name IS NULL
1301 UPDATE t_host_inventory SET alias='' WHERE alias IS NULL
1303 UPDATE t_host_inventory SET os='' WHERE os IS NULL
1313 UPDATE t_host_inventory SET tag='' WHERE tag IS NULL
1347 UPDATE t_host_inventory SET notes='' WHERE notes IS NULL
1443 ALTER TABLE t_host_inventory DROP COLUMN notes_ext
1445 REORG TABLE t_host_inventory
[all …]
/dports/net-mgmt/zabbix3-proxy/zabbix-3.0.32/upgrades/dbpatches/2.0/oracle/
H A Dpatch.sql513 CREATE TABLE t_host_inventory ( table
590 INSERT INTO t_host_inventory
619 UPDATE t_host_inventory SET notes = notes||CHR(13)||CHR(10)||notes_ext WHERE notes IS NOT NULL AND …
620 UPDATE t_host_inventory SET notes = notes_ext WHERE notes IS NULL;
621 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
624 INSERT INTO host_inventory SELECT * FROM t_host_inventory;
626 DROP TABLE t_host_inventory;
/dports/net-mgmt/zabbix3-java/zabbix-3.0.32/upgrades/dbpatches/2.0/oracle/
H A Dpatch.sql513 CREATE TABLE t_host_inventory ( table
590 INSERT INTO t_host_inventory
619 UPDATE t_host_inventory SET notes = notes||CHR(13)||CHR(10)||notes_ext WHERE notes IS NOT NULL AND …
620 UPDATE t_host_inventory SET notes = notes_ext WHERE notes IS NULL;
621 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
624 INSERT INTO host_inventory SELECT * FROM t_host_inventory;
626 DROP TABLE t_host_inventory;
/dports/net-mgmt/zabbix3-frontend/zabbix-3.0.32/upgrades/dbpatches/2.0/oracle/
H A Dpatch.sql513 CREATE TABLE t_host_inventory ( table
590 INSERT INTO t_host_inventory
619 UPDATE t_host_inventory SET notes = notes||CHR(13)||CHR(10)||notes_ext WHERE notes IS NOT NULL AND …
620 UPDATE t_host_inventory SET notes = notes_ext WHERE notes IS NULL;
621 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
624 INSERT INTO host_inventory SELECT * FROM t_host_inventory;
626 DROP TABLE t_host_inventory;
/dports/net-mgmt/zabbix3-server/zabbix-3.0.32/upgrades/dbpatches/2.0/oracle/
H A Dpatch.sql513 CREATE TABLE t_host_inventory ( table
590 INSERT INTO t_host_inventory
619 UPDATE t_host_inventory SET notes = notes||CHR(13)||CHR(10)||notes_ext WHERE notes IS NOT NULL AND …
620 UPDATE t_host_inventory SET notes = notes_ext WHERE notes IS NULL;
621 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
624 INSERT INTO host_inventory SELECT * FROM t_host_inventory;
626 DROP TABLE t_host_inventory;
/dports/net-mgmt/zabbix3-agent/zabbix-3.0.32/upgrades/dbpatches/2.0/oracle/
H A Dpatch.sql513 CREATE TABLE t_host_inventory ( table
590 INSERT INTO t_host_inventory
619 UPDATE t_host_inventory SET notes = notes||CHR(13)||CHR(10)||notes_ext WHERE notes IS NOT NULL AND …
620 UPDATE t_host_inventory SET notes = notes_ext WHERE notes IS NULL;
621 ALTER TABLE t_host_inventory DROP COLUMN notes_ext;
624 INSERT INTO host_inventory SELECT * FROM t_host_inventory;
626 DROP TABLE t_host_inventory;