2019_03_29_224808_create_course_sections_table.php 596 B

1234567891011121314151617181920212223242526
  1. <?php
  2. /**
  3. * 教程书籍 章节表
  4. */
  5. use Illuminate\Database\Schema\Blueprint;
  6. use Illuminate\Database\Migrations\Migration;
  7. class CreateCourseSectionsTable extends Migration
  8. {
  9. public function up()
  10. {
  11. Schema::create('course_sections', function(Blueprint $table) {
  12. $table->increments('id');
  13. $table->string('title')->index()->comment('章节名称');
  14. $table->integer('course_book_id')->unsigned()->index()->comment('教程书籍 id');
  15. $table->timestamps();
  16. });
  17. }
  18. public function down()
  19. {
  20. Schema::drop('course_sections');
  21. }
  22. }