aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authorben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-04-21 13:25:59 +0000
committerben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-04-21 13:25:59 +0000
commit0f4de8e0c31c2d360aa0fe1144c8a50b034038e5 (patch)
treeeaf9a23b284b7cd2c51f02c74fafd5933c786088 /engine/schema
parent52225c52c4f72fcf2ccfdbcb984b2ed9124f5016 (diff)
downloadelgg-0f4de8e0c31c2d360aa0fe1144c8a50b034038e5.tar.gz
elgg-0f4de8e0c31c2d360aa0fe1144c8a50b034038e5.tar.bz2
Added site_guid to the entities table
git-svn-id: https://code.elgg.org/elgg/trunk@496 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-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)