From 30cf0fd22e492fd2b0052ddfd5b808da51b36052 Mon Sep 17 00:00:00 2001 From: Paul-Christian Volkmer Date: Thu, 18 Jan 2024 14:13:15 +0100 Subject: feat #29: add initial support for mtbfile api tokens --- src/main/resources/db/migration/postgresql/V0_2_0__Tokens.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 src/main/resources/db/migration/postgresql/V0_2_0__Tokens.sql (limited to 'src/main/resources/db/migration/postgresql') diff --git a/src/main/resources/db/migration/postgresql/V0_2_0__Tokens.sql b/src/main/resources/db/migration/postgresql/V0_2_0__Tokens.sql new file mode 100644 index 0000000..c89c52e --- /dev/null +++ b/src/main/resources/db/migration/postgresql/V0_2_0__Tokens.sql @@ -0,0 +1,9 @@ +CREATE TABLE IF NOT EXISTS token +( + id serial, + name varchar(255) not null, + username varchar(255) not null unique, + password varchar(255) not null, + created_at timestamp with time zone default now() not null, + PRIMARY KEY (id) +); \ No newline at end of file -- cgit v1.2.3