File: /home/imensosw/www/imenso.co/demo/zuruuna/wedding_web.sql
-- phpMyAdmin SQL Dump
-- version 4.3.11
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Nov 04, 2016 at 09:37 AM
-- Server version: 5.6.24
-- PHP Version: 5.6.8
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: `wedding_web`
--
-- --------------------------------------------------------
--
-- Table structure for table `we_category`
--
CREATE TABLE IF NOT EXISTS `we_category` (
`id` int(11) NOT NULL,
`category_name` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_category`
--
INSERT INTO `we_category` (`id`, `category_name`) VALUES
(4, 'Ceremony'),
(5, 'Reception'),
(6, 'Attire'),
(7, 'Beauty'),
(8, 'Flowers'),
(9, 'Photograhy'),
(10, 'Stationary'),
(11, 'Gifts'),
(12, 'Transportation'),
(13, 'Lodging'),
(14, 'Honeymoon');
-- --------------------------------------------------------
--
-- Table structure for table `we_event`
--
CREATE TABLE IF NOT EXISTS `we_event` (
`id` int(11) NOT NULL,
`event_name` varchar(100) NOT NULL,
`event_type` varchar(20) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_event`
--
INSERT INTO `we_event` (`id`, `event_name`, `event_type`) VALUES
(4, 'Wedding', '2'),
(5, 'Baby Shower', '1'),
(6, 'Marriage Anniversary', '2'),
(7, 'Engagement', '2'),
(8, 'Christmas', '1'),
(9, 'Eid-ul', '1');
-- --------------------------------------------------------
--
-- Table structure for table `we_event_cat`
--
CREATE TABLE IF NOT EXISTS `we_event_cat` (
`id` bigint(20) NOT NULL,
`event_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_event_cat`
--
INSERT INTO `we_event_cat` (`id`, `event_id`, `category_id`) VALUES
(9, 5, 6),
(10, 5, 7),
(11, 5, 8),
(12, 5, 9),
(13, 5, 11),
(14, 5, 12),
(22, 7, 7),
(23, 7, 8),
(24, 7, 9),
(25, 7, 11),
(35, 8, 4),
(36, 8, 5),
(37, 8, 6),
(38, 8, 7),
(49, 9, 4),
(50, 9, 5),
(51, 9, 6),
(52, 9, 7),
(53, 9, 8),
(54, 9, 9),
(55, 9, 10),
(56, 9, 12),
(57, 4, 4),
(58, 4, 6),
(59, 4, 7),
(60, 4, 8),
(61, 4, 9),
(62, 4, 10),
(63, 4, 11),
(64, 4, 12),
(65, 4, 13),
(66, 4, 14),
(74, 6, 4),
(75, 6, 5),
(76, 6, 7),
(77, 6, 8),
(78, 6, 9),
(79, 6, 11),
(80, 6, 12);
-- --------------------------------------------------------
--
-- Table structure for table `we_registration`
--
CREATE TABLE IF NOT EXISTS `we_registration` (
`reg_id` bigint(20) NOT NULL,
`reg_name` varchar(100) NOT NULL,
`mobile_no` varchar(100) NOT NULL,
`address` longtext NOT NULL,
`reg_email` varchar(255) NOT NULL,
`reg_password` varchar(255) NOT NULL,
`reg_status` varchar(1) NOT NULL,
`reg_date` date NOT NULL,
`events` int(11) NOT NULL,
`access_key` varchar(255) NOT NULL,
`user_type` varchar(10) NOT NULL DEFAULT 'USER'
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_registration`
--
INSERT INTO `we_registration` (`reg_id`, `reg_name`, `mobile_no`, `address`, `reg_email`, `reg_password`, `reg_status`, `reg_date`, `events`, `access_key`, `user_type`) VALUES
(1, 'jay', '', '', 'jparihar69@gmail.com', '123', '1', '2016-05-16', 1, '07d258', 'USER'),
(5, 'rahul joshi', '', '', 'rahuljoshi.gogu@gmail.com', '123123', 'Y', '2016-05-18', 0, 'o7d242', 'USER'),
(6, 'Jay Parihar', '', '', 'jparihar69@yahoo.com', '123456', 'Y', '2016-05-18', 0, 'o7d512', 'USER'),
(7, 'Time Out', '', '', 'ohotimeout@gmail.com', '123123', 'Y', '2016-05-18', 1, 'o7dnwa', 'USER'),
(8, 'Megha Singh', '', '', 'mthakur@imensosoftware.com', '123456', 'Y', '2016-05-18', 1, 'o7dqw9', 'USER'),
(9, 'Mireille Maalouf', '', '', 'meray@hotmail.com', 'iiiiii', 'Y', '2016-05-18', 1, 'o7dsa1', 'USER'),
(10, 'Bernard Sebahieh', '', '', 'test@test.com', '123456', 'Y', '2016-05-18', 1, 'o7dt2q', 'USER'),
(11, 'Bernard', '', '', 'bernard@gmail.com', '123456', 'Y', '2016-05-18', 1, 'o7dtc0', 'USER'),
(12, 'meray', '', '', 'meray@meray.com', '123456', 'Y', '2016-05-19', 0, 'o7eob6', 'USER'),
(13, 'hadi', '', '', 'hadi@hadi.com', '123456', 'Y', '2016-05-19', 1, 'o7eqyn', 'USER'),
(14, 'Bernard', '', '', 'bernad@gmail.com', 'aaaaaa', 'Y', '2016-05-19', 1, 'o7f40q', 'USER'),
(15, 'juruna', '', '', 'juruna@gmail.com', '123456', 'Y', '2016-05-19', 1, 'o7fa06', 'USER'),
(16, 'bernard ', '', '', 'bernards@gmail.com', '123456', 'Y', '2016-05-19', 1, 'o7fppi', 'USER'),
(17, 'Bernard', '', '', 'bernardn@gmail.com', '123456', 'Y', '2016-05-20', 0, 'o7h269', 'USER'),
(18, 'bernard', '', '', '123@123.com', '123456', 'Y', '2016-05-20', 1, 'o7h6u2', 'USER'),
(19, 'timeout', '', '', 'timeout@gmail.com', '123123', 'Y', '2016-05-20', 0, 'o7hcsf', 'USER'),
(20, 'ttadmin', '', '', 'ttadmin@gmail.com', '123123', 'Y', '2016-05-20', 0, 'o7hd09', 'USER'),
(21, 'Bernard Sebahieh', '', '', 'test@test1.om', '123456', 'Y', '2016-05-20', 1, 'o7hmje', 'USER'),
(22, 'BANDAR ALASADI', '', '', 'bandarsar@me.com', 'Arnoob', 'Y', '2016-05-22', 1, 'o7ki5j', 'USER'),
(23, 'prateek', '', '', 'prateek@prateek.com', '123456', 'Y', '2016-05-22', 1, 'o7kjx5', 'USER'),
(24, 'Humaid', '', '', 'zayedforever@gmail.com', 'hba1710017', 'Y', '2016-05-23', 1, 'o7m9sx', 'USER'),
(25, 'Salim El Massih', '', '', 'tryme@hotmail.com', '123456', 'Y', '2016-05-23', 1, 'o7mdxa', 'USER'),
(26, 'timetime', '', '', 'timetime@gmail.com', 'timetime', '1', '2016-05-24', 1, 'eds32', 'USER'),
(27, 'time', '', '', 'time@gmail.com', '123123', 'Y', '2016-06-02', 1, 'o85364', 'USER'),
(28, 'Devendra kag', '', '', 'kag.dev004@gmail.com', '123456', 'Y', '2016-06-07', 1, 'o8e852', 'USER'),
(29, 'full name', '', '', 'full@gmail.com', 'fullname', 'Y', '2016-06-21', 0, 'o943dm', 'USER'),
(30, '', '', '', '', '', 'Y', '2016-06-22', 0, 'o962za', 'USER');
-- --------------------------------------------------------
--
-- Table structure for table `we_review`
--
CREATE TABLE IF NOT EXISTS `we_review` (
`id` int(11) NOT NULL,
`review_type` varchar(20) NOT NULL DEFAULT 'VENDOR',
`review_date` date NOT NULL,
`review` longtext NOT NULL,
`review_point` int(1) NOT NULL DEFAULT '3',
`review_by` bigint(20) NOT NULL,
`review_for` bigint(20) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_review`
--
INSERT INTO `we_review` (`id`, `review_type`, `review_date`, `review`, `review_point`, `review_by`, `review_for`) VALUES
(1, 'VENDOR', '2016-06-24', 'Best vendor ever !', 4, 16, 0),
(2, 'VENDOR', '2016-06-24', 'cfsafdsf', 4, 16, 16),
(3, 'VENDOR', '2016-10-26', 'sfafsf', 3, 16, 16),
(4, 'VENDOR', '2016-10-26', 'sfafsf', 1, 16, 16);
-- --------------------------------------------------------
--
-- Table structure for table `we_setting`
--
CREATE TABLE IF NOT EXISTS `we_setting` (
`ID` int(11) NOT NULL,
`site_url` varchar(255) NOT NULL,
`website_url` text NOT NULL,
`basic_path` varchar(255) NOT NULL,
`admin_email` varchar(100) NOT NULL,
`site_title` varchar(50) NOT NULL DEFAULT 'Wedding',
`site_logo` varchar(255) NOT NULL,
`default_user_image` varchar(255) NOT NULL,
`fb_app_id` varchar(255) NOT NULL DEFAULT '1652462151670702'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_setting`
--
INSERT INTO `we_setting` (`ID`, `site_url`, `website_url`, `basic_path`, `admin_email`, `site_title`, `site_logo`, `default_user_image`, `fb_app_id`) VALUES
(1, 'http://10.0.0.6/zuruuna/administrator/', 'http://10.0.0.6/zuruuna/', 'D:/xampp/htdocs/zuruuna/', 'rahuljoshi.gogu@gmail.com', 'Wedding', 'logo.png', 'user-default.png', '1652462151670702');
-- --------------------------------------------------------
--
-- Table structure for table `we_user`
--
CREATE TABLE IF NOT EXISTS `we_user` (
`ID` bigint(20) NOT NULL,
`username` varchar(50) NOT NULL,
`useremail` varchar(50) NOT NULL,
`userpassword` varchar(50) NOT NULL,
`access_key` varchar(100) NOT NULL,
`active` varchar(1) NOT NULL DEFAULT 'N',
`regdate` date NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_user`
--
INSERT INTO `we_user` (`ID`, `username`, `useremail`, `userpassword`, `access_key`, `active`, `regdate`) VALUES
(1, 'admin', 'admin@gmail.com', 'admin123', 'ASD112', 'Y', '0000-00-00'),
(2, 'timeout', 'ohotimeout@gmail.com', '123456', 'o6yfrq', 'N', '2016-05-10');
-- --------------------------------------------------------
--
-- Table structure for table `we_users_event`
--
CREATE TABLE IF NOT EXISTS `we_users_event` (
`id` bigint(20) NOT NULL,
`event_id` int(11) NOT NULL,
`event_location` varchar(255) NOT NULL,
`event_address` longtext NOT NULL,
`event_date` date NOT NULL,
`event_budget` decimal(11,0) NOT NULL,
`event_user` bigint(20) NOT NULL,
`status` int(1) NOT NULL,
`create_date` date NOT NULL,
`first_fname` varchar(50) NOT NULL,
`first_lname` varchar(50) NOT NULL,
`second_fname` varchar(50) NOT NULL,
`second_lname` varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_users_event`
--
INSERT INTO `we_users_event` (`id`, `event_id`, `event_location`, `event_address`, `event_date`, `event_budget`, `event_user`, `status`, `create_date`, `first_fname`, `first_lname`, `second_fname`, `second_lname`) VALUES
(7, 5, 'Gurgaon, Haryana, India', 'Event Address', '2016-06-30', '10000', 5, 1, '2016-05-18', 'Rahul', 'Joshi', 'Gogu', 'Joshi'),
(10, 5, 'Nedwell Place, Taranganba, Queensland, Australia', 'Nedwell place', '2016-06-16', '223', 1, 1, '2016-05-18', '', '', '', ''),
(12, 4, 'Dubai - United Arab Emirates', '', '2016-05-31', '100000', 8, 1, '2016-05-18', '', '', '', ''),
(13, 5, 'Dubai - United Arab Emirates', '', '2016-05-26', '20000', 9, 1, '2016-05-18', '', '', '', ''),
(14, 4, 'Dubai - United Arab Emirates', '', '2016-05-17', '5000', 10, 1, '2016-05-18', '', '', '', ''),
(15, 5, '', '', '2016-05-25', '2000', 11, 1, '2016-05-18', '', '', '', ''),
(16, 4, 'Dubai - United Arab Emirates', '', '2016-05-19', '3000', 13, 1, '2016-05-19', '', '', '', ''),
(17, 4, '', 'Dubai', '0000-00-00', '0', 14, 1, '2016-05-19', '', '', '', ''),
(18, 4, 'Indore, Madhya Pradesh, India', 'roger mei road', '2016-05-17', '2000', 15, 1, '2016-05-19', '', '', '', ''),
(19, 4, 'New York, NY, United States', 'Springfield Gardens', '2016-05-31', '30000', 16, 1, '2016-05-19', '', '', '', ''),
(20, 4, 'ritz-carlton dubai', 'ritz carlton', '2016-09-16', '5000', 18, 1, '2016-05-20', '', '', '', ''),
(21, 5, 'Testour, Beja, Tunisia', 'test 1', '2016-05-31', '20000', 21, 1, '2016-05-20', '', '', '', ''),
(22, 5, 'Jumeira 1 - Jumeirah - Dubai - United Arab Emirates', 'MArina', '2016-05-30', '40000', 22, 1, '2016-05-22', '', '', '', ''),
(23, 4, 'IBG Building, 7th Street, Butuan City, Caraga, Philippines', 'souq', '2016-05-31', '20000', 23, 1, '2016-05-22', '', '', '', ''),
(24, 4, 'Gulf News 1 - Al Wasl - Dubai - United Arab Emirates', 'GULF NEWS', '2016-08-31', '20000', 24, 1, '2016-05-23', '', '', '', ''),
(25, 4, 'vapiano ', 'vapiano', '2016-05-10', '50000', 25, 1, '2016-05-23', '', '', '', ''),
(26, 4, 'Gurgaon Bus Stand, Block B, Gurgaon, Haryana, India', 'address', '2016-05-28', '10000', 26, 1, '2016-05-24', '', '', '', ''),
(28, 6, 'Location of the Oldest Primary School Among Akhun Khel Territory, Harrori - Khakoo - Singlekot Road, Khakoo, Khyber Pakhtunkhwa, Pakistan', 'address', '2016-06-22', '22222', 7, 1, '2016-06-02', 'Time', 'Out', 'Time', 'In'),
(31, 4, 'Lodhi Colony, New Delhi, Delhi, India', 'address', '2016-06-14', '10000', 27, 1, '2016-06-02', 'Time', 'Time', 'Time', 'Time'),
(32, 4, 'Sector 48, Gurgaon, Haryana, India', 'Hyat regecy', '2016-06-30', '250000', 28, 1, '2016-06-07', 'Aladin', 'Sheik', 'Jasmin', 'Sheik');
-- --------------------------------------------------------
--
-- Table structure for table `we_users_event_cat`
--
CREATE TABLE IF NOT EXISTS `we_users_event_cat` (
`id` bigint(20) NOT NULL,
`event_user` bigint(20) NOT NULL,
`event_id` int(11) NOT NULL,
`user_event_id` bigint(20) NOT NULL,
`category_id` int(11) NOT NULL,
`end_date` date NOT NULL,
`budget` decimal(11,2) NOT NULL,
`actual_budget` decimal(11,2) NOT NULL,
`status` int(1) NOT NULL DEFAULT '0',
`event_cat_note` longtext NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_users_event_cat`
--
INSERT INTO `we_users_event_cat` (`id`, `event_user`, `event_id`, `user_event_id`, `category_id`, `end_date`, `budget`, `actual_budget`, `status`, `event_cat_note`) VALUES
(13, 1, 5, 10, 6, '2016-05-03', '123000.00', '0.00', 1, ''),
(14, 1, 5, 10, 7, '0000-00-00', '0.00', '0.00', 0, ''),
(15, 1, 5, 10, 8, '0000-00-00', '0.00', '0.00', 0, ''),
(16, 1, 5, 10, 9, '2016-05-31', '0.00', '0.00', 0, ''),
(22, 8, 4, 12, 4, '2016-05-04', '1200.00', '0.00', 1, ''),
(23, 8, 4, 12, 6, '2016-05-11', '1000.00', '0.00', 1, ''),
(24, 8, 4, 12, 7, '2016-05-19', '1000.00', '0.00', 0, ''),
(25, 8, 4, 12, 8, '0000-00-00', '0.00', '0.00', 0, ''),
(26, 8, 4, 12, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(27, 8, 4, 12, 13, '0000-00-00', '0.00', '0.00', 0, ''),
(28, 8, 4, 12, 14, '0000-00-00', '0.00', '0.00', 0, ''),
(29, 9, 5, 13, 6, '2016-05-11', '4000.00', '0.00', 0, ''),
(30, 9, 5, 13, 7, '0000-00-00', '0.00', '0.00', 0, ''),
(31, 9, 5, 13, 8, '0000-00-00', '0.00', '0.00', 0, ''),
(32, 9, 5, 13, 9, '0000-00-00', '0.00', '0.00', 0, ''),
(33, 9, 5, 13, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(34, 9, 5, 13, 12, '0000-00-00', '0.00', '0.00', 0, ''),
(35, 10, 4, 14, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(36, 10, 4, 14, 12, '0000-00-00', '0.00', '0.00', 0, ''),
(37, 10, 4, 14, 13, '0000-00-00', '0.00', '0.00', 0, ''),
(38, 13, 4, 16, 4, '2016-05-17', '200.00', '0.00', 0, ''),
(39, 13, 4, 16, 6, '0000-00-00', '0.00', '0.00', 0, ''),
(40, 13, 4, 16, 7, '0000-00-00', '0.00', '0.00', 0, ''),
(41, 13, 4, 16, 8, '0000-00-00', '0.00', '0.00', 0, ''),
(42, 13, 4, 16, 9, '0000-00-00', '0.00', '0.00', 0, ''),
(43, 13, 4, 16, 10, '0000-00-00', '0.00', '0.00', 0, ''),
(44, 13, 4, 16, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(48, 15, 4, 18, 4, '0000-00-00', '0.00', '0.00', 0, ''),
(49, 15, 4, 18, 6, '0000-00-00', '0.00', '0.00', 0, ''),
(50, 15, 4, 18, 12, '0000-00-00', '0.00', '0.00', 0, ''),
(51, 16, 4, 19, 4, '0000-00-00', '1000.00', '3000.00', 0, ''),
(52, 16, 4, 19, 6, '0000-00-00', '0.00', '0.00', 0, ''),
(53, 16, 4, 19, 7, '0000-00-00', '0.00', '0.00', 0, ''),
(54, 16, 4, 19, 12, '0000-00-00', '0.00', '0.00', 0, ''),
(55, 16, 4, 19, 13, '0000-00-00', '0.00', '0.00', 0, ''),
(60, 18, 4, 20, 4, '2016-05-25', '500.00', '0.00', 0, ''),
(61, 18, 4, 20, 6, '2016-05-25', '100.00', '0.00', 0, ''),
(62, 18, 4, 20, 7, '2016-05-11', '55.00', '155.00', 0, 'This is the price of beauty'),
(63, 18, 4, 20, 8, '2016-05-31', '400.00', '0.00', 0, ''),
(64, 18, 4, 20, 9, '0000-00-00', '0.00', '0.00', 0, ''),
(65, 18, 4, 20, 10, '0000-00-00', '0.00', '0.00', 0, ''),
(66, 18, 4, 20, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(67, 18, 4, 20, 12, '0000-00-00', '0.00', '0.00', 0, ''),
(68, 18, 4, 20, 13, '0000-00-00', '0.00', '0.00', 0, ''),
(69, 18, 4, 20, 14, '0000-00-00', '0.00', '0.00', 0, ''),
(71, 22, 5, 22, 7, '2016-05-12', '1000.00', '2000.00', 0, ''),
(72, 22, 5, 22, 8, '2016-05-21', '900.00', '0.00', 0, ''),
(73, 22, 5, 22, 9, '2016-05-20', '999.00', '0.00', 0, ''),
(74, 22, 5, 22, 12, '2016-06-27', '999.00', '0.00', 0, ''),
(75, 23, 4, 23, 6, '2016-05-15', '200.00', '0.00', 0, ''),
(76, 23, 4, 23, 7, '2016-05-28', '100.00', '0.00', 0, ''),
(77, 23, 4, 23, 8, '0000-00-00', '0.00', '0.00', 0, ''),
(78, 23, 4, 23, 10, '0000-00-00', '0.00', '0.00', 0, ''),
(79, 23, 4, 23, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(80, 23, 4, 23, 14, '0000-00-00', '0.00', '0.00', 0, ''),
(81, 24, 4, 24, 4, '0000-00-00', '0.00', '0.00', 0, ''),
(82, 24, 4, 24, 6, '0000-00-00', '0.00', '0.00', 0, ''),
(83, 24, 4, 24, 7, '0000-00-00', '0.00', '0.00', 0, ''),
(84, 24, 4, 24, 8, '0000-00-00', '0.00', '0.00', 0, ''),
(85, 24, 4, 24, 9, '0000-00-00', '0.00', '0.00', 0, ''),
(86, 24, 4, 24, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(87, 24, 4, 24, 12, '0000-00-00', '0.00', '0.00', 0, ''),
(88, 24, 4, 24, 14, '0000-00-00', '0.00', '0.00', 0, ''),
(89, 25, 4, 25, 4, '2016-05-09', '200.00', '300.00', 0, ''),
(90, 25, 4, 25, 6, '0000-00-00', '0.00', '0.00', 0, ''),
(91, 25, 4, 25, 7, '0000-00-00', '0.00', '0.00', 0, ''),
(92, 25, 4, 25, 8, '0000-00-00', '0.00', '0.00', 0, ''),
(93, 25, 4, 25, 9, '0000-00-00', '0.00', '0.00', 0, ''),
(94, 25, 4, 25, 10, '0000-00-00', '0.00', '0.00', 0, ''),
(95, 25, 4, 25, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(106, 26, 4, 26, 4, '2016-05-20', '0.00', '0.00', 0, ''),
(107, 26, 4, 26, 6, '2016-05-20', '0.00', '0.00', 0, ''),
(108, 26, 4, 26, 7, '2016-05-20', '0.00', '0.00', 0, ''),
(109, 26, 4, 26, 8, '2016-05-19', '0.00', '0.00', 0, ''),
(110, 26, 4, 26, 9, '2016-05-28', '0.00', '0.00', 0, ''),
(113, 26, 4, 26, 12, '2016-05-26', '0.00', '0.00', 0, ''),
(114, 26, 4, 26, 11, '2016-05-27', '0.00', '0.00', 0, ''),
(119, 7, 6, 28, 4, '2016-06-16', '1000.00', '0.00', 0, ''),
(120, 7, 6, 28, 5, '2016-06-24', '1200.00', '0.00', 0, ''),
(121, 7, 6, 28, 7, '2016-06-25', '1400.00', '0.00', 0, ''),
(122, 28, 4, 32, 4, '2016-06-08', '1000.00', '0.00', 0, ''),
(123, 28, 4, 32, 6, '2016-06-15', '1000.00', '0.00', 0, ''),
(124, 28, 4, 32, 7, '0000-00-00', '0.00', '0.00', 0, ''),
(125, 28, 4, 32, 8, '0000-00-00', '0.00', '0.00', 0, ''),
(126, 28, 4, 32, 9, '0000-00-00', '0.00', '0.00', 0, ''),
(127, 28, 4, 32, 10, '0000-00-00', '0.00', '0.00', 0, ''),
(128, 28, 4, 32, 11, '0000-00-00', '0.00', '0.00', 0, ''),
(129, 28, 4, 32, 12, '0000-00-00', '0.00', '0.00', 0, ''),
(130, 28, 4, 32, 13, '0000-00-00', '0.00', '0.00', 0, ''),
(131, 28, 4, 32, 14, '0000-00-00', '0.00', '0.00', 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `we_users_event_guestlist`
--
CREATE TABLE IF NOT EXISTS `we_users_event_guestlist` (
`id` bigint(20) NOT NULL,
`event_user` bigint(20) NOT NULL,
`user_event_id` bigint(20) NOT NULL,
`guest_name` varchar(50) NOT NULL,
`guest_email` varchar(100) NOT NULL,
`guest_contact_no` varchar(50) NOT NULL,
`guest_address` longtext NOT NULL,
`guest_location` longtext NOT NULL,
`no_of_guest` int(11) NOT NULL,
`no_of_plus_guest` int(11) NOT NULL,
`guest_note` longtext NOT NULL,
`entry_date` date NOT NULL,
`guest_status` int(1) NOT NULL DEFAULT '0',
`guest_of` varchar(20) NOT NULL DEFAULT '-'
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_users_event_guestlist`
--
INSERT INTO `we_users_event_guestlist` (`id`, `event_user`, `user_event_id`, `guest_name`, `guest_email`, `guest_contact_no`, `guest_address`, `guest_location`, `no_of_guest`, `no_of_plus_guest`, `guest_note`, `entry_date`, `guest_status`, `guest_of`) VALUES
(8, 5, 7, 'Rahul joshi', 'rahuljoshi@gmail.com', '2123212321', 'My Address', 'lll', 1, 0, 'Notes', '2016-05-24', 0, '-'),
(9, 1, 10, 'Bobby', 'jparihar@imensosoftware.com', '8976542211', 'Gurgaon', '', 0, 0, 'test note', '2016-05-25', 0, '-'),
(10, 1, 10, 'Suunny', 'Deol', '9876543210', 'indore', '', 0, 0, 'test note', '2016-05-25', 0, '-'),
(11, 1, 10, 'oliver', 'oliver@bmail.com', '0987654321', 'indore', '', 0, 0, 'indore', '2016-05-25', 0, '-'),
(12, 5, 7, 'mohan', 'mohan@gmail.com', '3212343212', 'address', 'location', 3, 2, 'Note', '2016-05-30', 0, '-'),
(15, 7, 28, 'Rahul joshi', 'rahul@gmail.com', '', '', '', 1, 0, '', '2016-06-02', 0, 'bride');
-- --------------------------------------------------------
--
-- Table structure for table `we_user_event_website`
--
CREATE TABLE IF NOT EXISTS `we_user_event_website` (
`id` bigint(20) NOT NULL,
`website_name` varchar(50) NOT NULL,
`user_event_id` bigint(20) NOT NULL,
`event_user` bigint(20) NOT NULL,
`cover_image` text NOT NULL,
`our_story` longtext NOT NULL,
`ceremony_location` longtext NOT NULL,
`ceremony_location_lat` varchar(100) NOT NULL,
`ceremony_location_lon` varchar(100) NOT NULL,
`ceremony_location_note` longtext NOT NULL,
`party_location` longtext NOT NULL,
`party_location_lat` varchar(100) NOT NULL,
`party_location_lon` varchar(100) NOT NULL,
`party_location_note` longtext NOT NULL,
`fb_app_id` text NOT NULL,
`fb_page_url` text NOT NULL,
`fb_data_small_header` varchar(5) NOT NULL DEFAULT 'true',
`fb_data_hide_cover` varchar(5) NOT NULL DEFAULT 'false',
`fb_data_tab` varchar(255) NOT NULL,
`fb_show_facepile` varchar(5) NOT NULL DEFAULT 'true',
`tw_ac_url` varchar(255) NOT NULL,
`tw_tweet_limit` int(1) NOT NULL DEFAULT '5',
`tw_widget_id` varchar(255) NOT NULL,
`tw_nofooter` int(1) NOT NULL DEFAULT '0',
`tw_noborders` int(1) NOT NULL DEFAULT '0',
`tw_noheader` int(1) NOT NULL DEFAULT '0',
`tw_noscrollbar` int(1) NOT NULL DEFAULT '0',
`tw_transparent` int(1) NOT NULL DEFAULT '0',
`entry_date` date NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_user_event_website`
--
INSERT INTO `we_user_event_website` (`id`, `website_name`, `user_event_id`, `event_user`, `cover_image`, `our_story`, `ceremony_location`, `ceremony_location_lat`, `ceremony_location_lon`, `ceremony_location_note`, `party_location`, `party_location_lat`, `party_location_lon`, `party_location_note`, `fb_app_id`, `fb_page_url`, `fb_data_small_header`, `fb_data_hide_cover`, `fb_data_tab`, `fb_show_facepile`, `tw_ac_url`, `tw_tweet_limit`, `tw_widget_id`, `tw_nofooter`, `tw_noborders`, `tw_noheader`, `tw_noscrollbar`, `tw_transparent`, `entry_date`) VALUES
(27, 'rahuljoshi', 7, 5, '1465565962_Tulips.jpg', '<p>zsgdsfgdgggdfgfgggdfg</p>', 'WZ-8/1, Railway Rd, Kheri, Kheri, Ashok Vihar, Sector 3, Gurgaon Rural, Haryana 122006, India', '28.4888742', '77.0108295', 'dddd', 'Hemwati Nandan Bahuguna Marg, Karampura Market, Karam Pura, New Delhi, Delhi 110015, India', '28.66138199999999', '77.14713400000005', 'note', '1652462151670702', 'https://www.facebook.com/VoiceOfHeart.JiOooDilSe/', 'true', 'false', 'timeline', 'true', 'https://twitter.com/hashtag/rahul', 10, '', 0, 0, 0, 0, 0, '2016-06-10'),
(28, 'jay', 10, 1, '', '<p>fsdgsdgsg</p>', '', '', '', '', '', '', '', '', '1652462151670702', '', 'true', 'false', 'timeline', 'true', '', 0, '', 0, 0, 0, 0, 0, '2016-06-10'),
(31, '31o85364', 31, 27, '', '', '', '', '', '', '', '', '', '', '1652462151670702', '', 'true', 'false', 'timeline', 'true', '', 5, '', 0, 0, 0, 0, 0, '2016-06-02'),
(32, '32o8e852', 32, 28, '', '', '', '', '', '', '', '', '', '', '', '', 'true', 'false', '', 'true', '', 5, '', 0, 0, 0, 0, 0, '2016-06-07'),
(33, 'jay-manisha2', 0, 1, '', '', '', '', '', '', '', '', '', '', '1652462151670702', '', 'true', 'false', 'timeline', 'true', '', 0, '', 0, 0, 0, 0, 0, '2016-06-10');
-- --------------------------------------------------------
--
-- Table structure for table `we_user_event_website_photos`
--
CREATE TABLE IF NOT EXISTS `we_user_event_website_photos` (
`id` bigint(20) NOT NULL,
`website_id` bigint(20) NOT NULL,
`image_name` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_user_event_website_photos`
--
INSERT INTO `we_user_event_website_photos` (`id`, `website_id`, `image_name`) VALUES
(66, 27, '1465565624_Jellyfish.jpg'),
(67, 27, '1465565624_Koala.jpg'),
(69, 27, '1465565962_Hydrangeas.jpg'),
(70, 27, '1465565962_Jellyfish.jpg'),
(71, 27, '1465565962_Koala.jpg'),
(72, 27, '1465565962_Lighthouse.jpg'),
(73, 27, '1465565962_Penguins.jpg');
-- --------------------------------------------------------
--
-- Table structure for table `we_user_event_wishes`
--
CREATE TABLE IF NOT EXISTS `we_user_event_wishes` (
`id` bigint(20) NOT NULL,
`entry_date` date NOT NULL,
`author_name` varchar(50) NOT NULL,
`author_email` varchar(255) NOT NULL,
`author_contact_no` varchar(20) NOT NULL,
`author_wish` longtext NOT NULL,
`website_id` bigint(20) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_user_event_wishes`
--
INSERT INTO `we_user_event_wishes` (`id`, `entry_date`, `author_name`, `author_email`, `author_contact_no`, `author_wish`, `website_id`) VALUES
(4, '0000-00-00', 'Mohit', '', '', 'Congrzzzzzzzzzzzzz.! :)', 27),
(5, '2016-06-01', 'Rahul', '', '', 'Wish', 27),
(6, '2016-06-01', 'Mohit', '', '', 'vsdv', 27),
(7, '2016-06-01', 'Mohan', '', '', 'Mohin Babu', 27),
(8, '2016-06-01', 'My Name', '', '', 'My Wish Is Boot badi!', 27),
(9, '2016-06-01', 'Manoz', '', '', 'Mazozzz Wishhhhhhhhhhhhhhhh', 27),
(10, '2016-06-01', 'ddd', '', '', 'fsdff', 27),
(11, '2016-06-01', 'jay', '', '', 'please send tmy greeting', 28);
-- --------------------------------------------------------
--
-- Table structure for table `we_user_personal`
--
CREATE TABLE IF NOT EXISTS `we_user_personal` (
`ID` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`fname` varchar(20) NOT NULL,
`lname` varchar(20) NOT NULL,
`fiance_fname` varchar(20) NOT NULL,
`fiance_lname` varchar(20) NOT NULL,
`username` varchar(20) NOT NULL,
`address_line1` varchar(255) NOT NULL,
`address_line2` varchar(255) NOT NULL,
`address_location` varchar(20) NOT NULL,
`address_zip` varchar(10) NOT NULL,
`user_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `we_user_wedding`
--
CREATE TABLE IF NOT EXISTS `we_user_wedding` (
`ID` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`role` varchar(20) NOT NULL,
`wedding_location` varchar(20) NOT NULL,
`wedding_date` date NOT NULL,
`wedding_budget` decimal(11,2) NOT NULL,
`number_of_guest` int(11) NOT NULL,
`wedding_theme` varchar(20) NOT NULL,
`wedding_colors` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `we_vendor`
--
CREATE TABLE IF NOT EXISTS `we_vendor` (
`id` bigint(20) NOT NULL,
`reg_id` bigint(20) NOT NULL,
`business_name` varchar(255) NOT NULL,
`business_description` longtext NOT NULL,
`vendor_image` varchar(255) NOT NULL,
`min_price` decimal(11,2) NOT NULL DEFAULT '0.00',
`max_price` decimal(11,2) NOT NULL DEFAULT '0.00',
`business_address` longtext NOT NULL,
`imp_details` longtext NOT NULL,
`vendor_name` varchar(255) NOT NULL,
`vendor_email` varchar(255) NOT NULL,
`vendor_pass` varchar(255) NOT NULL,
`vendor_status` varchar(20) NOT NULL,
`vendor_contact_no` varchar(50) NOT NULL,
`access_key` varchar(20) NOT NULL,
`category_id` bigint(20) NOT NULL,
`level_id` int(5) NOT NULL,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`entry_date` date NOT NULL,
`update_date` date NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_vendor`
--
INSERT INTO `we_vendor` (`id`, `reg_id`, `business_name`, `business_description`, `vendor_image`, `min_price`, `max_price`, `business_address`, `imp_details`, `vendor_name`, `vendor_email`, `vendor_pass`, `vendor_status`, `vendor_contact_no`, `access_key`, `category_id`, `level_id`, `start_date`, `end_date`, `entry_date`, `update_date`) VALUES
(16, 0, 'Teeowl', '<p>Teeowl was born out of a simple yet powerful idea: Let’s locally design and manufacture high- quality lifestyle T-Shirts and exclusively offer them online to you at extremely reasonable prices.</p>', '1466671407_logo-sm.png', '100.00', '2000.00', '112, Railway Station Rd, Chhoti Gwaltoli, Indore, Madhya Pradesh 452007, India', '<ul>\r\n<li>Are You A <strong>Doctor</strong>?</li>\r\n<li>Well, then you must have</li>\r\n<li>Available for a <strong>LIMITED TIME! </strong></li>\r\n<li>Not Available in <strong>Retail Store, </strong>Get your’s<strong> TODAY!</strong></li>\r\n<li><strong>100% Cotton,</strong> <strong>Soft,</strong> <strong>Premium</strong> quality material</li>\r\n</ul>', 'rahul joshi', 'rahuljoshi.gogu@gmail.com', '123123', 'Y', '8982611068', 'o97uwf', 3, 0, '2016-06-23', '0000-00-00', '2016-06-23', '0000-00-00'),
(17, 0, 'imenso', '<p>k fjkf jlfkjs fjsakf jkfj klsjf kfk fkljfklfjlkfj</p>', '', '1000.00', '5000.00', '', '<ul>\r\n<li>sfdsafsdfs</li>\r\n<li>fasfd</li>\r\n<li>fas</li>\r\n<li>fsfsafasdf</li>\r\n</ul>', 'jay', 'jparihar@gmail.com', 'chemical69', 'Y', '9977808469', 'o98c4g', 5, 0, '2016-06-23', '0000-00-00', '2016-06-23', '0000-00-00');
-- --------------------------------------------------------
--
-- Table structure for table `we_vendor_category_master`
--
CREATE TABLE IF NOT EXISTS `we_vendor_category_master` (
`id` int(11) NOT NULL,
`category_name` varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_vendor_category_master`
--
INSERT INTO `we_vendor_category_master` (`id`, `category_name`) VALUES
(3, 'Category 1'),
(4, 'Category 2'),
(5, 'Category 3'),
(6, 'Category 4');
-- --------------------------------------------------------
--
-- Table structure for table `we_vendor_cat_subcat_master`
--
CREATE TABLE IF NOT EXISTS `we_vendor_cat_subcat_master` (
`id` bigint(20) NOT NULL,
`category_id` bigint(20) NOT NULL,
`subcat_id` bigint(20) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_vendor_cat_subcat_master`
--
INSERT INTO `we_vendor_cat_subcat_master` (`id`, `category_id`, `subcat_id`) VALUES
(15, 3, 4),
(16, 3, 5),
(17, 3, 8),
(18, 3, 9),
(19, 3, 12),
(20, 4, 4),
(21, 4, 5),
(22, 4, 6),
(23, 4, 7),
(24, 4, 10),
(25, 4, 11),
(32, 5, 5),
(33, 5, 7),
(34, 5, 8),
(35, 5, 9),
(36, 5, 10),
(37, 5, 11),
(38, 6, 5),
(39, 6, 6),
(40, 6, 7),
(41, 6, 9),
(42, 6, 10),
(43, 6, 11),
(44, 6, 13);
-- --------------------------------------------------------
--
-- Table structure for table `we_vendor_photo_gallary`
--
CREATE TABLE IF NOT EXISTS `we_vendor_photo_gallary` (
`id` bigint(20) NOT NULL,
`event_id` bigint(20) NOT NULL,
`vendor_id` bigint(20) NOT NULL,
`image_name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `we_vendor_subcat`
--
CREATE TABLE IF NOT EXISTS `we_vendor_subcat` (
`id` bigint(20) NOT NULL,
`vendor_id` bigint(20) NOT NULL,
`category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `we_vendor_subcategory_master`
--
CREATE TABLE IF NOT EXISTS `we_vendor_subcategory_master` (
`id` bigint(20) NOT NULL,
`category_name` varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `we_vendor_subcategory_master`
--
INSERT INTO `we_vendor_subcategory_master` (`id`, `category_name`) VALUES
(4, 'Sub Category 1'),
(5, 'Sub Category 2'),
(6, 'Sub Category 3'),
(7, 'Sub Category 4'),
(8, 'Sub Category 5'),
(9, 'Sub Category 6'),
(10, 'Sub Category 7'),
(11, 'Sub Category 8'),
(12, 'Sub Category 9'),
(13, 'Sub Category 10');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `we_category`
--
ALTER TABLE `we_category`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_event`
--
ALTER TABLE `we_event`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_event_cat`
--
ALTER TABLE `we_event_cat`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_registration`
--
ALTER TABLE `we_registration`
ADD PRIMARY KEY (`reg_id`);
--
-- Indexes for table `we_review`
--
ALTER TABLE `we_review`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_setting`
--
ALTER TABLE `we_setting`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `we_user`
--
ALTER TABLE `we_user`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `we_users_event`
--
ALTER TABLE `we_users_event`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_users_event_cat`
--
ALTER TABLE `we_users_event_cat`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_users_event_guestlist`
--
ALTER TABLE `we_users_event_guestlist`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_user_event_website`
--
ALTER TABLE `we_user_event_website`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_user_event_website_photos`
--
ALTER TABLE `we_user_event_website_photos`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_user_event_wishes`
--
ALTER TABLE `we_user_event_wishes`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_user_personal`
--
ALTER TABLE `we_user_personal`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `we_user_wedding`
--
ALTER TABLE `we_user_wedding`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `we_vendor`
--
ALTER TABLE `we_vendor`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_vendor_category_master`
--
ALTER TABLE `we_vendor_category_master`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_vendor_cat_subcat_master`
--
ALTER TABLE `we_vendor_cat_subcat_master`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_vendor_photo_gallary`
--
ALTER TABLE `we_vendor_photo_gallary`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_vendor_subcat`
--
ALTER TABLE `we_vendor_subcat`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `we_vendor_subcategory_master`
--
ALTER TABLE `we_vendor_subcategory_master`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `we_category`
--
ALTER TABLE `we_category`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `we_event`
--
ALTER TABLE `we_event`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `we_event_cat`
--
ALTER TABLE `we_event_cat`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=81;
--
-- AUTO_INCREMENT for table `we_registration`
--
ALTER TABLE `we_registration`
MODIFY `reg_id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `we_review`
--
ALTER TABLE `we_review`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `we_setting`
--
ALTER TABLE `we_setting`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `we_user`
--
ALTER TABLE `we_user`
MODIFY `ID` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `we_users_event`
--
ALTER TABLE `we_users_event`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
--
-- AUTO_INCREMENT for table `we_users_event_cat`
--
ALTER TABLE `we_users_event_cat`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=132;
--
-- AUTO_INCREMENT for table `we_users_event_guestlist`
--
ALTER TABLE `we_users_event_guestlist`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `we_user_event_website`
--
ALTER TABLE `we_user_event_website`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT for table `we_user_event_website_photos`
--
ALTER TABLE `we_user_event_website_photos`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=74;
--
-- AUTO_INCREMENT for table `we_user_event_wishes`
--
ALTER TABLE `we_user_event_wishes`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `we_user_personal`
--
ALTER TABLE `we_user_personal`
MODIFY `ID` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `we_user_wedding`
--
ALTER TABLE `we_user_wedding`
MODIFY `ID` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `we_vendor`
--
ALTER TABLE `we_vendor`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `we_vendor_category_master`
--
ALTER TABLE `we_vendor_category_master`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `we_vendor_cat_subcat_master`
--
ALTER TABLE `we_vendor_cat_subcat_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=45;
--
-- AUTO_INCREMENT for table `we_vendor_photo_gallary`
--
ALTER TABLE `we_vendor_photo_gallary`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `we_vendor_subcat`
--
ALTER TABLE `we_vendor_subcat`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `we_vendor_subcategory_master`
--
ALTER TABLE `we_vendor_subcategory_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
/*!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 */;