Only fetch rows from past thirty days

1 files changed, 3 insertions, 2 deletions

diff --git a/database/migrations/2016_12_27_232934_create_clicks_table.php b/database/migrations/2016_12_27_232934_create_clicks_table.php
index fe45110..5ba2bff 100644
--- a/database/migrations/2016_12_27_232934_create_clicks_table.php
+++ b/database/migrations/2016_12_27_232934_create_clicks_table.php
@@ -23,10 +23,11 @@ class CreateClicksTable extends Migration
             $table->string('referer')->nullable();
             $table->string('referer_host')->nullable();
             $table->text('user_agent')->nullable();
+            $table->integer('link_id')->unsigned();
 
             $table->index('ip');
-            $table->index('referer');
-            $table->integer('link_id')->unsigned();
+            $table->index('referer_host');
+            $table->index('link_id');
             $table->foreign('link_id')->references('id')->on('links')->onDelete('cascade');
 
             $table->timestamps();