From 27b595df0fd78dcd9d7df39b4265ebab3d8599c3 Mon Sep 17 00:00:00 2001 From: Kyle Hooks Date: Sat, 6 Nov 2021 19:11:12 -0400 Subject: [PATCH] preparing for real logins --- sql/data/profiles.csv | 2 -- sql/data/version.csv | 3 ++- sql/tables.sql | 6 +----- 3 files changed, 3 insertions(+), 8 deletions(-) delete mode 100644 sql/data/profiles.csv diff --git a/sql/data/profiles.csv b/sql/data/profiles.csv deleted file mode 100644 index 333fa8b..0000000 --- a/sql/data/profiles.csv +++ /dev/null @@ -1,2 +0,0 @@ -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/data/version.csv b/sql/data/version.csv index a27c247..0639a9e 100644 --- a/sql/data/version.csv +++ b/sql/data/version.csv @@ -6,4 +6,5 @@ id,version,created,notes 5,0.0.4,2021-06-17,"add custom foods tables (custom_foods, cf_dat)" 6,0.0.5,2021-10-28,"update tables to support app (subset of original features)" 7,1.0.0,2021-11-05,"remove test data" -8,1.0.1,2021-11-05,"use field headers from test data" \ No newline at end of file +8,1.0.1,2021-11-05,"use field headers from test data" +9,1.0.2,2021-11-05,"no default profiles and remove bf_eqs, bmr_eqs" \ No newline at end of file diff --git a/sql/tables.sql b/sql/tables.sql index 2c3038f..fea6da4 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -33,11 +33,7 @@ CREATE TABLE profiles ( act_lvl int DEFAULT 2, -- [1, 2, 3, 4, 5] goal_wt real, 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 + img_data text ); -- -- 2.52.0