--
-- Table structure for table `sermons_serm`
--
CREATE TABLE IF NOT EXISTS `sermons_serm` (
  `serm_id` INT AUTO_INCREMENT PRIMARY KEY,
  `serm_title` VARCHAR(255) NOT NULL,
  `serm_speaker` VARCHAR(255) DEFAULT '',
  `serm_date` DATE DEFAULT NULL,
  `serm_description` TEXT,
  `serm_audio_url` VARCHAR(500) DEFAULT '',
  `serm_video_url` VARCHAR(500) DEFAULT '',
  `serm_scripture` VARCHAR(255) DEFAULT '',
  `serm_image_url` VARCHAR(500) DEFAULT '',
  `serm_featured` TINYINT(1) DEFAULT 0,
  `serm_created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `serm_updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `serm_created_by` INT DEFAULT NULL
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;

--
-- Table structure for table `videos_vid`
--
CREATE TABLE IF NOT EXISTS `videos_vid` (
  `vid_id` INT AUTO_INCREMENT PRIMARY KEY,
  `vid_title` VARCHAR(255) NOT NULL,
  `vid_description` TEXT,
  `vid_url` VARCHAR(500) DEFAULT '',
  `vid_embed_code` TEXT,
  `vid_category` VARCHAR(100) DEFAULT '',
  `vid_thumbnail_url` VARCHAR(500) DEFAULT '',
  `vid_featured` TINYINT(1) DEFAULT 0,
  `vid_date` DATE DEFAULT NULL,
  `vid_created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `vid_updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `vid_created_by` INT DEFAULT NULL
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;

--
-- Table structure for table `prayer_requests_pray`
--
CREATE TABLE IF NOT EXISTS `prayer_requests_pray` (
  `pray_id` INT AUTO_INCREMENT PRIMARY KEY,
  `pray_name` VARCHAR(255) DEFAULT '',
  `pray_email` VARCHAR(255) DEFAULT '',
  `pray_request` TEXT NOT NULL,
  `pray_status` VARCHAR(20) DEFAULT 'pending',
  `pray_answer_notes` TEXT,
  `pray_created_at` DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;

--
-- Table structure for table `contact_submissions_con`
--
CREATE TABLE IF NOT EXISTS `contact_submissions_con` (
  `con_id` INT AUTO_INCREMENT PRIMARY KEY,
  `con_name` VARCHAR(255) DEFAULT '',
  `con_email` VARCHAR(255) DEFAULT '',
  `con_subject` VARCHAR(255) DEFAULT '',
  `con_message` TEXT NOT NULL,
  `con_read` TINYINT(1) DEFAULT 0,
  `con_created_at` DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
