mod_storage_sql2: Auto increment columns won't be NULL, so drop nullable=false
authorKim Alvefur <zash@zash.se>
Mon, 11 Nov 2013 23:15:26 +0100
changeset 5913 6865eecaf5a5
parent 5912 f6145e894569
child 5914 eda2556aa139
child 5916 1c4405f33561
mod_storage_sql2: Auto increment columns won't be NULL, so drop nullable=false
plugins/mod_storage_sql2.lua
--- a/plugins/mod_storage_sql2.lua	Mon Nov 11 23:09:18 2013 +0100
+++ b/plugins/mod_storage_sql2.lua	Mon Nov 11 23:15:26 2013 +0100
@@ -44,7 +44,7 @@
 
 	local ProsodyArchiveTable = Table {
 		name="prosodyarchive";
-		Column { name="sort_id", type="INTEGER", primary_key=true, auto_increment=true, nullable=false };
+		Column { name="sort_id", type="INTEGER", primary_key=true, auto_increment=true };
 		Column { name="host", type="TEXT", nullable=false };
 		Column { name="user", type="TEXT", nullable=false };
 		Column { name="store", type="TEXT", nullable=false };