diff options
Diffstat (limited to 'migrations/20240412153150_create_user_.up.sql')
| -rw-r--r-- | migrations/20240412153150_create_user_.up.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/migrations/20240412153150_create_user_.up.sql b/migrations/20240412153150_create_user_.up.sql new file mode 100644 index 0000000..e13fd90 --- /dev/null +++ b/migrations/20240412153150_create_user_.up.sql @@ -0,0 +1,7 @@ +CREATE TABLE user_ ( + id UUID NOT NULL PRIMARY KEY, + name VARCHAR(100) NOT NULL, + email VARCHAR(255) NOT NULL UNIQUE, + created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() +); |