diff options
| author | ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-04-21 13:25:59 +0000 |
|---|---|---|
| committer | ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-04-21 13:25:59 +0000 |
| commit | 0f4de8e0c31c2d360aa0fe1144c8a50b034038e5 (patch) | |
| tree | eaf9a23b284b7cd2c51f02c74fafd5933c786088 /engine/schema/mysql.sql | |
| parent | 52225c52c4f72fcf2ccfdbcb984b2ed9124f5016 (diff) | |
| download | elgg-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/mysql.sql')
| -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)
|