/** * Reverse the migrations. * * @return void */ public function down() { $features = PropertyFeatures::getFeatureCodes(); // drop the pivot tables foreach ($features as $feature) { $pivotName = $feature < 'property' ? $feature . '_property' : 'property_' . $feature; if (Schema::hasTable($pivotName)) { Schema::drop($pivotName); } } // drop the features tables foreach ($features as $feature) { $featureTable = $feature . 's'; if (Schema::hasTable($featureTable)) { Schema::drop($featureTable); } } }
public function resetTables() { // reset the tables DB::statement('SET FOREIGN_KEY_CHECKS = 0'); // disable foreign key constraints foreach (PropertyFeatures::getFeatureCodes() as $feature) { $featureTable = $feature . 's'; $pivotTable = $feature < 'property' ? $feature . '_property' : 'property_' . $feature; // truncate the pivot table DB::table($pivotTable)->truncate(); // truncate the feature table DB::table($featureTable)->truncate(); } DB::table('properties')->truncate(); DB::statement('SET FOREIGN_KEY_CHECKS = 1'); // enable foreign key constraints }