Index: db-scripts/dml.sql
===================================================================
--- db-scripts/dml.sql	(revision 3ebe47cce61b3bfc1dee2566f7475e378374591e)
+++ db-scripts/dml.sql	(revision 86158850756b7b97df263e784aecbbae73d37b17)
@@ -109,4 +109,10 @@
 (39, 25, '2026-03-28', 6050);
 
+-- If INCOMES.income_id is an IDENTITY column, advance its sequence past dummy ids.
+SELECT setval(
+	pg_get_serial_sequence('trekr.incomes', 'income_id'),
+	(SELECT COALESCE(MAX(income_id), 0) FROM trekr.incomes)
+);
+
 INSERT INTO TRAINING_USERS (user_id, gender, age, weight) VALUES
 (1, 'Male', 21, 73),
@@ -185,4 +191,10 @@
 (30, 20, 2300, '2026-02-10');
 
+-- If DAILY_INTAKES.daily_intake_id is an IDENTITY column, advance its sequence past dummy ids.
+SELECT setval(
+	pg_get_serial_sequence('trekr.daily_intakes', 'daily_intake_id'),
+	(SELECT COALESCE(MAX(daily_intake_id), 0) FROM trekr.daily_intakes)
+);
+
 INSERT INTO TRAINING_SESSIONS (training_id, training_user_id, weight_user_id, duration, calories, date, type) VALUES
 (1, 1, 1, 60, 500, '2026-02-01', 'Running'),
@@ -211,4 +223,10 @@
 (24, 17, 17, 40, 320, '2026-02-13', 'Strength');
 
+-- If TRAINING_SESSIONS.training_id is an IDENTITY column, advance its sequence past dummy ids.
+SELECT setval(
+	pg_get_serial_sequence('trekr.training_sessions', 'training_id'),
+	(SELECT COALESCE(MAX(training_id), 0) FROM trekr.training_sessions)
+);
+
 INSERT INTO DISCIPLINE_USERS (user_id, num_tasks, tasks) VALUES
 (1, 2, '["Morning Run","Read Book"]'),
@@ -244,4 +262,10 @@
 (14, 19, 'Gym Program', 3, '["Squat","Bench","Deadlift"]'),
 (15, 20, 'Exam Prep', 3, '["Practice","Mock","Review"]');
+
+-- If CUSTOM_TRACKING_CATEGORIES.custom_tracking_id is an IDENTITY column, advance its sequence past dummy ids.
+SELECT setval(
+	pg_get_serial_sequence('trekr.custom_tracking_categories', 'custom_tracking_id'),
+	(SELECT COALESCE(MAX(custom_tracking_id), 0) FROM trekr.custom_tracking_categories)
+);
 
 INSERT INTO TASKS (task_id, name, is_finished, discipline_user_id, custom_tracking_id) VALUES
@@ -307,4 +331,10 @@
 (60, 'Review Exam', FALSE, NULL, 15);
 
+-- If TASKS.task_id is an IDENTITY column, advance its sequence past dummy ids.
+SELECT setval(
+	pg_get_serial_sequence('trekr.tasks', 'task_id'),
+	(SELECT COALESCE(MAX(task_id), 0) FROM trekr.tasks)
+);
+
 INSERT INTO DAILY_COMPLETION (daily_completion_id, user_id, date, procent) VALUES
 (1, 1, '2026-02-01', 100),
@@ -338,4 +368,10 @@
 (29, 20, '2026-02-09', 33),
 (30, 20, '2026-02-10', 66);
+
+-- If DAILY_COMPLETION.daily_completion_id is an IDENTITY column, advance its sequence past dummy ids.
+SELECT setval(
+	pg_get_serial_sequence('trekr.daily_completion', 'daily_completion_id'),
+	(SELECT COALESCE(MAX(daily_completion_id), 0) FROM trekr.daily_completion)
+);
 
 INSERT INTO TASK_DAILY_COMPLETION (task_id, daily_completion_id) VALUES
@@ -393,2 +429,8 @@
 (16, 14, 'SPY', 485, '2026-02-09', 1.5),
 (17, 15, 'NVDA', 640, '2026-02-10', 0.9);
+
+-- If ASSETS.asset_id is an IDENTITY column, advance its sequence past dummy ids.
+SELECT setval(
+	pg_get_serial_sequence('trekr.assets', 'asset_id'),
+	(SELECT COALESCE(MAX(asset_id), 0) FROM trekr.assets)
+);