-- phpMyAdmin SQL Dump
-- version 4.9.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 24, 2021 at 10:37 PM
-- Server version: 5.6.51-cll-lve
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `seven_hill`
--

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

--
-- Table structure for table `admin_users`
--

CREATE TABLE `admin_users` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin_users`
--

INSERT INTO `admin_users` (`id`, `username`, `password`) VALUES
(1, 'anuj', 'shukla'),
(3, 'daya', 'saraswati');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `categories` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `categories`, `status`) VALUES
(51, 'Customize Software', 1),
(52, 'Web Application', 1),
(53, 'Mobile Application', 1),
(54, 'Industry Specific Software', 1);

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

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

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(75) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `comment` text NOT NULL,
  `added_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `categories` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `product` (`id`, `categories`, `name`, `image`, `status`) VALUES
(12, '54', 'Salon Management', '9549334_salon.jpeg', 1),
(13, '53', 'Collage Maker App', '3293023_collage.png', 1),
(14, '51', 'Automated Invoicing', '4642512_automated.png', 1),
(15, '51', 'Bug Tracking System', '2250501_Bug.png', 1),
(16, '51', 'C M S', '3489081_cms.jpg', 1),
(17, '51', 'E-commerce Solutions', '9788057_ecomm.png', 1),
(18, '51', 'C R M', '1516340_Crm.jpg', 1),
(19, '51', 'Business Process Automation System', '2240498_bpas.jpg', 1),
(20, '52', 'Grocery Store', '5397426_grocery.jpg', 1),
(21, '52', 'Logistics Website', '4425244_logistics.jpg', 1),
(22, '52', 'Medical Support', '7657477_medical.png', 1),
(23, '52', 'Operations Management', '2843479_operations.jpg', 1),
(24, '52', 'Packers & Movers', '2454276_packers.jpg', 1),
(25, '52', 'Tickets On Web', '8044223_ticket.jpg', 1),
(26, '54', 'Farm Management', '1586432_farm.jpg', 1),
(27, '54', 'Hotel Management', '7368892_hotel.png', 1),
(28, '54', 'Jewellery Management', '2134381_jewellery.png', 1),
(29, '54', 'M L M', '6632671_mlm.jpg', 1),
(30, '54', 'Property Management', '2106305_property.jpg', 1),
(31, '54', 'Restaurant Management', '8483613_restaurant.png', 1),
(32, '54', 'Robotics Software', '9554890_robo.png', 1),
(33, '54', 'A I Softwares', '8372548_art.png', 1),
(34, '53', 'Dating App', '2656793_dating.jpg', 1),
(35, '53', 'Music Apps', '9346393_music.jpg', 1),
(36, '53', 'Online Shopping App', '9745446_shop.png', 1),
(37, '53', 'E-learning App', '4300016_learn.jpeg', 1),
(38, '53', 'Bill Payment App', '4400301_bill.jpg', 1);

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
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 */;
