From 638a668286eb843325db4daea5218e39778f548c Mon Sep 17 00:00:00 2001 From: Kyle Hooks Date: Thu, 28 Oct 2021 10:50:03 -0400 Subject: [PATCH] updating tables for usage in app 2 --- sql/tables.sql | 19 +------------------ 1 file changed, 1 insertion(+), 18 deletions(-) diff --git a/sql/tables.sql b/sql/tables.sql index 2aebf12..97a29a9 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -14,24 +14,7 @@ -- You should have received a copy of the GNU General Public License -- along with this program. If not, see . -CREATE TABLE version( id integer PRIMARY KEY AUTOINCREMENT, version text NOT NULL, created date NOT NULL, notes text -); - --- TODO: enforce FK constraint across two DBs? --- ---------------------------------- --- Equations ---------------------------------- - -CREATE TABLE bmr_eqs ( - id integer PRIMARY KEY AUTOINCREMENT, - name text NOT NULL -); - -CREATE TABLE bf_eqs ( - id integer PRIMARY KEY AUTOINCREMENT, - name text NOT NULL -); +CREATE TABLE version( id integer PRIMARY KEY AUTOINCREMENT, version text NOT NULL, created date NOT NULL, notes text); -- -------------------------------- -- 2.52.0