-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 10, 2023 at 02:09 PM
-- Server version: 10.4.25-MariaDB
-- PHP Version: 8.1.10

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: `winzonesoftech`
--

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

--
-- Table structure for table `applier`
--

CREATE TABLE `applier` (
  `id` int(200) NOT NULL,
  `job` varchar(500) NOT NULL,
  `fname` varchar(500) NOT NULL,
  `lname` varchar(500) NOT NULL,
  `dob` varchar(500) NOT NULL,
  `phone` varchar(500) NOT NULL,
  `gender` varchar(500) NOT NULL,
  `message` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `applier`
--

INSERT INTO `applier` (`id`, `job`, `fname`, `lname`, `dob`, `phone`, `gender`, `message`, `image`) VALUES
(17, 'Web Designer', ' gchh', 'vnb', '2023-06-10', 'bjh', 'Male', ' vnc', 'img/mm.jpg');

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

--
-- Table structure for table `career`
--

CREATE TABLE `career` (
  `id` int(11) NOT NULL,
  `jobtitle` varchar(500) NOT NULL,
  `location` varchar(500) NOT NULL,
  `posteddate` varchar(500) NOT NULL,
  `salary` varchar(500) NOT NULL,
  `description` varchar(1500) NOT NULL,
  `visible` varchar(500) NOT NULL,
  `date` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `career`
--

INSERT INTO `career` (`id`, `jobtitle`, `location`, `posteddate`, `salary`, `description`, `visible`, `date`) VALUES
(13, 'Web Designer', 'Karaikudi', '2023-06-01', '25,000', 'Design page layouts and templates. Produce design assets for use in social media and marketing channels.', 'active', '2023-06-05'),
(14, 'Admin', 'Karaikudi', '2023-06-05', '17,000', 'Preparing, organising and storing information in paper and digital form. Dealing with queries on the phone and by email. ', 'active', '2023-06-05'),
(15, 'Web Developer', 'Karaikudi', '2023-06-10', '30,000', 'Get the right Web developer job with company ratings & salaries.', 'active', '2023-06-05');

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

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

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `category` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `category` (`id`, `category`) VALUES
(25, 'CONSTRUCTION'),
(26, 'EVENT MANAGEMENT'),
(27, 'FABRICATION'),
(28, 'PHOTOGRAPHY');

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

--
-- Table structure for table `ecomcategory`
--

CREATE TABLE `ecomcategory` (
  `id` int(11) NOT NULL,
  `category` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ecomcategory`
--

INSERT INTO `ecomcategory` (`id`, `category`) VALUES
(1, 'PRODUCTS'),
(2, 'Hospital'),
(3, 'AUTOMOBILE'),
(4, 'HOME APPLIANCE');

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

--
-- Table structure for table `ecomgallery`
--

CREATE TABLE `ecomgallery` (
  `id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `title` varchar(500) NOT NULL,
  `alt` varchar(500) NOT NULL,
  `link` varchar(500) NOT NULL,
  `cid` int(255) NOT NULL,
  `name` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ecomgallery`
--

INSERT INTO `ecomgallery` (`id`, `image`, `title`, `alt`, `link`, `cid`, `name`) VALUES
(1, 'img/cdn3.mydukaan.webp', 'sriramdigitalstudio', 'ddd', 'http://sriramdigitalstudio.in/', 2, 'dd'),
(2, 'img/hospital-building-for-healthcare-background-illustration-with-ambulance-car-doctor-patient-nurses-and-medical-clinic-exterior-free-vector.webp', 'rdinfra', 'sss', 'http://jmstructures.in/', 1, 'sssssssss'),
(3, 'img/Untitleda.jpg', 'moderntiles', 'ss', 'http://jesusstonework.in/', 3, 'sssssssss'),
(4, 'img/Unrtitled.jpg', 'rdinfra', 'ss', 'http://dineshbatterykkdi.com/', 4, 'sssssssss');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(100) NOT NULL,
  `image` varchar(300) NOT NULL,
  `content` varchar(400) NOT NULL,
  `url` varchar(255) NOT NULL,
  `cid` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `image`, `content`, `url`, `cid`) VALUES
(8, 'img/appl.png', 'application development', '', '2'),
(9, 'img/b2.png', 'application development', '', '2'),
(10, 'img/web.png', 'ERP development', '', '3'),
(11, 'img/domain.png', 'domain register', '', '5'),
(12, 'img/host.png', 'domain register', '', '5'),
(13, 'img/f4.jpg', 'Formal  shirts', '', '7'),
(14, 'img/f6.jpg', 'Formal  shirts', '', '7'),
(15, 'img/f9.png', 'Formal  shirts', '', '7'),
(16, 'img/cs1.jpg', 'Plain shirts', '', '8'),
(17, 'img/cs2.jpg', 'Plain shirts', '', '8'),
(18, 'img/cs7.png', 'Plain shirts', '', '8'),
(19, 'img/p2.jpg', 'Checked shirts', '', '9'),
(20, 'img/p3.jpg', 'Checked shirts', '', '9'),
(21, 'img/p7.jpg', 'Checked shirts', '', '9'),
(22, 'img/j1.jpg', 'Jeans', '', '10'),
(23, 'img/j3.jpg', 'Jeans', '', '10'),
(24, 'img/sd5.jpg', 'Jeans', '', '10'),
(25, 'img/sd6.jpg', 'Jeans', '', '10'),
(32, 'img/2.png', 'Chruch', 'https://www.winzonesoftech.com', '14'),
(33, 'img/banners.png', 'Digital printing', 'http://www.winzonesoftech.com', '12'),
(34, 'img/slide.png', 'Digital printing', 'http://www.winzonesoftech.com', '12'),
(35, 'img/erp.png', 'ERP ', 'http://www.winzonesoftech.com', '13'),
(36, 'img/banner1.png', 'hotel', 'http://www.winzonesoftech.com', '11');

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

--
-- Table structure for table `gallerycat`
--

CREATE TABLE `gallerycat` (
  `id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `title` varchar(500) NOT NULL,
  `link` varchar(500) NOT NULL,
  `alt` varchar(500) NOT NULL,
  `cid` int(255) NOT NULL,
  `name` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `gallerycat`
--

INSERT INTO `gallerycat` (`id`, `image`, `title`, `link`, `alt`, `cid`, `name`) VALUES
(7, 'img/completed (1).jpeg', 'rdinfra', 'http://www.rdinfra.co.in/', 'best construction in karaikudi', 25, 'RD infra customer Location'),
(11, 'img/Untitled.jpg', 'SIRUMALAR', 'http://sirumalarevents.com/', 'best event in karaikudi', 26, 'school event'),
(12, 'img/ssUntitled.jpg', 'jesusstonework', 'https://drmanisdentalclinic.com/', 'ddd', 27, 'ggg'),
(13, 'img/aavin_milk.jpg', 'sriramdigitalstudio', 'http://sriramdigitalstudio.in/', 'Sriram', 28, 'karaikudi photography'),
(14, 'img/about-1.png', 'makizhconstruction', 'sf', 'sf', 25, 'Makizh Construction');

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

--
-- Table structure for table `gallery_category`
--

CREATE TABLE `gallery_category` (
  `id` int(100) NOT NULL,
  `category` varchar(390) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery_category`
--

INSERT INTO `gallery_category` (`id`, `category`) VALUES
(11, 'web designing'),
(12, 'web development'),
(13, 'software development'),
(14, 'digital marketing');

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE `portfolio` (
  `id` int(11) NOT NULL,
  `image` varchar(1500) NOT NULL,
  `title` varchar(900) NOT NULL,
  `link` varchar(900) NOT NULL,
  `yid` varchar(200) NOT NULL,
  `cid` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `portfolio`
--

INSERT INTO `portfolio` (`id`, `image`, `title`, `link`, `yid`, `cid`) VALUES
(2, 'img/moderntiles.jpeg', 'Modern Tiles', 'http://moderntiles.in/', '1', '4'),
(3, 'img/velantiles.jpeg', 'Sri Velan Tiles', 'http://srivelantiles.com/', '1', '4'),
(5, 'img/vip-construction.jpeg', 'VIP Constructions', 'http://www.vipconstruction.in/', '1', '3'),
(6, 'img/Web capture_29-5-2023_132528_keerthidentalclinic.com(1).jpeg', 'Keerthy Dental Clinic', 'http://keerthidentalclinic.com/', '5', '32'),
(9, 'img/sribogar2.jpeg', 'Sri Bogar Varmalaya', 'http://sribogarvarmalaya.com/', '5', '32'),
(10, 'img/daya(1).jpeg', 'Dhaya Clinic', 'http://dhayaclinic.com/', '5', '32'),
(11, 'img/sakthi(1).jpeg', 'Sakthi Medical centre', 'http://www.sakthimedicalcentre.com/', '5', '29'),
(13, 'img/sakthi3 (1).jpeg', 'sakthi medical centre', 'http://www.sakthimedicalcentre.com/', '5', '32'),
(14, 'img/sg(1).jpeg', ' STEEL GIANT ENGINEERING', 'http://steelgiant.in/', '5', '31'),
(15, 'img/Web capture_29-5-2023_14611_indhuvehiclebodyfitting.com(1).jpeg', 'INDHU INDUSTRIES', 'https://indhuvehiclebodyfitting.com/', '5', '31'),
(17, 'img/Web capture_29-5-2023_151055_dhanyadentalclinic.com(1).jpeg', 'Dhanya Dental Clinic', 'http://dhanyadentalclinic.com/', '5', '32'),
(18, 'img/Web capture_29-5-2023_152114_sripoornaengineering.com(1).jpeg', ' SRI POORNA ENGINEERING', 'http://sripoornaengineering.com/', '5', '31'),
(20, 'img/Web capture_29-5-2023_152352_vishwacarvings.com(1).jpeg', 'vishwa wood carving', 'http://vishwacarvings.com/', '5', '33'),
(21, 'img/Web capture_29-5-2023_153029_pavithradecoration.com(1).jpeg', ' Pavithra Marriage Decoration', 'http://pavithradecoration.com/', '5', '30'),
(22, 'img/Web capture_1-6-2023_164937_sirumalarevents.com(1).jpeg', 'sirumalar events', 'http://sirumalarevents.com/', '5', '30'),
(23, 'img/Web capture_1-6-2023_174328_jsinteriorsdesign.com (1).jpeg', 'js interiors design', 'http://jsinteriorsdesign.com/', '5', '33'),
(25, 'img/Web capture_1-6-2023_174732_jesusstonework.in (1).jpeg', 'jesus stone work', 'http://jesusstonework.in/', '5', '33'),
(27, 'img/Web capture_1-6-2023_181945_jollystudio.in (1).jpeg', 'jollystudio', 'http://jollystudio.in/', '5', '34'),
(28, 'img/Web capture_1-6-2023_184640_sriramdigitalstudio.in (1).jpeg', 'sri ram digital studio', 'http://sriramdigitalstudio.in/', '5', '34'),
(30, 'img/Web capture_1-6-2023_191216_arrahmanconstruction.in (1).jpeg', 'arrahman construction', 'http://arrahmanconstruction.in/', '5', '63'),
(31, 'img/Web capture_1-6-2023_192417_www.rdinfra.co.in (1).jpeg', 'rd infra', 'http://www.rdinfra.co.in/', '5', '63'),
(33, 'img/Web capture_1-6-2023_213020_studio7eleven.com (1).jpeg', 'studio7 eleven', 'http://studio7eleven.com/', '5', '44'),
(34, 'img/Web capture_1-6-2023_21356_abibridalstudio.com (1).jpeg', 'abi bridal studio', 'http://abibridalstudio.com/', '5', '44'),
(35, 'img/Web capture_1-6-2023_213850_akhilamtravels.com (1).jpeg', 'akhilam travels', 'https://akhilamtravels.com/', '5', '36'),
(36, 'img/Web capture_2-6-2023_95249_yasincoirmat.in (1).jpeg', 'yasin coir mat', 'http://yasincoirmat.in/', '5', '35'),
(37, 'img/Web capture_2-6-2023_95626_sbagsandgifts.com (1).jpeg', 's bags and gifts', 'http://sbagsandgifts.com/', '5', '35'),
(38, 'img/Web capture_2-6-2023_95840_kabuilderanddesign.com (1).jpeg', 'ka builder and design', 'http://kabuilderanddesign.com/', '5', '63'),
(39, 'img/Web capture_2-6-2023_10048_shadowassociates.in (1).jpeg', 'shadow associates', 'http://shadowassociates.in/', '5', '63'),
(41, 'img/Web capture_2-6-2023_10259_jmstructures.in (1).jpeg', 'jm structures', 'http://jmstructures.in/', '5', '63'),
(42, 'img/Web capture_2-6-2023_10633_www.sssconstructionkkdi.com (1).jpeg', 'sss constructionkkdi', 'http://www.sssconstructionkkdi.com/', '5', '63'),
(43, 'img/Web capture_2-6-2023_10934_makizhconstruction.com.jpeg', 'makizh construction', 'http://makizhconstruction.com/', '5', '63'),
(44, 'img/Web capture_2-6-2023_101311_jeyyampromotors.com.jpeg', 'jeyyam promotors', 'http://jeyyampromotors.com/', '5', '63'),
(45, 'img/Web capture_2-6-2023_101456_www.ceeyemconstructions.com (1).jpeg', 'ceeyem constructions', 'http://www.ceeyemconstructions.com/', '5', '63'),
(46, 'img/Web capture_2-6-2023_10214_www.thilsathtourstravels.com.jpeg', 'thilsath tours and travels', 'http://www.thilsathtourstravels.com/', '5', '36'),
(47, 'img/Web capture_2-6-2023_102243_www.veerasystems.in.jpeg', 'veera systems', 'http://www.veerasystems.in/', '5', '37'),
(48, 'img/Web capture_2-6-2023_102449_rppowersystems.com (1).jpeg', 'rp power systems', 'http://rppowersystems.com/', '5', '37'),
(49, 'img/Web capture_2-6-2023_102626_dineshbatterykkdi.com.jpeg', 'dinesh battery', 'http://dineshbatterykkdi.com/', '5', '30'),
(50, 'img/Web capture_2-6-2023_102839_www.sunflowertiles.com (1).jpeg', 'sun flower tiles', 'http://www.sunflowertiles.com/', '5', '40'),
(51, 'img/Web capture_2-6-2023_103330_sriganapathyathanguditiles.com (1).jpeg', 'sri ganapathy athangudi tiles', 'http://sriganapathyathanguditiles.com/', '5', '40'),
(52, 'img/Web capture_2-6-2023_103532_www.moderntiles.in (1).jpeg', 'modern tiles', 'http://www.moderntiles.in/', '5', '40'),
(53, 'img/Web capture_2-6-2023_10386_www.kavifloortiles.com.jpeg', 'kavi floor tiles', 'http://www.kavifloortiles.com/', '5', '40'),
(54, 'img/Web capture_2-6-2023_104025_www.malarathanguditiles.com (1).jpeg', 'malar athangudi tiles', 'http://www.malarathanguditiles.com/', '5', '40');

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

--
-- Table structure for table `portfoliocategory`
--

CREATE TABLE `portfoliocategory` (
  `id` int(11) NOT NULL,
  `category` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL,
  `yid` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `portfoliocategory`
--

INSERT INTO `portfoliocategory` (`id`, `category`, `image`, `yid`) VALUES
(3, 'Construction', 'img/construction.jpg', '1'),
(4, 'Tiles Shop', 'img/tiles.jpg', '1'),
(5, 'Construction', 'img/construction.jpg', '3'),
(6, 'Construction', 'img/construction.jpg', '4'),
(30, 'EVENT MANAGEMENT', 'img/event.jpg', '5'),
(31, 'FABRICATION', 'img/fabrication.jpg', '5'),
(32, 'Hospital', 'img/hospital.jpg', '5'),
(33, 'INTERIOR', 'img/interior.jpg', '5'),
(34, 'PHOTOGRAPHY', 'img/photography.jpg', '5'),
(35, 'PRODUCTS', 'img/products.jpg', '5'),
(36, 'TRAVELS', 'img/travels.jpg', '5'),
(37, 'BATTERIES', 'img/batteries.jpg', '5'),
(40, 'Tiles shop', 'img/tiles.jpg', '5'),
(41, 'ANTIQUE', 'img/antique(1).jpg', '5'),
(43, 'AUTOMOBILE', 'img/automobile1(1).jpg', '5'),
(44, 'BEAUTY PARLOUR', 'img/beauty.jpg', '5'),
(45, 'TAX CONSULTATION', 'img/tax.jpg', '5'),
(46, 'SPORTS', 'img/sport.jpg', '5'),
(47, 'HOME APPLIANCE', 'img/home.jpg', '5'),
(48, 'DOCUMENT REGISTER', 'img/document.jpg', '5'),
(49, 'CHETTINAD ITEMS', 'img/chettinad.jpg', '5'),
(50, 'LABOROTIES', 'img/lab.jpg', '5'),
(51, 'BAKKERIES', 'img/bakery.jpg', '5'),
(52, 'HOTEL', 'img/hotel.jpg', '5'),
(53, 'BROADBAND', 'img/broad(1).jpg', '5'),
(54, 'MAHAL', 'img/mahal.jpg', '5'),
(55, 'AMBULANCE', 'img/ambulance.jpg', '5'),
(56, 'ARTS AND CRAFT', 'img/Untitled-1.jpg', '5'),
(57, 'EDUCATION', 'img/Untitled-2.jpg', '5'),
(58, 'DIGITAL POSTER', 'img/DIGI.jpg', '5'),
(60, 'DEPARTMENT STORE', 'img/dept.png', '5'),
(61, 'GIFT SHOP', 'img/gift.png', '5'),
(62, 'TEXTILES', 'img/red.jpg', '5'),
(63, 'CONSTRUCTION', 'img/construction.jpg', '5');

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

--
-- Table structure for table `portfolioyear`
--

CREATE TABLE `portfolioyear` (
  `id` int(11) NOT NULL,
  `year` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `portfolioyear`
--

INSERT INTO `portfolioyear` (`id`, `year`) VALUES
(1, '2020'),
(3, '2021'),
(4, '2022'),
(5, '2023');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(100) NOT NULL,
  `username` varchar(500) NOT NULL,
  `password` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');

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

--
-- Table structure for table `webcategory`
--

CREATE TABLE `webcategory` (
  `id` int(11) NOT NULL,
  `category` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `webcategory`
--

INSERT INTO `webcategory` (`id`, `category`) VALUES
(2, 'Matrimony'),
(3, 'Products'),
(4, 'Music'),
(5, 'Online store');

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

--
-- Table structure for table `webgallery`
--

CREATE TABLE `webgallery` (
  `id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `title` varchar(500) NOT NULL,
  `link` varchar(500) NOT NULL,
  `alt` varchar(500) NOT NULL,
  `cid` int(255) NOT NULL,
  `name` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `webgallery`
--

INSERT INTO `webgallery` (`id`, `image`, `title`, `link`, `alt`, `cid`, `name`) VALUES
(1, 'img/Unrtitled.jpg', 'skmatrimony', 'http://oomskmatrimony.com/', 'best matrimony in karaikudi', 2, 'Oomskmatrimony'),
(2, 'img/images.jpg', 'Jammu Organic', 'http://jeyyampromotors.com/', 'best organic product in karaikudi', 3, 'organic'),
(3, 'img/good_times_with_bad_music_1050x700.webp', 'moderntiles', 'http://dineshbatterykkdi.com/', 'best matrimony in karaikudi', 4, 'Oomskmatrimony'),
(4, 'img/online.jpg', 'sriramdigitalstudio', 'https://akshayakart.com/', 'best matrimony in karaikudi', 5, 'akshayakart');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `applier`
--
ALTER TABLE `applier`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

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

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

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

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

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

--
-- AUTO_INCREMENT for table `gallery_category`
--
ALTER TABLE `gallery_category`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

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

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

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

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

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

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