20 lines
544 B
PHP
20 lines
544 B
PHP
<?php
|
||
$db = new SQLite3(__DIR__ . '/../mentalnet_funnies.db');
|
||
|
||
// Check if the table already exists
|
||
$result = $db->querySingle("SELECT name FROM sqlite_master WHERE type='table' AND name='comics'");
|
||
|
||
if ($result) {
|
||
echo "ℹ️ Table 'comics' already exists.";
|
||
} else {
|
||
$db->exec("CREATE TABLE comics (
|
||
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
||
title TEXT NOT NULL,
|
||
filename TEXT NOT NULL,
|
||
description TEXT,
|
||
date_added DATETIME DEFAULT CURRENT_TIMESTAMP
|
||
)");
|
||
echo "✅ Table 'comics' created.";
|
||
}
|
||
?>
|
||
|