From 3aada9949d51024a92a8b5c6cb70d12f9c3cac16 Mon Sep 17 00:00:00 2001
From: Jake Vanderwerf <get@jakevanderwerf.ca>
Date: Sun, 21 Dec 2025 19:59:48 +0000
Subject: [PATCH] =auth refactored via rest, referral system set up for Jane, some javascript consolidation

---
 inc/registry/CheckCustomTables.php |   43 ++++++++++++++++++++++++-------------------
 1 files changed, 24 insertions(+), 19 deletions(-)

diff --git a/inc/registry/CheckCustomTables.php b/inc/registry/CheckCustomTables.php
index 8980dd6..95745c4 100644
--- a/inc/registry/CheckCustomTables.php
+++ b/inc/registry/CheckCustomTables.php
@@ -497,25 +497,30 @@
         ];
     }
 
-    protected function errorLogTables():array
-    {
-
-        return [
-            'error_log'=> "(
-            `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
-            `error_type` varchar(50) NOT NULL,
-            `component` varchar(50) NOT NULL,
-            `message` text NOT NULL,
-            `context` JSON,
-            `severity` varchar(20) NOT NULL,
-            `user_id` {$this->userIDType} NOT NULL,
-            `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
-            PRIMARY KEY (`id`),
-            KEY `error_lookup` (`error_type`, `severity`, `created_at`),
-            KEY `component_errors` (`component`, `created_at`)
-        )"
-        ];
-    }
+	protected function errorLogTables():array
+	{
+		return [
+			'error_log'=> "(
+				`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
+				`error_type` varchar(50) NOT NULL,
+				`component` varchar(100) NOT NULL,
+				`method` varchar(100) DEFAULT NULL,
+				`page_url` varchar(255) DEFAULT NULL,
+				`message` text NOT NULL,
+				`context` JSON,
+				`severity` varchar(20) NOT NULL,
+				`user_id` {$this->userIDType} DEFAULT NULL,
+				`user_was_logged_in` tinyint(1) NOT NULL,
+				`source` enum('frontend','backend') NOT NULL,
+				`created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
+				PRIMARY KEY (`id`),
+				KEY `created_at` (`created_at`),
+				KEY `component_severity_date` (`component`, `severity`, `created_at`),
+				KEY `error_type_date` (`error_type`, `created_at`),
+				KEY `severity_date` (`severity`, `created_at`)
+			)"
+		];
+	}
 
 	protected function userIntegrationsTable():array
 	{

--
Gitblit v1.10.0