--
-- Host: localhost    Database: nodeboilerplate_sequelize
-- ------------------------------------------------------


--
-- Table structure for table `Task`
--

CREATE TABLE `Task` (
  `id` int NOT NULL AUTO_INCREMENT,
  `task` varchar(255) NOT NULL,
  `picture` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Task`
--

INSERT INTO `Task` VALUES (3,'This is task 2','newName_1599659097301.jpg',0,'2020-09-09 13:21:04','2020-09-09 13:44:57');

--
-- Table structure for table `User`
--

CREATE TABLE `User` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `bio` text,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `is_verified` tinyint(1) NOT NULL DEFAULT '0',
  `token` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `User`
--

INSERT INTO `User` VALUES (1,NULL,NULL,NULL,'aslam.doctor@gmail.com','$2a$10$7GK7Mswnlrvhru4jCd1p.u8Ss/G2mmvSihnALQnQf4AhI8DOoqbb2',1,'','2020-09-09 15:51:29','2020-09-09 17:00:40'),(2,'Jahn','Doe','Hello, I am John Doe.','john@doe.com','$2a$10$mLZM/wKT3R.I32XSk9g5puFiBH/8f.BEfAy/C9Jbyz2zmhnODK8bi',1,'','2020-09-09 16:00:28','2020-09-09 16:48:11');


