START TRANSACTION; ALTER TABLE `diet` ADD COLUMN `premium` TINYINT(1) NULL DEFAULT 0 AFTER `start_date`; UPDATE configuration set config_value = "1.2.6", date_change=CURRENT_DATE WHERE config_key = "db_version"; COMMIT;