ToDOList is a simple to do list project. Node Js was used for backend and html, CSS ,... for front end and for api we use axios lib.

We use MySQL for store our users and their notes, so we need a MySQL data base called notes, user of db should be root, and password for db user is 92nEx*s4m#HkqF=e. You can custom above items in config.js.

module.exports = {
	HOST:  "localhost",
    USER:  "root",
    PASSWORD:  "92nEx*s4m#HkqF=e",
    DB:  "notes"
};

To Create users table enter the below code.

CREATE TABLE user ( id int NOT NULL AUTO_INCREMENT, username varchar(255) NOT NULL,password varchar(255), token varchar(255) NOT NULL, PRIMARY KEY (id));

users table should be like this.

To Create notes table enter the below code.

CREATE TABLE user ( id int NOT NULL AUTO_INCREMENT, userId int NOT NULL, title varchar(255),description varchar(255),status int, date varchar(255),time varchar(255), PRIMARY KEY (id) , FOREIGN  KEY (userId) REFERENCES users(id));

notes table should be like this.

To run project you should install node js first.

To run the project go to Server directory then run below command on your terminal or cmd:

npm run start:dev

This project use port number 8080 to run express server.