Fixes #260: Done. Nice spot.

git-svn-id: https://code.elgg.org/elgg/trunk@2014 36083f99-b078-4883-b0ff-0f9b5a30f544

1 files changed, 16 insertions, 16 deletions

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index fbd5a9dfa..cd1b638a9 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -20,7 +20,7 @@ CREATE TABLE `prefix_config` (
   `value` text NOT NULL,

   `site_guid` int(11) NOT NULL,

   PRIMARY KEY  (`name`,`site_guid`)

-);

+) ENGINE=MyISAM;

 

 -- Define entities. 

 CREATE TABLE `prefix_entities` (

@@ -41,7 +41,7 @@ CREATE TABLE `prefix_entities` (
 	

 	primary key (`guid`),

     KEY `site_guid` (`site_guid`)

-);

+) ENGINE=MyISAM;

 

 -- Entity subtypes - lets you subtype one of the main objects (sites/objects/etc)

 CREATE TABLE `prefix_entity_subtypes` (

@@ -54,7 +54,7 @@ CREATE TABLE `prefix_entity_subtypes` (
 	

 	PRIMARY KEY (`id`),

 	UNIQUE KEY (`type`, `subtype`)

-) ;

+) ENGINE=MyISAM;

 

 -- Describe relationships between entities, can describe friendships but also site membership, depending on context

 CREATE TABLE `prefix_entity_relationships` (

@@ -65,7 +65,7 @@ CREATE TABLE `prefix_entity_relationships` (
   `guid_two` bigint(20) unsigned  NOT NULL,

   PRIMARY KEY  (`id`),

   UNIQUE KEY (`guid_one`,`relationship`,`guid_two`)

-)  ;

+) ENGINE=MyISAM;

 

 --

 -- *** Access controls ***

@@ -78,14 +78,14 @@ CREATE TABLE `prefix_access_collections` (
   `owner_guid` bigint(20) unsigned NOT NULL,

   `site_guid` bigint(20) unsigned NOT NULL default '0',

   PRIMARY KEY  (`id`)

-) AUTO_INCREMENT=3;

+) AUTO_INCREMENT=3  ENGINE=MyISAM;

 

 -- Access containers 

 CREATE TABLE `prefix_access_collection_membership` (

   `user_guid` int(11) NOT NULL,

   `access_collection_id` int(11) NOT NULL,

   PRIMARY KEY  (`user_guid`,`access_collection_id`)

-)  ;

+) ENGINE=MyISAM;

 

 

 --

@@ -102,7 +102,7 @@ CREATE TABLE `prefix_objects_entity` (
 

   PRIMARY KEY  (`guid`),
   FULLTEXT KEY (`title`,`description`)

-)  ;

+) ENGINE=MyISAM;

 

 -- Extra information relating to "sites"

 CREATE TABLE `prefix_sites_entity` (

@@ -115,7 +115,7 @@ CREATE TABLE `prefix_sites_entity` (
   PRIMARY KEY  (`guid`),

   UNIQUE KEY (`url`),
   FULLTEXT KEY (`name`,`description`, `url`)

-)  ;

+) ENGINE=MyISAM;

 

 -- Extra information relating to "users"

 CREATE TABLE `prefix_users_entity` (

@@ -175,7 +175,7 @@ CREATE TABLE `prefix_annotations` (
 	`enabled` enum ('yes', 'no') NOT NULL default 'yes',

 	

 	PRIMARY KEY (`id`)

-) ;

+) ENGINE=MyISAM;

 

 -- Table structure for metadata

 CREATE TABLE `prefix_metadata` (

@@ -196,7 +196,7 @@ CREATE TABLE `prefix_metadata` (
 	

 	PRIMARY KEY (`id`)

 	

-) ;

+) ENGINE=MyISAM;

 

 -- Meta strings table (avoids storing text strings more than once)

 CREATE TABLE `prefix_metastrings` (

@@ -205,7 +205,7 @@ CREATE TABLE `prefix_metastrings` (
 	

 	PRIMARY KEY (`id`),
 	FULLTEXT KEY `string` (`string`)

-) ;

+) ENGINE=MyISAM;

 

 --

 -- *** Misc ***

@@ -223,7 +223,7 @@ CREATE TABLE `prefix_api_users` (
 	

 	unique key (api_key),

 	primary key (id)

-);

+) ENGINE=MyISAM;

 

 -- API Sessions

 CREATE TABLE `prefix_users_apisessions` (

@@ -237,14 +237,14 @@ CREATE TABLE `prefix_users_apisessions` (
 	

 	PRIMARY KEY  (`id`),

 	UNIQUE KEY (`user_guid`,`site_guid`)

-) ;

+) ENGINE=MyISAM;

 

 -- Datalists for things like db version

 CREATE TABLE `prefix_datalists` (

   `name` varchar(32) NOT NULL,

   `value` text NOT NULL,

   KEY `name` (`name`)

-);

+) ENGINE=MyISAM;

 

 -- System log

 CREATE TABLE `prefix_system_log` (

@@ -259,11 +259,11 @@ CREATE TABLE `prefix_system_log` (
 	`time_created` int(11) NOT NULL,

 	

 	PRIMARY KEY  (`id`)

-);

+) ENGINE=MyISAM;

 

 -- Privileged paths, added to by the admin panel

 CREATE TABLE `prefix_privileged_paths` (

 	`path` varchar(128) NOT NULL,

 	

 	PRIMARY KEY (`path`)

-);

+) ENGINE=MyISAM;