-- phpMyAdmin SQL Dump
-- version 4.7.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 10, 2018 at 09:56 AM
-- Server version: 5.7.19-log
-- PHP Version: 7.2.1

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `sklad`
--

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

--
-- Table structure for table `doc_rows`
--

CREATE TABLE `doc_rows` (
  `id` int(10) UNSIGNED NOT NULL,
  `status` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` int(10) UNSIGNED NOT NULL,
  `document_id` int(10) UNSIGNED NOT NULL,
  `product_id` int(10) UNSIGNED NOT NULL,
  `storage_id` int(10) UNSIGNED NOT NULL,
  `place_id` int(10) UNSIGNED DEFAULT NULL,
  `pallet` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `old_qty` int(10) DEFAULT '0',
  `quantity` int(10) NOT NULL DEFAULT '0',
  `measure` tinyint(1) NOT NULL DEFAULT '1',
  `batch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiring_date` date DEFAULT NULL,
  `price` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `discount` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `value` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doc_rows`
--

INSERT INTO `doc_rows` (`id`, `status`, `parent_id`, `user_id`, `document_id`, `product_id`, `storage_id`, `place_id`, `pallet`, `old_qty`, `quantity`, `measure`, `batch`, `expiring_date`, `price`, `discount`, `value`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 0, 1, 1, 300005, 1, 0, '0', 0, 48, 1, NULL, NULL, '0.00000', '0.00000', '0.00000', '2018-03-28 03:48:18', '2018-03-28 03:48:18', NULL),
(2, 1, 0, 1, 1, 300006, 1, 0, '0', 0, 1152, 1, NULL, NULL, '0.00000', '0.00000', '0.00000', '2018-03-28 03:48:18', '2018-03-28 03:48:18', NULL),
(3, 1, 0, 1, 1, 20005, 1, 1, '4-39', 0, 48, 0, 'lll56', '2018-10-31', '0.00000', '0.00000', '0.00000', '2018-03-28 03:48:18', '2018-03-28 03:48:18', NULL),
(4, 1, 0, 1, 1, 300540, 1, 0, '0', 0, 6, 1, NULL, NULL, '0.00000', '0.00000', '0.00000', '2018-03-28 03:48:18', '2018-03-28 03:48:18', NULL),
(5, 1, 0, 1, 1, 13035, 1, 1, '4-40', 0, 6, 1, 'ki58', '2018-09-28', '0.00000', '0.00000', '0.00000', '2018-03-28 03:48:18', '2018-03-28 03:48:18', NULL),
(6, 2, 0, 1, 1, 300005, 1, 0, '0', 0, 48, 1, NULL, NULL, '0.00000', '0.00000', '0.00000', '2018-03-28 03:48:19', '2018-03-28 03:48:19', NULL),
(7, 2, 0, 1, 1, 300006, 1, 0, '0', 0, 1152, 1, NULL, NULL, '0.00000', '0.00000', '0.00000', '2018-03-28 03:48:19', '2018-03-28 03:48:19', NULL),
(8, 2, 0, 1, 1, 20005, 1, 1, '4-41', 0, 48, 0, 'kjhtr8597', '2018-05-03', '0.00000', '0.00000', '0.00000', '2018-03-28 03:48:19', '2018-03-28 03:48:19', NULL),
(9, 0, 0, 1, 2, 20005, 1, NULL, NULL, 0, 2304, 1, NULL, NULL, '0.60300', '0.00000', '1389.31200', '2018-03-28 03:51:45', '2018-03-28 03:51:45', NULL),
(10, 0, 0, 1, 2, 13035, 1, NULL, NULL, 0, 6, 1, NULL, NULL, '37.00000', '0.00000', '222.00000', '2018-03-28 03:51:46', '2018-03-28 03:51:46', NULL),
(11, 0, 0, 1, 3, 300005, 1, NULL, NULL, 0, 96, 1, NULL, NULL, '3.00000', '0.00000', '288.00000', '2018-03-28 03:52:58', '2018-03-28 03:52:58', NULL),
(12, 0, 0, 1, 3, 300006, 1, NULL, NULL, 0, 2304, 1, NULL, NULL, '0.20000', '0.00000', '460.80000', '2018-03-28 03:52:58', '2018-03-28 03:52:58', NULL),
(13, 0, 0, 1, 3, 300540, 1, NULL, NULL, 0, 6, 1, NULL, NULL, '80.00000', '0.00000', '480.00000', '2018-03-28 03:52:58', '2018-03-28 03:52:58', NULL),
(14, 0, 0, 1, 4, 53330, 1, NULL, NULL, 0, 1000, 1, NULL, NULL, '15.03000', '0.00000', '15030.00000', '2018-03-28 03:58:01', '2018-03-28 03:58:01', NULL),
(15, 0, 0, 1, 5, 53330, 1, NULL, NULL, 0, 1100, 1, NULL, NULL, '16.49000', '0.00000', '18139.00000', '2018-03-28 04:02:24', '2018-03-28 04:02:24', NULL),
(16, 1, 0, 1, 6, 13035, 1, 0, '0', 0, 1, 1, 'ki58', '2018-09-28', '41.00000', '0.00000', '41.00000', '2018-03-28 04:17:08', '2018-03-28 04:17:08', NULL),
(17, 1, 0, 1, 6, 20005, 1, 0, '0', 0, 1, 0, 'kjhtr8597', '2018-05-03', '15.84000', '0.00000', '15.84000', '2018-03-28 04:17:09', '2018-03-28 04:17:09', NULL),
(18, 1, 0, 1, 6, 300540, 1, 0, '0', 0, 1, 1, NULL, NULL, '80.00000', '0.00000', '80.00000', '2018-03-28 04:17:09', '2018-03-28 04:17:09', NULL),
(19, 1, 0, 1, 6, 300006, 1, 0, '0', 0, 24, 1, NULL, NULL, '0.20000', '0.00000', '4.80000', '2018-03-28 04:17:09', '2018-03-28 04:17:09', NULL),
(20, 1, 0, 1, 6, 300005, 1, 0, '0', 0, 1, 1, NULL, NULL, '3.00000', '0.00000', '3.00000', '2018-03-28 04:17:09', '2018-03-28 04:17:09', NULL),
(21, 1, 0, 1, 7, 13035, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '41.00000', '0.00000', '41.00000', '2018-03-28 04:25:13', '2018-03-28 04:25:13', NULL),
(22, 1, 0, 1, 7, 20005, 1, NULL, NULL, 0, 24, 1, NULL, NULL, '15.84000', '0.00000', '380.16000', '2018-03-28 04:25:13', '2018-03-28 04:25:13', NULL),
(23, 1, 0, 1, 7, 300540, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '80.00000', '0.00000', '80.00000', '2018-03-28 04:25:13', '2018-03-28 04:25:13', NULL),
(24, 1, 0, 1, 7, 300006, 1, NULL, NULL, 0, 24, 1, NULL, NULL, '0.20000', '0.00000', '4.80000', '2018-03-28 04:25:13', '2018-03-28 04:25:13', NULL),
(25, 1, 0, 1, 7, 300005, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '3.00000', '0.00000', '3.00000', '2018-03-28 04:25:13', '2018-03-28 04:25:13', NULL),
(26, 0, 0, 14733, 9, 13035, 1, 32, '4-40', 5, 50, 1, 'ki58', '2018-09-28', '0.00000', '0.00000', '0.00000', '2018-05-05 07:24:58', '2018-05-05 07:24:58', NULL),
(27, 0, 0, 1, 10, 460496, 1, 0, '0', 0, 10, 1, NULL, NULL, '3.00000', '0.00000', '30.00000', '2018-05-08 03:21:55', '2018-05-08 03:21:55', NULL),
(28, 1, 0, 1, 12, 300540, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '80.00000', '0.00000', '80.00000', '2018-05-08 06:02:09', '2018-05-08 06:02:09', NULL),
(29, 0, 0, 1, 12, 300006, 1, NULL, NULL, 24, 24, 1, NULL, NULL, '0.20000', '0.00000', '4.80000', '2018-05-08 06:02:09', '2018-05-08 06:04:29', NULL),
(30, 1, 0, 1, 12, 300005, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '3.00000', '0.00000', '3.00000', '2018-05-08 06:02:09', '2018-05-08 06:02:09', NULL),
(31, 1, 0, 1, 13, 300550, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '80.00000', '0.00000', '80.00000', '2018-05-08 06:04:29', '2018-05-08 06:04:29', NULL),
(32, 0, 0, 1, 14, 300006, 1, NULL, NULL, 24, 24, 1, NULL, NULL, '0.20000', '0.00000', '4.80000', '2018-05-08 06:04:29', '2018-05-08 06:04:29', NULL),
(33, 1, 0, 1, 15, 20005, 1, NULL, NULL, 0, 2304, 1, NULL, NULL, '0.60300', '0.00000', '1389.31200', '2018-05-08 06:09:41', '2018-05-08 06:09:41', NULL),
(34, 1, 0, 1, 15, 13035, 1, NULL, NULL, 0, 4, 1, NULL, NULL, '37.50000', '0.00000', '150.00000', '2018-05-08 06:09:41', '2018-05-08 06:09:41', NULL),
(35, 0, 0, 1, 16, 13035, 1, NULL, NULL, 0, 2, 1, NULL, NULL, '37.50000', '0.00000', '75.00000', '2018-05-08 06:10:06', '2018-05-08 06:10:06', NULL),
(36, 1, 0, 1, 17, 300010, 1, NULL, NULL, 0, 100, 1, NULL, NULL, '0.20000', '0.00000', '20.00000', '2018-05-08 06:11:28', '2018-05-08 06:11:28', NULL),
(37, 1, 0, 1, 18, 20005, 1, 0, '0', 0, 1, 0, 'kjhtr8597', '2018-05-03', '15.84000', '0.00000', '15.84000', '2018-05-08 06:18:18', '2018-05-08 06:18:18', NULL),
(38, 1, 0, 1, 18, 300006, 1, 0, '0', 0, 24, 1, NULL, NULL, '0.20000', '0.00000', '4.80000', '2018-05-08 06:18:18', '2018-05-08 06:18:18', NULL),
(39, 1, 0, 1, 18, 300005, 1, 0, '0', 0, 1, 1, NULL, NULL, '3.00000', '0.00000', '3.00000', '2018-05-08 06:18:19', '2018-05-08 06:18:19', NULL),
(40, 1, 0, 1, 19, 20005, 1, NULL, NULL, 0, 24, 1, NULL, NULL, '15.84000', '0.00000', '380.16000', '2018-05-08 06:19:51', '2018-05-08 06:19:51', NULL),
(41, 1, 0, 1, 19, 300006, 1, NULL, NULL, 0, 24, 1, NULL, NULL, '0.20000', '0.00000', '4.80000', '2018-05-08 06:19:51', '2018-05-08 06:19:51', NULL),
(42, 1, 0, 1, 19, 300005, 1, NULL, NULL, 0, 1, 1, NULL, NULL, '3.00000', '0.00000', '3.00000', '2018-05-08 06:19:51', '2018-05-08 06:19:51', NULL),
(43, 0, 0, 1, 20, 20005, 1, NULL, NULL, 0, 1152, 1, NULL, NULL, '15.84000', '0.00000', '760.32000', '2018-05-08 07:39:43', '2018-05-08 07:39:43', NULL),
(44, 0, 0, 1, 20, 300006, 1, NULL, NULL, 0, 1152, 1, NULL, NULL, '0.20000', '0.00000', '230.40000', '2018-05-08 07:39:43', '2018-05-08 07:39:43', NULL),
(45, 0, 0, 1, 20, 300005, 1, NULL, NULL, 0, 48, 1, NULL, NULL, '3.00000', '0.00000', '144.00000', '2018-05-08 07:39:43', '2018-05-08 07:39:43', NULL),
(46, 1, 0, 1, 25, 11005, 1, 1, '4-14589', 0, 50, 0, 'lk 1236', '2018-12-14', '0.00000', '0.00000', '0.00000', '2018-05-08 08:46:52', '2018-05-08 08:46:52', NULL),
(47, 1, 0, 1, 25, 300051, 1, 0, '0', 0, 1000, 1, NULL, NULL, '0.00000', '0.00000', '0.00000', '2018-05-08 08:46:52', '2018-05-08 08:46:52', NULL),
(48, 1, 0, 1, 25, 300050, 1, 0, '0', 0, 50, 1, NULL, NULL, '0.00000', '0.00000', '0.00000', '2018-05-08 08:46:52', '2018-05-08 08:46:52', NULL);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `doc_rows`
--
ALTER TABLE `doc_rows`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
