From d56293a189105352a5e392c1318c323518c64796 Mon Sep 17 00:00:00 2001 From: marcus Date: Thu, 20 Nov 2008 11:45:43 +0000 Subject: Refs #569, #570, #571: Minor database schema errors corrected git-svn-id: https://code.elgg.org/elgg/trunk@2472 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 10 ++++++++++ engine/schema/upgrades/2008111901.sql | 2 +- 2 files changed, 11 insertions(+), 1 deletion(-) 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 , -- cgit v1.2.3