diff options
Diffstat (limited to 'ssh/database/migrations/2020_03_19_150116_create_discussion_table.php')
| -rw-r--r-- | ssh/database/migrations/2020_03_19_150116_create_discussion_table.php | 44 |
1 files changed, 0 insertions, 44 deletions
diff --git a/ssh/database/migrations/2020_03_19_150116_create_discussion_table.php b/ssh/database/migrations/2020_03_19_150116_create_discussion_table.php deleted file mode 100644 index 1869892..0000000 --- a/ssh/database/migrations/2020_03_19_150116_create_discussion_table.php +++ /dev/null @@ -1,44 +0,0 @@ -<?php - -use Illuminate\Database\Migrations\Migration; -use Illuminate\Database\Schema\Blueprint; -use Illuminate\Support\Facades\Schema; - -class CreateDiscussionTable extends Migration -{ - /** - * Run the migrations. - * - * @return void - */ - public function up() - { - Schema::create('discussion', function (Blueprint $table) { - $table->id(); - $table->timestamps(); - - $table->unsignedBigInteger('article_id')->default(0); - $table->string('title'); - $table->string('source'); - $table->string('item_id')->unique(); - $table->string('source_url'); - $table->integer('posted_on'); - $table->integer('comments')->default(0); - $table->integer('upvotes')->default(0); - - $table->foreign('article_id')->references('id')->on('article')->onDelete('cascade'); - - $table->unique(['item_id', 'posted_on', 'source']); - }); - } - - /** - * Reverse the migrations. - * - * @return void - */ - public function down() - { - Schema::dropIfExists('discussion'); - } -} |
