USE echohrcz_sitetrisqure;
CREATE TABLE IF NOT EXISTS `admin` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `email` VARCHAR(255) DEFAULT NULL,
  `password` VARCHAR(255) DEFAULT NULL,
  `role` VARCHAR(50) DEFAULT 'admin',
  `full_name` VARCHAR(255) DEFAULT NULL,
  `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_idx` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT IGNORE INTO `admin` (`email`,`password`,`role`,`full_name`) VALUES ('admin@local','$2y$10__HASH__guKBDCzpZni0Vju8ifm6.6XqN8FW4ot1zIlSY4FO.BPSmZzlBJeS','super','Site Admin');