Skip to content

Latest commit

 

History

History
31 lines (27 loc) · 506 Bytes

File metadata and controls

31 lines (27 loc) · 506 Bytes

ToDo

環境

  • Python : 3.6.5
  • MySQL : 5.7.22

pip

pip3 install flask mysql-connector-python-rf

or pipenv

pipenv install flask mysql-connector-python-rf
CREATE DATABASE todo
CREATE TABLE `todo`.`task` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `user_name` VARCHAR(45) NOT NULL,
  `task_title` VARCHAR(45) NOT NULL,
  `task_details` VARCHAR(255) NULL,
  `task_limit` DATETIME NOT NULL,
  `insert_date` DATETIME NOT NULL,
  `update_date` DATETIME,
  PRIMARY KEY (`id`));