Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
admin	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
assets	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
auth	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
includes	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
layouts	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
uploads	[ DIR ]	drwxr-xr-x	2026-04-01 03:43
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
404.php	2.81 KB	-rw-r--r--	2026-03-01 20:29
PRD.md	10.42 KB	-rw-r--r--	2026-03-01 20:12
contact.php	8.52 KB	-rw-r--r--	2026-03-01 23:42
dashboard.php	27.37 KB	-rw-r--r--	2026-03-01 20:23
database.sql	3.35 KB	-rw-r--r--	2026-03-01 20:13
error_log	6.87 KB	-rw-r--r--	2026-03-01 20:23
index.php	11.9 KB	-rw-r--r--	2026-03-16 18:50
me.zip	14.2 MB	-rw-r--r--	2026-03-01 20:08
payment.php	9.09 KB	-rw-r--r--	2026-03-01 23:13
process_order.php	2.36 KB	-rw-r--r--	2026-03-01 21:23
purchase.php	6.51 KB	-rw-r--r--	2026-03-01 23:14
services.php	5.29 KB	-rw-r--r--	2026-03-01 23:40
wp-blog-header.php	2.74 KB	-rw-r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

# CodeBySycho Database Schema

CREATE DATABASE IF NOT EXISTS fastear1_codebysycho;
USE fastear1_codebysycho;

-- Users Table
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(150) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    profile_pic VARCHAR(255) DEFAULT 'default_user.png',
    registered_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Services Table
CREATE TABLE services (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    features TEXT,
    full_description TEXT,
    price DECIMAL(10, 2) NOT NULL,
    is_premium BOOLEAN DEFAULT FALSE,
    status ENUM('Active', 'Inactive') DEFAULT 'Active',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Orders Table
CREATE TABLE orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    service_id INT NOT NULL,
    project_details TEXT,
    payment_status ENUM('Paid', 'Unpaid') DEFAULT 'Unpaid',
    order_status TINYINT DEFAULT 1 COMMENT 'Stages 1-8',
    deliverable_file VARCHAR(255),
    ordered_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (service_id) REFERENCES services(id)
);

-- Order Status History for progress bar
CREATE TABLE order_status_history (
    id INT AUTO_INCREMENT PRIMARY KEY,
    order_id INT NOT NULL,
    status_label VARCHAR(50) NOT NULL,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (order_id) REFERENCES orders(id)
);

-- Testimonials
CREATE TABLE testimonials (
    id INT AUTO_INCREMENT PRIMARY KEY,
    client_name VARCHAR(100),
    review_text TEXT,
    rating TINYINT DEFAULT 5,
    is_active BOOLEAN DEFAULT TRUE
);

-- Contact Settings
CREATE TABLE contact_settings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    phone VARCHAR(20),
    email VARCHAR(150),
    address TEXT,
    social_links JSON
);

-- Admin Credentials (Changeable)
CREATE TABLE admin_settings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(150) NOT NULL DEFAULT 'admin@gmail.com',
    password VARCHAR(255) NOT NULL,
    last_login TIMESTAMP
);

-- Initial Admin (Password: Admin123)
-- Hash: $2y$10$8u6A.F.H3vV9v5N9Q6i2fOuP2K.2g/9Wp/mN.Yl.oYl.Yl.oYl.Yl. (Placeholder - use real hash)
INSERT INTO admin_settings (email, password) VALUES ('admin@gmail.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi');

-- Payment Methods Table (used by Admin Payment Setup Panel)
CREATE TABLE admin_payment_methods (
    id INT AUTO_INCREMENT PRIMARY KEY,
    method_name VARCHAR(100) NOT NULL COMMENT 'e.g. JazzCash, Binance, Easypaisa',
    account_details TEXT NOT NULL COMMENT 'Account number, title, etc.',
    instructions TEXT COMMENT 'Instructions shown to the user on payment page',
    method_file VARCHAR(255) DEFAULT NULL COMMENT 'QR Code or Gateway Logo filename',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Add payment screenshot column to orders (for client payment proof)
ALTER TABLE orders ADD COLUMN payment_screenshot VARCHAR(255) DEFAULT NULL AFTER deliverable_file;

-- Example Payment Method (optional seed data - remove if not needed)
-- INSERT INTO admin_payment_methods (method_name, account_details, instructions) 
-- VALUES ('JazzCash', '03001234567 - Muhammad Sycho', 'Send payment and attach screenshot below.');