diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-02-20 14:15:16 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-02-20 14:15:16 +0000 |
| commit | dd1e1557c1280b9517c5ca6ab9c024d00b87f669 (patch) | |
| tree | 00d307d97784dc7ccd75d476b9207f8a123a55c2 /upgrades/dbpatches | |
| parent | a35b8b27f20430d9084d02aff8bdfa5f281d3b0f (diff) | |
| download | zabbix-dd1e1557c1280b9517c5ca6ab9c024d00b87f669.tar.gz zabbix-dd1e1557c1280b9517c5ca6ab9c024d00b87f669.tar.xz zabbix-dd1e1557c1280b9517c5ca6ab9c024d00b87f669.zip | |
- added tables valuemaps and mappings (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2663 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches')
| -rw-r--r-- | upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql | 23 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql | 24 |
2 files changed, 47 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql b/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql index 3f19c9ab..2dffd403 100644 --- a/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql +++ b/upgrades/dbpatches/1.1beta6_to_1.1beta7/mysql/patch.sql @@ -2,3 +2,26 @@ alter table hosts add templateid int(4) DEFAULT '0' NOT NULL; alter table items add templateid int(4) DEFAULT '0' NOT NULL; alter table triggers add templateid int(4) DEFAULT '0' NOT NULL; alter table graphs add templateid int(4) DEFAULT '0' NOT NULL; + +-- +-- Table structure for table 'valuemaps' +-- + +CREATE TABLE valuemaps ( + valuemapid int(4) NOT NULL auto_increment, + name varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (valuemapid) +) type=InnoDB; + +-- +-- Table structure for table 'mapping' +-- + +CREATE TABLE mappings ( + mappingid int(4) NOT NULL auto_increment, + valuemapid int(4) DEFAULT '0' NOT NULL, + value varchar(64) DEFAULT '' NOT NULL, + newvalue varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (mappingid), + KEY valuemapid (valuemapid) +) type=InnoDB; diff --git a/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql b/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql index 77abb30a..54bab225 100644 --- a/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql +++ b/upgrades/dbpatches/1.1beta6_to_1.1beta7/postgresql/patch.sql @@ -2,3 +2,27 @@ alter table hosts add templateid int4 DEFAULT '0' NOT NULL; alter table items add templateid int4 DEFAULT '0' NOT NULL; alter table triggers add templateid int4 DEFAULT '0' NOT NULL; alter table graphs add templateid int4 DEFAULT '0' NOT NULL; + +-- +-- Table structure for table 'valuemaps' +-- + +CREATE TABLE valuemaps ( + valuemapid serial, + name varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (valuemapid) +); + +-- +-- Table structure for table 'mapping' +-- + +CREATE TABLE mappings ( + mappingid serial, + valuemapid int4 DEFAULT '0' NOT NULL, + value varchar(64) DEFAULT '' NOT NULL, + newvalue varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (mappingid), +); + +CREATE INDEX mappings_valuemapid on mappings (valuemapid); |