diff options
author | Michael Vetter <jubalh@iodoru.org> | 2020-03-27 18:29:03 +0100 |
---|---|---|
committer | Michael Vetter <jubalh@iodoru.org> | 2020-04-06 10:50:20 +0200 |
commit | fe67102e716f4b1c7208c2b149a0b7be5a6d5a36 (patch) | |
tree | cd816ff60af64e1eea5b598d1d8974853d181e2b /src/database.c | |
parent | c56443fea529b4ab78204ad4f8ada43b477ffe61 (diff) | |
download | profani-tty-fe67102e716f4b1c7208c2b149a0b7be5a6d5a36.tar.gz |
db: make id autoincrement
Diffstat (limited to 'src/database.c')
-rw-r--r-- | src/database.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/database.c b/src/database.c index 09402bc5..a2be7f40 100644 --- a/src/database.c +++ b/src/database.c @@ -100,7 +100,7 @@ log_database_init(ProfAccount *account) } char *err_msg; - char *query = "CREATE TABLE IF NOT EXISTS `ChatLogs` ( `cl_id` INTEGER PRIMARY KEY, `jid` TEXT NOT NULL, `resource` TEXT, `message` TEXT, `timestamp` TEXT, `is_muc` INTEGER, `stanza_id` TEXT, `replace_id` TEXT)"; + char *query = "CREATE TABLE IF NOT EXISTS `ChatLogs` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `jid` TEXT NOT NULL, `resource` TEXT, `message` TEXT, `timestamp` TEXT, `is_muc` INTEGER, `stanza_id` TEXT, `replace_id` TEXT)"; if( SQLITE_OK != sqlite3_exec(g_chatlog_database, query, NULL, 0, &err_msg)) { goto out; } |