From beb18470c7324ecbd946e28eff07a4f240f8efac Mon Sep 17 00:00:00 2001
From: Shane Jaroch <nutratracker@protonmail.com>
Date: Wed, 5 Aug 2020 20:16:26 -0400
Subject: [PATCH] add versioning

---
 data/import.sql | 2 ++
 data/nt_ver.csv | 3 +++
 data/tables.sql | 6 ++++++
 3 files changed, 11 insertions(+)
 create mode 100644 data/nt_ver.csv

diff --git a/data/import.sql b/data/import.sql
index 7ca8ebb..adbbd65 100644
--- a/data/import.sql
+++ b/data/import.sql
@@ -1,5 +1,7 @@
 .mode csv
 
+.import '| tail -n +2 nt_ver.csv' nt_ver
+
 .import '| tail -n +2 nt/nutr_def.csv' nutr_def
 .import '| tail -n +2 nt/fdgrp.csv' fdgrp
 .import '| tail -n +2 nt/food_des.csv' food_des
diff --git a/data/nt_ver.csv b/data/nt_ver.csv
new file mode 100644
index 0000000..14c4492
--- /dev/null
+++ b/data/nt_ver.csv
@@ -0,0 +1,3 @@
+id,version,created
+1,0.0.0,Wed 05 Aug 2020 07:09:35 PM EDT
+2,0.0.1,Wed 05 Aug 2020 08:14:52 PM EDT
diff --git a/data/tables.sql b/data/tables.sql
index 9ccd0a8..af2f378 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -14,6 +14,12 @@
 -- You should have received a copy of the GNU General Public License
 -- along with this program.  If not, see <https://www.gnu.org/licenses/>.
 
+CREATE TABLE nt_ver (
+  id integer PRIMARY KEY AUTOINCREMENT,
+  version text NOT NULL,
+  created timestamp DEFAULT CURRENT_TIMESTAMP
+);
+
 CREATE TABLE nutr_def (
   id integer PRIMARY KEY AUTOINCREMENT,
   rda float,
-- 
2.52.0