Fix column name in UNIQUE index

Thanks to Jiri for noticing that.

diff --git a/coffee_db.sql b/coffee_db.sql
index 380e229bba02e5afc94909e47e03f6c788c93c78..03a7e7cd86d621bb5f4d66c6e5f58d671622d1e1 100644 (file)
--- a/coffee_db.sql
+++ b/coffee_db.sql
@@ -21,7 +21,7 @@ create table if not exists coffees (
     id varchar(24) references users(id), -- id may be unknown
     flavor varchar(255) not null references flavors(name),
     time datetime default current_timestamp,
-    UNIQUE (id, flavor, datetime)
+    UNIQUE (id, flavor, time)
 );