/dports/net-mgmt/zabbix3-proxy/zabbix-3.0.32/upgrades/dbpatches/2.0/postgresql/ |
H A D | patch.sql | 518 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 D | patch.sql | 518 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 D | patch.sql | 518 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 D | patch.sql | 518 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 D | patch.sql | 518 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 D | patch.sql | 512 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 D | patch.sql | 512 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 D | patch.sql | 512 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 D | patch.sql | 512 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 D | patch.sql | 512 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 D | patch.sql | 1188 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 D | patch.sql | 1188 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 D | patch.sql | 1188 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 D | patch.sql | 1188 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 D | patch.sql | 1188 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 D | patch.sql | 513 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 D | patch.sql | 513 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 D | patch.sql | 513 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 D | patch.sql | 513 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 D | patch.sql | 513 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;
|