Changeset 3ebe47c for db-scripts

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

Location:

db-scripts

Files:

• ddl.sql (modified) (1 diff)
• dml.sql (modified) (1 diff)

db-scripts/ddl.sql

@@ -20 +20 @@
 
 CREATE TABLE USERS (
-    user_id BIGINT PRIMARY KEY,
+    user_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
     email TEXT NOT NULL,
     username TEXT NOT NULL,

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