#
# ChangeLog for db-scripts
#
# Generated by Trac 1.6
# 07/07/26 18:23:54

Mon, 22 Jun 2026 17:00:39 GMT Andrej <asumanovski@…> [545738f]
	* backend/Dockerfile (added)
	* backend/src/main/java/com/trekr/backend/config/SecurityConfig.java (modified)
	* backend/src/main/java/com/trekr/backend/controller/CustomTrackingController.java (modified)
	* backend/src/main/java/com/trekr/backend/dto/discipline/CreateTaskRequest.java (modified)
	* backend/src/main/java/com/trekr/backend/dto/discipline/TaskDto.java (modified)
	* backend/src/main/java/com/trekr/backend/dto/discipline/UpdateTaskRequest.java (modified)
	* backend/src/main/java/com/trekr/backend/entity/discipline/Task.java (modified)
	* backend/src/main/java/com/trekr/backend/repository/TaskRepository.java (modified)
	* backend/src/main/java/com/trekr/backend/service/CustomTrackingService.java (modified)
	* backend/src/main/java/com/trekr/backend/service/DisciplineService.java (modified)
	* db-scripts/ddl.sql (modified)
	* db-scripts/dml.sql (modified)
	* db-scripts/docker-init/01-init.sql (added)
	* db-scripts/migrations/002_task_enhancements.sql (added)
	* docker-compose.yml (added)
	* frontend/Dockerfile (added)
	* frontend/nginx.conf (added)
	* frontend/src/api/discipline.js (modified)
	* frontend/src/pages/Dashboard/pages/CustomCategory/CustomCategoryKanban.jsx (modified)
	* frontend/src/pages/Dashboard/pages/CustomCategory/components/CustomCategoryKanbanBoard.jsx (modified)
	* frontend/src/pages/Dashboard/pages/CustomCategory/components/KanbanColumn.jsx (modified)
	* frontend/src/pages/Dashboard/pages/CustomCategory/components/TaskTicketCard.jsx (modified)

	Switched to dockerized db and improved Task model and Task Ui


Mon, 22 Jun 2026 14:56:41 GMT Andrej <asumanovski@…> [447c39f]
	* AGENTS.md (added)
	* backend/src/main/java/com/trekr/backend/dto/discipline/UpdateTaskStatusRequest.java (added)
	* backend/src/main/java/com/trekr/backend/dto/training/CreateTrainingSessionRequest.java (modified)
	* backend/src/main/java/com/trekr/backend/entity/discipline/TaskStatus.java (added)
	* backend/src/main/java/com/trekr/backend/service/TrainingService.java (modified)
	* db-scripts/migrations/V001__expand_tasks_table.sql (added)
	* db-scripts/tunnel_scripta.sh (modified)
	* frontend/index.html (modified)
	* frontend/public/favicon.png (added)
	* frontend/src/pages/Dashboard/pages/CustomCategory/components/TaskFormModal.jsx (added)
	* frontend/src/pages/Dashboard/pages/Discipline/DisciplineTracking.jsx (modified)
	* frontend/src/pages/Dashboard/pages/Finance/components/NewIncomeForm.jsx (modified)
	* frontend/src/pages/Dashboard/pages/Training/NewTrainingSession.jsx (modified)

	Improved UI and small fixes


