diff options
author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-27 12:53:58 +0000 |
---|---|---|
committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-27 12:53:58 +0000 |
commit | 2713d9853752255ed1b53c7f9ed2abf92af5cac8 (patch) | |
tree | 9ba9dcf1536e720f3ebbc8643de218e63b032ed2 /upgrades | |
parent | c8b70e6fece0a0aed254bb34cdc02b07dcf8c08e (diff) | |
download | zabbix-2713d9853752255ed1b53c7f9ed2abf92af5cac8.tar.gz zabbix-2713d9853752255ed1b53c7f9ed2abf92af5cac8.tar.xz zabbix-2713d9853752255ed1b53c7f9ed2abf92af5cac8.zip |
- added new table 'ids' which will store last IDs for all tables (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@3841 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades')
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/ids.sql | 7 | ||||
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/nodes.sql | 2 |
2 files changed, 7 insertions, 2 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/ids.sql b/upgrades/dbpatches/1.3/mysql/patch/ids.sql new file mode 100644 index 00000000..9080273f --- /dev/null +++ b/upgrades/dbpatches/1.3/mysql/patch/ids.sql @@ -0,0 +1,7 @@ +CREATE TABLE ids ( + nodeid integer DEFAULT '0' NOT NULL, + table_name varchar(64) DEFAULT '' NOT NULL, + field_name varchar(64) DEFAULT '' NOT NULL, + nextid bigint unsigned DEFAULT '0' NOT NULL, + PRIMARY KEY (nodeid,table_name,field_name) +) type=InnoDB; diff --git a/upgrades/dbpatches/1.3/mysql/patch/nodes.sql b/upgrades/dbpatches/1.3/mysql/patch/nodes.sql index 9a59d281..40be6161 100644 --- a/upgrades/dbpatches/1.3/mysql/patch/nodes.sql +++ b/upgrades/dbpatches/1.3/mysql/patch/nodes.sql @@ -7,8 +7,6 @@ CREATE TABLE nodes ( slave_history integer DEFAULT '30' NOT NULL, slave_trends integer DEFAULT '365' NOT NULL, event_lastid bigint unsigned DEFAULT '0' NOT NULL, - events_eventid bigint unsigned DEFAULT '0' NOT NULL, - alerts_alertid bigint unsigned DEFAULT '0' NOT NULL, history_lastid bigint unsigned DEFAULT '0' NOT NULL, history_str_lastid bigint unsigned DEFAULT '0' NOT NULL, history_uint_lastid bigint unsigned DEFAULT '0' NOT NULL, |