-- ============================================
-- CREATE CONTACT US TABLE
-- ============================================

CREATE TABLE IF NOT EXISTS `contact_messages` (
  `contact_id` int(11) NOT NULL AUTO_INCREMENT,
  `contact_name` varchar(255) NOT NULL,
  `contact_email` varchar(255) NOT NULL,
  `contact_subject` varchar(500) NOT NULL,
  `contact_message` text NOT NULL,
  `contact_status` enum('new','read','replied') DEFAULT 'new',
  `contact_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `contact_ip` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`contact_id`),
  KEY `contact_status` (`contact_status`),
  KEY `contact_date` (`contact_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ============================================
-- EXECUTION COMPLETE
-- ============================================
