Changeset 37307aa for db-scripts/ddl.sql

Timestamp:

04/21/26 18:07:57 (3 months ago)

Author:

Andrej <asumanovski@…>

Branches:

master

Children:

89156c1

Parents:

c4c43f3

Message:

env file issue fix

File:

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

db-scripts/ddl.sql

@@ -21 +21 @@
 CREATE TABLE USERS (
     user_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
-    email TEXT NOT NULL,
-    username TEXT NOT NULL,
+    email TEXT NOT NULL UNIQUE,
+    username TEXT NOT NULL UNIQUE,
     password TEXT NOT NULL
 );