diff options
author | Tom Smeding <tom.smeding@gmail.com> | 2020-08-01 14:54:19 +0200 |
---|---|---|
committer | Tom Smeding <tom.smeding@gmail.com> | 2020-08-01 14:54:19 +0200 |
commit | 4c5dee222b940dcfdf6f7356b6fa3b3bf4dbcb73 (patch) | |
tree | 0819d116d4d0c388abab6b417c90e386245ec2cc /schema.sql | |
parent | 6244f4a65aa391cae85bfc6930589ba7feaa536e (diff) |
server: autoincrement on msgid to prevent reuse if room is deleted
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -1,4 +1,4 @@ --- Database schema version 2 +-- Database schema version 3 pragma foreign_keys = on; @@ -29,7 +29,7 @@ create table Users ( create unique index users_name_index on Users(name); create table Messages ( - id integer primary key not null, + id integer primary key autoincrement not null, room integer not null, user integer null, time integer not null, |