From 0f4de8e0c31c2d360aa0fe1144c8a50b034038e5 Mon Sep 17 00:00:00 2001
From: ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Mon, 21 Apr 2008 13:25:59 +0000
Subject: Added site_guid to the entities table

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

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

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 9646edb5e..83a11b458 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -1,4 +1,4 @@
---
+l--
 -- Main Elgg database
 -- 
 -- @link http://elgg.org/
@@ -22,12 +22,14 @@ CREATE TABLE `prefix_entities` (
 	`subtype` int(11) NULL,
 	
 	`owner_guid` bigint(20) unsigned NOT NULL,
+    `site_guid` bigint(20) unsigned NOT NULL,
 	`access_id` int(11) NOT NULL,
 	
 	`time_created` int(11) NOT NULL,
 	`time_updated` int(11) NOT NULL,
 	
-	primary key (`guid`)
+	primary key (`guid`),
+    KEY `site_guid` (`site_guid`)
 );
 
 -- Entity subtypes - lets you subtype one of the main objects (sites/objects/etc)
-- 
cgit v1.2.3

