Files
Wallos/migrations/000050.php
Miguel Ribeiro 11eaf402e8 feat!: complete ui overhaul (#1108)
feat: option for the week to start on sunday
feat: redesign login / registration pages
feat: more statistics
feat: declarative oidc settings
feat: grid view for subscriptions
feat: subscription details popup
feat: translate categories with ai
feat: google image search with serpapi
feat: selfh.st image search
feat: dashboard icons image search
fix: improve background removal feature for logos
feat: v2.0 api - write endpoints
fix: include todays subscriptions on amount due this month
fix: calendar occurrences to respect subscription start date
fix: honor configured outbound proxy for logo search without reopening httpoxy SSRF bypass
fix: remove hardcode string from the admin page
fix: ssrf via http proxy env var in payments logo search
fix: require cron auth guard on storetotalyearlycost.php
fix: validate per-user smtp host against ssrf
fix: escape iCal property values to prevent crlf injection
2026-07-11 23:54:52 +02:00

15 lines
529 B
PHP

<?php
// This migration adds the "google_search" table, holding the optional
// SerpAPI key used to add Google image results to the subscription logo search.
$tableQuery = $db->query("SELECT name FROM sqlite_master WHERE type='table' AND name='google_search'");
$tableRequired = $tableQuery->fetchArray(SQLITE3_ASSOC) === false;
if ($tableRequired) {
$db->exec("CREATE TABLE google_search (
id INTEGER PRIMARY KEY AUTOINCREMENT,
user_id INTEGER NOT NULL,
api_key TEXT NOT NULL DEFAULT ''
)");
}