Tue, 12 May 2026 22:35:13 GMT Andrej <asumanovski@…> [42da64d]
	* .idea/copilotDiffState.xml (added)
	* backend/docs/Normalization.txt (deleted)
	* backend/docs/P6_Advanced_Reports.txt (deleted)
	* backend/docs/SQL_Injection_Prevention.txt (added)
	* backend/docs/SQL_Injection_Quick_Reference.txt (added)
	* backend/docs/Security_Audit_Report.txt (added)
	* backend/src/main/java/com/trekr/backend/repository/TrainingSessionRepository.java (modified)
	* backend/src/main/java/com/trekr/backend/service/AuthService.java (modified)
	* backend/src/main/java/com/trekr/backend/service/CustomTrackingService.java (modified)
	* backend/src/main/java/com/trekr/backend/service/DisciplineService.java (modified)
	* backend/src/main/java/com/trekr/backend/service/FinanceService.java (modified)
	* backend/src/main/java/com/trekr/backend/service/InvestingService.java (modified)
	* backend/src/main/java/com/trekr/backend/service/TrainingService.java (modified)
	* backend/src/main/java/com/trekr/backend/service/WeightService.java (modified)
	* backend/src/main/resources/application.properties (modified)
	* db-scripts/triggers/compute_daily_completion.sql (added)
	* db-scripts/triggers/compute_daily_completion_all.sql (added)
	* db-scripts/triggers/finance_validate_trigger.sql (added)
	* db-scripts/triggers/uniqueness_and_training_checks.sql (added)
	* db-scripts/views/finance_allocations_view.sql (added)
	* db-scripts/views/finance_monthly_summary_view.sql (added)
	* frontend/src/App.jsx (modified)
	* frontend/src/api/axios.js (modified)
	* frontend/src/pages/Dashboard/DashboardLayout.jsx (modified)
	* frontend/src/pages/Dashboard/pages/Investing/InvestingTracking.jsx (modified)
	* frontend/src/pages/Dashboard/pages/Investing/components/InvestingProgressCard.jsx (modified)
	* frontend/src/pages/LandingPage/components/Benefits.jsx (modified)
	* frontend/src/pages/LandingPage/components/Faq.defaults.js (added)
	* frontend/src/pages/LandingPage/components/Faq.jsx (modified)
	* frontend/src/pages/LandingPage/components/Features.jsx (modified)
	* frontend/src/pages/LandingPage/components/Footer.jsx (modified)
	* frontend/src/pages/LandingPage/components/Hero.jsx (modified)
	* frontend/src/pages/LandingPage/components/HowItWorks.defaults.js (added)
	* frontend/src/pages/LandingPage/components/HowItWorks.defaults.jsx (added)
	* frontend/src/pages/LandingPage/components/HowItWorks.jsx (modified)
	* frontend/src/pages/LandingPage/components/NavbarLanding.jsx (modified)
	* frontend/src/pages/LandingPage/components/Who.defaults.jsx (added)
	* frontend/src/pages/LandingPage/components/Who.jsx (modified)
	* frontend/src/utils/authSession.js (added)

	Fixed auth issue


Mon, 27 Apr 2026 20:01:12 GMT Andrej <asumanovski@…> [708af9e]
	* backend/src/main/java/com/trekr/backend/controller/WeightController.java (added)
	* backend/src/main/java/com/trekr/backend/dto/weight/CreateDailyIntakeRequest.java (added)
	* backend/src/main/java/com/trekr/backend/dto/weight/TodayTrainingInfoDto.java (added)
	* backend/src/main/java/com/trekr/backend/dto/weight/TrackingStatusResponse.java (added)
	* backend/src/main/java/com/trekr/backend/dto/weight/WeightDailyIntakeDto.java (added)
	* backend/src/main/java/com/trekr/backend/dto/weight/WeightDailyIntakesResponse.java (added)
	* backend/src/main/java/com/trekr/backend/dto/weight/WeightProfileResponse.java (added)
	* backend/src/main/java/com/trekr/backend/dto/weight/WeightStartRequest.java (added)
	* backend/src/main/java/com/trekr/backend/entity/weight/WeightUser.java (modified)
	* backend/src/main/java/com/trekr/backend/repository/DailyIntakeRepository.java (added)
	* backend/src/main/java/com/trekr/backend/repository/TrainingSessionRepository.java (modified)
	* backend/src/main/java/com/trekr/backend/repository/WeightUserRepository.java (added)
	* backend/src/main/java/com/trekr/backend/service/WeightService.java (added)
	* db-scripts/ddl.sql (modified)
	* frontend/src/App.jsx (modified)
	* frontend/src/pages/Dashboard/pages/Weight/NewWeightIntake.jsx (added)
	* frontend/src/pages/Dashboard/pages/Weight/Weight.jsx (modified)
	* frontend/src/pages/Dashboard/pages/Weight/WeightTracking.jsx (added)
	* frontend/src/pages/Dashboard/pages/Weight/components/WeightCenteredCard.jsx (added)
	* frontend/src/pages/Dashboard/pages/Weight/components/WeightIntakesTable.jsx (added)
	* frontend/src/pages/Dashboard/pages/Weight/components/WeightProgressCard.jsx (added)
	* frontend/src/pages/Dashboard/pages/Weight/components/WeightStartCtaCard.jsx (added)
	* frontend/src/pages/Dashboard/pages/Weight/components/WeightStartForm.jsx (added)
	* frontend/src/pages/Dashboard/pages/Weight/components/WeightSummaryCard.jsx (added)
	* frontend/src/pages/Dashboard/pages/Weight/components/WeightTrackingHeader.jsx (added)

	Weight tracking feature complete


