mardi 11 septembre 2018

Can not create table in phpmyadmin

I remove users table in DB.

then i import other users table in my DB.

But show this error:

Error
SQL query:


CREATE TABLE `users` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_group_id` int(11) UNSIGNED NOT NULL,
  `gender` tinyint(1) DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eco_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `post_code` varchar(255) COLLATE utf8mb4_unicode_ci[...]
MySQL said: Documentation

#1215 - Cannot add foreign key constraint

My framwork is Laravel 5.6, PHP 7.2

How to issue this problem?



from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2Mn0pZI
via IFTTT

Aucun commentaire:

Enregistrer un commentaire