summaryrefslogtreecommitdiff
path: root/ssh/database/migrations/2020_03_19_150116_create_discussion_table.php
diff options
context:
space:
mode:
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.php44
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');
- }
-}