Online Shop Dump User By X-m3n

Online Shop Leak user

http://afsf.homeservice.ph

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 09, 2017 at 04:09 PM
-- Server version: 10.1.16-MariaDB
-- PHP Version: 5.6.24

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

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

--
-- Table structure for table `cancel_order`
--

CREATE TABLE `cancel_order` (
  `cancel_id` int(10) NOT NULL,
  `product_id` int(20) NOT NULL,
  `quantity` int(5) NOT NULL,
  `cancellation_approval` text NOT NULL,
  `reason` text NOT NULL,
  `date_cancelled` text NOT NULL,
  `customer_id` int(10) NOT NULL,
  `order_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cancel_order`
--

INSERT INTO `cancel_order` (`cancel_id`, `product_id`, `quantity`, `cancellation_approval`, `reason`, `date_cancelled`, `customer_id`, `order_id`) VALUES
(1, 35, 1, 'Waiting', '', 'December 21, 2016', 2, 11),
(2, 35, 1, 'Waiting', 'Item price too high', 'December 21, 2016', 7, 12),
(3, 35, 1, 'Cancelled', 'Found cheaper somewhere else', 'December 21, 2016', 7, 13),
(4, 39, 1, 'Cancelled', 'I order the wrong product', 'December 21, 2016', 7, 14),
(5, 35, 1, 'Cancelled', 'I placed a duplicate order', 'December 24, 2016', 9, 38),
(6, 37, 6, 'Cancelled', 'I placed a duplicate order', 'January 25, 2017', 10, 12),
(7, 35, 1, 'Cancelled', 'Shipping cost too high', 'January 25, 2017', 10, 12),
(8, 35, 1, 'Cancelled', 'Item price too high', 'January 25, 2017', 10, 13);

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

--
-- Table structure for table `cashier_transaction`
--

CREATE TABLE `cashier_transaction` (
  `transaction_id` int(20) NOT NULL,
  `customer_name` text NOT NULL,
  `home_address` text NOT NULL,
  `employee_id` int(20) NOT NULL,
  `order_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cashier_transaction`
--

INSERT INTO `cashier_transaction` (`transaction_id`, `customer_name`, `home_address`, `employee_id`, `order_id`) VALUES
(1, 'Jerome Solomon Renia', '', 7, 3),
(2, 'Hanamitchi Dagul Sakuragi', '', 6, 15),
(3, 'Hanamitchi Dagul Sakuragi', '', 6, 16),
(4, 'Hanamitchi Dagul Sakuragi', '', 6, 0),
(5, 'Jhon Marvin Toralba Junio', '', 7, 0),
(6, 'Jerome Solomon Renia', '', 7, 0),
(7, 'Jerome Solomon Renia', '', 7, 0),
(8, 'Jerome Solomon Renia', '', 7, 0),
(9, 'Jerome Solomon Renia', '', 7, 43),
(10, 'Jhon Marvin Toralba Junio', '', 7, 44),
(11, 'Riley Rose Raid', '', 7, 45),
(12, 'mikko', '', 6, 73),
(13, 'mikko', '', 6, 1),
(14, 'Rommel Bato', '', 6, 2),
(15, 'Jerome Solomon Renia', '', 6, 4),
(16, 'Syd Bermz', '', 6, 5),
(17, 'mike', '', 7, 6),
(18, 'Jhon Marvin Toralba Junio', '', 7, 7),
(19, 'Jerome', 'Bayambang', 7, 8),
(20, 'vvvvv', 'gdxdgfgn', 6, 9),
(21, 'fcfcfcfc', 'vgftuj', 6, 10),
(22, 'Jhon Marvin Toralba Junio', 'Malasiqui', 6, 11),
(23, 'lORENZO', 'dUBAI', 6, 14),
(24, 'Samule Uy', 'Bayambang', 6, 17),
(25, 'Jovelyn Bedania', 'Balungao', 7, 18),
(26, 'Kimmy Vans Graner', 'Bugallon', 6, 22),
(27, 'Lea Papa Gilledo', 'Bayambang', 6, 24);

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

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

CREATE TABLE `customer` (
  `customer_id` int(10) NOT NULL,
  `first_name` varchar(20) NOT NULL,
  `middle_name` varchar(20) NOT NULL,
  `last_name` varchar(20) NOT NULL,
  `birth_date` date NOT NULL,
  `birth_place` text NOT NULL,
  `address` text NOT NULL,
  `contact_number` int(15) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `email_address` varchar(20) NOT NULL,
  `customer_password` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`customer_id`, `first_name`, `middle_name`, `last_name`, `birth_date`, `birth_place`, `address`, `contact_number`, `gender`, `email_address`, `customer_password`) VALUES
(2, 'Jhon Marvin', 'Toralba', 'Junio', '1995-11-03', 'Malasiqui, Pangasinan', 'Malasiqui, Pangasinan', 9090, 'Male', 'jm@gmail.com', '3da770cc56ed4407b6aaf10ad4e72b4d'),
(3, 'Abegail', 'abs', 'johnson', '1987-06-21', 'Sa tabi lang', 'Sa tabi lang', 9090909, 'Female', 'abegail@gmail.com', '7eb036d95efd0ec315606393479aec4a'),
(5, 'Riley', 'Rose', 'Raid', '1994-03-21', 'jan lang', 'jan lang', 2147483647, 'Female', 'riley@gmail.com', '8018306cada92212a17e03b4d04f8653'),
(6, 'Kimmy', 'Vans', 'Graner', '1993-08-27', 'Bayambang, Pangasinan', 'bayambang', 2147483647, 'Female', 'kimmy', '9643a919f70460c26cac34b868c94601'),
(7, 'Hanamitchi', 'Dagul', 'Sakuragi', '1993-07-19', 'Japan', 'Tokyo, Japan', 9999, 'Male', 'hanamitchi@gmail.com', '48c909e2a300d8e02678a0de486538bd'),
(8, 'Josh', 'Mars', 'Brandy', '1999-08-26', 'Malabon City', 'bayambang', 999, 'Male', 'josh@gmail.com', 'abb1a9336cff9a7f91fba55a69570d1d'),
(9, 'Gladys', 'Reyes', 'Bermudez', '2002-05-21', 'Tarlac', 'Tarlac', 909090, 'Female', 'syd@gmail.com', '05fe03b494c0f1a7d6cb49f0bf3fd70d'),
(10, 'jayson', 'jayson', 'jayson', '1995-11-18', 'sddsfhsdkh', 'osmsmas', 2147483647, 'Male', 'jayson_delosantos18@', '827ccb0eea8a706c4c34a16891f84e7b'),
(11, 'jayson', 'Tisoy', 'DeloSantos', '2017-01-02', 'm', 'Buayaen', 2147483647, 'Male', 'jayson_delosantos18@', '827ccb0eea8a706c4c34a16891f84e7b'),
(12, 'JOVELYN', 'B', 'BEDENIA', '1997-03-05', 'BALUNGAO', 'bALUNGAO', 2147483647, 'Female', 'jp@yahoo.com', '827ccb0eea8a706c4c34a16891f84e7b'),
(13, 'Lea', 'Papa', 'Gilledo', '1998-04-27', 'Bugallon', 'Bugallon', 2147483647, 'Female', 'gilledolea@gmail.com', 'e10adc3949ba59abbe56e057f20f883e');

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `employee_id` int(10) NOT NULL,
  `emp_first_name` varchar(20) NOT NULL,
  `emp_middle_name` varchar(20) NOT NULL,
  `emp_last_name` varchar(20) NOT NULL,
  `birth_date` date NOT NULL,
  `birth_place` varchar(20) NOT NULL,
  `job_title` varchar(10) NOT NULL,
  `marital_status` varchar(10) NOT NULL,
  `address` text NOT NULL,
  `email_address` varchar(20) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `employee_type` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`employee_id`, `emp_first_name`, `emp_middle_name`, `emp_last_name`, `birth_date`, `birth_place`, `job_title`, `marital_status`, `address`, `email_address`, `gender`, `username`, `password`, `employee_type`) VALUES
(6, 'admin', 'admin', 'admin', '1987-12-10', 'Bayambang, Pangasina', 'Administra', 'Single', 'Bayambang, Pangasinan', 'admin@gmail.com', 'Male', 'Admin', '827ccb0eea8a706c4c34a16891f84e7b', 'Admin'),
(7, 'Jerome', 'Solomon', 'Renia', '1995-09-13', 'Bayambang, Pangasina', 'Programmer', 'Single', 'Bayambang, Pangasinan', 'jerome@gmail.com', 'Male', 'jerome', '827ccb0eea8a706c4c34a16891f84e7b', 'Admin');

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

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

CREATE TABLE `invoice` (
  `invoice_id` int(11) NOT NULL,
  `csi_number` varchar(20) NOT NULL,
  `invoice_date` date NOT NULL,
  `order_details_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `invoice` (`invoice_id`, `csi_number`, `invoice_date`, `order_details_id`) VALUES
(2, '09292', '2017-01-22', 3),
(3, '74747', '2017-01-22', 3),
(4, '77777777', '2017-01-22', 3),
(5, '6666666666666666', '2017-01-22', 3),
(6, '88888888888', '2017-01-22', 3),
(7, '99999999999999999999', '2017-01-22', 3),
(8, '66677', '2017-01-22', 3),
(9, '1000', '2017-01-22', 3),
(10, '12300000', '2017-01-23', 6),
(11, '123400000', '2017-01-23', 7),
(12, '123400000', '2017-01-23', 8),
(13, '2900000', '2017-01-23', 9),
(14, '2900000', '2017-01-23', 10),
(16, '5570009', '2017-01-23', 12),
(17, '41421', '2017-01-24', 3),
(18, '41421', '2017-01-24', 3),
(19, '41421', '2017-01-24', 3),
(20, '41234', '2017-01-24', 3),
(21, '32123', '2017-01-24', 13),
(22, '32123', '2017-01-24', 14),
(23, '41421', '2017-01-25', 19),
(24, '41421', '2017-01-25', 19),
(25, '45466', '2017-01-25', 19),
(26, '31211', '2017-01-25', 20),
(27, '32123', '2017-01-27', 21),
(28, '42451', '2017-01-27', 24),
(29, '32123', '2017-01-29', 25),
(30, '32123', '2017-01-29', 26),
(31, '42150', '2017-01-29', 27),
(32, '125400-001', '2017-05-08', 29),
(33, '001-230', '2017-05-08', 30),
(34, '001-2012', '2017-05-09', 32),
(35, '100123', '2017-05-09', 33);

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

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

CREATE TABLE `orders` (
  `order_id` int(20) NOT NULL,
  `date_ordered` date NOT NULL,
  `payment` text NOT NULL,
  `total` float NOT NULL,
  `customer_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `orders` (`order_id`, `date_ordered`, `payment`, `total`, `customer_id`) VALUES
(1, '2017-01-16', 'At Shop', 200, 0),
(2, '2017-01-21', 'At Shop', 3000, 0),
(3, '2017-01-21', 'Cash On Delivery', 9000, 2),
(4, '2017-01-22', 'At Shop', 3000, 1),
(5, '2017-01-22', 'At Shop', 3000, 0),
(6, '2017-01-23', 'At Shop', 3000, 0),
(7, '2017-01-23', 'At Shop', 3200, 0),
(8, '2017-01-23', 'At Shop', 3200, 0),
(9, '2017-01-23', 'At Shop', 3000, 0),
(10, '2017-01-23', 'At Shop', 3000, 0),
(11, '2017-01-24', 'At Shop', 3200, 2),
(12, '2017-01-25', 'Picked Up', 4400, 10),
(13, '2017-01-25', 'Cash On Delivery', 3200, 10),
(14, '2017-01-25', 'At Shop', 3000, 0),
(15, '2017-01-27', 'Cash On Delivery', 3000, 11),
(16, '2017-01-27', 'Picked Up', 200, 11),
(17, '2017-01-27', 'At Shop', 10000000, 0),
(18, '2017-01-29', 'At Shop', 24750, 0),
(19, '2017-01-29', 'Cash On Delivery', 32000, 12),
(20, '2017-01-29', 'Cash On Delivery', 3950, 12),
(21, '2017-05-08', 'Cash On Delivery', 3000, 13),
(22, '2017-05-08', 'At Shop', 1500, 6),
(23, '2017-05-08', 'Cash On Delivery', 22000, 13),
(24, '2017-05-09', 'At Shop', 1500, 13);

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

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `order_details_id` int(10) NOT NULL,
  `quantity` int(10) NOT NULL,
  `unit_price` int(10) NOT NULL,
  `status` varchar(20) NOT NULL,
  `delivery_date` date NOT NULL,
  `order_id` int(10) NOT NULL,
  `product_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_details`
--

INSERT INTO `order_details` (`order_details_id`, `quantity`, `unit_price`, `status`, `delivery_date`, `order_id`, `product_id`) VALUES
(1, 1, 200, 'Buy at Shop', '0000-00-00', 1, 39),
(10, 1, 200, 'Buy at Shop', '0000-00-00', 8, 39),
(17, 1, 200, 'Picked Up', '2017-01-25', 12, 40),
(19, 1, 200, 'Delivered', '2017-01-27', 13, 39),
(20, 1, 3000, 'Buy at Shop', '0000-00-00', 14, 35),
(21, 1, 3000, 'Delivered', '2017-01-27', 15, 35),
(22, 1, 3000, 'Picked Up', '2017-01-27', 16, 35),
(23, 1, 200, 'processing', '0000-00-00', 16, 39),
(24, 1, 10000000, 'Buy at Shop', '0000-00-00', 17, 42),
(25, 1, 3250, 'Buy at Shop', '0000-00-00', 18, 43),
(26, 1, 21500, 'Buy at Shop', '0000-00-00', 18, 143),
(27, 1, 32000, 'Delivered', '2017-01-29', 19, 144),
(28, 1, 3950, 'processing', '0000-00-00', 20, 47),
(29, 1, 3000, 'Delivered', '2017-05-08', 21, 188),
(30, 1, 1500, 'Buy at Shop', '0000-00-00', 22, 187),
(31, 1, 12000, 'processing', '0000-00-00', 23, 191),
(32, 1, 10000, 'Shipped', '0000-00-00', 23, 190),
(33, 1, 1500, 'Buy at Shop', '0000-00-00', 24, 187);

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

--
-- Table structure for table `pisonet`
--

CREATE TABLE `pisonet` (
  `pisonet_id` int(20) NOT NULL,
  `pisonet_image` text NOT NULL,
  `specification` text NOT NULL,
  `price` text NOT NULL,
  `pisonet_quantity` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pisonet`
--

INSERT INTO `pisonet` (`pisonet_id`, `pisonet_image`, `specification`, `price`, `pisonet_quantity`) VALUES
(6, 'FB_IMG_1491645619652.jpg', '3 chair<br>1 table\n', '1200', 1);

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

--
-- Table structure for table `pisonet_stock`
--

CREATE TABLE `pisonet_stock` (
  `pisonet_stock_id` int(20) NOT NULL,
  `stock_quantity` int(10) NOT NULL,
  `date` text NOT NULL,
  `pisonet_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pisonet_stock`
--

INSERT INTO `pisonet_stock` (`pisonet_stock_id`, `stock_quantity`, `date`, `pisonet_id`) VALUES
(1, 40, 'December 20, 2016', 1);

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

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

CREATE TABLE `product` (
  `product_id` int(10) NOT NULL,
  `product_name` varchar(20) NOT NULL,
  `product_price` float NOT NULL,
  `product_quantity` int(10) NOT NULL,
  `product_description` text NOT NULL,
  `product_image` text NOT NULL,
  `category_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `product` (`product_id`, `product_name`, `product_price`, `product_quantity`, `product_description`, `product_image`, `category_id`) VALUES
(187, 'Dining Table', 1500, 2, 'Dining Tables', 'FB_IMG_1491645655021.jpg', 45),
(188, 'Sala Set 2', 3000, 0, 'set two', 'FB_IMG_1492819157196.jpg', 46),
(189, 'Penchair', 5000, 2, 'Pentchair', 'FB_IMG_1491645625703.jpg', 44),
(190, 'Table Set', 10000, 3, 'Tables Set', 'FB_IMG_1491645635020.jpg', 46),
(191, 'Cabinet Set', 12000, 3, 'Cabinet Set', 'FB_IMG_1492730775092.jpg', 46),
(192, 'Aparador Set', 15000, 3, 'Aparador Set', 'FB_IMG_1492730781234.jpg', 46),
(194, 'Tables Set Glass', 12000, 2, 'Four Chair and one table', '2b20e5f2a5379606b071da452ada07ec.jpg', 45),
(195, 'Table Set 3', 2000, 4, 'Table with glass', '10b9da5f0ce46fdfb493f2070b1d3b6d.jpg', 45),
(196, 'Sofa', 13000, 3, 'Soft and refreshing Blah Balah', '053c49f8603b1fddc2bc265cf6d50c0c.jpg', 45),
(197, 'Awesome Table', 4000, 4, 'Bili kana ang ganda ee', 'images (5).jpg', 45),
(198, 'Glass table', 1000000, 1, 'Naks ang design sulit ang bayad haha<br>', 'images (2).jpg', 45);

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

--
-- Table structure for table `product_category`
--

CREATE TABLE `product_category` (
  `product_category_id` int(10) NOT NULL,
  `product_category_name` text NOT NULL,
  `product_category_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_category`
--

INSERT INTO `product_category` (`product_category_id`, `product_category_name`, `product_category_description`) VALUES
(44, 'Chair', 'Chair'),
(45, 'Tables', 'Tables'),
(46, 'Furniture set', 'set');

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

--
-- Table structure for table `product_stock`
--

CREATE TABLE `product_stock` (
  `product_stock_id` int(20) NOT NULL,
  `quantity_stock` int(10) NOT NULL,
  `last_stock` int(10) NOT NULL,
  `date` date NOT NULL,
  `product_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_stock`
--

INSERT INTO `product_stock` (`product_stock_id`, `quantity_stock`, `last_stock`, `date`, `product_id`) VALUES
(13, 70, 386, '2016-12-30', 41),
(14, 20, 124, '2016-12-30', 35),
(15, 90, 159, '2016-12-30', 37),
(16, 60, 144, '2016-12-31', 35),
(17, 90, 0, '2017-01-04', 35),
(18, 8, 141, '2017-01-04', 37),
(19, 4, 456, '2017-01-04', 41),
(20, 7, 83, '2017-01-04', 39),
(21, 1, 299, '2017-01-04', 40),
(22, 1, 149, '2017-01-04', 37),
(23, 20, 6, '2017-01-29', 151);

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

--
-- Table structure for table `rent`
--

CREATE TABLE `rent` (
  `rent_id` int(20) NOT NULL,
  `units` int(5) NOT NULL,
  `pisonet_id` int(20) NOT NULL,
  `request_date` text NOT NULL,
  `status` text NOT NULL,
  `customer_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rent`
--

INSERT INTO `rent` (`rent_id`, `units`, `pisonet_id`, `request_date`, `status`, `customer_id`) VALUES
(1, 50, 1, 'December 20, 2016', 'Cancelled', 2),
(2, 2, 1, 'December 21, 2016', 'Cancelled', 1),
(3, 1, 3, 'December 21, 2016', 'Pulled Out', 1),
(4, 2, 3, 'December 21, 2016', 'Pulled Out', 1),
(5, 1, 3, 'December 21, 2016', 'Pulled Out', 1),
(6, 10, 5, 'December 21, 2016', 'Pulled Out', 2),
(7, 90, 1, 'December 24, 2016', 'Pulled Out', 9),
(8, 8, 1, 'December 24, 2016', 'Cancelled', 9),
(9, 2, 1, 'January 25, 2017', 'Pulled Out', 10),
(10, 2, 2, 'January 25, 2017', 'Pulled Out', 10),
(11, 1, 6, 'May 9, 2017', 'Cancelled', 13);

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

--
-- Table structure for table `requisition`
--

CREATE TABLE `requisition` (
  `requisition_id` int(11) NOT NULL,
  `name` text NOT NULL,
  `company` text NOT NULL,
  `contact_number` int(15) NOT NULL,
  `email` text NOT NULL,
  `home_address` text NOT NULL,
  `request` text NOT NULL,
  `status` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `requisition_details`
--

CREATE TABLE `requisition_details` (
  `requisition_details_id` int(11) NOT NULL,
  `req_quantity` int(11) NOT NULL,
  `req_unit_price` int(11) NOT NULL,
  `req_total` date NOT NULL,
  `product_id` int(11) NOT NULL,
  `requisition_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `return_order`
--

CREATE TABLE `return_order` (
  `return_id` int(20) NOT NULL,
  `quantity` int(5) NOT NULL,
  `reason` text NOT NULL,
  `reimbursement` text NOT NULL,
  `return_date` text NOT NULL,
  `product_id` int(20) NOT NULL,
  `customer_id` int(20) NOT NULL,
  `order_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `return_order`
--

INSERT INTO `return_order` (`return_id`, `quantity`, `reason`, `reimbursement`, `return_date`, `product_id`, `customer_id`, `order_id`) VALUES
(1, 1, 'Damage Packaging', '200', 'December 21, 2016', 0, 1, 17),
(2, 1, 'Missing Parts', '200', 'December 21, 2016', 39, 1, 17),
(3, 1, 'Unhappy with the item quality', 'Credit store', 'December 21, 2016', 39, 1, 17),
(4, 1, 'Missing Parts', 'Replace by another product', 'December 22, 2016', 39, 2, 27),
(5, 1, 'Missing Parts', 'Replace by another product', 'December 23, 2016', 35, 9, 36),
(6, 1, 'Missing Parts', 'Replace by another product', 'December 24, 2016', 35, 9, 36),
(7, 1, 'Missing Parts', 'Replace by another product', 'December 24, 2016', 35, 9, 36),
(8, 100, 'Wrong Item', 'Credit store', 'January 3, 2017', 37, 1, 40),
(9, 1, 'Defective item', 'Credit store', 'January 27, 2017', 35, 11, 15),
(10, 1, 'Unhappy with the item quality', 'Replace by another product', 'May 9, 2017', 188, 13, 21);

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

--
-- Table structure for table `sale_discont`
--

CREATE TABLE `sale_discont` (
  `sale_id` int(10) NOT NULL,
  `sale_price` float NOT NULL,
  `description` varchar(50) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `product_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `service_id` int(10) NOT NULL,
  `service_name` text NOT NULL,
  `service_description` text NOT NULL,
  `service_price` int(10) NOT NULL,
  `service_image` text NOT NULL,
  `service_category_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `service_category`
--

CREATE TABLE `service_category` (
  `service_category_id` int(10) NOT NULL,
  `service_category_name` varchar(50) NOT NULL,
  `service_category_description` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `voucher`
--

CREATE TABLE `voucher` (
  `voucher_id` int(20) NOT NULL,
  `date_issued` text NOT NULL,
  `amount` float NOT NULL,
  `customer_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voucher`
--

INSERT INTO `voucher` (`voucher_id`, `date_issued`, `amount`, `customer_id`) VALUES
(1, 'December 21, 2016', 200, 1),
(2, 'January 3, 2017', 0, 1),
(3, 'January 27, 2017', 0, 11);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cancel_order`
--
ALTER TABLE `cancel_order`
  ADD PRIMARY KEY (`cancel_id`);

--
-- Indexes for table `cashier_transaction`
--
ALTER TABLE `cashier_transaction`
  ADD PRIMARY KEY (`transaction_id`);

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

--
-- Indexes for table `employee`
--
ALTER TABLE `employee`
  ADD PRIMARY KEY (`employee_id`);

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

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

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
  ADD PRIMARY KEY (`order_details_id`);

--
-- Indexes for table `pisonet`
--
ALTER TABLE `pisonet`
  ADD PRIMARY KEY (`pisonet_id`);

--
-- Indexes for table `pisonet_stock`
--
ALTER TABLE `pisonet_stock`
  ADD PRIMARY KEY (`pisonet_stock_id`);

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

--
-- Indexes for table `product_category`
--
ALTER TABLE `product_category`
  ADD PRIMARY KEY (`product_category_id`);

--
-- Indexes for table `product_stock`
--
ALTER TABLE `product_stock`
  ADD PRIMARY KEY (`product_stock_id`);

--
-- Indexes for table `rent`
--
ALTER TABLE `rent`
  ADD PRIMARY KEY (`rent_id`);

--
-- Indexes for table `requisition`
--
ALTER TABLE `requisition`
  ADD PRIMARY KEY (`requisition_id`);

--
-- Indexes for table `requisition_details`
--
ALTER TABLE `requisition_details`
  ADD PRIMARY KEY (`requisition_details_id`);

--
-- Indexes for table `return_order`
--
ALTER TABLE `return_order`
  ADD PRIMARY KEY (`return_id`);

--
-- Indexes for table `sale_discont`
--
ALTER TABLE `sale_discont`
  ADD PRIMARY KEY (`sale_id`);

--
-- Indexes for table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`service_id`);

--
-- Indexes for table `service_category`
--
ALTER TABLE `service_category`
  ADD PRIMARY KEY (`service_category_id`);

--
-- Indexes for table `voucher`
--
ALTER TABLE `voucher`
  ADD PRIMARY KEY (`voucher_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cancel_order`
--
ALTER TABLE `cancel_order`
  MODIFY `cancel_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `cashier_transaction`
--
ALTER TABLE `cashier_transaction`
  MODIFY `transaction_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `customer`
--
ALTER TABLE `customer`
  MODIFY `customer_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `employee`
--
ALTER TABLE `employee`
  MODIFY `employee_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `invoice`
--
ALTER TABLE `invoice`
  MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `order_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `order_details_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT for table `pisonet`
--
ALTER TABLE `pisonet`
  MODIFY `pisonet_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `pisonet_stock`
--
ALTER TABLE `pisonet_stock`
  MODIFY `pisonet_stock_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `product_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=199;
--
-- AUTO_INCREMENT for table `product_category`
--
ALTER TABLE `product_category`
  MODIFY `product_category_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT for table `product_stock`
--
ALTER TABLE `product_stock`
  MODIFY `product_stock_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `rent`
--
ALTER TABLE `rent`
  MODIFY `rent_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `requisition`
--
ALTER TABLE `requisition`
  MODIFY `requisition_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `requisition_details`
--
ALTER TABLE `requisition_details`
  MODIFY `requisition_details_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `return_order`
--
ALTER TABLE `return_order`
  MODIFY `return_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `sale_discont`
--
ALTER TABLE `sale_discont`
  MODIFY `sale_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `service_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `service_category`
--
ALTER TABLE `service_category`
  MODIFY `service_category_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `voucher`
--
ALTER TABLE `voucher`
  MODIFY `voucher_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
/*!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 */;