diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/items.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/items.sql | 42 |
1 files changed, 21 insertions, 21 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/items.sql b/upgrades/dbpatches/1.3/postgresql/patch/items.sql index 2093e4a2..f34aac7d 100644 --- a/upgrades/dbpatches/1.3/postgresql/patch/items.sql +++ b/upgrades/dbpatches/1.3/postgresql/patch/items.sql @@ -1,43 +1,43 @@ CREATE TABLE items_tmp ( - itemid bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, - snmp_community varchar(64) DEFAULT '' NOT NULL, - snmp_oid varchar(255) DEFAULT '' NOT NULL, - snmp_port integer DEFAULT '161' NOT NULL, - hostid bigint unsigned DEFAULT '0' NOT NULL, - description varchar(255) DEFAULT '' NOT NULL, + snmp_community varchar(64) DEFAULT '' NOT NULL, + snmp_oid varchar(255) DEFAULT '' NOT NULL, + snmp_port integer DEFAULT '161' NOT NULL, + hostid bigint DEFAULT '0' NOT NULL, + description varchar(255) DEFAULT '' NOT NULL, key_ varchar(255) DEFAULT '' NOT NULL, delay integer DEFAULT '0' NOT NULL, history integer DEFAULT '90' NOT NULL, trends integer DEFAULT '365' NOT NULL, - nextcheck integer DEFAULT '0' NOT NULL, - lastvalue varchar(255) NULL, - lastclock integer NULL, - prevvalue varchar(255) NULL, + nextcheck integer DEFAULT '0' NOT NULL, + lastvalue varchar(255) NULL, + lastclock integer NULL, + prevvalue varchar(255) NULL, status integer DEFAULT '0' NOT NULL, - value_type integer DEFAULT '0' NOT NULL, - trapper_hosts varchar(255) DEFAULT '' NOT NULL, + value_type integer DEFAULT '0' NOT NULL, + trapper_hosts varchar(255) DEFAULT '' NOT NULL, units varchar(10) DEFAULT '' NOT NULL, - multiplier integer DEFAULT '0' NOT NULL, + multiplier integer DEFAULT '0' NOT NULL, delta integer DEFAULT '0' NOT NULL, - prevorgvalue varchar(255) NULL, + prevorgvalue varchar(255) NULL, snmpv3_securityname varchar(64) DEFAULT '' NOT NULL, snmpv3_securitylevel integer DEFAULT '0' NOT NULL, snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL, snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL, formula varchar(255) DEFAULT '0' NOT NULL, error varchar(128) DEFAULT '' NOT NULL, - lastlogsize integer DEFAULT '0' NOT NULL, - logtimefmt varchar(64) DEFAULT '' NOT NULL, - templateid bigint unsigned DEFAULT '0' NOT NULL, - valuemapid bigint unsigned DEFAULT '0' NOT NULL, - delay_flex varchar(255) DEFAULT '' NOT NULL, + lastlogsize integer DEFAULT '0' NOT NULL, + logtimefmt varchar(64) DEFAULT '' NOT NULL, + templateid bigint DEFAULT '0' NOT NULL, + valuemapid bigint DEFAULT '0' NOT NULL, + delay_flex varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (itemid) -) ENGINE=InnoDB; +); CREATE UNIQUE INDEX items_1 on items_tmp (hostid,key_); CREATE INDEX items_2 on items_tmp (nextcheck); CREATE INDEX items_3 on items_tmp (status); insert into items_tmp select *,'' from items; drop table items; -alter table items_tmp rename items; +alter table items_tmp rename to items; |