prosody
cbc25ae1eea0
util/sql.lua

Find changesets by keywords by author, files, the commit message, revision number or hash, or revset expression.

Software / code / prosody

Comparison

util/sql.lua @ 5885:cbc25ae1eea0

util.sql: Allow creating unique indices
author Kim Alvefur <zash@zash.se>
date Mon, 28 Oct 2013 23:18:54 +0100
parent 5883:39b187e7e892
child 5886:1237f9cc3123
comparison
equal deleted inserted replaced
5884:9cb81a17ae23 5885:cbc25ae1eea0
249 if self.params.driver == "PostgreSQL" then 249 if self.params.driver == "PostgreSQL" then
250 sql = sql:gsub("`", "\""); 250 sql = sql:gsub("`", "\"");
251 elseif self.params.driver == "MySQL" then 251 elseif self.params.driver == "MySQL" then
252 sql = sql:gsub("`([,)])", "`(20)%1"); 252 sql = sql:gsub("`([,)])", "`(20)%1");
253 end 253 end
254 if index.unique then
255 sql = sql:gsub("^CREATE", "CREATE UNIQUE");
256 end
254 --print(sql); 257 --print(sql);
255 return self:execute(sql); 258 return self:execute(sql);
256 end 259 end
257 function engine:_create_table(table) 260 function engine:_create_table(table)
258 local sql = "CREATE TABLE `"..table.name.."` ("; 261 local sql = "CREATE TABLE `"..table.name.."` (";