-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 05, 2025 at 09:13 PM
-- Server version: 5.7.23-23
-- PHP Version: 8.1.32

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `pnoacamy_demo_test`
--

-- --------------------------------------------------------

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` int(11) NOT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `username`, `password`) VALUES
(1, 'admin', '$2y$10$Bo60NROuHbKlMfhnxXBk4uqOxkd1rFQOzgFytl91n/ERJ1tJuefzW'),
(2, 'edkeyte', '$2y$10$t73BdOlSiG3G3OiH7YNs7.gVFUhLLzKm6rLAYFoPXW9.imghn2bna');

-- --------------------------------------------------------

--
-- Table structure for table `ai_usage_log`
--

CREATE TABLE `ai_usage_log` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `used_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ai_usage_log`
--

INSERT INTO `ai_usage_log` (`id`, `user_id`, `used_at`) VALUES
(1, 2, '2025-06-29 16:32:57');

-- --------------------------------------------------------

--
-- Table structure for table `branding`
--

CREATE TABLE `branding` (
  `id` int(11) NOT NULL,
  `background_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `logo_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `openai_api_key` text COLLATE utf8_unicode_ci,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subtitle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `facebook_group_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `brand_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'MLM Lead Pro',
  `bridge_video_url` text COLLATE utf8_unicode_ci,
  `footer_note` text COLLATE utf8_unicode_ci,
  `default_leadsleap_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_share_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `theme_stylesheet` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'theme-orange.css',
  `license_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `open_graph_image` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `share_code_leads` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `share_code_referrals` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `branding`
--

INSERT INTO `branding` (`id`, `background_image`, `logo_image`, `openai_api_key`, `title`, `subtitle`, `facebook_group_url`, `brand_name`, `bridge_video_url`, `footer_note`, `default_leadsleap_id`, `default_share_code`, `theme_stylesheet`, `license_key`, `open_graph_image`, `share_code_leads`, `share_code_referrals`) VALUES
(1, 'assets/images/1751628694_bg_3fdw3.jpg', 'assets/images/1751680535_logo_logo23.png', 'ENTER YOUR OPEN AI API KEY HERE', 'Discover Your All-In-One Marketing Solution', 'Simple tools to grow your audience, generate leads, and scale your business automatically.', 'https://www.facebook.com/groups/changethis', 'AutoAsset Network', 'https://www.youtube.com/embed/LMlCN6_vUvs', '<p>\r\n    <a href=\"privacy-policy.php\" target=\"_blank\">Privacy Policy</a> | <a href=\"disclaimer.php\" target=\"_blank\">Disclaimer</a> | <a href=\"terms-of-use.php\" target=\"_blank\">Terms of Use</a> | <a href=\"income-disclaimer.php\" target=\"_blank\">Income Disclaimer</a>\r\n</p>', 'keyte', 'F6716D', 'theme-purple.css', 'ENTERMYKEYHERE', 'assets/images/1751683093_og_facebook-open-graph-9238.jpg', 'list-eHPWNfhnu', 'list-eHPWwVGGwVu');

-- --------------------------------------------------------

--
-- Table structure for table `clicks`
--

CREATE TABLE `clicks` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8_unicode_ci,
  `ref_code` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country_code` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `source` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `share_code` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `clicks`
--

INSERT INTO `clicks` (`id`, `user_id`, `ip_address`, `user_agent`, `ref_code`, `country`, `country_code`, `created_at`, `source`, `share_code`) VALUES
(99, 5, '60.113.131.162', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 'eddie5', 'Japan', 'JP', '2025-07-05 23:45:05', '', '78XZCH');

-- --------------------------------------------------------

--
-- Table structure for table `leads`
--

