aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorKim Alvefur <zash@zash.se>2013-10-30 22:27:22 +0100
committerKim Alvefur <zash@zash.se>2013-10-30 22:27:22 +0100
commitabb45cc639f5974aaf5c4fd61618886aa492425b (patch)
tree1d9a0fd90dcc23da7fb6ca2c13da25cc88832b9e
parent029256f34a7f430d379007f783d9f6c1a86da1f8 (diff)
downloadprosody-abb45cc639f5974aaf5c4fd61618886aa492425b.tar.gz
prosody-abb45cc639f5974aaf5c4fd61618886aa492425b.zip
mod_storage_sql2: Use primary_key and auto_increment flags instead of baking that into the type
-rw-r--r--plugins/mod_storage_sql2.lua2
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/mod_storage_sql2.lua b/plugins/mod_storage_sql2.lua
index dcd7a45a..a4f47a87 100644
--- a/plugins/mod_storage_sql2.lua
+++ b/plugins/mod_storage_sql2.lua
@@ -64,7 +64,7 @@ local function create_table()
local ProsodyArchiveTable = Table {
name="prosodyarchive";
- Column { name="sort_id", type="INTEGER PRIMARY KEY AUTOINCREMENT", nullable=false };
+ Column { name="sort_id", type="INTEGER", primary_key=true, auto_increment=true, nullable=false };
Column { name="host", type="TEXT", nullable=false };
Column { name="user", type="TEXT", nullable=false };
Column { name="store", type="TEXT", nullable=false };