-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------


-- Dumping structure for table uditsolutions_digital_vc_company.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs`
(
    `id`         bigint unsigned                                               NOT NULL AUTO_INCREMENT,
    `uuid`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci         NOT NULL,
    `queue`      text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci         NOT NULL,
    `payload`    longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci     NOT NULL,
    `exception`  longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci     NOT NULL,
    `failed_at`  timestamp                                                     NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- Dumping data for table uditsolutions_digital_vc_company.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table uditsolutions_digital_vc_company.forms
CREATE TABLE IF NOT EXISTS `forms`
(
    `id`                 int          NOT NULL,
    `name`               varchar(255) NOT NULL,
    `company_name`       varchar(255)          DEFAULT NULL,
    `company_name_url`   varchar(250)          DEFAULT NULL,
    `photo`              varchar(255)          DEFAULT NULL,
    `logo`               varchar(255)          DEFAULT NULL,
    `photo_1`            varchar(255)          DEFAULT NULL,
    `photo_2`            varchar(255)          DEFAULT NULL,
    `photo_3`            varchar(255)          DEFAULT NULL,
    `photo_4`            varchar(255)          DEFAULT NULL,
    `photo_5`            varchar(255)          DEFAULT NULL,
    `photo_6`            varchar(255)          DEFAULT NULL,
    `photo_7`            varchar(100)          DEFAULT NULL,
    `photo_8`            varchar(100)          DEFAULT NULL,
    `banner`             varchar(100)          DEFAULT NULL,
    `profile_upload`     varchar(255)          DEFAULT NULL,
    `video_1`            varchar(255)          DEFAULT NULL,
    `video_2`            varchar(255)          DEFAULT NULL,
    `video_3`            varchar(200)          DEFAULT NULL,
    `video_4`            varchar(200)          DEFAULT NULL,
    `file_1`             varchar(255)          DEFAULT NULL,
    `email_id`           varchar(255)          DEFAULT NULL,
    `designation`        varchar(255)          DEFAULT NULL,
    `mobile_number`      varchar(21)           DEFAULT NULL,
    `facebook_link`      varchar(255)          DEFAULT NULL,
    `website_link`       varchar(255)          DEFAULT NULL,
    `instagram_link`     varchar(255)          DEFAULT NULL,
    `linkedin_link`      varchar(255)          DEFAULT NULL,
    `twitter_link`       varchar(255)          DEFAULT NULL,
    `youtube_link`       varchar(255)          DEFAULT NULL,
    `phone_number`       varchar(255)          DEFAULT NULL,
    `short_description`  text,
    `expiry_date`        date                  DEFAULT NULL,
    `is_approved`        tinyint               DEFAULT NULL,
    `status`             tinyint      NOT NULL DEFAULT '1',
    `created_at`         timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`         timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `vendor_id`          int                   DEFAULT NULL,
    `google_review_link` varchar(250)          DEFAULT NULL,
    `payment_qr_code`    longblob,
    `payment_upi_id`     text,
    `payment_link`       varchar(250)          DEFAULT NULL,
    `template_id`        int                   DEFAULT NULL,
    `color_code`         text,
    `user_id`            int                   DEFAULT NULL,
    `location`           varchar(300)          DEFAULT NULL,
    `address`            text,
    `services`           varchar(200)          DEFAULT NULL
) ENGINE = InnoDB
  DEFAULT CHARSET = latin1;

-- Dumping data for table uditsolutions_digital_vc_company.forms: ~9 rows (approximately)
INSERT INTO `forms` (`id`, `name`, `company_name`, `company_name_url`, `photo`, `logo`, `photo_1`, `photo_2`, `photo_3`,
                     `photo_4`, `photo_5`, `photo_6`, `photo_7`, `photo_8`, `banner`, `profile_upload`, `video_1`,
                     `video_2`, `video_3`, `video_4`, `file_1`, `email_id`, `designation`, `mobile_number`,
                     `facebook_link`, `website_link`, `instagram_link`, `linkedin_link`, `twitter_link`, `youtube_link`,
                     `phone_number`, `short_description`, `expiry_date`, `is_approved`, `status`, `created_at`,
                     `updated_at`, `vendor_id`, `google_review_link`, `payment_qr_code`, `payment_upi_id`,
                     `payment_link`, `template_id`, `color_code`, `user_id`, `location`, `address`, `services`)