CREATE TABLE `leads` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `page_id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `leads`
--

INSERT INTO `leads` (`id`, `user_id`, `page_id`, `name`, `email`, `source`, `created_at`) VALUES
(3, 2, 1, 'Edward', 'edkeyte@me.com', 'Direct Entry', '2025-07-05 23:41:31');

-- --------------------------------------------------------

--
-- Table structure for table `lead_capture_pages`
--

CREATE TABLE `lead_capture_pages` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `share_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `layout` int(11) NOT NULL,
  `background` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mockup` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_theme` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `headline` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `subheadline` text COLLATE utf8mb4_unicode_ci,
  `footer_text` mediumtext COLLATE utf8mb4_unicode_ci,
  `form_name_field` tinyint(1) DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_headline` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Anton',
  `font_subheading` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pacifico',
  `default_capture` tinyint(1) NOT NULL DEFAULT '0',
  `mockup_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cta_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exit_popup_enabled` tinyint(1) DEFAULT '0',
  `exit_popup_lead_magnet_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lead_capture_pages`
--

INSERT INTO `lead_capture_pages` (`id`, `user_id`, `share_code`, `layout`, `background`, `mockup`, `color_theme`, `headline`, `subheadline`, `footer_text`, `form_name_field`, `created_at`, `thumbnail`, `font_headline`, `font_subheading`, `default_capture`, `mockup_filename`, `cta_text`, `exit_popup_enabled`, `exit_popup_lead_magnet_id`) VALUES
(1, 2, 'F6716D', 0, 'bg_1746311650_7918.jpg', NULL, 'teal', '💼 Work Smarter, Not Harder', '<p style=\"text-align:center;\">🚀 <strong>Discover a Free System That Builds Your Team</strong><br>Multiple Income Streams. 100% Done-For-You.</p>', NULL, 1, '2025-06-29 22:33:37', 'assets/thumbnails/6.png', 'Bangers', 'Work Sans', 1, 'mockup1.png', 'fa-magic SHOW ME HOW IT WORKS', 0, 'unlock-financial-freedom'),
(21, 3, 'Y6UBNJ', 0, 'bg_1746311650_7918.jpg', NULL, 'teal', '💼 Work Smarter, Not Harder', '<p style=\"text-align:center;\">🚀 <strong>Discover a Free System That Builds Your Team</strong><br>Multiple Income Streams. 100% Done-For-You.</p>', NULL, 1, '2025-07-05 08:08:03', 'assets/thumbnails/6.png', 'Bangers', 'Work Sans', 1, 'mockup1.png', 'fa-magic SHOW ME HOW IT WORKS', 0, 'unlock-financial-freedom');

-- --------------------------------------------------------

--
-- Table structure for table `programs`
--

CREATE TABLE `programs` (
  `id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subtitle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cta_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `signup_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `placeholder_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_admin_referrer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url_template` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '{{USER_ID}}',
  `slot_number` int(11) NOT NULL,
  `step_label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `step_video_url` text COLLATE utf8_unicode_ci,
  `icon_class` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_new` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `programs`
--

INSERT INTO `programs` (`id`, `title`, `subtitle`, `video_url`, `cta_text`, `signup_url`, `placeholder_text`, `default_admin_referrer`, `url_template`, `slot_number`, `step_label`, `step_video_url`, `icon_class`, `is_new`) VALUES
(1, 'AFFILIATE PROGRAM OVERVIEW!', 'Study The Comp Plan:', 'https://www.youtube.com/embed/LMlCN6_vUvs', 'DEMO TEXT', 'https://livegoodtour.com/', 'DEMO TEXT', '', '', 3, 'AFFILIATE PROGRAM OVERVIEW!', 'https://www.youtube.com/embed/LMlCN6_vUvs', 'fa-money-bill-wave', 0),
(2, 'HOW TO START EARNING FROM DAY ONE!', 'Understand the system, the payout model, and getting started.', 'https://www.youtube.com/embed/LMlCN6_vUvs', 'GET STARTED RIGHT NOW!', 'https://www.prosperitymarketingsystem.com/go/?s=', 'Enter Affiliate Username Here', 'edkeyte', 'https://yourdomainhere.com?ref={{USER_ID}}', 1, 'THE PATH TO PROSPERITY', 'https://www.youtube.com/embed/LMlCN6_vUvs', 'fa-rocket', 1),
(3, 'Training And Next Steps!', 'Watch below to learn how to scale!', 'https://www.youtube.com/embed/LMlCN6_vUvs', 'demo', 'https://leadsleap.com/?r=', 'demo', '', '', 4, 'Welcome Aboard! Training!', 'https://www.youtube.com/embed/LMlCN6_vUvs', 'fa-handshake', 0),
(34, '10K MONTHLY!', 'Watch The Video Here', 'https://www.youtube.com/embed/LMlCN6_vUvs', 'DEMO TEXT', NULL, 'DEMO TEXT', '', '', 2, 'YOUR 10K MONTH PLAN!', 'https://www.youtube.com/embed/LMlCN6_vUvs', 'fa-graduation-cap', 0);

-- --------------------------------------------------------

--
-- Table structure for table `strategies`
--

CREATE TABLE `strategies` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `platform_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `platform_placeholder` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_ref_link` text COLLATE utf8_unicode_ci,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `approved` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `strategy_rebrands`
--

CREATE TABLE `strategy_rebrands` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `strategy_slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ref_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `strategy_votes`
--

