-- --------------------------------------------------------
-- Server OS:                    Win32
-- HeidiSQL Version:             9.3.0.4984
-- --------------------------------------------------------


-- 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.class
CREATE TABLE IF NOT EXISTS `class` (
  `ID` int(11) NOT NULL,
  `Code` varchar(2) NOT NULL DEFAULT '',
  `Vehicle` varchar(45) NOT NULL DEFAULT '' COMMENT 'Vehicle Name',
  `Status` int(11) NOT NULL DEFAULT '0' COMMENT 'Active of InActive',
  `BaseRate` int(11) NOT NULL DEFAULT '0',
  `ClassLevel` int(11) NOT NULL DEFAULT '0',
  `FlagRate` int(11) NOT NULL DEFAULT '0' COMMENT 'Rate Mothod 0-Casual / Proporsial 1- Time In 2- Time Out ',
  `ManualPrice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Ticket price for manual transaction',
  `LostTicketPrice` decimal(10,2) NOT NULL DEFAULT '0.00',
  `FlagMaxRate` int(11) NOT NULL DEFAULT '0' COMMENT 'Max Rate for Customer  0 - Unlimit 1-With Limit',
  `MaxRRate` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Reguler max Rate',
  `FlagMaxRRate` int(11) NOT NULL DEFAULT '0' COMMENT 'max Rate by 0-24 Hour 1- One shot',
  `MaxHRate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `FlagMaxHRate` int(11) NOT NULL DEFAULT '0',
  `GracePeriodType` int(11) NOT NULL DEFAULT '0',
  `GracePeriod` int(11) NOT NULL DEFAULT '0' COMMENT 'Greace period from Exit to Entry  in 1 Location',
  `GracePeriodHoliday` int(11) NOT NULL DEFAULT '1',
  `RRate0` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RTime0` int(11) NOT NULL DEFAULT '0',
  `RBy0` int(11) NOT NULL DEFAULT '0',
  `RRate1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RTime1` int(11) NOT NULL DEFAULT '0',
  `RBy1` int(11) NOT NULL DEFAULT '0',
  `RRate2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RTime2` int(11) NOT NULL DEFAULT '0',
  `RBy2` int(11) NOT NULL DEFAULT '0',
  `RRate3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RTime3` int(11) NOT NULL DEFAULT '0',
  `RBy3` int(11) NOT NULL DEFAULT '0',
  `RRate4` decimal(10,2) NOT NULL DEFAULT '0.00',
  `RTime4` int(11) NOT NULL DEFAULT '0',
  `RBy4` int(11) NOT NULL DEFAULT '0',
  `HRate0` decimal(10,2) NOT NULL DEFAULT '0.00',
  `HTime0` int(11) NOT NULL DEFAULT '0',
  `HBy0` int(11) NOT NULL DEFAULT '0',
  `HRate1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `HTime1` int(11) NOT NULL DEFAULT '0',
  `HBy1` int(11) NOT NULL DEFAULT '0',
  `HRate2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `HTime2` int(11) NOT NULL DEFAULT '0',
  `HBy2` int(11) NOT NULL DEFAULT '0',
  `HRate3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `HTime3` int(11) NOT NULL DEFAULT '0',
  `HBy3` int(11) NOT NULL DEFAULT '0',
  `HRate4` decimal(10,2) NOT NULL DEFAULT '0.00',
  `HTime4` int(11) NOT NULL DEFAULT '0',
  `HBy4` int(11) NOT NULL DEFAULT '0',
  `LRRate0` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LRTime0` int(11) NOT NULL DEFAULT '0',
  `LRBy0` int(11) NOT NULL DEFAULT '0',
  `LRRate1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LRTime1` int(11) NOT NULL DEFAULT '0',
  `LRBy1` int(11) NOT NULL DEFAULT '0',
  `LRRate2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LRTime2` int(11) NOT NULL DEFAULT '0',
  `LRBy2` int(11) NOT NULL DEFAULT '0',
  `LRRate3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LRTime3` int(11) NOT NULL DEFAULT '0',
  `LRBy3` int(11) NOT NULL DEFAULT '0',
  `LRRate4` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LRTime4` int(11) NOT NULL DEFAULT '0',
  `LRBy4` int(11) NOT NULL DEFAULT '0',
  `LHRate0` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LHTime0` int(11) NOT NULL DEFAULT '0',
  `LHBy0` int(11) NOT NULL DEFAULT '0',
  `LHRate1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LHTime1` int(11) NOT NULL DEFAULT '0',
  `LHBy1` int(11) NOT NULL DEFAULT '0',
  `LHRate2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LHTime2` int(11) NOT NULL DEFAULT '0',
  `LHBy2` int(11) NOT NULL DEFAULT '0',
  `LHRate3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LHTime3` int(11) NOT NULL DEFAULT '0',
  `LHBy3` int(11) NOT NULL DEFAULT '0',
  `LHRate4` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LHTime4` int(11) NOT NULL DEFAULT '0',
  `LHBy4` int(11) NOT NULL DEFAULT '0',
  `LGracePeriod` int(11) NOT NULL DEFAULT '0',
  `LGracePeriodIn` int(11) NOT NULL DEFAULT '0',
  `LGracePeriodOut` int(11) NOT NULL DEFAULT '0',
  `LStatus` tinyint(4) NOT NULL DEFAULT '0',
  `LARate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LATime` int(11) NOT NULL DEFAULT '0',
  `LAMultiple` tinyint(4) NOT NULL DEFAULT '0',
  `LCross` decimal(10,2) NOT NULL DEFAULT '0.00',
  `LCrossMultiple` tinyint(4) NOT NULL DEFAULT '0',
  `HSaturday` int(11) NOT NULL DEFAULT '0',
  `HSunday` int(11) NOT NULL DEFAULT '0',
  `OStatus` int(11) NOT NULL DEFAULT '0' COMMENT '0- No Overnight   1- Overnight Allowed',
  `OStartTime` varchar(8) NOT NULL DEFAULT '' COMMENT 'OverNight Start Time',
  `OEndTime` varchar(8) NOT NULL DEFAULT '' COMMENT 'Overnight End Time',
  `ORRate` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Overnight Reguler Rate',
  `OHRate` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Overnight Holiday Rate',
  `OOv` tinyint(4) NOT NULL DEFAULT '0',
  `EStartDate` datetime DEFAULT NULL COMMENT 'Event Start Date',
  `EEndDate` datetime DEFAULT NULL COMMENT 'Event End Time',
  `ERate` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Event Rate',
  `AStatus` int(11) NOT NULL DEFAULT '0',
  `ARate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `ATime` int(11) NOT NULL DEFAULT '6',
  `AMultiple` int(11) NOT NULL DEFAULT '0',
  `AOv` tinyint(4) NOT NULL DEFAULT '0',
  `FStatus` int(11) NOT NULL DEFAULT '0',
  `FStartTime` varchar(8) NOT NULL DEFAULT '',
  `FEndTime` varchar(8) NOT NULL DEFAULT '',
  `FRRate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `FHRate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `Insurance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `ClassTaxID` int(11) NOT NULL DEFAULT '0',
  `ClassIcon` varchar(10) NOT NULL DEFAULT '',
  `BStatus` tinyint(4) NOT NULL DEFAULT '0',
  `BTime` int(11) NOT NULL DEFAULT '0',
  `BRate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `IsOvReguler` tinyint(4) NOT NULL DEFAULT '0',
  `UserID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID_UNIQUE` (`ID`),
  UNIQUE KEY `Code_UNIQUE` (`Code`),
  UNIQUE KEY `Vehicle_UNIQUE` (`Vehicle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table sapdash.class: ~9 rows (approximately)
DELETE FROM `class`;
INSERT INTO `class` (`ID`, `Code`, `Vehicle`, `Status`, `BaseRate`, `ClassLevel`, `FlagRate`, `ManualPrice`, `LostTicketPrice`, `FlagMaxRate`, `MaxRRate`, `FlagMaxRRate`, `MaxHRate`, `FlagMaxHRate`, `GracePeriodType`, `GracePeriod`, `GracePeriodHoliday`, `RRate0`, `RTime0`, `RBy0`, `RRate1`, `RTime1`, `RBy1`, `RRate2`, `RTime2`, `RBy2`, `RRate3`, `RTime3`, `RBy3`, `RRate4`, `RTime4`, `RBy4`, `HRate0`, `HTime0`, `HBy0`, `HRate1`, `HTime1`, `HBy1`, `HRate2`, `HTime2`, `HBy2`, `HRate3`, `HTime3`, `HBy3`, `HRate4`, `HTime4`, `HBy4`, `LRRate0`, `LRTime0`, `LRBy0`, `LRRate1`, `LRTime1`, `LRBy1`, `LRRate2`, `LRTime2`, `LRBy2`, `LRRate3`, `LRTime3`, `LRBy3`, `LRRate4`, `LRTime4`, `LRBy4`, `LHRate0`, `LHTime0`, `LHBy0`, `LHRate1`, `LHTime1`, `LHBy1`, `LHRate2`, `LHTime2`, `LHBy2`, `LHRate3`, `LHTime3`, `LHBy3`, `LHRate4`, `LHTime4`, `LHBy4`, `LGracePeriod`, `LGracePeriodIn`, `LGracePeriodOut`, `LStatus`, `LARate`, `LATime`, `LAMultiple`, `LCross`, `LCrossMultiple`, `HSaturday`, `HSunday`, `OStatus`, `OStartTime`, `OEndTime`, `ORRate`, `OHRate`, `OOv`, `EStartDate`, `EEndDate`, `ERate`, `AStatus`, `ARate`, `ATime`, `AMultiple`, `AOv`, `FStatus`, `FStartTime`, `FEndTime`, `FRRate`, `FHRate`, `Insurance`, `ClassTaxID`, `ClassIcon`, `BStatus`, `BTime`, `BRate`, `IsOvReguler`, `UserID`) VALUES
	(10, 'C', 'MOTOR', 0, 0, 0, 3, 0.00, 25000.00, 0, 0.00, 0, 0.00, 0, 0, 5, 1, 0.00, 0, 5, 2000.00, 5, 55, 2000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 5, 2000.00, 5, 55, 2000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 1000.00, 0, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 2000.00, 0, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 5, 15, 15, 0, 0.00, 0, 0, 0.00, 0, 0, 0, 0, '22:00:00', '04:00:00', 5000.00, 10000.00, 0, NULL, NULL, 0.00, 0, 8000.00, 6, 1, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 5000.00, 1, 'motorcycle', 0, 0, 0.00, 0, 1000),
	(11, 'B', 'MOBIL', 0, 0, 0, 3, 0.00, 50000.00, 0, 0.00, 0, 0.00, 0, 0, 5, 1, 0.00, 0, 5, 4000.00, 5, 55, 4000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 5, 4000.00, 5, 55, 4000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 3000.00, 0, 60, 2000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 3000.00, 0, 60, 2000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 5, 15, 15, 0, 0.00, 0, 0, 0.00, 0, 1, 1, 0, '23:00:00', '05:00:00', 5000.00, 7000.00, 0, NULL, NULL, 0.00, 0, 0.00, 0, 0, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 0.00, 2, 'car', 0, 0, 0.00, 0, 1000),
	(12, 'X', 'BOX /TRUCK', 1, 0, 2, 3, 0.00, 50000.00, 0, 0.00, 0, 0.00, 0, 0, 0, 1, 7000.00, 0, 60, 3000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 7000.00, 0, 60, 3000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 3000.00, 0, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 3000.00, 0, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 5, 15, 15, 0, 0.00, 0, 0, 0.00, 0, 1, 1, 0, '  :  :', '  :  :', 0.00, 0.00, 0, NULL, NULL, 0.00, 0, 0.00, 0, 0, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 0.00, 2, 'truck', 0, 0, 0.00, 0, 1000),
	(13, 'HB', 'HOTEL MOBIL', 0, 2, 6, 3, 0.00, 0.00, 0, 0.00, 0, 0.00, 0, 0, 0, 1, 0.00, 0, 60, 4000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 60, 4000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0.00, 0, 1, 1, 0, '  :  :', '  :  :', 0.00, 0.00, 0, NULL, NULL, 0.00, 0, 0.00, 0, 0, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 0.00, 1, '', 0, 0, 0.00, 0, 1000),
	(14, 'V', 'VOUCHER MOBIL', 0, 1, 0, 3, 0.00, 0.00, 0, 0.00, 0, 0.00, 0, 0, 0, 1, 6000.00, 0, 60, 4000.00, 0, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 6000.00, 0, 60, 4000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0.00, 0, 1, 1, 0, '  :  :', '  :  :', 0.00, 0.00, 0, NULL, NULL, 0.00, 0, 0.00, 0, 0, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 0.00, 1, '', 0, 0, 0.00, 0, 1000),
	(15, 'SV', 'VALET 3S', 1, 0, 0, 3, 0.00, 0.00, 0, 0.00, 0, 0.00, 0, 0, 0, 1, 5000.00, 0, 60, 4000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 5000.00, 0, 60, 4000.00, 60, 60, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0.00, 0, 1, 1, 0, '  :  :', '  :  :', 0.00, 0.00, 0, NULL, NULL, 0.00, 0, 0.00, 0, 0, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 0.00, 1, '', 0, 0, 0.00, 0, 1000),
	(16, 'HM', 'HOTEL MOTOR', 0, 2, 6, 3, 0.00, 0.00, 0, 0.00, 0, 0.00, 0, 0, 0, 1, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0.00, 0, 1, 1, 0, '  :  :', '  :  :', 0.00, 0.00, 0, NULL, NULL, 0.00, 0, 0.00, 0, 0, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 0.00, 1, '', 0, 0, 0.00, 0, 1000),
	(17, 'S', 'VOUCHER MOTOR', 0, 1, 0, 1, 0.00, 0.00, 0, 0.00, 0, 0.00, 0, 0, 0, 1, 3000.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 3000.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0.00, 0, 1, 1, 0, '  :  :', '  :  :', 0.00, 0.00, 0, NULL, NULL, 0.00, 0, 0.00, 0, 0, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 0.00, 1, '', 0, 0, 0.00, 0, 1000),
	(18, 'P', 'VOUCHER PIM', 0, 2, 0, 3, 0.00, 0.00, 0, 0.00, 0, 0.00, 0, 0, 0, 1, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0.00, 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0.00, 0, 1, 1, 0, '  :  :', '  :  :', 0.00, 0.00, 0, NULL, NULL, 0.00, 0, 0.00, 0, 0, 0, 0, '  :  :', '  :  :', 0.00, 0.00, 0.00, 1, '', 0, 0, 0.00, 0, 1151);


-- 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=201904871413 DEFAULT CHARSET=latin1;

-- Dumping data for table sapdash.dash: ~56 rows (approximately)
DELETE FROM `dash`;
INSERT INTO `dash` (`dashId`, `dash_locId`, `label`, `OvCount`, `InCount`, `TrsCount`, `y`, `Differs`, `dash_clasId`, `dash_posInId`, `dash_posOutId`, `dash_isCust`, `dash_complateId`) VALUES
	(201904870818, 578, '2022-02-05 11:34:35', 0, 0, 8, 0.00, 0.00, -1, 31, 0, 0, 1),
	(201904870819, 578, '2022-02-05 11:34:35', 0, 0, 1, 0.00, 0.00, 10, 52, 0, 0, 1),
	(201904870820, 578, '2022-02-05 11:34:35', 0, 0, 2, 70084000.00, 0.00, 10, 52, 52, 0, 1),
	(201904870821, 578, '2022-02-05 11:34:35', 0, 0, 1, 150000.00, 0.00, 11, 52, 52, 1, 1),
	(201904870822, 578, '2022-02-05 11:34:35', 0, 0, 23, 0.00, 0.00, 13, 12, 0, 0, 1),
	(201904870823, 578, '2022-02-05 11:34:35', 0, 0, 4, 2500.00, 0.00, 13, 12, 17, 0, 1),
	(201904870824, 578, '2022-02-05 11:34:35', 0, 0, 10, 900.00, 0.00, 13, 12, 22, 0, 1),
	(201904870825, 578, '2022-02-05 11:34:38', 0, 0, 8, 0.00, 0.00, -1, 31, 0, 0, 1),
	(201904870826, 578, '2022-02-05 11:34:38', 0, 0, 1, 0.00, 0.00, 10, 52, 0, 0, 1),
	(201904870827, 578, '2022-02-05 11:34:38', 0, 0, 2, 70084000.00, 0.00, 10, 52, 52, 0, 1),
	(201904870828, 578, '2022-02-05 11:34:38', 0, 0, 1, 150000.00, 0.00, 11, 52, 52, 1, 1),
	(201904870829, 578, '2022-02-05 11:34:38', 0, 0, 23, 0.00, 0.00, 13, 12, 0, 0, 1),
	(201904870830, 578, '2022-02-05 11:34:38', 0, 0, 4, 2500.00, 0.00, 13, 12, 17, 0, 1),
	(201904870831, 578, '2022-02-05 11:34:38', 0, 0, 10, 900.00, 0.00, 13, 12, 22, 0, 1),
	(201904870832, 578, '2022-02-05 11:48:15', 0, 0, 8, 0.00, 0.00, -1, 31, 0, 0, 1),
	(201904870833, 578, '2022-02-05 11:48:15', 0, 0, 1, 0.00, 0.00, 10, 52, 0, 0, 1),
	(201904870834, 578, '2022-02-05 11:48:15', 0, 0, 2, 70084000.00, 0.00, 10, 52, 52, 0, 1),
	(201904870835, 578, '2022-02-05 11:48:15', 0, 0, 1, 150000.00, 0.00, 11, 52, 52, 1, 1),
	(201904870836, 578, '2022-02-05 11:48:15', 0, 0, 23, 0.00, 0.00, 13, 12, 0, 0, 1),
	(201904870837, 578, '2022-02-05 11:48:15', 0, 0, 4, 2500.00, 0.00, 13, 12, 17, 0, 1),
	(201904870838, 578, '2022-02-05 11:48:15', 0, 0, 10, 900.00, 0.00, 13, 12, 22, 0, 1),
	(201904870839, 578, '2022-02-05 11:48:19', 0, 0, 8, 0.00, 0.00, -1, 31, 0, 0, 1),
	(201904870840, 578, '2022-02-05 11:48:19', 0, 0, 1, 0.00, 0.00, 10, 52, 0, 0, 1),
	(201904870841, 578, '2022-02-05 11:48:19', 0, 0, 2, 70084000.00, 0.00, 10, 52, 52, 0, 1),
	(201904870842, 578, '2022-02-05 11:48:19', 0, 0, 1, 150000.00, 0.00, 11, 52, 52, 1, 1),
	(201904870843, 578, '2022-02-05 11:48:19', 0, 0, 23, 0.00, 0.00, 13, 12, 0, 0, 1),
	(201904870844, 578, '2022-02-05 11:48:19', 0, 0, 4, 2500.00, 0.00, 13, 12, 17, 0, 1),
	(201904870845, 578, '2022-02-05 11:48:19', 0, 0, 10, 900.00, 0.00, 13, 12, 22, 0, 1),
	(201904870846, 578, '2022-03-05 11:48:23', 0, 0, 8, 0.00, 0.00, -1, 31, 0, 0, 1),
	(201904870847, 578, '2022-03-05 11:48:23', 0, 0, 1, 0.00, 0.00, 10, 52, 0, 0, 1),
	(201904870848, 578, '2022-03-05 11:48:23', 0, 0, 2, 70084000.00, 0.00, 10, 52, 52, 0, 1),
	(201904870849, 578, '2022-03-05 11:48:23', 0, 0, 1, 150000.00, 0.00, 11, 52, 52, 1, 1),
	(201904870850, 578, '2022-03-05 11:48:23', 0, 0, 23, 0.00, 0.00, 13, 12, 0, 0, 1),
	(201904870851, 578, '2022-03-05 11:48:23', 0, 0, 4, 2500.00, 0.00, 13, 12, 17, 0, 1),
	(201904870852, 578, '2022-03-05 11:48:23', 0, 0, 10, 900.00, 0.00, 13, 12, 22, 0, 1),
	(201904870853, 578, '2022-03-05 11:48:28', 0, 0, 8, 0.00, 0.00, -1, 31, 0, 0, 1),
	(201904870854, 578, '2022-03-05 11:48:28', 0, 0, 1, 0.00, 0.00, 10, 52, 0, 0, 1),
	(201904870855, 578, '2022-03-05 11:48:28', 0, 0, 2, 70084000.00, 0.00, 10, 52, 52, 0, 1),
	(201904870856, 578, '2022-03-05 11:48:28', 0, 0, 1, 150000.00, 0.00, 11, 52, 52, 1, 1),
	(201904870857, 578, '2022-03-05 11:48:28', 0, 0, 23, 0.00, 0.00, 13, 12, 0, 0, 1),
	(201904870858, 578, '2022-03-05 11:48:28', 0, 0, 4, 2500.00, 0.00, 13, 12, 17, 0, 1),
	(201904870859, 578, '2022-03-05 11:48:28', 0, 0, 10, 900.00, 0.00, 13, 12, 22, 0, 1),
	(201904871307, 578, '2024-01-06 16:05:32', 0, 0, 4, 20000000.00, 0.00, 13, 12, 17, 0, 1),
	(201904871311, 578, '2023-01-06 16:18:47', 0, 0, 2, 13000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871312, 578, '2023-04-06 16:18:47', 0, 0, 1, 15000000.00, 0.00, 11, 52, 52, 1, 1),
	(201904871313, 578, '2023-05-06 16:18:47', 0, 0, 23, 25000000.00, 0.00, 13, 12, 0, 0, 1),
	(201904871315, 579, '2024-02-14 16:18:47', 0, 0, 9, 1500000.00, 0.00, 13, 12, 22, 0, 1),
	(201904871387, 587, '2023-06-06 16:18:47', 0, 0, 0, 21000000.00, 0.00, NULL, NULL, NULL, NULL, NULL),
	(201904871388, 587, '2023-07-06 16:18:47', 0, 0, 0, 21000000.00, 0.00, NULL, NULL, NULL, NULL, NULL),
	(201904871389, 578, '2023-03-06 16:18:47', 0, 0, 2, 17000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871390, 578, '2023-02-06 16:18:47', 0, 0, 2, 19000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871391, 587, '2023-08-06 16:18:47', 0, 0, 0, 23000000.00, 0.00, NULL, NULL, NULL, NULL, NULL),
	(201904871392, 587, '2023-09-06 16:18:47', 0, 0, 0, 22000000.00, 0.00, NULL, NULL, NULL, NULL, NULL),
	(201904871393, 587, '2023-10-06 16:18:47', 0, 0, 0, 13000000.00, 0.00, NULL, NULL, NULL, NULL, NULL),
	(201904871394, 587, '2023-11-06 16:18:47', 0, 0, 0, 18000000.00, 0.00, NULL, NULL, NULL, NULL, NULL),
	(201904871395, 587, '2023-12-06 16:18:47', 0, 0, 0, 11000000.00, 0.00, NULL, NULL, NULL, NULL, NULL),
	(201904871396, 578, '2023-02-05 16:18:47', 0, 0, 2, 18000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871397, 578, '2023-02-04 16:18:47', 0, 0, 2, 17000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871398, 578, '2023-02-03 16:18:47', 0, 0, 2, 16000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871399, 578, '2023-02-02 16:18:47', 0, 0, 2, 15000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871400, 578, '2023-02-01 16:18:47', 0, 0, 2, 14000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871401, 578, '2023-02-07 16:18:47', 0, 0, 2, 20000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871402, 578, '2023-02-08 16:18:47', 0, 0, 2, 21000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871403, 578, '2023-02-09 16:18:47', 0, 0, 2, 22000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871404, 578, '2023-02-10 16:18:47', 0, 0, 2, 23000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871405, 578, '2023-02-11 16:18:47', 0, 0, 2, 24000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871406, 578, '2023-01-31 16:18:47', 0, 0, 2, 13000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871407, 578, '2023-01-30 16:18:47', 0, 0, 2, 13000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871408, 578, '2023-01-29 16:18:47', 0, 0, 2, 13000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871409, 578, '2023-01-28 16:18:47', 0, 0, 2, 13000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871410, 578, '2023-01-27 16:18:47', 0, 0, 2, 13000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871411, 578, '2023-02-12 16:18:47', 0, 0, 2, 20000000.00, 0.00, 10, 52, 52, 0, 1),
	(201904871412, 578, '2023-02-13 16:18:47', 0, 0, 2, 24000000.00, 0.00, 10, 52, 52, 0, 1);


-- Dumping structure for table sapdash.dashboardhst
CREATE TABLE IF NOT EXISTS `dashboardhst` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `HstDate` datetime NOT NULL DEFAULT '1900-01-01 00:00:00',
  `DashboardID` int(11) NOT NULL,
  `SerialNumber` varchar(45) NOT NULL DEFAULT '',
  `HeadID` int(11) NOT NULL DEFAULT '0',
  `DeviceName` varchar(45) NOT NULL DEFAULT '',
  `Remark` varchar(45) NOT NULL DEFAULT '',
  `LocationAllow` varchar(1024) NOT NULL DEFAULT '',
  `DeviceAllow` varchar(10) NOT NULL DEFAULT '0000000000',
  `Status` tinyint(4) NOT NULL DEFAULT '0',
  `UserID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID_UNIQUE` (`ID`),
  KEY `HstDate` (`HstDate`),
  KEY `DashboardID` (`DashboardID`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

-- Dumping data for table sapdash.dashboardhst: ~17 rows (approximately)
DELETE FROM `dashboardhst`;
INSERT INTO `dashboardhst` (`ID`, `HstDate`, `DashboardID`, `SerialNumber`, `HeadID`, `DeviceName`, `Remark`, `LocationAllow`, `DeviceAllow`, `Status`, `UserID`) VALUES
	(13, '2018-05-31 14:23:57', 10001, '116183131039', 10, 'Jony', 'JS', '10,1000,1002', '1111111111', 0, 999),
	(14, '2018-05-31 14:53:04', 10002, 'YA4TYU4TK', 10, 'MUJIONO', 'HP ENVY ', '10,1000,1001', '1111111111', 0, 999),
	(15, '2018-05-31 15:56:26', 10002, '1Z7G7Q9F', 10, 'DESTY', '', '10,1000,1001', '1111111111', 0, 999),
	(16, '2018-05-31 15:57:22', 10002, '1Z7D7Q9F', 10, 'DESTY', '', '10,1000,1001', '1111111111', 0, 999),
	(17, '2018-05-31 16:34:27', 10003, 'EW1SQ3WV', 10, 'Alex Musbar', 'Alex', '10,1000,1001', '1111111111', 0, 999),
	(18, '2018-06-04 10:20:32', 10001, '20009153688020000', 10, 'Jony', 'JS', '10,1000,1001', '1111111111', 0, 999),
	(19, '2018-06-04 10:20:53', 10001, '20009153688020000', 10, 'Jony', 'JS', '10,1000,1001', '1111111111', 0, 999),
	(20, '2018-08-21 15:40:15', 10004, 'ZA5CJU1TK', 10, 'Andyanto', 'SPI', '10,1001,1002', '1111111111', 0, 999),
	(21, '2018-08-21 16:16:51', 10005, '7150514AF04C', 10, 'Ryan', 'BD SPI', '10,1001,1002', '1111111111', 0, 999),
	(22, '2018-08-21 16:34:05', 10006, '017071BPCN40Y1ZFDGSR', 10, 'BD 1', 'BD SPI', '10,1001,1002', '1111111111', 0, 999),
	(23, '2018-08-21 17:02:50', 10007, 'BW4YDK23', 10, 'Ahin', 'BD Spi', '10,1001,1002', '1111111111', 0, 999),
	(24, '2018-08-21 17:47:55', 10008, 'ZA5WMO1TV', 10, 'SC', 'BD SPI', '10,1001,1002', '1111111111', 0, 999),
	(25, '2019-01-08 10:25:49', 10003, 'LWG1H5KH', 10, 'Alex Musbar', 'Alex', '10,1001,1002', '1111111111', 0, 999),
	(26, '2019-01-28 16:40:53', 10003, '00523_B8_5184BF_8A.9', 10, 'Alex Musbar', 'Alex', '10,1001,1002', '1111111111', 0, 999),
	(27, '2019-01-28 16:40:56', 10003, '00523_B8_5184BF_8A.9', 10, 'Alex Musbar', 'Alex', '10,1001,1002', '1111111111', 0, 999),
	(28, '2019-01-30 11:21:35', 10009, 'RASPBERRY', 10, 'RASPBERRY', 'LINUX', '10,1001,1002', '1111111111', 0, 999),
	(29, '2019-01-31 08:44:40', 10010, '270F00000808', 99, 'hari', 'tes', '10,1001,1002', '1111111111', 0, 999);


-- Dumping structure for table sapdash.dash_sum
CREATE TABLE IF NOT EXISTS `dash_sum` (
  `dash_sumId` int(11) NOT NULL AUTO_INCREMENT,
  `dash_sum_dashLabel` datetime DEFAULT NULL,
  `dash_sum_locId` int(11) DEFAULT NULL,
  `dash_sum_y` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`dash_sumId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table sapdash.dash_sum: ~3 rows (approximately)
DELETE FROM `dash_sum`;
INSERT INTO `dash_sum` (`dash_sumId`, `dash_sum_dashLabel`, `dash_sum_locId`, `dash_sum_y`) VALUES
	(1, '2024-02-02 15:57:34', 579, 3400.00),
	(2, '2024-02-02 16:06:08', 578, 70087400.00),
	(3, '2024-02-03 16:06:08', 578, 1.00);


-- Dumping structure for table sapdash.location
CREATE TABLE IF NOT EXISTS `location` (
  `locId` int(11) NOT NULL,
  `locParentId` int(11) NOT NULL DEFAULT '0',
  `SpvID` int(11) NOT NULL DEFAULT '0',
  `Name` varchar(40) NOT NULL DEFAULT '',
  `Address1` varchar(50) NOT NULL DEFAULT '',
  `Address2` varchar(50) NOT NULL DEFAULT '',
  `ContactName` varchar(45) NOT NULL DEFAULT '',
  `Telephone` varchar(45) NOT NULL DEFAULT '',
  `Handphone` varchar(45) NOT NULL DEFAULT '',
  `Email` varchar(45) NOT NULL DEFAULT '',
  `posmasuk` int(11) NOT NULL COMMENT 'Jumlah pos masuk',
  `poskeluar` int(11) NOT NULL COMMENT 'Jumlah pos keluar',
  `ProbTicket` int(225) NOT NULL DEFAULT '0' COMMENT 'Jumlah tiket masalah',
  `karyawan` int(20) NOT NULL,
  `sistem` varchar(50) NOT NULL,
  `keterangan` varchar(40) NOT NULL,
  `StaffCount` int(11) NOT NULL DEFAULT '0',
  `Status` tinyint(4) NOT NULL DEFAULT '0',
  `UserID` int(11) NOT NULL DEFAULT '0',
  `LOvCount` int(11) NOT NULL DEFAULT '0',
  `LInCount` int(11) NOT NULL DEFAULT '0',
  `LTrsCount` int(11) NOT NULL DEFAULT '0',
  `LTrsValue` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Last TRS',
  `LUPTrs` datetime DEFAULT NULL COMMENT 'Last Update TRS',
  `YTrsValue` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Pendapatan tahun berjalan',
  `LYTrsValue` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Pendapatan tahun lalu',
  `PYTrsValue` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Target pendapatan tahun berjalan',
  `YOutValue` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Pengeluaran tahun berjalan',
  `LYOutValue` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Pengeluaran tahun lalu',
  `PYOutValue` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Target pengeluaran tahun berjalan',
  `YLocCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Jumlah lokasi tahun berjalan',
  `LYLocCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Jumlah lokasi tahun lalu',
  `PYLocCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Target jumlah lokasi tahun berjalan',
  PRIMARY KEY (`locId`),
  UNIQUE KEY `ID_UNIQUE` (`locId`),
  UNIQUE KEY `Name` (`Name`),
  KEY `HeadID` (`locParentId`),
  KEY `SpvID` (`SpvID`),
  KEY `Status` (`Status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table sapdash.location: ~11 rows (approximately)
DELETE FROM `location`;
INSERT INTO `location` (`locId`, `locParentId`, `SpvID`, `Name`, `Address1`, `Address2`, `ContactName`, `Telephone`, `Handphone`, `Email`, `posmasuk`, `poskeluar`, `ProbTicket`, `karyawan`, `sistem`, `keterangan`, `StaffCount`, `Status`, `UserID`, `LOvCount`, `LInCount`, `LTrsCount`, `LTrsValue`, `LUPTrs`, `YTrsValue`, `LYTrsValue`, `PYTrsValue`, `YOutValue`, `LYOutValue`, `PYOutValue`, `YLocCount`, `LYLocCount`, `PYLocCount`) VALUES
	(10, 0, 1, 'SPI', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0.00, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 0),
	(14, 0, 1, 'ASIA PARKING', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', 'ASIA PARKING', 0, 0, 0, 0, 0, 0, 0.00, NULL, 20000000.00, 30000000.00, 50000000.00, 5000000.00, 6000000.00, 6000000.00, 2, 1, 2),
	(15, 14, 1, 'ASIA PARKING 1', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0.00, NULL, 20000000.00, 19000000.00, 21000000.00, 5000000.00, 9000000.00, 8000000.00, 2, 1, 4),
	(16, 14, 10001, 'ASIA PARKING 2', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0.00, '2024-01-11 00:00:05', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 0),
	(17, 14, 10002, 'ASIA PARKING 3', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0.00, '2024-01-11 00:00:05', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 0),
	(18, 14, 10003, 'ASIA PARKING 4', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', 'test', 0, 0, 0, 0, 0, 0, 0.00, '2024-01-11 00:00:05', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 0),
	(19, 14, 10004, 'ASIA PARKING 5', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', 'Buana Parking', 0, 0, 0, 0, 0, 0, 0.00, '2024-01-11 00:00:05', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 0),
	(234, 10, 1, 'SPI3', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', 'Universitas Tarumanegara', 0, 0, 0, 0, 0, 0, 0.00, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 0),
	(577, 10, 0, 'SPI4', '', '', '', '', '', '', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0.00, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 0),
	(578, 10, 1, 'SPI1', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0.00, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0, 0),
	(579, 10, 1, 'SPI2', '-', '-', '-', '-', '-', '-', 0, 0, 0, 0, '', 'Demo (Lokasi punya Nusapala)', 0, 0, 0, 0, 0, 0, 0.00, NULL, 80000000.00, 90000000.00, 100000000.00, 14000000.00, 14000000.00, 16000000.00, 60, 50, 80);


-- Dumping structure for function sapdash.maxDate
DELIMITER //
CREATE DEFINER=`hakim`@`%%` FUNCTION `maxDate`(ym VARCHAR(50)) RETURNS varchar(20) CHARSET utf8 COLLATE utf8_unicode_ci
    DETERMINISTIC
BEGIN

   DECLARE result varchar(20);
   select label into result from dash where DATE_FORMAT(label, '%Y-%m') = ym ORDER BY label DESC LIMIT 1;
   RETURN result;

END//
DELIMITER ;


-- Dumping structure for function sapdash.maxDateId
DELIMITER //
CREATE DEFINER=`hakim`@`%%` FUNCTION `maxDateId`(`dashId` VARCHAR(50)) RETURNS varchar(20) CHARSET utf8 COLLATE utf8_unicode_ci
    DETERMINISTIC
BEGIN

   DECLARE rMaxDate varchar(20);
   select label into rMaxDate from dash where dash_locId = dashId order by label desc limit 1;
   RETURN rMaxDate;

END//
DELIMITER ;


-- Dumping structure for table sapdash.pendapatan
CREATE TABLE IF NOT EXISTS `pendapatan` (
  `pendapatanId` int(11) NOT NULL AUTO_INCREMENT,
  `pendapatan_classId` int(11) DEFAULT NULL,
  `pendapatan_posInId` int(11) DEFAULT NULL,
  `pendapatan_posOutId` int(11) DEFAULT NULL,
  `pendapatan_isCust` int(11) DEFAULT NULL,
  `pendapatan_rateOut` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`pendapatanId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table sapdash.pendapatan: ~0 rows (approximately)
DELETE FROM `pendapatan`;


-- Dumping structure for table sapdash.score
CREATE TABLE IF NOT EXISTS `score` (
  `playerid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `score` int(11) DEFAULT '0',
  PRIMARY KEY (`playerid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table sapdash.score: ~5 rows (approximately)
DELETE FROM `score`;
INSERT INTO `score` (`playerid`, `score`) VALUES
	(1, 10),
	(2, 40),
	(3, 20),
	(4, 9),
	(5, 20);


-- Dumping structure for table sapdash.user_access
CREATE TABLE IF NOT EXISTS `user_access` (
  `user_accessId` int(11) NOT NULL AUTO_INCREMENT,
  `user_access_userId` int(11) DEFAULT NULL,
  `user_access_locId` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_accessId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table sapdash.user_access: ~12 rows (approximately)
DELETE FROM `user_access`;
INSERT INTO `user_access` (`user_accessId`, `user_access_userId`, `user_access_locId`) VALUES
	(1, 1, 234),
	(2, 1, 577),
	(3, 1, 10),
	(4, 1, 578),
	(5, 1, 14),
	(6, 1, 15),
	(7, 1, 16),
	(8, 1, 17),
	(9, 1, 18),
	(10, 1, 19),
	(11, 2, 234),
	(12, 2, 10),
	(13, 1, 579);
