-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 21, 2024 at 11:14 PM
-- Server version: 5.7.44
-- PHP Version: 8.1.30

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: `alokparastechnol_mycircle`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `account_id` bigint(20) NOT NULL,
  `profile_id` varchar(255) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `type` varchar(255) NOT NULL COMMENT 'public, private, business, track',
  `name` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `surname` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `logo` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `cover_photo` varchar(255) NOT NULL,
  `designation` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `description` text CHARACTER SET utf8mb4 NOT NULL,
  `theme_color` varchar(255) NOT NULL DEFAULT '#ffffff',
  `icon_type` varchar(255) NOT NULL DEFAULT 'rectangular' COMMENT 'rectangular, round',
  `btn_color` varchar(255) DEFAULT NULL,
  `icon_color` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`account_id`, `profile_id`, `user_id`, `type`, `name`, `surname`, `logo`, `photo`, `cover_photo`, `designation`, `description`, `theme_color`, `icon_type`, `btn_color`, `icon_color`, `status`, `created_on`) VALUES
(1, 'p1o1d672b05163441c', 1, 'public', 'Gurpreet', 'Kaur', '', '', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 12:56:38'),
(2, 'p2o2d672b0573648f9', 2, 'public', 'Gautam ', 'Kumar', '', 'dp_2_1732084242.jpg', '', 'Android dev', 'hey.. everyone one ', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 12:58:11'),
(3, 'p3o3d672b085e704ba', 3, 'public', 'Paras', 'Tech', '', 'dp_3_1731586808.jpg', '', 'test', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 13:10:38'),
(4, 'p4o4d672b09655854f', 4, 'public', 'Amit ', 'Kumar', '', '', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 13:15:01'),
(5, 'p5o5d672b0d2ef3ab6', 5, 'public', 'Paras', 'Tech', '', '', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 13:31:10'),
(6, 'p6o6d672b0d44ec231', 6, 'public', 'Karan', 'Sidhu', '', 'dp_6_1732084955.jpg', '', 'Software Developer ', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 13:31:32'),
(7, 'p7o7d672b1dcf83ba1', 7, 'public', 'Paras', 'Tech', '', 'dp_7_1732085401.jpg', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 14:42:07'),
(8, 'p8o8d672b34168a9c0', 8, 'public', 'Paras', 'Tech', '', 'dp_8_1732085938.jpg', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 16:17:10'),
(9, 'p9o9d672b4511aa36b', 9, 'public', 'Baljit', 'Kaur', '', 'dp_9_1732087031.jpg', '', 'Software developer IOS', 'IOS Developer having three years of experience ', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 17:29:37'),
(10, 'p10o10d672b5f6ccb75b', 10, 'public', 'test', 'dev', '', 'dp_10_1732094276.jpg', '', 'test', 'cugxucigcigcicgicgifgucgichhcigcicyic', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-06 19:22:04'),
(11, 'p11o11d672c4b4cec586', 11, 'public', 'Paras', 'Tech', '', 'dp_11_1732095191.jpg', '', 'Software Developer iOS', 'Software Developer iOS having three years of experience', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-07 12:08:28'),
(12, 'p12o12d672c5a4d57a83', 12, 'public', 'Paras', 'Tech', '', 'dp_12_1732096470.jpg', '', 'Software developer', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-07 13:12:29'),
(13, 'p13o13d672c64f2d2e96', 13, 'public', 'Baljit', 'Kaur', '', 'dp_13_1732096838.jpg', '', 'Software Developer', 'Software Developer having three years of experience', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-07 13:57:54'),
(14, 'p14o14d672e21682f7a4', 14, 'public', 'Baljit', 'Kaur', '', 'dp_14_1731663369.jpg', '', 'Software Developer', 'iOS', '', '', NULL, NULL, 1, '2024-11-08 21:34:16'),
(15, 'p15o15d6731b56d62eb9', 15, 'public', 'Baljit', 'Kaur', '', 'dp_15_1731310987.jpg', '', 'ydhhchhv', 'fucucviiv', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-11 14:42:37'),
(16, 'p16o16d67332382eb315', 16, 'public', 'Baljit', 'Kaur', '', 'dp_16_1731404710.jpg', '', 'dhdjffnfjffj', 'jfjvjffufgdhcnvncbc', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-12 16:44:34'),
(17, 'p17o17d67333b7284b60', 17, 'public', 'Baljit', 'Kaur', '', 'dp_17_1731410930.jpg', '', 'Software Tester', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-12 18:26:42'),
(18, 'p18o18d67334b82aea35', 18, 'public', 'G', 'Kay', '', 'dp_18_1731414943.jpg', '', 'xyydicuuv', 'chcjckvjijb', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-12 19:35:14'),
(19, 'p19o19d67343b48a2c70', 19, 'public', 'ytest', '', '', '', '', '          ', 'The only way for the world is for ', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-13 12:38:16'),
(20, 'p20o20d673452435b62c', 20, 'public', 'Baljit', 'Kaur', '', '', '', 'Software Tester', 'This description added by tester in the bio field. Can you please check my profile on Instagram?', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-13 14:16:19'),
(21, 'p21o21d6735d0a2c19e4', 21, 'public', 'Baljit', 'Kaur', '', 'dp_21_1731580077.jpg', '', 'jdfjgjmgvmnv', 'cnjgjgkg', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-14 17:27:46'),
(22, 'p22o22d6735e1caab20e', 22, 'public', 'Baljit', 'Kaur', '', 'dp_22_1731584485.jpg', '', 'hiii......', 'Description is any type of communication that aims to make vivid a place, object, person, group, or other physical entity.[1] Description is one of four rhetorical modes (also known as modes o', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-14 18:40:58'),
(23, 'p23o23d6735e4cae5b30', 23, 'public', 'Baljit', 'Kaur', '', '', '', 'referrer', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-14 18:53:46'),
(24, 'p24o24d6735e886d2152', 24, 'public', 'Baljit', 'Kaur', '', '', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-14 19:09:42'),
(25, 'p25o25d6735e96053e26', 25, 'public', 'Baljit', 'Kaur', '', 'dp_25_1731586426.jpg', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-14 19:13:20'),
(26, 'p26o26d6736e402a89cc', 26, 'public', 'Baljit', 'Kaur', '', '', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-15 13:02:42'),
(27, 'p27o27d6736e4ea499c7', 27, 'public', 'Paras', 'Tech', '', 'dp_27_1732102565.jpg', '', 'Test', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-15 13:06:34'),
(28, 'p28o28d6736e91533c7c', 28, 'public', 'rajwinder', 'Thakur', '', 'dp_28_1731651979.jpg', '', 'Senior Software Tester', 'hello how are you I am working in forest technology since. Can You please test the this app on your device because I am able to to do everything and in my app.', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-15 13:24:21'),
(29, 'p29o29d673ac778ae5b0', 29, 'public', 'Deep', 'Sidhu', '', '', '', '', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-18 11:50:00'),
(30, 'p30o30d673aceaa2a9ed', 30, 'public', 'Hunar', 'Sidhu', '', 'dp_30_1731907527.jpg', '', 'Business Analysts', 'The only way I could do that was if you had to do a lot more work and then you would be done by yourself so you would be fine and then I could just go home to you if I needed you and you could just.', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-18 12:20:42'),
(31, 'p31o31d673ad0fc26550', 31, 'public', 'Baljit', 'Kaur', '', 'dp_31_1731907862.jpg', '', 'Android dev', 'Enjoy your day.... ', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-18 12:30:36'),
(32, 'p32o32d673ad9b05079e', 32, 'public', 'Baljit', 'Kaur', '', 'dp_32_1731910125.jpg', '', 'Designer', 'The Bio added by tester in create profile screen', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-18 13:07:44'),
(33, 'p33o33d673ae197abcae', 33, 'public', 'Baljit', 'kaur', '', 'dp_33_1732173607.jpg', '', 'Software Developer IOS', 'Software developer having three years of experience in iOS development ', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-18 13:41:27'),
(34, 'p34o34d673c7ce7a0c9b', 34, 'public', 'Paras', 'Baljit', '', 'dp_34_1732017420.jpg', '', 'test design', 'test', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-19 18:56:23'),
(35, 'p35o35d673c7e430db50', 35, 'public', 'Paras', 'IOS', '', 'dp_35_1732174399.jpg', '', 'test', 'testtest', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-19 19:02:11'),
(37, 'p2o37d673ee5756b67b', 2, 'private', 'web dev', '', '', 'dp_2_1732175221.jpg', '', '', 'device', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-21 14:47:01'),
(38, 'p36o38d673ee6a2b9ab3', 36, 'public', 'Paras', 'Baljit', '', 'dp_36_1732175543.jpg', '', 'Software Developer', '', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-21 14:52:02'),
(39, 'p37o39d673ee7420bc9a', 37, 'public', 'iOS', 'Baljit', '', 'dp_37_1732175924.jpg', '', 'Software Developer', 'IOS Developer ', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-21 14:54:42'),
(40, 'p37o40d673f0aa9b74be', 37, 'private', 'Werner', '', '', '', '', '', 'Werner', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-21 17:25:45'),
(41, 'p38o41d673f2138982e5', 38, 'public', 'Prachi', 'Sachdeva', '', 'dp_38_1732190628.jpg', '', 'Tester', 'Bio', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-21 19:02:00'),
(42, 'p39o42d673f2729a6238', 39, 'public', 'Kashish', 'Sharma', '', 'dp_39_1732192136.jpg', '', 'Quality Analysts', 'This bio added by tester. Edited', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-21 19:27:21'),
(43, 'p40o43d674016e3df37c', 40, 'public', 'Swarn', 'Singh ', '', '', '', 'Business Analyst', 'Hello There', '#ffffff', 'rectangular', NULL, NULL, 1, '2024-11-22 12:30:11');

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

--
-- Table structure for table `account_tap`
--

CREATE TABLE `account_tap` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `account_id` bigint(20) NOT NULL,
  `through` varchar(255) NOT NULL COMMENT 'web|mobile',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account_tap`
--

INSERT INTO `account_tap` (`id`, `user_id`, `account_id`, `through`, `created_on`) VALUES
(1, 1, 1, 'web', '2024-11-18 19:09:21'),
(3, 1, 1, 'web', '2024-11-20 14:39:09');

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

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

CREATE TABLE `admins` (
  `id` int(11) NOT NULL,
  `full_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `email_token` varchar(255) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `admins` (`id`, `full_name`, `email`, `password`, `photo`, `status`, `email_token`, `created_on`) VALUES
(1, 'Mac Williams', 'hello@example.com', '12bce374e7be15142e8172f668da00d8', '', 1, '', '2021-05-20 16:32:45');

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

--
-- Table structure for table `advertisement`
--

CREATE TABLE `advertisement` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `photo` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `tx_id` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `app_clicks`
--

CREATE TABLE `app_clicks` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `account_id` bigint(20) NOT NULL,
  `app_id` bigint(20) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_clicks`
--

INSERT INTO `app_clicks` (`id`, `user_id`, `account_id`, `app_id`, `slug`, `created_on`) VALUES
(1, 28, 28, 8, 'phone', '2024-11-15 14:40:39'),
(2, 28, 28, 8, 'phone', '2024-11-15 14:41:37'),
(3, 15, 15, 1, 'email', '2024-11-18 18:36:52'),
(4, 15, 15, 1, 'email', '2024-11-18 18:37:30'),
(5, 15, 15, 2, 'email', '2024-11-18 18:37:54'),
(6, 15, 15, 2, 'email', '2024-11-19 19:19:43'),
(7, 40, 43, 39, 'instagram', '2024-11-22 12:53:09');

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

--
-- Table structure for table `app_icons`
--

CREATE TABLE `app_icons` (
  `slug` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `hints` varchar(255) NOT NULL,
  `instruction` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `base_url` varchar(255) DEFAULT NULL,
  `linking_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app_icons`
--

INSERT INTO `app_icons` (`slug`, `type`, `name`, `hints`, `instruction`, `image`, `base_url`, `linking_url`) VALUES
('behance', 'portfolio', 'Behance', 'Username', 'Enter your behance url', 'behance.png', 'https://www.behance.net/', NULL),
('binance', 'finance', 'Binance', 'Email Address or Payment Link', 'Enter your binance url', 'binance.png', 'https://www.binance.com/', ''),
('bitHub', 'business', 'BitHub', 'bitHub Link', 'Enter your BitHub url', 'bitHub.png', 'https://www.bithub.com/', ''),
('blockchain', 'finance', 'Blockchain', 'Email Address or blockchain Link', 'Enter your blockchain url', 'blockchain.png', 'https://www.blockchain.com/', ''),
('canva', 'portfolio', 'Canva', 'canva url', 'Enter your email id', 'canva.png', 'https://www.canva.com/', ''),
('coinbase', 'finance', 'Coinbase', 'coinbase business url', 'Enter your coinbase url', 'coinbase.png', 'https://www.pymnts.com/', ''),
('discord', 'contact', 'Discord', 'Username without @', 'Enter your email or phone number', 'discord.png', 'https://discord.com/', ''),
('domains', 'finance', 'Domains', '', 'Enter your domains url', 'domains.png', '', ''),
('facebook', 'social', 'Facebook', 'Facebook Profile Link', 'Enter your email and password', 'facebook.png', 'https://www.facebook.com/', 'fb://facewebmodal/f?href='),
('figma', 'portfolio', 'Figma', 'Username', 'Enter your email id', 'figma.png', 'https://www.figma.com/', NULL),
('fiverr', 'portfolio', 'Fiverr', 'fiverr Link', 'Enter your fiverr url', 'fiverr.png', 'https://www.fiverr.com/', ''),
('github', 'business', 'Github', 'Github Link', 'Enter your email', 'github.png', 'https://github.com/', ''),
('instagram', 'social', 'Instagram', 'Username without @', 'Enter your phone number, username, or email id', 'instagram.png', 'https://www.instagram.com/', 'instagram://user?username='),
('ledger', 'finance', 'Ledger', '', 'Enter your ledger url', 'ledger.png', 'https://www.ledger.com/', ''),
('link', 'contact', 'Link', 'Custom link', 'Enter your link url', 'link.png', NULL, NULL),
('linkedin', 'business', 'LinkedIn', 'Linkedin Profile url', 'Enter your email or phone', 'linkedin.png', 'https://www.linkedin.com/', ''),
('ludex', 'finance', 'Ludex', 'Email Address or Payment Link', 'Enter your ludex url', 'ludex.png', 'https://ludex.gg/', ''),
('magiceden', 'finance', 'Magiceden', 'Username without @', 'Enter your magiceden url', 'magiceden.png', 'https://magiceden.io/', ''),
('metamask', 'finance', 'Metamask', 'Email Address or Payment Link', 'Enter your metamask url', 'metamask.png', 'https://metamask.io/', ''),
('notion', 'business', 'Notion', 'Custom link', 'Enter your email id', 'notion.png', 'https://www.notion.com/', NULL),
('okx', 'finance', 'Okx', 'Email Address or Payment Link', 'Enter your okx url', 'okx.png', 'https://www.okx.com', ''),
('opensea', 'finance', 'Opensea', 'Email Address or Payment Link', 'Enter your opensea url', 'opensea.png', 'https://opensea.io/', ''),
('panini-direct', 'finance', 'Panini-Direct', 'panini url', 'Enter your panini-direct url', 'panini-direct.png', 'https://www.paniniamerica.net/', ''),
('paypal', 'finance', 'Paypal', 'Email Address or Payment Link', 'Enter your paypal url', 'paypal.png', 'https://www.paypal.me/', 'https://www.paypal.com/paypalme/'),
('phantom', 'finance', 'Phantom', '', 'Enter your phantom url', 'phantom.png', '', ''),
('rainbow', 'finance', 'Rainbow', 'Email Address or Payment Link', 'Enter your rainbow url', 'rainbow.png', 'https://rainbow.me/en/', ''),
('reditt', 'social', 'Reditt', 'Username', 'Enter your email id', 'reditt.png', 'https://www.reddit.com/', 'https://www.reddit.com/'),
('safe', 'finance', 'Safe', '', 'Enter your safe url', 'safe.png', '', ''),
('sandbox', 'finance', 'Sandbox', 'Email Address or Payment Link', 'Enter your sandbox url', 'sandbox.png', 'https://www.sandbox.game', ''),
('slack', 'contact', 'Slack', 'slack business url', 'Enter your email id', 'slack.png', 'https://slack.com/intl/en-in/workspace-signin', 'https://slack.com/intl/en-in/workspace-signin'),
('spatial', 'finance', 'Spatial ', 'spatial url', 'Enter your spatial url', 'spatial.png', 'https://www.spatial.io/', ''),
('sui', 'finance', 'Sui', 'Email Address ', 'Enter your sui url', 'sui.png', 'https://sui.io/', ''),
('telegram', 'contact', 'Telegram', 'Username', 'Enter your contact number', 'telegram.png', 'https://telegram.me/', 'https://telegram.me/'),
('tiktok', 'social', 'Tiktok', 'Username without @', 'Enter your email id', 'tiktok.png', 'https://www.tiktok.com/', 'https://www.tiktok.com/@'),
('trust', 'finance', 'Trust', 'Custom link', 'Enter your trust url', 'trust.png', NULL, NULL),
('uniswap', 'finance', 'Uniswap', 'Email Address or Payment Link', 'Enter your uniswap url', 'uniswap.png', 'https://app.uniswap.org/', ''),
('unstoppable', 'finance', 'Unstoppable', 'Email Address or Payment Link', 'Enter your unstoppable url', 'unstoppable.png', 'https://unstoppable.money/', ''),
('x', 'business', 'X', 'X Profile Link', 'Enter your email id ', 'x.png', 'https://x.com/', ''),
('youtube', 'business', 'Youtube', 'Channel Link', 'Enter your youtube url', 'youtube.png', NULL, NULL),
('zerion', 'finance', 'Zerion', 'Email Address or zerion Link', 'Enter your zerion url', 'zerion.png', 'https://zerion.io/', '');

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

--
-- Table structure for table `connect_categories`
--

CREATE TABLE `connect_categories` (
  `id` int(20) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `connect_categories`
--

INSERT INTO `connect_categories` (`id`, `name`, `created_on`, `updated_on`) VALUES
(1, 'rajwinder kaur', '2024-11-21 12:09:14', '2024-11-21 12:09:14');

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

--
-- Table structure for table `connect_cat_relations`
--

CREATE TABLE `connect_cat_relations` (
  `connect_id` bigint(20) NOT NULL,
  `cat_id` bigint(20) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `connect_cat_relations`
--

INSERT INTO `connect_cat_relations` (`connect_id`, `cat_id`, `created_on`, `updated_on`) VALUES
(1, 4, '2024-11-21 13:42:16', '2024-11-21 13:42:16'),
(2, 4, '2024-11-21 13:41:45', '2024-11-21 13:41:45'),
(2, 6, '2024-11-21 14:14:20', '2024-11-21 14:14:20'),
(3, 4, '2024-11-21 13:42:16', '2024-11-21 13:42:16'),
(4, 4, '2024-11-21 13:41:45', '2024-11-21 13:41:45'),
(5, 4, '2024-11-21 13:41:45', '2024-11-21 13:41:45'),
(9, 4, '2024-11-21 13:41:45', '2024-11-21 13:41:45'),
(10, 4, '2024-11-21 14:14:48', '2024-11-21 14:14:48'),
(11, 4, '2024-11-21 14:17:07', '2024-11-21 14:17:07'),
(22, 4, '2024-11-21 14:07:14', '2024-11-21 14:07:14'),
(33, 4, '2024-11-21 14:07:14', '2024-11-21 14:07:14'),
(55, 4, '2024-11-21 14:21:16', '2024-11-21 14:21:16'),
(55, 42, '2024-11-21 14:21:53', '2024-11-21 14:21:53');

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

--
-- Table structure for table `device_tap`
--

CREATE TABLE `device_tap` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `tag_id` varchar(255) NOT NULL,
  `through` varchar(255) NOT NULL COMMENT 'web|mobile',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `device_tap`
--

INSERT INTO `device_tap` (`id`, `user_id`, `tag_id`, `through`, `created_on`) VALUES
(1, 1, '2', 'mobile', '2024-11-20 13:06:10'),
(2, 1, '2', 'mobile', '2024-11-20 13:06:38');

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `template` text NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`id`, `subject`, `template`, `created_on`) VALUES
(1, 'MyCircle, Reset Password', 'Hi {name},\r\n\r\nYour reset password pin is : {pin}\r\n', '2022-01-10 13:00:00'),
(2, 'MyCircle, Contact Email', '{content}', '2022-01-10 13:00:00'),
(3, 'MyCircle, Connect Email', '{content}', '2022-01-10 13:00:00'),
(4, 'MyCircle, Thanks for purchasing', 'Hi {name},\r\n\r\n<br><br>\r\n\r\nThanks for purchasing. You have buy {package} membership.\r\n\r\n\r\n<br><br>', '2022-02-14 10:22:38'),
(5, 'MyCircle, You\'ve been welcome to join your team', '<!doctype html>\n<html lang=\"en\">\n  <head>\n    <title>POD</title>\n  </head>\n  <style>\n    @import url(\'https://fonts.googleapis.com/css2?family=Noto+Sans:wght@400;500;600;700&display=swap\');\n  </style>\n  <body style=\"box-sizing: border-box;\">\n    <div class=\"wrapper\" style=\"max-width:640px; margin:0 auto;font-size: 16px;font-family: \'Noto Sans\', sans-serif;border:1px solid #e7e7e7; padding-bottom:30px;\">\n        <div class=\"header\" style=\"background-color:#101333; height:82px; width: 100%; padding-top: 10px;\">\n          <div class=\"logo\" style=\"float: left;\"><img src=\"https://saurabh.parastechnologies.in/POD/public/admin/assets/img/logo.png\" style=\"padding-left:20px;width:78px;\"></div>\n          <div class=\"date\" style=\"padding: 0 20px;\"><p style=\"color: #fff; font-size: 16px; margin: 0; line-height: 70px; text-align: right;\">POD</p></div>          \n        </div>\n        <div class=\"content-wrap\" style=\"padding:20px;\">\n          <br>\n          <br>\n			<p style=\"color: #000; font-weight: 300; margin-top:0;\">You\'ve been invited to join company on POD Teams</p>\n			<br>\n      <br>\n			<p style=\"color: #000; font-weight: 300; margin-top:0; margin-bottom: 10px;\">To claim your new digital business card from a computer, click here to</p>\n      <br>\n      <a href=\"{link}\" style=\"text-decoration: none; color: #ffffff; background: #0071bc; padding: 12px 20px; border-radius: 100px; font-size: 18px; font-weight: 600; letter-spacing: 1.5px;\">Accept Invite</a>\n			<br><br>\n			<p style=\"color: #000; font-weight: 300; margin-top:30px;\">To claim your new digital business card from a mobile phone:</p>\n      		<br>\n			<p style=\"color: #000; font-weight: 300; margin-top:0;\">1. Tap the log in button above<br>2. Then once you\'ve downloaded the POD app, login with the info:</p>\n      <br>\n			<p style=\"color: #000; font-weight: 300; margin-top:0;\">Email: {email}<br>Password: {password}</p>\n			<br>\n			<p style=\"color: #000; font-weight: 300; margin-top:0; margin-bottom: 5px;\">POD will have you choose a new password as soon as you log in the first time.</p>\n\n			<br><br><br>\n			<p style=\"color: #000; font-weight: 300; margin-top:0; margin-bottom: 5px;\">Learn exactly how to use your new POD digital business card using our easy-to-follow tutorials here:</p>\n			  <br>\n			  <br>\n			   <p style=\"color: #000; font-weight: 300; margin-top:0; margin-bottom: 5px;\">\n				<a href=\"https://pod-wm.com/\" style=\"text-decoration: none; color: #000; background: #fff; border: 1px solid #000; padding: 12px 16px; border-radius: 100px; font-size: 18px; font-weight: 600; letter-spacing: 1.5px;\">See Tutorials</a>\n			  </p>\n\n			  <br>\n            <div class=\"footer\" style=\"padding:10px 0;\">\n                <p style=\"color: #000; font-weight: 300; font-size: 20px; margin-top:0; margin-bottom: 5px;\">Thank You,</p>\n                <span style=\"color:#0071bc; font-size: 20px;\">POD Team</span>\n            </div>\n        </div>\n    </div>\n  </body>\n</html>', '2022-02-14 10:22:38');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `meta_title` varchar(255) NOT NULL,
  `meta_description` text NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `feature_image` varchar(255) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `slug`, `meta_title`, `meta_description`, `title`, `content`, `feature_image`, `created_on`) VALUES
(1, 'about', 'About', '', 'About', '<i>Last updated on Dec 22,2021</i>          <p>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo.</p>           <p>At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis:</p>          <ul>            <li>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque</li>            <li>Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit</li>            <li>sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam</li>            <li>Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur</li>          </ul>                    <h3>The information we collect and how we use it</h3>             <p>At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores:</p>          <ul>            <li>similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio</li>          </ul>', '', '2022-01-27 11:28:14');

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `mode` varchar(100) NOT NULL DEFAULT 'dark'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `name`, `color`, `mode`) VALUES
(1, 'Default', '#FFFFFF', 'dark'),
(2, 'Burgundy', '#eee7e9', 'light'),
(3, 'Golden', '#f9e8b8', 'light'),
(4, 'Silver', '#7f4848', 'dark'),
(5, 'Black', '#000000', 'light'),
(6, 'Light Blue', '#c79eb2', 'light'),
(7, 'DarkBlue', '#818e1f', 'light'),
(8, 'Golden ', '#000000', 'dark'),
(9, 'Golden ', '#f0c7c7', 'dark'),
(10, 'blue and dark blue backbg', '#000000', 'dark');

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

--
-- Table structure for table `track_details`
--

CREATE TABLE `track_details` (
  `account_id` bigint(20) NOT NULL,
  `sub_type` varchar(255) NOT NULL COMMENT 'human or pet or asset',
  `age` varchar(255) NOT NULL,
  `whatsapp_no` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `mother_name` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `address` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `breed` varchar(255) NOT NULL,
  `vac_details` varchar(255) NOT NULL,
  `next_vac_details` varchar(255) NOT NULL,
  `vet_info` varchar(255) NOT NULL,
  `owner_name` varchar(255) NOT NULL,
  `owner_contact` varchar(255) NOT NULL,
  `address_link` text NOT NULL,
  `brand` varchar(255) NOT NULL,
  `marked_missed` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `account_id` bigint(20) NOT NULL,
  `tx_id` varchar(255) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `account_id`, `tx_id`, `created_on`) VALUES
(1, 1, 36, '1', '2024-11-20 13:28:03');

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

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

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL,
  `token` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `device_id` varchar(255) NOT NULL,
  `device_name` varchar(255) NOT NULL,
  `device_token` text NOT NULL,
  `reset_pin` varchar(255) NOT NULL,
  `social_id` varchar(100) NOT NULL,
  `social_source` varchar(100) NOT NULL COMMENT 'facebook, google, linkedin, apple',
  `user_status` tinyint(1) NOT NULL DEFAULT '1',
  `last_login` timestamp NULL DEFAULT NULL,
  `modified_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `users` (`id`, `token`, `email`, `password`, `device_id`, `device_name`, `device_token`, `reset_pin`, `social_id`, `social_source`, `user_status`, `last_login`, `modified_on`, `created_on`) VALUES
(1, '82870317b3985ce6b5de0a8bfbe09192', 'gurpreet@yopmail.com', '25d55ad283aa400af464c76d713c07ad', '1234', '4321', '11223344', '', '', '', 1, '2024-11-20 14:42:17', '2024-11-20 07:42:17', '2024-11-20 13:19:38'),
(2, '870c135ec23b6c953bf91033c89f611e', 'Gautampb12@gmail.com', 'd89855da0e646a043817e9281dbb7136', '1234567890', '', 'hfdhfkdfldjfljdsd', '', '', '', 1, '2024-11-20 18:48:46', '2024-11-20 11:48:46', '2024-11-20 13:30:24'),
(3, '', 'ParasTech@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '', '', '', 1, '2024-11-20 13:33:21', '2024-11-20 06:40:11', '2024-11-20 13:33:21'),
(4, '022ebaf2765e70383df25b96e4249db8', 'ajk123647@gmail.com', 'ef428ba675efc8869039f77f05a16909', '1234567890', '', 'hhhhh', '', '', '', 1, '2024-11-20 13:37:34', '2024-11-20 06:37:34', '2024-11-20 13:37:34'),
(5, '', 'ParasIos@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '4776', '', '', 1, '2024-11-20 13:41:22', '2024-11-20 07:55:40', '2024-11-20 13:41:22'),
(6, 'e027ffd84b6253c738f62853190505b3', 'karan1@yopmail.com', 'f925916e2754e5e03f75dd58a5733251', '1234567890', '', 'hfdhfkdfldjfljdsd', '7010', '', '', 1, '2024-11-20 14:14:43', '2024-11-20 07:14:43', '2024-11-20 13:42:17'),
(7, '', 'ParasBaljit@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '', '', '', 1, '2024-11-20 13:48:05', '2024-11-20 06:53:06', '2024-11-20 13:48:05'),
(8, '', 'ParasJit@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '', '', '', 1, '2024-11-20 13:58:41', '2024-11-20 07:01:23', '2024-11-20 13:58:41'),
(9, '4c42e8a5fb23bdba55d8aac12ca7f8d2', 'JitParas@yopmail.com', 'acbd9ab2f68bea3f5291f825416546a1', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-21 14:09:43', '2024-11-21 07:09:43', '2024-11-20 14:14:22'),
(10, '807173b4e98646b9c65d27d26cb66aa3', 'pk@yopmail.com', 'f925916e2754e5e03f75dd58a5733251', '1234567890', '', 'hfdhfkdfldjfljdsd', '4100', '', '', 1, '2024-11-22 12:03:40', '2024-11-22 05:03:40', '2024-11-20 14:44:37'),
(11, '', 'ParasJeet@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '', '', '', 1, '2024-11-20 16:32:51', '2024-11-20 09:35:29', '2024-11-20 16:32:51'),
(12, '', 'meet@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '', '', '', 1, '2024-11-20 16:41:22', '2024-11-20 09:56:56', '2024-11-20 16:41:22'),
(13, '', 'ParasJ@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '', '', '', 1, '2024-11-20 16:58:17', '2024-11-20 10:02:27', '2024-11-20 16:58:17'),
(14, '', 'Jit@yopmail.com', 'acbd9ab2f68bea3f5291f825416546a1', '', 'ios', '', '', '', '', 1, '2024-11-20 17:24:23', '2024-11-20 10:24:32', '2024-11-20 17:15:19'),
(15, '', 'iosT@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '', '', '', 1, '2024-11-20 17:25:25', '2024-11-20 10:30:46', '2024-11-20 17:25:25'),
(16, 'b998eb86bfb407350076f8892b36eb21', 'iosBaljit@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 17:35:20', '2024-11-20 10:35:20', '2024-11-20 17:35:20'),
(17, 'a8582aa3a0f5f05154dc87ae8e370270', 'dummyIOS@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 17:38:27', '2024-11-20 10:38:27', '2024-11-20 17:38:27'),
(18, 'd742a2b55ebff72f83d00e8d36f4c40b', 'qwerty123@gmail.com', 'd89855da0e646a043817e9281dbb7136', '1234567890', '', 'hhhhh', '', '', '', 1, '2024-11-20 18:01:48', '2024-11-20 11:01:48', '2024-11-20 18:01:48'),
(19, '0260e390e779ebac21ce7b004ed729fb', 'ytest@gmail.com', '05a671c66aefea124cc08b76ea6d30bb', '1234', '4321', '11223344', '', '', '', 1, '2024-11-20 18:19:45', '2024-11-20 11:19:45', '2024-11-20 18:19:45'),
(20, '9508e51965f483ad6581cbc0360b35ee', 'dummyIOS121@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 18:22:14', '2024-11-20 11:22:14', '2024-11-20 18:22:14'),
(21, 'df285776eb96fb7b586b5a9dce5321fb', 'dummyIOS123@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk78', '', '', '', 1, '2024-11-20 18:22:55', '2024-11-20 11:22:55', '2024-11-20 18:22:55'),
(22, '355288c6d4474e5781f55c18831363f5', 'paras@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 18:27:20', '2024-11-20 11:27:20', '2024-11-20 18:27:20'),
(23, '5496bb03619097435921310e99447eae', 'parasMobile@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 18:28:05', '2024-11-20 11:28:05', '2024-11-20 18:28:05'),
(24, 'c7254c0e783918a3cf4ccb86a244e2d9', 'parasMobiless@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 18:30:21', '2024-11-20 11:30:21', '2024-11-20 18:30:21'),
(25, 'afdd1259c21c4b79b466c8352f05f6b3', 'parasMobile12@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 18:31:25', '2024-11-20 11:31:25', '2024-11-20 18:31:25'),
(26, 'f37464e36b451d758679a2ff0368ddfb', 'parasMobile121@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 18:31:58', '2024-11-20 11:31:58', '2024-11-20 18:31:58'),
(27, '966c25092a40c3c9609e115f64424bc2', 'mobileParas@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-20 18:34:11', '2024-11-20 11:34:11', '2024-11-20 18:34:11'),
(28, '06bc6adbb4a5c91bb70f7b64e2f5333c', 'rajwinderkaur@parastechnologies.com', '58b4e38f66bcdb546380845d6af27187', '12345', '43211', '112233445', '', '', '', 1, '2024-11-21 11:39:44', '2024-11-21 04:39:44', '2024-11-21 11:39:44'),
(29, '98ade2f7d13a88c56cdcfd25f7a8f269', 'deep@yopmail.com', 'f925916e2754e5e03f75dd58a5733251', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-21 13:10:00', '2024-11-21 06:10:00', '2024-11-21 11:45:45'),
(30, '', 'hunar@yopmail.com', 'f925916e2754e5e03f75dd58a5733251', '', 'ios', '', '', '', '', 1, '2024-11-21 11:52:43', '2024-11-21 05:22:25', '2024-11-21 11:52:43'),
(31, '4b208ef97fa0cf5794400b21b189f9cf', 'baljit@yopmail.com', 'f925916e2754e5e03f75dd58a5733251', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-21 12:24:12', '2024-11-21 05:24:12', '2024-11-21 12:24:12'),
(32, '', 'kaur@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', '', '', '', '', 1, '2024-11-21 14:07:05', '2024-11-21 07:07:16', '2024-11-21 14:07:05'),
(33, '4fcebba620672a35ffcfbbe1ab481574', 'baljitKaur@yopmail.com', '8dd43ae0638e1ce2690e2e3cfa653923', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-21 14:22:04', '2024-11-21 07:22:04', '2024-11-21 14:19:20'),
(34, '9ca66ec946a08d4a0423b888dc14c72b', 'baljitGoraya@yopmail.com', 'acbd9ab2f68bea3f5291f825416546a1', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-21 14:26:52', '2024-11-21 07:26:52', '2024-11-21 14:26:52'),
(35, '1ca3df9023d0c13f27f9bb60a9481e63', 'mobile@yopmail.com', 'acbd9ab2f68bea3f5291f825416546a1', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-21 14:35:27', '2024-11-21 07:35:27', '2024-11-21 14:32:58'),
(36, '', 'iosTech@yopmail.com', 'acbd9ab2f68bea3f5291f825416546a1', '', 'ios', '', '', '', '', 1, '2024-11-21 14:52:02', '2024-11-21 07:53:48', '2024-11-21 14:52:02'),
(37, '2189606a73c341ca0bfaae6f7ab95650', 'mobile1@yopmail.com', 'acbd9ab2f68bea3f5291f825416546a1', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-21 14:58:35', '2024-11-21 07:58:35', '2024-11-21 14:54:42'),
(38, '', 'prachi@yopmail.com', 'f925916e2754e5e03f75dd58a5733251', '', 'ios', '', '', '', '', 1, '2024-11-21 19:02:00', '2024-11-21 12:26:20', '2024-11-21 19:02:00'),
(39, 'bc8c55d9d98b05ad990ec4348eaa356b', 'kashish@yopmail.com', 'f925916e2754e5e03f75dd58a5733251', '', 'ios', 'okokpopjhjopokkljkjkjk', '', '', '', 1, '2024-11-21 19:28:15', '2024-11-21 12:28:15', '2024-11-21 19:27:21'),
(40, '9b7270f6cf73616dcb6cf6a4fdaa9d74', 'swarn@yopmail.com', 'f925916e2754e5e03f75dd58a5733251', '1234567890', '', 'hhhhh', '', '', '', 1, '2024-11-22 12:30:11', '2024-11-22 05:30:11', '2024-11-22 12:30:11');

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

--
-- Table structure for table `user_apps`
--

CREATE TABLE `user_apps` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `account_id` bigint(20) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `app_order` int(11) NOT NULL,
  `direct` tinyint(1) NOT NULL DEFAULT '0',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_apps`
--

INSERT INTO `user_apps` (`id`, `user_id`, `account_id`, `slug`, `title`, `content`, `file_name`, `app_order`, `direct`, `created_on`) VALUES
(1, 15, 15, 'email', 'Email', 'amit123@gmail.com', '', 1, 0, '2024-11-11 17:21:11'),
(2, 15, 15, 'email', 'Email', 'amit1234@gmail.com', '', 1, 0, '2024-11-11 17:21:11'),
(3, 3, 3, 'whatsapp', 'WhatsApp', '+57 933939393', '', 1, 0, '2024-11-12 14:05:59'),
(4, 3, 3, 'instagram', 'Instagram', 'test', '', 2, 0, '2024-11-12 14:06:13'),
(5, 1, 25, 'facebook', 'FB', 'fb.com', '', 1, 0, '2024-11-15 12:54:58'),
(6, 1, 25, 'facebook', 'FB', 'fb.com', '', 2, 0, '2024-11-15 12:57:17'),
(7, 27, 27, 'link', 'Link', 'www.google.com', '', 1, 0, '2024-11-15 13:20:41'),
(8, 28, 28, 'phone', 'Phone', '+591 6284581145', '', 1, 0, '2024-11-15 13:51:58'),
(9, 22, 22, 'whatsapp', 'WhatsApp', '+57 7973823365', '', 1, 0, '2024-11-18 12:19:00'),
(10, 22, 22, 'whatsapp', 'WhatsApp', '+57 7973823365', '', 2, 0, '2024-11-18 12:20:35'),
(11, 33, 33, 'phone', 'Phone', '+91 7973823365', '', 1, 0, '2024-11-18 19:08:00'),
(12, 22, 22, 'phone', 'Phone', '+57 7973823365', '', 3, 0, '2024-11-19 13:24:29'),
(13, 1, 25, 'facebook', 'FB', 'fb.com', '', 3, 0, '2024-11-19 15:02:22'),
(14, 1, 25, 'facebook', 'FB', 'fb.com', '', 4, 0, '2024-11-19 15:02:27'),
(15, 1, 25, 'facebook', 'FB', 'fb.com', '', 5, 0, '2024-11-19 15:03:48'),
(16, 22, 22, 'phone', 'Phone', '+91 7973823365', '', 4, 0, '2024-11-20 11:59:09'),
(17, 22, 22, 'phone', 'Phone', '+91 797382365', '', 5, 0, '2024-11-20 12:53:51'),
(18, 22, 22, 'phone', 'Phone', '+91 7973823365', '', 6, 0, '2024-11-20 13:02:50'),
(19, 22, 22, 'phone', 'Phone', '7973823365', '', 7, 0, '2024-11-20 13:02:50'),
(20, 22, 22, 'phone', 'Phone', '+91 7973823365', '', 8, 0, '2024-11-20 13:09:15'),
(21, 22, 22, 'phone', 'Phone', '+91 7558468569', '', 9, 0, '2024-11-20 13:16:28'),
(22, 2, 2, 'phone', 'Phone', '+91 7973823365', '', 1, 0, '2024-11-20 13:31:34'),
(23, 1, 1, 'phone', 'Phone', '+91 9115894585', '', 1, 0, '2024-11-20 13:33:31'),
(24, 2, 2, 'phone', 'Phone', '+91 7973823365', '', 2, 0, '2024-11-20 19:03:25'),
(25, 10, 10, 'whatsapp', 'WhatsApp', '+91 9898989898', '', 1, 0, '2024-11-20 19:39:07'),
(26, 10, 10, 'whatsapp', 'WhatsApp', '+57 3636363636', '', 2, 0, '2024-11-20 19:41:41'),
(27, 10, 10, 'safe', 'WhatsApp', '+57 6565656565', '', 3, 0, '2024-11-20 19:42:44'),
(28, 1, 25, 'facebook', 'FB', 'fb.com', '', 6, 0, '2024-11-20 19:47:28'),
(29, 10, 25, 'facebook', 'FB', 'fb.com', '', 7, 0, '2024-11-20 19:48:03'),
(30, 9, 9, 'google', 'Google', 'https://www.google.com/', '', 1, 0, '2024-11-20 19:58:36'),
(31, 10, 25, 'facebook', 'FB', 'fb.com', '', 8, 0, '2024-11-20 20:06:31'),
(32, 10, 25, 'facebook', 'FB', 'fb.com', '', 9, 0, '2024-11-21 11:25:08'),
(33, 2, 2, 'phone', 'Phone', '+57 5856485319', '', 3, 0, '2024-11-21 12:11:48'),
(34, 10, 10, 'whatsapp', 'WhatsApp', '+57 9696969699', '', 4, 0, '2024-11-21 13:10:53'),
(35, 10, 10, 'slack', 'Slack', 'testtest', '', 5, 0, '2024-11-21 19:54:52'),
(36, 28, 25, 'facebook', 'FB', 'fb.com', '', 10, 0, '2024-11-22 12:08:47'),
(37, 10, 10, 'youtube', 'Youtube', 'test', '', 6, 0, '2024-11-22 12:20:18'),
(38, 10, 10, 'linkedin', 'LinkedIn', 'testtest', '', 7, 0, '2024-11-22 12:20:42'),
(39, 40, 43, 'instagram', 'Instagram', 'gurpreet', '', 1, 0, '2024-11-22 12:38:53'),
(40, 40, 43, 'instagram', 'Instagram', 'ngjfjfjf', '', 2, 0, '2024-11-22 12:51:24');

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

--
-- Table structure for table `user_connects`
--

CREATE TABLE `user_connects` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `account_id` bigint(20) NOT NULL,
  `lat` varchar(255) NOT NULL,
  `lng` varchar(255) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_connects`
--

INSERT INTO `user_connects` (`id`, `user_id`, `account_id`, `lat`, `lng`, `created_on`) VALUES
(1, 1, 1, '', '', '2024-11-15 14:21:04'),
(2, 1, 2, '', '', '2024-11-15 13:31:39'),
(3, 1, 3, '', '', '2024-11-15 14:21:19'),
(4, 9, 9, '', '', '2024-11-20 19:55:00');

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

--
-- Table structure for table `user_devices`
--

CREATE TABLE `user_devices` (
  `tag_id` varchar(255) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `account_id` bigint(20) NOT NULL,
  `tag_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `type` varchar(255) NOT NULL COMMENT 'tag, keyring, card, bluetooth',
  `type_id` int(11) NOT NULL,
  `lock_status` tinyint(1) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_devices`
--

INSERT INTO `user_devices` (`tag_id`, `user_id`, `account_id`, `tag_name`, `type`, `type_id`, `lock_status`, `created_on`) VALUES
('3', 1, 1, '', '', 3, 0, '2024-11-18 17:50:17'),
('4', 1, 1, '', '', 3, 0, '2024-11-15 14:23:25');

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

--
-- Table structure for table `user_device_types`
--

CREATE TABLE `user_device_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_subscription`
--

CREATE TABLE `user_subscription` (
  `id` int(11) NOT NULL,
  `tx_id` varchar(255) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `package_name` varchar(255) NOT NULL COMMENT 'yearly or monthly',
  `source` varchar(255) NOT NULL COMMENT 'ios or android',
  `modified_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_subscription`
--

INSERT INTO `user_subscription` (`id`, `tx_id`, `user_id`, `package_name`, `source`, `modified_on`, `created_on`) VALUES
(2, '1', 1, 'yearly', 'ios', '2024-11-18 11:34:43', '2024-11-18 11:34:43');

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

--
-- Table structure for table `user_subscription_log`
--

CREATE TABLE `user_subscription_log` (
  `id` int(11) NOT NULL,
  `tx_id` varchar(255) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `source` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_subscription_log`
--

INSERT INTO `user_subscription_log` (`id`, `tx_id`, `user_id`, `package_name`, `source`, `data`, `created_on`) VALUES
(1, '1', 1, 'yearly', 'ios', '', '2024-11-18 18:17:36'),
(2, '1', 1, 'yearly', 'ios', '', '2024-11-18 18:20:58'),
(3, '1', 1, 'yearly', 'android ', '', '2024-11-18 18:21:16'),
(4, '1', 1, 'yearly', 'ios', '', '2024-11-18 18:21:41'),
(5, '1', 1, 'yearly', 'ios', '', '2024-11-18 18:34:43');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`account_id`);

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

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

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

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

--
-- Indexes for table `app_icons`
--
ALTER TABLE `app_icons`
  ADD UNIQUE KEY `slug` (`slug`);

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

--
-- Indexes for table `connect_cat_relations`
--
ALTER TABLE `connect_cat_relations`
  ADD PRIMARY KEY (`connect_id`,`cat_id`);

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

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

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

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

--
-- Indexes for table `track_details`
--
ALTER TABLE `track_details`
  ADD PRIMARY KEY (`account_id`);

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

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

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

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

--
-- Indexes for table `user_devices`
--
ALTER TABLE `user_devices`
  ADD UNIQUE KEY `tag_id` (`tag_id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `account_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `account_tap`
--
ALTER TABLE `account_tap`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `advertisement`
--
ALTER TABLE `advertisement`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `app_clicks`
--
ALTER TABLE `app_clicks`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `device_tap`
--
ALTER TABLE `device_tap`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `user_apps`
--
ALTER TABLE `user_apps`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `user_connects`
--
ALTER TABLE `user_connects`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `track_details`
--
ALTER TABLE `track_details`
  ADD CONSTRAINT `fk_account_id` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`account_id`);
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 */;
