public function up()
{
Schema::create('posts', function (Blueprint $table) {
$table->increments('id');
$table->text('type');
$table->text('likes');
$table->text('comments');
$table->text('shares');
$table->text('portee');
$table->text('P_organic');
$table->text('P_payee');
$table->date('date');
$table->integer('page_id')->unsigned();
$table->foreign('page_id')->references('id')->on('pages')->onDelete('cascade')->onUpdate('cascade');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('posts');
}
}
je veux calculer la somme des colonnes : likes , comments , shares qui correspond à la mm page_id
j'espere que tu m'a compris
merci en tout cas