CORE_V5 // everestentp

PATH: home / u865795251 / domains / whatisnewis.com / public_html / everestentp /

Editing: database.sql

-- Database creation or use statement (optional)
CREATE DATABASE IF NOT EXISTS `tapwell_everest` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `tapwell_everest`;

-- Table structure for table `admin_users`
CREATE TABLE IF NOT EXISTS `admin_users` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `username` VARCHAR(50) NOT NULL UNIQUE,
  `password_hash` VARCHAR(255) NOT NULL,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Table structure for table `inquiries`
CREATE TABLE IF NOT EXISTS `inquiries` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(100) NOT NULL,
  `email` VARCHAR(100) NOT NULL,
  `phone` VARCHAR(30) DEFAULT NULL,
  `company` VARCHAR(100) DEFAULT NULL,
  `budget` VARCHAR(50) DEFAULT NULL,
  `quantity` VARCHAR(50) DEFAULT NULL,
  `specs` TEXT DEFAULT NULL,
  `message` TEXT DEFAULT NULL,
  `category` VARCHAR(100) DEFAULT NULL,
  `form_type` VARCHAR(50) DEFAULT NULL,
  `status` ENUM('pending', 'contacted', 'resolved') DEFAULT 'pending',
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Default Admin User (username: admin, password: AdminEverest2026!)
INSERT INTO `admin_users` (`username`, `password_hash`) VALUES
('admin', '$2y$10$94uaMZ4IQ/2sqjAL6WfZbuUTvuhMRDjfsc/UVFkfadgRzJwmJ6DRe');

CANCEL