-- تغییرات تکمیلی ربات فروشگاهی خیرآبادی

ALTER TABLE `users`
  ADD COLUMN IF NOT EXISTS `address` text DEFAULT NULL;

ALTER TABLE `users`
  MODIFY COLUMN `req3` text DEFAULT NULL;

ALTER TABLE `shop_orders`
  ADD COLUMN IF NOT EXISTS `discount_code` varchar(64) DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS `discount_amount` decimal(14,0) NOT NULL DEFAULT 0,
  ADD COLUMN IF NOT EXISTS `receipt_message_id` int(11) DEFAULT NULL;

ALTER TABLE `wallet_receipts`
  ADD COLUMN IF NOT EXISTS `receipt_message_id` int(11) DEFAULT NULL;

ALTER TABLE `shop_products`
  ADD COLUMN IF NOT EXISTS `content_message_id` int(11) DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS `content_chat_id` varchar(64) DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS `subcategory_id` int(11) DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `shop_subcategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE IF NOT EXISTS `discount_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `discount_type` enum('percent','fixed') NOT NULL DEFAULT 'percent',
  `discount_value` decimal(14,2) NOT NULL DEFAULT 0,
  `max_uses` int(11) DEFAULT NULL,
  `used_count` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `expires_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;