aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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 ,