From 92c97520fe9dbb288c96cfc9d363ec2710739f92 Mon Sep 17 00:00:00 2001 From: Kyle Hooks Date: Sat, 6 Nov 2021 08:51:46 -0400 Subject: [PATCH] user profile image --- sql/data/profiles.csv | 4 ++-- sql/tables.sql | 1 + 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/sql/data/profiles.csv b/sql/data/profiles.csv index 3ad8ba6..333fa8b 100644 --- a/sql/data/profiles.csv +++ b/sql/data/profiles.csv @@ -1,2 +1,2 @@ -id,name,created,updated,eula,gender,dob,act_lvl,goal_wt,goal_bf,bmr_eq_id,bf_eq_id,pwd_hash -1,New User,1601067725,1601067725,,MALE,2001-01-01,2,78,0.12,1,1,password +id,name,created,updated,eula,gender,dob,act_lvl,goal_wt,goal_bf,bmr_eq_id,bf_eq_id,pwd_hash,img_data +1,New User,1601067725,1601067725,,MALE,2001-01-01,2,78,0.12,1,1,password, diff --git a/sql/tables.sql b/sql/tables.sql index 97a29a9..2c3038f 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -35,6 +35,7 @@ CREATE TABLE profiles ( goal_bf real, bmr_eq_id int DEFAULT 1, bf_eq_id int DEFAULT 1, + img_data text, FOREIGN KEY (bmr_eq_id) REFERENCES bmr_eqs (id) ON UPDATE CASCADE, FOREIGN KEY (bf_eq_id) REFERENCES bf_eqs (id) ON UPDATE CASCADE ); -- 2.52.0