aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--engine/schema/mysql.sql6
1 files changed, 4 insertions, 2 deletions
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)