Wed, 22 Apr 2026 16:22:37 GMT Andrej <asumanovski@…> [89156c1]
	* backend/docs/P6_Advanced_Reports.txt (added)
	* db-scripts/p6-relational-algebra/p6_q1_annual_finance_budget_resilience_ra.txt (added)
	* db-scripts/p6-relational-algebra/p6_q2_annual_training_consistency_workload_ra.txt (added)
	* db-scripts/p6-relational-algebra/p6_q3_annual_discipline_adherence_streaks_ra.txt (added)
	* db-scripts/p6-relational-algebra/p6_q4_annual_investing_diversification_concentration_ra.txt (added)
	* db-scripts/p6_q1_annual_finance_budget_resilience.sql (added)
	* db-scripts/p6_q2_annual_training_consistency_workload.sql (added)
	* db-scripts/p6_q3_annual_discipline_adherence_streaks.sql (added)
	* db-scripts/p6_q4_annual_investing_diversification_concentration.sql (added)

	Phase 6 documentation


Tue, 21 Apr 2026 16:07:57 GMT Andrej <asumanovski@…> [37307aa]
	* .idea/.gitignore (added)
	* .idea/compiler.xml (added)
	* .idea/copilot.data.migration.ask2agent.xml (added)
	* .idea/encodings.xml (added)
	* .idea/inspectionProfiles/Project_Default.xml (added)
	* .idea/jarRepositories.xml (added)
	* .idea/misc.xml (added)
	* .idea/modules.xml (added)
	* .idea/trekr.iml (added)
	* .idea/vcs.xml (added)
	* backend/src/main/java/com/trekr/backend/BackendApplication.java (modified)
	* db-scripts/ddl.sql (modified)
	* db-scripts/dml.sql (modified)
	* frontend/src/pages/Register/Register.jsx (modified)

	env file issue fix


Mon, 20 Apr 2026 17:04:21 GMT Andrej <asumanovski@…> [c4c43f3]
	* backend/HELP.md (modified)
	* backend/docs/Normalization.txt (added)
	* backend/src/main/java/com/trekr/backend/entity/discipline/CustomTrackingCategory.java (modified)
	* backend/src/main/java/com/trekr/backend/entity/discipline/DisciplineUser.java (modified)
	* backend/src/main/java/com/trekr/backend/entity/training/TrainingSession.java (modified)
	* db-scripts/ddl.sql (modified)
	* db-scripts/dml.sql (modified)

	Normalization of the database


Tue, 10 Feb 2026 13:02:45 GMT Andrej <asumanovski@…> [5c20c64]
	* backend/src/main/resources/application.properties (modified)
	* db-scripts/dml.sql (modified)
	* frontend/src/pages/LandingPage/components/Benefits.jsx (added)
	* frontend/src/pages/LandingPage/components/Features.jsx (added)

	Added new content to the landing page and fixed app properties


