From 131e9de561f2237fa9b5b70ac15fa4ac1c555afb Mon Sep 17 00:00:00 2001 From: ben Date: Wed, 19 Nov 2008 19:34:12 +0000 Subject: Introducing the new private settings table. git-svn-id: https://code.elgg.org/elgg/trunk@2464 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/upgrades/2008111901.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 engine/schema/upgrades/2008111901.sql (limited to 'engine/schema') diff --git a/engine/schema/upgrades/2008111901.sql b/engine/schema/upgrades/2008111901.sql new file mode 100644 index 000000000..ee227d4d0 --- /dev/null +++ b/engine/schema/upgrades/2008111901.sql @@ -0,0 +1,8 @@ + CREATE TABLE IF NOT EXISTS `prefix_private_settings` ( + `id` INT NOT NULL , + `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; \ No newline at end of file -- cgit v1.2.3