-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `elephant_digital_vc`
--

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs`
(
    `id`         bigint UNSIGNED                         NOT NULL,
    `uuid`       varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text COLLATE utf8mb4_unicode_ci         NOT NULL,
    `queue`      text COLLATE utf8mb4_unicode_ci         NOT NULL,
    `payload`    longtext COLLATE utf8mb4_unicode_ci     NOT NULL,
    `exception`  longtext COLLATE utf8mb4_unicode_ci     NOT NULL,
    `failed_at`  timestamp                               NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

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

--
-- Table structure for table `forms`
--

CREATE TABLE `forms`
(
    `id`                 int          NOT NULL,
    `name`               varchar(255) NOT NULL,
    `company_name`       varchar(255)          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,
    `email_id`           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,
    `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` text,
    `payment_qr_code`    longblob,
    `payment_upi_id`     text,
    `template_id`        int                   DEFAULT NULL,
    `color_code`         int                   DEFAULT NULL
) ENGINE = InnoDB
  DEFAULT CHARSET = latin1;

--
-- Dumping data for table `forms`
--

INSERT INTO `forms` (`id`, `name`, `company_name`, `photo`, `logo`, `photo_1`, `photo_2`, `photo_3`, `photo_4`,
                     `photo_5`, `email_id`, `mobile_number`, `facebook_link`, `website_link`, `instagram_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`,
                     `template_id`, `color_code`)
VALUES (1, 'UDIT TAKWANI', 'UD IT SOLUTIONS', '65771e83cd1c2.jpeg', '65771e841bc3e.png', NULL, NULL, NULL, NULL, NULL,
        'udit9solutions@gmail.com', '7977731361', 'https://www.facebook.com/uditsolutions', 'uditsolutions.in',
        'https://www.instagram.com/uditsolutions.in/', '9819441334',
        'We provide exclusive IT solutions in the areas of software design and development. We provide professional web design solutions that suit our clients. We provide the next-generation technology solutions that set standards for industrial expertise, innovative creations, and global-scale quality. UD IT Solutions is involved in software publishing, consultancy, and supply. We also provide maintenance and refurbishing of the existing or new application or website. We are the best website development company in Mumbai.',
        '2024-12-11', 1, 1, '2023-12-11 00:00:00', '2023-12-11 00:00:00', 6, NULL, NULL, NULL, NULL, NULL),
       (3, 'tester12', 'tester', 'tester', 'tesre', NULL, NULL, NULL, NULL, NULL, '#dd2ddb', '1234567890',
        'www.instagram.com', 'www.instagram.com', 'https://www.instagram.com/', '1234567890', 'NA', '2023-12-27', 1, 1,
        '2023-12-19 00:00:00', '2024-07-13 02:17:22', 1, NULL, NULL, NULL, NULL, NULL),
       (4, 'tester', 'tester', 'tester', 'tesre', NULL, NULL, NULL, NULL, NULL, NULL, '1234567890', 'www.instagram.com',
        'www.instagram.com', NULL, '1234567890', NULL, '2023-12-27', 0, 0, '2023-12-19 00:00:00', '2023-12-19 00:00:00',
        1, NULL, NULL, NULL, NULL, NULL),
       (5, 'UDIT TAKWANI', 'UD IT SOLUTIONS', '665eecab4f31c.jpeg', '665eecad4baf5.png', '665eecab4fd65.jpeg',
        '665eecabb507a.jpeg', '665eecac8442f.jpeg', NULL, NULL, 'udit9solutions@gmail.com', '7977731361',
        'https://www.facebook.com/uditsolutions', 'uditsolutions.in', 'https://www.instagram.com/uditsolutions.in/',
        '9819441334',
        'We provide exclusive IT solutions in the areas of software design and development. We provide professional web design solutions that suit our clients. We provide the next-generation technology solutions that set standards for industrial expertise, innovative creations, and global-scale quality. UD IT Solutions is involved in software publishing, consultancy, and supply. We also provide maintenance and refurbishing of the existing or new application or website. We are the best website development company in Mumbai.',
        '2025-06-04', 1, 1, '2024-06-04 08:30:05', '2024-06-04 08:38:29', NULL, NULL, NULL, NULL, NULL, NULL),
       (6, 't', 'test', '665eee9110628.jpeg', '665eee91285f5.jpeg', NULL, NULL, NULL, NULL, NULL, 't@gmail.com', 'tt',
        't', 't', 'tt', 't', 'sfg', '2025-06-04', 0, 1, '2024-06-04 08:38:09', '2024-06-04 08:38:09', NULL, NULL, NULL,
        NULL, NULL, NULL),
       (7, 'Tejas Dave', 'Libra valuers', '6667fe21affb3.png', '6667fe21bfded.png', NULL, NULL, NULL, NULL, NULL,
        'tejas.dave@libravaluers.com', '9769070154', 'https://www.facebook.com/people/Libra-Valuers/61559063691029/',
        'https://libravaluers.com/', 'https://www.instagram.com/libravaluers/?hl=en', '9769070154',
        'Libra Valuers offers services principally in the areas of real estate valuation and real estate advisory services. Libra Valuers has been established by Tejas Dave-MRICS with extensive knowledge of the Indian property market.\r\n\r\nTejas Dave has experienced Real estate Professional with more than 17 yrs in valuation practice across India. Acquired experience including in Construction finance , mortgage valuation, project appraisal , Builder approvals, project execution, feasibility studies for various developments, special property valuations, Technical due diligence exercise, Mass valuation, NPA portfolio valuation, Real estate research along with managing portfolio across india. He has working with leading banks & HFC as Head of Asset valuation department.\r\n\r\nHas exceptional networking and mentoring skills coupled with experience in managing high performance teams, associate with Shivaji university-Maharashtra as mentor to students for different real estate research projects in the master of valuation in real estate course.',
        '2025-06-11', 1, 1, '2024-06-11 05:34:58', '2024-06-11 05:38:13', 6, NULL, NULL, NULL, NULL, NULL),
       (8, 'CA Nishant Ruparel', 'NKRM/NK Ruparel', '666ab2c6e0b53.webp', '666ab2c6e0e48.webp', NULL, NULL, NULL, NULL,
        NULL, 'nishant@nkruparel.com', '98206 52813', 'www.facebook.com/NKRUPAREL', 'https://nkruparel.com/',
        'www.instagram.com/nkruparelandcompany', '98206 52813',
        'N K Ruparel and Company is a dynamic young company. Founded in 2012 by Chartered Accountant CA Nishant Ruparel, the firm focuses on all solutions related to statutory and legal compliances.\r\nWe, N K Ruparel & Company, are a professionally managed Chartered Accountancy Firm operating from Mumbai, India. Our expertise lies in offering highly reliable Consultancy solutions involving Virtual CFO Service, Indirect Tax, Direct Tax, Company Law, and Accounting Services. Further, we also deal in services involving Company Registration in India, FEMA Matters, Advice on Joint Ventures, LLP Registration, Import Export Code, International Taxation, Management Consultancy and due diligence Services etc.',
        '2025-06-13', 1, 1, '2024-06-13 06:50:14', '2024-06-13 07:01:05', 6, NULL, NULL, NULL, NULL, NULL),
       (9, 'Deep Kapadia', 'Einz Consultancy', '668915a2b58d2.jpg', '668915a2b6039.jpg', NULL, NULL, NULL, NULL, NULL,
        'einzconsultancy@gmail.com', '98216 21766', 'https://www.facebook.com/einz.deepkapadia?fref=ts',
        'https://franchiseesale.com/', 'https://www.instagram.com/einzconsultancy1', '+91 98216 21766',
        'The consulting firm which acts as a catalyst to help develop and grow faster.\r\nWe are experts in giving a successful form and shape to Youridea.\r\nPioneers in conceiving, developing & setting up franchisee\r\nWe work on the concept of Visualise & accomplish.\r\nSystematic and strategical approach towards building Your idea.\r\nWe are experts in giving a successful form and shape to YOUR IDEA .',
        '2025-07-06', 1, 1, '2024-07-06 08:00:02', '2024-07-06 08:01:30', NULL, NULL, NULL, NULL, NULL, NULL),
       (10, 'Kamia\'s Communication', 'Kamia\'s Communication', '668d0bbe7c4c6.jpeg', '668d0bbe7d4f1.jpeg', NULL, NULL,
        NULL, NULL, NULL, 'udit9solutions@gmail.com', '98209 25051', 'https://www.facebook.com/uditsolutions/',
        'https://uditsolutions.in/', 'https://www.instagram.com/uditsolutions.in/', '98209 25051', 'Ok', '2025-07-09',
        1, 1, '2024-07-09 08:06:54', '2024-07-09 08:07:23', 6, NULL, NULL, NULL, NULL, NULL),
       (11, 'Udit Takwani 1', 'UD IT Solutions n', '6695eada2b910.jpg', '6695eada4c003.jpg', '6695eada2bf3c.jpg', NULL,
        NULL, '6695eada2c2ec.jpeg', NULL, 'udit9solutions@gmail.com', '7977731361', 'null', 'https://uditsolutions.in/',
        'null', '9819441334',
        'We provide exclusive IT solutions in the areas of software design and development. We provide professional web design solutions that suit our clients. We provide the next-generation technology solutions that set standards for industrial expertise, innovative creations, and global-scale quality. UD IT Solutions is involved in software publishing, consultancy, and supply. We also provide maintenance and refurbishing of the existing or new application or website. We are the best website development company in Mumbai.',
        '2025-07-16', 1, 1, '2024-07-16 01:36:58', '2024-07-16 01:53:46', NULL,
        'https://www.glassdoor.co.in/Reviews/UD-IT-Solutions-Reviews-E4160413.htm',
        0x363639356561646134666436632e6a706567, '7977731361@ybl', 2, 123),
       (12, 'Renu Thakur', 'Rayer Services', '6697a0937b2f8.jpg', '6697a0938a901.jpg', NULL, NULL, NULL, NULL, NULL,
        'udit9solutions@gmail.com', '9324493472', 'https://www.facebook.com/uditsolutions/',
        'https://uditsolutions.in/', 'https://www.instagram.com/uditsolutions.in/', '9324493472', 'na', '2025-07-17', 1,
        1, '2024-07-17 08:44:35', '2024-07-17 08:44:45', NULL, NULL, NULL, NULL, NULL, NULL),
       (13, 'Jay Thakar', 'UD IT Solutions', '66acd5e7215a9.jpeg', '66acd5e7222c0.jpeg', NULL, NULL, NULL, NULL, NULL,
        'udit9solutions@gmail.com', '79777 31361', 'https://www.facebook.com/uditsolutions/',
        'https://uditsolutions.in/', 'https://www.instagram.com/uditsolutions.in/', '79777 31361', 'NA', '2025-08-02',
        1, 1, '2024-08-02 10:49:43', '2024-08-02 10:53:23', 6, NULL, NULL, NULL, NULL, NULL),
       (14, 'Jay Thakar', 'UD IT Solutions', '66acd6ab45b50.jpeg', '66acd6ab45ddc.jpeg', NULL, NULL, NULL, NULL, NULL,
        'udit9solutions@gmail.com', '79777 31361', 'https://www.facebook.com/uditsolutions/',
        'https://uditsolutions.in/', 'https://www.instagram.com/uditsolutions.in/', '79777 31361', 'NA', '2025-08-02',
        0, 1, '2024-08-02 10:52:59', '2024-08-02 10:52:59', NULL, NULL, NULL, NULL, NULL, NULL),
       (15, 'Bharat Takwani', 'Kastabhanjan Traders', '66b09c4e450d3.jpeg', '66b09c4e5d2e4.jpg', NULL, NULL, NULL, NULL,
        NULL, 'udit9solutions@gmail.com', '8169554040', 'https://www.facebook.com/uditsolutions/',
        'https://uditsolutions.in/', 'https://www.instagram.com/uditsolutions.in/', '8169554040', 'na', '2025-08-05', 1,
        1, '2024-08-05 07:33:02', '2024-08-05 07:33:13', NULL, NULL, NULL, NULL, NULL, NULL),
       (16, 'Pradip', 'UD IT Solutions', '66d6dae112fa1.jpg', '66d6dae307b06.jpg', '66d6dae11336c.jpeg',
        '66d6dae1616a5.jpeg', NULL, NULL, '66d6dae231715.jpeg', 'pradip3275@gmail.com', '9767169605',
        'https://www.facebook.com/uditsolutions', 'https://uditsolutions.in/',
        'https://www.instagram.com/uditsolutions.in/', '9819441334', 'NO desc', '2025-09-03', 1, 1,
        '2024-09-03 07:46:11', '2024-09-03 07:47:00', 8, NULL, NULL, NULL, NULL, NULL),
       (17, 'Riday Bhuptani', 'Agri Xport Consultancy', '66fbe178afceb.png', '66fbe178c36c7.png', NULL, NULL, NULL,
        NULL, NULL, 'riday@agrixportconsultancy.com', '9819449477', '######', 'agrixportconsultancy.com', '#######',
        '9819449477', 'N/A', '2025-09-30', 1, 1, '2024-10-01 09:48:08', '2024-10-01 09:48:31', NULL, NULL, NULL, NULL,
        NULL, NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations`
