ALTER TABLE panel_customers ADD COLUMN backup_days INT DEFAULT 7; DROP TABLE IF EXISTS `modules_backup_jobs`; CREATE TABLE `modules_backup_jobs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customerid` int(11) NOT NULL, `backup_typ` varchar(20) NOT NULL, `backup_status` longtext NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;