36 lines
1.2 KiB
PHP
36 lines
1.2 KiB
PHP
<?php
|
|
// 임시 DB 설치 스크립트
|
|
$config = [
|
|
'db_host' => 'update.onetake.best',
|
|
'db_user' => 'onetake',
|
|
'db_pw' => 'dnjsxpdlzm1!',
|
|
'db_name' => 'onetake'
|
|
];
|
|
|
|
try {
|
|
$dsn = "mysql:host={$config['db_host']};dbname={$config['db_name']};charset=utf8mb4";
|
|
$db = new PDO($dsn, $config['db_user'], $config['db_pw'], [
|
|
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
|
|
]);
|
|
|
|
$sql = "CREATE TABLE IF NOT EXISTS `licenses` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`project_name` VARCHAR(100) NOT NULL,
|
|
`device_id` VARCHAR(100) NOT NULL DEFAULT '*',
|
|
`expiry_date` DATE NOT NULL,
|
|
`tv_limit` INT NOT NULL DEFAULT 1,
|
|
`token` TEXT NOT NULL,
|
|
`issued_by` VARCHAR(50) NOT NULL,
|
|
`issued_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
INDEX `idx_project` (`project_name`),
|
|
INDEX `idx_device` (`device_id`),
|
|
INDEX `idx_issued_at` (`issued_at`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
|
|
|
|
$db->exec($sql);
|
|
echo "<h1>SUCCESS</h1><p>'licenses' table created or already exists.</p>";
|
|
|
|
} catch (PDOException $e) {
|
|
echo "<h1>ERROR</h1><p>" . $e->getMessage() . "</p>";
|
|
}
|
|
?>
|