-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 06, 2019 at 07:35 AM
-- Server version: 10.1.36-MariaDB
-- PHP Version: 5.6.38

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `newmont33`
--

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

--
-- Table structure for table `adminuser`
--

CREATE TABLE `adminuser` (
  `sessionusername` varchar(50) NOT NULL,
  `sessionpassword` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adminuser`
--

INSERT INTO `adminuser` (`sessionusername`, `sessionpassword`) VALUES
('admin', 'admin123');

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

--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `brandno` int(11) NOT NULL,
  `brand` varchar(255) NOT NULL DEFAULT '',
  `pimg` varchar(255) NOT NULL,
  `status` varchar(25) NOT NULL,
  `scrolllogo` varchar(25) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brand`
--

INSERT INTO `brand` (`brandno`, `brand`, `pimg`, `status`, `scrolllogo`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(100, 'ERGOMAT', '100_pic_1554268867.jpg', 'Active', 'Yes', 0, '2019-04-03 09:20:57', 0, '2019-04-03 09:21:07'),
(110, 'SPECTRUM INDUSTRIAL', '110_pic_1554268885.jpg', 'Active', 'Yes', 0, '2019-04-03 09:21:25', 0, '2019-04-03 09:21:25'),
(120, 'KANSAI PAINT', '120_pic_1554268899.jpg', 'Active', 'Yes', 0, '2019-04-03 09:21:39', 0, '2019-04-03 09:21:39');

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

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

CREATE TABLE `category` (
  `categoryno` int(11) NOT NULL,
  `category` varchar(255) NOT NULL DEFAULT '',
  `pimg` varchar(255) NOT NULL,
  `catdesc` text NOT NULL,
  `status` varchar(25) NOT NULL,
  `categorypriority` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `category` (`categoryno`, `category`, `pimg`, `catdesc`, `status`, `categorypriority`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(100, 'Lockout & Tagout', '100_pic_1554269597.jpg', '', 'Active', 0, 0, '2019-04-03 09:25:18', 0, '2019-04-03 09:33:17'),
(110, 'Floor Marking', '110_pic_1554269144.jpg', '', 'Inactive', 0, 0, '2019-04-03 09:25:44', 0, '2019-04-03 09:31:13'),
(120, 'Floor Painting', '120_pic_1554269587.jpg', 'It is essential to have a proper floor surface for the effective movement of forklift, pallets and human pathway. We are official distributor of Kansai Paints- Japan in the UAE, which is one of the best manufacturers of surface paints in the world. Polyurethane Enamel – High Gloss, Semi-Gloss and Matte Finish. Epoxy Topcoat – Semi Gloss and High Gloss etc are some of the main surface finished we do', 'Active', 0, 0, '2019-04-03 09:26:11', 0, '2019-04-03 09:33:07'),
(130, 'Safety Signages', '130_pic_1554269191.jpg', '', 'Inactive', 0, 0, '2019-04-03 09:26:31', 0, '2019-04-03 09:31:16'),
(140, 'Bumpers', '140_pic_1554269226.jpg', '', 'Inactive', 0, 0, '2019-04-03 09:27:06', 0, '2019-04-03 09:31:19'),
(150, 'Shadow Boards', '150_pic_1554269337.jpg', '', 'Inactive', 0, 0, '2019-04-03 09:27:24', 0, '2019-04-03 09:31:22'),
(160, 'Labeling Systems', '160_pic_1554269349.jpg', '', 'Inactive', 0, 0, '2019-04-03 09:27:38', 0, '2019-04-03 09:31:25'),
(170, 'Factory Furniture', '', '', 'Inactive', 0, 0, '2019-04-03 09:29:35', 0, '2019-04-03 09:31:28'),
(180, 'Fire Equipments', '', '', 'Inactive', 0, 0, '2019-04-03 09:29:44', 0, '2019-04-03 09:31:32'),
(190, 'Tagging Systems', '190_pic_1554269411.jpg', '', 'Inactive', 0, 0, '2019-04-03 09:30:11', 0, '2019-04-03 09:31:34'),
(200, 'Others', '', '', 'Inactive', 0, 0, '2019-04-03 09:30:33', 0, '2019-04-03 09:31:37');

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

--
-- Table structure for table `customer`
--

CREATE TABLE `customer` (
  `customerno` int(11) NOT NULL,
  `memberno` int(11) NOT NULL,
  `id` varchar(100) NOT NULL,
  `ordercode` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(250) NOT NULL,
  `country` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `orderno`
--

CREATE TABLE `orderno` (
  `ordercode` int(11) NOT NULL,
  `customerno` int(11) NOT NULL,
  `id` varchar(100) NOT NULL,
  `orderamt` decimal(10,0) NOT NULL,
  `deliverycharges` decimal(10,0) NOT NULL,
  `orderdate` datetime NOT NULL,
  `deliverydate` date NOT NULL,
  `deliverytime` time NOT NULL,
  `orderstatus` varchar(20) NOT NULL,
  `paymentmode` varchar(25) NOT NULL,
  `payment` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `ordersno` int(11) NOT NULL,
  `ordercode` varchar(25) NOT NULL,
  `productno` varchar(20) NOT NULL,
  `productdetailsno` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `sprice` decimal(10,2) NOT NULL,
  `tprice` decimal(10,2) NOT NULL,
  `orderdate` datetime NOT NULL,
  `orderstatus` varchar(20) NOT NULL,
  `deliverydate` date NOT NULL,
  `deliverytime` varchar(25) NOT NULL,
  `paymentmode` varchar(25) NOT NULL,
  `payment` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `product` (
  `productno` int(11) NOT NULL,
  `pname` varchar(255) NOT NULL,
  `pcimg` varchar(255) NOT NULL,
  `brand` int(11) NOT NULL,
  `categoryno` int(11) NOT NULL,
  `subcategoryno` int(11) NOT NULL,
  `subcategory2no` int(11) NOT NULL,
  `subcategory3no` int(11) NOT NULL,
  `subcategory4no` int(11) NOT NULL,
  `subcategory5no` int(11) NOT NULL,
  `subcategory6no` int(11) NOT NULL,
  `status` varchar(20) NOT NULL,
  `productpriority` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `product` (`productno`, `pname`, `pcimg`, `brand`, `categoryno`, `subcategoryno`, `subcategory2no`, `subcategory3no`, `subcategory4no`, `subcategory5no`, `subcategory6no`, `status`, `productpriority`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(10, 'Safety Lockout Padlock', '100_pic_1554525452.jpg', 0, 100, 100, 0, 0, 0, 0, 0, 'Active', 0, 0, '2019-04-06 08:37:32', 0, '2019-04-06 08:37:32'),
(20, 'Di- Electric safety Lockout Padlock', '100_pic_1554526256.jpg', 0, 100, 110, 0, 0, 0, 0, 0, 'Active', 0, 0, '2019-04-06 08:50:56', 0, '2019-04-06 08:50:56'),
(30, 'Wire Padlock', '', 0, 100, 110, 0, 0, 0, 0, 0, 'Active', 0, 0, '2019-04-06 08:53:23', 0, '2019-04-06 08:53:23'),
(40, 'Padlock Caddy', '', 0, 100, 110, 0, 0, 0, 0, 0, 'Active', 0, 0, '2019-04-06 08:59:16', 0, '2019-04-06 08:59:16'),
(50, 'Epoxy Floor Coating NZ Industrial', '', 0, 120, 0, 0, 0, 0, 0, 0, 'Active', 0, 0, '2019-04-06 09:06:29', 0, '2019-04-06 09:06:29'),
(60, 'Car Park Flooring', '', 0, 120, 0, 0, 0, 0, 0, 0, 'Active', 0, 0, '2019-04-06 09:06:56', 0, '2019-04-06 09:06:56');

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

--
-- Table structure for table `productcategory`
--

CREATE TABLE `productcategory` (
  `productcategoryno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `categoryno` int(11) NOT NULL,
  `subcategoryno` int(11) NOT NULL,
  `subcategory2no` int(11) NOT NULL,
  `subcategory3no` int(11) NOT NULL,
  `subcategory4no` int(11) NOT NULL,
  `subcategory5no` int(11) NOT NULL,
  `subcategory6no` int(11) NOT NULL,
  `productpriority` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productcategory`
--

INSERT INTO `productcategory` (`productcategoryno`, `productno`, `categoryno`, `subcategoryno`, `subcategory2no`, `subcategory3no`, `subcategory4no`, `subcategory5no`, `subcategory6no`, `productpriority`) VALUES
(1, 10, 100, 100, 0, 0, 0, 0, 0, 0),
(2, 20, 100, 110, 0, 0, 0, 0, 0, 0),
(3, 30, 100, 110, 0, 0, 0, 0, 0, 0),
(4, 40, 100, 110, 0, 0, 0, 0, 0, 0),
(5, 50, 120, 0, 0, 0, 0, 0, 0, 0),
(6, 60, 120, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `productcolors`
--

CREATE TABLE `productcolors` (
  `productcolorsno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `color` varchar(255) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `productdesc`
--

CREATE TABLE `productdesc` (
  `productdescno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `desc1` text NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productdesc`
--

INSERT INTO `productdesc` (`productdescno`, `productno`, `desc1`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(1, 10, 'The nylon body is ribbed for easy gripping and handling with an individually keyed to differ 6-pin lock which will not release the key until the shackle is closed.', 0, '2019-04-06 08:37:32', 0, '2019-04-06 08:37:32'),
(2, 20, 'The nylon body is ribbed for easy gripping and handling with an individually keyed to differ 6-pin lock which will not release the key until the shackle is closed.', 0, '2019-04-06 08:50:56', 0, '2019-04-06 08:50:56'),
(3, 30, 'A compact padlock with a flexible wire shackle. Ideal for use on smaller MCB lockouts or for when a standard padlock is unsuitable.', 0, '2019-04-06 08:53:23', 0, '2019-04-06 08:53:23'),
(4, 40, 'A simple, useful method to carry multiple padlocks. Hooks over a belt or pocket and comes complete with a retractable strap.', 0, '2019-04-06 08:59:16', 0, '2019-04-06 08:59:16');

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

--
-- Table structure for table `productdetails`
--

CREATE TABLE `productdetails` (
  `productdetailsno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `productname` varchar(255) NOT NULL,
  `productcodesuffix` varchar(25) NOT NULL,
  `productcode` varchar(50) NOT NULL,
  `itemsize` varchar(100) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `packing` varchar(100) NOT NULL,
  `countryoforigin` varchar(100) NOT NULL,
  `stock` int(11) NOT NULL,
  `spcialoffer` varchar(25) NOT NULL,
  `newarrivals` varchar(25) NOT NULL,
  `hotdeals` varchar(25) NOT NULL,
  `featuredproduct` varchar(25) NOT NULL,
  `status` varchar(50) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productdetails`
--

INSERT INTO `productdetails` (`productdetailsno`, `productno`, `productname`, `productcodesuffix`, `productcode`, `itemsize`, `weight`, `packing`, `countryoforigin`, `stock`, `spcialoffer`, `newarrivals`, `hotdeals`, `featuredproduct`, `status`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(10, 10, 'RED', '', 'LOK007-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:23'),
(20, 10, 'YELLOW', '', 'LOK008-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:28'),
(30, 10, 'GREEN', '', 'LOK009-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:33'),
(40, 10, 'BLUE', '', 'LOK010-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:42'),
(50, 10, 'BLACK', '', 'LOK011-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:47'),
(60, 10, 'ORANGE', '', 'LOK012-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:52'),
(80, 20, 'YELLOW', '', 'LOK263-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:05'),
(90, 20, 'GREEN', '', 'LOK264-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:10'),
(100, 20, 'BLUE', '', 'LOK265-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:17'),
(110, 20, 'BLACK', '', 'LOK266-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:23'),
(120, 20, 'ORANGE', '', 'LOK267-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:30'),
(130, 20, 'RED', '', 'LOK268-L', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:34'),
(140, 30, '', '', 'LOK185', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:53:23', 0, '2019-04-06 08:53:23'),
(150, 40, '', '', 'LOK146', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 08:59:16', 0, '2019-04-06 08:59:16'),
(160, 50, '', '', 'NMFP101', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 09:06:29', 0, '2019-04-06 09:06:29'),
(180, 60, '', '', 'NMFP102', '', '', '', '', 0, 'No', 'No', 'No', 'No', 'Active', 0, '2019-04-06 09:06:56', 0, '2019-04-06 09:06:56');

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

--
-- Table structure for table `productfeatures`
--

CREATE TABLE `productfeatures` (
  `productfeaturesno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `pfeaturepoint` text,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productfeatures`
--

INSERT INTO `productfeatures` (`productfeaturesno`, `productno`, `pfeaturepoint`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(1, 10, '6-pin cylinder for extra security', 0, '2019-04-06 08:37:32', 0, '2019-04-06 08:37:32'),
(2, 10, 'Non-conductive, non-sparking and resistant to chemicals and corrosion', 0, '2019-04-06 08:37:32', 0, '2019-04-06 08:37:32'),
(3, 10, 'Key retaining', 0, '2019-04-06 08:37:32', 0, '2019-04-06 08:37:32'),
(4, 20, '6-pin cylinder for extra security', 0, '2019-04-06 08:50:56', 0, '2019-04-06 08:50:56'),
(5, 20, 'Non-conductive, non-sparking and resistant to chemicals and corrosion', 0, '2019-04-06 08:50:56', 0, '2019-04-06 08:50:56'),
(6, 20, 'Key retaining', 0, '2019-04-06 08:50:56', 0, '2019-04-06 08:50:56'),
(7, 30, '6-pin cylinder for extra security', 0, '2019-04-06 08:53:23', 0, '2019-04-06 08:53:23'),
(8, 30, 'Non-conductive, non-sparking and resistant to chemicals and corrosion', 0, '2019-04-06 08:53:23', 0, '2019-04-06 08:53:23'),
(9, 30, 'Key retaining', 0, '2019-04-06 08:53:23', 0, '2019-04-06 08:53:23');

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

--
-- Table structure for table `productfeatureshead`
--

CREATE TABLE `productfeatureshead` (
  `productfeaturesheadno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `pfeaturehead` varchar(255) NOT NULL,
  `pfeaturedesc` text,
  `addedby` int(11) NOT NULL,
  `addeddate` date NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productfeatureshead`
--

INSERT INTO `productfeatureshead` (`productfeaturesheadno`, `productno`, `pfeaturehead`, `pfeaturedesc`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(1, 10, 'Shackle Height (A)', '40mm', 0, '2019-04-06', 0, '2019-04-06'),
(2, 10, 'Body Height (B) ', '45mm', 0, '2019-04-06', 0, '2019-04-06'),
(3, 10, 'Body Width (C)', '42mm', 0, '2019-04-06', 0, '2019-04-06'),
(4, 10, 'Shackle Diameter (D) ', '6mm', 0, '2019-04-06', 0, '2019-04-06'),
(5, 10, 'Body Depth (E)', '20mm', 0, '2019-04-06', 0, '2019-04-06'),
(6, 20, 'Shackle Height (A)', '40mm', 0, '2019-04-06', 0, '2019-04-06'),
(7, 20, 'Body Height (B)', '45mm', 0, '2019-04-06', 0, '2019-04-06'),
(8, 20, 'Body Width (C)', '42mm', 0, '2019-04-06', 0, '2019-04-06'),
(9, 20, 'Shackle Diameter (D)', '6mm', 0, '2019-04-06', 0, '2019-04-06'),
(10, 20, 'Body Depth (E)', '20mm', 0, '2019-04-06', 0, '2019-04-06'),
(11, 30, 'Shackle Height (A) ', '71mm', 0, '2019-04-06', 0, '2019-04-06'),
(12, 30, 'Body Height (B)', '45mm', 0, '2019-04-06', 0, '2019-04-06'),
(13, 30, 'Body Width (C) ', '42mm', 0, '2019-04-06', 0, '2019-04-06'),
(14, 30, 'Shackle Diameter (D)', '3mm', 0, '2019-04-06', 0, '2019-04-06'),
(15, 30, 'Body Depth (E) ', '20mm', 0, '2019-04-06', 0, '2019-04-06'),
(16, 40, 'Max: Padlock capacity', '12 padlocks', 0, '2019-04-06', 0, '2019-04-06');

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

--
-- Table structure for table `productimages`
--

CREATE TABLE `productimages` (
  `productimagesno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `productdetailsno` int(11) NOT NULL,
  `pimg` varchar(255) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productimages`
--

INSERT INTO `productimages` (`productimagesno`, `productno`, `productdetailsno`, `pimg`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(1, 10, 10, '10_pic_1554525452_1.jpg', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:23'),
(2, 10, 20, '10_pic_1554525452_2.jpg', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:28'),
(3, 10, 30, '10_pic_1554525452_3.jpg', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:33'),
(4, 10, 40, '10_pic_1554525452_4.jpg', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:42'),
(5, 10, 50, '10_pic_1554525452_5.jpg', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:47'),
(6, 10, 60, '10_pic_1554525452_6.jpg', 0, '2019-04-06 08:37:32', 0, '2019-04-06 09:27:52'),
(7, 20, 80, '20_pic_1554526256_1.jpg', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:05'),
(8, 20, 90, '20_pic_1554526256_2.jpg', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:10'),
(9, 20, 100, '20_pic_1554526256_3.jpg', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:17'),
(10, 20, 110, '20_pic_1554526256_4.jpg', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:23'),
(11, 20, 120, '20_pic_1554526256_5.jpg', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:30'),
(12, 20, 130, '20_pic_1554526256_6.jpg', 0, '2019-04-06 08:50:56', 0, '2019-04-06 09:28:34'),
(13, 30, 140, '30_pic_1554526403_1.jpg', 0, '2019-04-06 08:53:23', 0, '2019-04-06 08:53:23'),
(14, 40, 150, '40_pic_1554526756_1.jpg', 0, '2019-04-06 08:59:16', 0, '2019-04-06 08:59:16'),
(15, 50, 160, '50_pic_1554527189_1.jpg', 0, '2019-04-06 09:06:29', 0, '2019-04-06 09:06:29'),
(16, 60, 180, '60_pic_1554527216_1.jpg', 0, '2019-04-06 09:06:56', 0, '2019-04-06 09:06:56'),
(17, 10, 10, '10_pic_1554527285_1.jpg', 0, '2019-04-06 09:08:05', 0, '2019-04-06 09:08:05'),
(18, 10, 20, '10_pic_1554527291_1.jpg', 0, '2019-04-06 09:08:11', 0, '2019-04-06 09:08:11'),
(19, 10, 30, '10_pic_1554527298_1.jpg', 0, '2019-04-06 09:08:18', 0, '2019-04-06 09:08:18'),
(20, 10, 40, '10_pic_1554527305_1.jpg', 0, '2019-04-06 09:08:25', 0, '2019-04-06 09:08:25'),
(21, 10, 50, '10_pic_1554527315_1.jpg', 0, '2019-04-06 09:08:35', 0, '2019-04-06 09:08:35'),
(22, 10, 60, '10_pic_1554527323_1.jpg', 0, '2019-04-06 09:08:43', 0, '2019-04-06 09:08:43'),
(23, 20, 80, '20_pic_1554527353_1.jpg', 0, '2019-04-06 09:09:13', 0, '2019-04-06 09:09:13'),
(24, 20, 90, '20_pic_1554527368_1.jpg', 0, '2019-04-06 09:09:28', 0, '2019-04-06 09:09:28'),
(25, 20, 100, '20_pic_1554527414_1.jpg', 0, '2019-04-06 09:10:14', 0, '2019-04-06 09:10:14'),
(26, 20, 110, '20_pic_1554527424_1.jpg', 0, '2019-04-06 09:10:24', 0, '2019-04-06 09:10:24'),
(27, 20, 120, '20_pic_1554527434_1.jpg', 0, '2019-04-06 09:10:34', 0, '2019-04-06 09:10:34');

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

--
-- Table structure for table `productkeywords`
--

CREATE TABLE `productkeywords` (
  `productkeywordsno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `keywords` text NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` date NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `productprices`
--

CREATE TABLE `productprices` (
  `productpricesno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `wholesaleprice` decimal(10,2) NOT NULL,
  `distrubutorprice` decimal(10,2) NOT NULL,
  `retailerprice` decimal(10,2) NOT NULL,
  `enduserprice` decimal(10,2) NOT NULL,
  `specialofferprice` decimal(10,2) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productprices`
--

INSERT INTO `productprices` (`productpricesno`, `productno`, `wholesaleprice`, `distrubutorprice`, `retailerprice`, `enduserprice`, `specialofferprice`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(1, 10, '0.00', '0.00', '0.00', '0.00', '0.00', 0, '2019-04-06 08:37:32', 0, '2019-04-06 08:37:32'),
(2, 20, '0.00', '0.00', '0.00', '0.00', '0.00', 0, '2019-04-06 08:50:56', 0, '2019-04-06 08:50:56'),
(3, 30, '0.00', '0.00', '0.00', '0.00', '0.00', 0, '2019-04-06 08:53:23', 0, '2019-04-06 08:53:23'),
(4, 40, '0.00', '0.00', '0.00', '0.00', '0.00', 0, '2019-04-06 08:59:16', 0, '2019-04-06 08:59:16'),
(5, 50, '0.00', '0.00', '0.00', '0.00', '0.00', 0, '2019-04-06 09:06:29', 0, '2019-04-06 09:06:29'),
(6, 60, '0.00', '0.00', '0.00', '0.00', '0.00', 0, '2019-04-06 09:06:56', 0, '2019-04-06 09:06:56');

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

--
-- Table structure for table `productsetting`
--

CREATE TABLE `productsetting` (
  `productsettingno` int(11) NOT NULL,
  `pro_brand` int(11) NOT NULL,
  `pro_productcodesuffix` varchar(20) NOT NULL,
  `pro_productcode` int(11) NOT NULL,
  `pro_productcodename` varchar(255) NOT NULL,
  `pro_productcode_com` int(11) NOT NULL,
  `pro_productcodeauto` int(25) NOT NULL,
  `pro_itemsize` int(11) NOT NULL,
  `pro_itemsize_com` int(11) NOT NULL,
  `pro_weight` int(11) NOT NULL,
  `pro_weight_com` int(11) NOT NULL,
  `pro_packing` int(11) NOT NULL,
  `pro_packing_com` int(11) NOT NULL,
  `pro_countryoforigin` int(11) NOT NULL,
  `pro_countryoforigin_com` int(11) NOT NULL,
  `pro_stock` int(11) NOT NULL,
  `pro_color` int(11) NOT NULL,
  `pro_spcialoffer` int(11) NOT NULL,
  `pro_newarrivals` int(11) NOT NULL,
  `pro_hotdeals` int(11) NOT NULL,
  `pro_featured` int(11) NOT NULL,
  `pro_images` int(11) NOT NULL,
  `pro_imagesmultiple` int(11) NOT NULL,
  `pro_imagesize` varchar(50) NOT NULL,
  `pro_price` int(11) NOT NULL,
  `pro_wholesaler` int(11) NOT NULL,
  `pro_wholesaler_com` int(11) NOT NULL,
  `pro_distrubutor` int(11) NOT NULL,
  `pro_distrubutor_com` int(11) NOT NULL,
  `pro_retailer` int(11) NOT NULL,
  `pro_retailer_com` int(11) NOT NULL,
  `pro_enduser` int(11) NOT NULL,
  `pro_enduser_com` int(11) NOT NULL,
  `pro_specialofferprice` int(11) NOT NULL,
  `pro_featuredesc` int(11) NOT NULL,
  `pro_feature` int(11) NOT NULL,
  `pro_desc` int(11) NOT NULL,
  `pro_warranty` int(11) NOT NULL,
  `pro_shipping` int(11) NOT NULL,
  `pro_shippedfrom` int(11) NOT NULL,
  `pro_leadtime` int(11) NOT NULL,
  `pro_shippingdesc` int(11) NOT NULL,
  `pro_shippingcost` int(11) NOT NULL,
  `pro_keywords` int(11) NOT NULL,
  `pro_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productsetting`
--

INSERT INTO `productsetting` (`productsettingno`, `pro_brand`, `pro_productcodesuffix`, `pro_productcode`, `pro_productcodename`, `pro_productcode_com`, `pro_productcodeauto`, `pro_itemsize`, `pro_itemsize_com`, `pro_weight`, `pro_weight_com`, `pro_packing`, `pro_packing_com`, `pro_countryoforigin`, `pro_countryoforigin_com`, `pro_stock`, `pro_color`, `pro_spcialoffer`, `pro_newarrivals`, `pro_hotdeals`, `pro_featured`, `pro_images`, `pro_imagesmultiple`, `pro_imagesize`, `pro_price`, `pro_wholesaler`, `pro_wholesaler_com`, `pro_distrubutor`, `pro_distrubutor_com`, `pro_retailer`, `pro_retailer_com`, `pro_enduser`, `pro_enduser_com`, `pro_specialofferprice`, `pro_featuredesc`, `pro_feature`, `pro_desc`, `pro_warranty`, `pro_shipping`, `pro_shippedfrom`, `pro_leadtime`, `pro_shippingdesc`, `pro_shippingcost`, `pro_keywords`, `pro_status`) VALUES
(1, 1, '', 1, 'Product Code', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, '(Size: 1000 * 850 Pixels)', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1);

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

--
-- Table structure for table `productshipping`
--

CREATE TABLE `productshipping` (
  `productshippingno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `shippingfrom` varchar(255) NOT NULL,
  `leadtime` varchar(255) NOT NULL,
  `shippingcost` varchar(255) NOT NULL,
  `shippingdesc` text NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `productwarranty`
--

CREATE TABLE `productwarranty` (
  `productwarrantyno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `warranty` text NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` date NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subcategory`
--

CREATE TABLE `subcategory` (
  `subcategoryno` int(11) NOT NULL,
  `categoryno` int(11) NOT NULL,
  `subcategory` varchar(255) NOT NULL DEFAULT '',
  `pimg` varchar(255) NOT NULL,
  `subcatdesc` text NOT NULL,
  `status` varchar(25) NOT NULL,
  `subcategorypriority` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subcategory`
--

INSERT INTO `subcategory` (`subcategoryno`, `categoryno`, `subcategory`, `pimg`, `subcatdesc`, `status`, `subcategorypriority`, `addedby`, `addeddate`, `modifiedby`, `modifieddate`) VALUES
(100, 100, 'Safety Padlocks', '100_pic_1554438332.jpg', '', 'Active', 0, 0, '2019-04-05 08:25:32', 0, '2019-04-05 08:25:32'),
(110, 100, 'Electrical Safety Padlocks', '110_pic_1554438347.jpg', '', 'Active', 0, 0, '2019-04-05 08:25:47', 0, '2019-04-05 08:25:47'),
(120, 100, 'Padlock Stations', '120_pic_1554438357.jpg', '', 'Active', 0, 0, '2019-04-05 08:25:57', 0, '2019-04-05 08:25:57'),
(130, 100, 'Safety Lock Out Hasps', '130_pic_1554438367.jpg', '', 'Active', 0, 0, '2019-04-05 08:26:07', 0, '2019-04-05 08:26:07'),
(140, 100, 'Valve Lock Out', '140_pic_1554438386.jpg', '', 'Active', 0, 0, '2019-04-05 08:26:26', 0, '2019-04-05 08:26:26'),
(150, 100, 'Cable Lock Out', '150_pic_1554438397.jpg', '', 'Active', 0, 0, '2019-04-05 08:26:37', 0, '2019-04-05 08:26:37'),
(160, 100, 'Circuit Breaker Lock Out', '160_pic_1554438423.jpg', '', 'Active', 0, 0, '2019-04-05 08:27:03', 0, '2019-04-05 08:27:03'),
(170, 100, 'Plug Lock Out', '170_pic_1554438434.jpg', '', 'Active', 0, 0, '2019-04-05 08:27:14', 0, '2019-04-05 08:27:14'),
(180, 100, 'Emergency / Push Button Lock Out', '180_pic_1554438447.jpg', '', 'Active', 0, 0, '2019-04-05 08:27:27', 0, '2019-04-05 08:27:27'),
(190, 100, 'Lock Out Kits', '190_pic_1554438458.jpg', '', 'Active', 0, 0, '2019-04-05 08:27:38', 0, '2019-04-05 08:27:38'),
(200, 100, 'Lock Out Station', '200_pic_1554438474.jpg', '', 'Active', 0, 0, '2019-04-05 08:27:54', 0, '2019-04-05 08:27:54'),
(210, 100, 'Others', '210_pic_1554438486.jpg', '', 'Active', 0, 0, '2019-04-05 08:28:06', 0, '2019-04-05 08:28:06'),
(220, 100, 'Tag Out Tags', '220_pic_1554438499.jpg', '', 'Active', 0, 0, '2019-04-05 08:28:19', 0, '2019-04-05 08:28:19');

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

--
-- Table structure for table `subcategory2`
--

CREATE TABLE `subcategory2` (
  `subcategory2no` int(11) NOT NULL,
  `categoryno` int(11) NOT NULL,
  `subcategoryno` int(11) NOT NULL,
  `subcategory2` varchar(255) NOT NULL DEFAULT '',
  `pimg2` varchar(255) NOT NULL,
  `subcat2desc` text NOT NULL,
  `status` varchar(25) NOT NULL,
  `subcategory2priority` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subcategory3`
--

CREATE TABLE `subcategory3` (
  `subcategory3no` int(11) NOT NULL,
  `categoryno` int(11) NOT NULL,
  `subcategoryno` int(11) NOT NULL,
  `subcategory2no` int(11) NOT NULL,
  `subcategory3` varchar(255) NOT NULL DEFAULT '',
  `pimg3` varchar(255) NOT NULL,
  `subcat3desc` text NOT NULL,
  `status` varchar(25) NOT NULL,
  `subcategory3priority` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subcategory4`
--

CREATE TABLE `subcategory4` (
  `subcategory4no` int(11) NOT NULL,
  `categoryno` int(11) NOT NULL,
  `subcategoryno` int(11) NOT NULL,
  `subcategory2no` int(11) NOT NULL,
  `subcategory3no` int(11) NOT NULL,
  `subcategory4` varchar(255) NOT NULL DEFAULT '',
  `pimg4` varchar(255) NOT NULL,
  `subcat4desc` text NOT NULL,
  `status` varchar(25) NOT NULL,
  `subcategory4priority` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subcategory5`
--

CREATE TABLE `subcategory5` (
  `subcategory5no` int(11) NOT NULL,
  `categoryno` int(11) NOT NULL,
  `subcategoryno` int(11) NOT NULL,
  `subcategory2no` int(11) NOT NULL,
  `subcategory3no` int(11) NOT NULL,
  `subcategory4no` int(11) NOT NULL,
  `subcategory5` varchar(255) NOT NULL DEFAULT '',
  `pimg5` varchar(255) NOT NULL,
  `subcat5desc` text NOT NULL,
  `status` varchar(25) NOT NULL,
  `subcategory5priority` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subcategory6`
--

CREATE TABLE `subcategory6` (
  `subcategory6no` int(11) NOT NULL,
  `categoryno` int(11) NOT NULL,
  `subcategoryno` int(11) NOT NULL,
  `subcategory2no` int(11) NOT NULL,
  `subcategory3no` int(11) NOT NULL,
  `subcategory4no` int(11) NOT NULL,
  `subcategory5no` int(11) NOT NULL,
  `subcategory6` varchar(255) NOT NULL DEFAULT '',
  `pimg6` varchar(255) NOT NULL,
  `subcat6desc` text NOT NULL,
  `status` varchar(25) NOT NULL,
  `subcategory6priority` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL,
  `modifiedby` int(11) NOT NULL,
  `modifieddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `temporders`
--

CREATE TABLE `temporders` (
  `tempordersno` int(11) NOT NULL,
  `productno` int(11) NOT NULL,
  `productdetailsno` int(11) NOT NULL,
  `id` varchar(255) NOT NULL,
  `qty` int(11) NOT NULL,
  `sprice` decimal(10,2) NOT NULL,
  `tprice` decimal(10,2) NOT NULL,
  `orderdate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `brand`
--
ALTER TABLE `brand`
  ADD PRIMARY KEY (`brandno`);

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

--
-- Indexes for table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`customerno`);

--
-- Indexes for table `orderno`
--
ALTER TABLE `orderno`
  ADD PRIMARY KEY (`ordercode`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`ordersno`);

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

--
-- Indexes for table `productcategory`
--
ALTER TABLE `productcategory`
  ADD PRIMARY KEY (`productcategoryno`);

--
-- Indexes for table `productcolors`
--
ALTER TABLE `productcolors`
  ADD PRIMARY KEY (`productcolorsno`);

--
-- Indexes for table `productdesc`
--
ALTER TABLE `productdesc`
  ADD PRIMARY KEY (`productdescno`);

--
-- Indexes for table `productdetails`
--
ALTER TABLE `productdetails`
  ADD PRIMARY KEY (`productdetailsno`);

--
-- Indexes for table `productfeatures`
--
ALTER TABLE `productfeatures`
  ADD PRIMARY KEY (`productfeaturesno`);

--
-- Indexes for table `productfeatureshead`
--
ALTER TABLE `productfeatureshead`
  ADD PRIMARY KEY (`productfeaturesheadno`);

--
-- Indexes for table `productimages`
--
ALTER TABLE `productimages`
  ADD PRIMARY KEY (`productimagesno`);

--
-- Indexes for table `productkeywords`
--
ALTER TABLE `productkeywords`
  ADD PRIMARY KEY (`productkeywordsno`);

--
-- Indexes for table `productprices`
--
ALTER TABLE `productprices`
  ADD PRIMARY KEY (`productpricesno`);

--
-- Indexes for table `productsetting`
--
ALTER TABLE `productsetting`
  ADD PRIMARY KEY (`productsettingno`);

--
-- Indexes for table `productshipping`
--
ALTER TABLE `productshipping`
  ADD PRIMARY KEY (`productshippingno`);

--
-- Indexes for table `productwarranty`
--
ALTER TABLE `productwarranty`
  ADD PRIMARY KEY (`productwarrantyno`);

--
-- Indexes for table `subcategory`
--
ALTER TABLE `subcategory`
  ADD PRIMARY KEY (`subcategoryno`);

--
-- Indexes for table `subcategory2`
--
ALTER TABLE `subcategory2`
  ADD PRIMARY KEY (`subcategory2no`);

--
-- Indexes for table `subcategory3`
--
ALTER TABLE `subcategory3`
  ADD PRIMARY KEY (`subcategory3no`);

--
-- Indexes for table `subcategory4`
--
ALTER TABLE `subcategory4`
  ADD PRIMARY KEY (`subcategory4no`);

--
-- Indexes for table `subcategory5`
--
ALTER TABLE `subcategory5`
  ADD PRIMARY KEY (`subcategory5no`);

--
-- Indexes for table `subcategory6`
--
ALTER TABLE `subcategory6`
  ADD PRIMARY KEY (`subcategory6no`);

--
-- Indexes for table `temporders`
--
ALTER TABLE `temporders`
  ADD PRIMARY KEY (`tempordersno`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `customerno` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orderno`
--
ALTER TABLE `orderno`
  MODIFY `ordercode` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `ordersno` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `productcolors`
--
ALTER TABLE `productcolors`
  MODIFY `productcolorsno` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `productdetails`
--
ALTER TABLE `productdetails`
  MODIFY `productdetailsno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

--
-- AUTO_INCREMENT for table `productfeatures`
--
ALTER TABLE `productfeatures`
  MODIFY `productfeaturesno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `productfeatureshead`
--
ALTER TABLE `productfeatureshead`
  MODIFY `productfeaturesheadno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `productimages`
--
ALTER TABLE `productimages`
  MODIFY `productimagesno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `productkeywords`
--
ALTER TABLE `productkeywords`
  MODIFY `productkeywordsno` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `productsetting`
--
ALTER TABLE `productsetting`
  MODIFY `productsettingno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `productshipping`
--
ALTER TABLE `productshipping`
  MODIFY `productshippingno` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `productwarranty`
--
ALTER TABLE `productwarranty`
  MODIFY `productwarrantyno` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `temporders`
--
ALTER TABLE `temporders`
  MODIFY `tempordersno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;