-- Check current SQL modes
SELECT @@sql_mode;
-- Set SQL mode without NO_ZERO_DATE and NO_ZERO_IN_DATE
SET sql_mode = REPLACE(@@sql_mode, 'NO_ZERO_IN_DATE', '');
SET sql_mode = REPLACE(@@sql_mode, 'NO_ZERO_DATE', '');
-- Update the orders table
UPDATE orders
SET confirmed_at = NULL 
WHERE confirmed_at = '0000-00-00 00:00:00';
-- Set the SQL mode back to its original setting
-- Replace 'your_original_sql_mode' with the mode you obtained from the first query
SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
-- Alter the orders table
ALTER TABLE orders MODIFY price DECIMAL(19,9);
ALTER TABLE orders MODIFY tip DECIMAL(19,9);
ALTER TABLE orders MODIFY price_in_usd DECIMAL(19,9);
ALTER TABLE orders MODIFY delivery_charge DECIMAL(19,9);

