summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql9
1 files changed, 9 insertions, 0 deletions
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;