-- Drop table

-- DROP TABLE public.migrations;

CREATE TABLE public.migrations (
	id serial NOT NULL,
	migration varchar(255) NOT NULL,
	batch int4 NOT NULL,
	CONSTRAINT migrations_pkey PRIMARY KEY (id)
);


-- Drop table

-- DROP TABLE public.users;

CREATE TABLE public.users (
	id bigserial NOT NULL,
	"name" varchar(255) NOT NULL,
	email varchar(255) NOT NULL,
	email_verified_at timestamp NULL,
	"password" varchar(255) NOT NULL,
	remember_token varchar(100) NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	CONSTRAINT users_email_unique UNIQUE (email),
	CONSTRAINT users_pkey PRIMARY KEY (id)
);


-- Drop table

-- DROP TABLE public.password_resets;

CREATE TABLE public.password_resets (
	email varchar(255) NOT NULL,
	"token" varchar(255) NOT NULL,
	created_at timestamp NULL
);
CREATE INDEX password_resets_email_index ON public.password_resets USING btree (email);


-- Drop table

-- DROP TABLE public.oauth_auth_codes;

CREATE TABLE public.oauth_auth_codes (
	id varchar(100) NOT NULL,
	user_id int8 NOT NULL,
	client_id uuid NOT NULL,
	scopes text NULL,
	revoked bool NOT NULL,
	expires_at timestamp NULL,
	CONSTRAINT oauth_auth_codes_pkey PRIMARY KEY (id)
);
CREATE INDEX oauth_auth_codes_user_id_index ON public.oauth_auth_codes USING btree (user_id);


-- Drop table

-- DROP TABLE public.oauth_access_tokens;

CREATE TABLE public.oauth_access_tokens (
	id varchar(100) NOT NULL,
	user_id int8 NULL,
	client_id uuid NOT NULL,
	"name" varchar(255) NULL,
	scopes text NULL,
	revoked bool NOT NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	expires_at timestamp NULL,
	CONSTRAINT oauth_access_tokens_pkey PRIMARY KEY (id)
);
CREATE INDEX oauth_access_tokens_user_id_index ON public.oauth_access_tokens USING btree (user_id);


-- Drop table

-- DROP TABLE public.oauth_refresh_tokens;

CREATE TABLE public.oauth_refresh_tokens (
	id varchar(100) NOT NULL,
	access_token_id varchar(100) NOT NULL,
	revoked bool NOT NULL,
	expires_at timestamp NULL,
	CONSTRAINT oauth_refresh_tokens_pkey PRIMARY KEY (id)
);
CREATE INDEX oauth_refresh_tokens_access_token_id_index ON public.oauth_refresh_tokens USING btree (access_token_id);


-- Drop table

-- DROP TABLE public.oauth_clients;

CREATE TABLE public.oauth_clients (
	id uuid NOT NULL,
	user_id int8 NULL,
	"name" varchar(255) NOT NULL,
	secret varchar(100) NULL,
	provider varchar(255) NULL,
	redirect text NOT NULL,
	personal_access_client bool NOT NULL,
	password_client bool NOT NULL,
	revoked bool NOT NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	CONSTRAINT oauth_clients_pkey PRIMARY KEY (id)
);
CREATE INDEX oauth_clients_user_id_index ON public.oauth_clients USING btree (user_id);


-- Drop table

-- DROP TABLE public.oauth_personal_access_clients;

CREATE TABLE public.oauth_personal_access_clients (
	id bigserial NOT NULL,
	client_id uuid NOT NULL,
	created_at timestamp NULL,
	updated_at timestamp NULL,
	CONSTRAINT oauth_personal_access_clients_pkey PRIMARY KEY (id)
);


-- Drop table

-- DROP TABLE public.failed_jobs;

CREATE TABLE public.failed_jobs (
	id bigserial NOT NULL,
	"connection" text NOT NULL,
	queue text NOT NULL,
	payload text NOT NULL,
	"exception" text NOT NULL,
	failed_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	CONSTRAINT failed_jobs_pkey PRIMARY KEY (id)
);