Advertisement
Itssuman1808

matrimony user table

Feb 22nd, 2022
1,132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.91 KB | None | 0 0
  1. INSERT INTO `users` (`id`, `user_type`, `role_id`, `code`, `membership`, `first_name`, `last_name`, `name`, `email`, `email_verified_at`, `new_email_verificiation_code`, `phone`, `verification_code`, `password`, `provider_id`, `photo`, `remember_token`, `last_login_ip`, `last_login_at`, `blocked`, `deactivated`, `permanently_delete`, `approved`, `balance`, `created_at`, `updated_at`, `deleted_at`) VALUES
  2. (1, 'admin', NULL, NULL, 1, 'Suman', 'Maji', NULL, 'suman@gmail.com', '2022-02-17 13:32:45', NULL, NULL, NULL, '$2y$10$0YOAzWXs5ydE81uzpa7jkOoqV5BRRs2vPVagGRWP62JTYDHp49Scu', NULL, NULL, 'K3mzYJsD3WPu7AAesGjXnrSFksjFSyJSemBxYyn16FjJALeLtLAFPKWAMUeX', NULL, NULL, 0, 0, 0, 1, 0, '2022-02-17 14:15:45', '2022-02-17 14:15:45', NULL);
  3.  
  4. ALTER TABLE `users`
  5.   ADD PRIMARY KEY (`id`),
  6.   ADD UNIQUE KEY `code` (`code`);
  7.  
  8. ALTER TABLE `users`
  9.   MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  10. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement