1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / app.eltorofashions.com / demo /
Filename : eltorofashions_app-demo_16_12_20.sql
back
-- phpMyAdmin SQL Dump
-- version 4.4.15.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 16, 2020 at 03:43 PM
-- Server version: 5.5.47-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.14

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 utf8mb4 */;

--
-- Database: `eltorofashions_app-demo`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `type` smallint(2) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`, `type`) VALUES
(1, 'admin', 'guest', 1),
(2, 'chellanadmin', 'guest', 2);

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

--
-- Table structure for table `agent_details`
--

CREATE TABLE IF NOT EXISTS `agent_details` (
  `aid` int(11) NOT NULL,
  `agent_code` varchar(100) DEFAULT NULL,
  `agent_name` varchar(100) DEFAULT NULL,
  `region` varchar(100) DEFAULT NULL,
  `phoneno` varchar(100) DEFAULT NULL,
  `address1` varchar(100) DEFAULT NULL,
  `address2` varchar(200) DEFAULT NULL,
  `pincode` int(100) DEFAULT NULL,
  `bankdetails` varchar(100) DEFAULT NULL,
  `aadhar_no` varchar(50) DEFAULT NULL,
  `commission` varchar(100) DEFAULT NULL,
  `type` int(11) DEFAULT NULL COMMENT '1-agent,2-salesman,3-distributor,4-stockist',
  `status` int(11) DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `agent_details`
--

INSERT INTO `agent_details` (`aid`, `agent_code`, `agent_name`, `region`, `phoneno`, `address1`, `address2`, `pincode`, `bankdetails`, `aadhar_no`, `commission`, `type`, `status`) VALUES
(1, 'AG 001', 'NAGARAJAN S', 'CHENNAI', '9380928205', 'NEW NO / OLD NO 54/19 JAI PALACE', 'K R KOIL STREET, WET MAMBALAM, CHENNAI', 600033, 'ICICI BANK - 027801509469 KILPAUK BRANCH IFC icic00002785', NULL, '20', NULL, 1),
(2, 'AG 005', 'VANARAJAN A', 'MADURAI', '9994868588', 'H 83, KOODAL PUDHUR', 'MADURAI', 625017, '', NULL, '', NULL, 1),
(3, 'kamal', 'kamal', 'chennai', '', '', '', 0, '', NULL, '10', NULL, 0),
(4, 'Ag 015', 'JOSEPH', 'THIRUNELVELI', '7448761764', '9-168, NORTH THUMVU STREET', 'VADAKKANKULAM,TIRUNELVELI', 627116, '', NULL, '0', NULL, 0),
(5, '006', 'S.RAVIKUMAR', 'TIRUNELVELI', '9865346599,7010084499', '36,THIRUMALNAGAR,', 'N.G.O.COLONY', 627007, '', NULL, '', NULL, 0),
(6, 'AG 006', 'S.RAVIKUMAR', 'TIRUNELVELI', '9865346599,7010084499', '36,HIRUMALNAGART', 'N.G.O.COLONY', 627007, '', NULL, '', NULL, 1),
(7, 'AG 007', 'R.SIVASUBRAMANIAN', 'TUTICORIN', '6384312023,7871931701', '198/5 SHANMUGASIGAMANI NAGAR,NEAR NADAR HR SEC SCHOOL', 'PASUVANDHINI ROAD,KOVILPATTI.', 0, '', NULL, '', NULL, 1),
(8, 'AG 008', 'R.ARUL', 'TIRUVANNAMALAI', '7639269798', 'SELAM MAIN ROAD,THANIPADI PO.', 'THANDARAMPET TK', 606706, '', NULL, '', NULL, 1),
(9, 'AG 009', 'J.RAJA', 'CUDDALORE', '9786494660', '# 1,GANESH NAGAR', 'PARTHIRI KUPPAM', 607401, '', NULL, '', NULL, 1),
(10, 'Ag 010', 'S.J.S.KENNEDY', 'KARUR', '9367660023', '55,LIC COLONY,ARUNACHALANAGAR,', 'PASUPATHIPALAYAM PO', 639004, '', NULL, '', NULL, 1),
(11, 'AG 011', 'J.RAJAVEL', 'KARUR', '7598023839,9443722230', '3,M.G.R.NAGAR,GANDHIGRAMAM SOUTH.', 'THNTHONI,PASUPATHIPALAYAM', 639004, '', NULL, '', NULL, 1),
(12, 'Ag 12', 'D.SARAVANAN', 'CHENNAI', '7397257506', '6,ARUMUGAM STREET,', 'PERAMBUR', 600, '', NULL, '', NULL, 1),
(13, 'Ag 014', 'A.RAJENDRAN', 'TIRUVARUR', '7845587758', 'GURU DHARSHINI,ANGALAMMAN KOVIL STREET,', 'TIRUVARUR', 610, '', NULL, '', NULL, 1),
(14, 'Ag 015', 'J.JOSEPH ROLEX', 'TIRUNELVELI', '7448761764,9894812416', 'ROLAGAM,9-168 NORTH THUMBU OFFICE STREET,', 'VADAKKANKULAM,', 627, '', NULL, '', NULL, 1),
(15, 'Ag 023', 'Ramesh Babu', '5', '7845631965', 'Madurai', '', 610001, 'Sbi', '865299871234', '0', 2, 1);

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

--
-- Table structure for table `cancelinvoice`
--

CREATE TABLE IF NOT EXISTS `cancelinvoice` (
  `cid` int(11) NOT NULL,
  `invoiceid` int(11) DEFAULT NULL,
  `canceldate` date DEFAULT NULL,
  `remark` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `carco_booking_details`
--

CREATE TABLE IF NOT EXISTS `carco_booking_details` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `service` varchar(150) DEFAULT NULL,
  `booking_date` date DEFAULT NULL,
  `booked_by` varchar(150) DEFAULT NULL,
  `lr_no` varchar(100) DEFAULT NULL,
  `lr_date` date DEFAULT NULL,
  `lr_image` varchar(100) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `carco_booking_details`
--

INSERT INTO `carco_booking_details` (`id`, `invoice_id`, `service`, `booking_date`, `booked_by`, `lr_no`, `lr_date`, `lr_image`) VALUES
(1, 30, 'test service', '2020-03-05', 'test', '123456789', '2020-03-10', '3692293711583232844.JPG'),
(2, 31, 'Akr', '2020-12-07', 'Ravi', '21432', '2020-12-07', '10024230651607241646.jpg'),
(3, 32, 'Kalyan Sundaram', '2020-12-06', 'Ravi', '44454 kr', '2020-12-06', '3897567171607275729.jpg');

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

--
-- Table structure for table `carco_delivery_status`
--

CREATE TABLE IF NOT EXISTS `carco_delivery_status` (
  `id` int(11) NOT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `received_by` varchar(150) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `carco_delivery_status`
--

INSERT INTO `carco_delivery_status` (`id`, `invoice_id`, `delivery_date`, `received_by`) VALUES
(1, 30, '2020-03-30', 'test received'),
(2, 31, '2020-12-07', 'Krishna');

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

--
-- Table structure for table `colour`
--

CREATE TABLE IF NOT EXISTS `colour` (
  `cid` int(11) NOT NULL,
  `colourtext` varchar(100) DEFAULT NULL,
  `colourcode` varchar(100) DEFAULT NULL,
  `createdtime` datetime DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `colour`
--

INSERT INTO `colour` (`cid`, `colourtext`, `colourcode`, `createdtime`, `del`) VALUES
(1, 'White', '01', '2019-07-16 15:54:56', 0),
(2, 'White', '01', '2019-09-08 17:48:32', 1),
(3, 'Black', '02', '2019-09-19 14:01:25', 1),
(4, 'Baby Pink', '04', '2019-09-19 14:02:18', 1),
(5, 'Red', '03', '2019-09-19 14:02:45', 1),
(6, 'Navy', '05', '2019-09-19 14:03:06', 1),
(7, 'Burgandy', '06', '2019-09-19 14:03:24', 1),
(8, 'Grey Melange', '07', '2019-09-19 14:03:58', 1),
(9, 'LT. Blue', '08', '2019-10-18 15:47:27', 1),
(10, 'Khaki Melange', '13', '2019-10-18 16:01:49', 1),
(11, 'Royal blue', '18', '2019-10-18 16:04:44', 1),
(12, 'Yellow', '09', '2019-10-30 12:10:07', 1),
(13, 'Dusty Orchid', '10', '2019-10-30 12:11:26', 1),
(14, 'Ceramic', '11', '2019-10-30 12:11:48', 1),
(15, 'Navy Melange', '12', '2019-10-30 12:12:10', 1),
(16, 'LT. Brown Melange', '14', '2019-10-30 12:12:57', 1),
(17, 'Turquoise', '15', '2019-10-30 12:13:32', 1),
(18, 'Olive', '16', '2019-10-30 12:13:50', 1),
(19, 'LT. Brown', '17', '2019-10-30 12:14:20', 1),
(20, 'Blue', '18', '2019-10-30 12:14:42', 1),
(21, 'Cream', '19', '2019-10-30 12:14:56', 1),
(22, 'Navy', '098', '2020-12-03 19:27:56', 1);

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

--
-- Table structure for table `delivery_in`
--

CREATE TABLE IF NOT EXISTS `delivery_in` (
  `cid` int(11) NOT NULL,
  `chellan_no` varchar(100) DEFAULT NULL,
  `from` varchar(200) DEFAULT NULL,
  `chellan_date` date DEFAULT NULL,
  `entry_date` date DEFAULT NULL,
  `employee` varchar(100) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `createdTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `delivery_in`
--

INSERT INTO `delivery_in` (`cid`, `chellan_no`, `from`, `chellan_date`, `entry_date`, `employee`, `status`, `createdTime`) VALUES
(1, NULL, 'Saratoga Tex', '2019-07-16', NULL, NULL, 1, '2019-07-16 10:28:50'),
(2, NULL, 'outparty1', '2019-07-17', NULL, NULL, 1, '2019-07-17 06:13:03'),
(3, NULL, 'Saratoga Tex Gurumurthy', '2019-09-05', NULL, NULL, 1, '2019-09-08 12:24:36'),
(4, NULL, 'outparty', '2019-09-13', NULL, NULL, 1, '2019-09-13 09:38:56'),
(5, NULL, 'saratoga tex', '2019-09-19', NULL, NULL, 1, '2019-09-19 08:53:29'),
(6, NULL, 'saratoga tex', '2019-10-18', NULL, NULL, 1, '2019-10-18 10:49:37'),
(7, NULL, 'saratoga tex', '2019-10-28', NULL, NULL, 1, '2019-10-28 11:12:25'),
(8, NULL, 'saratoga tex', '2019-10-28', NULL, NULL, 1, '2019-10-28 11:13:42'),
(9, NULL, 'saratoga tex', '2019-10-31', NULL, NULL, 1, '2019-10-31 09:21:21'),
(10, NULL, 'Saratoga', '2019-11-03', NULL, NULL, 1, '2019-11-03 12:48:49'),
(11, NULL, 'saratoga tex', '2019-11-18', NULL, NULL, 1, '2019-11-18 11:12:48'),
(12, NULL, 'saratoga tex', '2019-11-18', NULL, NULL, 1, '2019-11-18 11:14:03'),
(13, NULL, 'Saratoga Tex', '2019-11-19', NULL, NULL, 1, '2019-11-19 06:16:43'),
(14, NULL, 'Saratoga Tex', '2019-11-19', NULL, NULL, 1, '2019-11-19 06:17:59'),
(15, NULL, 'Saratoga Tex', '2019-11-19', NULL, NULL, 1, '2019-11-19 06:19:32'),
(16, NULL, 'saratoga tex', '2019-11-21', NULL, NULL, 1, '2019-11-21 06:38:12'),
(17, NULL, 'saratoga tex', '2019-11-29', NULL, NULL, 1, '2019-11-29 07:48:54'),
(18, NULL, 'saratoga tex', '2019-12-04', NULL, NULL, 1, '2019-12-04 06:38:29'),
(19, '001', 'Saratoga Tex', '2019-12-04', NULL, NULL, 1, '2019-12-05 10:44:12'),
(20, '002', 'Saratoga Tex', '2019-12-13', NULL, NULL, 1, '2019-12-13 08:31:33'),
(21, '3', 'Saratoga Tex', '2019-12-16', '2019-12-17', 'x', 1, '2019-12-17 09:51:40'),
(22, '003', 'Saratoga Tex', '2019-12-23', '2019-12-24', 'suresh', 1, '2019-12-24 12:53:47'),
(23, '2', 'Saratoga Tex', '2019-12-18', '2019-12-28', 'a', 1, '2019-12-28 12:19:44'),
(24, '003', 'Saratoga Tex', '2020-02-01', '2020-02-01', 'A', 1, '2020-02-01 11:40:00'),
(25, '085', 'Arvind international', '2020-12-05', '2020-12-06', 'Kowsalya', 1, '2020-12-06 07:43:48'),
(26, '015', 'Arvind international', '2020-12-05', '2020-12-06', 'Kowsalya', 1, '2020-12-06 16:53:04');

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

