23 lines
818 B
PHP
23 lines
818 B
PHP
<?php
|
|
/**
|
|
* Migration: Create tft_designs table
|
|
* Run once: http://localhost/fiberid/migrate_tft_designs.php
|
|
*/
|
|
require_once 'koneksi.php';
|
|
|
|
try {
|
|
$pdo->exec("
|
|
CREATE TABLE IF NOT EXISTS tft_designs (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
name VARCHAR(100) NOT NULL DEFAULT 'Untitled',
|
|
design_json LONGTEXT NOT NULL,
|
|
version_hash VARCHAR(64) NOT NULL DEFAULT '',
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
|
|
");
|
|
echo "<h3 style='color:green;'>✅ Table 'tft_designs' created successfully!</h3>";
|
|
} catch (PDOException $e) {
|
|
echo "<h3 style='color:red;'>❌ Error: " . $e->getMessage() . "</h3>";
|
|
}
|