Mercurial > prosody-hg

comparison plugins/mod_storage_sql2.lua @ 5913:6865eecaf5a5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
mod_storage_sql2: Auto increment columns won't be NULL, so drop nullable=false
author Kim Alvefur <zash@zash.se>
date Mon, 11 Nov 2013 23:15:26 +0100
parents 0e0aab930e10
children e1e9f1411442
comparison
equal deleted inserted replaced
5912:f6145e894569 5913:6865eecaf5a5
42 ProsodyTable:create(engine); 42 ProsodyTable:create(engine);
43 end); 43 end);
44 44
45 local ProsodyArchiveTable = Table { 45 local ProsodyArchiveTable = Table {
46 name="prosodyarchive"; 46 name="prosodyarchive";
47 Column { name="sort_id", type="INTEGER", primary_key=true, auto_increment=true, nullable=false }; 47 Column { name="sort_id", type="INTEGER", primary_key=true, auto_increment=true };
48 Column { name="host", type="TEXT", nullable=false }; 48 Column { name="host", type="TEXT", nullable=false };
49 Column { name="user", type="TEXT", nullable=false }; 49 Column { name="user", type="TEXT", nullable=false };
50 Column { name="store", type="TEXT", nullable=false }; 50 Column { name="store", type="TEXT", nullable=false };
51 Column { name="key", type="TEXT", nullable=false }; -- item id 51 Column { name="key", type="TEXT", nullable=false }; -- item id
52 Column { name="when", type="INTEGER", nullable=false }; -- timestamp 52 Column { name="when", type="INTEGER", nullable=false }; -- timestamp