kttd/migrations/2023-05-11-145250_create_users/up.sql
Andrey Tkachenko 9fd1025d4a
All checks were successful
continuous-integration/drone/push Build is passing
schema update; error handling
2023-05-12 13:07:05 +04:00

11 lines
321 B
SQL

CREATE TABLE users (
id SERIAL PRIMARY KEY,
image_id INTEGER,
first_name VARCHAR NOT NULL,
last_name VARCHAR NOT NULL,
email VARCHAR NOT NULL,
password VARCHAR(64) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
)