From 28af8ed412224bd8969db98521b67e0f4027ddf7 Mon Sep 17 00:00:00 2001 From: UnavailableDev <69792062+UnavailableDev@users.noreply.github.com> Date: Wed, 26 Oct 2022 20:42:50 +0200 Subject: added seeded data for temperature and humidity --- scripts/db-add.sql | 194 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 194 insertions(+) create mode 100644 scripts/db-add.sql diff --git a/scripts/db-add.sql b/scripts/db-add.sql new file mode 100644 index 0000000..6b202aa --- /dev/null +++ b/scripts/db-add.sql @@ -0,0 +1,194 @@ +INSERT INTO `WSdb`.`tblMain` (temperature, humidity) VALUES +-- 20.6, 77.7, 0.59, now() +(23.6,57), +(23.6,57), +(23.6,56), +(23.6,56), +(23.5,58), +(23.4,59), +(23.4,59), +(23.4,60), +(23.4,60), +(23.4,60), +(23.3,60), +(23.3,60), +(23.3,60), +(23.2,60), +(23.4,60), +(23.3,60), +(23.2,60), +(23.2,59), +(23.1,59), +(23.1,59), +(23.0,59), +(23.0,59), +(22.9,59), +(22.9,59), +(22.9,58), +(22.8,58), +(22.8,58), +(22.8,58), +(22.8,58), +(22.7,58), +(22.7,58), +(22.7,58), +(22.6,58), +(22.6,58), +(22.6,58), +(22.6,58), +(22.5,58), +(22.5,58), +(22.5,58), +(22.4,58), +(22.4,58), +(22.4,58), +(22.4,57), +(22.4,57), +(22.3,57), +(22.3,57), +(22.3,57), +(22.3,57), +(22.3,57), +(22.4,57), +(22.7,57), +(22.9,57), +(23.0,57), +(23.2,57), +(23.2,57), +(23.1,59), +(23.0,59), +(23.0,59), +(23.2,58), +(23.4,58), +(23.4,58), +(23.5,57), +(23.6,57), +(23.7,57), +(23.7,57), +(23.8,57), +(23.9,57), +(23.8,59), +(23.8,59), +(23.7,58), +(23.6,58), +(23.5,58), +(23.5,58), +(23.4,57), +(23.5,59), +(23.8,58), +(23.7,59), +(23.7,59), +(23.7,59), +(23.9,59), +(23.8,57), +(23.7,56), +(23.5,55), +(23.4,54), +(23.4,54), +(23.6,53), +(23.6,56), +(23.7,55), +(23.7,54), +(23.8,54), +(23.8,54), +(23.8,55), +(23.7,55), +(23.6,55), +(23.5,55), +(23.5,56), +(23.4,56), +(23.4,58), +(23.3,59), +(23.4,63), +(23.4,63), +(23.4,63), +(23.4,63), +(23.4,63), +(23.3,64), +(23.2,63), +(23.2,62), +(23.1,62), +(23.1,61), +(23.0,61), +(22.9,61), +(22.9,61), +(22.9,61), +(22.8,60), +(22.8,60), +(22.8,60), +(22.7,60), +(22.7,60), +(22.6,60), +(22.6,60), +(22.5,59), +(22.5,59), +(22.5,59), +(22.4,59), +(22.4,59), +(22.4,59), +(22.4,59), +(22.4,59), +(22.4,58), +(22.3,58), +(22.3,58), +(22.3,58), +(22.3,58), +(22.2,58), +(22.2,58), +(22.2,58), +(22.2,58), +(22.2,58), +(22.1,58), +(22.1,58), +(22.1,58), +(22.1,57), +(22.0,57), +(22.0,57), +(22.0,57), +(22.1,58), +(22.4,57), +(22.5,58), +(22.6,58), +(22.7,58), +(22.8,58), +(22.9,58), +(22.9,58), +(22.8,57), +(22.7,57), +(22.7,57), +(22.9,57), +(22.9,57), +(23.0,58), +(23.2,58), +(23.3,58), +(23.2,59), +(23.2,59), +(23.2,58), +(23.4,58), +(23.6,59), +(23.7,59), +(23.9,59), +(24.0,58), +(23.9,55), +(23.9,54), +(23.9,55), +(24.0,55), +(24.2,55), +(24.2,55), +(24.1,56), +(24.0,55), +(24.0,56), +(23.9,57), +(23.9,56), +(24.0,55), +(24.1,55), +(23.9,56), +(23.9,56), +(23.9,56), +(23.9,56), +(23.8,56), +(23.8,56), +(23.7,56), +(23.7,56), +(23.6,58), +(23.6,59); -- cgit v1.2.3