-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Dec 17, 2024 at 11:22 AM
-- Server version: 10.11.10-MariaDB
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u181040597_sandila`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `email`, `password`) VALUES
(1, 'admin@gmail.com', 'admin');

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

--
-- Table structure for table `business_listings`
--

CREATE TABLE `business_listings` (
  `id` int(11) NOT NULL,
  `business_name` varchar(255) NOT NULL,
  `city_id` varchar(255) NOT NULL,
  `category_id` int(11) NOT NULL,
  `products_services` varbinary(300) NOT NULL,
  `business_days` varchar(255) NOT NULL,
  `business_start_year` year(4) NOT NULL,
  `contact_number` int(20) NOT NULL,
  `usp` int(255) NOT NULL,
  `business_type` varchar(50) NOT NULL,
  `photos` text NOT NULL,
  `address` text NOT NULL,
  `additional_contact` varchar(20) NOT NULL,
  `website_url` varchar(255) NOT NULL,
  `contact_person` varchar(255) NOT NULL,
  `gst_number` varchar(20) NOT NULL,
  `status` enum('1','0') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_listings`
--

INSERT INTO `business_listings` (`id`, `business_name`, `city_id`, `category_id`, `products_services`, `business_days`, `business_start_year`, `contact_number`, `usp`, `business_type`, `photos`, `address`, `additional_contact`, `website_url`, `contact_person`, `gst_number`, `status`) VALUES
(1, 'Vasu Jyoti', 'Gomati Nagar, Lucknow', 2, 0x56617375204a796f7469, '2024-12-16', '2024', 1234567890, 0, 'Vasu Jyoti', 'Vasu Jyoti (1) (1).jpg', 'Gomati Nagar, Lucknow', '123456789', 'https://vyaparbazar.com/m-demoo/Sandila-Global-Service/', 'Ankit Kumar', 'AJHDASDJKAS345435', '1'),
(2, 'A2Z Grocery Store Ltd.', 'Indiranagar Sec -18, Lucknow', 2, 0x41325a2047726f6365727920, '2024-12-16', '2024', 1234567890, 0, 'A2Z Grocery Store Ltd.', '499390_18b8b (1) (1).jpg', 'Indiranagar Sec -18, Lucknow', '123456789', 'https://barabanki.uponline.in/grocery-and-general-stores/2875', 'vishal sharma', 'LFSFSKLDFLKJKL7', '1'),
(3, 'TG Enterprises', 'Lalbagh, Lucknow', 3, 0x544720456e74657270726973, '2024-12-16', '2024', 1234567890, 0, 'TG Enterprises', 'Photocopy-Laminates-Binding (1).jpg', 'Lalbagh, Lucknow', '1245655545454', 'https://barabanki.uponline.in/grocery-and-general-stores/2875', 'ankit', 'DFHFGJDTYJYUIYUI', '1');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `category_name`, `category_image`) VALUES
(2, 'Daily Home Needs', 'daily-home-needs (1).webp'),
(3, 'Business Needs & Office Supplies', 'daily-business-needs.webp'),
(4, 'Repairs & Service', 'repairs-service.webp'),
(5, 'Brokers, Agents & Agencies', 'brokers-agents-agencies.webp'),
(6, 'Consultants & Professionals', 'consultants-professionals.webp'),
(7, 'Advertising & Marketing', 'consultants-professionals.webp'),
(8, 'Advertising & Marketing', 'advertising-marketing.webp'),
(9, 'Doctors, Clinics & Hospitals', 'doctors-clinics-hospitals.webp'),
(10, 'Kids & Children', 'kids-children.webp'),
(11, 'Fun & Entertainment', 'fun-entertainment.webp'),
(12, 'Architecture & Interiors', 'architecture-interiors.webp'),
(13, 'Plywood, Hardware & Paint', 'plywood-hardware-paint.webp'),
(14, 'Sanitary & Bath Fittings', 'sanitar-bath-fittings.webp'),
(15, 'Travel & Tourism', 'travel-tourism.webp'),
(16, ' Hotels & Accomodation', 'hotels-accomodation.webp'),
(17, ' Hobby Classes', 'hobby-classes.webp'),
(18, ' Education, Coaching & Training', 'education-coaching-training.webp'),
(19, 'Gifting', 'gifting.webp'),
(20, ' Health, Fitness & Sports', 'health-fitness-sports.webp'),
(21, ' Home & Kitchen', 'home-kitchen.webp'),
(22, 'Clothing & Fashion', 'clothing-fashion.webp'),
(23, 'Jewellery', 'jewellery.webp'),
(24, ' Cars, Bikes & Automobiles', 'cars-bikes-automobiles.webp'),
(25, 'Courier, Transport & Logistics', 'courier-transport-logistics.webp'),
(26, 'Real Estate', 'real-estate.webp'),
(27, 'Financial Services', 'financial-services.webp'),
(28, 'IT Services', 'it-services.webp'),
(29, 'Laptops, Mobiles & Computers', 'laptops-mobiles-computers.webp'),
(30, 'Electronics & Appliances', 'electronics-appliances.webp'),
(31, 'Printing, Display & Signage', 'printing-display-signage.webp'),
(32, 'Security & Surveillance', 'security-surveillance.webp'),
(33, 'Machines, Tools & Equipments', 'machines-tools-equipments.webp'),
(34, 'Farming, Plants, Flowers & Pets', 'farming-plants-flowers-pets.webp');

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

--
-- Table structure for table `registration`
--

CREATE TABLE `registration` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `business_name` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `city` text NOT NULL,
  `state` varchar(255) NOT NULL,
  `pincode` varchar(6) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('1','0') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` (`id`, `username`, `user_id`, `email`, `password`, `mobile`, `business_name`, `address`, `city`, `state`, `pincode`, `created_at`, `status`) VALUES
(1, 'ravi', '', 'ravijio896921@gmail.com', '111', '1234567890', 'kumar', '1234567890', 'eresd', 'Delhi', '110055', '2024-11-20 11:14:55', '1'),
(2, 'ANURAG', '', 'anura.sandila@gmail.com', 'YUVA123#', '9450390056', 'SANDILA GLOBAL', 'BAROOUNI', 'SANDILA', 'UP', '241204', '2024-11-26 12:15:31', '1'),
(3, 'ANURAG', '', 'anura.sandila@gmail.com', 'YUVA123#', '9450390056', 'SANDILA GLOBAL', 'BAROOUNI', 'SANDILA', 'UP', '241204', '2024-11-28 11:47:13', '1'),
(4, 'Vikash', 'v123', 'email@gmail.com', '111', '12345678', 'kumar', 'delhi\r\n123456789', 'eresd', 'Delhi', 'DSFD', '2024-12-14 08:44:38', '1'),
(5, 'k', 'kk', 'r@gmail.com', '123', '12345678', 'kumar', '1234567890\r\n123456789', 'eresd', 'Delhi', 'DSFD', '2024-12-15 10:22:36', '1');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;