aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/upgrades
diff options
context:
space:
mode:
authorben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-11-19 19:34:12 +0000
committerben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-11-19 19:34:12 +0000
commit131e9de561f2237fa9b5b70ac15fa4ac1c555afb (patch)
tree0b857725b153cb5f127e5c8a8e6b5f2967158a84 /engine/schema/upgrades
parentee31f4c6cc9bcdf823c5c0bf7bf8582c02f05a3b (diff)
downloadelgg-131e9de561f2237fa9b5b70ac15fa4ac1c555afb.tar.gz
elgg-131e9de561f2237fa9b5b70ac15fa4ac1c555afb.tar.bz2
Introducing the new private settings table.
git-svn-id: https://code.elgg.org/elgg/trunk@2464 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema/upgrades')
-rw-r--r--engine/schema/upgrades/2008111901.sql8
1 files changed, 8 insertions, 0 deletions
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