From c760349138df71f67cf55a87596326d6ba6c8a04 Mon Sep 17 00:00:00 2001 From: hugetoad 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