VALUES (1, 'Kiran Patil', 'Kiran Facility Management Services', 'Testings', '66b65de3beafc.jpg', '66b65de3bf848.jpg',
        '66b65de3beed9.jpg', '66b65de3bf082.png', '66b65de3bf2ca.jpg', '66b65de3bf5a1.jpg', NULL, NULL, NULL, NULL,
        NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'renuthkr12@gmail.com', NULL, '9819861079',
        'https://www.facebook.com/prasadjoglekar1', 'https://www.rayerdigitalmarketing.com',
        'https://www.instagram.com/finkeysenterprisellp/', NULL, 'https://x.com/home', NULL, '8928996469',
        '<p>Go contactless in 3 easy steps!<br>Forget about reprinting and sharing thousands of business cards. MDVC NFC enabled  cards are a new and eco friendly approach that allow you to share your contact details, socials etc. into any other smartphone just in single tap</p>',
        '2025-07-29', 1, 1, '2024-07-29 11:46:58', '2024-10-05 05:49:27', NULL, 'https://g.co/kgs/VEY2BZ4', NULL, NULL,
        'null', 3, '#de1c1c', NULL, NULL, NULL, NULL),
       (2, 'Prasad Joglekar', 'Finkeys Enterprise LLP', 'FinkeysEnterpriseLLP', '66b65cf061dbf.jpg',
        '66b6574639596.jpg', '66d080202e21e.jpg', '66d080202e52c.jpg', '66d080202e786.jpg', '66d080202ea7b.jpg', NULL,
        NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'prasad@finkeys.in', 'Co Founder', '9869326999',
        'https://www.facebook.com/finkeysenterprises', 'https://finkeys.in/',
        'https://www.instagram.com/finkeysenterprisellp/', NULL, 'https://x.com/home', NULL, '9869326999',
        '<p><span style="color: rgb(0, 0, 0); font-family: Montserrat, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 500; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">We are expert financial advisors based in Mumbai &amp; Ratnagiri  committed to helping individuals and businesses to achieve their financial goals. With a deep understanding of both local and global markets,Finkeys offer tailored solutions that cater to diverse financial needs.We believe thoroughly in the value created by investing, with the objectives of safety of capital, beating risk free, benchmark returns and creation of long term wealth depending upon the needs and objectives of the clients.</span></p>',
        '2025-08-09', 1, 1, '2024-08-09 07:02:13', '2024-10-05 05:49:28', NULL, 'https://g.co/kgs/VEY2BZ4',
        _binary 0x363662363536376464343163622e706e67, NULL, 'null', 2, '#a8d9ed', NULL, NULL, NULL,
        '<p>Mutul Funds - Mutul Fund Investmants</p><p>SIP - SIP investments</p><p>Retirement Funds</p>'),
       (3, 'Neerav Mehta', 'Hanks International', 'HanksInternational', '66d0884d9ddc9.jpg', '66d0884d9e115.png',
        '66d9f42c14724.jpg', '66d9f42c14f39.jpg', '66d9f42c15234.jpg', NULL, NULL, '66d088ae5f5fa.png', NULL, NULL,
        '172682507066ed426eaf527.png', NULL, 'https://www.hanksinternational.com/images/gallery/Kervi%20Tank.mp4',
        'https://www.hanksinternational.com/images/gallery/Rashmi%20Jamwal.mp4', NULL, NULL, '66b6620d7d8f1.pdf',
        'info@hanksinternational.com', 'Founder', '9892213145', 'https://www.facebook.com/neerav.kanan?mibextid=ZbWKwL',
        'https://www.hanksinternational.com/', 'https://www.instagram.com/neerav.kanan?igsh=MXM3Mmx5ZGg4dGN5MQ%3D%3D',
        NULL, NULL, NULL, '9892213145',
        '<p>As a dedicated Health &amp; Wellness Coach, I am passionate about guiding individuals on their journey to optimal well-being. With a holistic approach that encompasses physical health, mental clarity, and emotional balance, I empower clients to achieve sustainable&nbsp; weightloss.</p>',
        '2025-08-09', 1, 1, '2024-08-09 13:03:05', '2024-10-05 05:49:31', NULL, NULL,
        _binary 0x363664303963373862623736362e6a706567, '9892213145@indianbank', 'null', 4, '#20bb53', NULL,
        'https://www.google.com/maps/search/+Platinum+Tower,+Charkop+Sajawat++CHSL+Plot+No+32,+RSC+19+X+20,++Sector+8,+Charkop,+Kandiwali(West)/@19.2130979,72.8167477,17z?entry=ttu&g_ep=EgoyMDI0MDgyNi4wIKXMDSoASAFQAw%3D%3D',
        '701, Platinum Tower, Charkop Sajawat  CHSL Plot No 32, RSC 19 X 20,  Sector 8, Charkop, Kandiwali(West)',
        '<ul><li><strong>Personalized Wellness Plans</strong></li><li><strong>Nutrition Coaching&nbsp;</strong><strong></strong></li><li><strong>Boot Camps</strong></li></ul>'),
       (4, 'Renu Thakur', 'Rayer', 'Rayer', '66fecc7fa9c3e.jpg', '66fecc7faa143.png', NULL, NULL, NULL, NULL, NULL,
        '66d7142c3bcf8.png', NULL, NULL, '172797458166feccb58994b.png', NULL, NULL, NULL, NULL, NULL, NULL,
        'renuthkr12@gmail.com', NULL, '9819861079', NULL, 'https://www.rayerdigitalmarketing.com', NULL, NULL, NULL,
        NULL, '8928996469', NULL, '2025-08-23', 1, 1, '2024-08-23 07:46:46', '2024-10-05 05:49:34', 8, NULL, NULL, NULL,
        NULL, 5, '#c31717', 21, 'null', 'M 602,Panchsheel Garden, Mahavir Nagar', NULL),
       (5, 'Ushma Baria', 'BARIA\'S CREATIONS (OPC) PRIVATE LIMITED', 'BARIA\'SCREATIONS(OPC)PRIVATELIMITED',
        '66c8bcc0bf71a.jpg', '66d59d88164a4.png', NULL, NULL, NULL, NULL, NULL, '66d707bfda7a4.jpg', NULL, NULL,
        '172683044266ed576a33b02.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 'bariascreation@gmail.com', 'Founder',
        '9820451603', 'https://www.facebook.com/profile.php?id=100064941662261', 'www.bariascreation.com',
        '@bariascreation', 'www.linkedin.com/in/ushmabaria', NULL, '@ushmabaria', '9326010207',
        '<p><span style="color: rgb(0, 0, 255); font-family: Roboto, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">Ushma Baria is a highly talented artist and designer who specializes in creating unique paintings and home decor items that reflect the culture and beauty of India. With over 25 years of experience in various industries, Ushma has honed her passion for art and design, resulting in the establishment of her own company, Baria’s Creation</span>.</p>',
        '2025-08-23', 1, 1, '2024-08-23 11:15:52', '2024-10-05 05:49:36', 8, 'https://g.page/r/CUItfVLaml9oEAE/review',
        _binary 0x363663386263633063306539362e6a706567, 'ushma.baria-2@okhdfcbank', NULL, 4, 'null', 25, 'null',
        'D-601 Antartica Lodha Aqua CHS',
        '<p>Sri Yantra</p><p>Lippan Art</p><p>Mosaic Art</p><p>Glass Paintings</p><p>Mandala Art</p><p>Home Decor Items</p><p>Corporate Gifting</p>'),
       (6, 'Pradip', 'UD IT Solutions', 'rayerservice', '66ea6638710dd.jpg', '66ea66387d644.jpg', NULL, NULL, NULL,
        NULL, NULL, NULL, NULL, NULL, '172674760866ec13d84ca56.jpg', NULL, NULL, NULL, NULL, NULL, NULL,
        'udit9solutions123@gmail.com', NULL, '9869326999', NULL, 'https://uditsolutions.in/', NULL, NULL, NULL, NULL,
        '9819441334', '<p>null</p>', '2025-09-18', 1, 1, '2024-09-18 00:03:44', '2024-10-05 05:49:38', NULL, NULL, NULL,
        NULL, NULL, 4, 'null', 39, '123', '123', '<p>null</p>'),
       (7, 'Sachin Naik', 'Finkeys Enterprise LLP', 'FinkeysEnterprise-SachinNaik', '66ed69f4cd077.jpg',
        '66ed69f4d99e8.jpg', '66ed787a4218f.jpeg', '66ed787a44461.jpg', '66ed787a451d9.jpg', '66ed787a455d3.jpg',
        '66ed787a45c40.jpg', '66ed787a4627a.jpg', '66ed787a466a3.jpg', NULL, '172709848566f16e756248d.jpg', NULL,
        'https://www.facebook.com/reel/862419805792430',
        'https://www.facebook.com/finkeysenterprises/videos/7583099001795859',
        'https://www.facebook.com/reel/509464985113295',
        'https://www.facebook.com/finkeysenterprises/videos/524273110113842', NULL, 'sachin@finkeys.in', 'Co Founder',
        '8369828241', 'https://www.facebook.com/finkeysenterprises', 'https://finkeys.in',
        'https://www.instagram.com/finkeysenterprisellp/',
        'https://in.linkedin.com/in/sachin-naik-qpfp%C2%AE-ab199715?trk=people-guest_people_search-card',
        'https://x.com/Finkeys220714', NULL, '8369828241',
        '<p>At Finkeys , we are dedicated to empowering individuals  with tailored financial solutions. As expert financial planners , we offer a comprehensive range of services including investment management, retirement planning, tax advisory, and wealth preservation strategies. Our commitment to understanding your unique needs ensures that we deliver effective, customized solutions to help you achieve your financial goals.</p>',
        '2025-09-20', 1, 1, '2024-09-20 03:46:54', '2024-10-05 05:49:39', NULL,
        'https://www.google.com/search?q=finkeys+enterprise+llp&oq=finkeys&aqs=chrome.1.69i60j69i59j0i10i512j69i57j0i10i512j69i60l3.4996j0j7&sourceid=chrome&ie=UTF-8#lrd=0x3be7b75c10bbc713:0xc7516f156bfe09af,3,,,,',
        NULL, NULL, NULL, 4, 'null', 40,
        'https://www.google.com/maps/dir/19.3964922,72.8869927/finkeys+enterprise+llp/@19.3101506,72.7932892,12z/data=!3m1!4b1!4m9!4m8!1m1!4e1!1m5!1m1!1s0x3be7b75c10bbc713:0xc7516f156bfe09af!2m2!1d72.8466725!2d19.2173977?entry=ttu&g_ep=EgoyMDI0MDkxNi4wIKXMDSoASAFQAw%3D%3D',
        'Orley CHS, B-004, Om Shree Geetanjali Nagar, Saibaba Nagar, Borivali West, Mumbai, Maharashtra 400092',
        '<p>Mutul Funds</p><p>Capital Market</p><p>Fixed Income</p><p>PMS &amp; AIFS</p><p>Insurance</p><p>SIP Investment&nbsp;</p><p>Income Tax Return &amp; Filling</p><p>Estate Planning</p>'),
       (8, 'Remi', 'T3r', 'Ter', '66f65504625b9.jpeg', '66f65504632b9.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL,
        NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'info@tec.com', NULL, '9876998776', NULL, NULL, NULL, NULL,
        NULL, NULL, '9876998776', NULL, '2025-09-27', 0, 1, '2024-09-27 01:17:32', '2024-10-05 05:49:41', 8, NULL, NULL,
        NULL, 'undefined', 5, NULL, 42, NULL, NULL, NULL),
       (9, 'Ankit parmar', 'Rushabh jewellers', 'Myvisisitingcard', '66f7d07a71851.jpg', '66f7d07a7d9d0.jpg', NULL,
        NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
        'rushabhjewellers25@gmail.com', 'Owner', '9773164684', NULL,
        'https://www.instagram.com/rushabhjewellers_rj?igsh=MXMxYXd4eW9penlwNQ==',
        'https://www.instagram.com/rushabhjewellers_rj?igsh=MXMxYXd4eW9penlwNQ==', NULL, NULL, NULL, '9892999757', NULL,
        '2025-09-28', 0, 1, '2024-09-28 04:16:34', '2024-10-05 05:49:43', 8,
        'https://www.app.easetap.com/ocznsh?preview=true', _binary 0x363666376430376138343833632e706e67, NULL,
        'undefined', 1, '#ff0000', 43, NULL, 'Shop no 6/a, natraj market, sainath road, malad west',
        '<p>Jewellery showroom&nbsp;</p>');

