diff options
| author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-11-20 11:45:43 +0000 |
|---|---|---|
| committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-11-20 11:45:43 +0000 |
| commit | d56293a189105352a5e392c1318c323518c64796 (patch) | |
| tree | 89855c4b5cb954cb0d0992858d4417ebf4a05705 /engine/schema | |
| parent | ad94f30fa23b83667c4ade72afaea948807e6b1b (diff) | |
| download | elgg-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.sql | 10 | ||||
| -rw-r--r-- | engine/schema/upgrades/2008111901.sql | 2 |
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 ,
|