From c760349138df71f67cf55a87596326d6ba6c8a04 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Mon, 13 May 2002 17:13:28 +0000
Subject: Minor changes

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 3c6195d4..93a5a4a8 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -360,4 +360,13 @@ CREATE INDEX services_links_serviceupid on services_links (serviceupid);
 CREATE INDEX services_links_servicedownid on services_links (servicedownid);
 CREATE UNIQUE INDEX services_links_upidownid on services_links (serviceupid, servicedownid);
 
+CREATE TABLE rights (
+  rightid               serial,
+  userid                int4		DEFAULT '' NOT NULL,
+  name                  char(255)	DEFAULT '' NOT NULL,
+  permission            char(1)		DEFAULT '' NOT NULL,
+  id                    int4,
+  PRIMARY KEY (rightid)
+);
+
 VACUUM ANALYZE;
-- 
cgit 

