File manager - Edit - /home/webapp69.cm.in.th/u69319090041/Shop41/scratch_run_migration.php
Back
<?php require_once __DIR__ . '/config/database.php'; $db = getDBConnection(); $sql = "CREATE TABLE IF NOT EXISTS `system_bank_accounts` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `bank_name` VARCHAR(100) NOT NULL, `account_number` VARCHAR(50) NOT NULL, `account_name` VARCHAR(100) NOT NULL, `qr_code_image` VARCHAR(255) DEFAULT NULL, `is_active` TINYINT(1) DEFAULT 1, `sort_order` INT DEFAULT 0, `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"; $db->exec($sql); $check = $db->query("SELECT COUNT(*) FROM system_bank_accounts")->fetchColumn(); if ($check == 0) { $db->exec("INSERT INTO `system_bank_accounts` (`bank_name`, `account_number`, `account_name`, `is_active`, `sort_order`) VALUES ('ธนาคารกสิกรไทย (K-Bank)', '123-4-56789-0', 'บริษัท 41Shop จำกัด', 1, 1), ('ธนาคารไทยพาณิชย์ (SCB)', '987-6-54321-0', 'บริษัท 41Shop จำกัด', 1, 2)"); } echo "MIGRATION SUCCESSFUL! Total accounts: " . $db->query("SELECT COUNT(*) FROM system_bank_accounts")->fetchColumn() . "\n";
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.23 |
proxy
|
phpinfo
|
Settings