From 707ef29ee108b5c6168e23f620c7456eefb73f35 Mon Sep 17 00:00:00 2001 From: Shane Jaroch Date: Tue, 11 Aug 2020 21:41:55 -0400 Subject: [PATCH] rename: nt_ver -> version --- sql/import.sql | 2 +- sql/tables.sql | 2 +- sql/{nt_ver.csv => version.csv} | 1 + 3 files changed, 3 insertions(+), 2 deletions(-) rename sql/{nt_ver.csv => version.csv} (77%) diff --git a/sql/import.sql b/sql/import.sql index df5e149..8716ce4 100644 --- a/sql/import.sql +++ b/sql/import.sql @@ -16,7 +16,7 @@ .mode csv -.import '| tail -n +2 nt_ver.csv' nt_ver +.import '| tail -n +2 version.csv' version .import '| tail -n +2 ../data/nt/nutr_def.csv' nutr_def .import '| tail -n +2 ../data/nt/fdgrp.csv' fdgrp diff --git a/sql/tables.sql b/sql/tables.sql index b0df172..503bcc5 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -14,7 +14,7 @@ -- You should have received a copy of the GNU General Public License -- along with this program. If not, see . -CREATE TABLE nt_ver ( +CREATE TABLE version ( id integer PRIMARY KEY AUTOINCREMENT, version text NOT NULL, created timestamp DEFAULT CURRENT_TIMESTAMP diff --git a/sql/nt_ver.csv b/sql/version.csv similarity index 77% rename from sql/nt_ver.csv rename to sql/version.csv index f1d5f1d..581793d 100644 --- a/sql/nt_ver.csv +++ b/sql/version.csv @@ -2,3 +2,4 @@ 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 3,0.0.2,Thu 06 Aug 2020 11:39:54 AM EDT +4,0.0.3,Tue 11 Aug 2020 09:37:50 PM EDT -- 2.52.0