diff options
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index c153510c..1b060b7d 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -6,9 +6,11 @@ CREATE TABLE hosts ( hostid serial, - host varchar(64) DEFAULT '' NOT NULL, - port int4 DEFAULT '0' NOT NULL, - status int4 DEFAULT '0' NOT NULL, + host varchar(64) DEFAULT '' NOT NULL, + useip int4 DEFAULT '0' NOT NULL, + ip varchar(15) DEFAULT '127.0.0.1' NOT NULL, + port int4 DEFAULT '0' NOT NULL, + status int4 DEFAULT '0' NOT NULL, PRIMARY KEY (hostid) ); |