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

START TRANSACTION;



--
-- Database: `deutlvhk_caj_db`
--
CREATE DATABASE IF NOT EXISTS `deutlvhk_caj_db` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `deutlvhk_caj_db`;

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

--
-- Table structure for table `alert_history`
--

CREATE TABLE `alert_history` (
  `id` int(11) NOT NULL,
  `transaction_type` varchar(50) NOT NULL,
  `description` varchar(200) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `time` varchar(50) NOT NULL,
  `acc_number` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `alert_history`
--

INSERT INTO `alert_history` (`id`, `transaction_type`, `description`, `amount`, `date`, `time`, `acc_number`) VALUES
(1, 'Deposit', 'Contract payment from AGIP', '$260,000.50', '2016-07-21', '17:18:29', ''),
(2, 'Deposit', 'Contract payment from AGIP', '$260,000.50', '21-07-2016', '17:20:37', ''),
(3, 'Local transfer', '', '', '21-07-2016', '17:37:33', ''),
(4, 'Local transfer', 'Local transfer to ', '$20,000.00', '21-07-2016', '17:39:49', ''),
(5, 'Local transfer', 'Local transfer to 01*******9', '$20,000.00', '21-07-2016', '17:40:46', ''),
(6, 'Local transfer', 'Local transfer to 01*******9', '$10,000.00', '21-07-2016', '17:49:56', ''),
(7, 'Local transfer', 'Local transfer to 01*******9', '$20,000.00', '21-07-2016', '17:53:36', ''),
(8, 'Local transfer', 'Local transfer to 01*******9', '$20,000.00', '21-07-2016', '17:56:00', ''),
(9, 'Local transfer', 'Local transfer to 01*******9', '$47,000.00', '21-07-2016', '17:57:13', ''),
(10, 'International transfer', 'International transfer to 46*******124', '$684.00', '21-07-2016', '18:13:03', ''),
(11, 'Deposit', 'Contract payment, Qatar government', '$260,000.50', '21-07-2016', '22:17:12', ''),
(12, 'Deposit', 'Contract payment, Qatar government', '$260,000.50', '21-07-2016', '22:18:24', '463980809124'),
(13, 'Local transfer', 'Local transfer to 01*******9', '$20,636.00', '21-07-2016', '22:23:47', '463980809124'),
(14, 'International transfer', 'International transfer to 46*******124', '$65,647.00', '21-07-2016', '22:26:17', '463980809124'),
(15, 'Deposit', 'Chinenye', '$500,000.00', '21-07-2016', '23:29:15', '463980809124'),
(16, 'Local transfer', 'Local transfer to 01*******9', '$50,000.00', '25-07-2016', '11:17:45', '463980809124'),
(17, 'Deposit', 'Francis Morgan', '$260,000.50', '27-09-2016', '21:46:35', '792655532893'),
(18, 'Deposit', 'Francis Morgan', '$260,000.50', '27-09-2016', '21:48:10', '792655532893'),
(19, 'Deposit', 'Francis Morgan', '$2,000,000.00', '26-10-2016', '19:25:26', '792655532893'),
(20, 'Deposit', 'Barrister Aren Aram', '$999,500.00', '29-06-2020', '09:11:39', '530762816004'),
(21, 'Deposit', 'Barrister Aren Aram', '$999,500.00', '29-06-2020', '09:11:39', '530762816004'),
(22, 'Deposit', 'Barrister Aren Aram', '$999,500.00', '29-06-2020', '09:13:58', '530762816004'),
(23, 'Deposit', 'Barrister Aren Aram', '$1,999,000.00', '29-06-2020', '09:21:07', '530762816004'),
(24, 'Deposit', 'Barrister Aren Aram', '$970,000.00', '20-07-2020', '06:28:10', '858834764383'),
(25, 'Deposit', 'Barrister Aren Aram', '$850,000.00', '24-07-2020', '03:07:59', '550417468897'),
(26, 'Deposit', 'Barrister Aren Aram', '$850,000.00', '25-07-2020', '06:43:42', '318830612614'),
(27, 'Deposit', 'Barrister Aren Aram', '$850,000.00', '06-08-2020', '05:35:18', '227942039924'),
(28, 'Deposit', 'Barrister Aren Aram', '$1,025,000.00', '06-08-2020', '08:19:43', '166822323138'),
(29, 'Deposit', 'Barrister Aren Aram', '$372,000.00', '11-08-2020', '06:01:28', '590668614583'),
(30, 'Deposit', 'Barrister Aren Aram', '$372,000.00', '11-08-2020', '09:29:37', '861277393565'),
(31, 'Deposit', 'Barrister Aren Aram', '$752,000.00', '17-08-2020', '09:00:41', '370729058078'),
(32, 'Deposit', 'Barrister Aren Aram', '$372,000.00', '19-08-2020', '09:05:37', '861044805715'),
(33, 'Deposit', 'Barrister Aren Aram', '$372,000.00', '19-08-2020', '10:04:48', '653666385864'),
(34, 'Deposit', 'Barrister Aren Aram', '$372,000.00', '24-08-2020', '04:31:05', '135139749116'),
(35, 'Deposit', 'Barrister Aren Aram', '$851,000.00', '25-08-2020', '04:32:36', '642096357829'),
(36, 'Deposit', 'Barrister Aren Aram', '$1,200,000.00', '27-08-2020', '07:15:48', '957454006755'),
(37, 'Deposit', 'Barrister Aren Aram', '$1,500,000.00', '27-08-2020', '10:14:22', '612057886304');

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

--
-- AUTO_INCREMENT for table `alert_history`
--
ALTER TABLE `alert_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
COMMIT;

