aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authorben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-04-24 13:19:32 +0000
committerben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-04-24 13:19:32 +0000
commitb3bf72d0faa76ffe3bb62141fca55d4decec19cf (patch)
tree086cac64141d03456a8542536a35c4e32fc2f6b6 /engine/schema
parent1c71016e6db14f52988522f3c47388eba86bc7ab (diff)
downloadelgg-b3bf72d0faa76ffe3bb62141fca55d4decec19cf.tar.gz
elgg-b3bf72d0faa76ffe3bb62141fca55d4decec19cf.tar.bz2
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
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql29
1 files changed, 18 insertions, 11 deletions
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`)
+);