aboutsummaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql4
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,