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

START TRANSACTION;



--
-- Database: `eaacheck_Support`
--

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

--
-- Table structure for table `Regulatory`
--

CREATE TABLE `Regulatory` (
  `IDnumber` int(3) NOT NULL,
  `Country` varchar(20) DEFAULT NULL,
  `Authority` varchar(10) DEFAULT NULL,
  `InspectionType` varchar(20) NOT NULL,
  `Current-Contract` varchar(20) DEFAULT NULL,
  `ContractExpiry` varchar(20) NOT NULL,
  `Previous-Contract` varchar(20) DEFAULT NULL,
  `Standards1` varchar(20) DEFAULT NULL,
  `Standards2` varchar(20) DEFAULT NULL,
  `Standards3` varchar(20) DEFAULT NULL,
  `RoyaltyUSD` varchar(10) DEFAULT NULL,
  `Fee-JP-USD` varchar(10) DEFAULT NULL,
  `Fee-JP-Yen` varchar(10) DEFAULT NULL,
  `Fee-UK-USD` varchar(10) DEFAULT NULL,
  `Fee-UK-GBP` varchar(10) DEFAULT NULL,
  `Fee-UAE-USD` varchar(10) DEFAULT NULL,
  `Fee-UAE-AED` varchar(10) DEFAULT NULL,
  `Fee-SG-USD` varchar(10) DEFAULT NULL,
  `Fee-SG-SGD` varchar(10) DEFAULT NULL,
  `Fee-SA-USD` varchar(10) DEFAULT NULL,
  `Fee-SA-RND` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Regulatory`
--

INSERT INTO `Regulatory` (`IDnumber`, `Country`, `Authority`, `InspectionType`, `Current-Contract`, `ContractExpiry`, `Previous-Contract`, `Standards1`, `Standards2`, `Standards3`, `RoyaltyUSD`, `Fee-JP-USD`, `Fee-JP-Yen`, `Fee-UK-USD`, `Fee-UK-GBP`, `Fee-UAE-USD`, `Fee-UAE-AED`, `Fee-SG-USD`, `Fee-SG-SGD`, `Fee-SA-USD`, `Fee-SA-RND`) VALUES
(1, 'Bahamas', 'BBSQ', 'RWI', 'BBSQ-2020', '28/02/2023', 'BBSQ_2019', 'BHS-001', '', '', '$40.00', '$150.00', '¥23,345', '$200.00', '£155.00', '$150.00', '550 AED', '$150.00', '$200.00', '', ''),
(2, 'St.Lucia', 'SLBS', 'RWI', 'SLBS-2022', '30/04/2025', '', 'SLNS_41', 'SLNS_42', '', '$40.00', '$150.00', '¥23,345', '$200.00', '£155.00', '$150.00', '', '$150.00', '$200.00', '', ''),
(3, 'Tanzania', 'TBS', 'RWI', 'TBS-2022', '19/07/2025', '', '', '', '', '$60.00', '$150.00', '¥23,055', '', '', '', '', '', '', '', ''),
(4, 'Uganda', 'UNBS', 'RWI', 'UNBS-2020', '31/05/2023', '', 'US845', '', '', '$40.00', '$140.00', '¥21,750', '$200.00', '£150.00', '$125.00', '460 AED', '$200.00', '', '$220.00', ''),
(5, 'Zambia', 'ZCSA', 'RWI', 'ZCSA-2020', '30/11/2023', '', '', '', '', '$45.00', '$140.00', '¥21,678', '$200.00', '£170.00', '$140.00', '515 AED', '$140.00', '', '$140.00', ''),
(6, 'Zimbabwe', 'MIC', 'RWI', 'MIC-2022', '31/05/2025', '', '', '', '', '$21.00', '$140.00', '¥22,026', '$200.00', '£170.00', '$140.00', '515 AED', '$140.00', '', '$140.00', ''),
(7, 'Mauritius', 'MCCP', 'RWI', 'Mauritius-2023', '30/11/2023', '', '', '', '', '', '$100.00', '¥10,450', '', '', '', '', '', '', '', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Regulatory`
--
ALTER TABLE `Regulatory`
  ADD PRIMARY KEY (`IDnumber`);
COMMIT;

