��JFIF��`�`��Viewing File: /home/u820193700/domains/spiti2026im.in/public_html/setup.sql

-- Database creation
CREATE DATABASE IF NOT EXISTS avahan_spiti_2026;
USE avahan_spiti_2026;

-- Registrations table
CREATE TABLE IF NOT EXISTS registrations (
    id INT AUTO_INCREMENT PRIMARY KEY,
    uid INT UNIQUE NOT NULL,
    name VARCHAR(100) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    email VARCHAR(100),
    city VARCHAR(100),
    bike VARCHAR(100),
    blood_group VARCHAR(10),
    tshirt_size VARCHAR(10),
    em_name VARCHAR(100),
    em_phone VARCHAR(20),
    experience VARCHAR(50),
    medical_notes TEXT,
    status ENUM('pending', 'confirmed', 'paid', 'cancelled') DEFAULT 'pending',
    payment_status ENUM('unpaid', 'deposit paid', 'full paid') DEFAULT 'unpaid',
    notes TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Interests table
CREATE TABLE IF NOT EXISTS interests (
    id INT AUTO_INCREMENT PRIMARY KEY,
    uid INT UNIQUE NOT NULL,
    name VARCHAR(100) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    email VARCHAR(100),
    city VARCHAR(100),
    status VARCHAR(50) DEFAULT 'interested',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Q&A table
CREATE TABLE IF NOT EXISTS qa (
    id INT AUTO_INCREMENT PRIMARY KEY,
    uid INT UNIQUE NOT NULL,
    question TEXT NOT NULL,
    answer TEXT,
    asked_by VARCHAR(100),
    published BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Admin table
CREATE TABLE IF NOT EXISTS admins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password_hash VARCHAR(255) NOT NULL,
    last_login TIMESTAMP NULL
);

-- Hotels table
CREATE TABLE IF NOT EXISTS hotels (
    id INT AUTO_INCREMENT PRIMARY KEY,
    uid INT UNIQUE NOT NULL,
    name VARCHAR(100) NOT NULL,
    day_location VARCHAR(100) NOT NULL,
    rooms_needed VARCHAR(50),
    rate_estimate VARCHAR(100),
    contact VARCHAR(50),
    notes TEXT,
    status ENUM('Not Booked', 'Pending', 'Booked') DEFAULT 'Not Booked',
    display_order INT DEFAULT 0
);

-- Contacts / Drafts
CREATE TABLE IF NOT EXISTS contacts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    uid INT UNIQUE NOT NULL,
    name VARCHAR(100) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    email VARCHAR(100),
    city VARCHAR(100),
    source VARCHAR(50),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Gallery table
CREATE TABLE IF NOT EXISTS gallery (
    id INT AUTO_INCREMENT PRIMARY KEY,
    uid INT UNIQUE NOT NULL,
    type ENUM('image', 'video', 'youtube', 'online_img') NOT NULL,
    url VARCHAR(512) NOT NULL,
    title VARCHAR(100),
    sort_order INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Insert default admin
INSERT IGNORE INTO admins (username, password_hash) VALUES ('admin', '$2y$10$SaBGYDaC7fzUzJOFEpGXQ.k4/WZUtiwjyBf42bukAkPFOscN8Hrou');

Back to Directory ��}�!1AQa"q2��#B��R��$3br� %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz�� w�!1AQaq"2�B�� #3R�br� $4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz��?��_��+��?��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��