SIMON Master Console Rebuild
True command center for SIMON + WEB360
This rebuild gives you a cleaner production spine: interactive tree, live viewer, guarded editor, dynamic graphics, architecture map, and note storage. It is designed to sit beside your existing
console.php
and become the stronger replacement path.
Dashboard
Tree
Viewer
System Map
File Registry
Notes
Files
15,026
Folders
377
Scanned Size
3.79 GB
PHP Files
791
Editable Text Files
12,310
File viewer
guarded to /htdocs
/gaylord/gaylord/database/gaylord_chat.sql
SET NAMES utf8mb4; CREATE TABLE IF NOT EXISTS users (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,username VARCHAR(32) NOT NULL UNIQUE,email VARCHAR(190) NOT NULL UNIQUE,password_hash VARCHAR(255) NOT NULL,display_name VARCHAR(80) NOT NULL,birthdate VARCHAR(10) NOT NULL,bio TEXT NOT NULL,city VARCHAR(100) NOT NULL DEFAULT '',pronouns VARCHAR(50) NOT NULL DEFAULT '',looking_for VARCHAR(120) NOT NULL DEFAULT '',is_online TINYINT(1) NOT NULL DEFAULT 0,latitude DECIMAL(10,7) NULL,longitude DECIMAL(10,7) NULL,location_accuracy DECIMAL(10,2) NULL,location_updated_at DATETIME NULL,share_location TINYINT(1) NOT NULL DEFAULT 0,selfie_verified TINYINT(1) NOT NULL DEFAULT 0,vibe VARCHAR(80) NOT NULL DEFAULT '',nickname VARCHAR(80) NOT NULL DEFAULT '',profile_status VARCHAR(40) NOT NULL DEFAULT 'Online',theme_mode VARCHAR(20) NOT NULL DEFAULT 'dark',created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,last_seen DATETIME NULL,INDEX idx_users_location(latitude,longitude)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS media (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id BIGINT UNSIGNED NOT NULL,storage_name VARCHAR(255) NOT NULL,original_name VARCHAR(255) NOT NULL,mime VARCHAR(80) NOT NULL,size_bytes BIGINT NOT NULL,is_primary TINYINT(1) NOT NULL DEFAULT 0,is_selfie TINYINT(1) NOT NULL DEFAULT 0,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,INDEX idx_media_user(user_id,created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS messages (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,sender_id BIGINT UNSIGNED NOT NULL,recipient_id BIGINT UNSIGNED NOT NULL,body TEXT NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,read_at DATETIME NULL,INDEX idx_messages_pair(sender_id,recipient_id,created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS favorites (user_id BIGINT UNSIGNED NOT NULL,target_id BIGINT UNSIGNED NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(user_id,target_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS blocks (blocker_id BIGINT UNSIGNED NOT NULL,blocked_id BIGINT UNSIGNED NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(blocker_id,blocked_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS reports (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,reporter_id BIGINT UNSIGNED NOT NULL,reported_id BIGINT UNSIGNED NOT NULL,reason VARCHAR(80) NOT NULL,details TEXT NOT NULL,status VARCHAR(30) NOT NULL DEFAULT 'open',created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS password_resets (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id BIGINT UNSIGNED NOT NULL,token_hash VARCHAR(255) NOT NULL,status VARCHAR(24) NOT NULL DEFAULT 'open',created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS profile_reactions (user_id BIGINT UNSIGNED NOT NULL,target_id BIGINT UNSIGNED NOT NULL,reaction VARCHAR(40) NOT NULL,note VARCHAR(180) NOT NULL DEFAULT '',created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(user_id,target_id,reaction)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS notifications (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id BIGINT UNSIGNED NOT NULL,type VARCHAR(60) NOT NULL,title VARCHAR(140) NOT NULL,body VARCHAR(255) NOT NULL DEFAULT '',is_read TINYINT(1) NOT NULL DEFAULT 0,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS group_rooms (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,owner_id BIGINT UNSIGNED NOT NULL,name VARCHAR(80) NOT NULL,description VARCHAR(240) NOT NULL DEFAULT '',visibility VARCHAR(20) NOT NULL DEFAULT 'public',radius_km DECIMAL(8,2) NOT NULL DEFAULT 50,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS group_members (room_id BIGINT UNSIGNED NOT NULL,user_id BIGINT UNSIGNED NOT NULL,role VARCHAR(20) NOT NULL DEFAULT 'member',joined_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(room_id,user_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS group_messages (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,room_id BIGINT UNSIGNED NOT NULL,sender_id BIGINT UNSIGNED NOT NULL,body TEXT NOT NULL,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,INDEX idx_group_messages_room(room_id,created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS adult_videos (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,user_id BIGINT UNSIGNED NOT NULL,storage_name VARCHAR(255) NOT NULL,original_name VARCHAR(255) NOT NULL,mime VARCHAR(80) NOT NULL,size_bytes BIGINT NOT NULL,title VARCHAR(140) NOT NULL,description TEXT NOT NULL,status VARCHAR(24) NOT NULL DEFAULT 'published',created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS adult_video_votes (video_id BIGINT UNSIGNED NOT NULL,user_id BIGINT UNSIGNED NOT NULL,vote SMALLINT NOT NULL DEFAULT 1,rating SMALLINT NOT NULL DEFAULT 0,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(video_id,user_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS market_items (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,seller_id BIGINT UNSIGNED NOT NULL,title VARCHAR(120) NOT NULL,description TEXT NOT NULL,price_cents BIGINT NOT NULL DEFAULT 0,category VARCHAR(60) NOT NULL DEFAULT 'Other',condition_name VARCHAR(40) NOT NULL DEFAULT 'Used',storage_name VARCHAR(255) NULL,mime VARCHAR(80) NULL,status VARCHAR(24) NOT NULL DEFAULT 'active',created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS developer_reports (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,public_id VARCHAR(40) NOT NULL UNIQUE,category VARCHAR(60) NOT NULL,title VARCHAR(160) NOT NULL,body TEXT NOT NULL,email VARCHAR(190) NOT NULL DEFAULT '',status VARCHAR(30) NOT NULL DEFAULT 'Submitted',approved TINYINT(1) NOT NULL DEFAULT 0,created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS schema_meta (name VARCHAR(80) PRIMARY KEY,value VARCHAR(255) NOT NULL); INSERT INTO schema_meta(name,value) VALUES('schema_version','1') ON DUPLICATE KEY UPDATE value=VALUES(value);
Save file
Quick jump
open a path
Open