42 lines
1.0 KiB
PHP
42 lines
1.0 KiB
PHP
<?php
|
|
require_once __DIR__ . '/config.php';
|
|
|
|
try {
|
|
$pdo = db();
|
|
$pdo->beginTransaction();
|
|
|
|
echo "Cleaning up demo data...\n";
|
|
|
|
// 1. Delete Order Items (Child of Orders)
|
|
$pdo->exec("DELETE FROM order_items");
|
|
echo "- Deleted order items.\n";
|
|
|
|
// 2. Delete Orders (Child of Outlets, Users, Tables)
|
|
$pdo->exec("DELETE FROM orders");
|
|
echo "- Deleted orders.\n";
|
|
|
|
// 3. Delete Tables (Child of Areas)
|
|
$pdo->exec("DELETE FROM tables");
|
|
echo "- Deleted tables.\n";
|
|
|
|
// 4. Delete Areas (Child of Outlets)
|
|
$pdo->exec("DELETE FROM areas");
|
|
echo "- Deleted areas.\n";
|
|
|
|
// 5. Delete Outlets
|
|
$pdo->exec("DELETE FROM outlets");
|
|
echo "- Deleted outlets.\n";
|
|
|
|
// Optional: Reset auto-increment (MySQL specific)
|
|
$pdo->exec("ALTER TABLE outlets AUTO_INCREMENT = 1");
|
|
$pdo->exec("ALTER TABLE orders AUTO_INCREMENT = 1");
|
|
|
|
$pdo->commit();
|
|
echo "✅ Demo data cleared successfully.\n";
|
|
|
|
} catch (Exception $e) {
|
|
$pdo->rollBack();
|
|
echo "❌ Error clearing data: " . $e->getMessage() . "\n";
|
|
}
|
|
|