/** * Run the migrations. * * @return void */ public function up() { Schema::DropIfExists('horaires'); Schema::Create('horaires', function (Blueprint $table) { $table->engine = 'InnoDB'; $table->increments('id'); $table->date('date'); $table->time('h_debut'); $table->time('h_fin'); $table->integer('matiere_id')->unsigned(); $table->foreign('matiere_id')->references('id')->on('matieres')->onDelete('cascade'); $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::DropIfExists('matieres'); Schema::Create('matieres', function (Blueprint $table) { $table->engine = 'InnoDB'; $table->increments('id'); $table->String('nom', 200); $table->integer('enseignant_id')->unsigned(); $table->integer('promo_id')->unsigned(); $table->integer('module_id')->unsigned(); $table->foreign('enseignant_id')->references('id')->on('enseignants')->onDelete('cascade'); $table->foreign('promo_id')->references('id')->on('promos')->onDelete('cascade'); $table->foreign('module_id')->references('id')->on('modules')->onDelete('cascade'); $table->timestamps(); }); }