-- Sunucu paketleri tablosu
CREATE TABLE IF NOT EXISTS `server_packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `duration` int(11) NOT NULL COMMENT 'Gu00fcn cinsinden su00fcre',
  `features` text DEFAULT NULL COMMENT 'JSON formatunda u00f6zellikler',
  `status` varchar(20) NOT NULL DEFAULT 'active',
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Varsayu0131lan paketler
INSERT INTO `server_packages` (`name`, `description`, `price`, `duration`, `features`, `status`, `created_at`) VALUES
('Ayu0131k', '1 ayu0131k sunucu paketi', 30.00, 30, '{"slots":32,"traffic":"Sunu0131rsu0131z","backup":"Haftaluk"}', 'active', NOW()),
('3 Ay', '3 ayu0131k sunucu paketi, %10 indirimli', 81.00, 90, '{"slots":32,"traffic":"Sunu0131rsu0131z","backup":"Haftaluk"}', 'active', NOW()),
('6 Ay', '6 ayu0131k sunucu paketi, %15 indirimli', 153.00, 180, '{"slots":32,"traffic":"Sunu0131rsu0131z","backup":"Haftaluk"}', 'active', NOW()),
('Yu0131llu0131k', '1 yu0131llu0131k sunucu paketi, %20 indirimli', 288.00, 365, '{"slots":32,"traffic":"Sunu0131rsu0131z","backup":"Haftaluk"}', 'active', NOW());
