summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 8d3a26d0..6a82cb8e 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -62,6 +62,7 @@ CREATE TABLE items (
value_type int4 DEFAULT '0' NOT NULL,
trapper_hosts varchar(255) DEFAULT '' NOT NULL,
units varchar(10) DEFAULT '' NOT NULL,
+ multiplier int4 DEFAULT '0' NOT NULL,
PRIMARY KEY (itemid),
FOREIGN KEY (hostid) REFERENCES hosts
);