server: autoincrement on msgid to prevent reuse if room is deleted

1 files changed, 2 insertions, 2 deletions

diff --git a/schema.sql b/schema.sql
index 5a1938c..f1d33fc 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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,