notes

A server-side notes application using MySQL and Javalin (based on Jetty)

setup

MySQL

You will need to install MySQL to use this project.

1. Make a Notes database: create database notes;
2. Add the notes table with schema:

   CREATE TABLE `notes` (
   `id` int(11) NOT NULL,
   `title` varchar(255) DEFAULT NULL,
   `body` varchar(5000) DEFAULT NULL,
   `color` varchar(6) DEFAULT NULL,
   `archived` tinyint(1) DEFAULT '0',
   `html` varchar(10000) DEFAULT NULL,
   `user_id` int(11) DEFAULT NULL
   `ispinned` tinyint(1) NOT NULL DEFAULT '0'
   )

3. Add the users table like so:

   CREATE TABLE `users` (
   `id` int NOT NULL,
   `username` varchar(255) NOT NULL,
   `password` varchar(255) NOT NULL,
   `isactive` tinyint(1) DEFAULT NULL
   )

4. Add the logins table with this schema:

   CREATE TABLE `logins` (
   `id` int NOT NULL,
   `user_id` int NOT NULL,
   `random` varchar(255) NOT NULL,
   `name_hash` varchar(255) NOT NULL,
   `date_created` datetime NOT NULL
   )

Config

You will also have to make a config.json file to hold your SQL information. It should look like this:

{
  "SQL" : {
    "username" : "myname",
    "password" : "mypass",
    "url" : "jdbc:mysql://localhost/NOTES?etcetcetc"
  }
}

Once you have made the database and the config file, you should be ready to go. Run the program by running Main.main()