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');
SAVE
CANCEL