Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ~~~
- ---------------------------------------------------------------------------------------------------------------------------------+
- | users | CREATE TABLE `users` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
- `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
- `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `role_id` int(10) unsigned DEFAULT NULL,
- `remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `created_at` timestamp NULL DEFAULT NULL,
- `updated_at` timestamp NULL DEFAULT NULL,
- `deleted_at` timestamp NULL DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_253_role_role_id_user` (`role_id`),
- KEY `users_deleted_at_index` (`deleted_at`),
- CONSTRAINT `fk_253_role_role_id_user` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
- +-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------
- ~~~
Add Comment
Please, Sign In to add comment