diff options
| author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-12-05 12:05:59 +0000 |
|---|---|---|
| committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-12-05 12:05:59 +0000 |
| commit | 7a5007f929a241c318325fa29a62e162a2b78bfa (patch) | |
| tree | 5c7d8474471cc319c2f9c02a41773f382654cd38 /engine/schema/upgrades/2008120501.sql | |
| parent | 2ec34ab24b4ec17fe28521de36bade6a5fb350a1 (diff) | |
| download | elgg-7a5007f929a241c318325fa29a62e162a2b78bfa.tar.gz elgg-7a5007f929a241c318325fa29a62e162a2b78bfa.tar.bz2 | |
Closes #611: Made name field longer
git-svn-id: https://code.elgg.org/elgg/trunk@2506 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema/upgrades/2008120501.sql')
| -rw-r--r-- | engine/schema/upgrades/2008120501.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/engine/schema/upgrades/2008120501.sql b/engine/schema/upgrades/2008120501.sql new file mode 100644 index 000000000..bd08556ee --- /dev/null +++ b/engine/schema/upgrades/2008120501.sql @@ -0,0 +1,9 @@ +-- Modify field length in private settings (for people who upgraded while #611 present) +ALTER TABLE `prefix_private_settings` MODIFY `name` varchar(128) NOT NULL; + +-- While we're at it, add some more keys +ALTER TABLE `prefix_private_settings` DROP KEY `name`; +ALTER TABLE `prefix_private_settings` ADD KEY `name` (`name`); + +ALTER TABLE `prefix_private_settings` DROP KEY `value`; +ALTER TABLE `prefix_private_settings` ADD KEY `value` (`value`);
\ No newline at end of file |