Mon, 09 Feb 2026 21:17:45 GMT Andrej <asumanovski@…> [8615885]
	* backend/src/main/java/com/trekr/backend/entity/discipline/CustomTrackingCategory.java (added)
	* backend/src/main/java/com/trekr/backend/entity/discipline/DailyCompletion.java (added)
	* backend/src/main/java/com/trekr/backend/entity/discipline/DisciplineUser.java (added)
	* backend/src/main/java/com/trekr/backend/entity/discipline/Task.java (added)
	* backend/src/main/java/com/trekr/backend/entity/discipline/TaskDailyCompletion.java (added)
	* backend/src/main/java/com/trekr/backend/entity/discipline/TaskDailyCompletionId.java (added)
	* backend/src/main/java/com/trekr/backend/entity/finance/FinanceUser.java (added)
	* backend/src/main/java/com/trekr/backend/entity/finance/Income.java (added)
	* backend/src/main/java/com/trekr/backend/entity/invest/Asset.java (added)
	* backend/src/main/java/com/trekr/backend/entity/invest/InvestorUser.java (added)
	* backend/src/main/java/com/trekr/backend/entity/training/TrainingSession.java (added)
	* backend/src/main/java/com/trekr/backend/entity/training/TrainingUser.java (added)
	* backend/src/main/java/com/trekr/backend/entity/weight/DailyIntake.java (added)
	* backend/src/main/java/com/trekr/backend/entity/weight/WeightUser.java (added)
	* db-scripts/ddl.sql (modified)
	* db-scripts/dml.sql (modified)

	Made all models


Mon, 09 Feb 2026 20:36:40 GMT Andrej <asumanovski@…> [3ebe47c]
	* backend/env (deleted)
	* backend/pom.xml (modified)
	* backend/src/main/java/com/trekr/backend/BackendApplication.java (modified)
	* backend/src/main/java/com/trekr/backend/config/SecurityConfig.java (modified)
	* backend/src/main/java/com/trekr/backend/controller/AuthController.java (modified)
	* backend/src/main/java/com/trekr/backend/dto/auth/AuthResponse.java (modified)
	* backend/src/main/java/com/trekr/backend/dto/auth/LoginRequest.java (modified)
	* backend/src/main/java/com/trekr/backend/dto/auth/RegisterRequest.java (modified)
	* backend/src/main/java/com/trekr/backend/entity/User.java (modified)
	* backend/src/main/java/com/trekr/backend/resources/application.properties (modified)
	* backend/src/main/java/com/trekr/backend/security/UserPrincipal.java (modified)
	* backend/src/main/java/com/trekr/backend/service/AuthService.java (modified)
	* backend/src/main/resources/application.properties (modified)
	* backend/src/test/resources/application.properties (added)
	* backend/src/test/resources/schema.sql (added)
	* db-scripts/ddl.sql (modified)
	* db-scripts/dml.sql (modified)
	* frontend/src/App.jsx (modified)
	* frontend/src/api/axios.js (modified)
	* frontend/src/main.jsx (modified)
	* frontend/src/pages/Dashboard.jsx (modified)
	* frontend/src/pages/LandingPage/components/Hero.jsx (modified)
	* frontend/src/pages/LandingPage/components/NavbarLanding.jsx (modified)
	* frontend/src/pages/Login/Login.jsx (added)
	* frontend/src/pages/Register/Register.jsx (added)

	Made authentication on frontend and backend


Mon, 09 Feb 2026 17:11:10 GMT Andrej <asumanovski@…> [59ed25c]
	* db-scripts/ddl.sql (added)
	* db-scripts/dml.sql (added)
	* db-scripts/tunnel_scripta.sh (added)

	Develop branch setup and added scripts