-- Safe upgrade: no existing users/statistics are deleted
ALTER TABLE `bots` ADD COLUMN `renew_fee` BIGINT NOT NULL DEFAULT 0 AFTER `days_remaining`;
ALTER TABLE `bots` ADD COLUMN `renew_days` INT NOT NULL DEFAULT 30 AFTER `renew_fee`;

CREATE TABLE IF NOT EXISTS `renew_payments` (
  `id` BIGINT NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT NOT NULL,
  `bot_id` INT NOT NULL,
  `amount` BIGINT NOT NULL,
  `status` VARCHAR(30) NOT NULL DEFAULT 'pending',
  `tracking_code` VARCHAR(100) DEFAULT NULL,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `paid_at` DATETIME DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tracking_code` (`tracking_code`),
  KEY `user_status` (`user_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;