| author | Thorsten Ortlepp
<post@ortlepp.ms> 2025-12-03 22:46:09 UTC |
| committer | Thorsten Ortlepp
<post@ortlepp.ms> 2025-12-03 22:46:09 UTC |
| parent | 97148a20cc316fec4cea2ca77825200e45372835 |
| 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 );