-- Dumping structure for table uditsolutions_digital_vc_company.migrations
CREATE TABLE IF NOT EXISTS `migrations`
(
    `id`        int unsigned                                                  NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch`     int                                                           NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

-- Dumping structure for table uditsolutions_digital_vc_company.vendors
CREATE TABLE IF NOT EXISTS `vendors`
(
    `id`            int          NOT NULL AUTO_INCREMENT,
    `name`          varchar(255) NOT NULL,
    `email`         varchar(255) NOT NULL,
    `logo`          varchar(255)          DEFAULT NULL,
    `mobile_number` varchar(20)  NOT NULL,
    `url`           varchar(100)          DEFAULT NULL,
    `created_at`    timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at`    timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `email` (`email`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 13
  DEFAULT CHARSET = latin1;

-- Dumping data for table uditsolutions_digital_vc_company.vendors: ~8 rows (approximately)
INSERT INTO `vendors` (`id`, `name`, `email`, `logo`, `mobile_number`, `url`, `created_at`, `updated_at`)
VALUES (1, 'tester', 'tetser@gmail.com', NULL, '', NULL, '2023-12-19 08:04:55', '2023-12-19 08:04:55'),
       (2, 'UD IT Solutions', 'udit9solutions@gmail.com', '65742614b0955.png', '7977731361', NULL,
        '2023-12-09 08:32:20', '2024-10-05 05:50:04'),
       (3, 'Prodigy Designs', 'prodigyartdesigns@gmail.com', '65746129a076d.png', '8879222897', NULL,
        '2023-12-09 12:44:25', '2024-10-05 05:50:05'),
       (4, 'Deep Digital', 'vendor1@gmail.com', '/tmp/phpsQO5PZ', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-one', '2024-09-03 07:29:43', '2024-10-05 05:50:06'),
       (5, 'Vendor Two', 'vendor2@gmail.com', '/tmp/phplFb4Sg', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-two', '2024-09-03 07:31:33', '2024-10-05 05:50:08'),
       (6, 'Vendor Three', 'vendor3@gmail.com', 'null', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-three', '2024-09-03 07:35:12', '2024-10-05 05:50:10'),
       (7, 'Vendor Four', 'vendor4@gmail.com', 'null', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-four', '2024-09-03 07:35:30', '2024-10-05 05:50:12'),
       (8, 'Vendor Five', 'vendor5@gmail.com', 'null', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-five', '2024-09-03 07:35:45', '2024-10-05 05:50:14');

