From 02fa0d85b2eaf2b25b8eff07a996def15f2f3929 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Fri, 26 May 2006 09:21:10 +0000
Subject: - Patch #18018 by dww, nedjo, tostinne, luke et al: block visibility
 by role.

---
 database/database.pgsql | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'database/database.pgsql')

diff --git a/database/database.pgsql b/database/database.pgsql
index 7d468f82b..a2812b604 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -571,6 +571,17 @@ CREATE TABLE role (
   UNIQUE (name)
 );
 
+--
+-- Table structure for table 'blocks_roles'
+--
+
+CREATE TABLE blocks_roles (
+  module varchar(64) NOT NULL,
+  delta varchar(32) NOT NULL,
+  rid integer NOT NULL,
+  PRIMARY KEY (module, delta, rid)
+);
+
 --
 -- Table structure for table 'search_dataset'
 --
-- 
cgit v1.2.3