From fe0765795aae52df0edf064ce4add55d6edb0ed9 Mon Sep 17 00:00:00 2001
From: Frankie B <git@diskfloppy.me>
Date: Wed, 19 Jul 2023 01:58:32 +0100
Subject: Update table names to new format

---
 resources/views/pages/admin/guestbook.blade.php | 6 +++++-
 resources/views/pages/bookmarks.blade.php       | 4 ++--
 resources/views/pages/guestbook.blade.php       | 6 +++++-
 3 files changed, 12 insertions(+), 4 deletions(-)

(limited to 'resources')

diff --git a/resources/views/pages/admin/guestbook.blade.php b/resources/views/pages/admin/guestbook.blade.php
index 56323ef..ec870bb 100644
--- a/resources/views/pages/admin/guestbook.blade.php
+++ b/resources/views/pages/admin/guestbook.blade.php
@@ -2,7 +2,11 @@
 @section('title', 'guestbook')
 @section('content')
     @php
-        $entries = DB::select('SELECT id, name, timestamp, message FROM guestbook_entries ORDER BY id DESC');
+        $entries = DB::select('
+            SELECT id, name, timestamp, message
+            FROM guestbook__entries
+            ORDER BY id DESC
+        ');
     @endphp
     <h1>Entries <small>({{ count($entries) }} total)</small></h1>
     @foreach ($entries as $entry)
diff --git a/resources/views/pages/bookmarks.blade.php b/resources/views/pages/bookmarks.blade.php
index 16d07cc..ee91334 100644
--- a/resources/views/pages/bookmarks.blade.php
+++ b/resources/views/pages/bookmarks.blade.php
@@ -5,7 +5,7 @@
 @php
     $categories = DB::select('
         SELECT id, name
-        FROM bookmark_categories
+        FROM bookmark__categories
         ORDER BY priority ASC
     ');
 @endphp
@@ -15,7 +15,7 @@
     @php
         $sites = DB::select('
             SELECT name, url, description
-            FROM bookmark_sites
+            FROM bookmark__sites
             WHERE category_id = ? ORDER BY priority ASC
         ', array($category->id));
     @endphp
diff --git a/resources/views/pages/guestbook.blade.php b/resources/views/pages/guestbook.blade.php
index 1690274..56991aa 100644
--- a/resources/views/pages/guestbook.blade.php
+++ b/resources/views/pages/guestbook.blade.php
@@ -43,7 +43,11 @@
     </ul>
     <hr/>
     @php
-        $entries = DB::select('SELECT name, timestamp, message FROM guestbook_entries ORDER BY id DESC');
+        $entries = DB::select('
+            SELECT name, timestamp, message
+            FROM guestbook__entries
+            ORDER BY id DES
+        ');
     @endphp
     <h1>Entries <small>({{ count($entries) }} total)</small></h1>
     @foreach ($entries as $entry)
-- 
cgit v1.2.3-54-g00ecf