From 495799b2aa61aab23d74d7faa110a0cd09d59bf0 Mon Sep 17 00:00:00 2001
From: alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Tue, 10 Oct 2006 13:34:58 +0000
Subject: More changes for distributed monitoring.

git-svn-id: svn://svn.zabbix.com/trunk@3335 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 create/schema/schema.sql | 24 +++++++++++++++++++++++-
 1 file changed, 23 insertions(+), 1 deletion(-)

(limited to 'create/schema/schema.sql')

diff --git a/create/schema/schema.sql b/create/schema/schema.sql
index 650cfa37..49abce50 100644
--- a/create/schema/schema.sql
+++ b/create/schema/schema.sql
@@ -22,7 +22,7 @@
 --
 
 CREATE TABLE nodes (
-	nodeid			{bigint}		DEFAULT '0' NOT NULL,
+	nodeid			{integer}		DEFAULT '0' NOT NULL,
 	name			{varchar}(64)		DEFAULT '' NOT NULL,
 	timezone		{integer}		DEFAULT '0' NOT NULL,
 	ip			{varchar}(15)		DEFAULT '' NOT NULL,
@@ -302,6 +302,17 @@ CREATE TABLE history_uint (
 
 CREATE INDEX history_uint_1 ON history_uint (itemid, clock);
 
+CREATE TABLE history_uint_sync (
+	id			{serial},
+	nodeid			{integer}			DEFAULT '0' NOT NULL,
+	itemid			{bigint}		DEFAULT '0' NOT NULL,
+	clock			{integer}		DEFAULT '0' NOT NULL,
+	value			{bigint}		DEFAULT '0' NOT NULL,
+	PRIMARY KEY (id)
+) {create_table_opt};
+
+CREATE INDEX history_uint_sync_1 ON history_uint_sync (nodeid, id);
+
 CREATE TABLE history_str (
 	itemid			{bigint}		DEFAULT '0' NOT NULL,
 	clock			{integer}		DEFAULT '0' NOT NULL,
@@ -310,6 +321,17 @@ CREATE TABLE history_str (
 
 CREATE INDEX history_str_1 ON history_str (itemid, clock);
 
+CREATE TABLE history_str_sync (
+	id			{serial},
+	nodeid			{integer}			DEFAULT '0' NOT NULL,
+	itemid			{bigint}		DEFAULT '0' NOT NULL,
+	clock			{integer}		DEFAULT '0' NOT NULL,
+	value			{varchar}(255)	DEFAULT '' NOT NULL,
+	PRIMARY KEY (id)
+) {create_table_opt};
+
+CREATE INDEX history_str_sync_1 ON history_str_sync (nodeid, id);
+
 CREATE TABLE hosts (
 	hostid			{bigint}			DEFAULT '0' NOT NULL,
 	host			{varchar}(64)		DEFAULT '' NOT NULL,
-- 
cgit