From 7ff83424592cd5a3c58fe2e6d7e67aeef5144caf Mon Sep 17 00:00:00 2001
From: horus
Date: Sat, 27 Jun 2026 05:40:45 +0200
Subject: merge

---
 .../2020_03_28_132812_create_view_articles.php     | 53 ----------------------
 1 file changed, 53 deletions(-)
 delete mode 100644 ssh/database/migrations/2020_03_28_132812_create_view_articles.php

(limited to 'ssh/database/migrations/2020_03_28_132812_create_view_articles.php')

diff --git a/ssh/database/migrations/2020_03_28_132812_create_view_articles.php b/ssh/database/migrations/2020_03_28_132812_create_view_articles.php
deleted file mode 100644
index 15fdee8..0000000
--- a/ssh/database/migrations/2020_03_28_132812_create_view_articles.php
+++ /dev/null
@@ -1,53 +0,0 @@
-<?php
-
-use Illuminate\Database\Migrations\Migration;
-use Illuminate\Database\Schema\Blueprint;
-use Illuminate\Support\Facades\DB;
-
-class CreateViewArticles extends Migration
-{
-    /**
-     * Run the migrations.
-     *
-     * @return void
-     */
-    public function up()
-    {
-	DB::statement(
-		"CREATE VIEW view_article AS
-		SELECT 
-			article_id as id,
-			article_id,
-			a.created_at,
-			a.updated_at,
-			a.url,
-			a.title,
-			a.excerpt_html,
-			sum(upvotes)+sum(comments) AS impact,
-			sum(upvotes) AS upvotes,
-			sum(comments) as comments,
-			count(article_id) AS repost
-		FROM 
-			discussion as d 
-		JOIN 
-			article AS a ON d.article_id = a.id 
-		GROUP BY 
-			article_id, 
-			a.created_at,
-			a.updated_at,
-			a.url,
-			a.title,
-			a.excerpt_html"
-	);
-    }
-
-    /**
-     * Reverse the migrations.
-     *
-     * @return void
-     */
-    public function down()
-    {
-	DB::statement("DROP VIEW view_article;");
-    }
-}
-- 
cgit v1.2.3