diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-11-24 16:58:31 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-11-24 16:58:31 +0000 |
| commit | 69c3bb458c5fd3924b1149f2e8e1852fdcffb7fd (patch) | |
| tree | 3d3be14102ca9965e9e847f388e6d50c1aaef35e /create | |
| parent | 1964ae1cb717b09523b924d351627d1601ab968f (diff) | |
| download | zabbix-69c3bb458c5fd3924b1149f2e8e1852fdcffb7fd.tar.gz zabbix-69c3bb458c5fd3924b1149f2e8e1852fdcffb7fd.tar.xz zabbix-69c3bb458c5fd3924b1149f2e8e1852fdcffb7fd.zip | |
More changes for DB.
git-svn-id: svn://svn.zabbix.com/trunk@3514 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create')
| -rw-r--r-- | create/data/nodes_master.sql | 4 | ||||
| -rw-r--r-- | create/data/nodes_slave.sql | 4 | ||||
| -rw-r--r-- | create/schema/schema_new.sql | 1 |
3 files changed, 5 insertions, 4 deletions
diff --git a/create/data/nodes_master.sql b/create/data/nodes_master.sql index 3a697ed3..b54b8815 100644 --- a/create/data/nodes_master.sql +++ b/create/data/nodes_master.sql @@ -1,2 +1,2 @@ -insert into nodes values (2, "D8", 2, "192.168.1.5", 10051, 30, 365, 0, 0, 0, 0, 0, 0, 1); -insert into nodes values (1, "ZABBIX", 2, "192.168.1.88", 10051, 30, 365, 0, 0, 0, 0, 0, 1, 0); +insert into nodes values (2, "D8", 2, "192.168.1.5", 10051, 30, 365, 0, 0, 0, 0, 0, 0, 0, 1); +insert into nodes values (1, "ZABBIX", 2, "192.168.1.88", 10051, 30, 365, 0, 0, 0, 0, 0, 0, 1, 0); diff --git a/create/data/nodes_slave.sql b/create/data/nodes_slave.sql index a7a24194..512c4785 100644 --- a/create/data/nodes_slave.sql +++ b/create/data/nodes_slave.sql @@ -1,2 +1,2 @@ -insert into nodes values (2, "D8", 2, "192.168.1.5", 10051, 30, 365, 0, 0, 0, 0, 0, 1, 1); -insert into nodes values (1, "ZABBIX", 2, "192.168.1.88", 10051, 30, 365, 0, 0, 0, 0, 0, 0, 0); +insert into nodes values (2, "D8", 2, "192.168.1.5", 10051, 30, 365, 0, 0, 0, 0, 0, 0, 1, 1); +insert into nodes values (1, "ZABBIX",2,"192.168.1.88", 10051, 30, 365, 0, 0, 0, 0, 0, 0, 0, 0); diff --git a/create/schema/schema_new.sql b/create/schema/schema_new.sql index 922e649b..a6cdbf80 100644 --- a/create/schema/schema_new.sql +++ b/create/schema/schema_new.sql @@ -31,6 +31,7 @@ FIELD |slave_history |t_integer |'30' |NOT NULL | FIELD |slave_trends |t_integer |'365' |NOT NULL | FIELD |event_lastid |t_id |'0' |NOT NULL | FIELD |event_maxid |t_id |'0' |NOT NULL | +FIELD |alert_maxid |t_id |'0' |NOT NULL | FIELD |history_lastid |t_bigint |'0' |NOT NULL | FIELD |history_str_lastid|t_bigint |'0' |NOT NULL | FIELD |history_uint_lastid|t_bigint |'0' |NOT NULL | |