================================================================================ SKY MAREE STEELE | CLINICAL PSYCHOLOGIST - DATABASE & SYSTEM ARCHITECTURE ================================================================================ 1. WEBUZO & SERVER ENVIRONMENT -------------------------------------------------------------------------------- Control Panel: Webuzo (Namecheap VPS / Shared Hosting) Current User: skymareesteele Primary Domain: skymareesteele.com Server IP Address: 162.213.248.20 Home Directory: /home/skymareesteele Web Root (PHP Site): /home/skymareesteele/public_html Name Servers: NS1.WEARESPECTRUM.ONLINE NS2.WEARESPECTRUM.ONLINE 2. MYSQL DATABASE CREDENTIALS -------------------------------------------------------------------------------- Database Host: localhost (or 127.0.0.1) Database Name: skymareesteele_db Database User: skymareesteele_db Database Password: ##SkyBird123## Character Set: utf8mb4 Collation: utf8mb4_unicode_ci Default Port: 3306 3. SKY MAREE STEELE - OFFICIAL INFORMATION & SOCIAL LINKS -------------------------------------------------------------------------------- Name: Sky Maree Steele Title: Clinical Psychologist, CEO, ADHD Coach & Women's Mentor Bio: Dedicated to fostering mental well-being and personal growth. With years of experience in various psychological settings, Sky has developed a unique and holistic approach to mental health. She empowers clients with the tools and insights they need to build resilience, understand themselves better, and achieve their goals. Contact Email: contact@skymareesteele.com Contact Phone: +61 412 345 678 Official Website: https://www.uniquelyyoupsychology.com/ Official Channels & Social Media: - Facebook: https://www.facebook.com/skymareesteele - YouTube: https://www.youtube.com/@skylivingwithadhd - Instagram: https://www.instagram.com/skymareesteele/ - TikTok: https://www.tiktok.com/@skymareesteele - LinkedIn: https://au.linkedin.com/in/sky-maree-steele-86b335154 - Spotify Podcast: https://open.spotify.com/show/1BAqtz9KiW8dzqKhv5rTOd - Amazon Music Podcast: https://music.amazon.com/podcasts/1af7d4ef-4e2b-4360-855b-4127565a840d/business-strategy-for-adhders 4. USER ACCOUNTS & CREDENTIALS -------------------------------------------------------------------------------- [ACCOUNT 1 - ADMIN] Username: SkySteele Password / PassKey: SkyBird (or ##SkyBird123##) Role: Admin User Key: USR-SKY-ADMIN-8A9B7C6D Site Key: SITE-SKY-ADMIN-E5F6A1B2 Email: contact@skymareesteele.com Display Name: Sky Steele Admin Access: Full privileges across Site Content, Users, Media, Memes, Best Books, Staff, Classes, Bookings, Partners, Forum, and Master AI / Persistent Logic configurations. [ACCOUNT 2 - COMMUNITY MEMBER] Username: wellness_warrior Password / PassKey: password Role: User User Key: USR-WELL-USER-A1B2C3D4 Site Key: SITE-WELL-USER-E5F6A7B8 Display Name: Alex Chen Bio: Championing mental wellness one day at a time. Website: https://example-wellness.com [ACCOUNT 3 - COMMUNITY MEMBER] Username: mindful_maven Password / PassKey: password Role: User User Key: USR-MIND-USER-C9D8E7F6 Site Key: SITE-MIND-USER-G5H4I3J2 Display Name: Sarah Jones Bio: Finding peace in the present moment. Website: https://example-mindful.com [ACCOUNT 4 - COMMUNITY MEMBER] Username: growth_guru Password / PassKey: password Role: User User Key: USR-GROW-USER-K1L2M3N4 Site Key: SITE-GROW-USER-O5P6Q7R8 Display Name: David Lee Bio: Embracing the journey of personal growth. Website: https://example-growth.com [ACCOUNT 5 - COMMUNITY MEMBER] Username: jane_doe Password / PassKey: password Role: User User Key: USR-JANE-USER-C3D4E5F6 Site Key: SITE-JANE-USER-9A8B7C6D Email: jane.doe@example.com Display Name: Jane Doe Bio: Just a user exploring the community. Website: https://example-jane.com 5. COMPLETE MYSQL TABLES & STRUCTURE -------------------------------------------------------------------------------- 1. site_settings - setting_key (VARCHAR 100, PK) - setting_value (LONGTEXT) - updated_at (TIMESTAMP) Holds the JSON configuration for hero title, subtitle, about paragraphs, services list, testimonials list, footer contacts, meme directory texts, and site logo. 2. users - id (INT AUTO_INCREMENT, PK) - username (VARCHAR 100, UNIQUE) - email (VARCHAR 255) - password_hash (VARCHAR 255) - user_key (VARCHAR 100) - site_key (VARCHAR 100) - pass_key (VARCHAR 100) - role (ENUM 'Admin', 'User') - display_name (VARCHAR 255) - bio (TEXT) - profile_image (LONGTEXT) - header_image (LONGTEXT) - website (VARCHAR 255) - social_links (TEXT) - ai_provider (VARCHAR 50) [e.g., gemini, groq, openai, openrouter, mistral, anthropic] - ai_api_key (VARCHAR 255) [Individual AI API Key entered in Account Settings] - created_at (TIMESTAMP) 3. ai_settings - id (INT AUTO_INCREMENT, PK) - setting_key (VARCHAR 100, UNIQUE) - setting_value (LONGTEXT) - updated_at (TIMESTAMP) Controls Master AI and Persistent Logic: * master_ai_enabled: '1' or '0' (When activated by Sky, makes AI free site-wide) * master_ai_provider: gemini / groq / openai / openrouter * master_ai_api_key: The Master AI Key * sky_individual_api_key: Sky's personal AI key * sky_individual_provider: Sky's personal AI provider * persistent_logic_meme_quote: System prompt for Meme Quote Generator * persistent_logic_meme_keywords: System prompt for Keyword extraction * persistent_logic_image_generator: System prompt for Image Generator * persistent_logic_forum_assistant: System prompt for Clinical/ADHD Advisor * persistent_logic_admin_meme: System prompt for Admin Meme Generator 4. memes - id (VARCHAR 100, PK) - author (VARCHAR 100) - quote (TEXT) - image_url (LONGTEXT) - background_color (VARCHAR 50) - text_color (VARCHAR 50) - keyword (VARCHAR 255) - timestamp (BIGINT) - views (INT) - likes (INT) 5. meme_comments - id (VARCHAR 100, PK) - meme_id (VARCHAR 100) - author (VARCHAR 100) - content (TEXT) - timestamp (BIGINT) 6. forum_categories - id (VARCHAR 100, PK) - name (VARCHAR 255) - description (TEXT) 7. forum_subcategories - id (VARCHAR 100, PK) - category_id (VARCHAR 100) - name (VARCHAR 255) - description (TEXT) 8. forum_posts - id (VARCHAR 100, PK) - category_id (VARCHAR 100) - subcategory_id (VARCHAR 100) - author (VARCHAR 100) - title (VARCHAR 255) - content (LONGTEXT) - timestamp (BIGINT) 9. forum_replies - id (VARCHAR 100, PK) - post_id (VARCHAR 100) - author (VARCHAR 100) - content (LONGTEXT) - timestamp (BIGINT) 10. books - id (VARCHAR 100, PK) - url (VARCHAR 500) - title (VARCHAR 255) - description (TEXT) - image_url (LONGTEXT) - rating (DECIMAL 3,1) - reviews (INT) 11. staff - id (VARCHAR 100, PK) - name (VARCHAR 255) - title (VARCHAR 255) - bio (TEXT) - photo_url (LONGTEXT) - website (VARCHAR 255) - profile_url (VARCHAR 255) - social_links (TEXT) 12. classes - id (VARCHAR 100, PK) - title (VARCHAR 255) - description (TEXT) - start_date (BIGINT) - image_url (LONGTEXT) - spots_available (INT) 13. bookings - id (VARCHAR 100, PK) - class_id (VARCHAR 100) - username (VARCHAR 100) - message (TEXT) - status (ENUM 'Pending', 'Confirmed', 'Cancelled') - timestamp (BIGINT) 14. partners - id (VARCHAR 100, PK) - name (VARCHAR 255) - logo_url (LONGTEXT) - hyperlink (VARCHAR 500) - rating (INT) 15. media_items - id (VARCHAR 100, PK) - url (VARCHAR 500) - title (VARCHAR 255) - description (TEXT) - type (ENUM 'video', 'podcast', 'clip') - views (INT) 6. BUILT-IN METHODS TO ADD & MANAGE DATA -------------------------------------------------------------------------------- Method A: Web-Based Automated Installer (Recommended) Navigate in your browser to: https://skymareesteele.com/install.php Click "Install / Seed Database". The script connects to MySQL, creates all tables, imports all users, media items, memes, forum discussions, staff, and initializes the default AI persistent logic. Method B: Import via Webuzo phpMyAdmin 1. Log into Webuzo Control Panel. 2. Click on phpMyAdmin under Database section. 3. Select database `skymareesteele_db`. 4. Click the "Import" tab at the top. 5. Choose the file `PHP/schema.sql`. 6. Click "Go" to execute. Method C: In-App Admin Control Panel 1. Open https://skymareesteele.com/ 2. Click "Login" in the header or footer. 3. Log in with Sky's admin credentials (SkySteele / SkyBird). 4. Navigate to Admin Dashboard (https://skymareesteele.com/dashboard.php). 5. Use the visual tabs to manage: - Sky's Bio & Practitioner Profile (WYSIWYG Rich Text) - Services, Programs & Session Pricing - SEO & Dynamic Meta Tags (Title, Description, Canonical URL, Keywords) - Audit Logs (Immutable security trail of all sensitive admin actions) - FAQs Manager - Subscribers & Client Enquiries - Master AI & Persistent Logic Inputs Method E: Emergency Database Backup & Export 1. In the Admin Dashboard header or Audit Logs tab, click "Export DB (.SQL)" 2. Alternatively, visit https://skymareesteele.com/export_db.php (Admin session required) 3. Instantly streams a full, timestamped SQL dump (`skymareesteele_db_backup_YYYY-MM-DD_HH-mm-ss.sql`) with DROP TABLE, CREATE TABLE, and INSERT statements for complete disaster recovery. 4. Every backup download is automatically recorded in the `audit_logs` security trail. Method D: User Control Panel (Individual AI Setup) 1. Log in as any registered user. 2. Click on username -> "Account Settings". 3. In the "Individual AI Configuration" section: - Select your preferred provider (Google Gemini, Groq, OpenAI, OpenRouter, Mistral, HuggingFace, Anthropic). - Paste your personal API Key. - Save changes. 4. AI features will instantly activate for your account. 7. AI ARCHITECTURE & PERSISTENT LOGIC ENFORCEMENT -------------------------------------------------------------------------------- No Auto-Load Mandate: - The site does NOT automatically execute background AI calls or require an API key to browse, read, book, or view media. - When an AI feature is accessed (Meme Quote, Meme Image, Image Generator, Forum Assistant, Admin Meme): 1. It first checks if the user has an individual API key in their profile. 2. If not, it checks if Sky has activated the "Master AI Input" (Free Site AI). 3. If neither is configured, the user is given a clear prompt with direct link to their Account Settings to add a free API key. - Persistent Logic Inputs: Each AI capability has its own customizable system prompt stored in `ai_settings`, which can be edited directly in the Admin Panel. These persistent logic inputs steer every generated quote, keyword, image prompt, and coaching reply. ================================================================================