Added a profile, that starts the app with a PostgreSQL-DB

[demos/spring/data-jdbc] / src / main / resources / db / migration / postgres / V1__Table_users.sql

diff --git a/src/main/resources/db/migration/postgres/V1__Table_users.sql b/src/main/resources/db/migration/postgres/V1__Table_users.sql
new file mode 100644 (file)
index 0000000..39b0f2d
--- /dev/null
+++ b/src/main/resources/db/migration/postgres/V1__Table_users.sql
@@ -0,0 +1,3 @@
+CREATE SEQUENCE users_id_seq;
+CREATE TABLE users (id BIGINT PRIMARY KEY NOT NULL DEFAULT NEXTVAL('users_id_seq'), username VARCHAR(255), created TIMESTAMP, logged_in BOOLEAN);
+ALTER SEQUENCE users_id_seq OWNED BY users.id;