-- ساخت جدول کاربران با پشتیبانی کامل فارسی
CREATE TABLE IF NOT EXISTS `users` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `fullname_fa` VARCHAR(191) COLLATE utf8mb4_general_ci NOT NULL,
  `fullname_en` VARCHAR(191) COLLATE utf8mb4_general_ci NOT NULL,
  `username` VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL UNIQUE,
  `password_hash` VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` VARCHAR(30) COLLATE utf8mb4_general_ci NOT NULL,
  `email` VARCHAR(191) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` DATETIME NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
