From e2f3393ba41e4e151e52f48e1672488cedacf7bb Mon Sep 17 00:00:00 2001 From: gamesguru Date: Wed, 21 Apr 2021 11:30:23 -0400 Subject: [PATCH] add food_costs table --- sql/data/food_costs.csv | 0 sql/tables.sql | 12 ++++++++++++ 2 files changed, 12 insertions(+) create mode 100644 sql/data/food_costs.csv diff --git a/sql/data/food_costs.csv b/sql/data/food_costs.csv new file mode 100644 index 0000000..e69de29 diff --git a/sql/tables.sql b/sql/tables.sql index 8414f5c..550930b 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -56,6 +56,18 @@ CREATE TABLE profiles ( FOREIGN KEY (bf_eq_id) REFERENCES bf_eqs (id) ON UPDATE CASCADE ); +-- +-------------------------------- +-- Food costs +-------------------------------- + +CREATE TABLE food_costs ( + id integer PRIMARY KEY AUTOINCREMENT, + profile_id integer NOT NULL, + food_id integer NOT NULL, + cost real NOT NULL +); + -- -------------------------------- -- Biometrics -- 2.52.0