39 lines
1.4 KiB
JavaScript
39 lines
1.4 KiB
JavaScript
const mysql = require('mysql2/promise');
|
|
require('dotenv').config(); // Load .env from current directory
|
|
|
|
async function addColumn() {
|
|
process.env.DB_HOST = process.env.DB_HOST || 'localhost';
|
|
process.env.DB_USER = process.env.DB_USER || 'root';
|
|
process.env.DB_PASSWORD = process.env.DB_PASSWORD || 'password'; // Fallback or assume env is loaded
|
|
process.env.DB_NAME = process.env.DB_NAME || 'sokuree_platform_dev';
|
|
|
|
console.log(`Connecting to database: ${process.env.DB_NAME} at ${process.env.DB_HOST}`);
|
|
|
|
const connection = await mysql.createConnection({
|
|
host: process.env.DB_HOST,
|
|
user: process.env.DB_USER,
|
|
password: process.env.DB_PASSWORD,
|
|
database: process.env.DB_NAME,
|
|
port: process.env.DB_PORT || 3306
|
|
});
|
|
|
|
try {
|
|
console.log("Checking if 'is_active' column exists...");
|
|
const [rows] = await connection.execute("SHOW COLUMNS FROM camera_settings LIKE 'is_active'");
|
|
|
|
if (rows.length === 0) {
|
|
console.log("Adding 'is_active' column...");
|
|
await connection.execute("ALTER TABLE camera_settings ADD COLUMN is_active BOOLEAN DEFAULT TRUE");
|
|
console.log("Column 'is_active' added successfully!");
|
|
} else {
|
|
console.log("Column 'is_active' already exists.");
|
|
}
|
|
} catch (error) {
|
|
console.error("Error updating database:", error);
|
|
} finally {
|
|
await connection.end();
|
|
}
|
|
}
|
|
|
|
addColumn();
|