migrations/20240412153145_create_credential.up.sql


1
2
3
4
5
6
7
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()
);