diff options
-rw-r--r-- | engine/schema/mysql.sql | 6 |
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)
|