17 lines
625 B
SQL
17 lines
625 B
SQL
CREATE TABLE IF NOT EXISTS users
|
|
(
|
|
id uuid DEFAULT gen_random_uuid() PRIMARY KEY NOT NULL,
|
|
email varchar(100) NOT NULL,
|
|
first_name varchar(50),
|
|
last_name varchar(50),
|
|
password varchar(100) NOT NULL,
|
|
is_active boolean default TRUE,
|
|
created_at timestamp WITH TIME ZONE DEFAULT NOW() NOT NULL,
|
|
updated_at timestamp WITH TIME ZONE DEFAULT NOW() NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS users_id_uindex
|
|
ON users (id);
|
|
CREATE UNIQUE INDEX IF NOT EXISTS email_uindex
|
|
ON users (email);
|