From 5a77c89fc8c5758802d9c529a452f8066f1841e7 Mon Sep 17 00:00:00 2001 From: Shane Jaroch Date: Wed, 30 Sep 2020 10:22:26 -0400 Subject: [PATCH] leave FKs missing on datasrcln for now --- sql/import.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/import.sql b/sql/import.sql index 4f90795..61095fd 100644 --- a/sql/import.sql +++ b/sql/import.sql @@ -39,9 +39,9 @@ PRAGMA foreign_keys = 1; .import '| tail -n +2 ../data/nt/data_src.csv' data_src -- TODO: fix "INSERT failed: FOREIGN KEY constraint failed" -PRAGMA foreign_keys = 0; +-- PRAGMA foreign_keys = 0; .import '| tail -n +2 ../data/nt/datsrcln.csv' datsrcln -PRAGMA foreign_keys = 1; +-- PRAGMA foreign_keys = 1; .import '| tail -n +2 ../data/nt/serv_desc.csv' serv_desc .import '| tail -n +2 ../data/nt/serving.csv' serving -- 2.52.0