Index: add-guest-role.js
===================================================================
--- add-guest-role.js	(revision d8deee62c54f2f99103fcf6857652e90d8a97637)
+++ add-guest-role.js	(revision d8deee62c54f2f99103fcf6857652e90d8a97637)
@@ -0,0 +1,31 @@
+// Add role column to guest table
+require('dotenv').config();
+const { Pool } = require('pg');
+
+const pool = new Pool({
+    user: process.env.DB_USER,
+    host: process.env.DB_HOST,
+    database: process.env.DB_NAME,
+    password: process.env.DB_PASSWORD,
+    port: parseInt(process.env.DB_PORT, 10),
+    ssl: { rejectUnauthorized: false }
+});
+
+async function addRoleColumn() {
+    try {
+        console.log('🔄 Adding role column to guest table...');
+        
+        await pool.query(`
+            ALTER TABLE project.guest 
+            ADD COLUMN IF NOT EXISTS role VARCHAR(100) DEFAULT 'Guest'
+        `);
+        
+        console.log('✅ Role column added successfully!');
+        process.exit(0);
+    } catch (err) {
+        console.error('❌ Error:', err.message);
+        process.exit(1);
+    }
+}
+
+addRoleColumn();