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.4.0.mysql | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'database/database.4.0.mysql')

diff --git a/database/database.4.0.mysql b/database/database.4.0.mysql
index dfd96323c..e2a9d0009 100644
--- a/database/database.4.0.mysql
+++ b/database/database.4.0.mysql
@@ -568,6 +568,17 @@ CREATE TABLE role (
   UNIQUE KEY name (name)
 );
 
+--
+-- Table structure for table 'blocks_roles'
+--
+CREATE TABLE blocks_roles (
+  module varchar(64) NOT NULL,
+  delta varchar(32) NOT NULL,
+  rid int(10) unsigned NOT NULL,
+  PRIMARY KEY (module, delta, rid)
+)
+/*!40100 DEFAULT CHARACTER SET utf8 */ ;
+
 --
 -- Table structure for table 'search_dataset'
 --
-- 
cgit v1.2.3