text: --
  -- Database: `cvwo`
  --
  CREATE DATABASE IF NOT EXISTS `cvwo` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  USE `cvwo`;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tasks`
  --
  
  DROP TABLE IF EXISTS `tasks`;
  CREATE TABLE IF NOT EXISTS `tasks` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL,
    `taskName` varchar(50) NOT NULL,
    `description` text NOT NULL,
    `category` varchar(20) NOT NULL,
    `timestamp` datetime NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE IF NOT EXISTS `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `email` varchar(100) NOT NULL,
    `password` varchar(300) NOT NULL,
    `timestamp` datetime NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  COMMIT;
  
  