diff options
| author | Kim Alvefur <zash@zash.se> | 2013-10-30 22:27:22 +0100 |
|---|---|---|
| committer | Kim Alvefur <zash@zash.se> | 2013-10-30 22:27:22 +0100 |
| commit | 18c0eafd7ac0a1e90c593824e02af01b6eb401b8 (patch) | |
| tree | 1d9a0fd90dcc23da7fb6ca2c13da25cc88832b9e | |
| parent | 1ffe00783ee9b52984d362564ca71ce9301f37c5 (diff) | |
| download | prosody-18c0eafd7ac0a1e90c593824e02af01b6eb401b8.tar.gz prosody-18c0eafd7ac0a1e90c593824e02af01b6eb401b8.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.lua | 2 |
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 }; |