Software / code / prosody
Changeset
5892:319ccceb1302
mod_storage_sql2: Use primary_key and auto_increment flags instead of baking that into the type
| author | Kim Alvefur <zash@zash.se> |
|---|---|
| date | Wed, 30 Oct 2013 22:27:22 +0100 |
| parents | 5891:b6a56934338c |
| children | 5893:62ce0328fdfe |
| files | plugins/mod_storage_sql2.lua |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/plugins/mod_storage_sql2.lua Wed Oct 30 14:33:15 2013 +0100 +++ b/plugins/mod_storage_sql2.lua Wed Oct 30 22:27:22 2013 +0100 @@ -64,7 +64,7 @@ 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 };
