{"success":true,"sql_results":[{"sql":"ALTER TABLE appointments ADD COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP","success":false,"message":"SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'updated_at'"},{"sql":"ALTER TABLE appointments MODIFY COLUMN status ENUM('pending', 'pending_payment', 'confirmed', 'cancelled', 'completed') DEFAULT 'pending'","success":true,"message":"Executed successfully"}],"current_columns":[{"Field":"id","Type":"int(11)","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"user_id","Type":"int(11)","Null":"NO","Key":"MUL","Default":null,"Extra":""},{"Field":"user_name","Type":"varchar(100)","Null":"NO","Key":"","Default":null,"Extra":""},{"Field":"user_mobile","Type":"varchar(15)","Null":"NO","Key":"","Default":null,"Extra":""},{"Field":"appointment_date","Type":"date","Null":"NO","Key":"","Default":null,"Extra":""},{"Field":"time_slot","Type":"varchar(50)","Null":"NO","Key":"","Default":null,"Extra":""},{"Field":"amount","Type":"decimal(10,2)","Null":"NO","Key":"","Default":null,"Extra":""},{"Field":"consultation_type","Type":"enum('office_meeting','video_call','audio_call')","Null":"YES","Key":"","Default":"video_call","Extra":""},{"Field":"number_of_persons","Type":"int(11)","Null":"YES","Key":"","Default":"1","Extra":""},{"Field":"notes","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"status","Type":"enum('pending','pending_payment','confirmed','cancelled','completed')","Null":"YES","Key":"","Default":"pending","Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"current_timestamp()","Extra":""},{"Field":"is_tatkal","Type":"tinyint(1)","Null":"YES","Key":"","Default":"0","Extra":""},{"Field":"consultation_type_id","Type":"int(11)","Null":"YES","Key":"MUL","Default":null,"Extra":""},{"Field":"payment_status","Type":"enum('pending','paid','failed','refunded')","Null":"YES","Key":"MUL","Default":"pending","Extra":""},{"Field":"payment_transaction_id","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"updated_at","Type":"timestamp","Null":"YES","Key":"","Default":"current_timestamp()","Extra":"on update current_timestamp()"},{"Field":"external_ref","Type":"varchar(64)","Null":"YES","Key":"UNI","Default":null,"Extra":""}],"test_insert":true,"test_error":null,"test_record":{"id":5850,"user_id":1,"user_name":"Test User","user_mobile":"9999999999","appointment_date":"2024-01-01","time_slot":"10:00 - 11:00","amount":"100.00","consultation_type":"video_call","number_of_persons":1,"notes":null,"status":"pending","created_at":"2026-08-26 03:45:47","is_tatkal":0,"consultation_type_id":null,"payment_status":"pending","payment_transaction_id":null,"updated_at":"2026-08-26 03:45:47","external_ref":null}}