-- CloudVault Initial Schema - Backup Schedules Table
CREATE TABLE IF NOT EXISTS `backup_schedules` (
  `id` int AUTO_INCREMENT NOT NULL,
  `device_id` varchar(255) NOT NULL,
  `backup_type` varchar(50) NOT NULL,
  `frequency` varchar(50) NOT NULL,
  `time_of_day` varchar(10),
  `enabled` boolean DEFAULT true,
  `last_run` timestamp,
  `next_run` timestamp,
  `created_at` timestamp DEFAULT (now()),
  CONSTRAINT `backup_schedules_id` PRIMARY KEY(`id`)
);
