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

START TRANSACTION;



--
-- Database: `pc`
--

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

--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `brand_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `brand`
--

INSERT INTO `brand` (`brand_id`, `title`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'ZERODOLL', 'storage/uploads/brands/1_brand_logo.png', 1, '2023-09-15 11:29:51', '2023-11-23 05:32:17'),
(2, 'ZERODOL- CR', 'storage/uploads/brands/2_brand_logo.png', 1, '2023-09-15 11:32:12', '2023-09-15 11:32:12'),
(3, 'ZERODOL - P', 'storage/uploads/brands/3_brand_logo.png', 1, '2023-09-15 11:32:40', '2023-09-15 11:32:40'),
(4, 'ZERODOL - SP', 'storage/uploads/brands/4_brand_logo.png', 1, '2023-09-15 11:33:03', '2023-09-15 11:33:03'),
(5, 'ZERODOL - TH 4/8 Mg', 'storage/uploads/brands/5_brand_logo.png', 1, '2023-09-15 11:38:44', '2023-09-15 11:38:44'),
(6, 'ZERODOL - TH4', 'storage/uploads/brands/6_brand_logo.png', 1, '2023-09-15 11:39:02', '2023-09-15 11:39:02'),
(7, 'ZERODOL - TH8', 'storage/uploads/brands/7_brand_logo.png', 1, '2023-09-15 11:39:19', '2023-09-15 11:39:19'),
(8, 'ZERODOL TH MAX 4mg', 'storage/uploads/brands/8_brand_logo.png', 1, '2023-09-15 11:39:52', '2023-09-15 11:39:52'),
(9, 'ZERODOL - TH MAX 8mg', 'storage/uploads/brands/9_brand_logo.png', 1, '2023-09-15 11:40:21', '2023-09-15 11:40:21'),
(10, 'ZERODOL - MR', 'storage/uploads/brands/10_brand_logo.png', 1, '2023-09-15 11:41:11', '2023-09-15 11:41:11'),
(11, 'ZERODOL - PT', 'storage/uploads/brands/11_brand_logo.png', 1, '2023-09-15 11:41:41', '2023-09-15 11:41:41'),
(12, 'ZERODOL - SPAS', 'storage/uploads/brands/12_brand_logo.png', 1, '2023-09-15 11:42:00', '2023-09-15 11:42:00'),
(13, 'ZERODOL - GEL', 'storage/uploads/brands/13_brand_logo.png', 1, '2023-09-15 11:42:20', '2023-09-15 11:42:20'),
(14, 'RAPICLAV 375', 'storage/uploads/brands/14_brand_logo.png', 1, '2023-09-15 11:42:36', '2023-09-15 11:42:36'),
(15, 'RAPICLAV 625', 'storage/uploads/brands/15_brand_logo.png', 1, '2023-09-15 11:42:50', '2023-09-15 11:42:50'),
(16, 'RAPICLAV DRY SYP', 'storage/uploads/brands/16_brand_logo.png', 1, '2023-09-15 11:43:10', '2023-09-15 11:43:10'),
(17, 'RAPICLAV FORTE SYP', 'storage/uploads/brands/17_brand_logo.png', 1, '2023-09-15 11:43:39', '2023-09-15 11:43:39'),
(18, 'ZERODOL - PG', 'storage/uploads/brands/18_brand_logo.png', 1, '2023-09-15 13:02:50', '2023-09-15 13:02:50'),
(19, 'Rapiclav 375/625/Forte/Dry Syrup', NULL, 1, '2023-09-15 13:43:26', '2023-09-15 13:43:26'),
(20, 'ZERODOL - S', 'storage/uploads/brands/20_brand_logo.png', 1, '2023-09-16 06:37:12', '2023-09-16 06:37:13'),
(21, 'ZERODOL - SP/S', NULL, 1, '2023-09-16 06:40:54', '2023-09-16 06:40:54'),
(22, 'ZERODOL - MR/TH', NULL, 1, '2023-09-16 06:44:17', '2023-09-16 06:44:17'),
(23, 'ZERODOL - TH/THOD', NULL, 1, '2023-09-16 06:46:38', '2023-09-16 06:46:38'),
(24, 'ZERODOL CR ALL', NULL, 1, '2023-09-16 06:48:46', '2023-09-16 06:48:46'),
(25, 'ZERODOL - TC', NULL, 1, '2023-09-16 15:42:36', '2023-09-16 15:42:36'),
(26, 'Test', NULL, 1, '2023-10-18 10:35:07', '2023-10-18 10:35:07'),
(27, 'Test', 'storage/uploads/brands/27_brand_logo.png', 1, '2023-11-23 05:41:45', '2023-11-23 05:41:45');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` bigint(20) DEFAULT NULL,
  `message` text NOT NULL,
  `file` text 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 `contact_us`
--

INSERT INTO `contact_us` (`id`, `name`, `email`, `mobile`, `message`, `file`, `created_at`, `updated_at`) VALUES
(1, 'Saurabh Patil', 'admin@gmail.com', NULL, 'Test', NULL, '2023-10-12 13:37:17', '2023-10-12 13:37:17'),
(2, 'Saurabh Patil', 'admin@gmail.com', NULL, 'Test', NULL, '2023-10-12 13:37:17', '2023-10-12 13:37:17'),
(3, 'test', 'admin@gmail.com', 7987987897897, 'test', NULL, '2023-10-12 13:38:27', '2023-10-12 13:38:27'),
(4, 'rashmi', 'rashmi@freshboxmedia.in', NULL, 'Hello', NULL, '2023-10-12 13:43:03', '2023-10-12 13:43:03');

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

--
-- Table structure for table `delete_account`
--

CREATE TABLE `delete_account` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` bigint(11) NOT NULL,
  `reason` text NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `delete_account`
--

INSERT INTO `delete_account` (`id`, `username`, `email`, `mobile`, `reason`, `updated_at`, `created_at`) VALUES
(2, 'test', 'test@gmail.com', 7756934882, 'test', '2023-10-03 09:24:58', '2023-10-03 09:24:58'),
(3, 'admin@gmail.com', 'manish@freshboxmedia.in', 7756934882, 'test', '2023-10-03 09:51:13', '2023-10-03 09:51:13'),
(4, 'admin@gmail.com', 'manish@freshboxmedia.in', 7756934882, 'ttest', '2023-10-03 09:53:25', '2023-10-03 09:53:25'),
(5, 'sumeet@natics.com', 'admin@gmail.com', 7756934882, 'test', '2023-10-03 09:55:27', '2023-10-03 09:55:27'),
(6, 'admin@gmail.com', 'manish@freshboxmedia.in', 7756934882, 'test', '2023-10-03 09:57:52', '2023-10-03 09:57:52'),
(7, 'admin@gmail.com', 'manish@freshboxmedia.in', 7756934882, 'test', '2023-10-03 09:58:44', '2023-10-03 09:58:44'),
(8, 'admin@gmail.com', 'manish@freshboxmedia.in', 7756934882, 'test', '2023-10-03 09:58:56', '2023-10-03 09:58:56'),
(9, 'admin@gmail.com', 'manish@freshboxmedia.in', 7756934882, 'test', '2023-10-03 10:00:54', '2023-10-03 10:00:54'),
(10, 'sumeet@natics.com', 'manish@freshboxmedia.in', 7756934882, 'test', '2023-10-03 10:01:07', '2023-10-03 10:01:07'),
(11, 'admin@gmail.com', 'admin@gmail.com', 7756934882, 'test', '2023-10-03 10:27:08', '2023-10-03 10:27:08'),
(12, 'admin@gmail.com', 'admin@gmail.com', 7756934882, 'test', '2023-10-03 10:28:11', '2023-10-03 10:28:11'),
(13, 'admin@gmail.com', 'manish@freshboxmedia.in', 7756934882, 'test', '2023-10-03 10:29:50', '2023-10-03 10:29:50'),
(14, 'admin@gmail.com', 'admin@gmail.com', 7756934882, 'test', '2023-10-12 13:06:24', '2023-10-12 13:06:24');

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

--
-- Table structure for table `dosage`
--

CREATE TABLE `dosage` (
  `dosage_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `dosage` text NOT NULL,
  `brand_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dosage`
