diff options
| -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 ,
|