Reputation: 49
I have create a tables name country_packages
inside MySQL workbench. Then I make migration inside PHP Laravel project. By using following command:
$ php artisan migrate
Unfortunately, it doesn't create the tables of country_packages
. I already force to make migrate. But still the new table doesn't created inside Laravel. What's wrong actually?
Upvotes: 1
Views: 819
Reputation: 49
country_packages
DROP TABLE IF EXISTS country_packages
;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE country_packages
(
id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
country_id
int(11) NOT NULL,
package_id
int(11) NOT NULL,
created_at
timestamp NULL DEFAULT NULL,
updated_at
timestamp NULL DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=2412 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;
--
country_packages
LOCK TABLES country_packages
WRITE;
/*!40000 ALTER TABLE country_packages
DISABLE KEYS */;
here's I successfully created table country_packages inside MySQL
Upvotes: 0