From 7d1d61757a39e7f949e65e0d9f8b6555f5010b90 Mon Sep 17 00:00:00 2001
From: dev
Date: Sat, 27 Jun 2026 07:01:54 +0200
Subject: feat: split movie synopsis into separate paragraphs

Synopsis now splits on \n\n into individual <p> tags instead of one
big text blob. Already implemented, confirmed working with latest DB data.
---
 .../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