-- phpMyAdmin SQL Dump
-- version 4.3.11
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 02, 2019 at 04:35 PM
-- Server version: 5.6.24
-- PHP Version: 5.5.24

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `event`
--

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

--
-- Table structure for table `add_birthday_event`
--

CREATE TABLE IF NOT EXISTS `add_birthday_event` (
  `name` varchar(200) NOT NULL,
  `address` varchar(500) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `capacity` varchar(500) NOT NULL,
  `event` varchar(200) NOT NULL,
  `rs` int(200) NOT NULL,
  `image` varchar(500) NOT NULL,
  `id` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `add_birthday_event`
--

INSERT INTO `add_birthday_event` (`name`, `address`, `phone`, `capacity`, `event`, `rs`, `image`, `id`) VALUES
('Dadar_hall  ', 'dadar  ', '7666301201', '', 'Birthday planners  ', 9000, 'birthday_event_img/download (1).jpg', 1),
('worli_hall', 'Worli ', '9969693065', '', 'Birthday planners', 10000, 'birthday_event_img/download.jpg', 2),
('A1', 'dadar', '9596401401', '', 'Birthday planners', 7000, 'birthday_event_img/download (3).jpg', 3);

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

--
-- Table structure for table `add_corporate_event`
--

CREATE TABLE IF NOT EXISTS `add_corporate_event` (
  `id` int(200) NOT NULL,
  `name` varchar(500) NOT NULL,
  `address` varchar(500) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `capacity` varchar(500) NOT NULL,
  `event` varchar(500) NOT NULL,
  `rs` int(200) NOT NULL,
  `image` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `add_corporate_event`
--

INSERT INTO `add_corporate_event` (`id`, `name`, `address`, `phone`, `capacity`, `event`, `rs`, `image`) VALUES
(5, 'Dadar', 'Dadar', '9828345826', '', 'corporate event', 9000, 'corporate_event_img/images.jpg'),
(6, 'A2', 'Parel', '7666301201', '', 'corporate event', 8000, 'corporate_event_img/images (5).jpg'),
(7, 'Parel', 'Parel', '9979793067', '', 'corporate event', 15000, 'corporate_event_img/images.jpg');

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

--
-- Table structure for table `add_event`
--

CREATE TABLE IF NOT EXISTS `add_event` (
  `address` varchar(50) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `capacity` varchar(50) NOT NULL,
  `event` varchar(50) NOT NULL,
  `rs` varchar(500) NOT NULL,
  `name` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `add_event`
--

INSERT INTO `add_event` (`address`, `phone`, `capacity`, `event`, `rs`, `name`, `image`, `id`) VALUES
('Worli   ', '9969693065', '', 'wedding planners   ', '9000', 'Worli_hall   ', 'event_img/images (1).jpg', 13),
('dadar', '7666301201', '', 'wedding planners', '10000', 'Dadar_hall', 'event_img/images (4).jpg', 14),
('kandivali', '9969693065', '', 'wedding planners', '10000', 'Kandivali_hall', 'event_img/download (16).jpg', 15),
('Parel', '9594801201', '', 'wedding planners', '8000', 'Parel_hall', 'event_img/download.jpg', 16);

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

--
-- Table structure for table `add_music_event`
--

CREATE TABLE IF NOT EXISTS `add_music_event` (
  `name` varchar(200) NOT NULL,
  `address` varchar(500) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `capacity` varchar(500) NOT NULL,
  `event` varchar(200) NOT NULL,
  `rs` int(200) NOT NULL,
  `image` varchar(500) NOT NULL,
  `id` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `add_music_event`
--

INSERT INTO `add_music_event` (`name`, `address`, `phone`, `capacity`, `event`, `rs`, `image`, `id`) VALUES
('worli_hall ', 'Worli ', '9969693065', '', 'live music party event ', 10000, 'music_event_img/images (6).jpg', 1),
('Kandivali_hall', 'kandivali', '9969693065', '', 'live music party event', 12000, 'music_event_img/images (2).jpg', 2),
('dadar', 'dadar', '7666391597', '', 'live music party event', 13000, 'music_event_img/images.jpg', 3);

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

--
-- Table structure for table `add_personal_event`
--

CREATE TABLE IF NOT EXISTS `add_personal_event` (
  `name` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `capacity` varchar(100) NOT NULL,
  `event` varchar(50) NOT NULL,
  `rs` int(200) NOT NULL,
  `image` varchar(500) NOT NULL,
  `id` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `add_personal_event`
--

INSERT INTO `add_personal_event` (`name`, `address`, `phone`, `capacity`, `event`, `rs`, `image`, `id`) VALUES
('Dadar_hall   ', 'dadar   ', '9969693065', '', 'personal event organisers   ', 8000, 'parsonal_event_img/images (3).jpg', 3),
('worli_hall', 'Worli ', '7666301201', '', 'personal event organisers', 10000, 'parsonal_event_img/images (5).jpg', 5);

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

--
-- Table structure for table `add_shows_event`
--

CREATE TABLE IF NOT EXISTS `add_shows_event` (
  `name` varchar(500) NOT NULL,
  `address` varchar(500) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `capacity` varchar(500) NOT NULL,
  `event` varchar(500) NOT NULL,
  `rs` int(200) NOT NULL,
  `image` varchar(500) NOT NULL,
  `id` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `add_shows_event`
--

INSERT INTO `add_shows_event` (`name`, `address`, `phone`, `capacity`, `event`, `rs`, `image`, `id`) VALUES
('Worli_hall ', 'Worli ', '7666301201', '', 'entertainment shows and stalls ', 8000, 'shows_event_img/images.jpg', 2),
('parel', 'Parel', '8878585431', '', 'entertainment shows and stalls', 12000, 'shows_event_img/download (4).jpg', 4),
('A to Z', 'Prabhadevi', '9989782354', '', 'entertainment shows and stalls', 15000, 'shows_event_img/download.jpg', 5);

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

--
-- Table structure for table `birthday_event_eqi1`
--

CREATE TABLE IF NOT EXISTS `birthday_event_eqi1` (
  `id` int(200) NOT NULL,
  `eqi1` varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `birthday_event_eqi1`
--

INSERT INTO `birthday_event_eqi1` (`id`, `eqi1`) VALUES
(1, 'Kid Birthday Party'),
(2, 'Adult Birthday Party');

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

--
-- Table structure for table `birthday_event_eqi2`
--

CREATE TABLE IF NOT EXISTS `birthday_event_eqi2` (
  `id` int(200) NOT NULL,
  `eqi2` varchar(500) NOT NULL,
  `rs` int(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `birthday_event_eqi2`
--

INSERT INTO `birthday_event_eqi2` (`id`, `eqi2`, `rs`) VALUES
(1, 'Flower Decoration', 20000),
(2, 'Venue Decoration', 10000),
(3, 'Balloon Decoration', 10000),
(4, 'DJ', 20000),
(5, 'Catering', 20000),
(6, 'Sound And Lighting', 10000),
(7, 'Anchoring & Hosting', 10000),
(8, 'Photography', 20000),
(9, 'Tents & Tarpaulins Rental', 10000),
(10, 'Furniture Rental', 10000),
(11, 'Shamiana/marquee Rental', 10000),
(12, 'Anchoring & Hosting', 10000),
(13, 'Stage set Up', 10000),
(14, 'Electrical Appliance Rental', 10000),
(15, 'Magic Show', 10000),
(16, 'Return Gifts', 10000);

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

--
-- Table structure for table `book`
--

CREATE TABLE IF NOT EXISTS `book` (
  `booking_id` int(200) NOT NULL,
  `date_` date NOT NULL,
  `place` varchar(500) NOT NULL,
  `eqi1` varchar(1000) NOT NULL,
  `guests` varchar(200) NOT NULL,
  `eqi2` varchar(1000) NOT NULL,
  `user_id` int(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `rs` varchar(200) NOT NULL,
  `customer_name` varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `book`
--

INSERT INTO `book` (`booking_id`, `date_`, `place`, `eqi1`, `guests`, `eqi2`, `user_id`, `name`, `rs`, `customer_name`) VALUES
(156, '2019-06-30', 'event_img/images (1).jpg ', 'Entire Wedding, Reception  ', '101 - 500    ', 'Flower Decoration  Rs.20000, DJ  Rs.20000, Catering  Rs.20000, Photography  Rs.30000  ', 2, 'Wedding Planners  ', 'Rs.7000  Rs.90000= Rs.97000', 'Sagar Naik'),
(157, '2019-06-28', 'parsonal_event_img/images (3).jpg', 'Bady Shower, Religious Event ', 'Less than 50  ', 'DJ  Rs.10000, Catering  Rs.20000 ', 2, 'personal event organisers ', 'Rs.9000  Rs.30000= Rs.39000', 'Sagar Naik'),
(158, '2019-06-30', 'birthday_event_img/download (1).jpg', 'Adult Birthday Party', '50 - 100', 'Venue Decoration  Rs.10000, DJ  Rs.20000, Photography  Rs.20000, Magic Show  Rs.10000', 26, 'Birthday party ', 'Rs.8000+ Rs.60000= Rs.68000', 'Akash Salvi'),
(159, '2019-06-30', 'shows_event_img/images.jpg', 'Corporate Event', '1 - 2 hours', 'Dance Show  Rs.30000, Mimicry Show  Rs.30000', 28, 'Entertainment shows and stalls', 'Rs.8000+ Rs.60000= Rs.68000', 'sharukh khan'),
(160, '2019-06-30', 'shows_event_img/images.jpg', 'Corporate Event', '1 - 2 hours', 'Balloon Decoration  Rs.15000, Dance Show  Rs.30000', 26, 'Entertainment shows and stalls', 'Rs.8000+ Rs.45000= Rs.53000', 'ajgar singh jurrat'),
(161, '2019-06-30', 'event_img/images (4).jpg ', 'Entire Wedding, Reception', '101 - 500', 'Mandap Decoration  Rs.20000, DJ  Rs.20000', 28, 'Wedding Planners', 'Rs.10000+ Rs.40000= Rs.50000', 'saurabh'),
(162, '2019-06-30', 'event_img/images (4).jpg ', 'Entire Wedding, Reception', '101 - 500', 'Mandap Decoration  Rs.20000, DJ  Rs.20000', 2, 'Wedding Planners', 'Rs.10000+ Rs.40000= Rs.50000', 'SagarNaik'),
(163, '2019-06-30', 'event_img/images (1).jpg ', 'Reception', 'Less than 100', 'DJ  Rs.20000, Catering  Rs.20000, Sound And Lighting  Rs.10000', 26, 'Wedding Planners', 'Rs.7000+ Rs.50000= Rs.57000', 'Akash Salvi'),
(164, '0000-00-00', 'event_img/images (4).jpg ', 'Reception, Sangeet', '101 - 500', 'DJ  Rs.20000, Catering  Rs.20000', 26, 'Wedding Planners', 'Rs.10000+ Rs.40000= Rs.50000', 'Akash Salvi'),
(165, '0000-00-00', 'event_img/images (4).jpg ', 'Reception, Sangeet', '101 - 500', 'DJ  Rs.20000, Catering  Rs.20000, Sound And Lighting  Rs.10000', 26, 'Wedding Planners', 'Rs.10000+ Rs.50000= Rs.60000', 'Akash Salvi'),
(166, '0000-00-00', 'event_img/images (1).jpg ', 'Entire Wedding', '101 - 500', 'Catering Rs.20000', 26, 'Wedding Planners', 'Rs.7000+ Rs.20000= Rs.27000', 'Akash Salvi'),
(167, '2019-07-26', 'event_img/images (4).jpg ', 'Reception', '101 - 500', 'Mandap Decoration Rs.20000', 26, 'Wedding Planners', 'Rs.10000+ Rs.20000= Rs.30000', 'Akash Salvi'),
(168, '2019-07-26', 'event_img/images (4).jpg ', 'Reception', '101 - 500', 'Mandap Decoration  Rs.20000', 26, 'Wedding Planners', 'Rs.10000+ Rs.20000= Rs.30000', 'Akash Salvi'),
(169, '2019-07-26', 'event_img/images (1).jpg ', 'Entire Wedding, Reception, Sangeet', '101 - 500', 'DJ  Rs.20000, Catering  Rs.20000', 2, 'Wedding Planners', 'Rs.7000+ Rs.40000= Rs.47000', 'Sagar Naik'),
(170, '2019-07-09', 'birthday_event_img/download (1).jpg ', 'Adult Birthday Party', '101 - 500', 'DJ  Rs.20000, Catering  Rs.20000', 2, 'Birthday party ', 'Rs.9000+ Rs.40000= Rs.49000', 'Sagar Naik'),
(171, '2019-07-19', 'corporate_event_img/images.jpg', 'Promotional Activity', '3 - 4 hours', 'DJ  Rs.20000', 2, 'Commercial event organisers', 'Rs.8000+ Rs.20000= Rs.28000', 'Sagar Naik'),
(172, '2019-07-26', 'shows_event_img/images.jpg', 'Corporate Event', '1 - 2 hours', 'Mimicry Show  Rs.30000', 26, 'Entertainment shows and stalls', 'Rs.8000+ Rs.30000= Rs.38000', 'Akash Salvi'),
(173, '2019-07-18', 'birthday_event_img/download.jpg', 'Kid Birthday Party', '50 - 100', 'DJ  Rs.20000, Catering  Rs.20000', 27, 'Birthday party ', 'Rs.10000+ Rs.40000= Rs.50000', 'Zawed Akhtar'),
(174, '2019-07-27', 'event_img/download (16).jpg ', 'Reception', '101 - 500', 'DJ  Rs.20000, Catering  Rs.20000, Sound And Lighting  Rs.10000', 28, 'Wedding Planners', 'Rs.10000+ Rs.50000= Rs.60000', 'Akshay Salvi'),
(175, '2019-07-24', 'parsonal_event_img/images (5).jpg', 'Celebration Party, Retirement / Farewell Party', '50 - 100', 'DJ  Rs.10000, Catering  Rs.20000', 26, 'personal event organisers', 'Rs.10000+ Rs.30000= Rs.40000', 'Akash Salvi'),
(176, '2019-09-01', 'birthday_event_img/download.jpg', 'Kid Birthday Party', '50 - 100', 'Venue Decoration  Rs.10000, DJ  Rs.20000, Photography  Rs.20000', 27, 'Birthday party ', 'Rs.10000+ Rs.50000= Rs.60000', 'Zawed Akhtar'),
(177, '2019-07-27', 'music_event_img/images (2).jpg', 'Corporate Event, Reception', '3 - 4 hours', 'Music Band  Rs.15000, Karaoke  Rs.10000', 2, 'live music and orchestra', 'Rs.12000+ Rs.25000= Rs.37000', 'Sagar Naik'),
(178, '2019-07-26', 'shows_event_img/download.jpg', 'Birthday Party', '1 - 2 hours', 'Mimicry Show  Rs.30000, Fashion / Beauty Show  Rs.20000', 28, 'Entertainment shows and stalls', 'Rs.15000+ Rs.50000= Rs.65000', 'Akshay Salvi'),
(179, '2019-09-01', 'corporate_event_img/images.jpg', 'Promotional Activity, Conference & Seminar, Celebrity Event / Stage Shows', '3 - 4 hours', 'Mandap Decoration  Rs.10000, Catering  Rs.20000, Sound And Lighting  Rs.10000', 26, 'Commercial event organisers', 'Rs.15000+ Rs.40000= Rs.55000', 'Akash Salvi');

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

--
-- Table structure for table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(200) NOT NULL,
  `name` varchar(500) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` int(10) NOT NULL,
  `city` varchar(500) NOT NULL,
  `event` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `name`, `email`, `phone`, `city`, `event`) VALUES
(1, 'zawed', 'zawed12@gmail.com', 2147483647, 'Mumbai', 'birthday');

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

--
-- Table structure for table `corporate_event_eqi1`
--

CREATE TABLE IF NOT EXISTS `corporate_event_eqi1` (
  `id` int(200) NOT NULL,
  `eqi1` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `corporate_event_eqi1`
--

INSERT INTO `corporate_event_eqi1` (`id`, `eqi1`) VALUES
(1, 'Exhibition / Trade Fair'),
(2, 'Promotional Activity'),
(3, 'Conference & Seminar'),
(4, 'Celebrity Event / Stage Shows'),
(5, 'Launch Celebration'),
(6, 'Corporate Retreat / Picnic'),
(7, 'Roadshow'),
(8, 'Sports Event'),
(9, 'Charity And Donation Camp');

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

--
-- Table structure for table `corporate_event_eqi2`
--

CREATE TABLE IF NOT EXISTS `corporate_event_eqi2` (
  `id` int(200) NOT NULL,
  `eqi2` varchar(500) NOT NULL,
  `rs` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `corporate_event_eqi2`
--

INSERT INTO `corporate_event_eqi2` (`id`, `eqi2`, `rs`) VALUES
(1, 'Flower Decoration', 10000),
(2, 'Venue Decoration', 10000),
(3, 'Mandap Decoration', 10000),
(4, 'DJ', 20000),
(5, 'Catering', 20000),
(6, 'Sound And Lighting', 10000),
(7, 'Anchoring & Hosting', 10000),
(8, 'Photography', 15000),
(9, 'Tents & Tarpaulins Rental', 10000),
(10, 'Furniture Rental', 10000),
(11, 'Manpower provider', 10000),
(12, 'Shamiana/marquee Rental', 20000),
(13, 'Stall / Booth Installation', 10000),
(14, 'Stage Set Up', 10000),
(15, 'Balloon Deoration', 10000),
(16, 'Banner Designing', 10000),
(17, 'Planning And Logistics', 10000),
(18, 'Karaoke System', 10000),
(19, 'Electrical Appliance Rental', 10000),
(20, 'Artist Management', 10000),
(21, 'Return Gifts', 20000);

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

--
-- Table structure for table `eqi1`
--

CREATE TABLE IF NOT EXISTS `eqi1` (
  `eqi1` varchar(200) NOT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `eqi1`
--

INSERT INTO `eqi1` (`eqi1`, `id`) VALUES
('Entire Wedding', 1),
('Reception', 2),
('Sangeet', 3),
('Engagement', 4),
('Christian_Wedding', 5),
('mehdi', 7);

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

--
-- Table structure for table `eqi2`
--

CREATE TABLE IF NOT EXISTS `eqi2` (
  `id` int(200) NOT NULL,
  `eqi2` varchar(200) NOT NULL,
  `rs` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `eqi2`
--

INSERT INTO `eqi2` (`id`, `eqi2`, `rs`) VALUES
(1, 'Flower Decoration', 20000),
(2, 'Venue Decoration', 30000),
(3, 'Mandap Decoration', 20000),
(4, 'DJ', 20000),
(5, 'Catering', 20000),
(6, 'Sound And Lighting', 10000),
(7, 'Anchoring & Hosting', 10000),
(8, 'Photography', 30000),
(9, 'Tents & Tarpaulins Rental', 20000),
(10, 'Furniture Rental', 10000),
(11, 'Manpower provider', 20000),
(12, 'Shamiana/marquee Rental', 20000),
(13, 'Electrical Appliance Rental', 20000),
(14, 'Artist Management', 10000),
(15, 'Return Gifts', 10000);

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

--
-- Table structure for table `feedback`
--

CREATE TABLE IF NOT EXISTS `feedback` (
  `id` int(200) NOT NULL,
  `user_id` int(200) NOT NULL,
  `massage` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `feedback`
--

INSERT INTO `feedback` (`id`, `user_id`, `massage`) VALUES
(64, 2, 'good'),
(65, 28, 'good');

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

--
-- Table structure for table `music_event_eqi1`
--

CREATE TABLE IF NOT EXISTS `music_event_eqi1` (
  `id` int(200) NOT NULL,
  `eqi1` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `music_event_eqi1`
--

INSERT INTO `music_event_eqi1` (`id`, `eqi1`) VALUES
(1, 'Wedding'),
(2, 'Corporate Event'),
(3, 'Reception'),
(4, 'Cancert'),
(5, 'Festival'),
(6, 'Birthday'),
(7, 'Engagement'),
(8, 'Culturals'),
(9, 'Dandiya');

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

--
-- Table structure for table `music_event_eqi2`
--

CREATE TABLE IF NOT EXISTS `music_event_eqi2` (
  `id` int(200) NOT NULL,
  `eqi2` varchar(500) NOT NULL,
  `rs` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `music_event_eqi2`
--

INSERT INTO `music_event_eqi2` (`id`, `eqi2`, `rs`) VALUES
(1, 'Music Band', 15000),
(2, 'Singari Melam', 10000),
(3, 'Balloon Decoration', 10000),
(4, 'Karaoke', 10000),
(5, 'One man Show Orchestra', 20000),
(6, 'Ghazal', 10000),
(7, 'Devotional', 10000),
(8, 'Sufi', 10000),
(9, 'Carnatic', 20000),
(10, 'Chenda Melam', 20000),
(11, 'NadaSwaram', 10000);

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

--
-- Table structure for table `music_time`
--

CREATE TABLE IF NOT EXISTS `music_time` (
  `id` int(200) NOT NULL,
  `time` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `music_time`
--

INSERT INTO `music_time` (`id`, `time`) VALUES
(1, 'Less than 1 hour'),
(2, '1 - 2 hours'),
(3, '3 - 4 hours'),
(4, 'More than 4 hours');

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

--
-- Table structure for table `parsonal_guests`
--

CREATE TABLE IF NOT EXISTS `parsonal_guests` (
  `id` int(200) NOT NULL,
  `guests` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `parsonal_guests`
--

INSERT INTO `parsonal_guests` (`id`, `guests`) VALUES
(1, 'Less than 50'),
(2, '50 - 100'),
(3, '101 - 500'),
(4, 'More than 500');

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

--
-- Table structure for table `personal_event_eqi1`
--

CREATE TABLE IF NOT EXISTS `personal_event_eqi1` (
  `id` int(200) NOT NULL,
  `eqi1` varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `personal_event_eqi1`
--

INSERT INTO `personal_event_eqi1` (`id`, `eqi1`) VALUES
(1, 'Celebration Party'),
(2, 'Bady Shower'),
(3, 'Naming ceremony'),
(4, 'Religious Event'),
(5, 'Retirement / Farewell Party'),
(6, 'Kitty Party'),
(7, 'Group Camp'),
(8, 'Reunion Party'),
(10, 'Vpanayanam');

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

--
-- Table structure for table `personal_event_eqi2`
--

CREATE TABLE IF NOT EXISTS `personal_event_eqi2` (
  `id` int(11) NOT NULL,
  `eqi2` varchar(100) NOT NULL,
  `rs` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `personal_event_eqi2`
--

INSERT INTO `personal_event_eqi2` (`id`, `eqi2`, `rs`) VALUES
(1, 'Flower Decoration', 20000),
(2, 'Venue Decoration', 10000),
(3, 'Balloon Decoration', 30000),
(4, 'DJ', 10000),
(5, 'Catering', 20000),
(6, 'Sound And Lighting', 10000),
(7, 'Anchoring & Hosting', 10000),
(8, 'Photography', 30000),
(9, 'Tents & Tarpaulins Rental', 10000),
(10, 'Furniture Rental', 20000),
(11, 'Manpower provider', 10000),
(12, 'Anchoring & Hosting', 20000),
(13, 'Stage set Up', 30000),
(14, 'Electrical Appliance Rental', 10000),
(15, 'Artist Management', 20000),
(16, 'Return Gifts', 20000);

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

--
-- Table structure for table `shows_event_eqi1`
--

CREATE TABLE IF NOT EXISTS `shows_event_eqi1` (
  `id` int(200) NOT NULL,
  `eqi1` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shows_event_eqi1`
--

INSERT INTO `shows_event_eqi1` (`id`, `eqi1`) VALUES
(1, 'Birthday Party'),
(2, 'Corporate Event'),
(3, 'Culturals'),
(4, 'Wedding');

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

--
-- Table structure for table `shows_event_eqi2`
--

CREATE TABLE IF NOT EXISTS `shows_event_eqi2` (
  `id` int(200) NOT NULL,
  `eqi2` varchar(500) NOT NULL,
  `rs` int(200) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shows_event_eqi2`
--

INSERT INTO `shows_event_eqi2` (`id`, `eqi2`, `rs`) VALUES
(1, 'Magic Show', 20000),
(2, 'Game Show', 10000),
(3, 'Balloon Decoration', 15000),
(4, 'Dance Show', 30000),
(5, 'Mimicry Show', 30000),
(6, 'Puppet Show', 10000),
(7, 'Fashion / Beauty Show', 20000),
(8, 'Music Show', 20000),
(9, 'Comedy Show', 30000),
(10, 'Drama Show', 15000),
(11, 'Mind Reading & Telepathy Show', 20000);

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

--
-- Table structure for table `signup`
--

CREATE TABLE IF NOT EXISTS `signup` (
  `fname` varchar(10) NOT NULL,
  `lname` varchar(10) NOT NULL,
  `email` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `city` varchar(20) NOT NULL,
  `country` varchar(20) NOT NULL,
  `username` varchar(10) NOT NULL,
  `password` varchar(8) NOT NULL,
  `role` varchar(500) NOT NULL,
  `id` int(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `signup`
--

INSERT INTO `signup` (`fname`, `lname`, `email`, `address`, `phone`, `gender`, `city`, `country`, `username`, `password`, `role`, `id`) VALUES
('Sagar', 'Naik', 'sagarnaik20@gmail.com', 'kandivali', '9699904797', 'Male', 'Mumbai', 'India', 'sagar@97', 'sagar@12', 'customer', 2),
('Saurabh', 'Salvi', 'salvisaurabh00@gmail.com', 'worli', '9594801201', '  Male', '  mumbai', '  india', 'saurabh', 'saurabhs', 'admin', 19),
('Akash', 'Salvi', 'salviakash20012@gmail.com', 'worli', '7666301201', '   Male', '   Mumbai', '   India', 'akash', 'akash123', 'customer', 26),
('Zawed', 'Akhtar', 'zawed12@gmail.com', 'Dharavi', '9812976544', ' Male', ' Mumbai', ' India', 'zawed', 'zawed123', 'customer', 27),
('Akshay', 'Salvi', 'akshay@gmail.com', 'worli', '9594301201', ' Male', ' mumbai', ' India', 'akshay', 'saurabhs', 'customer', 28);

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

--
-- Table structure for table `wedding_guests`
--

CREATE TABLE IF NOT EXISTS `wedding_guests` (
  `id` int(200) NOT NULL,
  `guests` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wedding_guests`
--

INSERT INTO `wedding_guests` (`id`, `guests`) VALUES
(1, 'Less than 100'),
(2, '101 - 500'),
(3, '501 - 1,000'),
(4, 'More than 1,000');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `add_event`
--
ALTER TABLE `add_event`
  ADD PRIMARY KEY (`id`), ADD KEY `name` (`name`);

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

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

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

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

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

--
-- Indexes for table `book`
--
ALTER TABLE `book`
  ADD PRIMARY KEY (`booking_id`), ADD KEY `user_id` (`user_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `add_birthday_event`
--
ALTER TABLE `add_birthday_event`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `add_corporate_event`
--
ALTER TABLE `add_corporate_event`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `add_event`
--
ALTER TABLE `add_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `add_music_event`
--
ALTER TABLE `add_music_event`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `add_personal_event`
--
ALTER TABLE `add_personal_event`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `add_shows_event`
--
ALTER TABLE `add_shows_event`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `birthday_event_eqi1`
--
ALTER TABLE `birthday_event_eqi1`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `birthday_event_eqi2`
--
ALTER TABLE `birthday_event_eqi2`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `book`
--
ALTER TABLE `book`
  MODIFY `booking_id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=180;
--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `corporate_event_eqi1`
--
ALTER TABLE `corporate_event_eqi1`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `corporate_event_eqi2`
--
ALTER TABLE `corporate_event_eqi2`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `eqi1`
--
ALTER TABLE `eqi1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `eqi2`
--
ALTER TABLE `eqi2`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `feedback`
--
ALTER TABLE `feedback`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=66;
--
-- AUTO_INCREMENT for table `music_event_eqi1`
--
ALTER TABLE `music_event_eqi1`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `music_event_eqi2`
--
ALTER TABLE `music_event_eqi2`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `music_time`
--
ALTER TABLE `music_time`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `parsonal_guests`
--
ALTER TABLE `parsonal_guests`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `personal_event_eqi1`
--
ALTER TABLE `personal_event_eqi1`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `personal_event_eqi2`
--
ALTER TABLE `personal_event_eqi2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `shows_event_eqi1`
--
ALTER TABLE `shows_event_eqi1`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `shows_event_eqi2`
--
ALTER TABLE `shows_event_eqi2`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `signup`
--
ALTER TABLE `signup`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `wedding_guests`
--
ALTER TABLE `wedding_guests`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
/*!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 */;
