From 0d3c18f6aabb988527d59732882c5f407ab7d04f Mon Sep 17 00:00:00 2001
From: icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Thu, 13 Mar 2008 16:42:19 +0000
Subject: Marcus Povey <marcus@dushka.co.uk> * Access control fields ok

git-svn-id: https://code.elgg.org/elgg/trunk@209 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index d42168f89..4d74fae8c 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -77,7 +77,7 @@ INSERT INTO `prefix_access_groups` (`id`, `name`, `site_guid`) VALUES
 CREATE TABLE `prefix_access_group_membership` (
   `user_guid` int(11) NOT NULL,
   `access_group_id` int(11) NOT NULL,
-  PRIMARY KEY  (`user_id`,`access_group_id`)
+  PRIMARY KEY  (`user_guid`,`access_group_id`)
 ) ENGINE=MyISAM ;
 
 
@@ -102,7 +102,7 @@ CREATE TABLE `prefix_sites_entity` (
   
   `name` text NOT NULL,
   `description` text NOT NULL,
-  `url` text NOT NULL, 
+  `url` varchar(255) NOT NULL, 
    
   PRIMARY KEY  (`guid`),
   UNIQUE KEY (`url`)
-- 
cgit v1.2.3

