From ea21f84fa22b82b2b16dc190d57fd87553d3bc79 Mon Sep 17 00:00:00 2001 From: marcus Date: Mon, 15 Sep 2008 16:51:10 +0000 Subject: Marcus Povey: * Some missing indexes added to database. * Removed privileged path table since this is no longer used. git-svn-id: https://code.elgg.org/elgg/trunk@2084 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 49 +++++++++++++++++++++++++++++++++++-------------- 1 file changed, 35 insertions(+), 14 deletions(-) (limited to 'engine/schema') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 696fc4c98..1eb8a8747 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -40,7 +40,14 @@ CREATE TABLE `prefix_entities` ( `enabled` enum ('yes', 'no') NOT NULL default 'yes', primary key (`guid`), - KEY `site_guid` (`site_guid`) + KEY `type` (`type`), + KEY `subtype` (`subtype`), + KEY `owner_guid` (`owner_guid`), + KEY `site_guid` (`site_guid`), + KEY `container_guid` (`container_guid`), + KEY `access_id` (`access_id`), + KEY `time_created` (`time_created`), + KEY `time_updated` (`time_updated`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Entity subtypes - lets you subtype one of the main objects (sites/objects/etc) @@ -77,6 +84,7 @@ CREATE TABLE `prefix_access_collections` ( `name` text NOT NULL, `owner_guid` bigint(20) unsigned NOT NULL, `site_guid` bigint(20) unsigned NOT NULL default '0', + PRIMARY KEY (`id`) ) AUTO_INCREMENT=3 ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -90,7 +98,7 @@ CREATE TABLE `prefix_access_collection_membership` ( -- -- *** Entity superclass details *** --- NB: Asside from GUID, these should now have any field names incommon with the entities table. +-- NB: Aside from GUID, these should now have any field names in common with the entities table. -- -- Extra information relating to "objects" @@ -138,6 +146,8 @@ CREATE TABLE `prefix_users_entity` ( PRIMARY KEY (`guid`), UNIQUE KEY (`username`), KEY `password` (`password`), + KEY `email` (`email`(50)), + KEY `code` (`code`), FULLTEXT KEY `name` (`name`), FULLTEXT KEY (`name`,`username`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -174,7 +184,13 @@ CREATE TABLE `prefix_annotations` ( `enabled` enum ('yes', 'no') NOT NULL default 'yes', - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `entity_guid` (`entity_guid`), + KEY `name_id` (`name_id`), + KEY `value_id` (`value_id`), + KEY `owner_guid` (`owner_guid`), + KEY `access_id` (`access_id`) + ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Table structure for metadata @@ -194,8 +210,13 @@ CREATE TABLE `prefix_metadata` ( `enabled` enum ('yes', 'no') NOT NULL default 'yes', - PRIMARY KEY (`id`) - + PRIMARY KEY (`id`), + KEY `entity_guid` (`entity_guid`), + KEY `name_id` (`name_id`), + KEY `value_id` (`value_id`), + KEY `owner_guid` (`owner_guid`), + KEY `access_id` (`access_id`) + ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Meta strings table (avoids storing text strings more than once) @@ -204,7 +225,7 @@ CREATE TABLE `prefix_metastrings` ( `string` TEXT NOT NULL, PRIMARY KEY (`id`), - FULLTEXT KEY `string` (`string`) + KEY `string` (`string`(50)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- @@ -236,7 +257,8 @@ CREATE TABLE `prefix_users_apisessions` ( `expires` int(11) NOT NULL, PRIMARY KEY (`id`), - UNIQUE KEY (`user_guid`,`site_guid`) + UNIQUE KEY (`user_guid`,`site_guid`), + KEY `token` (`token`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Datalists for things like db version @@ -258,12 +280,11 @@ CREATE TABLE `prefix_system_log` ( `time_created` int(11) NOT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `object_id` (`object_id`), + KEY `object_class` (`object_class`), + KEY `event` (`event`), + KEY `performed_by_guid` (`performed_by_guid`), + KEY `time_created` (`time_created`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; --- Privileged paths, added to by the admin panel -CREATE TABLE `prefix_privileged_paths` ( - `path` varchar(128) NOT NULL, - - PRIMARY KEY (`path`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3