-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `hubject_backend`
--

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

--
-- Table structure for table `eroamingauthentificationdata`
--

CREATE TABLE `eroamingauthentificationdata` (
  `ID` int(11) NOT NULL,
  `ProviderID` varchar(200) NOT NULL,
  `Identification` varchar(200) NOT NULL,
  `UID` varchar(50) NOT NULL,
  `EvcoID` varchar(250) NOT NULL,
  `RFID` varchar(200) NOT NULL,
  `PIN` varchar(250) NOT NULL,
  `HashedPIN` varchar(250) NOT NULL,
  `PrintedNumber` varchar(150) NOT NULL,
  `ExpiryDate` date NOT NULL,
  `DateTime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `eroamingauthentificationdata`
--

INSERT INTO `eroamingauthentificationdata` (`ID`, `ProviderID`, `Identification`, `UID`, `EvcoID`, `RFID`, `PIN`, `HashedPIN`, `PrintedNumber`, `ExpiryDate`, `DateTime`) VALUES
(1, 'DE-8EO', 'RFIDMifareFamilyIdentification', '7568290FFF765F', '-', '-', '-', '-', '-', '2022-07-03', '2022-07-03 12:56:51'),
(2, 'DE8EOO', 'RemoteIdentification', '-', 'DE-8EO-CAet5e4XY-3', '-', '-', '-', '-', '2022-07-03', '2022-07-03 13:13:02'),
(3, 'DE-8EO', 'RFIDIdentification', '7568290FFF765F', 'DE-8EO-CAet5e4XY-8', 'mifareFamily', '-', '-', '12345', '2022-07-31', '2022-07-23 18:19:17'),
(4, 'DW-8EOO', 'QRCodeIdentification', '-', 'DE-8EO-CAet5e4XY-4', '', '12345', '-', '-', '2022-07-27', '2022-07-23 18:25:14'),
(5, 'DQ-8EOO', 'PlugAndChargeIdentification', '-', 'DE-8EO-CAet5e4XY-1', '', '-', '', '-', '0000-00-00', '2022-07-23 18:30:05'),
(6, 'DE-8EO', 'RFIDMifareFamilyIdentification', '7568290FFF765G', '-', '-', '-', '-', '-', '2022-07-03', '0000-00-00 00:00:00'),
(8, 'DE-8EO', 'RFIDMifareFamilyIdentification', '7568290FFF765H', '-', '-', '-', '-', '-', '2022-07-03', '0000-00-00 00:00:00'),
(9, 'DE-8EO', 'RFIDMifareFamilyIdentification', '7568290FFF765O', '-', '-', '-', '-', '-', '2022-07-03', '0000-00-00 00:00:00');

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

--
-- Table structure for table `eroamingauthorizeremotereservationstart`
--

CREATE TABLE `eroamingauthorizeremotereservationstart` (
  `ID` int(11) NOT NULL,
  `SessionID` varchar(200) NOT NULL,
  `CPOPartnerSessionID` varchar(250) NOT NULL,
  `EMPPartnerSessionID` varchar(250) NOT NULL,
  `ProviderID` varchar(200) NOT NULL,
  `EvseID` varchar(50) NOT NULL,
  `Identification` varchar(200) NOT NULL,
  `PartnerProductID` varchar(200) NOT NULL,
  `Duration` int(11) NOT NULL,
  `DateTime` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `eroamingauthorizeremotereservationstart`
--

INSERT INTO `eroamingauthorizeremotereservationstart` (`ID`, `SessionID`, `CPOPartnerSessionID`, `EMPPartnerSessionID`, `ProviderID`, `EvseID`, `Identification`, `PartnerProductID`, `Duration`, `DateTime`) VALUES
(1, '', '', '', 'DE0399', 'DE*AB7*E840*6487', 'RFIDMifareFamilyIdentification', '', 0, '2022-09-05 11:35:05'),
(2, '', '', '', 'DE0399', 'DE*AB7*E840*6487', 'RFIDMifareFamilyIdentification', '', 0, '2022-09-05 22:30:29');

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

--
-- Table structure for table `eroamingauthorizeremotereservationstop`
--

CREATE TABLE `eroamingauthorizeremotereservationstop` (
  `ID` int(11) NOT NULL,
  `SessionID` varchar(200) NOT NULL,
  `CPOPartnerSessionID` varchar(250) NOT NULL,
  `EMPPartnerSessionID` varchar(250) NOT NULL,
  `ProviderID` varchar(200) NOT NULL,
  `EvseID` varchar(200) NOT NULL,
  `DateTime` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `eroamingauthorizeremotereservationstop`
--

INSERT INTO `eroamingauthorizeremotereservationstop` (`ID`, `SessionID`, `CPOPartnerSessionID`, `EMPPartnerSessionID`, `ProviderID`, `EvseID`, `DateTime`) VALUES
(1, 'b2688855-7f00-0002-6d8e-48d883f6abb6', '', '', 'DE0399', 'DE*AB7*E840*6487', '2022-09-05 11:35:45'),
(2, 'b2688855-7f00-0002-6d8e-48d883f6abb6', '', '', 'DE0399', 'DE*AB7*E840*6487', '2022-09-06 19:10:06');

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

--
-- Table structure for table `eroamingauthorizeremotestart`
--

CREATE TABLE `eroamingauthorizeremotestart` (
  `ID` int(11) NOT NULL,
  `SessionID` varchar(200) NOT NULL,
  `CPOPartnerSessionID` varchar(250) NOT NULL,
  `EMPPartnerSessionID` varchar(250) NOT NULL,
  `ProviderID` varchar(200) NOT NULL,
  `EvseID` varchar(200) NOT NULL,
  `Identification` varchar(200) NOT NULL,
  `PartnerProductID` varchar(200) NOT NULL,
  `DateTime` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `eroamingauthorizeremotestop`
--

CREATE TABLE `eroamingauthorizeremotestop` (
  `ID` int(11) NOT NULL,
  `SessionID` varchar(200) NOT NULL,
  `CPOPartnerSessionID` varchar(250) NOT NULL,
  `EMPPartnerSessionID` varchar(250) NOT NULL,
  `ProviderID` varchar(200) NOT NULL,
  `EvseID` varchar(200) NOT NULL,
  `DateTime` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `eroamingchargedetailrecord`
--

CREATE TABLE `eroamingchargedetailrecord` (
  `ID` int(11) NOT NULL,
  `SessionID` varchar(200) NOT NULL,
  `CPOPartnerSessionID` varchar(250) NOT NULL,
  `EMPPartnerSessionID` varchar(250) NOT NULL,
  `PartnerProductID` varchar(200) NOT NULL,
  `EvseID` varchar(200) NOT NULL,
  `Identification` varchar(200) NOT NULL,
  `ChargingStart` datetime NOT NULL,
  `ChargingEnd` datetime NOT NULL,
  `SessionStart` datetime NOT NULL,
  `SessionEnd` datetime NOT NULL,
  `MeterValueStart` decimal(10,3) NOT NULL,
  `MeterValueEnd` decimal(10,3) NOT NULL,
  `MeterValueInBetween` decimal(10,3) NOT NULL,
  `ConsumedEnergy` decimal(10,3) NOT NULL,
  `MeetingSignature` varchar(200) NOT NULL,
  `HubOperatorID` varchar(200) NOT NULL,
  `HubProviderID` varchar(200) NOT NULL,
  `DateTime` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `eroamingchargedetailrecord`
--

INSERT INTO `eroamingchargedetailrecord` (`ID`, `SessionID`, `CPOPartnerSessionID`, `EMPPartnerSessionID`, `PartnerProductID`, `EvseID`, `Identification`, `ChargingStart`, `ChargingEnd`, `SessionStart`, `SessionEnd`, `MeterValueStart`, `MeterValueEnd`, `MeterValueInBetween`, `ConsumedEnergy`, `MeetingSignature`, `HubOperatorID`, `HubProviderID`, `DateTime`) VALUES
(1, 'b2688855-7f00-0002-6d8e-48d883f6abb6', '', '', '', '123-123', 'RFIDMifareFamilyIdentification', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-07-17 18:25:47', '2022-07-17 18:55:47', '29.990', '39.800', '0.000', '0.000', '', '', 'DE-8EOO', '2022-08-08 18:45:58'),
(2, 'b2688855-7f00-0002-6d8e-48d883f6abb6', '', '', '', '123-123', 'RFIDIdentification', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-07-17 18:28:47', '2022-07-17 18:58:47', '29.990', '39.800', '0.000', '0.000', '', '', 'DE-8EO', '2022-08-08 18:45:58'),
(3, 'b2688855-7f00-0002-6d8e-48d883f6abb6', '', '', '', '123-123', 'QRCodeIdentification', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-07-17 18:29:47', '2022-07-17 18:59:47', '29.990', '39.800', '0.000', '0.000', '', '', 'DE-8EO', '2022-08-08 18:45:58'),
(4, 'b2688855-7f00-0002-6d8e-48d883f6abb6', '', '', '', '123-123', 'RFIDIdentification', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-07-17 18:25:47', '2022-07-17 18:55:47', '29.990', '39.800', '0.000', '0.000', '', '', 'DE-8EO', '2022-08-28 15:38:49');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `eroamingauthentificationdata`
--
ALTER TABLE `eroamingauthentificationdata`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `eroamingauthorizeremotereservationstart`
--
ALTER TABLE `eroamingauthorizeremotereservationstart`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `eroamingauthorizeremotereservationstop`
--
ALTER TABLE `eroamingauthorizeremotereservationstop`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `eroamingauthorizeremotestart`
--
ALTER TABLE `eroamingauthorizeremotestart`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `eroamingauthorizeremotestop`
--
ALTER TABLE `eroamingauthorizeremotestop`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `eroamingchargedetailrecord`
--
ALTER TABLE `eroamingchargedetailrecord`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `eroamingauthentificationdata`
--
ALTER TABLE `eroamingauthentificationdata`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `eroamingauthorizeremotereservationstart`
--
ALTER TABLE `eroamingauthorizeremotereservationstart`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `eroamingauthorizeremotereservationstop`
--
ALTER TABLE `eroamingauthorizeremotereservationstop`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `eroamingauthorizeremotestart`
--
ALTER TABLE `eroamingauthorizeremotestart`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `eroamingauthorizeremotestop`
--
ALTER TABLE `eroamingauthorizeremotestop`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `eroamingchargedetailrecord`
--
ALTER TABLE `eroamingchargedetailrecord`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

