Changeset 3ebe47c for db-scripts/dml.sql

Timestamp:

02/09/26 21:36:40 (5 months ago)

Author:

Andrej <asumanovski@…>

Branches:

master

Children:

8615885

Parents:

140d098

Message:

Made authentication on frontend and backend

File:

• db-scripts/dml.sql (modified) (1 diff)

db-scripts/dml.sql

@@ -32 +32 @@
 (29, 'petra@example.com', 'petra_kostova', '1234'),
 (30, 'vlado@example.com', 'vlado_ilievski', '1234');
+
+-- If USERS.user_id is an IDENTITY column, ensure its backing sequence is advanced
+-- past the inserted dummy ids so future inserts (e.g., app registration) don't
+-- try to reuse ids and fail with duplicate key errors.
+SELECT setval(
+        pg_get_serial_sequence('trekr.users', 'user_id'),
+        (SELECT COALESCE(MAX(user_id), 0) FROM trekr.users)
+);
 
 INSERT INTO FINANCE_USERS (user_id, spending_budget, saving_budget, investing_budget, donation_budget, credit) VALUES