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


-- Dumping structure for table digital_vc.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 digital_vc.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table digital_vc.forms
CREATE TABLE IF NOT EXISTS `forms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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(255) DEFAULT NULL,
  `photo_8` varchar(255) DEFAULT NULL,
  `photo_9` varchar(255) DEFAULT NULL,
  `profile_upload` varchar(255) DEFAULT NULL,
  `video_1` varchar(255) DEFAULT NULL,
  `video_2` varchar(255) DEFAULT NULL,
  `video_3` varchar(255) DEFAULT NULL,
  `video_4` varchar(255) DEFAULT NULL,
  `file_1` varchar(255) DEFAULT NULL,
  `email_id` varchar(255) DEFAULT NULL,
  `designation` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci 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) CHARACTER SET latin1 COLLATE latin1_swedish_ci 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,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_vendor_id` (`vendor_id`),
  CONSTRAINT `fk_vendor_id` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

-- Dumping data for table digital_vc.forms: ~7 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`, `photo_9`, `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`, `url`) VALUES
	(11, 'Renu Thakur', 'Rayer Services', 'RayerServices', '66a0f013d3277.jpg', '66a0f015568a3.png', '669fa7012ba1b.png', '669fa70136eeb.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'www.youtube.com', 'www.youtube.com', NULL, NULL, NULL, 'renuthkr12@gmail.com', 'Teacher', '9819861079', 'https://www.facebook.com/uditsolutions', 'https://www.rayerdigitalmarketing.com', 'https://www.instagram.com/rayerservices/', NULL, NULL, NULL, '8928996469', '<p><span style="color: rgb(37, 42, 44); font-family: Nunito, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 600; 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; float: none; display: inline !important; font-size: 18px;">As one of leading digital marketing agencies in Vasai, Mumbai, our mission is to empower businesses with the right digital marketing strategies and solutions that drive growth, enhance online presence, and connect brands with their target audience effectively. With a team of passionate and skilled professionals, we are committed to delivering innovative and result-driven solutions tailored to meet the unique needs of each client.</span></p><p><span style="color: rgb(37, 42, 44); font-family: Nunito, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 600; 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; float: none; display: inline !important; font-size: 18px;">Visit&nbsp;<a href="https://www.rayerdigitalmarketing.com">Website</a></span></p><p><span style="color: rgb(37, 42, 44); font-family: Nunito, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 600; 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; float: none; display: inline !important; font-size: 18px;">SERVICES</span></p><ul style="list-style-type: circle;"><li><span style="color: rgb(37, 42, 44); font-family: Nunito, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 600; 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; float: none; display: inline !important; font-size: 18px;">WEBSITE </span></li><li><span style="color: rgb(37, 42, 44); font-family: Nunito, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 600; 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; float: none; display: inline !important; font-size: 18px;">SOFTWARE</span></li><li><span style="color: rgb(37, 42, 44); font-family: Nunito, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 600; 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; float: none; display: inline !important; font-size: 18px;">GRAPHICS<br></span><br></li></ul><br>', '2025-07-21', 1, 1, '2024-07-21 05:04:04', '2024-08-13 01:50:39', 8, 'https://shorturl.at/qzWVE', _binary 0x363661303938313762366434342e706e67, '9767169605@hdfc', 'null', 2, '#bc6f13', NULL, NULL, NULL, NULL, NULL),
	(20, 'Test user', 'Testings', 'Testings', '66a79d5294419.jpg', '66a79d5294ab0.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'renuthkr12@gmail.com', NULL, '9819861079', NULL, 'https://www.rayerdigitalmarketing.com', NULL, NULL, NULL, NULL, '8928996469', '<p>Test test</p>', '2025-07-29', 1, 1, '2024-07-29 11:46:58', '2024-07-29 11:49:24', NULL, NULL, NULL, NULL, NULL, 1, '#000000', NULL, NULL, NULL, NULL, NULL),
	(21, 'Test akshay', 'UD IT Solution', 'UDITSolution', '66b9e206a5d97.png', '66b9e206a6ebd.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'test3@gmail.com', 'Developer', '9900044442', NULL, 'uditsolutions.in', NULL, NULL, NULL, NULL, '9900044442', '<p>nasafsda sdgfs</p>', '2025-08-12', 1, 1, '2024-08-12 08:20:54', '2024-08-12 11:21:41', NULL, NULL, NULL, NULL, NULL, 1, '#000000', NULL, NULL, NULL, NULL, NULL),
	(23, 'test4', 'UD IT Solution', 'UDITSolution', '66b9e690e3403.png', '66b9e690e3761.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'test4@gmail.com', NULL, '9900044434', NULL, 'uditsolutions.in', NULL, NULL, NULL, NULL, '9900044434', '<p>fddfh dgfd</p>', '2025-08-12', 0, 1, '2024-08-12 08:40:16', '2024-08-12 08:40:16', NULL, NULL, NULL, NULL, NULL, 2, '#309e84', NULL, NULL, NULL, NULL, NULL),
	(24, 'test5', 'UD IT Solution', 'UDITSolution', '66b9e878423e7.jpg', '66b9e878428be.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'test5@gmail.com', NULL, '9900044466', NULL, 'uditsolutions.in', NULL, NULL, NULL, NULL, '9900044466', '<p>dsgsfdg</p>', '2025-08-12', 1, 1, '2024-08-12 08:48:24', '2024-08-12 11:21:34', NULL, NULL, NULL, NULL, NULL, 1, '#683131', NULL, NULL, NULL, NULL, NULL),
	(25, 'test7', 'UD IT Solution', 'UDITSolution', '66b9ec6dd832f.jpg', '66b9ec6dd8818.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'test7@gmail.com', NULL, '9900044499', NULL, 'uditsolutions.in', NULL, NULL, NULL, NULL, '9900044499', '<p>ffdh</p>', '2025-08-12', 1, 1, '2024-08-12 09:05:17', '2024-08-30 10:11:41', NULL, NULL, NULL, NULL, 'null', 3, '#218260', 25, NULL, NULL, NULL, NULL),
	(26, 'ts', 'test Companey', 'testCompaney', '66c7fe87bbfcc.jpeg', '66c7fe893881a.jpeg', '66c7fe87d4bfe.jpeg', '66c7fe8817428.jpeg', '66c7fe884dfe8.jpeg', '66c7fe8886d41.jpeg', '66c7fe88bd527.jpeg', '66c7fe88f3f6e.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '66c7fe896f2f1.pdf', 'admin@gmail.com', 'tesf', '5642563596', 'https://speedzza.in/digitalcardadmin/#/admin/visiting-card', 'https://speedzza.in/digitalcardadmin/#/admin/visiting-card', 'https://speedzza.in/digitalcardadmin/#/admin/visiting-card', 'https://speedzza.in/digitalcardadmin/#/admin/visiting-card', 'https://speedzza.in/digitalcardadmin/#/admin/visiting-card', 'https://speedzza.in/digitalcardadmin/#/admin/visiting-card', '5642563596', '<p>dfs</p>', '2025-08-23', 0, 1, '2024-08-23 01:14:18', '2024-08-23 01:14:18', NULL, 'https://speedzza.in/digitalcardadmin/#/admin/visiting-card', _binary 0x363663376665386137353235392e6a706567, 'ffs', 'https://speedzza.in/digitalcardadmin/#/admin/visiting-card', 1, '#913737', 26, NULL, NULL, NULL, NULL);

-- Dumping structure for table digital_vc.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 digital_vc.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` text,
  `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=15 DEFAULT CHARSET=latin1;

-- Dumping data for table digital_vc.vendors: ~1 rows (approximately)
INSERT INTO `vendors` (`id`, `name`, `email`, `logo`, `mobile_number`, `url`, `created_at`, `updated_at`) VALUES
	(8, 'Rayer Services', 'rayer@test.com', '66a09446b607d.png', '9819861079', 'https://speedzza.in/digitalcard/#/rayer-services', '2024-07-19 18:35:18', '2024-07-24 03:42:30');