--

INSERT INTO `dosage` (`dosage_id`, `title`, `dosage`, `brand_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Test updated', 'Test updated', 1, 0, '2023-10-19 09:54:35', '2023-10-19 10:24:07'),
(2, 'Test', 'Test', 10, 1, '2023-10-19 10:09:40', '2023-10-19 10:09:40'),
(3, 'Test 3', 'Test 3', 1, 1, '2023-10-19 10:16:21', '2023-10-19 10:16:21');

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

--
-- Table structure for table `induction_matrix`
--

CREATE TABLE `induction_matrix` (
  `im_id` int(11) NOT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `speciality_id` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `induction_matrix`
--

INSERT INTO `induction_matrix` (`im_id`, `brand_id`, `speciality_id`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 'In Osteoarthritis, Start With Zerodol P', 1, '2023-09-15 12:58:44', '2023-09-15 12:58:44'),
(2, 2, 1, 'In Osteoarthritis, Stay With Zerodol CR', 1, '2023-09-15 12:59:06', '2023-09-15 12:59:06'),
(3, 4, 1, 'In Managing Pain, Inflammation & Swelling associated with Fracture, Trauma & Injury', 1, '2023-09-15 12:59:35', '2023-09-15 12:59:35'),
(4, 5, 1, 'In Acute Low Back Pain', 1, '2023-09-15 13:00:25', '2023-09-15 13:00:25'),
(5, 10, 1, 'In Spondyltis,Myalgia & Sprain', 1, '2023-09-15 13:02:03', '2023-09-15 13:02:03'),
(6, 18, 1, 'In Neuropathic Pain', 1, '2023-09-15 13:04:27', '2023-09-15 13:04:27'),
(7, 11, 1, 'In Severe Acute Pain', 1, '2023-09-15 13:04:47', '2023-09-15 13:04:47'),
(8, 13, 1, 'In Osteoarthritis Pain, Joint Pain and Back Pain', 1, '2023-09-15 13:04:59', '2023-09-15 13:04:59'),
(9, 12, 2, 'In Colicky Pain', 1, '2023-09-15 13:06:09', '2023-09-15 13:06:09'),
(10, 3, 2, 'In Pain & Inflammation associated with Pharyngitis, Tonsillitis & Sinusitis', 1, '2023-09-15 13:06:26', '2023-09-15 13:06:26'),
(11, 19, 2, 'In Respiratory Tract Infections', 1, '2023-09-15 13:46:49', '2023-09-15 13:46:49'),
(12, 3, 3, 'In Post- Operative Pain & Inflammation', 1, '2023-09-15 13:51:20', '2023-09-15 13:51:20'),
(14, 4, 3, 'In Managing Pain, Inflammation & Swelling associated with Abscess, Wound & Injury', 1, '2023-09-16 06:36:12', '2023-09-16 06:36:12'),
(15, 20, 3, 'In Managing Post -Operative Pain, Inflammation & Swelling', 1, '2023-09-16 06:37:49', '2023-09-16 06:37:49'),
(16, 12, 3, 'In Intestinal Colic, Ureteric Colic & Biliary Colic, Smooth Muscle Spasm', 1, '2023-09-16 06:38:38', '2023-09-16 06:38:38'),
(17, 11, 3, 'In Severe Acute Pain', 1, '2023-09-16 06:38:58', '2023-09-16 06:38:58'),
(18, 19, 3, 'In Surgical Site Infections, Surgical Prophylaxis & Cellulites', 1, '2023-09-16 06:39:18', '2023-09-16 06:39:18'),
(19, 3, 4, 'In Pain & Inflammation associated with Pharyngitis, Tonsillitis & Sinusitis', 1, '2023-09-16 06:39:56', '2023-09-16 06:39:56'),
(20, 21, 4, 'In Managing Pain, Inflammation & Swelling associated with Tonsillitis , Sinusitis & Pharyngitis', 1, '2023-09-16 06:41:28', '2023-09-16 06:41:28'),
(21, 19, 4, 'In Acute Otitis Media, Respiratory Tract Infections & Pharyngotonsillitis', 1, '2023-09-16 06:41:51', '2023-09-16 06:41:51'),
(22, 3, 5, 'In Dental Pain & Inflammation', 1, '2023-09-16 06:42:55', '2023-09-16 06:42:55'),
(23, 21, 5, 'In Managing Pain, Inflammation & Swelling associated with Caries Teeth, Tooth Abscess & Extraction', 1, '2023-09-16 06:43:14', '2023-09-16 06:43:14'),
(24, 11, 5, 'In Severe Acute Pain', 1, '2023-09-16 06:43:37', '2023-09-16 06:43:37'),
(25, 22, 5, 'In Jaw muscle spasm & Trismus', 1, '2023-09-16 06:44:37', '2023-09-16 06:44:37'),
(26, 19, 5, 'In Root Canal Treatment, Caries and Abscess', 1, '2023-09-16 06:44:50', '2023-09-16 06:44:50'),
(27, 12, 6, 'In Dysmenorrhea & Abdominal Cramps', 1, '2023-09-16 06:45:05', '2023-09-16 06:45:05'),
(28, 3, 6, 'In Pain & Inflammation associated with Gynecological Procedure', 1, '2023-09-16 06:45:36', '2023-09-16 06:45:36'),
(29, 21, 6, 'In Managing Pain, Inflammation & Swelling associated with Abscess, Wound & Injury', 1, '2023-09-16 06:46:01', '2023-09-16 06:46:01'),
(30, 23, 6, 'In Acute & Chronic Low Back Pain', 1, '2023-09-16 06:46:56', '2023-09-16 06:46:56'),
(31, 3, 7, 'In Pain & Fever', 1, '2023-09-16 06:47:17', '2023-09-16 06:47:17'),
(32, 21, 7, 'In Colicky Pain & Abdominal Pain', 1, '2023-09-16 06:47:33', '2023-09-16 06:47:33'),
(33, 12, 7, 'In Pain associated with Smooth muscle spasm', 1, '2023-09-16 06:47:47', '2023-09-16 06:47:47'),
(34, 10, 7, 'In spondyltis,Myalgia & Sprain', 1, '2023-09-16 06:48:04', '2023-09-16 06:48:04'),
(35, 24, 7, 'In Pain & Inflammation', 1, '2023-09-16 06:49:30', '2023-09-16 06:49:30'),
(36, 13, 7, 'In Joint Pain, Back Pain and Osteoarthritis Pain', 1, '2023-09-16 06:49:40', '2023-09-16 06:49:40'),
(37, 19, 7, 'In Respiratory Tract Infections', 1, '2023-09-16 06:50:00', '2023-09-16 06:50:00'),
(38, 19, 8, 'In Acute Otitis Media, Respiratory Tract Infections', 1, '2023-09-16 06:50:16', '2023-09-16 06:50:16'),
(39, 25, 1, 'In Traumatic Tissue Injury', 1, '2023-09-30 15:24:22', '2023-09-30 15:24:22'),
(40, 13, 2, 'In Osteoarthritis Pain, Joint Pain and Back Pain', 1, '2023-09-30 15:25:43', '2023-09-30 15:25:43'),
(41, 3, 2, 'In Pain & Fever', 1, '2023-09-30 15:26:05', '2023-09-30 15:26:05'),
(42, 12, 2, 'In Colicky Pain & Abdominal Pain', 1, '2023-09-30 15:26:22', '2023-09-30 15:26:22'),
(43, 25, 3, 'In Post-Surgical Tissue Injury', 1, '2023-09-30 15:26:52', '2023-09-30 15:26:52'),
(44, 16, 4, 'test', 1, '2023-11-23 05:41:15', '2023-11-23 05:41:15');

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `menu_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `route` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`menu_id`, `title`, `icon`, `route`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Introduction', 'bx-book-content', 'intro', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'Communication', 'bx-user-voice', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'Indication Matrix', 'bx-table', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'Products', 'bx-package', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'Price List', 'bx-purchase-tag-alt', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `price_list`
--

CREATE TABLE `price_list` (
  `price_id` int(11) NOT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `pack_size` varchar(11) DEFAULT NULL,
  `mrp` float DEFAULT NULL,
  `ptr` float DEFAULT NULL,
  `esv` float DEFAULT NULL,
  `approved_date` text NOT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `price_list`
--

INSERT INTO `price_list` (`price_id`, `brand_id`, `pack_size`, `mrp`, `ptr`, `esv`, `approved_date`, `status`, `created_at`, `updated_at`) VALUES
(1, 14, '10\'s', 229.7, 164.07, 147.66, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 15, '10\'s', 204.85, 146.32, 131.69, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 16, '30ml', 67.54, 48.24, 43.42, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 17, '30ml', 142.9, 102.07, 91.86, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 1, '10\'s', 59.3, 42.36, 38.12, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 2, '10\'s', 91.6, 65.43, 58.89, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 13, '30gm', 151, 107.86, 97.07, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 10, '10\'s', 108.3, 77.36, 69.62, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 11, '10\'s', 162.6, 116.14, 104.53, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 4, '10\'s', 130.1, 92.93, 83.64, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 12, '10\'s', 144.7, 103.36, 93.02, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 25, '10\'s', 155.1, 110.78, 99.7, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 6, '10\'s', 229.8, 164.14, 147.73, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 7, '10\'s', 340.9, 243.5, 219.15, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 8, '10\'s', 190.05, 135.75, 122.17, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 9, '10\'s', 289.75, 206.97, 186.27, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 23, '5\'s', 230, 164.29, 147.86, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 3, '10\'s', 73, 52.14, 46.93, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 18, '10\'s', 233.1, 166.5, 149.85, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 20, '10\'s', 114.3, 81.64, 73.48, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 5, '3', 100, 33, 33, '20/23/24', 1, '2023-11-23 06:06:11', '2023-11-23 06:08:30');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `product_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`product_id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Aceclofenac 100 Mg', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'Diclofenac', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'Etoricoxibif', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'Ibuprofen', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'Nimesulide', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'Piroxicam', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 'Etodolac', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 'Aceclofenac (100 Mg) + Paracetamol (325 Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 'Diclofenac+Paracetamol (50 Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 'Etorcoxib (60Mg) + Paracetamol (325Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 'Ibuprofen (400Mg)+ Paracetamol(325Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 'Nimesulide (100Mg)+ Paracetamol (325Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 'Etodolac ( 400Mg)+ Paracetamol (325Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 'Aceclofenac (100 Mg) + Paracetamol (325 Mg) + Serratiopeptidase', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, ' Diclofenac+Paracetamol (50 Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 'Etorcoxib (60Mg) + Paracetamol (325Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 'Ibuprofen (400Mg) + Paracetamol(325Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 'Nimesulide (100Mg) + Paracetamol (325Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 'Etodolac ( 400Mg) + Paracetamol (325Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 'Diclofenac (50Mg) + Paracetamol (325Mg)+ Serratiopeptidase (15Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, ' Diclofenac (50 Mg) + Serratiopeptidase (10 Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 'Diclofenac + Paracetamol + Trypsin + Chymotrypsin', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, 'Aceclofenac + Chymotrypsin + Trypsin', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, 'Chymotrypsin + Diclofenac + Trypsin', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, 'Bromelain (90Mg) + Diclofenac (50Mg) + Rutoside (100Mg) + Trypsinchymotrypsin (50000Au)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, 'Bromelain (90Mg) + Diclofenac (50Mg) + Rutoside (100Mg) + Trypsin (48Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, ' Chymotrypsin + Trypsin', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(28, 'Bromelains + Chymotrypsin + Rutoside + Trypsin', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(29, 'Bromelain (90Mg) + Rutoside (100Mg) + Trypsin (48Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(30, 'Aceclofenac (100 Mg) + Paracetamol (325 Mg) + Serratiopeptidase (15 Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, 'Diclofenac (50Mg) + Paracetamol (325Mg) + Serratiopeptidase (15Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, ' Diclofenac (50 Mg) + Serratiopeptidase (10 Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, ' Chymotrypsin + Trypsin', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(34, 'Bromelains + Chymotrypsin + Rutoside + Trypsin', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, 'Bromelain (90Mg) + Rutoside (100Mg) + Trypsin (48Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, 'Aceclofenac (100 Mg) + Thiocolchicoside (8Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, 'Etoricoxib (60Mg) + Thiocolchicoside (8Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, 'Diclofenac(50Mg) + Thiocolchicoside (8Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, 'Etodolac (400Mg) + Thiocolchicoside (8Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(40, 'Tolperisone (150Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(41, 'Baclofen', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(42, ' Aceclofenac (100 Mg) + Paracetamol (325 Mg) + Thiocolchicoside (4Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(43, 'Diclofenac(50Mg) + Paracetamol (325Mg) + Chlorzoxazone (500Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(44, 'Aceclofenac (100 Mg) + Paracetamol (325 Mg) + Thiocolchicoside (8Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(45, ' Aceclofenac (100 Mg) + Paracetamol (325 Mg) + Tizanidine (2 Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(46, 'Aceclofenac (100Mg) + Paracetamol (325Mg) + Tramadol (37.5Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(47, 'Paracetamol (325 Mg) + Tramadol (37.5 Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(48, 'Aceclofenac 100Mg + Drotaverine Hcl (80Mg)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(49, 'Amoxicillin (250Mg) + Clavulanic Acid (125Mg) ', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(50, 'Amoxicillin (500 Mg) + Clavulanic Acid (125Mg) ', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(51, 'Amoxicillin (200Mg/5Ml) + Clavulanic Acid (28.5Mg/5Ml) ', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(52, 'Amoxicillin (400Mg/5Ml) + Clavulanic Acid (57Mg/5Ml) ', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(53, 'Diclofenac Diethylamine Bp, Linseed Oil Bp, Methyl Salicylate Ip, Menthol Ip', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(54, 'Oleum Lini, Diclofenacdiethlyamine Bp, Methyly Salicylate, Menthol, Benzoyl Alcohol', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(55, 'Diclofenac Diethylamine Bp', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(56, 'Absolute Alcohol, Diclofenac, Menthol, Methyl Salicylate', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `product_catalogue`
--

CREATE TABLE `product_catalogue` (
  `catalogue_id` int(11) NOT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `competitor_company_name` varchar(255) DEFAULT NULL,
  `mrp` float DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `product_catalogue`
--

INSERT INTO `product_catalogue` (`catalogue_id`, `brand_id`, `title`, `type`, `product_id`, `competitor_company_name`, `mrp`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'HIFENAC', 'direct', 1, 'INTAS', 57, 1, '2023-09-16 07:48:11', '2023-09-16 07:48:11'),
(2, 1, 'ACECLO', 'direct', 1, 'ARISTO', 53, 1, '2023-09-16 07:49:18', '2023-09-16 07:49:18'),
(3, 1, 'DOLOKIND', 'direct', 1, 'MANKIND', 35, 1, '2023-09-16 07:49:58', '2023-09-16 07:49:58'),
(4, 1, 'DOLOWIN', 'direct', 1, 'MICRO LABS*', 55, 1, '2023-09-16 07:50:52', '2023-09-16 07:50:52'),
(5, 1, 'ACENAC', 'direct', 1, 'MEDLEY PHARMA', 46, 1, '2023-09-16 07:51:27', '2023-09-16 07:51:27'),
(6, 1, 'VOVERAN', 'indirect', 2, 'NOVARTIS', 197, 1, '2023-09-16 07:54:53', '2023-09-16 07:54:53'),
(7, 1, 'DYNAPAR', 'indirect', 2, 'TROIKAA', 71, 1, '2023-09-16 08:01:16', '2023-09-16 08:01:16'),
(8, 1, 'ETOSHINE', 'indirect', 3, 'SUN', 150, 1, '2023-09-16 08:03:18', '2023-09-16 08:03:18'),
(9, 1, 'NUCOXIA', 'indirect', 3, 'ZYDUS', 288, 1, '2023-09-16 08:04:00', '2023-09-16 08:04:00'),
(10, 1, 'BRUFEN', 'indirect', 4, 'ABBOTT', 18, 1, '2023-09-16 08:04:33', '2023-09-16 08:04:33'),
(11, 1, 'IBUGESIC', 'indirect', 4, 'CIPLA', 33.27, 1, '2023-09-25 11:23:57', '2023-09-25 11:23:57'),
(12, 1, 'NISE', 'indirect', 5, 'DRL', 108, 1, '2023-09-25 11:24:38', '2023-09-25 11:24:38'),
(13, 1, 'NIMULID', 'indirect', 5, 'PANACEA', 84.8, 1, '2023-09-25 11:25:12', '2023-09-25 11:25:12'),
(14, 1, 'DOLONEX', 'indirect', 6, 'PFIZER', 215.82, 1, '2023-09-25 11:25:52', '2023-09-25 11:25:52'),
(15, 1, 'UGESIC', 'indirect', 6, 'MEYER', 132, 1, '2023-09-25 11:26:23', '2023-09-25 11:26:23'),
(16, 1, 'ETOVA', 'indirect', 7, 'IPCA LABS', 106.15, 1, '2023-09-25 11:26:52', '2023-09-25 11:26:52'),
(17, 1, 'ETOGESIC', 'indirect', 7, 'ZYDUS', 97.7, 1, '2023-09-25 11:27:25', '2023-09-25 11:27:25'),
(18, 3, 'HIFENAC-P', 'direct', 8, 'INTAS', 99, 1, '2023-09-25 11:29:13', '2023-09-25 11:29:13'),
(19, 3, 'ACECLO PLUS', 'direct', 8, 'ARISTO', 90.85, 1, '2023-09-25 11:29:41', '2023-09-25 11:29:41'),
(20, 3, 'DOLOKIND PLUS', 'direct', 8, 'MANKIND', 68.51, 1, '2023-09-25 11:30:10', '2023-09-25 11:30:10'),
(21, 3, 'ACENAC-P', 'direct', 8, 'MEDLEY', 61, 1, '2023-09-25 11:30:38', '2023-09-25 11:30:38'),
(22, 3, 'DOLOWIN-PLUS', 'direct', 8, 'MICRO LABS*', 75, 1, '2023-09-25 11:31:07', '2023-09-25 11:31:07'),
(23, 3, 'OXALGIN-DP', 'indirect', 9, 'ZYDUS', 122, 1, '2023-09-25 11:33:22', '2023-09-25 11:33:22'),
(24, 3, 'ESGIPYRIN', 'indirect', 9, 'ABBOTT', 117, 1, '2023-09-25 11:33:49', '2023-09-25 11:33:49'),
(25, 3, 'DYNAPAR', 'indirect', 9, 'TROIKAA', 70, 1, '2023-09-25 11:34:58', '2023-09-25 11:34:58'),
(26, 3, 'DICLOMOL', 'indirect', 9, 'WIN MEDICARE', 93.4, 1, '2023-09-25 11:35:31', '2023-09-25 11:35:31'),
(27, 3, 'DICLORAN A', 'indirect', 9, 'J B CHEMICALS', 74.05, 1, '2023-09-25 11:40:51', '2023-09-25 11:40:51'),
(28, 3, 'NUCOXIA-P', 'indirect', 10, 'ZYDUS CADILA*', 221.05, 1, '2023-09-25 11:42:14', '2023-09-25 11:42:14'),
(29, 3, 'BRUTAFLAM-PLUS', 'indirect', 10, 'MANKIND', 110, 1, '2023-09-25 11:42:37', '2023-09-25 11:42:37'),
(30, 3, 'ETRIK-P', 'indirect', 10, 'ALEMBIC', 128.9, 1, '2023-09-25 11:43:02', '2023-09-25 11:43:02'),
(31, 3, 'ETOS-P', 'indirect', 10, 'SYSTOPIC', 59, 1, '2023-09-25 11:44:01', '2023-09-25 11:44:01'),
(32, 3, 'ETORICA-P', 'indirect', 10, 'MICRO LABS*', 174, 1, '2023-09-25 11:53:11', '2023-09-25 11:53:11'),
(33, 3, 'COMBIFLAM', 'indirect', 11, 'SANOFI*', 46.05, 1, '2023-09-25 11:54:18', '2023-09-25 11:54:18'),
(34, 3, 'IBUGESIC PLUS', 'indirect', 11, 'CIPLA', 33.27, 1, '2023-09-25 11:55:47', '2023-09-25 11:55:47'),
(35, 3, 'FLEXON', 'indirect', 11, 'ARISTO PHARMA*', 28.75, 1, '2023-09-25 11:56:30', '2023-09-25 11:56:30'),
(36, 3, 'FENCETA', 'indirect', 11, 'ALKEM*', 26.9, 1, '2023-09-25 11:57:01', '2023-09-25 11:57:01'),
(37, 3, 'CORFLAM', 'indirect', 11, 'ABARIS HEALTHCARE', 20.44, 1, '2023-09-25 11:57:30', '2023-09-25 11:57:30'),
(38, 3, 'SUMO', 'indirect', 18, 'ALKEM*', 136, 1, '2023-09-25 12:06:36', '2023-09-25 12:06:36'),
(39, 3, 'NIMSAID-P', 'indirect', 18, 'MEDLEY PHARMA', 112.5, 1, '2023-09-25 12:07:19', '2023-09-25 12:07:19'),
(40, 3, 'TROMANIL PLUS', 'indirect', 18, 'PSYCHOTROPICS', 30, 1, '2023-09-25 12:07:44', '2023-09-25 12:07:44'),
(41, 3, 'NIMUCET GOLD', 'indirect', 18, 'INTAS PHARMA*', 53.5, 1, '2023-09-25 12:08:05', '2023-09-25 12:08:05'),
(42, 3, 'NIMPREX-P', 'indirect', 18, 'SEAGULL PHARMA', 46.2, 1, '2023-09-25 12:08:30', '2023-09-25 12:08:30'),
(43, 3, 'PROXYM-XT', 'indirect', 19, 'EMCURE*', 382.25, 1, '2023-09-25 12:08:56', '2023-09-25 12:08:56'),
(44, 3, 'ETOLGIA-P', 'indirect', 19, 'VASU ORGANICS', 108.9, 1, '2023-09-25 12:09:24', '2023-09-25 12:09:24'),
(45, 3, 'ETOGESIC-P', 'indirect', 19, 'ZYDUS CADILA*', 94.8, 1, '2023-09-25 12:09:45', '2023-09-25 12:09:45'),
(46, 3, 'TOLDIN-P', 'indirect', 19, 'TORRENT PHARMA*', 75.8, 1, '2023-09-25 12:11:49', '2023-09-25 12:11:49'),
(47, 3, 'ETOFREE-P', 'indirect', 19, 'LUPIN LIMITED', 89.7, 1, '2023-09-25 12:12:41', '2023-09-25 12:12:41'),
(48, 4, 'SIGNOFLAM', 'direct', 14, 'LUPIN', 134.45, 1, '2023-09-25 12:28:30', '2023-09-25 12:28:30'),
(49, 4, 'FLOZEN-AA', 'direct', 14, 'MANKIND', 104.5, 1, '2023-09-25 12:42:56', '2023-09-25 12:42:56'),
(50, 4, 'HIFENAC-D', 'direct', 14, 'INTAS', 116, 1, '2023-09-25 12:44:19', '2023-09-25 12:44:19'),
(51, 4, 'DOLOSTAT-SP', 'direct', 14, 'BLUE CROSS', 50, 1, '2023-09-25 12:44:47', '2023-09-25 12:44:47'),
(52, 4, 'DOLOWIN FORTE', 'direct', 8, 'MICRO LABS*', 148, 1, '2023-09-25 12:45:43', '2023-09-25 12:45:43'),
(53, 4, 'ENZOFLAM', 'indirect', 20, 'ALKEM*', 152, 1, '2023-09-25 12:46:43', '2023-09-25 12:46:43'),
(54, 4, 'SERADIC-P', 'indirect', 20, 'OBSURGE BIOTECH', 130.9, 1, '2023-09-25 12:47:26', '2023-09-25 12:47:26'),
(55, 4, 'EBILITY', 'indirect', 20, 'ABBOTT*', 181.46, 1, '2023-09-25 12:47:26', '2023-09-25 12:47:26'),
(56, 4, 'DICLOTAL-SP', 'indirect', 20, 'BLUE CROSS', 48, 1, '2023-09-25 12:47:26', '2023-09-25 12:47:26'),
(57, 4, 'ESGIPYRIN-SP', 'indirect', 20, 'ABBOTT*', 156.65, 1, '2023-09-25 12:47:26', '2023-09-25 12:47:26'),
(58, 4, 'LYSER-D', 'indirect', 21, 'COMED', 258, 1, '2023-09-25 12:52:28', '2023-09-25 12:52:28'),
(59, 4, 'EMANZEN D', 'indirect', 21, 'EMCURE*', 210.8, 1, '2023-09-25 12:52:28', '2023-09-25 12:52:28'),
(60, 4, 'SN-15 PLUS', 'indirect', 21, 'SERUM INSTITUTE', 106.45, 1, '2023-09-25 12:52:28', '2023-09-25 12:52:28'),
(61, 4, 'TOLPA-D', 'indirect', 21, 'MICRO LAB', 167, 1, '2023-09-25 12:52:28', '2023-09-25 12:52:28'),
(62, 4, 'FLOZEN-PLUS', 'indirect', 21, 'MANKIND', 106.8, 1, '2023-09-25 12:52:28', '2023-09-25 12:52:28'),
(63, 25, 'LYSOFLAM', 'indirect', 22, 'ALKEM*', 133, 1, '2023-09-25 12:57:54', '2023-09-25 12:57:54'),
(64, 25, 'CHYMOFLAM', 'indirect', 22, 'AGLOWMED', 121, 1, '2023-09-25 12:57:54', '2023-09-25 12:57:54'),
(65, 25, 'DOLENTIA FORTE', 'indirect', 22, 'AKUMENTIS HEALTH', 162.8, 1, '2023-09-25 12:57:54', '2023-09-25 12:57:54'),
(66, 25, 'Z-HEAL', 'indirect', 22, 'SALUD CARE', 225, 1, '2023-09-25 12:57:54', '2023-09-25 12:57:54'),
(67, 25, 'ALONAC FORTE', 'indirect', 23, 'EAST WEST PHARMA', 156.3, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(68, 25, 'TRIWALK-A', 'indirect', 23, 'INVISION MEDI SCIE', 90, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(69, 25, 'CHYMORAL-PLUS', 'indirect', 24, 'TORRENT PHARMA*', 198, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(70, 25, 'SISTAL-PLUS', 'indirect', 24, 'BESTOCHEM', 118, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(71, 25, 'OLTRYPSINE-D', 'indirect', 24, 'OLCARE LAB', 109, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(72, 25, 'CHYMEX-D', 'indirect', 24, 'OLCARE LAB', 186, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(73, 25, 'K-TRIP PLUS', 'indirect', 24, 'FDC', 92.5, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(74, 25, 'LYMED-D', 'indirect', 25, 'COMED CHEMICALS', 200, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(75, 25, 'ENZOMAC PLUS', 'indirect', 26, 'MACLEODS PHARMA', 309.5, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(76, 25, 'ENZOHEAL-D', 'indirect', 26, 'MACLEODS PHARMA', 309.5, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(77, 25, 'RUTOHEAL-D', 'indirect', 26, 'MANKIND', 239.9, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(78, 25, 'XYMOHEAL D', 'indirect', 26, 'CORONA REMEDIES', 301.1, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(79, 25, 'ZYMOFLAM-D', 'indirect', 26, 'ARISTO PHARMA*', 277, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(80, 25, 'CHYMORAL FORTE ', 'indirect', 27, 'TORRENT', 453, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(81, 25, 'K-TRIP FORTE', 'indirect', 27, 'FDC', 122, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(82, 25, 'ENZOFLAM-CT', 'indirect', 27, 'ALKEM', 281, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(83, 25, 'XYMOHEAL', 'indirect', 27, 'CORONA', 273.75, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(84, 25, 'CHYMOTAS FORTE', 'indirect', 27, 'INTAS PHARMA*', 396, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(85, 25, 'CHYMORAL-BR\r\n', 'indirect', 28, 'TORRENT PHARMA*\r\n', 272.3, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(86, 25, 'TRIFLAME +\r\n', 'indirect', 28, 'LINCOLN PHARMA\r\n', 270, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(87, 25, 'CHYMOGRAM FORTE\r\n', 'indirect', 28, 'OAKNET PHARMA\r\n', 164.84, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(88, 25, 'ENZOMAC', 'indirect', 29, 'MACLEODS PHARMA', 371.8, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(89, 25, 'DISPERZYME', 'indirect', 29, 'AKSIGEN\r\n', 689, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(90, 25, 'PHLOGAM', 'indirect', 29, 'AKSIGEN\r\n', 234, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(91, 25, 'ENZOHEAL\r\n', 'indirect', 29, 'MACLEODS PHARMA\r\n', 371.8, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(92, 25, 'THRIZE\r\n', 'indirect', 29, 'PHARMED\r\n', 280, 1, '2023-09-25 12:59:59', '2023-09-25 12:59:59'),
(93, 6, 'HIFENAC TH', 'direct', 36, 'INTAS', 238, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(94, 6, 'MIOFREE-A         \r\n', 'direct', 36, 'LUPIN\r\n', 257.8, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(95, 6, 'ZIX-MR            \r\n', 'direct', 36, 'JENBURKT\r\n', 239.75, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(96, 6, 'THIOSPAS-A', 'direct', 36, 'ABBOTT\r\n', 335.86, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(97, 6, 'THICHOREN AC\r\n', 'direct', 36, 'LA RENON \r\n', 199, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(98, 6, 'NUCOXIA-MR\r\n', 'indirect', 37, 'ZYDUS CADILA*', 304.4, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(99, 6, 'ETOSHINE-MR\r\n', 'indirect', 37, 'SUN*\r\n', 274, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(100, 6, 'BRUTAFLAM-MR\r\n', 'indirect', 37, 'MANKIND', 199, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(101, 6, 'ETRIK-MR\r\n', 'indirect', 37, 'ALEMBIC\r\n', 270.25, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(102, 6, 'ETOS MR\r\n', 'indirect', 37, 'SYSTOPIC\r\n', 141, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(103, 6, 'DYNAPAR-MR\r\n', 'indirect', 38, 'TROIKAA PHARMA\r\n', 241.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(104, 6, 'MYOSPAS-TH\r\n', 'indirect', 38, 'WIN MEDICARE\r\n', 268, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(105, 6, 'SYSTAFLAM-MR\r\n', 'indirect', 38, 'SYSTOPIC\r\n', 141, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(106, 6, 'THIOACT D\r\n', 'indirect', 38, 'SUN*\r\n', 204, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(107, 6, 'ETOVA-MR\r\n', 'indirect', 39, 'IPCA LABS\r\n', 273.85, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(108, 6, 'PROXYM-MR\r\n', 'indirect', 39, 'EMCURE*\r\n', 350.6, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(109, 6, 'ETOGESIC-MR\r\n', 'indirect', 39, 'ZYDUS CADILA*\r\n', 258.2, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(110, 6, 'SETOLAC-MR\r\n', 'indirect', 39, 'ZUVENTUS \r\n', 291.2, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(111, 6, 'ETORNEXT-TH\r\n', 'indirect', 39, 'ALEMBIC\r\n', 282.6, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(112, 6, 'MYOTOP\r\n', 'indirect', 40, 'ZUVENTUS \r\n', 156.65, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(113, 6, 'TOLPERITAS\r\n', 'indirect', 40, 'INTAS PHARMA*\r\n', 152.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(114, 6, 'SYNAPTOL\r\n', 'indirect', 40, 'SUN*\r\n', 142, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(115, 6, 'TOLKEM\r\n', 'indirect', 40, 'ALKEM*\r\n', 166, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(116, 6, 'TOLIFAST\r\n', 'indirect', 40, 'LUPIN LIMITED\r\n', 167, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(117, 6, 'LIOFEN\r\n', 'indirect', 41, 'SUN*\r\n', 111.4, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(118, 6, 'BACLOF\r\n', 'indirect', 41, 'INTAS PHARMA*\r\n', 111.41, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(119, 6, 'BACFEN\r\n', 'indirect', 41, 'ICON LIFESCIENCES\r\n', 118.8, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(120, 6, 'BACLOREN\r\n', 'indirect', 41, 'LA RENON HEALTHCA.\r\n', 109, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(121, 6, 'BIZLO\r\n', 'indirect', 41, 'TORRENT PHARMA*\r\n', 111.4, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(122, 7, 'HIFENAC TH        \r\n', 'direct', 36, 'INTAS\r\n', 372, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(123, 7, 'MIOFREE-A         \r\n', 'direct', 36, 'LUPIN\r\n', 379.85, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(124, 7, 'ZIX-MR', 'direct', 36, 'JENBURKT\r\n', 378, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(125, 7, 'THIOSPAS-A', 'direct', 36, 'ABBOTT', 562.6, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(126, 7, 'THICHOREN AC\r\n', 'direct', 36, 'LA RENON', 345, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(127, 7, 'NUCOXIA-MR', 'indirect', 37, 'ZYDUS CADILA*', 376.6, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(128, 7, 'RETOZ-MR', 'indirect', 37, 'DR REDDYS LABS', 409.75, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(129, 7, 'NUREETO-MR', 'indirect', 37, 'INTAS PHARMA*', 383, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(130, 7, 'NUCOXIA RELAX', 'indirect', 37, 'ZYDUS CADILA*\r\n', 466.4, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(131, 7, 'DORFREE MR\r\n', 'indirect', 37, 'LUPIN LIMITED\r\n', 350.6, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(132, 7, 'DYNAPAR-MR\r\n', 'indirect', 38, 'TROIKAA PHARMA', 300, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(133, 7, 'MYOSPAS-TH', 'indirect', 38, 'WIN MEDICARE\r\n', 239, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(134, 7, 'THIOACT D', 'indirect', 38, 'SUN*', 219, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(135, 7, 'ETOVA-MR', 'indirect', 39, 'IPCA LABS', 313.3, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(136, 7, 'PROXYM-MR', 'indirect', 39, 'EMCURE*', 172.57, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(137, 7, 'ETOGESIC-MR\r\n', 'indirect', 39, 'ZYDUS CADILA*\r\n', 219.91, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(138, 8, 'NEORELAX-MR       \r\n', 'direct', 42, 'MEYER', 233, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(139, 8, 'ACENAC-MR         \r\n', 'direct', 42, 'MEDLEY\r\n', 235, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(140, 8, 'HIFENAC MAX\r\n', 'direct', 42, 'INTAS PHARMA*\r\n', 258, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(141, 8, 'TOLAGIN', 'direct', 42, 'PHARMED\r\n', 235, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(142, 8, 'ZACY-MR', 'direct', 42, 'COMED CHEMICALS', 199, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(143, 8, 'MOBIZOX', 'indirect', 43, 'SUN*\r\n', 236, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(144, 8, 'INTAGESIC-MR', 'indirect', 43, 'INTAS PHARMA*\r\n', 103, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(145, 8, 'POWERGESIC MR', 'indirect', 43, 'JENBURKT', 183, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(146, 8, 'ORTHODEX-MR', 'indirect', 43, 'PSYCHOTROPICS', 112.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(147, 8, 'FLAMAR-MX', 'indirect', 43, 'INDOCO*', 103.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(149, 9, 'NEORELAX-MR', 'direct', 44, 'MEYER', 370, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(150, 9, 'ACENAC-MR', 'direct', 44, 'MEDLEY', 351.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(151, 9, 'TOLAGIN', 'direct', 44, 'PHARMED', 349, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(152, 9, 'ZACY-MR', 'direct', 44, 'COMED CHEMICALS', 320, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(153, 9, 'SIGNOFLAM-TH', 'direct', 44, 'LUPIN LIMITED', 269, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(154, 10, 'ANPROX MR', 'direct', 45, 'SEAGULL', 35, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(155, 10, 'ACENOVA-MR', 'direct', 45, 'SYNCHEM LAB', 60.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(156, 10, 'ACCETIZ-P', 'direct', 45, 'GENO', 62.25, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(157, 11, 'HIFENAC TA', 'direct', 45, 'INTAS PHARMA*', 142, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(158, 11, 'COMBIPARA-TR', 'direct', 45, 'DELCURE LIF. SCIEN', 100.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(159, 11, 'ULTRACET', 'indirect', 47, 'JANSSEN', 261, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(160, 11, 'CALPOL-T', 'indirect', 47, 'GSK', 102.1, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(161, 11, 'ACUVIN', 'indirect', 47, 'ABBOTT*', 227.66, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(162, 11, 'ULTRANISE', 'indirect', 47, 'DR REDDYS LABS', 73, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(163, 11, 'ULTRAM', 'indirect', 47, 'MICRO LABS*', 123, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(164, 12, 'DROTIN A', 'direct', 48, 'WALTER BUSHNELL', 195.22, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(165, 12, 'HIFENAC SPAS', 'direct', 48, 'INTAS', 144, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(166, 12, 'ACECLO SPAS', 'direct', 48, 'ARISTO', 125.9, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(167, 12, 'DOLOWIN SPAS', 'direct', 48, 'MICRO LAB', 119, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(168, 12, 'VETORY D', 'direct', 48, 'HETETO', 100.4, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(170, 13, 'VOLINI', 'direct', 53, 'SUN', 130, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(171, 13, 'DFO GEL', 'direct', 54, 'OZONE', 136.88, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(172, 13, 'DYNAPAR', 'direct', 53, 'TROIKAA', 154, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(173, 13, 'VOVERAN', 'direct', 55, 'DR. REDDYS', 150.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(174, 13, 'NANOFAST', 'direct', 56, 'PHARMED', 157, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(175, 14, 'AUGMENTIN', 'direct', 49, 'GSK', 229, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(176, 14, 'CLAVAM', 'direct', 49, 'Alkem', 218.5, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(177, 14, 'MOXIKIND-CV', 'direct', 49, 'Mankind', 169.9, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(178, 14, 'MOXCLAV', 'direct', 49, 'Sun', 264, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(179, 14, 'MOX-CV', 'direct', 49, 'Sun', 264, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(180, 15, 'AUGMENTIN', 'direct', 50, 'GSK', 182.78, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(181, 15, 'CLAVAM', 'direct', 50, 'Alkem\r\n', 182.78, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(182, 15, 'MOXIKIND-CV', 'direct', 50, 'Mankind', 171.1, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(183, 15, 'MOXCLAV', 'direct', 50, 'Sun', 182.78, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(184, 15, 'MOX-CV', 'direct', 50, 'Sun', 182.78, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(185, 16, 'CLAVAM BID', 'direct', 51, 'Alkem', 60.8, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(186, 16, 'AUGMENTIN DUO', 'direct', 51, 'GSK', 60.48, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(187, 16, 'MOXCLAV', 'direct', 51, 'Sun', 61.48, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(188, 16, 'ADVENT', 'direct', 51, 'Cipla', 60.48, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(189, 16, 'CLAMP', 'direct', 51, 'DRL', 60.48, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(190, 17, 'CLAVAM FORTE', 'direct', 52, 'Alkem ', 162, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(191, 17, 'AUGMENTIN DDS', 'direct', 52, 'GSK', 173, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(192, 17, 'MOXCLAV DS', 'direct', 52, 'Sun', 155, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(193, 17, 'ADVENT FORTE', 'direct', 52, 'Cipla', 239.58, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(194, 17, 'CLAMP KID FORTE', 'direct', 52, 'DRL', 195.25, 1, '2023-09-25 13:22:53', '2023-09-25 13:22:53'),
(195, 4, 'Test', 'direct', 3, 'test', 100, 1, '2023-10-18 10:46:53', '2023-10-18 10:46:53');

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

--
-- Table structure for table `speciality`
--

CREATE TABLE `speciality` (
  `speciality_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `speciality`
--

INSERT INTO `speciality` (`speciality_id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(1, 'ORTHO', 1, '2023-09-15 11:45:01', '2023-09-15 11:45:01'),
(2, 'CP', 1, '2023-09-15 11:45:12', '2023-09-15 11:45:12'),
(3, 'SURGEON', 1, '2023-09-15 11:45:31', '2023-09-15 11:45:31'),
(4, 'ENT', 1, '2023-09-15 11:45:44', '2023-09-15 11:45:44'),
(5, 'DENTIST', 1, '2023-09-15 11:45:59', '2023-09-15 11:45:59'),
(6, 'GYNAE', 1, '2023-09-15 11:46:15', '2023-09-15 11:46:15'),
(7, 'GP', 1, '2023-09-15 11:46:22', '2023-09-15 11:46:22'),
(8, 'PEDIA', 1, '2023-09-15 11:46:38', '2023-09-15 11:46:38'),
(9, 'Test', 1, '2023-11-23 05:32:43', '2023-11-23 05:32:43');

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

--
-- Table structure for table `template`
--

CREATE TABLE `template` (
  `temp_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `template`
--

INSERT INTO `template` (`temp_id`, `title`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Happy Ganesh Chaturthi', 'storage/uploads/templates/1_template.png', 0, '2023-09-18 07:06:35', '2023-10-13 05:11:25'),
(6, 'Happy Durga Pooja', 'storage/uploads/templates/6_template.png', 1, '2023-10-13 06:14:33', '2023-10-13 06:14:33');

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

--
-- Table structure for table `version_log`
--

CREATE TABLE `version_log` (
  `id` int(11) NOT NULL,
  `module` varchar(255) NOT 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=utf8mb4;

--
-- Dumping data for table `version_log`
--

INSERT INTO `version_log` (`id`, `module`, `created_at`, `updated_at`) VALUES
(1, 'brand', '2023-11-23 05:32:17', '2023-11-23 05:32:17'),
(2, 'speciality', '2023-11-23 05:32:43', '2023-11-23 05:32:43'),
(3, 'induction_matrix', '2023-11-23 05:41:15', '2023-11-23 05:41:15'),
(4, 'brand', '2023-11-23 05:41:45', '2023-11-23 05:41:45'),
(5, 'pricelist', '2023-11-23 06:06:11', '2023-11-23 06:06:11'),
(6, 'pricelist', '2023-11-23 06:08:30', '2023-11-23 06:08:30');

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

--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `video_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `thumbnail` varchar(50) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `menu_id` int(255) DEFAULT NULL,
  `subtype` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video`
--

INSERT INTO `video` (`video_id`, `title`, `thumbnail`, `path`, `menu_id`, `subtype`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Mode of Action of  Aceclofenac', NULL, 'storage/uploads/videos/2_video.mp4', 2, 2, 1, '2023-09-16 08:54:55', '2023-09-16 08:54:55'),
(3, 'Chondroprotective Action', NULL, 'storage/uploads/videos/3_video.mp4', 2, 2, 1, '2023-09-16 16:31:09', '2023-09-16 16:31:10'),
(4, 'Aceclofenac vs. Etoricoxib', NULL, 'storage/uploads/videos/4_video.mp4', 2, 1, 1, '2023-09-16 16:33:29', '2023-09-16 16:33:29'),
(5, 'Aceclofenac offers better cardiac safety than Etoricoxib', NULL, 'storage/uploads/videos/5_video.mp4', 2, 1, 1, '2023-09-16 16:34:33', '2023-09-16 16:34:33'),
(6, 'Aceclofenac vs. Ibuprofen', NULL, 'storage/uploads/videos/6_video.mp4', 2, 1, 1, '2023-09-16 16:37:50', '2023-09-16 16:37:51'),
(7, 'Aceclofenac vs. Piroxicam', NULL, 'storage/uploads/videos/7_video.mp4', 2, 1, 1, '2023-09-16 16:39:12', '2023-09-16 16:39:12'),
(8, 'Aceclofenac vs. Nimesulide', NULL, 'storage/uploads/videos/8_video.mp4', 2, 1, 1, '2023-09-16 16:40:22', '2023-09-16 16:40:22'),
(9, 'Aceclofenac vs. Etodolac', NULL, 'storage/uploads/videos/9_video.mp4', 2, 1, 1, '2023-09-16 16:41:21', '2023-09-16 16:41:22'),
(10, 'Aceclofenac vs. Indomethacin and Naproxen', NULL, 'storage/uploads/videos/10_video.mp4', 2, 1, 1, '2023-09-16 16:42:43', '2023-09-16 16:42:43'),
(11, 'Aceclofenac vs. Mefenamic Acid', NULL, 'storage/uploads/videos/11_video.mp4', 2, 1, 1, '2023-09-16 16:43:45', '2023-09-16 16:43:45'),
(12, 'Aceclofenac vs. Diclofenac', NULL, 'storage/uploads/videos/12_video.mp4', 2, 1, 1, '2023-09-28 11:33:44', '2023-09-28 11:33:44');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `brand`
--
ALTER TABLE `brand`
  ADD PRIMARY KEY (`brand_id`);

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

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

--
-- Indexes for table `dosage`
--
ALTER TABLE `dosage`
  ADD PRIMARY KEY (`dosage_id`);

--
-- Indexes for table `induction_matrix`
--
ALTER TABLE `induction_matrix`
  ADD PRIMARY KEY (`im_id`),
  ADD KEY `product_id` (`brand_id`),
  ADD KEY `speciality_id` (`speciality_id`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`menu_id`);

--
-- Indexes for table `price_list`
--
ALTER TABLE `price_list`
  ADD PRIMARY KEY (`price_id`),
  ADD KEY `product_id` (`brand_id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `product_catalogue`
--
ALTER TABLE `product_catalogue`
  ADD PRIMARY KEY (`catalogue_id`),
  ADD KEY `brand_id` (`brand_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `speciality`
--
ALTER TABLE `speciality`
  ADD PRIMARY KEY (`speciality_id`);

--
-- Indexes for table `template`
--
ALTER TABLE `template`
  ADD PRIMARY KEY (`temp_id`);

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

--
-- Indexes for table `video`
--
ALTER TABLE `video`
  ADD PRIMARY KEY (`video_id`),
  ADD KEY `menu_id` (`menu_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `brand`
--
ALTER TABLE `brand`
  MODIFY `brand_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

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

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

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

--
-- AUTO_INCREMENT for table `induction_matrix`
--
ALTER TABLE `induction_matrix`
  MODIFY `im_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

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

--
-- AUTO_INCREMENT for table `price_list`
--
ALTER TABLE `price_list`
  MODIFY `price_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `product_catalogue`
--
ALTER TABLE `product_catalogue`
  MODIFY `catalogue_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=196;

--
-- AUTO_INCREMENT for table `speciality`
--
ALTER TABLE `speciality`
  MODIFY `speciality_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

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

--
-- AUTO_INCREMENT for table `video`
--
ALTER TABLE `video`
  MODIFY `video_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `induction_matrix`
--
ALTER TABLE `induction_matrix`
  ADD CONSTRAINT `induction_matrix_ibfk_2` FOREIGN KEY (`speciality_id`) REFERENCES `speciality` (`speciality_id`),
  ADD CONSTRAINT `induction_matrix_ibfk_3` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`brand_id`);

--
-- Constraints for table `price_list`
--
ALTER TABLE `price_list`
  ADD CONSTRAINT `price_list_ibfk_1` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`brand_id`);

--
-- Constraints for table `product_catalogue`
--
ALTER TABLE `product_catalogue`
  ADD CONSTRAINT `product_catalogue_ibfk_1` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`brand_id`),
  ADD CONSTRAINT `product_catalogue_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `product` (`product_id`);

--
-- Constraints for table `video`
--
ALTER TABLE `video`
  ADD CONSTRAINT `video_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`menu_id`);
COMMIT;

