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

START TRANSACTION;



--
-- Database: `orbitalp_hmc`
--

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

--
-- Table structure for table `bp_add_category`
--

CREATE TABLE `bp_add_category` (
  `id` int(11) NOT NULL,
  `name` varchar(111) NOT NULL,
  `image` varchar(111) NOT NULL,
  `created_date` varchar(111) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bp_add_category`
--

INSERT INTO `bp_add_category` (`id`, `name`, `image`, `created_date`) VALUES
(30, 'ESSCO', '160830183911.jpg', '2020-12-18'),
(28, 'TRUFLO', '16083017999.jpg', '2020-12-18'),
(29, 'EBAX', '160830181810.jpg', '2020-12-18'),
(20, 'AJAY', '16083016051.jpg', '2020-12-18'),
(21, 'GRUNDFOSX', '16083016522.jpg', '2020-12-18'),
(22, 'ARTIZE', '16083016683.jpg', '2020-12-18'),
(23, 'NIRALI', '16083016894.jpg', '2020-12-18'),
(24, 'LEGRAND', '16083017125.jpg', '2020-12-18'),
(25, 'JAQUAR LIGHTING', '16083017356.jpg', '2020-12-18'),
(26, 'JAQUAR', '16083017567.jpg', '2020-12-18'),
(27, 'SYSKA', '16083017758.jpg', '2020-12-18');

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

--
-- Table structure for table `bp_add_product`
--

CREATE TABLE `bp_add_product` (
  `id` int(11) NOT NULL,
  `cate_id` varchar(11) NOT NULL,
  `cate_name` varchar(150) NOT NULL,
  `product_name` varchar(111) NOT NULL,
  `image` varchar(111) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bp_add_product`
--

INSERT INTO `bp_add_product` (`id`, `cate_id`, `cate_name`, `product_name`, `image`) VALUES
(65, '20', 'AJAY', 'Ajay CPVC', '1614665136Ajay CPVC _ Price List.pdf'),
(66, '20', 'AJAY', 'Ajay SWR', '1614665162Ajay SWR Price List.pdf'),
(67, '20', 'AJAY', 'Ajay UPVC', '1614665187Ajay UPVC Price List.pdf'),
(68, '22', 'ARTIZE', 'ARTIZE', '1614665215ARTIZE-CATALOGUE.pdf'),
(69, '29', 'EBAX', 'EBAX', '1614665243Ebax-catalogue-2020.pdf'),
(70, '30', 'ESSCO', 'ESSCO', '1614665386Essco-Catalogue.pdf'),
(71, '21', 'GRUNDFOSX', 'GRUNDFOS DBS', '1614665424Grundfos DBS Booklet.pdf'),
(72, '26', 'JAQUAR', 'Jaquar Customer Guide', '1614665585Jaquar customer-guide-vol18.pdf'),
(73, '25', 'JAQUAR LIGHTING', 'Jaquar Lighting Decorative', '1614665621Jaquar Lighting - Decorative_Price_List.pdf'),
(74, '25', 'JAQUAR LIGHTING', 'Jaquar Lighting Commercial', '1614665708Jaquar Lighting - commercial price list.pdf'),
(75, '25', 'JAQUAR LIGHTING', 'Jaquar Lighting Trade', '1614665760Jaquar Lighting trade_price_list.pdf'),
(76, '25', 'JAQUAR LIGHTING', 'Jaquar Ligthing Chandeliers', '1614665808Jaquar Ligthing - chandeliers_price_list.pdf'),
(77, '24', 'LEGRAND', 'Legrand Retail', '1614665841Legrand Retail Price List Oct 2020.pdf'),
(78, '23', 'NIRALI', 'Nirali BG', '1614665878Nirali BG Catalogue.pdf'),
(79, '27', 'SYSKA', 'SYSKA WIRES & CABLES', '1614665906SYSKA WIRES & CABLES.pdf'),
(80, '28', 'TRUFLO', 'TRUFLO', '1614665930Truflo Pricelist.pdf');

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

--
-- Table structure for table `bp_gallery`
--

CREATE TABLE `bp_gallery` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `image` varchar(200) NOT NULL,
  `created_date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bp_gallery`
--

INSERT INTO `bp_gallery` (`id`, `title`, `image`, `created_date`) VALUES
(22, 'HMC', '16146691334.jpg', '2021-03-02'),
(21, 'HMC', '16146691243.jpg', '2021-03-02'),
(20, 'HMC', '16146691142.jpg', '2021-03-02'),
(19, 'HMC', '16146690991.jpg', '2021-03-02');

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

--
-- Table structure for table `registrations`
--

CREATE TABLE `registrations` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `organisation` varchar(255) DEFAULT NULL,
  `address` longtext DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone_office` varchar(255) DEFAULT NULL,
  `phone_res` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `status_of_participant` varchar(255) DEFAULT NULL,
  `attend_of_congress` varchar(255) DEFAULT NULL,
  `section_name` varchar(255) DEFAULT NULL,
  `subject_area` varchar(255) DEFAULT NULL,
  `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 `registrations`
--

INSERT INTO `registrations` (`id`, `name`, `image`, `gender`, `dob`, `designation`, `organisation`, `address`, `country`, `phone_office`, `phone_res`, `mobile`, `email`, `status_of_participant`, `attend_of_congress`, `section_name`, `subject_area`, `created_at`, `updated_at`) VALUES
(9, 'Mriganka Saikia', '41f9c57ee6edd4136e3ac92d3e797c282022-11-19.jpg', 'Male', '2022-11-01', 'SI', 'ITS', 'GUWAHATI', 'INDIA', '7744551122', '2132132133', '9876542157', 'rr@mail.com', 'Student', '1', 'Oral', 'SEC 3C', '2022-11-19 14:49:34', '2022-11-19 14:49:34'),
(10, 'Vikash Bedi', 'a404f63ef239a48e0a305cac3d9bdd832022-11-19.jpg', 'Male', '2022-11-01', 'SI', 'ITS', 'RAJBARI', 'INDIA', '7744551122', '1321321321', '9876542157', 'rr@mail.com', 'Student', '2', '', '', '2022-11-19 14:50:49', '2022-11-19 14:50:49'),
(11, 'Abhilash Sharma', '98722d63189daaec107e5e788ba44be62022-11-19.jpg', 'Male', '2022-11-15', 'SI', 'ITS', 'QWERTY', 'INDIA', '7744551122', '231312321', '9876542157', 'rr@mail.com', 'Student', '2', '', '', '2022-11-19 14:58:23', '2022-11-19 14:58:23');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

