aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorKim Alvefur <zash@zash.se>2013-10-28 23:18:54 +0100
committerKim Alvefur <zash@zash.se>2013-10-28 23:18:54 +0100
commit6c769838e9a81a145796cb447c03967f5c6fdb7a (patch)
tree10d4a46e9118315fa61171070a641f34bcf71c50
parentf925ba7723bf4336b6ad7089e5cfb8841d5ffa4a (diff)
downloadprosody-6c769838e9a81a145796cb447c03967f5c6fdb7a.tar.gz
prosody-6c769838e9a81a145796cb447c03967f5c6fdb7a.zip
util.sql: Allow creating unique indices
-rw-r--r--util/sql.lua3
1 files changed, 3 insertions, 0 deletions
diff --git a/util/sql.lua b/util/sql.lua
index 972940f7..736417bb 100644
--- a/util/sql.lua
+++ b/util/sql.lua
@@ -251,6 +251,9 @@ function engine:_create_index(index)
elseif self.params.driver == "MySQL" then
sql = sql:gsub("`([,)])", "`(20)%1");
end
+ if index.unique then
+ sql = sql:gsub("^CREATE", "CREATE UNIQUE");
+ end
--print(sql);
return self:execute(sql);
end