-- ===================================================================== -- ONE POINT ALLIANCE - DATABASE SCHEMA -- Compatible with any database name (e.g. onepoint or onepoint_db) -- ===================================================================== -- --------------------------------------------------------------------- -- 1. Table structure for `admins` -- Default Admin Credentials: -- Username: admin OR admin@onepointalliance.com.au -- Password: admin123 -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `admins` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `username` VARCHAR(60) NOT NULL UNIQUE, `email` VARCHAR(120) NOT NULL UNIQUE, `password_hash` VARCHAR(255) NOT NULL, `full_name` VARCHAR(100) NOT NULL DEFAULT 'Alliance Administrator', `role` ENUM('superadmin', 'admin', 'manager') DEFAULT 'superadmin', `designation` VARCHAR(100) DEFAULT 'Alliance Executive', `avatar` VARCHAR(255) DEFAULT NULL, `phone` VARCHAR(50) DEFAULT NULL, `bio` TEXT DEFAULT NULL, `last_login` DATETIME DEFAULT NULL, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- --------------------------------------------------------------------- -- 2. Table structure for `bookings` (Discovery / Strategic Consultations) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `bookings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `division` VARCHAR(100) NOT NULL DEFAULT 'General Enquiry', `name` VARCHAR(120) NOT NULL, `email` VARCHAR(120) NOT NULL, `phone` VARCHAR(40) NOT NULL, `notes` TEXT DEFAULT NULL, `status` ENUM('pending', 'contacted', 'completed', 'cancelled') DEFAULT 'pending', `assigned_advisor` VARCHAR(100) DEFAULT NULL, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- --------------------------------------------------------------------- -- 3. Table structure for `contacts` (Contact Us, Call Requests, General Inquiries) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `contacts` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `inquiry_type` ENUM('contact-us', 'request-call', 'general-enquiry') DEFAULT 'contact-us', `full_name` VARCHAR(120) NOT NULL, `email` VARCHAR(120) NOT NULL, `phone` VARCHAR(40) NOT NULL, `service_interest` VARCHAR(80) DEFAULT 'finance', `preferred_time` VARCHAR(60) DEFAULT NULL, `timeframe` VARCHAR(60) DEFAULT NULL, `message` TEXT DEFAULT NULL, `status` ENUM('unread', 'in_progress', 'resolved', 'archived') DEFAULT 'unread', `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- --------------------------------------------------------------------- -- 4. Table structure for `partner_applications` (B2B Practice Accreditation) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `partner_applications` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `firm_name` VARCHAR(150) NOT NULL, `applicant_name` VARCHAR(120) NOT NULL, `email` VARCHAR(120) NOT NULL, `phone` VARCHAR(40) NOT NULL, `sector` VARCHAR(80) NOT NULL DEFAULT 'finance', `years_in_business` VARCHAR(40) NOT NULL DEFAULT '5-10', `credentials` VARCHAR(255) DEFAULT NULL, `message` TEXT DEFAULT NULL, `status` ENUM('pending', 'under_review', 'approved', 'declined') DEFAULT 'pending', `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- --------------------------------------------------------------------- -- 5. Table structure for `newsletter_subscribers` -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `newsletter_subscribers` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `email` VARCHAR(150) NOT NULL UNIQUE, `status` ENUM('active', 'unsubscribed') DEFAULT 'active', `subscribed_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- --------------------------------------------------------------------- -- 6. Table structure for `frontend_hero_settings` (Hero Section Content) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_hero_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `pill_badge_text` VARCHAR(255) NOT NULL DEFAULT 'Australia\'s Premier Private Advisory Alliance', `headline_main` TEXT NOT NULL, `headline_highlight` VARCHAR(255) NOT NULL DEFAULT 'from startup to growth.', `subtext` TEXT NOT NULL, `btn_primary_text` VARCHAR(100) NOT NULL DEFAULT 'Book a Consultation', `btn_secondary_text` VARCHAR(100) NOT NULL DEFAULT 'Explore Services', `btn_secondary_link` VARCHAR(255) NOT NULL DEFAULT '/services', `rating_score` VARCHAR(50) NOT NULL DEFAULT '4.98 / 5.0', `proof_caption` VARCHAR(255) NOT NULL DEFAULT 'Trusted by over 5,400+ Australian families & businesses', `accreditation_tags` TEXT NOT NULL, `deal_room_tag` VARCHAR(100) NOT NULL DEFAULT 'LIVE DEAL ROOM', `pod_heading` VARCHAR(150) NOT NULL DEFAULT 'Coordinated Advisory Pod', `pod_status_badge` VARCHAR(100) NOT NULL DEFAULT 'Synchronized', `floating_metric_num` VARCHAR(100) NOT NULL DEFAULT '$1.4B+ Assets Coordinated', `floating_metric_sub` VARCHAR(255) NOT NULL DEFAULT '100% Zero-Conflict Execution', `pods_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ===================================================================== -- DUMMY / INITIAL SEED DATA -- ===================================================================== -- 1. Insert Default Admin User -- Password is 'admin123' (Bcrypt hash: $2y$10$tM2a60s1n79WkE4B8f9Vv.y3U8fT4f0q4GzR.c7rD1Z5lM7.x9a9W) DELETE FROM `admins` WHERE `username` = 'admin'; INSERT INTO `admins` (`username`, `email`, `password_hash`, `full_name`, `role`) VALUES ('admin', 'admin@onepointalliance.com.au', '$2y$10$Ww48eRjLd8j7wH07h9sVq.Y19uBw5L2lK7sXyL90iVvF.n7wG7VGy', 'Alliance Executive Admin', 'superadmin'); -- 2. Insert Sample Consultations / Bookings INSERT INTO `bookings` (`division`, `name`, `email`, `phone`, `notes`, `status`, `created_at`) VALUES ('Finance & Mortgage', 'David Vance', 'david.vance@vancetech.com.au', '0400 123 456', 'Looking for commercial refinancing for $2.4M industrial warehouse in Brisbane.', 'pending', NOW() - INTERVAL 2 HOUR), ('Property', 'Sarah Jenkins', 'sarah.j@apollocapital.com', '0412 889 900', 'Buyer advocacy request for luxury residential purchase in Sydney Eastern Suburbs.', 'contacted', NOW() - INTERVAL 1 DAY), ('Business', 'Marcus Thorne', 'm.thorne@thornegroup.net', '0433 554 112', 'Corporate tax restructuring and Virtual CFO advisory for expansion into VIC.', 'completed', NOW() - INTERVAL 3 DAY), ('Legal & Conveyancing', 'Elena Rostova', 'elena@rostovadesign.com.au', '0421 998 776', 'Urgent contract review for commercial lease in Barangaroo.', 'pending', NOW() - INTERVAL 5 HOUR); -- 3. Insert Sample Contacts / Inquiries INSERT INTO `contacts` (`inquiry_type`, `full_name`, `email`, `phone`, `service_interest`, `preferred_time`, `timeframe`, `message`, `status`, `created_at`) VALUES ('request-call', 'Julian Bradley', 'julian.b@bradleyco.com', '0418 223 344', 'finance', 'morning', 'immediately', 'Need emergency pre-auction approval advice before Saturday auction.', 'unread', NOW() - INTERVAL 1 HOUR), ('contact-us', 'Clara Montgomery', 'clara@montgomerylaw.com.au', '0420 556 778', 'legal', 'afternoon', 'today', 'Inquiring regarding multi-jurisdiction conveyancing capabilities.', 'in_progress', NOW() - INTERVAL 1 DAY), ('general-enquiry', 'Thomas Reed', 'thomas.reed@sydneyinvest.org', '0409 112 233', 'multi-division', 'morning', 'this-week', 'Interested in cross-pillar synergy for SMSF property and tax structuring.', 'resolved', NOW() - INTERVAL 2 DAY); -- 4. Insert Sample Partner Applications INSERT INTO `partner_applications` (`firm_name`, `applicant_name`, `email`, `phone`, `sector`, `years_in_business`, `credentials`, `message`, `status`, `created_at`) VALUES ('Apex Wealth Advisory', 'Robert Sinclair', 'r.sinclair@apexwealth.com.au', '0411 778 899', 'finance', '10+', 'MFAA Fellow, AFSL #489120', 'We manage $150M+ in loan volume annually and want to join the Sydney advisory panel.', 'under_review', NOW() - INTERVAL 12 HOUR), ('Prestige Conveyancing NSW', 'Amanda Sterling', 'amanda@prestigelegal.nsw.gov.au', '0422 334 455', 'legal', '5-10', 'Law Society NSW, AIC Member', 'Seeking exclusive conveyancing partnership for North Shore residential deals.', 'pending', NOW() - INTERVAL 1 DAY); -- 5. Insert Sample Newsletter Subscribers INSERT INTO `newsletter_subscribers` (`email`, `status`, `subscribed_at`) VALUES ('executive.briefing@macquarie.com', 'active', NOW() - INTERVAL 3 DAY), ('investor.desk@meriton.com.au', 'active', NOW() - INTERVAL 2 DAY), ('director@horizonwealth.com.au', 'active', NOW() - INTERVAL 1 DAY); -- 6. Insert 100% Exact Live Hero Section Content DELETE FROM `frontend_hero_settings`; INSERT INTO `frontend_hero_settings` ( `id`, `pill_badge_text`, `headline_main`, `headline_highlight`, `subtext`, `btn_primary_text`, `btn_secondary_text`, `btn_secondary_link`, `rating_score`, `proof_caption`, `accreditation_tags`, `deal_room_tag`, `pod_heading`, `pod_status_badge`, `floating_metric_num`, `floating_metric_sub`, `pods_json` ) VALUES ( 1, 'Australia\'s Premier Private Advisory Alliance', 'An integrated business, finance and property services group helping individuals and businesses', 'from startup to growth.', 'Access finance, property, accounting, legal and insurance services through one connected alliance.', 'Book a Consultation', 'Explore Services', '/services', '4.98 / 5.0', 'Trusted by over 5,400+ Australian families & businesses', 'MFAA Accredited, CA ANZ, REBAA Certified, Law Society', 'LIVE DEAL ROOM', 'Coordinated Advisory Pod', 'Synchronized', '$1.4B+ Assets Coordinated', '100% Zero-Conflict Execution', -- --------------------------------------------------------------------- -- 7. Table structure for `frontend_pillars_settings` (The 5 Core Advisory Pillars Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_pillars_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Top 1% Accredited Partners', `title_main` VARCHAR(255) NOT NULL DEFAULT 'The 5 Core', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Advisory Pillars', `subtitle` TEXT NOT NULL, `bottom_btn_text` VARCHAR(255) NOT NULL DEFAULT 'View Full Services Architecture', `bottom_btn_link` VARCHAR(255) NOT NULL DEFAULT '/services', `pillars_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 7. Insert 100% Exact Live Advisory Pillars Section Content DELETE FROM `frontend_pillars_settings`; INSERT INTO `frontend_pillars_settings` ( `id`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `bottom_btn_text`, `bottom_btn_link`, `pillars_json` ) VALUES ( 1, 'Top 1% Accredited Partners', 'The 5 Core', 'Advisory Pillars', 'All alliance specialists operate under independent AFSL, ACL, and CPA/CA licenses, coordinating through a single synchronized blueprint to guarantee conflict-free execution.', 'View Full Services Architecture', '/services', '[{"id":"finance","icon":"Landmark","color":"#059669","category_tag":"SERVICES: FINANCE & MORTGAGE","title":"Finance & Mortgage","subtitle":"Bespoke Lending & Capital Solutions Across 40+ Premier Lenders","shortDesc":"Comprehensive residential, commercial, investment, and personal finance structuring tailored to your cashflow.","bullet_points":["Home & Residential Loans","Investment & Equity Lending","Commercial & Business Finance","Personal & Vehicle Finance"],"btn_text":"View All Finance & Mortgage Solutions","btn_link":"/services?pillar=finance"},{"id":"property","icon":"Building2","color":"#b48c1a","category_tag":"SERVICES: PROPERTY & REAL ESTATE","title":"Property & Real Estate","subtitle":"High-Yield Acquisition, Strategic Development & Turnkey Management","shortDesc":"End-to-end real estate advisory covering residential, commercial, construction, investment, and complete asset management.","bullet_points":["Residential & Buyers Advocacy","Investment & Advisory","Commercial & Construction","Property & Asset Management"],"btn_text":"View All Property & Real Estate Solutions","btn_link":"/services?pillar=property"},{"id":"accounting","icon":"Calculator","color":"#2563eb","category_tag":"SERVICES: ACCOUNTING & BUSINESS ADVISORY","title":"Accounting & Business Advisory","subtitle":"Strategic Tax Minimization, Business Setup & Corporate CFO Advisory","shortDesc":"Comprehensive accounting, tax structuring, entity establishment, and strategic advisory designed to protect and scale enterprises.","bullet_points":["Accounting & Tax Compliance","Business Setup & Structuring","Cloud Bookkeeping & BAS","Business Growth & CFO Advisory"],"btn_text":"View All Accounting & Business Advisory Solutions","btn_link":"/services?pillar=accounting"},{"id":"legal","icon":"Scale","color":"#9333ea","category_tag":"SERVICES: LEGAL & CONVEYANCING SERVICES","title":"Legal & Conveyancing Services","subtitle":"Conveyancing Precision & Robust Commercial Legal Counsel","shortDesc":"Precision legal representation covering property transfers, commercial agreements, and business compliance.","bullet_points":["Property Conveyancing","Business & Commercial Law","Property Legal & Leasing","Estate & Succession Planning"],"btn_text":"View All Legal & Conveyancing Services Solutions","btn_link":"/services?pillar=legal"},{"id":"insurance","icon":"Shield","color":"#db2777","category_tag":"SERVICES: INSURANCE","title":"Insurance","subtitle":"Institutional-Grade Asset Defense & Personal Risk Protection","shortDesc":"Tailored insurance policies safeguarding properties, business operations, key executives, and family security.","bullet_points":["Property & Asset Insurance","Business & Liability Insurance","Personal & Income Protection","Key Person & Partnership Cover"],"btn_text":"View All Insurance Solutions","btn_link":"/services?pillar=insurance"},{"id":"renovation","icon":"Hammer","color":"#ea580c","category_tag":"SERVICES: RENOVATION & TRADE","title":"Renovation & Trade","subtitle":"Turnkey Renovations, Licensed Trades & Property Maintenance","shortDesc":"Vetted building services, licensed trades, full-scale property renovations, and preventative asset maintenance.","bullet_points":["Renovations & Value-Add Upgrades","Licensed Trades & Building Services","Repairs & Emergency Maintenance","Commercial Fitouts & Facility Care"],"btn_text":"View All Renovation & Trade Solutions","btn_link":"/services?pillar=renovation"}]' ); -- --------------------------------------------------------------------- -- 13. Table structure for `frontend_about_hero_settings` (About Page Header / Hero Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_about_hero_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `breadcrumb_parent_text` VARCHAR(255) NOT NULL DEFAULT 'Home', `breadcrumb_parent_link` VARCHAR(255) NOT NULL DEFAULT '/', `breadcrumb_current_text` VARCHAR(255) NOT NULL DEFAULT 'About Us', `badge_text` VARCHAR(255) NOT NULL DEFAULT 'About One Point Alliance', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Australia\'s Connected', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Umbrella Platform', `subtitle` TEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 13. Insert 100% Exact Live About Page Header Content DELETE FROM `frontend_about_hero_settings`; INSERT INTO `frontend_about_hero_settings` ( `id`, `breadcrumb_parent_text`, `breadcrumb_parent_link`, `breadcrumb_current_text`, `badge_text`, `title_main`, `title_highlight`, `subtitle` ) VALUES ( 1, 'Home', '/', 'About Us', 'About One Point Alliance', 'Australia\'s Connected', 'Umbrella Platform', 'One Point Alliance is an integrated services group bringing together premier finance, property, accounting, legal, and risk specialists under one coordinated advisory framework.' ); -- --------------------------------------------------------------------- -- 14. Table structure for `frontend_about_umbrella_settings` (About Umbrella Architecture Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_about_umbrella_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Umbrella Platform Architecture', `title_main` VARCHAR(255) NOT NULL DEFAULT 'About', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'One Point Alliance', `subtitle` TEXT NOT NULL, `problem_badge` VARCHAR(255) NOT NULL DEFAULT 'The Traditional Problem', `problem_heading` VARCHAR(255) NOT NULL DEFAULT 'The Burden of Fragmented Advice', `problem_p1` TEXT NOT NULL, `problem_p2` TEXT NOT NULL, `solution_highlight_label` VARCHAR(255) NOT NULL DEFAULT 'The One Point Solution:', `solution_highlight_text` TEXT NOT NULL, `advantage_badge` VARCHAR(255) NOT NULL DEFAULT 'The Umbrella Advantage', `advantage_heading` VARCHAR(255) NOT NULL DEFAULT 'One Ecosystem. Total Synergy.', `advantage_p1` TEXT NOT NULL, `advantage_p2` TEXT NOT NULL, `stat1_val` VARCHAR(100) NOT NULL DEFAULT '$1.4B+', `stat1_label` VARCHAR(255) NOT NULL DEFAULT 'Client Transactions Coordinated', `stat2_val` VARCHAR(100) NOT NULL DEFAULT '250+', `stat2_label` VARCHAR(255) NOT NULL DEFAULT 'Vetted Alliance Specialists', `banner_title` VARCHAR(255) NOT NULL DEFAULT 'One Point Alliance as the Umbrella Platform', `banner_subtitle` TEXT NOT NULL, `pillars_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 14. Insert 100% Exact Live About Umbrella Architecture Content DELETE FROM `frontend_about_umbrella_settings`; INSERT INTO `frontend_about_umbrella_settings` ( `id`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `problem_badge`, `problem_heading`, `problem_p1`, `problem_p2`, `solution_highlight_label`, `solution_highlight_text`, `advantage_badge`, `advantage_heading`, `advantage_p1`, `advantage_p2`, `stat1_val`, `stat1_label`, `stat2_val`, `stat2_label`, `banner_title`, `banner_subtitle`, `pillars_json` ) VALUES ( 1, 'Umbrella Platform Architecture', 'About', 'One Point Alliance', 'We operate as the overarching umbrella platform that unites independent accredited firms into one synchronized advisory engine.', 'The Traditional Problem', 'The Burden of Fragmented Advice', 'Historically, Australian business owners, home buyers, and property investors have had to deal with separate accountants, independent mortgage brokers, isolated conveyancers, and siloed real estate agents.', 'This fragmentation results in conflicting advice, missed tax benefits, delayed property settlements, and costly blind spots in asset protection.', 'The One Point Solution:', 'One Point Alliance acts as the central coordinating umbrella, aligning every specialist around your balance sheet.', 'The Umbrella Advantage', 'One Ecosystem. Total Synergy.', 'Rather than treating finance, tax, and property as disconnected transactions, One Point Alliance provides a shared strategic infrastructure where all disciplines communicate seamlessly.', 'Clients enjoy a single trusted relationship while gaining immediate access to the collective expertise of Australia’s top licensed practitioners.', '$1.4B+', 'Client Transactions Coordinated', '250+', 'Vetted Alliance Specialists', 'One Point Alliance as the Umbrella Platform', 'One master agreement, zero conflicting advice. Under our umbrella, 5 specialized divisions coordinate in real-time on your behalf:', '[{"name":"Finance & Lending","role":"Mortgages & Commercial Credit"},{"name":"Property Advisory","role":"Advocacy & Acquisitions"},{"name":"Business & Tax","role":"Accounting & Corporate CFO"},{"name":"Legal Counsel","role":"Conveyancing & Contracts"},{"name":"Risk & Insurance","role":"Asset & Business Protection"}]' ); -- --------------------------------------------------------------------- -- 15. Table structure for `frontend_about_vision_settings` (About Page: Vision & Mission Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_about_vision_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `vision_badge` VARCHAR(255) NOT NULL DEFAULT 'Guiding Horizon', `vision_title` VARCHAR(255) NOT NULL DEFAULT 'Our Vision', `vision_desc` TEXT NOT NULL, `vision_tagline` VARCHAR(255) NOT NULL DEFAULT 'Zero Silos • Uncompromising Ethics • Intergenerational Growth', `mission_badge` VARCHAR(255) NOT NULL DEFAULT 'Our Purpose', `mission_title` VARCHAR(255) NOT NULL DEFAULT 'Our Mission', `mission_desc` TEXT NOT NULL, `mission_tagline` VARCHAR(255) NOT NULL DEFAULT 'Client First • Seamless Coordination • Measurable Impact', `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 15. Insert 100% Exact Live About Vision & Mission Content DELETE FROM `frontend_about_vision_settings`; INSERT INTO `frontend_about_vision_settings` ( `id`, `vision_badge`, `vision_title`, `vision_desc`, `vision_tagline`, `mission_badge`, `mission_title`, `mission_desc`, `mission_tagline` ) VALUES ( 1, 'Guiding Horizon', 'Our Vision', 'To be Australasia\'s premier cross-disciplinary alliance, establishing a unified standard where personal and corporate wealth strategies operate in perfect harmony.', 'Zero Silos • Uncompromising Ethics • Intergenerational Growth', 'Our Purpose', 'Our Mission', 'To eliminate the friction between isolated advisors by providing clients a dedicated single point of contact backed by top-tier accredited specialists.', 'Client First • Seamless Coordination • Measurable Impact' -- --------------------------------------------------------------------- -- 16. Table structure for `frontend_about_how_it_works_settings` (About Page: How the Alliance Works Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_about_how_it_works_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Execution Blueprint', `title_main` VARCHAR(255) NOT NULL DEFAULT 'How the', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Alliance Works', `subtitle` TEXT NOT NULL, `steps_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 16. Insert 100% Exact Live About How the Alliance Works Content DELETE FROM `frontend_about_how_it_works_settings`; INSERT INTO `frontend_about_how_it_works_settings` ( `id`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `steps_json` ) VALUES ( 1, 'Execution Blueprint', 'How the', 'Alliance Works', 'From initial holistic diagnosis to synchronized ongoing execution across all areas of your life and business.', -- --------------------------------------------------------------------- -- 17. Table structure for `frontend_about_why_choose_settings` (About Page: Why One Point Alliance Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_about_why_choose_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Strategic Superiority', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Why', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'One Point Alliance', `subtitle` TEXT NOT NULL, `features_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 17. Insert 100% Exact Live About Why One Point Alliance Content DELETE FROM `frontend_about_why_choose_settings`; INSERT INTO `frontend_about_why_choose_settings` ( `id`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `features_json` ) VALUES ( 1, 'Strategic Superiority', 'Why', 'One Point Alliance', 'Why business founders, investors, and Australian families choose our integrated platform over fragmented single-service firms.', -- --------------------------------------------------------------------- -- 18. Table structure for `frontend_about_network_settings` (About Page: Our Professional Network Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_about_network_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Accredited Specialists', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Our', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Professional Network', `subtitle` TEXT NOT NULL, `divisions_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 18. Insert 100% Exact Live About Our Professional Network Content DELETE FROM `frontend_about_network_settings`; INSERT INTO `frontend_about_network_settings` ( `id`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `divisions_json` ) VALUES ( 1, 'Accredited Specialists', 'Our', 'Professional Network', 'A carefully audited network of industry-leading professionals across Australia, all bound by shared service standards and mutual fiduciary dedication.', '[{"title":"Finance & Mortgage Broking","badge":"Credit & Lending","icon":"Landmark","accent":"#059669","bg":"rgba(16, 185, 129, 0.1)","desc":"MFAA and FBAA accredited mortgage brokers and private debt specialists with access to 40+ premier Australian lenders.","points":["Residential & investment home loans","SMSF debt structures & refinancing","Commercial mortgages & private syndication"],"link":"/services?pillar=finance","link_text":"Explore Division Capabilities"},{"title":"Property & Buyer\'s Advocacy","badge":"Acquisition & Portfolio","icon":"Building2","accent":"#b48c1a","bg":"rgba(180, 140, 26, 0.1)","desc":"Licensed buyers\' advocates and real estate advisors representing private clients, first-home buyers, and property investors.","points":["100% independent off-market buying representation","Auction bidding & price negotiation","Property management & asset yield care"],"link":"/services?pillar=property","link_text":"Explore Division Capabilities"},{"title":"Business & Corporate Advisory","badge":"Accounting & Tax","icon":"Calculator","accent":"#2563eb","bg":"rgba(37, 99, 235, 0.1)","desc":"Chartered Accountants (CA ANZ / CPA) providing corporate tax structuring, CFO services, bookkeeping, and growth advisory.","points":["Tax minimisation & trust structuring","Virtual CFO & payroll governance","Cashflow optimization & entity establishment"],"link":"/services?pillar=accounting","link_text":"Explore Division Capabilities"},{"title":"Legal & Conveyancing","badge":"Statutory & Contracts","icon":"Scale","accent":"#9333ea","bg":"rgba(147, 51, 234, 0.1)","desc":"Practising solicitors, commercial barristers, and PEXA-certified conveyancers ensuring rock-solid contracts and seamless settlements.","points":["Contract of sale & Section 32 reviews","PEXA electronic settlement guarantee","Commercial agreements, wills & estate planning"],"link":"/services?pillar=legal","link_text":"Explore Division Capabilities"},{"title":"Asset & Personal Insurance","badge":"Risk Defense","icon":"Shield","accent":"#db2777","bg":"rgba(219, 39, 119, 0.1)","desc":"NIBA accredited risk advisors providing institutional-grade insurance shielding your family, commercial properties, and enterprises.","points":["Building, landlord & commercial property cover","Key person, life, TPD & income defense","D&O and professional indemnity solutions"],"link":"/services?pillar=insurance","link_text":"Explore Division Capabilities"},{"title":"Strategic Wealth & General Advisory","badge":"Holistic Direction","icon":"Compass","accent":"#d97706","bg":"rgba(217, 119, 6, 0.1)","desc":"Senior Alliance Directors who orchestrate all disciplines into a single synchronized wealth roadmap.","points":["Cross-pillar portfolio diagnostics","Dedicated single point of contact","Ongoing quarterly wealth synchronization"],"link":"/services","link_text":"Explore Division Capabilities"}]' ); -- --------------------------------------------------------------------- -- 19. Table structure for `frontend_service_hero_settings` (Services Page: Hero & Multi-Service Advantage) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_service_hero_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `breadcrumb_parent_text` VARCHAR(255) NOT NULL DEFAULT 'Home', `breadcrumb_parent_link` VARCHAR(255) NOT NULL DEFAULT '/', `breadcrumb_current_text` VARCHAR(255) NOT NULL DEFAULT 'Services Architecture', `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Multi-Service Architecture', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Our', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Six Service Divisions', `subtitle` TEXT NOT NULL, `advantage_title` VARCHAR(255) NOT NULL DEFAULT 'The Multi-Service Advantage', `advantage_desc` TEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 19. Insert 100% Exact Live Services Page Header & Advantage Content DELETE FROM `frontend_service_hero_settings`; INSERT INTO `frontend_service_hero_settings` ( `id`, `breadcrumb_parent_text`, `breadcrumb_parent_link`, `breadcrumb_current_text`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `advantage_title`, `advantage_desc` ) VALUES ( 1, 'Home', '/', 'Services Architecture', 'Multi-Service Architecture', 'Our', 'Six Service Divisions', 'Access finance, property, accounting, legal, insurance, and renovation services through one connected alliance.', 'The Multi-Service Advantage', 'Instead of navigating disconnected professionals who operate in silos, One Point Alliance delivers an integrated multi-service framework. When you purchase a property, arrange a mortgage, set up a company, or renovate an asset, our accredited divisions collaborate under one unified governance model. This eliminates conflicting advice, accelerates execution, and protects your bottom line.' ); -- --------------------------------------------------------------------- -- 20. Table structure for `frontend_service_matrix_settings` (Services Page: Core Division Matrix Table) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_service_matrix_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Core Division Matrix', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Overview of the', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Six Divisions', `subtitle` TEXT NOT NULL, `col1_title` VARCHAR(255) NOT NULL DEFAULT 'Service Division', `col2_title` VARCHAR(255) NOT NULL DEFAULT 'Main Focus', `col3_title` VARCHAR(255) NOT NULL DEFAULT 'Explore Division', `matrix_rows_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 20. Insert 100% Exact Live Core Division Matrix Content DELETE FROM `frontend_service_matrix_settings`; INSERT INTO `frontend_service_matrix_settings` ( `id`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `col1_title`, `col2_title`, `col3_title`, `matrix_rows_json` ) VALUES ( 1, 'Core Division Matrix', 'Overview of the', 'Six Divisions', 'Explore each specialized division and its dedicated scope of capabilities:', 'Service Division', 'Main Focus', 'Explore Division', '[{"id":"finance","title":"Finance & Mortgage","mainFocus":"Home, investment, commercial and personal finance","buttonText":"View Capabilities","icon":"Landmark","color":"#059669"},{"id":"property","title":"Property & Real Estate","mainFocus":"Residential, commercial, construction, investment, management, advisory","buttonText":"View Capabilities","icon":"Building2","color":"#b48c1a"},{"id":"accounting","title":"Accounting & Business Advisory","mainFocus":"Accounting, tax, business setup and growth","buttonText":"View Capabilities","icon":"Calculator","color":"#2563eb"},{"id":"legal","title":"Legal & Conveyancing Services","mainFocus":"Property, business and conveyancing legal support","buttonText":"View Capabilities","icon":"Scale","color":"#9333ea"},{"id":"insurance","title":"Insurance","mainFocus":"Property, business, personal and risk protection","buttonText":"View Capabilities","icon":"Shield","color":"#db2777"},{"id":"renovation","title":"Renovation & Trade","mainFocus":"Renovations, repairs, trades, building services, maintenance","buttonText":"View Capabilities","icon":"Hammer","color":"#ea580c"}]' ); -- --------------------------------------------------------------------- -- 21. Table structure for `frontend_service_capabilities_settings` (Services Page: Detailed Division Capabilities) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_service_capabilities_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Detailed Capabilities', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Comprehensive', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Division Capabilities', `subtitle` TEXT NOT NULL, `all_filter_label` VARCHAR(255) NOT NULL DEFAULT 'All Six Divisions', `cta_button_text` VARCHAR(255) NOT NULL DEFAULT 'Book a Consultation', `pillars_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 21. Insert 100% Exact Live Detailed Division Capabilities Content DELETE FROM `frontend_service_capabilities_settings`; INSERT INTO `frontend_service_capabilities_settings` ( `id`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `all_filter_label`, `cta_button_text`, `pillars_json` ) VALUES ( 1, 'Detailed Capabilities', 'Comprehensive', 'Division Capabilities', 'Filter by specific division or explore the complete end-to-end scope:', 'All Six Divisions', 'Book a Consultation', '[{"id":"finance","title":"Finance & Mortgage","subtitle":"Bespoke Lending & Capital Solutions Across 40+ Premier Lenders","shortDesc":"Comprehensive residential, commercial, investment, and personal finance structuring tailored to your cashflow.","color":"#059669","icon":"Landmark","subServices":[{"id":"fin-home-loans","name":"Home Loans","summary":"","features":["Home loans for first-home buyers, upgraders and investors, compared across a panel of lenders."]},{"id":"fin-refinancing-investment","name":"Refinancing & Investment Loans","summary":"","features":["Refinancing reviews to check whether your current loan still suits you.","Investment, car and personal loans through one adviser."]},{"id":"fin-settlement-support","name":"Support & Settlement","summary":"","features":["Support from application through to settlement, with clear updates along the way.","Benefit: your lender, lawyer and agent can work to the same timeline, so there are fewer delays at settlement."]}]},{"id":"property","title":"Property & Real Estate","subtitle":"High-Yield Acquisition, Strategic Development & Turnkey Management","shortDesc":"End-to-end real estate advisory covering residential, commercial, construction, investment, and complete asset management.","color":"#b48c1a","icon":"Building2","subServices":[{"id":"prop-residential","name":"Residential & Buyers Advocacy","summary":"100% independent representation to locate, evaluate, and negotiate off-market and on-market homes.","features":["Independent due diligence & valuation","Auction bidding & price negotiation","Off-market private vendor access","First-home and family buying support"]},{"id":"prop-investment-adv","name":"Investment & Advisory","summary":"Data-driven property portfolio modeling, capital growth zone mapping, and yield maximization.","features":["Sub-market demographic growth analysis","Cashflow & capital yield forecasting","Strategic portfolio expansion mapping","Risk assessment & exit planning"]},{"id":"prop-commercial-const","name":"Commercial & Construction","summary":"Acquisition, site feasibility, and transaction management for commercial assets and new builds.","features":["Commercial property acquisitions","Development site feasibility studies","Builder vetting & contract advisory","Project handover inspection coordination"]},{"id":"prop-management","name":"Property & Asset Management","summary":"Executive-grade property care, tenant vetting, and yield optimization protecting physical wealth.","features":["Zero-tolerance rent arrears protocol","Routine 3D digital condition reports","Preventative maintenance network","Annual market rental reviews"]}]},{"id":"accounting","title":"Accounting & Business Advisory","subtitle":"Strategic Tax Minimization, Business Setup & Corporate CFO Advisory","shortDesc":"Comprehensive accounting, tax structuring, entity establishment, and strategic advisory designed to protect and scale enterprises.","color":"#2563eb","icon":"Calculator","subServices":[{"id":"acc-tax","name":"Accounting & Tax Compliance","summary":"Proactive compliance and sophisticated tax planning for business founders, investors, and family trusts.","features":["Annual tax strategy & restructuring","Capital Gains Tax (CGT) minimization","Family trust & corporate beneficiary setups","ATO compliance & audit protection"]},{"id":"acc-setup","name":"Business Setup & Structuring","summary":"Turnkey entity formation, company registrations, partnership agreements, and asset-shielding frameworks.","features":["Company, trust & partnership incorporation","ABN, TFN, GST & PAYG registrations","Shareholder agreement alignment","Asset protection structure reviews"]},{"id":"acc-bas-bookkeeping","name":"Cloud Bookkeeping & BAS","summary":"Automated cloud accounting keeping financials audit-ready, organized, and cashflows predictable.","features":["Xero / QuickBooks / MYOB integration","Monthly & quarterly BAS/IAS lodgements","Single Touch Payroll (STP) management","Real-time management accounts"]},{"id":"acc-growth-cfo","name":"Business Growth & CFO Advisory","summary":"Virtual CFO leadership helping scale valuations, financial runways, and exit readiness.","features":["Virtual CFO retained advisory","Cashflow runway & scenario stress-testing","KPI dashboard & financial modeling","M&A valuation & succession planning"]}]},{"id":"legal","title":"Legal & Conveyancing Services","subtitle":"Conveyancing Precision & Robust Commercial Legal Counsel","shortDesc":"Precision legal representation covering property transfers, commercial agreements, and business compliance.","color":"#9333ea","icon":"Scale","subServices":[{"id":"leg-conveyancing","name":"Property Conveyancing","summary":"Frictionless, accurate title transfers and contract reviews for residential and commercial purchases.","features":["Pre-auction contract reviews within 24h","Section 32 & vendor statement drafting","PEXA electronic settlement execution","Off-the-plan contract negotiation"]},{"id":"leg-business","name":"Business & Commercial Law","summary":"Rock-solid legal protection for contracts, partnerships, employment, and commercial transactions.","features":["Shareholder & partnership agreements","Commercial contracts & NDAs","Terms of trade & supplier agreements","Commercial dispute resolution"]},{"id":"leg-property-legal","name":"Property Legal & Leasing","summary":"Comprehensive legal counsel for commercial leasing, easements, caveats, and joint ventures.","features":["Retail & commercial lease drafting","Property joint venture structuring","Subdivision legal documentation","Caveat & title encumbrance counsel"]},{"id":"leg-estate","name":"Estate & Succession Planning","summary":"Protecting generational legacy through wills, testamentary trusts, and enduring powers of attorney.","features":["Testamentary trust wills","Enduring powers of attorney (Financial & Medical)","Business succession deeds","Asset shielding for beneficiaries"]}]},{"id":"insurance","title":"Insurance","subtitle":"Institutional-Grade Asset Defense & Personal Risk Protection","shortDesc":"Tailored insurance policies safeguarding properties, business operations, key executives, and family security.","color":"#db2777","icon":"Shield","subServices":[{"id":"ins-property","name":"Property & Asset Insurance","summary":"Comprehensive coverage protecting residential homes, investment properties, and commercial premises.","features":["Building & high-value contents cover","Landlord rent default & tenant damage","Commercial strata & building insurance","Natural perils, flood & storm coverage"]},{"id":"ins-business","name":"Business & Liability Insurance","summary":"Shielding your enterprise from commercial claims, executive liability, and operational exposures.","features":["Public & products liability insurance","Professional indemnity coverage","Directors & Officers (D&O) liability","Cyber risk & business interruption cover"]},{"id":"ins-personal","name":"Personal & Income Protection","summary":"Protecting your family\'s lifestyle and income against unforeseen health, trauma, or life events.","features":["Income protection insurance","Life & terminal illness cover","Total & Permanent Disability (TPD)","Trauma & critical illness defense"]},{"id":"ins-keyperson","name":"Key Person & Partnership Cover","summary":"Ensuring business continuity and funding buy-sell agreements if a partner suffers illness or death.","features":["Key person capital & revenue protection","Buy/sell agreement insurance funding","Business expenses insurance","Corporate continuity planning"]}]},{"id":"renovation","title":"Renovation & Trade","subtitle":"Turnkey Renovations, Licensed Trades & Property Maintenance","shortDesc":"Vetted building services, licensed trades, full-scale property renovations, and preventative asset maintenance.","color":"#ea580c","icon":"Hammer","subServices":[{"id":"reno-full","name":"Renovations & Value-Add Upgrades","summary":"Strategic kitchen, bathroom, and full-property makeovers designed to maximize rental yields and capital value.","features":["Kitchen & bathroom transformations","Interior reconfigurations & extensions","Value-add pre-sale cosmetic upgrades","Fixed-price project management"]},{"id":"reno-trades","name":"Licensed Trades & Building Services","summary":"Audited network of master electricians, certified plumbers, carpenters, and registered builders.","features":["Master electricians & rewiring","Licensed plumbing & gas fitting","Carpentry, plastering & structural work","Fully insured & compliance-certified trades"]},{"id":"reno-repairs","name":"Repairs & Emergency Maintenance","summary":"Rapid-response property repairs, water damage remediation, and preventative maintenance.","features":["Rapid-response urgent repairs","Roofing, guttering & leak repairs","Locksmith & security upgrades","Routine rental inspection defect fixes"]},{"id":"reno-commercial","name":"Commercial Fitouts & Facility Care","summary":"Office make-goods, commercial retail fitouts, and ongoing facility maintenance programs.","features":["Office & retail commercial fitouts","Commercial lease make-good obligations","Scheduled preventative facility care","WHS and safety compliance audits"]}]}]' ); -- --------------------------------------------------------------------- -- 25. Table structure for `frontend_partners_hero_settings` (Partners Page: Hero & Header Banner) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_partners_hero_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `breadcrumb_parent_text` VARCHAR(255) NOT NULL DEFAULT 'Home', `breadcrumb_parent_link` VARCHAR(255) NOT NULL DEFAULT '/', `breadcrumb_current_text` VARCHAR(255) NOT NULL DEFAULT 'Partners & Accreditation', `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Top 1% Accredited Advisory Network', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Partner with', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'OnePoint Alliance', `subtitle` TEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 25. Insert 100% Exact Live Partners Page Header Content DELETE FROM `frontend_partners_hero_settings`; INSERT INTO `frontend_partners_hero_settings` ( `id`, `breadcrumb_parent_text`, `breadcrumb_parent_link`, `breadcrumb_current_text`, `badge_text`, `title_main`, `title_highlight`, `subtitle` ) VALUES ( 1, 'Home', '/', 'Partners & Accreditation', 'Top 1% Accredited Advisory Network', 'Partner with', 'OnePoint Alliance', 'Join Australia\'s premier multi-disciplinary network. Collaborate with the top 1% of accredited brokers, CPAs, conveyancers, and property advocates to access high-intent cross-referrals and deliver synchronized client outcomes.' ); -- --------------------------------------------------------------------- -- 26. Table structure for `frontend_partners_advantage_settings` (Partners Page: Alliance Advantage Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_partners_advantage_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Alliance Advantage', `title` VARCHAR(255) NOT NULL DEFAULT 'Why Top Practices Join the Alliance', `subtitle` TEXT NOT NULL, `benefits_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 26. Insert 100% Exact Live Partners Page Alliance Advantage Content DELETE FROM `frontend_partners_advantage_settings`; INSERT INTO `frontend_partners_advantage_settings` ( `id`, `badge_text`, `title`, `subtitle`, `benefits_json` ) VALUES ( 1, 'Alliance Advantage', 'Why Top Practices Join the Alliance', 'Accelerate your practice growth with pre-screened clients, cross-pillar synergy, and shared infrastructure.', '[{"icon":"Target","title":"Qualified Cross-Pillar Referrals","description":"Receive pre-screened clients actively seeking your specific specialty."},{"icon":"Share2","title":"Shared Digital Deal Room","description":"Collaborate with Alliance partners in real-time, expediting multi-service settlements."},{"icon":"Megaphone","title":"Co-Branded Marketing & Events","description":"Gain exposure through our high-converting podcasts, executive roundtables, and webinars."},{"icon":"CheckCircle2","title":"Alliance Accreditation Badge","description":"Display the recognized OnePoint seal of trust, signaling elite vetting and peer endorsement."}]' ); -- --------------------------------------------------------------------- -- 27. Table structure for `frontend_partners_apply_settings` (Partners Page: Application Portal & Standards) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_partners_apply_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Accreditation Portal', `title` VARCHAR(255) NOT NULL DEFAULT 'Apply for Alliance Membership', `description` TEXT NOT NULL, `criteria_title` VARCHAR(255) NOT NULL DEFAULT 'Accreditation Standards:', `criteria_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 27. Insert 100% Exact Live Partners Page Application & Standards Content DELETE FROM `frontend_partners_apply_settings`; INSERT INTO `frontend_partners_apply_settings` ( `id`, `badge_text`, `title`, `description`, `criteria_title`, `criteria_json` ) VALUES ( 1, 'Accreditation Portal', 'Apply for Alliance Membership', 'We accept licensed, ethical, and high-performing advisory practices across Property, Finance, Accounting, Legal, and Insurance.', 'Accreditation Standards:', '["Current Australian regulatory license (AFSL, ACL, CPA/CA, Law Society)","Minimum 3+ years active operating history with a clean compliance record","Strict commitment to 24h client response SLAs","Verifiable 4.8+ client satisfaction rating"]' ); -- --------------------------------------------------------------------- -- 30. Table structure for `frontend_contact_hero_settings` (Contact Page: Hero & Header Banner) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_contact_hero_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `breadcrumb_parent_text` VARCHAR(255) NOT NULL DEFAULT 'Home', `breadcrumb_parent_link` VARCHAR(255) NOT NULL DEFAULT '/', `breadcrumb_current_text` VARCHAR(255) NOT NULL DEFAULT 'Contact', `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Executive Alliance Desks', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Connect With', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'One Point Alliance', `subtitle` TEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 30. Insert 100% Exact Live Contact Page Header Content DELETE FROM `frontend_contact_hero_settings`; INSERT INTO `frontend_contact_hero_settings` ( `id`, `breadcrumb_parent_text`, `breadcrumb_parent_link`, `breadcrumb_current_text`, `badge_text`, `title_main`, `title_highlight`, `subtitle` ) VALUES ( 1, 'Home', '/', 'Contact', 'Executive Alliance Desks', 'Connect With', 'One Point Alliance', 'Reach our national headquarters, request an executive call-back, locate an interstate alliance desk, or submit a general inquiry.' ); -- --------------------------------------------------------------------- -- 31. Table structure for `frontend_contact_info_settings` (Contact Page: Executive Office & Form Settings) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_contact_info_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `tab_contact_us` VARCHAR(255) NOT NULL DEFAULT 'Contact Us', `tab_request_call` VARCHAR(255) NOT NULL DEFAULT 'Request a Call', `tab_locations` VARCHAR(255) NOT NULL DEFAULT 'Locations', `tab_general_enquiry` VARCHAR(255) NOT NULL DEFAULT 'General Enquiry', `hq_badge` VARCHAR(255) NOT NULL DEFAULT 'National Executive Headquarters', `hq_title` VARCHAR(255) NOT NULL DEFAULT 'Executive Alliance Office', `hq_description` TEXT NOT NULL, `divisions_title` VARCHAR(255) NOT NULL DEFAULT 'Six Service Divisions Coordinated:', `divisions_json` LONGTEXT NOT NULL, `phone_label` VARCHAR(255) NOT NULL DEFAULT 'Alliance Toll-Free Helpline:', `phone_val` VARCHAR(255) NOT NULL DEFAULT '0404 423 111', `phone_direct` VARCHAR(255) NOT NULL DEFAULT 'Direct: 0404 423 111', `email_label` VARCHAR(255) NOT NULL DEFAULT 'Strategic Advisory Inquiries:', `email_val` VARCHAR(255) NOT NULL DEFAULT 'advisory@onepointalliance.com.au', `address_label` VARCHAR(255) NOT NULL DEFAULT 'Principal Office:', `address_val` TEXT NOT NULL, `hours_label` VARCHAR(255) NOT NULL DEFAULT 'Operating Hours:', `hours_val` VARCHAR(255) NOT NULL DEFAULT 'Monday - Friday: 8:30 AM - 6:00 PM AEST', `sla_title` VARCHAR(255) NOT NULL DEFAULT 'Guaranteed Response SLA', `sla_description` TEXT NOT NULL, `form_title_contact` VARCHAR(255) NOT NULL DEFAULT 'Send an Executive Message', `form_title_general` VARCHAR(255) NOT NULL DEFAULT 'Submit a General Enquiry', `form_title_call` VARCHAR(255) NOT NULL DEFAULT 'Request an Advisory Call', `form_subtitle` TEXT NOT NULL, `form_btn_text` VARCHAR(255) NOT NULL DEFAULT 'Submit Inquiry', `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 31. Insert 100% Exact Live Contact Page Office Info & Form Details DELETE FROM `frontend_contact_info_settings`; INSERT INTO `frontend_contact_info_settings` ( `id`, `tab_contact_us`, `tab_request_call`, `tab_locations`, `tab_general_enquiry`, `hq_badge`, `hq_title`, `hq_description`, `divisions_title`, `divisions_json`, `phone_label`, `phone_val`, `phone_direct`, `email_label`, `email_val`, `address_label`, `address_val`, `hours_label`, `hours_val`, `sla_title`, `sla_description`, `form_title_contact`, `form_title_general`, `form_title_call`, `form_subtitle`, `form_btn_text` ) VALUES ( 1, 'Contact Us', 'Request a Call', 'Locations', 'General Enquiry', 'National Executive Headquarters', 'Executive Alliance Office', 'Our central operations coordinate accredited partners and client transactions across Sydney, Melbourne, Brisbane, Perth, and Adelaide.', 'Six Service Divisions Coordinated:', '["Finance & Mortgage","Property & Real Estate","Accounting & Business Advisory","Legal & Conveyancing Services","Insurance","Renovation & Trade"]', 'Alliance Toll-Free Helpline:', '0404 423 111', 'Direct: 0404 423 111', 'Strategic Advisory Inquiries:', 'advisory@onepointalliance.com.au', 'Principal Office:', 'Level 38, International Towers, Barangaroo NSW 2000, Australia', 'Operating Hours:', 'Monday - Friday: 8:30 AM - 6:00 PM AEST', 'Guaranteed Response SLA', 'Direct advisory inquiries are responded to within 2 business hours.', 'Send an Executive Message', 'Submit a General Enquiry', 'Request an Advisory Call', 'Complete the details below and our coordinator will connect you with the appropriate accredited director.', 'Submit Inquiry' ); -- --------------------------------------------------------------------- -- 32. Table structure for `frontend_contact_locations_settings` (Contact Page: Alliance Office Locations Cards & Header) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_contact_locations_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'National Footprint', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Alliance', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Office Locations', `subtitle` TEXT NOT NULL, `desks_title` VARCHAR(255) NOT NULL DEFAULT 'Key Desks Present:', `locations_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP -- --------------------------------------------------------------------- -- 33. Table structure for `frontend_site_settings` (Global Site Branding, Logos, SEO Meta Tags & Scripts) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_site_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `site_name` VARCHAR(150) NOT NULL DEFAULT 'One Point Alliance', `logo_url` TEXT DEFAULT NULL, `logo_dark_url` TEXT DEFAULT NULL, `logo_width` VARCHAR(20) NOT NULL DEFAULT '220', `logo_height` VARCHAR(20) NOT NULL DEFAULT '48', `logo_alt_text` VARCHAR(255) NOT NULL DEFAULT 'One Point Alliance - Multi-Disciplinary Advisory', `favicon_url` TEXT DEFAULT NULL, `apple_touch_icon_url` TEXT DEFAULT NULL, `site_title` VARCHAR(255) NOT NULL DEFAULT 'One Point Alliance | Multi-Disciplinary Advisory Ecosystem', `site_tagline` VARCHAR(255) NOT NULL DEFAULT 'Institutional-Grade Wealth, Property, Legal & Accounting Solutions', `meta_description` TEXT NOT NULL, `meta_keywords` TEXT NOT NULL, `meta_author` VARCHAR(150) NOT NULL DEFAULT 'One Point Alliance', `meta_robots` VARCHAR(100) NOT NULL DEFAULT 'index, follow', `canonical_url` VARCHAR(255) NOT NULL DEFAULT 'https://onepointalliance.com.au', `og_title` VARCHAR(255) NOT NULL DEFAULT 'One Point Alliance | Australia\'s Premier Private Advisory Alliance', `og_description` TEXT NOT NULL, `og_image_url` TEXT DEFAULT NULL, `twitter_card` VARCHAR(50) NOT NULL DEFAULT 'summary_large_image', `twitter_site` VARCHAR(100) NOT NULL DEFAULT '@OnePointAlliance', `header_scripts` TEXT DEFAULT NULL, `footer_scripts` TEXT DEFAULT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 33. Insert Default Site Settings DELETE FROM `frontend_site_settings`; INSERT INTO `frontend_site_settings` ( `id`, `site_name`, `logo_url`, `logo_dark_url`, `logo_width`, `logo_height`, `logo_alt_text`, `favicon_url`, `apple_touch_icon_url`, `site_title`, `site_tagline`, `meta_description`, `meta_keywords`, `meta_author`, `meta_robots`, `canonical_url`, `og_title`, `og_description`, `og_image_url`, `twitter_card`, `twitter_site` ) VALUES ( 1, 'One Point Alliance', '', '', '220', '48', 'One Point Alliance - Multi-Disciplinary Advisory', '', '', 'One Point Alliance | Multi-Disciplinary Advisory Ecosystem', 'Institutional-Grade Wealth, Property, Legal & Accounting Solutions', 'One Point Alliance orchestrates high-performance multi-disciplinary advisory across finance, property acquisition, tax accounting, commercial legal counsel, and asset protection.', 'multi-disciplinary advisory, private wealth australia, mortgage broker sydney, commercial legal counsel, property buyer advocate, tax accounting, asset protection', 'One Point Alliance Pty Ltd', 'index, follow', 'https://onepointalliance.com.au', 'One Point Alliance | Australia\'s Premier Private Advisory Alliance', 'Australia\'s premier multi-disciplinary advisory ecosystem. Single point of governance for finance, property, accounting, and legal.', '', 'summary_large_image', '@OnePointAlliance' ); -- --------------------------------------------------------------------- -- 34. Table structure for `frontend_footer_settings` (Global Footer & Legal Customization) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_footer_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `cta_badge_text` VARCHAR(255) NOT NULL DEFAULT 'Cross-Pillar Synergy', `cta_heading` VARCHAR(255) NOT NULL DEFAULT 'Speak with a Senior Alliance Director', `cta_description` TEXT NOT NULL, `cta_btn_text` VARCHAR(150) NOT NULL DEFAULT 'Book Strategic Discovery Session', `brand_mission` TEXT NOT NULL, `phone_label` VARCHAR(150) NOT NULL DEFAULT 'National Advisory Helpline', `phone_val` VARCHAR(100) NOT NULL DEFAULT '0404 423 111', `email_label` VARCHAR(150) NOT NULL DEFAULT 'Strategic Inquiries', `email_val` VARCHAR(150) NOT NULL DEFAULT 'advisory@onepointalliance.com.au', `headquarters_label` VARCHAR(150) NOT NULL DEFAULT 'Headquarters', `headquarters_val` VARCHAR(255) NOT NULL DEFAULT 'Level 28, Tower One, Barangaroo NSW', `accreditations_tags` TEXT NOT NULL, `divisions_heading` VARCHAR(150) NOT NULL DEFAULT 'The 6 Core Divisions', `divisions_links_json` LONGTEXT NOT NULL, `divisions_highlight_text` VARCHAR(255) NOT NULL DEFAULT 'Explore Complete Services Matrix', `divisions_highlight_link` VARCHAR(255) NOT NULL DEFAULT '/services', `legal_heading` VARCHAR(150) NOT NULL DEFAULT 'Legal', `legal_links_json` LONGTEXT NOT NULL, `contact_heading` VARCHAR(150) NOT NULL DEFAULT 'Contact & Desks', `contact_links_json` LONGTEXT NOT NULL, `newsletter_title` VARCHAR(150) NOT NULL DEFAULT 'Alliance Market Brief', `newsletter_desc` TEXT NOT NULL, `newsletter_placeholder` VARCHAR(150) NOT NULL DEFAULT 'Enter executive email...', `regulatory_text` TEXT NOT NULL, `copyright_text` VARCHAR(255) NOT NULL DEFAULT '© {year} ONE POINT ALLIANCE. All Rights Reserved. One Network. Multiple Solutions.', `bottom_links_json` LONGTEXT NOT NULL, `back_to_top_text` VARCHAR(100) NOT NULL DEFAULT 'Back to top', `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 34. Insert Default Live Footer Content DELETE FROM `frontend_footer_settings`; INSERT INTO `frontend_footer_settings` ( `id`, `cta_badge_text`, `cta_heading`, `cta_description`, `cta_btn_text`, `brand_mission`, `phone_label`, `phone_val`, `email_label`, `email_val`, `headquarters_label`, `headquarters_val`, `accreditations_tags`, `divisions_heading`, `divisions_links_json`, `divisions_highlight_text`, `divisions_highlight_link`, `legal_heading`, `legal_links_json`, `contact_heading`, `contact_links_json`, `newsletter_title`, `newsletter_desc`, `newsletter_placeholder`, `regulatory_text`, `copyright_text`, `bottom_links_json`, `back_to_top_text` ) VALUES ( 1, 'Cross-Pillar Synergy', 'Speak with a Senior Alliance Director', 'Stop managing disparate advisors. Speak with a Senior Alliance Director today and align your property, finance, tax, and legal frameworks under one synchronized blueprint.', 'Book Strategic Discovery Session', 'Australia\'s premier multi-disciplinary advisory alliance. We coordinate top 1% accredited brokers, CPAs, conveyancers, and buyer\'s advocates under one synchronized strategic blueprint.', 'National Advisory Helpline', '0404 423 111', 'Strategic Inquiries', 'advisory@onepointalliance.com.au', 'Headquarters', 'Level 28, Tower One, Barangaroo NSW', 'MFAA, CA ANZ, REBAA, Law Society NSW', 'The 6 Core Divisions', '[{"name":"Finance & Mortgage","url":"/services?pillar=finance"},{"name":"Property & Real Estate","url":"/services?pillar=property"},{"name":"Accounting & Business Advisory","url":"/services?pillar=accounting"},{"name":"Legal & Conveyancing Services","url":"/services?pillar=legal"},{"name":"Insurance Protection","url":"/services?pillar=insurance"},{"name":"Renovation & Trade","url":"/services?pillar=renovation"}]', 'Explore Complete Services Matrix', '/services', 'Legal', '[{"name":"Privacy Policy","url":"/resources?tab=legal#privacy"},{"name":"Terms & Conditions","url":"/resources?tab=legal#terms"},{"name":"Disclaimer","url":"/resources?tab=legal#disclaimer"},{"name":"Complaints","url":"/resources?tab=legal#complaints"},{"name":"Regulatory Information","url":"/resources?tab=legal#regulatory"}]', 'Contact & Desks', '[{"name":"Contact Us (Headquarters)","url":"/contact?tab=contact-us"},{"name":"Request a Call","url":"/contact?tab=request-call"},{"name":"Locations (Sydney, Melb, QLD, WA)","url":"/contact?tab=locations"},{"name":"General Enquiry","url":"/contact?tab=general-enquiry"}]', 'Alliance Market Brief', 'Quarterly insights on lending rates, tax structures, and off-market property.', 'Enter executive email...', 'Regulatory Disclaimer: One Point Alliance is a multi-disciplinary advisory network. Financial, mortgage broking, accounting, and legal services are provided exclusively by independently licensed and accredited alliance partners holding appropriate Australian Financial Services Licences (AFSL), Australian Credit Licences (ACL), CA ANZ/CPA registrations, or State Legal Practice certificates.', '© {year} ONE POINT ALLIANCE. All Rights Reserved. One Network. Multiple Solutions.', '[{"name":"Privacy Policy","url":"/resources?tab=legal"},{"name":"Terms of Engagement","url":"/resources?tab=legal"},{"name":"Credit Guide","url":"/resources?tab=legal"}]', 'Back to top' ); -- --------------------------------------------------------------------- -- 35. Table structure for `frontend_service_life_living_settings` (Services Page: Life & Living Section) -- --------------------------------------------------------------------- CREATE TABLE IF NOT EXISTS `frontend_service_life_living_settings` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `badge_text` VARCHAR(255) NOT NULL DEFAULT 'Lifestyle & Personal Empowerment', `title_main` VARCHAR(255) NOT NULL DEFAULT 'Life &', `title_highlight` VARCHAR(255) NOT NULL DEFAULT 'Living', `subtitle` TEXT NOT NULL, `cards_json` LONGTEXT NOT NULL, `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 35. Insert Default Live Services Life & Living Content DELETE FROM `frontend_service_life_living_settings`; INSERT INTO `frontend_service_life_living_settings` ( `id`, `badge_text`, `title_main`, `title_highlight`, `subtitle`, `cards_json` ) VALUES ( 1, 'Lifestyle & Personal Empowerment', 'Life &', 'Living', 'Holistic lifestyle advisory, personal growth, driver education, and premium vehicle concierge services tailored to elevate every dimension of your journey.', '[{"id":"buy-a-car","title":"Buy a Car","badge":"Vehicle Concierge & Auto Finance","color":"#0284c7","icon":"Car","summary":"End-to-end vehicle sourcing, dealer price negotiation, novated leasing, and pre-approved low-rate asset finance.","features":["Wholesale fleet & private dealership sourcing","Pre-approved asset finance & low-rate vehicle loans","Novated lease & business tax optimization","Independent vehicle inspection & delivery setup"],"buttonText":"Consult on Vehicle Sourcing"},{"id":"driving-instructor","title":"Driving Instructor","badge":"Accredited Driver Training","color":"#b48c1a","icon":"GraduationCap","summary":"Certified, dual-controlled driver education for learner drivers, international license conversions, and defensive road mastery.","features":["Victoria’s accredited professional instructors.","Dual-control modern automatic & manual vehicles","Defensive driving & test route mock assessments","Flexible door-to-door lesson scheduling"],"buttonText":"Book Driver Instruction"},{"id":"wellbeing","title":"Wellbeing & Vitality","badge":"Holistic Health & Vitality","color":"#059669","icon":"HeartPulse","summary":"Executive health programs, mental resilience, preventative wellness frameworks, and nutrition guidance for balanced living.","features":["Confidential executive mental resilience coaching","Personalized vitality & preventative wellness plans","Workplace ergonomics & stress management","Nutritional counseling & lifestyle optimization"],"buttonText":"Explore Wellbeing Programs"},{"id":"empowering","title":"Empowering & Growth","badge":"Personal Leadership & Mentorship","color":"#7c3aed","icon":"Zap","summary":"Strategic personal development, high-performance coaching, career transitions, and personal leadership empowerment.","features":["1-on-1 strategic leadership & career acceleration","Financial confidence & wealth empowerment workshops","Goal mastery & life purpose realignment","Confidence building & public presentation coaching"],"buttonText":"Discover Empowerment Coaching"}]' );