From b6bdb81f2d76db29b81456097e7bb6d81e9fb07c Mon Sep 17 00:00:00 2001
From: Shane Jaroch <nutratracker@protonmail.com>
Date: Wed, 5 Aug 2020 19:33:55 -0400
Subject: [PATCH] update sql, add readme

---
 README.rst      | 38 ++++++++++++++++++++++++++++++++++++++
 data/import.sql |  2 +-
 data/tables.sql | 13 +++++++------
 3 files changed, 46 insertions(+), 7 deletions(-)
 create mode 100644 README.rst

diff --git a/README.rst b/README.rst
new file mode 100644
index 0000000..6a601e0
--- /dev/null
+++ b/README.rst
@@ -0,0 +1,38 @@
+**********
+ nutra-db
+**********
+
+.. image:: https://api.travis-ci.com/gamesguru/ntdb.svg?branch=master
+    :target: https://travis-ci.com/gamesguru/ntdb
+
+Python, SQL and CSV files for setting up portable SQL database.
+
+See CLI:    https://github.com/nutratech/cli
+
+Pypi page:  https://pypi.org/project/nutra
+
+Building the database
+#########################
+
+1. Inside ``/data`` folder, run :code:`bash setup.sh`
+
+2. Now run :code:`python3 process.py`
+
+3. Create the database with :code:`sqlite3 nutra.db`
+
+4. Create the tables, import the data, and save:
+
+.. code-block:: bash
+
+    .read tables.sql
+    .read import.sql
+    .exit
+
+Tables (Relational Design)
+##########################
+
+See :code:`sql/tables.sql` for details.
+
+This is frequently updated, see :code:`docs/` for more info.
+
+.. image:: docs/nutra.svg
diff --git a/data/import.sql b/data/import.sql
index 2ba1ca4..7ca8ebb 100644
--- a/data/import.sql
+++ b/data/import.sql
@@ -7,7 +7,7 @@
 
 .import '| tail -n +2 nt/src_cd.csv' src_cd
 .import '| tail -n +2 nt/deriv_cd.csv' deriv_cd
--- .import '| tail -n +2 nt/nut_data.csv' nut_data
+.import '| tail -n +2 nt/nut_data.csv' nut_data
 
 
 .import '| tail -n +2 nt/lang_desc.csv' lang_desc
diff --git a/data/tables.sql b/data/tables.sql
index c8d226f..c44d49e 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -33,8 +33,8 @@ CREATE TABLE fdgrp (
 
 CREATE TABLE food_des (
   id integer PRIMARY KEY AUTOINCREMENT,
-  fdgrp_id int,
-  long_desc text,
+  fdgrp_id int NOT NULL,
+  long_desc text NOT NULL,
   shrt_desc text,
   com_name text,
   manufac_name text,
@@ -60,9 +60,9 @@ CREATE TABLE deriv_cd (
 );
 
 CREATE TABLE nut_data (
-  food_id int,
-  nutr_id int,
-  nutr_val float,
+  food_id int NOT NULL,
+  nutr_id int NOT NULL,
+  nutr_val float NOT NULL,
   num_data_pts int,
   std_err float,
   src_cd text,
@@ -76,7 +76,8 @@ CREATE TABLE nut_data (
   low_eb float,
   up_eb float,
   stat_cmt text,
-  add_mod_date date
+  add_mod_date date,
+  cc text
 );
 
 CREATE TABLE lang_desc (
-- 
2.52.0