git » subscription-tool.git » commit b952d42

fix code format

author Thorsten Ortlepp
2025-12-03 22:46:09 UTC
committer Thorsten Ortlepp
2025-12-03 22:46:09 UTC
parent 97148a20cc316fec4cea2ca77825200e45372835

fix code format

src/main/resources/application.properties +1 -0
src/main/resources/db/migration/V1_0__create_tables.sql +13 -15

diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
index 2f3b62e..9fc4ecb 100644
--- a/src/main/resources/application.properties
+++ b/src/main/resources/application.properties
@@ -1,4 +1,5 @@
 spring.application.name=subscription-tool
+
 spring.datasource.url=jdbc:postgresql://localhost:5000/subscriptiontool
 spring.datasource.username=postgres
 spring.datasource.password=PASSWORD
diff --git a/src/main/resources/db/migration/V1_0__create_tables.sql b/src/main/resources/db/migration/V1_0__create_tables.sql
index 8ba8387..616fd1e 100644
--- a/src/main/resources/db/migration/V1_0__create_tables.sql
+++ b/src/main/resources/db/migration/V1_0__create_tables.sql
@@ -1,18 +1,16 @@
-CREATE TABLE subscriptions
-(
-    id           BIGINT GENERATED ALWAYS AS IDENTITY UNIQUE,
-    mail         VARCHAR(255) NOT NULL UNIQUE,
-    code         CHAR(64)     NOT NULL,
-    confirmed    BOOLEAN      NOT NULL DEFAULT FALSE,
-    registration TIMESTAMP    NOT NULL DEFAULT CURRENT_TIMESTAMP,
-    confirmation TIMESTAMP
+CREATE TABLE subscriptions (
+  id BIGINT GENERATED ALWAYS AS IDENTITY UNIQUE,
+  mail VARCHAR(255) NOT NULL UNIQUE,
+  code CHAR(64) NOT NULL,
+  confirmed BOOLEAN NOT NULL DEFAULT FALSE,
+  registration TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  confirmation TIMESTAMP
 );
 
-CREATE TABLE mailqueue
-(
-    id           BIGINT GENERATED ALWAYS AS IDENTITY UNIQUE,
-    subscription BIGINT REFERENCES subscriptions (id),
-    sent         BOOLEAN   NOT NULL DEFAULT FALSE,
-    creation     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-    completion   TIMESTAMP
+CREATE TABLE mailqueue (
+  id BIGINT GENERATED ALWAYS AS IDENTITY UNIQUE,
+  subscription BIGINT REFERENCES subscriptions (id),
+  sent BOOLEAN NOT NULL DEFAULT FALSE,
+  creation TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  completion TIMESTAMP
 );