From b3bf72d0faa76ffe3bb62141fca55d4decec19cf Mon Sep 17 00:00:00 2001
From: ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Thu, 24 Apr 2008 13:19:32 +0000
Subject: The beginnings of a db upgrade system. See lib/version.php,
 /version.php and the datalist functions in elgglib.php.

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

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

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index ae5dbe033..f037ac32c 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -43,7 +43,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` (
@@ -54,7 +54,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 ***
@@ -68,7 +68,7 @@ CREATE TABLE `prefix_access_groups` (
   `site_guid` bigint(20) unsigned NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `name` (`name`)
-) ENGINE=MyISAM ;
+)  ;
 
 -- Dumping data for table `access_groups`
 INSERT INTO `prefix_access_groups` (`id`, `name`, `site_guid`) VALUES
@@ -81,7 +81,7 @@ CREATE TABLE `prefix_access_group_membership` (
   `user_guid` int(11) NOT NULL,
   `access_group_id` int(11) NOT NULL,
   PRIMARY KEY  (`user_guid`,`access_group_id`)
-) ENGINE=MyISAM ;
+)  ;
 
 
 --
@@ -97,7 +97,7 @@ CREATE TABLE `prefix_objects_entity` (
   `description` text NOT NULL,
 
   PRIMARY KEY  (`guid`)
-) ENGINE=MyISAM ;
+)  ;
 
 -- Extra information relating to "sites"
 CREATE TABLE `prefix_sites_entity` (
@@ -109,7 +109,7 @@ CREATE TABLE `prefix_sites_entity` (
    
   PRIMARY KEY  (`guid`),
   UNIQUE KEY (`url`)
-) ENGINE=MyISAM ;
+)  ;
 
 -- Extra information relating to "users"
 CREATE TABLE `prefix_users_entity` (
@@ -131,7 +131,7 @@ CREATE TABLE `prefix_users_entity` (
   PRIMARY KEY  (`guid`),
   KEY `password` (`password`),
   FULLTEXT KEY `name` (`name`)
-) ENGINE=MyISAM ;
+)  ;
 
 
 -- TODO: Collection
@@ -157,7 +157,7 @@ CREATE TABLE `prefix_annotations` (
 	`time_created` int(11) NOT NULL,
 	
 	PRIMARY KEY (`id`)
-) ENGINE=MyISAM;
+) ;
 
 -- Table structure for metadata
 CREATE TABLE `prefix_metadata` (
@@ -176,7 +176,7 @@ CREATE TABLE `prefix_metadata` (
 	
 	PRIMARY KEY (`id`)
 	
-) ENGINE=MyISAM;
+) ;
 
 -- Meta strings table (avoids storing text strings more than once)
 CREATE TABLE `prefix_metastrings` (
@@ -185,7 +185,7 @@ CREATE TABLE `prefix_metastrings` (
 	
 	PRIMARY KEY (`id`),
 	UNIQUE KEY (`string`)
-) ENGINE=MyISAM;
+) ;
 
 --
 -- *** Misc ***
@@ -217,5 +217,12 @@ 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(16) NOT NULL,
+  `value` text NOT NULL,
+  KEY `name` (`name`)
+);
 
-- 
cgit v1.2.3