--
-- Table structure for table `delivery_in_products`
--

CREATE TABLE IF NOT EXISTS `delivery_in_products` (
  `cid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `delivery_in_products`
--

INSERT INTO `delivery_in_products` (`cid`, `pid`, `quantity`, `status`) VALUES
(1, 1, 14, 1),
(2, 2, 100, 1),
(3, 3, 10, 1),
(5, 8, 10, 1),
(5, 9, 10, 1),
(5, 10, 10, 1),
(5, 11, 10, 1),
(5, 12, 5, 1),
(4, 5, 12, 1),
(4, 6, 20, 1),
(4, 7, 30, 1),
(6, 22, 5, 1),
(6, 21, 5, 1),
(6, 20, 5, 1),
(6, 19, 5, 1),
(6, 18, 5, 1),
(6, 17, 5, 1),
(6, 16, 5, 1),
(6, 15, 5, 1),
(6, 14, 5, 1),
(6, 13, 5, 1),
(6, 13, 4, 1),
(7, 23, 10, 1),
(8, 23, 5, 1),
(9, 24, 10, 1),
(10, 24, 15, 1),
(12, 168, 10, 1),
(11, 169, 5, 1),
(13, 101, 12, 1),
(14, 101, 12, 1),
(14, 102, 8, 1),
(14, 103, 10, 1),
(15, 103, 10, 1),
(15, 102, 8, 1),
(15, 101, 12, 1),
(16, 287, 7, 1),
(17, 335, 10, 1),
(17, 333, 12, 1),
(17, 334, 8, 1),
(17, 332, 15, 1),
(17, 331, 6, 1),
(18, 277, 12, 1),
(18, 279, 9, 1),
(18, 287, 8, 1),
(18, 274, 11, 1),
(19, 45, 7, 1),
(19, 39, 8, 1),
(19, 41, 6, 1),
(19, 62, 8, 1),
(20, 335, 5, 1),
(20, 334, 5, 1),
(20, 333, 5, 1),
(20, 332, 5, 1),
(20, 331, 5, 1),
(21, 32, 10, 1),
(21, 31, 10, 1),
(22, 44, 15, 1),
(22, 43, 12, 1),
(23, 42, 10, 1),
(23, 40, 20, 1),
(23, 44, 22, 1),
(24, 339, 100, 1),
(24, 338, 100, 1),
(24, 336, 100, 1),
(25, 341, 20, 1),
(26, 341, 18, 1);

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

--
-- Table structure for table `delivery_out`
--

CREATE TABLE IF NOT EXISTS `delivery_out` (
  `cid` int(11) NOT NULL,
  `chellan_no` varchar(200) DEFAULT NULL,
  `oid` int(11) DEFAULT NULL,
  `chellan_date` date DEFAULT NULL,
  `transportation` varchar(200) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `invoice_generator` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-not generated 1-generated',
  `createdTime` datetime DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `delivery_out`
--

INSERT INTO `delivery_out` (`cid`, `chellan_no`, `oid`, `chellan_date`, `transportation`, `status`, `invoice_generator`, `createdTime`) VALUES
(1, NULL, 1, '2019-07-16', NULL, 1, 0, '2019-07-16 16:07:44'),
(2, NULL, 2, '2019-07-17', NULL, 1, 0, '2019-07-17 11:47:27'),
(3, NULL, 3, '2019-08-14', NULL, 1, 0, '2019-08-14 17:55:22'),
(4, NULL, 4, '2019-09-08', 'AKR', 1, 0, '2019-09-08 17:58:31'),
(5, NULL, 6, '2019-09-13', 'test order', 1, 0, '2019-09-13 15:16:31'),
(6, NULL, 7, '2019-09-19', 'AKR', 1, 0, '2019-09-19 16:00:22'),
(7, NULL, 7, '2019-09-19', 'AKR', 1, 0, '2019-09-19 16:09:45'),
(8, NULL, 8, '2019-10-19', 'AKR door delivery', 1, 0, '2019-10-19 15:41:14'),
(9, NULL, 9, '2019-10-31', 'AKR door delivery', 1, 0, '2019-10-31 14:57:49'),
(10, '12', 10, '2019-11-03', 'Akr', 1, 0, '2019-11-03 18:25:26'),
(11, '1', 13, '2019-11-21', 'AKR door delivery', 1, 0, '2019-11-21 12:31:53'),
(12, '001', 16, '2019-12-05', 'AKR door delivery', 1, 0, '2019-12-05 16:41:16'),
(13, '001', 16, '2019-12-05', 'AKR door delivery', 1, 0, '2019-12-05 16:58:18'),
(14, '1014', 16, '2019-12-10', 'AKR door delivery', 1, 0, '2019-12-10 13:16:43'),
(15, '1015', 17, '2019-12-13', 'kalyan door delivery', 1, 0, '2019-12-13 14:45:54'),
(16, '1016', 17, '2019-12-13', 'kalyan door delivery', 1, 0, '2019-12-13 15:18:28'),
(17, '1017', 18, '2019-12-17', 'AKR door delivery', 1, 0, '2019-12-17 15:32:33'),
(18, '1018', 18, '2019-12-17', 'AKR door delivery', 1, 0, '2019-12-17 15:36:48'),
(19, '1019', 19, '2019-12-24', 'AKR door delivery', 1, 1, '2019-12-24 18:50:51'),
(20, '1020', 20, '2019-12-25', 'courier', 1, 1, '2019-12-25 14:01:46'),
(21, '1021', 20, '2019-12-25', 'courier', 1, 0, '2019-12-25 15:25:25'),
(22, '1022', 20, '2019-12-27', 'courier', 1, 1, '2019-12-27 11:35:00'),
(23, '1023', 1, '2019-12-28', '', 1, 1, '2019-12-28 17:10:00'),
(24, '1024', 19, '2019-12-28', 'AKR door delivery', 1, 1, '2019-12-28 17:40:35'),
(25, '1025', 21, '2019-12-28', 'mss', 1, 1, '2019-12-28 17:57:19'),
(26, '1026', 21, '2020-01-03', 'mss', 1, 1, '2020-01-03 13:50:54'),
(27, '1027', 24, '2020-02-01', 'kalyan door delivery', 1, 1, '2020-02-01 17:39:00'),
(28, '1028', 25, '2020-02-19', 'test', 1, 0, '2020-02-19 15:00:14'),
(29, '1029', 27, '2020-03-03', 'Demo trans', 1, 1, '2020-03-03 16:20:46'),
(30, '1030', 30, '2020-12-06', 'Akr', 1, 1, '2020-12-06 13:25:00'),
(31, '1031', 31, '2020-12-06', 'Kalyanasundaram', 1, 1, '2020-12-06 22:49:27'),
(32, '1032', 30, '2020-12-06', 'Akr', 1, 1, '2020-12-06 23:05:04');

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

--
-- Table structure for table `delivery_out_products`
--

CREATE TABLE IF NOT EXISTS `delivery_out_products` (
  `cid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `delivery_out_products`
--

INSERT INTO `delivery_out_products` (`cid`, `pid`, `quantity`, `status`) VALUES
(1, 1, 7, 1),
(2, 2, 10, 1),
(2, 1, 3, 1),
(3, 2, 1, 1),
(3, 1, 2, 1),
(4, 3, 0, 1),
(5, 5, 2, 1),
(5, 6, 2, 1),
(5, 7, 2, 1),
(6, 8, 5, 1),
(6, 9, 5, 1),
(6, 11, 4, 1),
(6, 12, 5, 1),
(6, 10, 2, 1),
(7, 8, 0, 1),
(7, 9, 0, 1),
(7, 11, 0, 1),
(7, 12, 0, 1),
(7, 10, 0, 1),
(8, 13, 4, 1),
(8, 14, 2, 1),
(8, 16, 2, 1),
(8, 16, 2, 1),
(8, 16, 2, 1),
(8, 16, 2, 1),
(8, 16, 2, 1),
(8, 16, 2, 1),
(8, 16, 2, 1),
(8, 16, 2, 1),
(8, 16, 3, 1),
(8, 16, 3, 1),
(8, 16, 3, 1),
(8, 16, 3, 1),
(8, 16, 3, 1),
(8, 16, 3, 1),
(8, 16, 3, 1),
(8, 16, 3, 1),
(9, 24, 4, 1),
(10, 24, 17, 1),
(11, 287, 5, 1),
(12, 62, 7, 1),
(12, 41, 6, 1),
(12, 45, 3, 1),
(13, 62, 0, 1),
(13, 41, 0, 1),
(13, 45, 0, 1),
(14, 62, 0, 1),
(14, 41, 0, 1),
(14, 45, 1, 1),
(15, 331, 12, 1),
(15, 332, 6, 1),
(15, 333, 5, 1),
(15, 334, 5, 1),
(15, 335, 3, 1),
(16, 335, 2, 1),
(16, 334, 0, 1),
(16, 333, 0, 1),
(16, 332, 0, 1),
(17, 32, 5, 1),
(17, 31, 7, 1),
(18, 32, 4, 1),
(18, 31, 2, 1),
(19, 43, 7, 1),
(19, 44, 4, 1),
(20, 43, 3, 1),
(20, 44, 4, 1),
(21, 44, 1, 1),
(21, 43, 0, 1),
(23, 0, 1, 1),
(22, 43, 0, 1),
(22, 44, 0, 1),
(24, 43, 1, 1),
(24, 44, 2, 1),
(25, 39, 5, 1),
(25, 40, 4, 1),
(25, 44, 6, 1),
(27, 336, 10, 1),
(27, 339, 6, 1),
(26, 39, 0, 1),
(26, 40, 4, 1),
(26, 44, 2, 1),
(28, 335, 5, 1),
(28, 334, 5, 1),
(29, 338, 2, 1),
(29, 339, 2, 1),
(30, 341, 7, 1),
(31, 341, 16, 1),
(32, 341, 1, 1);

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

--
-- Table structure for table `invoice`
--

CREATE TABLE IF NOT EXISTS `invoice` (
  `invoice_id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `agent_code` int(11) DEFAULT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `actualdate` date DEFAULT NULL,
  `party` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `balance` decimal(10,2) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `due_days` int(11) DEFAULT NULL,
  `days_credit` varchar(50) DEFAULT NULL,
  `carco_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-invoice,1-booked,2-delivered',
  `status` varchar(100) DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` (`invoice_id`, `cid`, `agent_code`, `invoice`, `actualdate`, `party`, `amount`, `balance`, `due_date`, `due_days`, `days_credit`, `carco_status`, `status`, `del`) VALUES
(1, 1, 1, '001 AP 19', '2019-07-16', 1, 1820.00, 1460.00, '2019-08-15', 30, NULL, 0, 'Partially Paid', 1),
(2, 2, 3, 'invone', '2019-07-17', 3, 1600.00, 1100.00, '2019-07-27', 10, NULL, 0, 'Partially Paid', 1),
(3, 3, 1, '10', '2019-08-14', 1, 510.00, 510.00, '2019-08-24', 10, NULL, 0, 'Not paid', 1),
(4, 4, 2, '001', '2019-09-08', 2, 0.00, 0.00, '2019-10-23', 45, NULL, 0, 'Not paid', 1),
(5, 5, 3, 'inv6', '2019-09-13', 4, 1320.00, 1320.00, '2019-10-03', 20, NULL, 0, 'Not paid', 1),
(6, 8, 1, '222', '2019-10-19', 3, 14620.00, 14620.00, '2019-11-18', 30, NULL, 0, 'Not paid', 1),
(7, 9, 1, '5', '2019-10-31', 2, 0.00, 0.00, '2019-11-30', 30, NULL, 0, 'Not paid', 1),
(8, 10, 2, '4', '2019-11-03', 6, 5100.00, 5100.00, '2019-12-18', 45, NULL, 0, 'Not paid', 1),
(9, 11, 1, '002', '2019-11-21', 8, 1745.00, 1745.00, '2019-11-23', 2, NULL, 0, 'Not paid', 1),
(10, 12, 14, '100', '2019-12-05', 15, 3965.00, 3965.00, '2020-01-04', 30, NULL, 0, 'Not paid', 1),
(11, 12, 14, '101', '2019-12-05', 15, 3965.00, 3965.00, '2019-12-27', 22, NULL, 0, 'Not paid', 1),
(12, 14, 14, '44 MAR 19', '2019-12-10', 15, 260.00, 260.00, '2020-01-24', 45, NULL, 0, 'Not paid', 1),
(13, 15, 14, 'ST001', '2019-12-13', 10, 10600.00, 10600.00, '2019-12-28', 15, NULL, 0, 'Not paid', 1),
(14, 16, 14, 'ST002', '2019-12-13', 10, 720.00, 720.00, '2019-12-28', 15, NULL, 0, 'Not paid', 1),
(15, 17, 8, '12', '2019-12-17', 21, 2112.00, 2112.00, '2020-01-16', 30, NULL, 0, 'Not paid', 1),
(16, 18, 8, '13', '2019-12-17', 21, 1056.00, 1056.00, '2020-01-16', 30, NULL, 0, 'Not paid', 1),
(17, 18, 8, '14', '2019-12-17', 21, 1056.00, 1056.00, '2020-01-31', 45, NULL, 0, 'Not paid', 1),
(18, 17, 8, '15', '2019-12-17', 21, 2112.00, 2112.00, '2020-01-31', 45, NULL, 0, 'Not paid', 1),
(19, 18, 8, '008', '2019-12-18', 21, 1056.00, 1056.00, '2020-02-01', 45, NULL, 0, 'Not paid', 1),
(20, 17, 8, '45', '2019-12-18', 21, 2112.00, 2112.00, '2020-02-01', 45, NULL, 0, 'Not paid', 1),
(21, 18, 8, '50', '2019-12-18', 21, 1056.00, 1056.00, '2020-02-01', 45, NULL, 0, 'Not paid', 1),
(22, 19, 2, '004', '2019-12-24', 17, 3360.00, 3360.00, '2020-01-29', NULL, NULL, 0, 'Not paid', 1),
(23, 20, 14, '004', '2019-12-25', 10, 1620.00, 1620.00, '2020-01-04', NULL, NULL, 0, 'Not paid', 1),
(24, 22, 14, '041', '2019-12-28', 10, 0.00, 0.00, '2020-01-07', NULL, NULL, 0, 'Not paid', 1),
(25, 24, 2, '042', '2019-12-28', 17, 480.00, 480.00, '2020-02-02', NULL, NULL, 0, 'Not paid', 1),
(26, 25, 14, '043', '2019-12-28', 11, 2550.00, 2550.00, '2020-02-06', NULL, NULL, 0, 'Not paid', 1),
(27, 27, 14, '044', '2020-02-01', 10, 4000.00, 4000.00, '2020-03-17', NULL, NULL, 0, 'Not paid', 1),
(28, 26, 14, '045', '2020-02-01', 11, 0.00, 0.00, '2020-03-12', NULL, NULL, 0, 'Not paid', 1),
(29, 23, 1, '046', '2020-02-03', 1, 0.00, 0.00, '2020-02-03', NULL, NULL, 0, 'Not paid', 1),
(30, 29, 11, '047', '2020-03-03', 15, 2000.00, 2000.00, '2020-03-23', NULL, NULL, 2, 'Not paid', 1),
(31, 30, 14, '048', '2020-12-06', 21, 2975.00, 2975.00, '2021-01-05', NULL, NULL, 2, 'Not paid', 1),
(32, 31, 15, '049', '2020-12-06', 10, 7680.00, 7680.00, '2021-01-20', NULL, NULL, 1, 'Not paid', 1),
(33, 32, 14, '050', '2020-12-06', 21, 425.00, 425.00, '2021-01-05', NULL, NULL, 0, 'Not paid', 1);

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

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

CREATE TABLE IF NOT EXISTS `orders` (
  `oid` int(11) NOT NULL,
  `party_id` int(11) DEFAULT NULL,
  `agent_id` int(11) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `due_days` int(11) NOT NULL,
  `due_date` date DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `transportation` varchar(200) DEFAULT NULL,
  `message` text NOT NULL,
  `serial` varchar(150) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `pending_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-total_pending,1- partial_pending 2-completed',
  `createdTime` datetime DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`oid`, `party_id`, `agent_id`, `order_date`, `due_days`, `due_date`, `delivery_date`, `transportation`, `message`, `serial`, `status`, `pending_status`, `createdTime`) VALUES
(1, 1, 1, '2019-07-16', 0, NULL, NULL, NULL, '', '', 1, 0, '2019-07-16 16:06:27'),
(2, 3, 3, '2019-07-01', 0, NULL, NULL, NULL, '', '', 1, 0, '2019-07-17 11:43:46'),
(3, 1, 1, '2019-08-14', 0, NULL, NULL, NULL, '', '', 1, 0, '2019-08-14 17:50:36'),
(4, 2, 2, '2019-09-08', 0, '2019-09-08', '2019-09-08', 'AKR', '', '', 1, 0, '2019-09-08 17:56:41'),
(5, 3, 2, '2019-09-08', 0, '2019-09-08', '2019-09-12', 'Akr', '', '', 1, 0, '2019-09-08 18:13:54'),
(6, 4, 3, '2019-09-13', 0, '2019-09-13', '2019-09-13', 'test order', '', '', 1, 0, '2019-09-13 15:10:30'),
(7, 2, 2, '2019-09-18', 0, '2019-09-30', '2019-09-21', 'AKR', '', '', 1, 0, '2019-09-19 14:50:08'),
(8, 3, 1, '2019-10-18', 30, '2019-11-20', '2019-10-21', 'AKR door delivery', 'door delivery', '401', 1, 0, '2019-10-18 16:28:35'),
(9, 6, 1, '2019-10-31', 30, '2019-12-07', '2019-11-07', 'AKR door delivery', 'urgent order by courier', '1532', 1, 0, '2019-10-31 14:53:47'),
(10, 6, 2, '2019-11-03', 45, '2019-12-23', '2019-11-08', 'Akr', '', '234', 1, 0, '2019-11-03 18:21:28'),
(11, 6, 4, '2019-11-03', 40, '2019-12-23', '2019-11-13', 'Ka!yan', '', '12', 1, 0, '2019-11-03 21:03:44'),
(12, 6, 1, '2019-11-03', 5, '2019-11-30', '2019-11-25', 'Okm', '', '34', 1, 0, '2019-11-03 21:10:39'),
(13, 8, 1, '2019-11-21', 90, '2020-02-19', '2019-11-21', 'AKR door delivery', '', '12', 1, 0, '2019-11-21 12:26:33'),
(14, 16, 1, '2019-11-29', 30, '2020-01-04', '2019-12-05', 'AKR door delivery', 'it i door delivery \ninform wayill # once sent', '486', 1, 0, '2019-11-29 13:36:10'),
(15, 17, 2, '2019-12-04', 45, '2020-01-24', '2019-12-10', 'AKR door delivery', '', '1442', 1, 0, '2019-12-04 12:23:43'),
(16, 15, 14, '2019-12-05', 30, '2020-01-10', '2019-12-11', 'AKR door delivery', '', '112', 1, 0, '2019-12-05 16:22:16'),
(17, 10, 14, '2019-12-13', 15, '2020-01-04', '2019-12-20', 'kalyan door delivery', 'you can make part shipments', '1501', 1, 0, '2019-12-13 14:17:31'),
(18, 21, 8, '2019-12-14', 45, '2020-02-02', '2019-12-19', 'AKR door delivery', 'hip immediately', '1122', 1, 0, '2019-12-17 15:26:55'),
(19, 17, 2, '2019-12-23', 36, '2020-01-29', '2019-12-24', 'AKR door delivery', '', 'zee', 1, 0, '2019-12-24 18:37:07'),
(20, 10, 14, '2019-12-23', 10, '2020-01-05', '2019-12-26', 'courier', '', '1536', 1, 0, '2019-12-25 13:56:10'),
(21, 11, 14, '2019-12-20', 40, '2020-02-05', '2019-12-27', 'mss', 'order delivery is already gone so please dothe needful', '1554', 1, 0, '2019-12-28 17:54:12'),
(22, 8, 1, '2020-01-21', 10, '2020-01-31', '2020-01-21', 'test', '', '1,2,3', 1, 0, '2020-01-21 14:13:18'),
(23, 18, 1, '2020-01-22', 90, '2020-04-26', '2020-01-27', 'mss', '', '111', 1, 0, '2020-01-28 13:17:48'),
(24, 10, 14, '2020-02-01', 45, '2020-03-21', '2020-02-05', 'kalyan door delivery', '', '1122', 1, 0, '2020-02-01 17:02:00'),
(25, 8, 1, '2020-02-19', 10, '2020-02-29', '2020-02-19', 'test', '', '1,2,3', 1, 1, '2020-02-19 14:59:24'),
(26, 8, 1, '2020-02-14', 45, '2020-04-14', '2020-02-29', 'kamaltest', '', '1,2,3', 1, 0, '2020-02-22 11:43:10'),
(27, 15, 11, '2020-03-01', 20, '2020-03-25', '2020-03-05', 'Demo trans', '', '1,2,3', 1, 4, '2020-03-03 15:32:45'),
(28, 21, 7, '2020-03-05', 10, '2020-03-20', '2020-03-10', 'test', '', '1,2,3', 1, 0, '2020-03-03 15:36:34'),
(29, 10, 14, '2020-12-04', 30, '2021-01-04', '2020-12-05', 'By tvs', '', '001', 1, 0, '2020-12-05 22:51:53'),
(30, 21, 14, '2020-12-03', 30, '2021-01-06', '2020-12-07', 'Akr', 'Payment must be in 30 days.', '1066', 1, 2, '2020-12-06 13:17:46'),
(31, 10, 15, '2020-12-06', 45, '2021-01-22', '2020-12-08', 'Kalyanasundaram', 'Delivery it earlier than the date ', '087', 1, 2, '2020-12-06 22:45:35');

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

--
-- Table structure for table `order_products`
--

CREATE TABLE IF NOT EXISTS `order_products` (
  `oid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unitprice` decimal(10,2) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_products`
--

INSERT INTO `order_products` (`oid`, `pid`, `quantity`, `unitprice`, `amount`, `status`) VALUES
(1, 1, 9, 260.00, 2340.00, 1),
(2, 2, 50, 100.00, 5000.00, 1),
(2, 1, 5, 200.00, 1000.00, 1),
(3, 2, 1, 170.00, 170.00, 1),
(3, 1, 2, 170.00, 340.00, 1),
(4, 3, 5, 165.00, 825.00, 1),
(5, 3, 5, 165.00, 825.00, 1),
(5, 2, 10, 240.00, 2400.00, 1),
(6, 5, 5, 110.00, 550.00, 1),
(6, 6, 6, 220.00, 1320.00, 1),
(6, 7, 7, 330.00, 2310.00, 1),
(7, 8, 5, 180.00, 900.00, 1),
(7, 9, 7, 180.00, 1260.00, 1),
(7, 11, 4, 180.00, 720.00, 1),
(7, 12, 5, 180.00, 900.00, 1),
(7, 10, 2, 180.00, 360.00, 1),
(8, 13, 5, 170.00, 850.00, 1),
(8, 14, 2, 170.00, 340.00, 1),
(8, 16, 2, 170.00, 340.00, 1),
(8, 16, 4, 170.00, 680.00, 1),
(10, 24, 16, 300.00, 4800.00, 1),
(11, 24, 4, 3500.00, 14000.00, 1),
(9, 24, 4, 0.00, 0.00, 1),
(12, 24, 4, 333.00, 1332.00, 1),
(13, 287, 6, 349.00, 2094.00, 1),
(14, 335, 6, 340.00, 2040.00, 1),
(14, 334, 6, 340.00, 2040.00, 1),
(14, 333, 6, 340.00, 2040.00, 1),
(14, 332, 10, 340.00, 3400.00, 1),
(14, 331, 4, 340.00, 1360.00, 1),
(15, 287, 5, 190.00, 950.00, 1),
(15, 279, 4, 190.00, 760.00, 1),
(15, 277, 3, 200.00, 600.00, 1),
(16, 62, 5, 245.00, 1225.00, 1),
(16, 41, 6, 245.00, 1470.00, 1),
(16, 45, 4, 260.00, 1040.00, 1),
(17, 335, 5, 360.00, 1800.00, 1),
(17, 334, 5, 340.00, 1700.00, 1),
(17, 333, 5, 340.00, 1700.00, 1),
(17, 332, 5, 340.00, 1700.00, 1),
(17, 331, 11, 340.00, 3740.00, 1),
(18, 32, 9, 176.00, 1584.00, 1),
(18, 31, 9, 176.00, 1584.00, 1),
(19, 44, 6, 250.00, 1500.00, 1),
(19, 43, 8, 240.00, 1920.00, 1),
(20, 44, 5, 340.00, 1700.00, 1),
(20, 43, 3, 270.00, 810.00, 1),
(21, 44, 8, 170.00, 1360.00, 1),
(21, 39, 5, 170.00, 850.00, 1),
(21, 40, 8, 170.00, 1360.00, 1),
(22, 330, 10, 400.00, 4000.00, 1),
(23, 48, 100, 200.00, 20000.00, 1),
(23, 32, 0, 0.00, 0.00, 1),
(24, 339, 10, 200.00, 2000.00, 1),
(24, 338, 10, 200.00, 2000.00, 1),
(24, 336, 10, 200.00, 2000.00, 1),
(25, 335, 10, 110.00, 1100.00, 1),
(25, 334, 10, 110.00, 1100.00, 1),
(26, 339, 10, 110.00, 1100.00, 1),
(26, 338, 10, 110.00, 1100.00, 1),
(26, 336, 10, 110.00, 1100.00, 1),
(27, 339, 10, 500.00, 5000.00, 1),
(27, 338, 10, 500.00, 5000.00, 1),
(28, 335, 2, 500.00, 1000.00, 1),
(28, 334, 2, 500.00, 1000.00, 1),
(28, 333, 2, 0.00, 0.00, 1),
(29, 341, 10, 476.00, 4760.00, 1),
(30, 341, 8, 425.00, 3400.00, 1),
(31, 341, 16, 480.00, 7680.00, 1);

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

--
-- Table structure for table `party`
--

CREATE TABLE IF NOT EXISTS `party` (
  `pid` int(11) NOT NULL,
  `partyname` varchar(100) DEFAULT NULL,
  `mobileno` varchar(100) DEFAULT NULL,
  `gst` varchar(100) DEFAULT NULL,
  `address1` text,
  `address2` text,
  `pan_no` varchar(50) DEFAULT NULL,
  `createdtime` datetime DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `party`
--

INSERT INTO `party` (`pid`, `partyname`, `mobileno`, `gst`, `address1`, `address2`, `pan_no`, `createdtime`, `del`) VALUES
(1, 'sri kumaran stores', '9505050565', NULL, NULL, NULL, NULL, '2019-07-16 15:28:15', 0),
(2, 'sri kumaran stores - pondy', '9994700900', NULL, NULL, NULL, NULL, '2019-07-16 15:31:59', 0),
(3, 'party 1', '7299312254', NULL, NULL, NULL, NULL, '2019-07-17 11:41:51', 0),
(4, 'kamalmaxparty', '9952281972', 'test kamal party gst', 'first address', 'second address', NULL, '2019-09-13 15:03:33', 0),
(5, 'MENLY CLOTHING', '9941649395', '33BVRPR0784B1ZF', '1,KARPAGA VINAYAGAR KOIL STREET', 'KANDHANCHAVADI, CHENNAI - 600098', NULL, '2019-10-28 15:56:15', 0),
(6, 'AL KAIR JAWLI STORES', '9944838694', '33AQUPM0774B1ZU', 'NO 22A QUIDA MILLATH PALLIKOODAM ROAD', 'JINNA THIDAL, MELAPALAYAM, THIRUNELVELI - 627005', NULL, '2019-11-02 11:40:22', 0),
(7, 'AUSTIN TEXTILES', '9443982555', '33AEXPA7904E1ZK', 'URAMBU JN KOLLENCODE(PO)', 'KANYAKUMARI DITRICT 629160', NULL, '2019-11-19 11:44:44', 0),
(8, 'POIGAI', '7338989006', '33CJYPD9027P12E', '4/13 CHURCH ROAD,PALLAVARAM,', 'CHENNAI 600043', NULL, '2019-11-19 15:30:50', 1),
(9, 'STYLE HUB MENS WEAR', '9894222034', '33HKWPS6660F1ZE', 'NO 7,SSR PLAZA,BUS STAND LINK ROAD.THIRUPATHIRIPULIYUR,', 'CUDDALLORE-2', NULL, '2019-11-19 15:36:29', 1),
(10, 'CITY BOYS READYMADES', '900360496', '0', '52/5 SENAITHALAIVAR COMPLEX,THIRUCHENDUR.', 'TUTICORIN DT.', NULL, '2019-11-19 15:40:09', 1),
(11, 'JEANIUS FASHION', '8122443039, 7904420223', '33CNHPM0301C2ZT', 'NO 11,GST ROAD,(OPP LALITHA JEWELLARY,CHROMPET.', 'CHENNAI-600044', NULL, '2019-11-19 15:43:52', 1),
(12, 'SRI HARIHARAN AGENCIES', '6369650262 ', '33GCJPS0408D1ZV', '65/A 1st FLOOR,JANAGARAJ COMPLEX,(CHITARAM THEATRE)', 'M.G.ROAD,VILLUPURAM.', NULL, '2019-11-19 15:52:12', 1),
(13, 'KIDZEE OXFORD BLOOM SCHOOL', '9443508193', '0', 'PASUMPON NAGAR,1st CROSS ,SINGARAVELAN SALAI.', 'PONDICHERRY UNION TERRITORY,KARAIKAL-609602', NULL, '2019-11-19 16:22:07', 1),
(14, 'MENLY CLOTHING', '9941649395,9176884316', '33BVRPRO78481ZF', '# 1,KARPAGA VINAYAGAR KOIL STREET,KANDANCHAVADI', 'CHENNAI-600098', NULL, '2019-11-20 16:47:02', 1),
(15, 'EPHOD', '9789893161', '0', '# 138,CHOOLAIMEDU HIGH ROAD', 'CHOOLAI MEDU,CHENNAI-94', NULL, '2019-11-20 16:49:21', 1),
(16, 'REPLICA', '7401751226', '0', '# 91,RADHANAGAR MAIN ROAD,', 'CHROMPET,CHENNAI-', NULL, '2019-11-20 16:51:36', 1),
(17, 'PARAMOUNT', '9751572353', '33AALPAG40901ZH', '20,WEST TOWER STREET,', 'MADURAI-01', NULL, '2019-11-20 16:54:26', 1),
(18, 'HARSITA FASHIONS', '9994462723', '0', 'TIRUPUR-641606', '0', NULL, '2019-11-20 16:59:27', 1),
(19, 'NEW TRENDS', '8124421800', '0', '6/743,81/9 ATHI SAKTHI COMPLEX,SATCHAPURAM(NEAR SBI-TMB ATM)', 'SIVAKASI', NULL, '2019-11-20 17:03:07', 1),
(20, 'L.S.READYMADES', '9790594380', '33AKOPV7365H1ZZ', 'PAVOORCHATRAM,-627808', 'TIRUNELVELI DT', NULL, '2019-11-20 17:06:41', 1),
(21, 'DREAMZ', '9884032547', '0', '# 5,KATTABOMMAN STREET,TAMBARAM', 'CHENNAI-600113', NULL, '2019-11-20 17:18:27', 1);

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

--
-- Table structure for table `payment`
--

CREATE TABLE IF NOT EXISTS `payment` (
  `payment_id` int(11) NOT NULL,
  `invoice` int(11) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `mode` varchar(100) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `remark` text,
  `del` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`payment_id`, `invoice`, `payment_date`, `mode`, `amount`, `remark`, `del`) VALUES
(1, 2, '2019-07-17', 'cash', 500.00, '', 1),
(2, 1, '2019-10-30', 'cash', 100.00, '', 1);

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

--
-- Table structure for table `print_description`
--

CREATE TABLE IF NOT EXISTS `print_description` (
  `pd_id` int(11) NOT NULL,
  `print_description` varchar(150) DEFAULT NULL,
  `createdtime` datetime NOT NULL,
  `del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-active 1-inact 2-None option'
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `print_description`
--

INSERT INTO `print_description` (`pd_id`, `print_description`, `createdtime`, `del`) VALUES
(1, 'None', '2019-11-18 15:03:33', 2),
(7, 'CYCLE', '2019-11-19 00:00:00', 0),
(8, 'Boxing', '2019-11-19 00:00:00', 0),
(9, 'Berlin', '2019-11-19 00:00:00', 0),
(10, 'AERO DEPT', '2019-11-19 00:00:00', 0),
(11, 'USA', '2019-11-19 00:00:00', 0),
(12, '6', '2019-11-19 00:00:00', 0),
(13, 'DONTBITE', '2019-11-19 00:00:00', 0),
(14, 'NA', '2019-11-19 00:00:00', 0),
(15, 'DONâ€™T FOLLOW', '2019-11-19 00:00:00', 0),
(16, 'PERSONALITY', '2019-11-19 00:00:00', 0),
(17, 'MUSIC PLAYER', '2019-11-19 00:00:00', 0),
(18, 'CHURCH NAME', '2019-11-19 00:00:00', 0),
(19, 'usa liberty', '2019-11-21 12:01:25', 1),
(20, 'ROME', '2019-11-25 12:18:36', 0),
(21, 'PARIS', '2019-11-25 12:19:03', 0),
(22, 'HOLIDAY', '2019-11-25 12:19:40', 0),
(23, 'MASTERPLANHOLIDAY', '2019-11-25 13:08:23', 0),
(24, 'None', '2020-12-03 19:30:37', 0);

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

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

CREATE TABLE IF NOT EXISTS `product` (
  `pid` int(11) NOT NULL,
  `productname` varchar(100) DEFAULT NULL,
  `barcode` varchar(100) DEFAULT NULL,
  `style` int(11) DEFAULT NULL,
  `colour` int(11) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `product_image` varchar(500) DEFAULT 'no_image.png',
  `print` int(11) DEFAULT NULL,
  `wash` varchar(100) DEFAULT NULL,
  `createdtime` datetime DEFAULT NULL,
  `del` int(11) DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=342 DEFAULT CHARSET=latin1;

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

INSERT INTO `product` (`pid`, `productname`, `barcode`, `style`, `colour`, `size`, `amount`, `product_image`, `print`, `wash`, `createdtime`, `del`) VALUES
(1, 'Polo - T- Shirt  Short Sleeve with collar White M', '9520199234952', 1, 1, 1, NULL, 'no_image.png', 7, 'Bio Wash', '2019-07-16 15:55:56', 0),
(2, 'Polo - T- Shirt  Short Sleeve with collar White S', 'b1', 1, 1, 2, NULL, 'no_image.png', 1, '', '2019-07-17 11:40:58', 0),
(3, 'Round neck short sleeve White XL', '87999000022', 2, 2, 5, 170.00, 'no_image.png', 8, 'Bio wash', '2019-09-08 17:51:49', 0),
(4, 'Polo - T- Shirt  Short Sleeve with collar White L', '40', 1, 2, 4, 240.00, 'no_image.png', 1, 'Biowash', '2019-09-08 18:10:56', 0),
(5, 'Polo - T- Shirt  Short Sleeve with collar White S', '123', 1, 2, 2, 100.00, 'no_image.png', 1, '', '2019-09-13 15:02:41', 0),
(6, 'Polo - T- Shirt  Short Sleeve with collar White M', '456', 1, 2, 1, 200.00, 'no_image.png', 1, '', '2019-09-13 15:04:07', 0),
(7, 'Polo - T- Shirt  Short Sleeve with collar White L', '789', 1, 2, 4, 300.00, 'no_image.png', 1, '', '2019-09-13 15:04:41', 0),
(8, 'Round neck short sleeve Baby Pink S', '951901041340', 2, 4, 2, 170.00, 'no_image.png', 9, 'Bio Wash', '2019-09-19 14:10:07', 0),
(9, 'Round neck short sleeve Baby Pink M', '951901042340', 2, 4, 1, 170.00, 'no_image.png', 9, 'Bio Wash', '2019-09-19 14:11:16', 0),
(10, 'Round neck short sleeve Baby Pink L', '951901043340', 2, 4, 4, 170.00, 'no_image.png', 9, 'Bio Wash', '2019-09-19 14:12:03', 0),
(11, 'Round neck short sleeve Baby Pink XL', '951901044340', 2, 4, 5, 167.00, 'no_image.png', 9, 'Bio Wash', '2019-09-19 14:13:02', 0),
(12, 'Round neck short sleeve Baby Pink XXL', '951901045340', 2, 4, 6, 190.00, 'no_image.png', 9, 'Bio Wash', '2019-09-19 14:14:40', 0),
(13, 'Round neck short sleeve - Lt Blue - M', '9519020823205', 2, 9, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 15:49:17', 0),
(14, 'Round neck short sleeve - Lt Blue - L', '9519020833204', 2, 9, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 15:51:42', 0),
(15, 'Round neck short sleeve - Lt Blue - XL', '9519020843203', 2, 9, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 15:59:24', 0),
(16, 'Round neck short sleeve - Khaki Melange - XL', '9519021343207', 2, 10, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 16:03:09', 0),
(17, 'Round neck short sleeve - Royal blue - S', '9519021813205', 2, 11, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 16:05:47', 0),
(18, 'Round neck short sleeve - Royal blue - L', '9519021833203', 2, 11, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 16:06:51', 0),
(19, 'Round neck short sleeve - Royal blue - XL', '9519021843202', 2, 11, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 16:07:55', 0),
(20, 'Round neck short sleeve - Lt Blue - S', '9519020813206', 2, 9, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 16:08:48', 0),
(21, 'Round neck short sleeve - Khaki Melange - L', '9519021333208', 2, 10, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 16:10:43', 0),
(22, 'Round neck short sleeve - Khaki Melange - M', '9519021323209', 2, 10, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-10-18 16:11:51', 0),
(23, 'VN FS PLN - White - M', '9519080123406', 5, 2, 1, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-10-28 16:40:47', 0),
(24, 'Polo S/S w/Collar & Pocket Plain - Yellow - XL', '9519090944954', 18, 12, 5, 495.00, '7327725571572513253.jpg', 1, 'Bio Wash', '2019-10-31 14:44:13', 0),
(25, 'VN F/S Plain - Cream - M', '8907264529706', 6, 21, 1, 10.00, 'no_image.png', 1, '', '2019-11-06 18:34:57', 0),
(26, 'RN S/S Print - Black - S', '9519010213405', 11, 3, 2, 340.00, 'no_image.png', 10, 'Bio Wash', '2019-11-18 11:06:38', 1),
(27, 'RN S/S Print - Black - M', '9519010223404', 11, 3, 1, 340.00, 'no_image.png', 10, 'Bio Wash', '2019-11-18 11:13:42', 1),
(28, 'RN S/S Print - Black - L', '9519010233403', 11, 3, 4, 340.00, 'no_image.png', 10, 'Bio Wash', '2019-11-18 11:17:16', 1),
(29, 'RN S/S Print - Black - XL', '9519010243402', 11, 3, 5, 340.00, 'no_image.png', 10, 'Bio Wash', '2019-11-18 11:19:01', 1),
(30, 'RN S/S Print - Black - XXL', '9519010253609', 11, 3, 6, 360.00, 'no_image.png', 10, 'Bio Wash', '2019-11-18 11:20:08', 1),
(31, 'RN S/S Print - Red - S', '9518010313405', 11, 5, 2, 340.00, '1221801311574763100.jpg', 11, 'Bio Wash', '2019-11-18 11:21:04', 1),
(32, 'RN S/S Print - Red - M', '9518010323404', 11, 5, 1, 340.00, '6434468121574763120.jpg', 11, 'Bio Wash', '2019-11-18 11:21:45', 1),
(33, 'RN S/S Print - Red - L', '9518010333403', 11, 5, 4, 340.00, '12072930851574763140.jpg', 11, 'Bio Wash', '2019-11-18 11:22:52', 1),
(34, 'RN S/S Print - Red - XL', '9518010343402', 11, 5, 5, 340.00, '7383276451574763161.jpg', 11, 'Bio Wash', '2019-11-18 11:24:54', 1),
(35, 'RN S/S Print - Red - XXL', '9518010353609', 11, 5, 6, 360.00, '7532583261574763188.jpg', 11, 'Bio Wash', '2019-11-18 11:25:31', 1),
(36, 'RN S/S Print - Baby Pink - S', '9519010413409', 11, 4, 2, 340.00, '3437652751574763414.jpg', 9, 'Bio Wash', '2019-11-18 11:40:24', 1),
(37, 'RN S/S Print - Baby Pink - M', '9519010423408', 11, 4, 1, 340.00, '19505949071574763825.jpg', 9, 'Bio Wash', '2019-11-18 11:41:10', 1),
(38, 'RN S/S Print - Baby Pink - L', '9519010433407', 11, 4, 4, 340.00, '91005981574763506.jpg', 9, 'Bio Wash', '2019-11-18 11:41:57', 1),
(39, 'RN S/S Print - Baby Pink - XL', '9519010443406', 11, 4, 5, 340.00, '1853034011574763854.jpg', 9, 'Bio Wash', '2019-11-18 11:42:44', 1),
(40, 'RN S/S Print - Baby Pink - XXL', '9519010453603', 11, 4, 6, 360.00, '9257134561574763883.jpg', 9, 'Bio Wash', '2019-11-18 11:43:31', 1),
(41, 'RN S/S Print - Navy - S', '9519010513406', 11, 6, 2, 340.00, '17120750051574765723.jpg', 12, 'Bio Wash', '2019-11-18 11:44:48', 1),
(42, 'RN S/S Print - Navy - M', '9519010523405', 11, 6, 1, 340.00, '15026582171574765761.jpg', 12, 'Bio Wash', '2019-11-18 11:45:30', 1),
(43, 'RN S/S Print - Navy - L', '9519010533404', 11, 6, 4, 340.00, '8821427251574765787.jpg', 12, 'Bio Wash', '2019-11-18 11:46:06', 1),
(44, 'RN S/S Print - Navy - XL', '9519010543403', 11, 6, 5, 340.00, '11133157631574765813.jpg', 12, 'Bio Wash', '2019-11-18 11:47:01', 1),
(45, 'RN S/S Print - Navy - XXL', '9519010553600', 11, 6, 6, 360.00, '11312184281574765841.jpg', 12, 'Bio Wash', '2019-11-18 11:47:36', 1),
(46, 'RN S/S Print - Burgandy - S', '9519010613403', 11, 7, 2, 340.00, 'no_image.png', 13, 'Bio Wash', '2019-11-18 11:49:02', 1),
(47, 'RN S/S Print - Burgandy - M', '9519010623402', 11, 7, 1, 340.00, 'no_image.png', 13, 'Bio Wash', '2019-11-18 11:49:59', 1),
(48, 'RN S/S Print - Burgandy - L', '9519010633401', 11, 7, 4, 340.00, 'no_image.png', 13, 'Bio Wash', '2019-11-18 11:51:19', 1),
(49, 'RN S/S Print - Burgandy - XL', '9519010643400', 11, 7, 5, 340.00, 'no_image.png', 13, 'Bio Wash', '2019-11-18 11:52:09', 1),
(50, 'RN S/S Print - Burgandy - XXL', '9519010653607', 11, 7, 6, 360.00, 'no_image.png', 13, 'Bio Wash', '2019-11-18 11:52:56', 1),
(51, 'RN S/S Print - Grey Melange - S', '9519010713400', 11, 8, 2, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 11:54:16', 1),
(52, 'RN S/S Print - Grey Melange - M', '9519010723409', 11, 8, 1, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 11:56:10', 1),
(53, 'RN S/S Print - Grey Melange - L', '9519010733408', 11, 8, 4, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 11:57:30', 1),
(54, 'RN S/S Print - Grey Melange - XL', '9519010743407', 11, 8, 5, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 11:58:10', 1),
(55, 'RN S/S Print - Grey Melange - XXL', '9519010753604', 11, 8, 6, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 11:59:00', 1),
(56, 'RN S/S Print - LT. Blue - S', '9418010813403', 11, 9, 2, 340.00, '8543043751574763942.jpg', 11, 'Bio Wash', '2019-11-18 12:00:35', 1),
(57, 'RN S/S Print - LT. Blue - M', '9418010823402', 11, 9, 1, 340.00, '5049115781574763973.jpg', 11, 'Bio Wash', '2019-11-18 12:02:08', 1),
(58, 'RN S/S Print - LT. Blue - L', '9418010833401', 11, 9, 4, 340.00, '6251738391574763996.jpg', 11, 'Bio Wash', '2019-11-18 12:02:42', 1),
(59, 'RN S/S Print - LT. Blue - XL', '9418010843400', 11, 9, 5, 340.00, '18983403841574764019.jpg', 11, 'Bio Wash', '2019-11-18 12:03:58', 1),
(60, 'RN S/S Print - LT. Blue - XXL', '9418010853607', 11, 9, 6, 360.00, '1612192041574764043.jpg', 11, 'Bio Wash', '2019-11-18 12:04:40', 1),
(61, 'RN S/S Print - Yellow - S', '9519010913404', 11, 12, 2, 340.00, '15042344541574764491.jpg', 15, 'Bio Wash', '2019-11-18 12:05:39', 1),
(62, 'RN S/S Print - Yellow - M', '9519010923403', 11, 12, 1, 340.00, '11978477921574764521.jpg', 15, 'Bio Wash', '2019-11-18 12:06:28', 1),
(63, 'RN S/S Print - Yellow - L', '9519010933402', 11, 12, 4, 340.00, '8247461191574764539.jpg', 15, 'Bio Wash', '2019-11-18 12:07:14', 1),
(64, 'RN S/S Print - Yellow - XL', '9519010943401', 11, 12, 5, 340.00, '5596201401574764572.jpg', 15, 'Bio Wash', '2019-11-18 12:09:07', 1),
(65, 'RN S/S Print - Yellow - XXL', '9519010953608', 11, 12, 6, 360.00, '3782244821574764595.jpg', 15, 'Bio Wash', '2019-11-18 12:10:02', 1),
(66, 'RN S/S Print - Duty Orchid - S', '9519011013400', 11, 13, 2, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:13:19', 1),
(67, 'RN S/S Print - Dusty Orchid - M', '9519011023409', 11, 13, 1, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:14:36', 1),
(68, 'RN S/S Print - Dusty Orchid - L', '9519011033408', 11, 13, 4, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:16:25', 1),
(69, 'RN S/S Print - Dusty Orchid - XL', '9519011043407', 11, 13, 5, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:17:02', 1),
(70, 'RN S/S Print - Dusty Orchid - XXL', '9519011053604', 11, 13, 6, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:17:36', 1),
(71, 'RN S/S Print - Ceramic - S', '9519011113407', 11, 14, 2, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:18:34', 1),
(72, 'RN S/S Print - Ceramic - M', '9519011123406', 11, 14, 1, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:19:11', 1),
(73, 'RN S/S Print - Ceramic - L', '9519011133405', 11, 14, 4, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:20:03', 1),
(74, 'RN S/S Print - Ceramic - XL', '9519011143404', 11, 14, 5, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:20:37', 1),
(75, 'RN S/S Print - Ceramic - XXL', '9519011153601', 11, 14, 6, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:21:12', 1),
(76, 'RN S/S Print - Navy Melange - S', '9519011213404', 11, 15, 2, 340.00, 'no_image.png', 16, 'Bio Wash', '2019-11-18 12:22:41', 1),
(77, 'RN S/S Print - Navy Melange - M', '9519011223403', 11, 15, 1, 340.00, 'no_image.png', 16, 'Bio Wash', '2019-11-18 12:23:11', 1),
(78, 'RN S/S Print - Navy Melange - L', '9519011233402', 11, 15, 4, 340.00, 'no_image.png', 16, 'Bio Wash', '2019-11-18 12:23:38', 1),
(79, 'RN S/S Print - Navy Melange - XL', '9519011243401', 11, 15, 5, 340.00, 'no_image.png', 16, 'Bio Wash', '2019-11-18 12:24:30', 1),
(80, 'RN S/S Print - Navy Melange - XXL', '9519011253608', 11, 15, 6, 360.00, 'no_image.png', 16, 'Bio Wash', '2019-11-18 12:25:00', 1),
(81, 'RN S/S Print - Khaki Melange - S', '9519011313401', 11, 10, 2, 340.00, '17310717131574764912.jpg', 17, 'Bio Wash', '2019-11-18 12:26:22', 1),
(82, 'RN S/S Print - Khaki Melange - M', '9519011323400', 11, 10, 1, 340.00, '17017860391574764938.jpg', 17, 'Bio Wash', '2019-11-18 12:26:52', 1),
(83, 'RN S/S Print - Khaki Melange - L', '9519011333409', 11, 10, 4, 340.00, '8402867121574764968.jpg', 17, 'Bio Wash', '2019-11-18 12:27:18', 1),
(84, 'RN S/S Print - Khaki Melange - XL', '9519011343408', 11, 10, 5, 340.00, '2617324211574764994.jpg', 17, 'Bio Wash', '2019-11-18 12:28:01', 1),
(85, 'RN S/S Print - Khaki Melange - XXL', '9519011353605', 11, 10, 6, 360.00, '8498976381574765029.jpg', 17, 'Bio Wash', '2019-11-18 12:28:28', 1),
(86, 'RN S/S Print - LT. Brown Melange - S', '9519011413408', 11, 16, 2, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:29:19', 1),
(87, 'RN S/S Print - LT. Brown Melange - M', '9519011423407', 11, 16, 1, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:30:10', 1),
(88, 'RN S/S Print - LT. Brown Melange - L', '9519011433406', 11, 16, 4, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:30:48', 1),
(89, 'RN S/S Print - LT. Brown Melange - XL', '9519011443405', 11, 16, 5, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:31:18', 1),
(90, 'RN S/S Print - LT. Brown Melange - XXL', '9519011453602', 11, 16, 6, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:31:59', 1),
(91, 'RN S/S Print - Turquoise - S', '9519011513405', 11, 17, 2, 340.00, 'no_image.png', 18, 'Bio Wash', '2019-11-18 12:32:51', 1),
(92, 'RN S/S Print - Turquoise - M', '9519011523404', 11, 17, 1, 340.00, 'no_image.png', 18, 'Bio Wash', '2019-11-18 12:33:20', 1),
(93, 'RN S/S Print - Turquoise - L', '9519011533403', 11, 17, 4, 340.00, 'no_image.png', 18, 'Bio Wash', '2019-11-18 12:34:00', 1),
(94, 'RN S/S Print - Turquoise - XL', '9519011543402', 11, 17, 5, 340.00, 'no_image.png', 18, 'Bio Wash', '2019-11-18 12:34:32', 1),
(95, 'RN S/S Print - Turquoise - XXL', '9519011553609', 11, 17, 6, 360.00, 'no_image.png', 18, 'Bio Wash', '2019-11-18 12:35:04', 1),
(96, 'RN S/S Print - Olive - S', '9519011613402', 11, 18, 2, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:35:53', 1),
(97, 'RN S/S Print - Olive - M', '9519011623401', 11, 18, 1, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:37:27', 1),
(98, 'RN S/S Print - Olive - L', '9519011633400', 11, 18, 4, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:37:53', 1),
(99, 'RN S/S Print - Olive - XL', '9519011643409', 11, 18, 5, 340.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:38:24', 1),
(100, 'RN S/S Print - Olive - XXL', '9519011653606', 11, 18, 6, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 12:39:05', 1),
(101, 'RN S/S Plain - Black - S', '9519020213204', 10, 3, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:50:58', 1),
(102, 'RN S/S Plain - Black - M', '9519020223203', 10, 3, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:51:28', 1),
(103, 'RN S/S Plain - Black - L', '9519020233202', 10, 3, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:52:01', 1),
(104, 'RN S/S Plain - Black - XL', '9519020243201', 10, 3, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:53:21', 1),
(105, 'RN S/S Plain - Black - XXL', '9519020253408', 10, 3, 6, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:53:59', 1),
(106, 'RN S/S Plain - Red - S', '9519020313201', 10, 5, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:54:46', 1),
(107, 'RN S/S Plain - Red - M', '9519020323200', 10, 5, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:55:18', 1),
(108, 'RN S/S Plain - Red - L', '9519020333209', 10, 5, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:55:47', 1),
(109, 'RN S/S Plain - Red - XL', '9519020343208', 10, 5, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:56:17', 1),
(110, 'RN S/S Plain - Red - XXL', '9519020353405', 10, 5, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 12:58:24', 1),
(111, 'RN S/S Plain - Baby Pink - S', '9519020413208', 10, 4, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:02:16', 1),
(112, 'RN S/S Plain - Baby Pink - M', '9519020423207', 10, 4, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:03:00', 1),
(113, 'RN S/S Plain - Baby Pink - L', '9519020433206', 10, 4, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:05:41', 1),
(114, 'RN S/S Plain - Baby Pink - XL', '9519020443205', 10, 4, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:06:15', 1),
(115, 'RN S/S Plain - Baby Pink - XXL', '9519020453402', 10, 4, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:06:42', 1),
(116, 'RN S/S Plain - Navy - S', '9519020513205', 10, 6, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:07:59', 1),
(117, 'RN S/S Plain - Navy - M', '9519020523204', 10, 6, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:08:28', 1),
(118, 'RN S/S Plain - Navy - XL', '9519020543202', 10, 6, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:08:55', 1),
(119, 'RN S/S Plain - Navy - L', '9519020533203', 10, 6, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:10:57', 1),
(120, 'RN S/S Plain - Navy - XXL', '9519020553409', 10, 6, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:11:32', 1),
(121, 'RN S/S Plain - Burgandy - S', '9519020613202', 10, 7, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:14:34', 1),
(122, 'RN S/S Plain - Burgandy - M', '9519020623201', 10, 7, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:15:01', 1),
(123, 'RN S/S Plain - Burgandy - L', '9519020633200', 10, 7, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:15:36', 1),
(124, 'RN S/S Plain - Burgandy - XL', '9519020643209', 10, 7, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 13:16:07', 1),
(125, 'RN S/S Plain - Burgandy - XXL', '9519020653406', 10, 7, 6, 340.00, '3789114821574063363.jpg', 1, 'Bio Wash', '2019-11-18 13:16:39', 1),
(126, 'RN S/S Plain - Grey Melange - S', '9519020713209', 10, 8, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:04:04', 1),
(127, 'RN S/S Plain - Grey Melange - M', '9519020723208', 10, 8, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:04:44', 1),
(128, 'RN S/S Plain - Grey Melange - L', '9519020733207', 10, 8, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:05:23', 1),
(129, 'RN S/S Plain - Grey Melange - XL', '9519020743206', 10, 8, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:05:56', 1),
(130, 'RN S/S Plain - Grey Melange - XXL', '9519020753403', 10, 8, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:06:35', 1),
(131, 'RN S/S Plain - LT. Blue - S', '9519020813206', 10, 9, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:07:32', 1),
(132, 'RN S/S Plain - LT. Blue - M', '9519020823205', 10, 9, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:08:07', 1),
(133, 'RN S/S Plain - LT. Blue - L', '9519020833204', 10, 9, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:08:40', 1),
(134, 'RN S/S Plain - LT. Blue - XL', '9519020843203', 10, 9, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:09:50', 1),
(135, 'RN S/S Plain - LT. Blue - XXL', '9519020853400', 10, 9, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:10:34', 1),
(136, 'RN S/S Plain - Yellow - S', '9519020913203', 10, 12, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:11:27', 1),
(137, 'RN S/S Plain - Yellow - M', '9519020923202', 10, 12, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:11:58', 1),
(138, 'RN S/S Plain - Yellow - L', '9519020933201', 10, 12, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:12:30', 1),
(139, 'RN S/S Plain - Yellow - XL', '9519020943200', 10, 12, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:13:10', 1),
(140, 'RN S/S Plain - Yellow - XXL', '9519020953407', 10, 12, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:13:52', 1),
(141, 'RN S/S Plain - Dusty Orchid - S', '9519021013209', 10, 13, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:15:58', 1),
(142, 'RN S/S Plain - Dusty Orchid - M', '9519021023208', 10, 13, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:16:45', 1),
(143, 'RN S/S Plain - Dusty Orchid - L', '9519021033207', 10, 13, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:17:34', 1),
(144, 'RN S/S Plain - Dusty Orchid - L', '951902103320', 10, 13, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:17:34', 0),
(145, 'RN S/S Plain - Dusty Orchid - L', '951902103320', 10, 13, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:17:34', 0),
(146, 'RN S/S Plain - Dusty Orchid - XL', '9519021043206', 10, 13, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:18:50', 1),
(147, 'RN S/S Plain - Dusty Orchid - XXL', '9519021053403', 10, 13, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:19:55', 1),
(148, 'RN S/S Plain - Ceramic - S', '9519021113206', 10, 14, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:20:55', 1),
(149, 'RN S/S Plain - Ceramic - M', '9519021123205', 10, 14, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:21:26', 1),
(150, 'RN S/S Plain - Ceramic - L', '9519021133204', 10, 14, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:22:08', 1),
(151, 'RN S/S Plain - Ceramic - XL', '9519021143203', 10, 14, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:22:47', 1),
(152, 'RN S/S Plain - Ceramic - XXL', '9519021153400', 10, 14, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:23:38', 1),
(153, 'RN S/S Plain - Navy Melange - S', '9519021213203', 10, 15, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:24:36', 1),
(154, 'RN S/S Plain - Navy Melange - M', '9519021223202', 10, 15, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:25:35', 1),
(155, 'RN S/S Plain - Navy Melange - L', '9519021233201', 10, 15, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:26:33', 1),
(156, 'RN S/S Plain - Navy Melange - XL', '9519021243200', 10, 15, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:27:19', 1),
(157, 'RN S/S Plain - Navy Melange - XXL', '9519021253407', 10, 15, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:28:03', 1),
(158, 'RN S/S Plain - Khaki Melange - S', '9519021313200', 10, 10, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:29:00', 1),
(159, 'RN S/S Plain - Khaki Melange - M', '9519021323209', 10, 10, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:29:42', 1),
(160, 'RN S/S Plain - Khaki Melange - L', '9519021333208', 10, 10, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:30:28', 1),
(161, 'RN S/S Plain - Khaki Melange - XL', '9519021343207', 10, 10, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:31:06', 1),
(162, 'RN S/S Plain - Khaki Melange - XXL', '9519021353404', 10, 10, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:31:47', 1),
(163, 'RN S/S Plain - LT. Brown Melange - S', '9519021413207', 10, 16, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:32:33', 1),
(164, 'RN S/S Plain - LT. Brown Melange - M', '9519021423206', 10, 16, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:33:00', 1),
(165, 'RN S/S Plain - LT. Brown Melange - L', '9519021433205', 10, 16, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:33:30', 1),
(166, 'RN S/S Plain - LT. Brown Melange - XL', '9519021443204', 10, 16, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:34:05', 1),
(167, 'RN S/S Plain - LT. Brown Melange - XXL', '9519021453401', 10, 16, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:34:43', 1),
(168, 'RN S/S Plain - Turquoise - S', '9519021513204', 10, 17, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:35:39', 1),
(169, 'RN S/S Plain - Turquoise - M', '9519021523203', 10, 17, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:36:10', 1),
(170, 'RN S/S Plain - Turquoise - L', '9519021533202', 10, 17, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:37:08', 1),
(171, 'RN S/S Plain - Turquoise - XL', '9519021543201', 10, 17, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:48:02', 1),
(172, 'RN S/S Plain - Turquoise - XXL', '9519021553408', 10, 17, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:48:50', 1),
(173, 'RN S/S Plain - Olive - S', '9519021613201', 10, 18, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:49:35', 1),
(174, 'RN S/S Plain - Olive - M', '9519021623200', 10, 18, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:50:09', 1),
(175, 'RN S/S Plain - Olive - L', '9519021633209', 10, 18, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:50:40', 1),
(176, 'RN S/S Plain - Olive - XL', '9519021643208', 10, 18, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:51:07', 1),
(177, 'RN S/S Plain - Olive - XXL', '9519021653405', 10, 18, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:54:41', 1),
(178, 'RN S/S Plain - LT. Brown - S', '9519021713208', 10, 19, 2, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:55:42', 1),
(179, 'RN S/S Plain - LT. Brown - M', '9519021723207', 10, 19, 1, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:56:12', 1),
(180, 'RN S/S Plain - LT. Brown - L', '9519021733206', 10, 19, 4, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:56:54', 1),
(181, 'RN S/S Plain - LT. Brown - XL', '9519021743205', 10, 19, 5, 320.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:57:25', 1),
(182, 'RN S/S Plain - LT. Brown - XXL', '9519021753402', 10, 19, 6, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-18 16:57:51', 1),
(183, 'RN F/S Print - Black - S', '9519030213607', 12, 3, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 16:59:13', 1),
(184, 'RN F/S Print - Black - M', '9519030223606', 12, 3, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 16:59:44', 1),
(185, 'RN F/S Print - Black - L', '9519030233605', 12, 3, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:00:52', 1),
(186, 'RN F/S Print - Black - XL', '9519030243604', 12, 3, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:01:35', 1),
(187, 'RN F/S Print - Black - XXL', '9519030253801', 12, 3, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:02:07', 1),
(188, 'RN F/S Print - Red - S', '9519030313604', 12, 5, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:02:52', 1),
(189, 'RN F/S Print - Red - M', '9519030323603', 12, 5, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:03:27', 1),
(190, 'RN F/S Print - Red - L', '9519030333602', 12, 5, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:03:55', 1),
(191, 'RN F/S Print - Red - XL', '9519030343601', 12, 5, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:04:25', 1),
(192, 'RN F/S Print - Red - XXL', '9519030353808', 12, 5, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:04:54', 1),
(193, 'RN F/S Print - Baby Pink - S', '9519030413601', 12, 4, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:05:43', 1),
(194, 'RN F/S Print - Baby Pink - M', '9519030423600', 12, 4, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:07:44', 1),
(195, 'RN F/S Print - Baby Pink - L', '9519030433609', 12, 4, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:08:16', 1),
(196, 'RN F/S Print - Baby Pink - XL', '9519030443608', 12, 4, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:08:58', 1),
(197, 'RN F/S Print - Baby Pink - XXL', '9519030453805', 12, 4, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:09:32', 1),
(198, 'RN F/S Print - Navy - S', '9519030513608', 12, 6, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:33:49', 1),
(199, 'RN F/S Print - Navy - M', '9519030523607', 12, 6, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:34:25', 1),
(200, 'RN F/S Print - Navy - L', '9519030533606', 12, 6, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:34:58', 1),
(201, 'RN F/S Print - Navy - XL', '9519030543605', 12, 6, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:35:27', 1),
(202, 'RN F/S Print - Navy - XXL', '9519030553802', 12, 6, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:36:00', 1),
(203, 'RN F/S Print - Burgandy - S', '9519030613605', 12, 7, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:36:54', 1),
(204, 'RN F/S Print - Burgandy - M', '9519030623604', 12, 7, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:37:21', 1),
(205, 'RN F/S Print - Burgandy - L', '9519030633603', 12, 7, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:37:50', 1),
(206, 'RN F/S Print - Burgandy - XL', '9519030643602', 12, 7, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:38:18', 1),
(207, 'RN F/S Print - Burgandy - XXL', '9519030653809', 12, 7, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-18 17:38:45', 1),
(208, 'RN F/S Print - Grey Melange - S', '9519030713602', 12, 8, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:08:14', 1),
(209, 'RN F/S Print - Grey Melange - M', '9519030723601', 12, 8, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:08:49', 1),
(210, 'RN F/S Print - Grey Melange - L', '9519030733600', 12, 8, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:09:26', 1),
(211, 'RN F/S Print - Grey Melange - XL', '9519030743609', 12, 8, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:09:55', 1),
(212, 'RN F/S Print - Grey Melange - XXL', '9519030753806', 12, 8, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:10:24', 1),
(213, 'RN F/S Print - LT. Blue - S', '9519030813609', 12, 9, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:11:22', 1),
(214, 'RN F/S Print - LT. Blue - M', '9519030823608', 12, 9, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:11:56', 1),
(215, 'RN F/S Print - LT. Blue - L', '9519030833607', 12, 9, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:12:42', 1),
(216, 'RN F/S Print - LT. Blue - XL', '9519030843606', 12, 9, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:13:10', 1),
(217, 'RN F/S Print - LT. Blue - XXL', '9519030853803', 12, 9, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:13:43', 1),
(218, 'RN F/S Print - Yellow - S', '9519030913606', 12, 12, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:15:16', 1),
(219, 'RN F/S Print - Yellow - M', '9519030923605', 12, 12, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:16:11', 1),
(220, 'RN F/S Print - Yellow - L', '9519030933604', 12, 12, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:17:00', 1),
(221, 'RN F/S Print - Yellow - XL', '9519030943603', 12, 12, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:19:04', 1),
(222, 'RN F/S Print - Yellow - XXL', '9519030953800', 12, 12, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:20:03', 1),
(223, 'RN F/S Print - Yellow - XXL', '951903095380', 12, 12, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:20:03', 0),
(224, 'RN F/S Print - Dusty Orchid - S', '9519031013602', 12, 13, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:22:47', 1),
(225, 'RN F/S Print - Dusty Orchid - M', '9519031023601', 12, 13, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:23:20', 1),
(226, 'RN F/S Print - Dusty Orchid - L', '9519031033600', 12, 13, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:23:54', 1),
(227, 'RN F/S Print - Dusty Orchid - XL', '9519031043609', 12, 13, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:24:24', 1),
(228, 'RN F/S Print - Dusty Orchid - XXL', '9519031053806', 12, 13, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:24:53', 1),
(229, 'RN F/S Print - Ceramic - S', '9519031113609', 12, 14, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:28:02', 1),
(230, 'RN F/S Print - Ceramic - M', '9519031123608', 12, 14, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:28:40', 1),
(231, 'RN F/S Print - Ceramic - L', '9519031133607', 12, 14, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:29:09', 1),
(232, 'RN F/S Print - Ceramic - XL', '9519031143606', 12, 14, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:30:05', 1),
(233, 'RN F/S Print - Ceramic - XXL', '9519031153803', 12, 14, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:30:34', 1),
(234, 'RN F/S Print - Navy Melange - S', '9519031213606', 12, 15, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:32:11', 1),
(235, 'RN F/S Print - Navy Melange - M', '9519031223605', 12, 15, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:32:37', 1),
(236, 'RN F/S Print - Navy Melange - L', '9519031233604', 12, 15, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:33:08', 1),
(237, 'RN F/S Print - Navy Melange - XL', '9519031243603', 12, 15, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:33:44', 1),
(238, 'RN F/S Print - Navy Melange - XXL', '9519031253800', 12, 15, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:34:12', 1),
(239, 'RN F/S Print - Khaki Melange - S', '9519031313603', 12, 10, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:35:06', 1),
(240, 'RN F/S Print - Khaki Melange - M', '9519031323602', 12, 10, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:36:06', 1),
(241, 'RN F/S Print - Khaki Melange - L', '9519031333601', 12, 10, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:36:41', 1),
(242, 'RN F/S Print - Khaki Melange - XL', '9519031343600', 12, 10, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:37:10', 1),
(243, 'RN F/S Print - Khaki Melange - XXL', '9519031353807', 12, 10, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:37:50', 1),
(244, 'RN F/S Print - LT. Brown Melange - S', '9519031413600', 12, 16, 2, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:38:37', 1),
(245, 'RN F/S Print - LT. Brown Melange - M', '9519031423609', 12, 16, 1, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:39:11', 1),
(246, 'RN F/S Print - LT. Brown Melange - L', '9519031433608', 12, 16, 4, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:39:44', 1),
(247, 'RN F/S Print - LT. Brown Melange - XL', '9519031443607', 12, 16, 5, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:40:11', 1),
(248, 'RN F/S Print - LT. Brown Melange - XXL', '9519031453804', 12, 16, 6, 380.00, 'no_image.png', 14, 'Bio Wash', '2019-11-19 11:40:48', 1),
(249, 'RN F/S Print - Turquoise - S', '9519031513607', 12, 17, 2, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:18:26', 1),
(250, 'RN F/S Print - Turquoise - M', '9519031523606', 12, 17, 1, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:18:53', 1),
(251, 'RN F/S Print - Turquoise - L', '9519031533605', 12, 17, 4, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:19:20', 1),
(252, 'RN F/S Print - Turquoise - XL', '9519031543604', 12, 17, 5, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:19:47', 1),
(253, 'RN F/S Print - Turquoise - XXL', '9519031553801', 12, 17, 6, 380.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:20:12', 1),
(254, 'RN F/S Print - Olive - S', '9519031613604', 12, 18, 2, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:20:54', 1),
(255, 'RN F/S Print - Olive - M', '9519031623603', 12, 18, 1, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:21:19', 1),
(256, 'RN F/S Print - Olive - L', '9519031633602', 12, 18, 4, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:21:45', 1),
(257, 'RN F/S Print - Olive - XL', '9519031643601', 12, 18, 5, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:22:13', 1),
(258, 'RN F/S Print - Olive - XL', '951903164360', 12, 18, 5, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:22:13', 0),
(259, 'RN F/S Print - Olive - XL', '951903164360', 12, 18, 5, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:22:13', 0),
(260, 'RN F/S Print - Olive - XXL', '951903165380', 12, 18, 6, 380.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:23:05', 0),
(261, 'RN F/S Print - Olive - XXL', '951903165380', 12, 18, 6, 380.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:23:05', 0),
(262, 'RN F/S Print - Olive - XXL', '9519031653808', 12, 18, 6, 380.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:23:05', 1),
(263, 'RN F/S Print - LT. Brown - S', '9519031713601', 12, 19, 2, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:24:16', 1),
(264, 'RN F/S Print - LT. Brown - M', '9519031723600', 12, 19, 1, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:24:47', 1),
(265, 'RN F/S Print - LT. Brown - L', '9519031733609', 12, 19, 4, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:25:14', 1),
(266, 'RN F/S Print - LT. Brown - XL', '9519031743608', 12, 19, 5, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:25:55', 1),
(267, 'RN F/S Print - LT. Brown - XXL', '9519031753805', 12, 19, 6, 380.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:26:20', 1),
(268, 'RN F/S Plain - Black - S', '9519040213406', 13, 3, 2, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:28:15', 1),
(269, 'RN F/S Plain - Black - M', '9519040223405', 13, 3, 1, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:28:58', 1),
(270, 'RN F/S Plain - Black - L', '9519040233404', 13, 3, 4, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:29:28', 1),
(271, 'RN F/S Plain - Black - XL', '9519040243403', 13, 3, 5, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:30:34', 1),
(272, 'RN F/S Plain - Black - XXL', '9519040253600', 13, 3, 6, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:31:13', 1),
(273, 'RN F/S Plain - Red - S', '9519040313403', 13, 5, 2, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:32:01', 1),
(274, 'RN F/S Plain - Red - M', '9519040323402', 13, 5, 1, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:32:27', 1),
(275, 'RN F/S Plain - Red - L', '9519040333401', 13, 5, 4, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:32:50', 1),
(276, 'RN F/S Plain - Red - XL', '9519040343400', 13, 5, 5, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:33:20', 1),
(277, 'RN F/S Plain - Red - XXL', '9519040353607', 13, 5, 6, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:33:44', 1),
(278, 'RN F/S Plain - Baby Pink - S', '9519040413400', 13, 4, 2, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:38:01', 1),
(279, 'RN F/S Plain - Baby Pink - M', '9519040423409', 13, 4, 1, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:38:42', 1),
(280, 'RN F/S Plain - Baby Pink - L', '9519040433408', 13, 4, 4, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:39:28', 1),
(281, 'RN F/S Plain - Baby Pink - XL', '9519040443407', 13, 4, 5, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:40:07', 1),
(282, 'RN F/S Plain - Baby Pink - XXL', '9519040454601', 13, 4, 6, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:40:35', 1),
(283, 'RN F/S Plain - Navy - S', '9519040513407', 13, 6, 2, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:41:14', 1),
(284, 'RN F/S Plain - Navy - M', '9519040523406', 13, 6, 1, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:41:43', 1),
(285, 'RN F/S Plain - Navy - L', '9519040533405', 13, 6, 4, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:42:07', 1),
(286, 'RN F/S Plain - Navy - XL', '9519040543404', 13, 6, 5, 340.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:42:31', 1),
(287, 'RN F/S Plain - Navy - XXL', '9519040553601', 13, 6, 6, 360.00, 'no_image.png', 1, 'Bio Wash', '2019-11-20 11:43:05', 1),
(288, 'VN F/S Plain - White - XXL', '9519080153601', 6, 2, 6, 360.00, 'no_image.png', 14, 'Bio Wash', '2019-11-22 12:46:46', 1),
(289, 'RN S/S Print - Red - S', '9418010313408', 11, 5, 2, 340.00, '8424510651574765914.jpg', 20, 'Bio Wash', '2019-11-25 12:18:18', 1),
(290, 'RN S/S Print - Red - M', '9418010323407', 11, 5, 1, 340.00, 'no_image.png', 20, 'Bio Wash', '2019-11-25 12:28:20', 0),
(291, 'RN S/S Print - Red - M', '9418010323407', 11, 5, 1, 340.00, '7255687631574765939.jpg', 20, 'Bio Wash', '2019-11-25 12:28:20', 1),
(292, 'RN S/S Print - Red - L', '9418010333406', 11, 5, 4, 340.00, '3778664551574765958.jpg', 20, 'Bio Wash', '2019-11-25 12:30:41', 1),
(293, 'RN S/S Print - Red - XL', '9418010343405', 11, 5, 5, 340.00, 'no_image.png', 20, 'Bio Wash', '2019-11-25 12:31:31', 0),
(294, 'RN S/S Print - Red - XL', '9418010343405', 11, 5, 5, 340.00, '3137637481574765977.jpg', 20, 'Bio Wash', '2019-11-25 12:31:31', 1),
(295, 'RN S/S Print - Red - XXL', '9418010353602', 11, 5, 6, 360.00, '12946206361574765992.jpg', 20, 'Bio Wash', '2019-11-25 12:32:47', 1),
(296, 'RN S/S Print - Red - S', '9618010313402', 11, 5, 2, 340.00, '19354166801574766566.jpg', 21, 'Bio Wash', '2019-11-25 12:36:05', 1),
(297, 'RN S/S Print - Black - S', '9418010213401', 11, 3, 2, 340.00, '11119465151574763230.jpg', 11, 'Bio Wash', '2019-11-25 12:38:58', 1),
(298, 'RN S/S Print - Red - M', '9618010323401', 11, 5, 1, 340.00, '1544647641574766580.jpg', 21, 'Bio Wash', '2019-11-25 12:39:58', 1),
(299, 'RN S/S Print - Red - L', '9618010333400', 11, 5, 4, 340.00, '12090032441574766595.jpg', 21, 'Bio Wash', '2019-11-25 12:40:25', 1),
(300, 'RN S/S Print - Red - XL', '9618010343409', 11, 5, 5, 340.00, '5995250371574766610.jpg', 21, 'Bio Wash', '2019-11-25 12:40:51', 1),
(301, 'RN S/S Print - Red - XXL', '9618010353606', 11, 5, 6, 360.00, '3162935461574766626.jpg', 21, 'Bio Wash', '2019-11-25 12:41:25', 1),
(302, 'RN S/S Print - Black - M', '9418010223400', 11, 3, 1, 340.00, '7362524461574763255.jpg', 11, 'Bio Wash', '2019-11-25 12:42:06', 1),
(303, 'RN S/S Print - Black - L', '9418010233409', 11, 3, 4, 340.00, '17587777921574763274.jpg', 11, 'Bio Wash', '2019-11-25 12:42:38', 1),
(304, 'RN S/S Print - Black - XL', '9418010243408', 11, 3, 5, 340.00, '18226193331574763296.jpg', 11, 'Bio Wash', '2019-11-25 12:43:41', 1),
(305, 'RN S/S Print - Black - XXL', '9418010253605', 11, 3, 6, 360.00, '11765026471574763314.jpg', 11, 'Bio Wash', '2019-11-25 12:44:27', 1),
(306, 'RN S/S Print - Black - S', '9518010213408', 11, 3, 2, 340.00, '15831358871574766071.jpg', 20, 'Bio Wash', '2019-11-25 12:54:24', 1),
(307, 'RN S/S Print - Black - M', '9518010223407', 11, 3, 1, 340.00, '4181033571574766084.jpg', 20, 'Bio Wash', '2019-11-25 12:55:02', 1),
(308, 'RN S/S Print - Black - L', '9518010233406', 11, 3, 4, 340.00, '13704412701574766097.jpg', 20, 'Bio Wash', '2019-11-25 12:55:32', 1),
(309, 'RN S/S Print - Black - XL', '9518010243405', 11, 3, 5, 340.00, '14911344241574766112.jpg', 20, 'Bio Wash', '2019-11-25 12:56:00', 1),
(310, 'RN S/S Print - Black - XXL', '9518010253602', 11, 3, 6, 340.00, '15393947901574766129.jpg', 20, 'Bio Wash', '2019-11-25 12:56:32', 1),
(311, 'RN S/S Print - Black - S', '9618010213405', 11, 3, 2, 340.00, '15811702651574766731.jpg', 21, 'Bio Wash', '2019-11-25 12:56:59', 1),
(312, 'RN S/S Print - Black - M', '9618010223404', 11, 3, 1, 340.00, '11364800121574766743.jpg', 21, 'Bio Wash', '2019-11-25 12:57:23', 1),
(313, 'RN S/S Print - Black - L', '9618010233403', 11, 3, 4, 340.00, '20036500361574766757.jpg', 21, 'Bio Wash', '2019-11-25 12:57:53', 1),
(314, 'RN S/S Print - Black - XL', '9618010243402', 11, 3, 5, 340.00, '4153453761574766770.jpg', 21, 'Bio Wash', '2019-11-25 12:58:20', 1),
(315, 'RN S/S Print - Black - XXL', '9618010253609', 11, 3, 6, 360.00, '13301273431574766784.jpg', 21, 'Bio Wash', '2019-11-25 12:58:47', 1),
(316, 'RN S/S Print - LT. Blue - S', '9518010813400', 11, 9, 2, 340.00, '13022504741574766464.jpg', 20, 'Bio Wash', '2019-11-25 13:00:00', 1),
(317, 'RN S/S Print - LT. Blue - M', '9518010823409', 11, 9, 1, 340.00, '15777843711574766482.jpg', 20, 'Bio Wash', '2019-11-25 13:00:33', 1),
(318, 'RN S/S Print - LT. Blue - L', '9518010833408', 11, 9, 4, 340.00, '12038211091574766496.jpg', 20, 'Bio Wash', '2019-11-25 13:01:01', 1),
(319, 'RN S/S Print - LT. Blue - XL', '9518010843407', 11, 9, 5, 340.00, '12661696091574766509.jpg', 20, 'Bio Wash', '2019-11-25 13:01:32', 1),
(320, 'RN S/S Print - LT. Blue - XXL', '9518010853604', 11, 9, 6, 360.00, '9924680091574766522.jpg', 20, 'Bio Wash', '2019-11-25 13:02:01', 1),
(321, 'RN S/S Print - LT. Blue - S', '9618010813407', 11, 9, 2, 340.00, '13091832581574764331.jpg', 21, 'Bio Wash', '2019-11-25 13:02:36', 1),
(322, 'RN S/S Print - LT. Blue - M', '9618010823406', 11, 9, 1, 340.00, '19270171881574764347.jpg', 21, 'Bio Wash', '2019-11-25 13:03:04', 1),
(323, 'RN S/S Print - LT. Blue - L', '9618010833405', 11, 9, 4, 340.00, '3512331021574764368.jpg', 21, 'Bio Wash', '2019-11-25 13:03:35', 1),
(324, 'RN S/S Print - LT. Blue - XL', '9618010843404', 11, 9, 5, 340.00, '16003896861574764387.jpg', 21, 'Bio Wash', '2019-11-25 13:04:00', 1),
(325, 'RN S/S Print - LT. Blue - XXL', '9618010853601', 11, 9, 6, 360.00, '422943211574764407.jpg', 21, 'Bio Wash', '2019-11-25 13:04:26', 1),
(326, 'RN S/S Print - LT. Blue - S', '9718010813404', 11, 9, 2, 340.00, 'no_image.png', 22, 'Bio Wash', '2019-11-25 13:04:57', 1),
(327, 'RN S/S Print - LT. Blue - M', '9718010823403', 11, 9, 1, 340.00, 'no_image.png', 22, 'Bio Wash', '2019-11-25 13:05:32', 1),
(328, 'RN S/S Print - LT. Blue - L', '9718010833402', 11, 9, 4, 340.00, 'no_image.png', 22, 'Bio Wash', '2019-11-25 13:06:00', 1),
(329, 'RN S/S Print - LT. Blue - XL', '9718010843401', 11, 9, 5, 340.00, 'no_image.png', 22, 'Bio Wash', '2019-11-25 13:06:52', 1),
(330, 'RN S/S Print - LT. Blue - XXL', '9718010853608', 11, 9, 6, 360.00, 'no_image.png', 22, 'Bio Wash', '2019-11-25 13:07:31', 1),
(331, 'RN S/S Print - LT. Brown - S', '9519011713409', 11, 19, 2, 340.00, '16729699211574764683.jpg', 23, 'Bio Wash', '2019-11-25 13:08:55', 1),
(332, 'RN S/S Print - LT. Brown - M', '9519011723408', 11, 19, 1, 340.00, '17271231211574764703.jpg', 23, 'Bio Wash', '2019-11-25 13:09:21', 1),
(333, 'RN S/S Print - LT. Brown - L', '9519011733407', 11, 19, 4, 340.00, '7889858371574764719.jpg', 23, 'Bio Wash', '2019-11-25 13:09:58', 1),
(334, 'RN S/S Print - LT. Brown - XL', '9519011743406', 11, 19, 5, 340.00, '12172848251574764735.jpg', 23, 'Bio Wash', '2019-11-25 13:10:29', 1),
(335, 'RN S/S Print - LT. Brown - XXL', '9519011753603', 11, 19, 6, 360.00, '10544676521574764753.jpg', 23, 'Bio Wash', '2019-11-25 13:11:06', 1),
(336, 'VN S/S Print - Ceramic - S', '9519012213403', 8, 14, 2, 340.00, 'no_image.png', 12, 'Bio Wash', '2020-02-01 16:54:29', 1),
(337, 'VN S/S Print - Ceramic - M', '9519012223402', 8, 14, 1, 340.00, 'no_image.png', 12, 'Bio Wash', '2020-02-01 16:56:32', 0),
(338, 'VN S/S Print - Ceramic - M', '9519012223402', 8, 14, 1, 340.00, 'no_image.png', 12, 'Bio Wash', '2020-02-01 16:56:38', 1),
(339, 'VN S/S Print - Ceramic - L', '9519012233401', 8, 14, 4, 340.00, 'no_image.png', 12, 'no wash', '2020-02-01 16:58:24', 1),
(340, 'VN F/S Plain - Royal blue - S', '8909291787435', 6, 11, 2, 500.00, 'no_image.png', 1, 'test', '2020-02-06 13:36:26', 0),
(341, '100% Cotton - Woven Checks/short sleeve  - Navy - 40', '9201215409157', 20, 22, 9, 915.00, '10438732491607188267.jpg', 1, 'None', '2020-12-05 22:41:07', 1);

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

--
-- Table structure for table `returninvoice`
--

CREATE TABLE IF NOT EXISTS `returninvoice` (
  `rid` int(11) NOT NULL,
  `invoiceid` int(11) DEFAULT NULL,
  `returndate` date DEFAULT NULL,
  `quantity` int(50) DEFAULT NULL,
  `returnamount` decimal(10,2) DEFAULT NULL,
  `remark` varchar(500) DEFAULT NULL,
  `del` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `returninvoice`
--

INSERT INTO `returninvoice` (`rid`, `invoiceid`, `returndate`, `quantity`, `returnamount`, `remark`, `del`) VALUES
(1, 2, '2019-07-17', NULL, NULL, 'teest', 0),
(2, 1, '2019-10-30', NULL, NULL, 'tes5t', 1);

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

--
-- Table structure for table `returninvoice_products`
--

CREATE TABLE IF NOT EXISTS `returninvoice_products` (
  `rid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `rquantity` int(11) DEFAULT NULL,
  `rtotal` decimal(10,2) DEFAULT NULL,
  `del` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `returninvoice_products`
--

INSERT INTO `returninvoice_products` (`rid`, `pid`, `rquantity`, `rtotal`, `del`) VALUES
(1, 2, 4, 400.00, 0),
(1, 1, 3, 600.00, 0),
(2, 1, 1, 260.00, 1);

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

--
-- Table structure for table `size`
--

CREATE TABLE IF NOT EXISTS `size` (
  `sid` int(11) NOT NULL,
  `size` varchar(100) DEFAULT NULL,
  `createdtime` datetime DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `size`
--

INSERT INTO `size` (`sid`, `size`, `createdtime`, `del`) VALUES
(1, 'M', '2019-07-16 15:55:19', 1),
(2, 'S', '2019-07-17 11:39:46', 1),
(3, 'S', '2019-09-08 17:49:03', 0),
(4, 'L', '2019-09-08 17:49:25', 1),
(5, 'XL', '2019-09-08 17:49:44', 1),
(6, 'XXL', '2019-09-19 14:04:48', 1),
(7, '36', '2020-12-03 19:28:31', 1),
(8, '38', '2020-12-03 19:29:30', 1),
(9, '40', '2020-12-03 19:29:43', 1),
(10, '42', '2020-12-03 19:30:08', 1),
(11, '44', '2020-12-03 19:30:21', 1);

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

--
-- Table structure for table `style`
--

CREATE TABLE IF NOT EXISTS `style` (
  `sid` int(11) NOT NULL,
  `style` varchar(100) DEFAULT NULL,
  `createdtime` datetime DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `style`
--

INSERT INTO `style` (`sid`, `style`, `createdtime`, `del`) VALUES
(1, 'Polo T-Shirt  S/S w/collar & pocket', '2019-07-16 15:54:41', 0),
(2, 'Round neck Short Sleeve', '2019-09-08 17:46:48', 0),
(3, 'V - neck Short Sleeve', '2019-10-28 15:59:47', 0),
(4, 'Round neck Full Sleeve', '2019-10-28 16:01:15', 0),
(5, 'VN FS PLN', '2019-10-28 16:38:08', 0),
(6, 'VN F/S Plain', '2019-10-30 11:44:05', 1),
(7, 'VN F/S Print', '2019-10-30 11:46:03', 1),
(8, 'VN S/S Print', '2019-10-30 11:46:54', 1),
(9, 'VN S/S Plain', '2019-10-30 11:47:31', 1),
(10, 'RN S/S Plain', '2019-10-30 11:48:32', 1),
(11, 'RN S/S Print', '2019-10-30 11:48:45', 1),
(12, 'RN F/S Print', '2019-10-30 11:49:04', 1),
(13, 'RN F/S Plain', '2019-10-30 11:49:22', 1),
(14, 'Polo S/S w/Collar Y/D', '2019-10-30 11:53:17', 1),
(15, 'Polo S/S w/Collar Plain', '2019-10-30 12:00:20', 1),
(16, 'Polo S/S w/Collar Print', '2019-10-30 12:01:07', 1),
(17, 'Polo S/S w/Collar & Pocket Y/D', '2019-10-30 12:01:42', 1),
(18, 'Polo S/S w/Collar & Pocket Plain', '2019-10-30 12:01:58', 1),
(19, 'Polo S/S w/Collar & Pocket Print', '2019-10-30 12:02:12', 1),
(20, '100% Cotton - Woven Checks/short sleeve ', '2020-12-03 19:23:46', 1);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `agent_details`
--
ALTER TABLE `agent_details`
  ADD PRIMARY KEY (`aid`);

--
-- Indexes for table `cancelinvoice`
--
ALTER TABLE `cancelinvoice`
  ADD PRIMARY KEY (`cid`);

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

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

--
-- Indexes for table `colour`
--
ALTER TABLE `colour`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `delivery_in`
--
ALTER TABLE `delivery_in`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `delivery_out`
--
ALTER TABLE `delivery_out`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
  ADD PRIMARY KEY (`invoice_id`);

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

--
-- Indexes for table `party`
--
ALTER TABLE `party`
  ADD PRIMARY KEY (`pid`);

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`payment_id`);

--
-- Indexes for table `print_description`
--
ALTER TABLE `print_description`
  ADD PRIMARY KEY (`pd_id`);

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

--
-- Indexes for table `returninvoice`
--
ALTER TABLE `returninvoice`
  ADD PRIMARY KEY (`rid`);

--
-- Indexes for table `size`
--
ALTER TABLE `size`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `style`
--
ALTER TABLE `style`
  ADD PRIMARY KEY (`sid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `agent_details`
--
ALTER TABLE `agent_details`
  MODIFY `aid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `cancelinvoice`
--
ALTER TABLE `cancelinvoice`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `carco_booking_details`
--
ALTER TABLE `carco_booking_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `carco_delivery_status`
--
ALTER TABLE `carco_delivery_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `colour`
--
ALTER TABLE `colour`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `delivery_in`
--
ALTER TABLE `delivery_in`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `delivery_out`
--
ALTER TABLE `delivery_out`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
--
-- AUTO_INCREMENT for table `invoice`
--
ALTER TABLE `invoice`
  MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `oid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;
--
-- AUTO_INCREMENT for table `party`
--
ALTER TABLE `party`
  MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `print_description`
--
ALTER TABLE `print_description`
  MODIFY `pd_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=342;
--
-- AUTO_INCREMENT for table `returninvoice`
--
ALTER TABLE `returninvoice`
  MODIFY `rid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `size`
--
ALTER TABLE `size`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `style`
--
ALTER TABLE `style`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
/*!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 */;