added seeded data for temperature and humidity

1 files changed, 194 insertions, 0 deletions

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);