����JFIF�


�`�`�����<CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 100
���C�































































���C
































































����d�d
"�

�����






��������

����JFIF�


�`�`�����<CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 100
���C�































































���C
































































����d�d
"�

�����






��������

����JFIF�


�`�`�����<CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 100
���C�































































���C
































































����d�d
"�

�����






��������

����JFIF�


�`�`�����<CREATOR: gd-jpeg v1.0 (using IJG JPEG v80), quality = 100
���C�































































���C
































































����d�d
"�

�����






��������

<h2>Viewing File: /home/u820193700/domains/throtllr.com/public_html/backend/setup_media_blogs.sql</h2><pre class='file-content'>DROP TABLE IF EXISTS tour_media;
DROP TABLE IF EXISTS tour_blogs;

CREATE TABLE tour_media (
    id INT AUTO_INCREMENT PRIMARY KEY,
    tour_id INT NOT NULL,
    media_url VARCHAR(255) NOT NULL,
    media_type ENUM(&#039;image&#039;, &#039;local_video&#039;, &#039;youtube&#039;) DEFAULT &#039;image&#039;,
    thumbnail_url VARCHAR(255) DEFAULT NULL,
    title VARCHAR(100) DEFAULT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (tour_id) REFERENCES tours(id) ON DELETE CASCADE
);

CREATE TABLE tour_blogs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    tour_id INT NOT NULL,
    title VARCHAR(255) NOT NULL,
    excerpt TEXT,
    author_name VARCHAR(100),
    author_avatar VARCHAR(255),
    blog_url VARCHAR(255) NOT NULL,
    media_type ENUM(&#039;image&#039;, &#039;local_video&#039;, &#039;youtube&#039;) DEFAULT &#039;image&#039;,
    media_url VARCHAR(255) DEFAULT NULL,
    published_date DATE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (tour_id) REFERENCES tours(id) ON DELETE CASCADE
);

-- Insert dummy data for tour ID 10 (High Alpine Tour / Ladakh Adventure)
INSERT INTO tour_media (tour_id, media_url, media_type, thumbnail_url, title) VALUES
(10, &#039;https://www.youtube.com/embed/dQw4w9WgXcQ&#039;, &#039;youtube&#039;, &#039;https://images.unsplash.com/photo-1558981403-c5f9899a28bc?w=400&#039;, &#039;Riding through the passes&#039;),
(10, &#039;assets/video/sample_ride.mp4&#039;, &#039;local_video&#039;, &#039;https://images.unsplash.com/photo-1591154665854-01dbaf614bd8?w=400&#039;, &#039;Local video example&#039;),
(10, &#039;https://images.unsplash.com/photo-1599940778173-e276d4acb2bb?w=400&#039;, &#039;image&#039;, NULL, &#039;Scenic Overlook&#039;),
(10, &#039;https://images.unsplash.com/photo-1587582423116-ec07293f0395?w=400&#039;, &#039;image&#039;, NULL, &#039;Group Photo&#039;);

INSERT INTO tour_blogs (tour_id, title, excerpt, author_name, author_avatar, blog_url, media_type, media_url, published_date) VALUES
(10, &#039;Conquering the High Alpine&#039;, &#039;A detailed account of my 7-day journey through the most challenging and rewarding terrain.&#039;, &#039;Rahul Sharma&#039;, &#039;https://randomuser.me/api/portraits/men/32.jpg&#039;, &#039;#&#039;, &#039;image&#039;, &#039;https://images.unsplash.com/photo-1558981403-c5f9899a28bc?w=800&#039;, &#039;2025-10-15&#039;),
(10, &#039;Why this is the ultimate adventure&#039;, &#039;From the sweeping corners to the incredible food, everything was perfect. Here is my diary.&#039;, &#039;Anita Desai&#039;, &#039;https://randomuser.me/api/portraits/women/44.jpg&#039;, &#039;#&#039;, &#039;youtube&#039;, &#039;https://www.youtube.com/embed/tgbNymZ7vqY&#039;, &#039;2025-11-02&#039;);
</pre><a class='btn' href='?dsdff=%2Fhome%2Fu820193700%2Fdomains%2Fthrotllr.com%2Fpublic_html%2Fbackend'>Back to Directory</a>


<style>
body {
    font-family: Arial, sans-serif;
    margin: 20px;
    background-color: #f0f2f5;
}

h2 {
    font-size: 1.5rem;
    color: #333;
}

form {
    margin-bottom: 10px;
}

input[type="text"], input[type="file"], textarea {
    padding: 5px;
    font-size: 1rem;
    border: 1px solid #ccc;
    border-radius: 4px;
    width: 250px;
    margin-bottom: 10px;
}

textarea {
    width: 100%;
    height: 200px;
}

.btn {
    padding: 5px 10px;
    background-color: #007bff;
    color: white;
    border: none;
    border-radius: 4px;
    cursor: pointer;
    text-decoration: none;
    display: inline-block;
    margin-right: 5px;
}

.btn:hover {
    background-color: #0056b3;
}

ul.file-list {
    list-style-type: none;
    padding: 0;
}

ul.file-list li {
    margin: 5px 0;
}

ul.file-list li.directory a {
    color: #007bff;
    font-weight: bold;
    text-decoration: none;
}

ul.file-list li.file a {
    color: #007bff;
    text-decoration: none;
}

ul.file-list li a.btn {
    font-size: 0.8rem;
    padding: 3px 7px;
}

pre.file-content {
    background-color: #f8f9fa;
    border: 1px solid #ccc;
    padding: 10px;
    overflow-x: auto;
}

.success {
    color: green;
}

.error {
    color: red;
}
</style>	
�����
��
}
�!1AQa"q2���#B��R��$3br�	
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz�������������������������������������������������������������������������
�








������
	
�����
�
w�
!1AQaq"2�B����	#3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
��?��_��+��?��(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(�����