(
    `id`        int UNSIGNED                            NOT NULL,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch`     int                                     NOT NULL
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors`
(
    `id`            int          NOT NULL,
    `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
) ENGINE = InnoDB
  DEFAULT CHARSET = latin1;

--
-- Dumping data for table `vendors`
--

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'),
       (6, 'UD IT Solutions', 'udit9solutions@gmail.com', '65742614b0955.png', '7977731361', NULL,
        '2023-12-09 08:32:20', '2023-12-09 12:47:25'),
       (7, 'Prodigy Designs', 'prodigyartdesigns@gmail.com', '65746129a076d.png', '8879222897', NULL,
        '2023-12-09 12:44:25', '2023-12-09 12:44:25'),
       (8, 'Deep Digital', 'vendor1@gmail.com', '/tmp/phpsQO5PZ', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-one', '2024-09-03 07:29:43', '2024-09-04 06:38:14'),
       (9, 'Vendor Two', 'vendor2@gmail.com', '/tmp/phplFb4Sg', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-two', '2024-09-03 07:31:33', '2024-09-04 06:45:20'),
       (10, 'Vendor Three', 'vendor3@gmail.com', 'null', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-three', '2024-09-03 07:35:12', '2024-09-03 08:02:33'),
       (11, 'Vendor Four', 'vendor4@gmail.com', 'null', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-four', '2024-09-03 07:35:30', '2024-09-03 08:02:47'),
       (12, 'Vendor Five', 'vendor5@gmail.com', 'null', '97654321',
        'https://elephantsoftwares.com/digitalcard/#/vendor-five', '2024-09-03 07:35:45', '2024-09-03 08:03:02');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `forms`
--
ALTER TABLE `forms`
    ADD PRIMARY KEY (`id`),
    ADD KEY `fk_vendor_id` (`vendor_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
    MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `forms`
--
ALTER TABLE `forms`
    MODIFY `id` int NOT NULL AUTO_INCREMENT,
    AUTO_INCREMENT = 18;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
    MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendors`
--
ALTER TABLE `vendors`
    MODIFY `id` int NOT NULL AUTO_INCREMENT,
    AUTO_INCREMENT = 13;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `forms`
--
ALTER TABLE `forms`
    ADD CONSTRAINT `fk_vendor_id` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

