diff options
Diffstat (limited to 'upgrades/dbpatches')
| -rw-r--r-- | upgrades/dbpatches/1.4/mysql/patch/items.sql | 3 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.4/postgresql/patch/items.sql | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/upgrades/dbpatches/1.4/mysql/patch/items.sql b/upgrades/dbpatches/1.4/mysql/patch/items.sql index 2093e4a2..b4cbd028 100644 --- a/upgrades/dbpatches/1.4/mysql/patch/items.sql +++ b/upgrades/dbpatches/1.4/mysql/patch/items.sql @@ -32,12 +32,13 @@ CREATE TABLE items_tmp ( templateid bigint unsigned DEFAULT '0' NOT NULL, valuemapid bigint unsigned DEFAULT '0' NOT NULL, delay_flex varchar(255) DEFAULT '' NOT NULL, + params text 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; +insert into items_tmp select *,'','' from items; drop table items; alter table items_tmp rename items; diff --git a/upgrades/dbpatches/1.4/postgresql/patch/items.sql b/upgrades/dbpatches/1.4/postgresql/patch/items.sql index f34aac7d..eeb7ecbe 100644 --- a/upgrades/dbpatches/1.4/postgresql/patch/items.sql +++ b/upgrades/dbpatches/1.4/postgresql/patch/items.sql @@ -32,12 +32,13 @@ CREATE TABLE items_tmp ( templateid bigint DEFAULT '0' NOT NULL, valuemapid bigint DEFAULT '0' NOT NULL, delay_flex varchar(255) DEFAULT '' NOT NULL, + params text DEFAULT '' NOT NULL, PRIMARY KEY (itemid) ); 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; +insert into items_tmp select *,'','' from items; drop table items; alter table items_tmp rename to items; |