-- phpMyAdmin SQL Dump
-- version 4.5.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 13, 2017 at 04:08 PM
-- Server version: 5.7.18-0ubuntu0.16.04.1
-- PHP Version: 7.0.18-0ubuntu0.16.04.1

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

--
-- Dumping data for table `barcode`
--

INSERT INTO `barcode` (`id`, `product_id`, `code`) VALUES
(1, 1, '1234');

--
-- Dumping data for table `packlist`
--

INSERT INTO `packlist` (`id`, `warehouse_id`, `status`, `created_at`) VALUES
(1, 1, 'created', '2012-01-01 00:00:00');

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

INSERT INTO `product` (`id`, `code`, `title`, `brand`, `image`) VALUES
(1, 'Chanel', 'Chanel No 5', 'Chanel', 'http://via.placeholder.com/350x150'),
(2, 'coco-madmoiselle', 'Coco Madmoiselle', 'Chanel', 'http://via.placeholder.com/350x150');

--
-- Dumping data for table `quantity`
--

INSERT INTO `quantity` (`id`, `product_id`, `transfer_id`, `received_quantity`, `scanned_quantity`) VALUES
(1, 2, 1, 10, 0),
(2, 1, 1, 5, 0);

--
-- Dumping data for table `transfer`
--

INSERT INTO `transfer` (`id`, `incoming_warehouse_id`, `outgoing_warehouse_id`, `code`, `status`, `packlist_id`) VALUES
(1, 1, 2, 'TR72', 'created', 1),
(9, NULL, NULL, 'TR74', 'created', 1);

--
-- Dumping data for table `transfer_product`
--

INSERT INTO `transfer_product` (`id`, `transfer_id`, `received_quantity`, `scanned_quantity`, `product_id`) VALUES
(1, 1, 10, 0, 1),
(2, 1, 5, 0, 2);

--
-- Dumping data for table `transfer_products`
--

INSERT INTO `transfer_products` (`transfer_id`, `product_id`) VALUES
(1, 1);

--
-- Dumping data for table `warehouse`
--

INSERT INTO `warehouse` (`id`, `name`, `code`, `active`) VALUES
(1, 'CrewShop', '107', 1),
(2, 'CrewShop website', '601', 1);

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