-- --------------------------------------------------------
-- Host:                         192.168.0.22
-- Server version:               5.5.32 - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL Version:             9.3.0.4984
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping database structure for sapdash
CREATE DATABASE IF NOT EXISTS `sapdash` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `sapdash`;


-- Dumping structure for table sapdash.dash
CREATE TABLE IF NOT EXISTS `dash` (
  `dashId` bigint(255) NOT NULL AUTO_INCREMENT,
  `dash_locId` int(11) NOT NULL DEFAULT '0',
  `label` datetime NOT NULL DEFAULT '1900-01-01 00:00:00',
  `OvCount` int(11) NOT NULL DEFAULT '0',
  `InCount` int(11) NOT NULL DEFAULT '0',
  `TrsCount` int(11) NOT NULL DEFAULT '0',
  `y` decimal(15,2) NOT NULL DEFAULT '0.00',
  `Differs` decimal(15,2) DEFAULT '0.00',
  `dash_clasId` int(11) DEFAULT NULL,
  `dash_posInId` int(11) DEFAULT NULL,
  `dash_posOutId` int(11) DEFAULT NULL,
  `dash_isCust` int(11) DEFAULT NULL,
  `dash_complateId` int(11) DEFAULT NULL,
  PRIMARY KEY (`dashId`),
  UNIQUE KEY `ID_UNIQUE` (`dashId`),
  KEY `LocationID` (`dash_locId`),
  KEY `DashDate` (`label`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

-- Dumping data for table sapdash.dash: ~13 rows (approximately)
DELETE FROM `dash`;
/*!40000 ALTER TABLE `dash` DISABLE KEYS */;
INSERT INTO `dash` (`dashId`, `dash_locId`, `label`, `OvCount`, `InCount`, `TrsCount`, `y`, `Differs`, `dash_clasId`, `dash_posInId`, `dash_posOutId`, `dash_isCust`, `dash_complateId`) VALUES
	(2, 579, '2023-02-01 14:13:30', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(3, 579, '2023-02-01 14:14:00', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(4, 579, '2023-02-01 14:14:20', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(5, 579, '2023-02-02 14:17:29', 0, 0, 1, 35000.00, 0.00, 10, 10, 10, 0, 1),
	(6, 234, '2023-02-03 14:18:22', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(7, 579, '2023-02-04 14:20:18', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(8, 579, '2023-02-05 14:22:45', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(9, 579, '2023-02-06 14:23:42', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(10, 579, '2023-03-06 14:24:47', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(11, 579, '2023-04-06 14:25:40', 0, 0, 1, 15000.00, 0.00, 10, 10, 10, 0, 1),
	(12, 579, '2023-02-07 14:39:48', 0, 0, 1, 15000.00, 0.00, 10, 10, 10, 0, 1),
	(13, 579, '2023-02-08 14:42:55', 0, 0, 1, 53000.00, 0.00, 10, 10, 10, 0, 1),
	(14, 579, '2023-02-09 14:57:22', 0, 0, 1, 53000.00, 0.00, 10, 10, 10, 0, 1),
	(15, 579, '2024-01-01 14:13:30', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(16, 579, '2024-02-01 14:13:30', 0, 0, 1, 25000.00, 0.00, 10, 10, 10, 0, 1),
	(17, 579, '2023-01-01 14:13:30', 0, 0, 1, 300000.00, 0.00, 10, 10, 10, 0, 1);
/*!40000 ALTER TABLE `dash` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
