File manager - Edit - /home/webapp69.cm.in.th/u69319090033/Shop/tools_backup/migrate_seller.php
Back
<?php require_once __DIR__ . '/db.php'; echo "Running migration...\n"; // 1. Modify role column $q1 = "ALTER TABLE `users` MODIFY COLUMN `role` ENUM('user','buyer','seller','admin','page_editor') NOT NULL DEFAULT 'user'"; if ($conn->query($q1)) { echo "Updated role enum successfully.\n"; } else { echo "Error updating role: " . $conn->error . "\n"; } // 2. Check and add seller_status $checkCol = $conn->query("SHOW COLUMNS FROM `users` LIKE 'seller_status'"); if ($checkCol && $checkCol->num_rows === 0) { $q2 = "ALTER TABLE `users` ADD COLUMN `seller_status` ENUM('none','pending','approved','rejected') NOT NULL DEFAULT 'none' AFTER `role`"; if ($conn->query($q2)) { echo "Added seller_status column successfully.\n"; } else { echo "Error adding seller_status: " . $conn->error . "\n"; } } else { echo "seller_status column already exists.\n"; } // 3. Check and add approved_at $checkCol = $conn->query("SHOW COLUMNS FROM `users` LIKE 'approved_at'"); if ($checkCol && $checkCol->num_rows === 0) { $q3 = "ALTER TABLE `users` ADD COLUMN `approved_at` TIMESTAMP NULL DEFAULT NULL AFTER `created_at`"; if ($conn->query($q3)) { echo "Added approved_at column successfully.\n"; } else { echo "Error adding approved_at: " . $conn->error . "\n"; } } else { echo "approved_at column already exists.\n"; } // 4. Check and add approved_by $checkCol = $conn->query("SHOW COLUMNS FROM `users` LIKE 'approved_by'"); if ($checkCol && $checkCol->num_rows === 0) { $q4 = "ALTER TABLE `users` ADD COLUMN `approved_by` INT(11) NULL DEFAULT NULL AFTER `approved_at`"; if ($conn->query($q4)) { echo "Added approved_by column successfully.\n"; } else { echo "Error adding approved_by: " . $conn->error . "\n"; } } else { echo "approved_by column already exists.\n"; } // Update existing sellers $conn->query("UPDATE `users` SET `seller_status` = 'approved' WHERE `role` = 'seller'"); echo "Migration finished.\n";
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.24 |
proxy
|
phpinfo
|
Settings