CREATE TABLE `strategy_votes` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `strategy_slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `user_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `edit_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `session_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `program_1` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `program_2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `program_3` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tracking_source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reset_token` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `referrer_id` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `first_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `program_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_6` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_7` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_8` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_9` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_10` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `leadsleap_user_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `leadsleap_list_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `leadsleap_list_id_referrals` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_demo` tinyint(1) NOT NULL DEFAULT '0',
  `profile_video_url` text COLLATE utf8_unicode_ci,
  `override_dashboard_step` int(11) DEFAULT NULL,
  `override_program_slot` int(11) DEFAULT NULL,
  `has_bridge_customization` tinyint(1) DEFAULT '0',
  `bridge_video_url` text COLLATE utf8_unicode_ci,
  `bridge_cta_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bridge_cta_description` text COLLATE utf8_unicode_ci,
  `bridge_cta_button_text` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bridge_cta_button_link` text COLLATE utf8_unicode_ci,
  `bridge_contact_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `has_strategy_access` tinyint(1) DEFAULT '0',
  `can_upload_backgrounds` tinyint(1) DEFAULT '1',
  `trafficzest_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `user_id`, `edit_token`, `session_id`, `program_1`, `program_2`, `program_3`, `email`, `tracking_source`, `reset_token`, `referrer_id`, `first_name`, `last_name`, `program_4`, `program_5`, `program_6`, `program_7`, `program_8`, `program_9`, `program_10`, `created_at`, `leadsleap_user_id`, `leadsleap_list_id`, `leadsleap_list_id_referrals`, `is_demo`, `profile_video_url`, `override_dashboard_step`, `override_program_slot`, `has_bridge_customization`, `bridge_video_url`, `bridge_cta_title`, `bridge_cta_description`, `bridge_cta_button_text`, `bridge_cta_button_link`, `bridge_contact_link`, `has_strategy_access`, `can_upload_backgrounds`, `trafficzest_user_id`) VALUES
(2, 'edkeyte', '$2y$10$YaKzBdPelSK.r9j3avu6FObW3.yDwKe0E/3f2w.7coBIfpBV/mS1K', NULL, 'edkeyte', NULL, 'edkeyte2', 'keyteedward@gmail.com', NULL, NULL, '0', 'Edward', 'Keyte', 'edkeyte3', NULL, '', '', '', '', '', '2025-06-29 01:07:51', 'keyte', '104266', '104267', 0, 'https://www.youtube.com/embed/LMlCN6_vUvs', NULL, NULL, 0, '', '', '', '', '', '', 1, 1, NULL),
(3, 'demo', '$2y$10$3g4w/m1Z.2XFcTAkz8lURuurrdnp.6BqFfJmOVpyJt1pitlqNpqIy', NULL, NULL, NULL, NULL, 'edkeyte@gmail.com', 'cp-traffic', NULL, 'edkeyte', 'Demo', 'User', '', NULL, '', '', '', '', '', '2025-07-01 07:20:16', 'test123', NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users_backup`
--

