/** * Run the migrations. * * @return void */ public function up() { DB::statement('CREATE VIRTUAL TABLE tags_fts USING fts3(tag_id, words);'); $tags = Tag::get(); foreach ($tags as $tag) { $fts = new TagFts(); $fts->tag_id = $tag->id; $fts->words = FtsUtils::toNgram($tag->name); $fts->save(); } }