ALTER TABLE public.core_users ADD verify_token varchar(50) NULL;
ALTER TABLE public.core_users ADD first_name varchar(50) NULL;
ALTER TABLE public.core_users ADD last_name varchar(50) NULL;

UPDATE public.core_users SET email = CONCAT(username,'@jivalabs.com') WHERE email is NULL or email = '';

CREATE UNIQUE INDEX core_users_email_idx ON public.core_users (email);
