diff options
author | Tom Smeding <tom.smeding@gmail.com> | 2020-07-30 20:45:54 +0200 |
---|---|---|
committer | Tom Smeding <tom.smeding@gmail.com> | 2020-07-30 20:45:54 +0200 |
commit | 6244f4a65aa391cae85bfc6930589ba7feaa536e (patch) | |
tree | d73c2a136bcfd124e8051eb09268af8fedfdbd3b /schema.sql | |
parent | dd40033d6d6358da8d065db04b3bfbcd834202ff (diff) | |
parent | 79c8ffd915115728070339f30d57a3a3e31bd322 (diff) |
Merge branch 'version2'
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 6 |
1 files changed, 5 insertions, 1 deletions
@@ -1,3 +1,5 @@ +-- Database schema version 2 + pragma foreign_keys = on; create table Meta ( @@ -31,9 +33,11 @@ create table Messages ( room integer not null, user integer null, time integer not null, + reply integer null, message blob, foreign key(room) references Rooms(id) on delete cascade, - foreign key(user) references Users(id) on delete set null + foreign key(user) references Users(id) on delete set null, + foreign key(reply) references Messages(id) on delete set null ); create index messages_time_index on Messages(room, time desc); |