diff options
| author | Toby Vincent <tobyv@tobyvin.dev> | 2024-04-12 16:42:43 -0500 |
|---|---|---|
| committer | Toby Vincent <tobyv@tobyvin.dev> | 2024-04-12 16:42:43 -0500 |
| commit | 00d63f5a5648f76d8e9cb8597446e05901543a0c (patch) | |
| tree | 3ff855a7c40d8edad0edc6a344eca6b7dec2e60b /migrations/20240412153145_create_credential.up.sql | |
| parent | 9f604a8404aac4113a56ddd2203cfbe154cd0f78 (diff) | |
refactor: improve auth flow and router layout
Diffstat (limited to 'migrations/20240412153145_create_credential.up.sql')
| -rw-r--r-- | migrations/20240412153145_create_credential.up.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/migrations/20240412153145_create_credential.up.sql b/migrations/20240412153145_create_credential.up.sql new file mode 100644 index 0000000..a2f0920 --- /dev/null +++ b/migrations/20240412153145_create_credential.up.sql @@ -0,0 +1,8 @@ +CREATE EXTENSION "uuid-ossp"; + +CREATE TABLE credential ( + id UUID NOT NULL PRIMARY KEY DEFAULT uuid_generate_v4(), + password_hash VARCHAR(100) NOT NULL, + created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() +); |