From b796a0b5aa59bba09127be4f8d599e30e3603879 Mon Sep 17 00:00:00 2001
From: gamesguru <mathmuncher11@gmail.com>
Date: Fri, 2 Oct 2020 21:57:37 -0400
Subject: [PATCH] wip

---
 sql/data/sync_data.csv | 4 ++++
 sql/import.sql         | 1 +
 sql/tables.sql         | 7 +++++--
 3 files changed, 10 insertions(+), 2 deletions(-)
 create mode 100644 sql/data/sync_data.csv

diff --git a/sql/data/sync_data.csv b/sql/data/sync_data.csv
new file mode 100644
index 0000000..160e540
--- /dev/null
+++ b/sql/data/sync_data.csv
@@ -0,0 +1,4 @@
+id,tablename,guid,constraint,action
+1,users,a0fdac7ab369de43f029a460879c854f,,INSERT
+2,users,7abf05c84beb849628a44336acfe7a5b,,INSERT
+3,users,2454c8ab7c575cd2610f9977ed3b2b61,,INSERT
diff --git a/sql/import.sql b/sql/import.sql
index 3dc8803..465650d 100644
--- a/sql/import.sql
+++ b/sql/import.sql
@@ -15,6 +15,7 @@
 -- along with this program.  If not, see <https://www.gnu.org/licenses/>.
 
 .mode csv
+.nullvalue NULL
 
 .import '| tail -n +2 ./data/bmr_eqs.csv' bmr_eqs
 .import '| tail -n +2 ./data/bf_eqs.csv' bf_eqs
diff --git a/sql/tables.sql b/sql/tables.sql
index 14c56b7..fdc63e5 100644
--- a/sql/tables.sql
+++ b/sql/tables.sql
@@ -29,12 +29,12 @@ INSERT INTO version(version, created, notes)
 
 CREATE TABLE bmr_eqs (
   id integer PRIMARY KEY AUTOINCREMENT,
-  name text
+  name text NOT NULL
 );
 
 CREATE TABLE bf_eqs (
   id integer PRIMARY KEY AUTOINCREMENT,
-  name text
+  name text NOT NULL
 );
 
 --
@@ -76,6 +76,9 @@ CREATE TABLE biometric_log (
   id integer PRIMARY KEY AUTOINCREMENT,
   guid text NOT NULL DEFAULT (lower(hex (randomblob (16)))) UNIQUE,
   user_id int NOT NULL,
+  created int DEFAULT (strftime ('%s', 'now')),
+  updated int DEFAULT (strftime ('%s', 'now')),
+  synced int DEFAULT -1,
   date int DEFAULT (strftime ('%s', 'now')),
   tags text,
   notes text,
-- 
2.52.0