- added table users_groups, usrgrp (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@958 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 24 insertions, 0 deletions

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 96273b11..f6d09aef 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -526,4 +526,28 @@ CREATE TABLE stats (
   PRIMARY KEY (itemid,year,month,day,hour)
 );
 
+--
+-- Table structure for table 'usrgrp'
+--
+
+CREATE TABLE usrgrp (
+  usrgrpid		serial,
+  name			varchar(64)	DEFAULT '' NOT NULL,
+  PRIMARY KEY (usrgrpid)
+);
+
+CREATE UNIQUE INDEX usrgrp_name on usrgrp (name);
+
+--
+-- Table structure for table 'users_groups'
+--
+
+CREATE TABLE users_groups (
+  usrgrpid		int4		DEFAULT '0' NOT NULL,
+  userid		int4		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (usrgrpid,userid),
+  FOREIGN KEY (usrgrpid) REFERENCES usrgrp,
+  FOREIGN KEY (userid) REFERENCES users
+);
+
 VACUUM ANALYZE;