sql.php

<?php
	require_once 'db.php';

	$sql = "INSERT INTO users (name,email,password) VALUES('Md. Mostafa Kamal','mostafa.kamal@desco.org.bd','690437692d902cfd23005bda16631d83644899e78dc0a489da6dca3cb9f9c0cdcd9dd533bc59102dc90155223df777672328c9149354de239f48c58f0a1d44a6');";
	$sql2 = <<<EOF
	PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "minutes2" (
	"id"	INTEGER,
	"minutes"	INTEGER,
	"temp"	REAL,
	"time_stamp"	INTEGER,
	PRIMARY KEY("id" AUTOINCREMENT)
);
INSERT INTO minutes2 VALUES(1,0,33.520000000000003126,1614096027);
INSERT INTO minutes2 VALUES(2,1,33.520000000000003126,1614096088);
INSERT INTO minutes2 VALUES(3,2,33.189999999999997726,1614096148);
INSERT INTO minutes2 VALUES(4,3,33.189999999999997726,1614096209);
INSERT INTO minutes2 VALUES(5,4,33.189999999999997726,1614096269);
INSERT INTO minutes2 VALUES(6,5,33.189999999999997726,1614096329);
INSERT INTO minutes2 VALUES(7,6,33.189999999999997726,1614096390);
INSERT INTO minutes2 VALUES(8,7,33.189999999999997726,1614096450);
INSERT INTO minutes2 VALUES(9,8,33.189999999999997726,1614096510);
INSERT INTO minutes2 VALUES(10,9,33.189999999999997726,1614096571);
INSERT INTO minutes2 VALUES(11,10,33.520000000000003126,1614096631);
INSERT INTO minutes2 VALUES(12,11,33.520000000000003126,1614096692);
INSERT INTO minutes2 VALUES(13,12,33.189999999999997726,1614096752);
INSERT INTO minutes2 VALUES(14,13,33.189999999999997726,1614096812);
INSERT INTO minutes2 VALUES(15,14,33.189999999999997726,1614096875);
INSERT INTO minutes2 VALUES(16,15,33.189999999999997726,1614096937);
INSERT INTO minutes2 VALUES(17,16,33.189999999999997726,1614096997);
INSERT INTO minutes2 VALUES(18,17,33.189999999999997726,1614097058);
INSERT INTO minutes2 VALUES(19,18,33.189999999999997726,1614097118);
INSERT INTO minutes2 VALUES(20,19,33.189999999999997726,1614097178);
INSERT INTO minutes2 VALUES(21,20,33.189999999999997726,1614097239);
INSERT INTO minutes2 VALUES(22,21,33.189999999999997726,1614097299);
INSERT INTO minutes2 VALUES(23,22,33.189999999999997726,1614097360);
INSERT INTO minutes2 VALUES(24,23,33.189999999999997726,1614097420);
INSERT INTO minutes2 VALUES(25,24,33.189999999999997726,1614097480);
INSERT INTO minutes2 VALUES(26,25,33.189999999999997726,1614097543);
INSERT INTO minutes2 VALUES(27,26,33.189999999999997726,1614097604);
INSERT INTO minutes2 VALUES(28,27,32.869999999999997442,1614097664);
INSERT INTO minutes2 VALUES(29,28,33.520000000000003126,1614097725);
INSERT INTO minutes2 VALUES(30,29,33.520000000000003126,1614097785);
INSERT INTO minutes2 VALUES(31,30,33.189999999999997726,1614097845);
INSERT INTO minutes2 VALUES(32,31,33.189999999999997726,1614097906);
INSERT INTO minutes2 VALUES(33,32,33.189999999999997726,1614097966);
INSERT INTO minutes2 VALUES(34,33,33.520000000000003126,1614098027);
INSERT INTO minutes2 VALUES(35,34,33.520000000000003126,1614098087);
INSERT INTO minutes2 VALUES(36,35,33.520000000000003126,1614098147);
INSERT INTO minutes2 VALUES(37,36,33.520000000000003126,1614098208);
INSERT INTO minutes2 VALUES(38,37,33.520000000000003126,1614098268);
INSERT INTO minutes2 VALUES(39,38,33.189999999999997726,1614098328);
INSERT INTO minutes2 VALUES(40,39,33.520000000000003126,1614098389);
INSERT INTO minutes2 VALUES(41,40,33.189999999999997726,1614098449);
INSERT INTO minutes2 VALUES(42,41,33.189999999999997726,1614098509);
INSERT INTO minutes2 VALUES(43,42,33.189999999999997726,1614098570);
INSERT INTO minutes2 VALUES(44,43,32.869999999999997442,1614098630);
INSERT INTO minutes2 VALUES(45,44,33.189999999999997726,1614098691);
INSERT INTO minutes2 VALUES(46,45,33.189999999999997726,1614098751);
INSERT INTO minutes2 VALUES(47,46,33.189999999999997726,1614098812);
INSERT INTO minutes2 VALUES(48,47,33.189999999999997726,1614098872);
INSERT INTO minutes2 VALUES(49,48,33.189999999999997726,1614098932);
INSERT INTO minutes2 VALUES(50,49,33.189999999999997726,1614098993);
INSERT INTO minutes2 VALUES(51,50,33.189999999999997726,1614099053);
INSERT INTO minutes2 VALUES(52,51,33.189999999999997726,1614099114);
INSERT INTO minutes2 VALUES(53,52,33.189999999999997726,1614099174);
INSERT INTO minutes2 VALUES(54,53,33.189999999999997726,1614095602);
INSERT INTO minutes2 VALUES(55,54,33.189999999999997726,1614095662);
INSERT INTO minutes2 VALUES(56,55,33.189999999999997726,1614095723);
INSERT INTO minutes2 VALUES(57,56,33.520000000000003126,1614095783);
INSERT INTO minutes2 VALUES(58,57,33.189999999999997726,1614095846);
INSERT INTO minutes2 VALUES(59,58,33.520000000000003126,1614095907);
INSERT INTO minutes2 VALUES(60,59,33.520000000000003126,1614095967);
CREATE TABLE hours2 (
	id integer PRIMARY KEY,
	date text NOT NULL,
	hour integer NOT NULL,
	temp REAL NOT NULL,
	timestamp integer NOT NULL UNIQUE
); 
EOF;

	$db->query($sql);
	$db->query($sql2);

	$db->close();
unset($db);
?>