public function run()
 {
     DB::table('negativekeywords')->delete();
     Negativekeyword::create(array('negativekeyword' => 'www'));
     Negativekeyword::create(array('negativekeyword' => '3g'));
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     Negativekeyword::destroy($id);
     return Response::json(array('success' => true));
 }
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     // Delete the data account and all data associated with it
     $lp = DataAccount::find($id)->landingPageUrls()->get();
     // Laravel's magic
     foreach ($lp as $v) {
         DB::table('landingpagewordcloud')->where('landing_page_urls_id', $v->id)->delete();
     }
     DataAccount::find($id)->landingPageUrls()->delete();
     DataAccount::destroy($id);
     Keyword::where('dataAccount', $id)->delete();
     Stopword::where('dataAccount', $id)->delete();
     Negativekeyword::where('dataAccount', $id)->delete();
     DB::table('keywords_segment')->where('dataAccount', $id)->delete();
     DB::table('segmentmap')->where('dataAccount', $id)->delete();
     DB::table('wordcloud')->where('dataAccount', $id)->delete();
     //DB::statement( 'drop database data_' . $id );
     return Response::json(array('success' => true));
 }