aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authormarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-11-20 11:45:43 +0000
committermarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-11-20 11:45:43 +0000
commitd56293a189105352a5e392c1318c323518c64796 (patch)
tree89855c4b5cb954cb0d0992858d4417ebf4a05705 /engine/schema
parentad94f30fa23b83667c4ade72afaea948807e6b1b (diff)
downloadelgg-d56293a189105352a5e392c1318c323518c64796.tar.gz
elgg-d56293a189105352a5e392c1318c323518c64796.tar.bz2
Refs #569, #570, #571: Minor database schema errors corrected
git-svn-id: https://code.elgg.org/elgg/trunk@2472 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql10
-rw-r--r--engine/schema/upgrades/2008111901.sql2
2 files changed, 11 insertions, 1 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 695a2e79f..0bdd93d1b 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -291,6 +291,16 @@ CREATE TABLE `prefix_datalists` (
PRIMARY KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+-- Ultra-private system settings for entities
+CREATE TABLE IF NOT EXISTS `prefix_private_settings` (
+ `id` INT NOT NULL auto_increment,
+ `entity_guid` INT NOT NULL ,
+ `name` VARCHAR( 32 ) NOT NULL ,
+ `value` TEXT NOT NULL ,
+ PRIMARY KEY ( `id` ) ,
+ INDEX ( `entity_guid` , `name` )
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;
+
-- System log
CREATE TABLE `prefix_system_log` (
`id` int(11) NOT NULL auto_increment,
diff --git a/engine/schema/upgrades/2008111901.sql b/engine/schema/upgrades/2008111901.sql
index ee227d4d0..af1f0182f 100644
--- a/engine/schema/upgrades/2008111901.sql
+++ b/engine/schema/upgrades/2008111901.sql
@@ -1,5 +1,5 @@
CREATE TABLE IF NOT EXISTS `prefix_private_settings` (
- `id` INT NOT NULL ,
+ `id` INT NOT NULL auto_increment,
`entity_guid` INT NOT NULL ,
`name` VARCHAR( 32 ) NOT NULL ,
`value` TEXT NOT NULL ,