Add support for another beverages (namely club mate)

[coffee/coffee-flask.git] / coffee_db.sql

diff --git a/coffee_db.sql b/coffee_db.sql
index 03a7e7cd86d621bb5f4d66c6e5f58d671622d1e1..acb42a2edd712cc790d17da66b540c3a6189ec35 100644 (file)
--- a/coffee_db.sql
+++ b/coffee_db.sql
@@ -6,14 +6,17 @@ create table if not exists users (
 );
 
 create table if not exists flavors (
-    name varchar(255) primary key not null
+    name varchar(255) primary key not null,
+    ord integer not null default 999
 );
 
 insert or ignore into flavors values
-    ("espresso"),
-    ("espresso lungo"),
-    ("cappuccino"),
-    ("latte macchiato")
+    ("espresso", 2),
+    ("espresso lungo", 3),
+    ("cappuccino", 1),
+    ("latte macchiato", 4),
+    ("Club-Mate 0,5 l", 5),
+    ("Club-Mate 0,33 l", 6)
 ;
 
 create table if not exists coffees (