CREATE TABLE `users_backup` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `edit_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `session_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `program_1` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `program_2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `program_3` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tracking_source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reset_token` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `referrer_id` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `first_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `program_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_6` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_7` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_8` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_9` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `program_10` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `leadsleap_user_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `leadsleap_list_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user_activity`
--

CREATE TABLE `user_activity` (
  `user_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `logins` int(11) DEFAULT '1',
  `last_login` datetime DEFAULT CURRENT_TIMESTAMP,
  `leadsleap_id_set` tinyint(1) DEFAULT '0',
  `campaign_id_set` tinyint(1) DEFAULT '0',
  `program_ids_set` tinyint(1) DEFAULT '0',
  `leadsleap_lists_set` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_activity`
--

INSERT INTO `user_activity` (`user_id`, `logins`, `last_login`, `leadsleap_id_set`, `campaign_id_set`, `program_ids_set`, `leadsleap_lists_set`) VALUES
('demo', 19, '2025-07-05 21:11:40', 1, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `user_points`
--

CREATE TABLE `user_points` (
  `user_id` int(11) NOT NULL,
  `total_points` int(11) NOT NULL DEFAULT '0',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user_programs`
--

CREATE TABLE `user_programs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `program_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sub_headline` text COLLATE utf8_unicode_ci,
  `youtube_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `join_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user_sessions`
--

CREATE TABLE `user_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `data` text COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_sessions`
--

INSERT INTO `user_sessions` (`id`, `data`, `timestamp`) VALUES
('2ffe8daa8e06986ffdbf7bf15348bdfd', '', 1751159581),
('88f48ff1332aec1c1345937f1d44b838', '', 1751160335),
('989c1ef2296b562719be478d484af376', '', 1751159681),
('a2ee65bc813f784aa31a1327e996fdfa', '', 1751160648),
('cc1039c97670761bb7751ba8043600a8', 'logged_in_user|s:7:\"edkeyte\";logged_in_user_name|s:4:\"Demo\";', 1751160873);

-- --------------------------------------------------------

--
-- Table structure for table `video_training`
--

CREATE TABLE `video_training` (
  `id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `youtube_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `video_training`
--

INSERT INTO `video_training` (`id`, `title`, `description`, `youtube_url`, `created_at`) VALUES
(2, 'Coming soon video!', 'Change your videos in the admin panel!', 'https://www.youtube.com/embed/LMlCN6_vUvs', '2025-07-01 06:38:29'),
(3, 'Coming soon video!', 'Change your videos in the admin panel!', 'https://www.youtube.com/embed/LMlCN6_vUvs', '2025-07-01 06:40:16');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `ai_usage_log`
--
ALTER TABLE `ai_usage_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `branding`
--
ALTER TABLE `branding`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clicks`
--
ALTER TABLE `clicks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `created_at` (`created_at`);

--
-- Indexes for table `leads`
--
ALTER TABLE `leads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `page_id` (`page_id`);

--
-- Indexes for table `lead_capture_pages`
--
ALTER TABLE `lead_capture_pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `share_code` (`share_code`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `programs`
--
ALTER TABLE `programs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slot_number` (`slot_number`);

--
-- Indexes for table `strategies`
--
ALTER TABLE `strategies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `strategy_rebrands`
--
ALTER TABLE `strategy_rebrands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `strategy_votes`
--
ALTER TABLE `strategy_votes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`,`strategy_slug`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`);

--
-- Indexes for table `user_activity`
--
ALTER TABLE `user_activity`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `user_points`
--
ALTER TABLE `user_points`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `user_programs`
--
ALTER TABLE `user_programs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `user_sessions`
--
ALTER TABLE `user_sessions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `video_training`
--
ALTER TABLE `video_training`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ai_usage_log`
--
ALTER TABLE `ai_usage_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `branding`
--
ALTER TABLE `branding`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `clicks`
--
ALTER TABLE `clicks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `leads`
--
ALTER TABLE `leads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `lead_capture_pages`
--
ALTER TABLE `lead_capture_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `programs`
--
ALTER TABLE `programs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `strategies`
--
ALTER TABLE `strategies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `strategy_rebrands`
--
ALTER TABLE `strategy_rebrands`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `strategy_votes`
--
ALTER TABLE `strategy_votes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `user_programs`
--
ALTER TABLE `user_programs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `video_training`
--
ALTER TABLE `video_training`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `leads`
--
ALTER TABLE `leads`
  ADD CONSTRAINT `leads_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `leads_ibfk_2` FOREIGN KEY (`page_id`) REFERENCES `lead_capture_pages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lead_capture_pages`
--
ALTER TABLE `lead_capture_pages`
  ADD CONSTRAINT `lead_capture_pages_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_programs`
--
ALTER TABLE `user_programs`
  ADD CONSTRAINT `user_programs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
