21 lines
709 B
SQL
21 lines
709 B
SQL
|
|
-- Table: public.users
|
|
|
|
-- DROP TABLE IF EXISTS public.users;
|
|
|
|
CREATE TABLE IF NOT EXISTS public.users
|
|
(
|
|
id character varying(255) COLLATE pg_catalog."default" NOT NULL DEFAULT uuid_generate_v4(),
|
|
email character varying(255) COLLATE pg_catalog."default" NOT NULL,
|
|
username character varying(255) COLLATE pg_catalog."default" NOT NULL,
|
|
password_hash character varying(255) COLLATE pg_catalog."default" NOT NULL,
|
|
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at timestamp with time zone ,
|
|
CONSTRAINT users_pkey PRIMARY KEY (id),
|
|
CONSTRAINT users_email_key UNIQUE (email)
|
|
)
|
|
|
|
TABLESPACE pg_default;
|
|
|
|
ALTER TABLE IF EXISTS public.users
|
|
OWNER to admin; |