diff options
Diffstat (limited to 'engine/schema/mysql.sql')
| -rw-r--r-- | engine/schema/mysql.sql | 10 |
1 files changed, 10 insertions, 0 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,
|