Guest User

Untitled

a guest
Mar 17th, 2018
265
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. ~~~
  2. ---------------------------------------------------------------------------------------------------------------------------------+
  3. | users | CREATE TABLE `users` (
  4. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  5. `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  6. `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  7. `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  8. `role_id` int(10) unsigned DEFAULT NULL,
  9. `remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  10. `created_at` timestamp NULL DEFAULT NULL,
  11. `updated_at` timestamp NULL DEFAULT NULL,
  12. `deleted_at` timestamp NULL DEFAULT NULL,
  13. PRIMARY KEY (`id`),
  14. KEY `fk_253_role_role_id_user` (`role_id`),
  15. KEY `users_deleted_at_index` (`deleted_at`),
  16. CONSTRAINT `fk_253_role_role_id_user` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
  17. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
  18. +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------
  19. ~~~
Add Comment
Please, Sign In to add comment