Server IP : 108.170.25.35 / Your IP : 18.189.182.211 Web Server : Apache/2 System : Linux gains.winzonesoftech.com 4.18.0-513.24.1.el8_9.x86_64 #1 SMP Mon Apr 8 11:23:13 EDT 2024 x86_64 User : softechwinzone ( 1579) PHP Version : 8.1.28 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/softechwinzone/public_html/database/ |
Upload File : |
-- 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 */;