aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authormarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-08-19 09:34:46 +0000
committermarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-08-19 09:34:46 +0000
commit3df961206c9aa689d077297751268079f812cd87 (patch)
tree994fc630c876533cb1bac2167a98dc64438cdcc4 /engine/schema
parent559bf959778a081033228521f41ae284f34175d5 (diff)
downloadelgg-3df961206c9aa689d077297751268079f812cd87.tar.gz
elgg-3df961206c9aa689d077297751268079f812cd87.tar.bz2
Fixes #260: Done. Nice spot.
git-svn-id: https://code.elgg.org/elgg/trunk@2014 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql32
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;