diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-08-11 10:22:11 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-08-11 10:22:11 +0000 |
| commit | b19b5e7b00b34e439b7f6934603ef3feb8a94a8f (patch) | |
| tree | 3053cc068566140604428647771f3f4ea4b40d28 /create | |
| parent | bcad0d8ff2049311f84d6727190601999d63d4bd (diff) | |
| download | zabbix-b19b5e7b00b34e439b7f6934603ef3feb8a94a8f.tar.gz zabbix-b19b5e7b00b34e439b7f6934603ef3feb8a94a8f.tar.xz zabbix-b19b5e7b00b34e439b7f6934603ef3feb8a94a8f.zip | |
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@161 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create')
| -rw-r--r-- | create/data/data.sql | 10 | ||||
| -rw-r--r-- | create/mysql/schema.sql | 4 | ||||
| -rw-r--r-- | create/postgresql/schema.sql | 4 |
3 files changed, 14 insertions, 4 deletions
diff --git a/create/data/data.sql b/create/data/data.sql index 4d09c223..6f9e5725 100644 --- a/create/data/data.sql +++ b/create/data/data.sql @@ -115,6 +115,16 @@ insert into items_template (itemtemplateid,description,key_,delay) values (47,'Checksum of /usr/bin/ssh','cksum[/usr/bin/ssh]', 600); insert into items_template (itemtemplateid,description,key_,delay) values (48,'Checksum of /etc/services','cksum[/etc/services]', 600); +insert into items_template (itemtemplateid,description,key_,delay) + values (49,'Number of disks read/write operations','io[disk_io]', 30); +insert into items_template (itemtemplateid,description,key_,delay) + values (50,'Number of disks read operations','io[disk_rio]', 30); +insert into items_template (itemtemplateid,description,key_,delay) + values (51,'Number of disks write operations','io[disk_wio]', 30); +insert into items_template (itemtemplateid,description,key_,delay) + values (52,'Number of block read from disks','io[disk_rblk]', 30); +insert into items_template (itemtemplateid,description,key_,delay) + values (53,'Number of block written to disks','io[disk_wblk]', 30); -- -- Data for table triggers_template diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 017cf659..4ee6586b 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -98,7 +98,7 @@ CREATE TABLE alerts ( type varchar(10) DEFAULT '' NOT NULL, sendto varchar(100) DEFAULT '' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, - message varchar(255) DEFAULT '' NOT NULL, + message blob DEFAULT '' NOT NULL, PRIMARY KEY (alertid), INDEX (actionid), KEY clock (clock) @@ -115,7 +115,7 @@ CREATE TABLE actions ( good int(4) DEFAULT '0' NOT NULL, delay int(4) DEFAULT '0' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, - message varchar(255) DEFAULT '' NOT NULL, + message blob DEFAULT '' NOT NULL, nextcheck int(4) DEFAULT '0' NOT NULL, PRIMARY KEY (actionid), KEY (triggerid) diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 46f4bf50..651d734b 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -112,7 +112,7 @@ CREATE TABLE actions ( good int4 DEFAULT '0' NOT NULL, delay int4 DEFAULT '0' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, - message varchar(255) DEFAULT '' NOT NULL, + message text DEFAULT '' NOT NULL, nextcheck int4 DEFAULT '0' NOT NULL, PRIMARY KEY (actionid), FOREIGN KEY (triggerid) REFERENCES triggers, @@ -130,7 +130,7 @@ CREATE TABLE alerts ( type varchar(10) DEFAULT '' NOT NULL, sendto varchar(100) DEFAULT '' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, - message varchar(255) DEFAULT '' NOT NULL, + message text DEFAULT '' NOT NULL, PRIMARY KEY (alertid), FOREIGN KEY (actionid) REFERENCES actions ); |