generated from phundrak/rust-poem-openapi-template
30 lines
946 B
MySQL
30 lines
946 B
MySQL
|
-- Add up migration script here
|
||
|
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS public.users
|
||
|
|
(
|
||
|
|
id uuid NOT NULL DEFAULT uuid_generate_v4(),
|
||
|
|
email character varying(255) NOT NULL,
|
||
|
|
created_at timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
last_updated timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
PRIMARY KEY (id),
|
||
|
|
CONSTRAINT users_email_unique UNIQUE (email)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS public.sessions
|
||
|
|
(
|
||
|
|
id uuid NOT NULL DEFAULT uuid_generate_v4(),
|
||
|
|
user_id uuid NOT NULL,
|
||
|
|
session_id character varying NOT NULL,
|
||
|
|
expires_at timestamp with time zone NOT NULL,
|
||
|
|
PRIMARY KEY (id),
|
||
|
|
CONSTRAINT sessions_user_id_unique UNIQUE (user_id)
|
||
|
|
);
|
||
|
|
|
||
|
|
ALTER TABLE IF EXISTS public.sessions
|
||
|
|
ADD CONSTRAINT sessions_user_id_users_fk FOREIGN KEY (user_id)
|
||
|
|
REFERENCES public.users (id) MATCH SIMPLE
|
||
|
|
ON UPDATE CASCADE
|
||
|
|
ON DELETE CASCADE
|
||
|
|
NOT VALID;
|