-- CloudVault Initial Schema - Servers Table
CREATE TABLE IF NOT EXISTS `servers` (
  `id` int AUTO_INCREMENT NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `api_key` varchar(255),
  `storage_capacity` bigint,
  `storage_used` bigint DEFAULT 0,
  `status` varchar(50) DEFAULT 'active',
  `last_ping` timestamp,
  `created_at` timestamp DEFAULT (now()),
  CONSTRAINT `servers_id` PRIMARY KEY(`id`)
);
