ColorFlow Habits is a visual task tracking app that turns your daily activities into a vivid color spectrum, offering a captivating and motivating way to monitor your progress and habits throughout the year.
SQL files to be executed from java code for table creation
Required INSERT commands
MySQL config information
Fix for #14
Tested the code with a local Java CommandLineRunner. Test IP/OP Details
USE colorflow;
show tables;
category
task
user
DESCRIBE category;
category_id bigint NO PRI auto_increment
category_color varchar(7) NO
category_description varchar(500) YES
category_name varchar(100) NO
create_time timestamp YES CURRENT_TIMESTAMP DEFAULT_GENERATED
last_modified timestamp YES CURRENT_TIMESTAMP DEFAULT_GENERATED
SELECT * FROM colorflow.category;
1 #FFFFFF Miscellaneous category as a default Misc 2023-09-11 00:24:44 2023-09-11 00:24:44
Added following -
Tested the code with a local Java CommandLineRunner. Test IP/OP Details