From 3df961206c9aa689d077297751268079f812cd87 Mon Sep 17 00:00:00 2001
From: marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Tue, 19 Aug 2008 09:34:46 +0000
Subject: Fixes #260: Done. Nice spot.

git-svn-id: https://code.elgg.org/elgg/trunk@2014 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 32 ++++++++++++++++----------------
 1 file changed, 16 insertions(+), 16 deletions(-)

(limited to 'engine/schema/mysql.sql')

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;
-- 
cgit v1.2.3

