summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-02-22 13:00:30 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-02-22 13:00:30 +0000
commit4d1bc57d77b0dd5f4df470f3dfa3d39e69201130 (patch)
treef5f713663d551b19888bdcb3010fb29d183f8029 /create/postgresql/schema.sql
parentbb235bd63289bd6debf4a951e4169fb3c9430a5f (diff)
downloadzabbix-4d1bc57d77b0dd5f4df470f3dfa3d39e69201130.tar.gz
zabbix-4d1bc57d77b0dd5f4df470f3dfa3d39e69201130.tar.xz
zabbix-4d1bc57d77b0dd5f4df470f3dfa3d39e69201130.zip
- added table housekeeper (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2672 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index b7b936a7..bed6613e 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -787,4 +787,15 @@ CREATE TABLE mappings (
CREATE INDEX mappings_valuemapid on mappings (valuemapid);
+--
+-- Table structure for table 'housekeeper'
+--
+
+CREATE TABLE housekeeper (
+ housekeeperid serial,
+ tablename varchar(64) DEFAULT '' NOT NULL,
+ field varchar(64) DEFAULT '' NOT NULL,
+ PRIMARY KEY (housekeeperid)
+);
+
VACUUM ANALYZE;