-- 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 `admin_list`
--

CREATE TABLE `admin_list` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin_list`
--

INSERT INTO `admin_list` (`id`, `username`, `password`) VALUES
(1, 'user', 'pass');

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

--
-- 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');

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

--
-- Table structure for table `boa_acc_clients`
--

CREATE TABLE `boa_acc_clients` (
  `id` int(11) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `middlename` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `reg_suffix` varchar(30) NOT NULL,
  `reg_dob` varchar(50) NOT NULL,
  `reg_src_income` varchar(100) NOT NULL,
  `reg_address1` varchar(200) NOT NULL,
  `reg_address2` varchar(200) NOT NULL,
  `reg_city` varchar(100) NOT NULL,
  `reg_state` varchar(100) NOT NULL,
  `reg_zip` varchar(20) NOT NULL,
  `reg_country` varchar(100) NOT NULL,
  `phone1` varchar(100) NOT NULL,
  `reg_phone1_type` varchar(100) NOT NULL,
  `phone2` varchar(50) NOT NULL,
  `reg_phone2_type` varchar(50) NOT NULL,
  `reg_nos_firstname` varchar(50) NOT NULL,
  `reg_nos_middlename` varchar(50) NOT NULL,
  `reg_nos_lastname` varchar(50) NOT NULL,
  `reg_nos_address` varchar(500) NOT NULL,
  `reg_nos_phone` varchar(50) NOT NULL,
  `reg_nos_rel` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `online_id` varchar(50) NOT NULL,
  `passcode` varchar(50) NOT NULL,
  `balance` varchar(50) NOT NULL,
  `acc_type` varchar(100) NOT NULL,
  `acc_number` varchar(100) NOT NULL,
  `date_time` varchar(50) NOT NULL,
  `passport_name` varchar(100) NOT NULL,
  `signature_name` varchar(100) NOT NULL,
  `transfer_code` varchar(20) NOT NULL,
  `transfer_message` varchar(500) NOT NULL,
  `transfer_acc_no` varchar(100) NOT NULL,
  `transfer_amount` varchar(100) NOT NULL,
  `email_status` varchar(30) NOT NULL,
  `email_token` varchar(100) NOT NULL,
  `transaction_id` varchar(100) NOT NULL,
  `cot_code` varchar(50) NOT NULL,
  `vat_code` varchar(50) NOT NULL,
  `transfer_level` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `boa_acc_clients`
--

INSERT INTO `boa_acc_clients` (`id`, `firstname`, `middlename`, `lastname`, `reg_suffix`, `reg_dob`, `reg_src_income`, `reg_address1`, `reg_address2`, `reg_city`, `reg_state`, `reg_zip`, `reg_country`, `phone1`, `reg_phone1_type`, `phone2`, `reg_phone2_type`, `reg_nos_firstname`, `reg_nos_middlename`, `reg_nos_lastname`, `reg_nos_address`, `reg_nos_phone`, `reg_nos_rel`, `email`, `online_id`, `passcode`, `balance`, `acc_type`, `acc_number`, `date_time`, `passport_name`, `signature_name`, `transfer_code`, `transfer_message`, `transfer_acc_no`, `transfer_amount`, `email_status`, `email_token`, `transaction_id`, `cot_code`, `vat_code`, `transfer_level`) VALUES
(6, 'Chukx', 'Monix', 'Hertz', 'IV', '12/09/1967', 'Self Employed', 'No 25 Kaza Street', 'No 25 Kaza Street', 'Ikeja', 'Lagos', '56732', 'Algeria [213]', '+2349', 'Mobile', '+2348', 'Home', 'Hosseini', 'Abdul', 'Malik', '', '', '', 'chucksy2@gmail.com', 'Chukx.Hertz', '50021701', '$3,139,482.6', 'Checking', '792655532893', '2016-08-04 07:40:18', 'ChukxHertz969645.jpg', '', '', 'Hello bbro', 'jfjjv', '$29,998', 'Verified', '7b42b93749ec7cd1b3ae2a1ff881d496', '1390504921', '', '', ''),
(7, 'Uche', 'Luther', 'Las', 'Jr', '12/03/1989', 'Employement income', 'no 25 Kaza street', 'no 25 Kaza street', 'Owerri', 'Imo', '875674', 'Australian External Territories [672]', '24458678585', 'Home', '2349', 'Home', 'Hugo', 'ico', 'Mbaga', 'no 25 kaza street', '234878776768', 'Cousin', 'austinechukwu23@yahoo.com', 'Uche.Las', '39808485', '', 'Savings', '278788573698', '01-04-2017 21:16:13', 'UcheLas691351.jpg', '', '5049', '', '', '', 'Unverified', 'b49bea29dca05760390370c3aaaa97f0', '', '2400', '9412', ''),
(8, 'Cristina', 'Geronimo', 'Latag', 'None', '22/06/1962', 'Inheritance or Trust', 'Blk 11 lot 19 Juana 3a binan laguna  philippines', 'Blk 11 lot 19 Juana 3a binan laguna  philippines', 'binan', 'binan', '4024', 'Philippines [63]', '+639177126573', 'Mobile', '+639177126573', 'Mobile', 'Rayn', 'Heart', 'Rayn', 'Blk 11 lot 19 Juana 3a binan laguna  philippines', '+639177126573', 'Husband', 'tenglatag@gmail.com', 'Cristina.Latag', '67241231', '$999,500.00', 'Savings', '530762816004', '29-06-2020 08:41:10', '530762816004704780.jpg', '', '5259', '', '001810-0000055', '$5,000.00', 'Verified', '', '7158095596', '8477', '5263', ''),
(13, 'María', 'Fernanda best', 'La Rosa', 'Sr', '22/06/1962', 'Inheritance or Trust', 'Guayaquil -guayas Marcelino maridueña', 'Guayaquil -guayas Marcelino maridueña', 'GUAYAGUIL', 'maridueña', 'EC091050', 'Ecuador [593]', '+2348147543373', 'Home', '+2348147543373', 'Home', 'Frank', 'F', 'Alex', 'UK', '+447478304348', 'Husband', 'o_cajethan@yahoo.com', 'María.La Rosa', '46694834', '', 'Savings', '729582999717', '06-08-2020 04:37:45', 'MaríaLa Rosa855556.jpg', '', '2382', '', '', '', 'Verified', '', '', '6082', '1547', ''),
(16, 'Ali', 'M', 'Muhammad', 'Sr', '22/06/1982', 'Other', 'Alexandria. the park. Awayed', 'Alexandria. the park. Awayed', 'awayed', 'awayed', '11865', 'Egypt [20]', '01010266691', 'Home', '01010266691', 'Home', 'Ali', 'Muhammad', 'Junior', 'Egypt', '01010266691', 'Other', 'sayedmusalmi123@gmail.com', 'Ali.Muhammad', 'sayed01010266691', '$372,000.00', 'Checking', '590668614583', '11-08-2020 05:58:11', '590668614583383829.jpeg', '', '7951', '', '5078034887697003', '50000', 'Verified', '', '6328364420', '2452', '1613', ''),
(18, 'Panattasa', 'P', 'Pengpis', 'Sr', '02/02/1978', 'Inheritance or Trust', '40/17 Moo 4 Pratuchai Subdistrict, Phra Nakhon Si Ayutthaya District Phra Nakhon Si Ayutthaya', '40/17 Moo 4 Pratuchai Subdistrict, Phra Nakhon Si Ayutthaya District Phra Nakhon Si Ayutthaya', 'Ayutthaya', 'Ayutthaya', '13000', 'Thailand [66]', '0895332954', 'Work', '0895332954', 'Home', 'Panattasa', 'Pengpis', 'Junior', '40/17 Moo 4 Pratuchai Subdistrict, Phra Nakhon Si Ayutthaya District Phra Nakhon Si Ayutthaya', '0895332954', 'Other', 'panatsa2954@gmail.com', 'Panattasa.Pengpis', '11399892', '$752,000.00', 'Checking', '370729058078', '17-08-2020 08:51:41', '370729058078180774.jpg', '', '9663', '', '1010517465', '$752,000', 'Verified', '', '2912474142', '6559', '4485', ''),
(22, 'Saqib', 'Javed', 'Azhar', 'Sr', '02/08/1964', 'Other', 'City Burewala Pakistan', 'City Burewala Pakistan', 'burewala', 'burewala', '54700', 'Pakistan [92]', '+923069891411', 'Work', '+923069891411', 'Home', 'Saqib', 'Javed', 'junior', 'City Burewala Pakistan', '+923069891411', 'Brother', 'saqibjaved112215@gmail.com', 'Saqib.Azhar', '45597292', '$372,000.00', 'Checking', '135139749116', '24-08-2020 04:14:32', 'SaqibAzhar636319.png', '', '4635', '', '', '', 'Verified', '', '6334628624', '2611', '3929', ''),
(23, 'Uthen', 'Chao', 'Lahan', 'Sr', '02/22/1983', 'Other', '553 Moo 3, Sa Krachom Subdistrict, Don Chedi District, Suphanburi Province', '553 Moo 3, Sa Krachom Subdistrict, Don Chedi District, Suphanburi Province', 'krachom', 'krachom', '72250', 'Thailand [66]', '+66921731553', 'Home', '+66921731553', 'Work', 'Uthen', 'Chao', 'junior', '553 Moo 3, Sa Krachom Subdistrict, Don Chedi District, Suphanburi Province', '553 Moo 3, Sa Krachom Subdistrict, Don Chedi Distr', 'Brother', 'thencheuxkwises@gmail.com', 'Uthen.Lahan', '44985459', '$851,000.00', 'Checking', '642096357829', '25-08-2020 04:25:40', '642096357829482033.jpg', '', '9143', '', '5222616912', '851000', 'Verified', '', '3565889009', '5799', '4625', ''),
(24, 'Viktoria', 'V.', 'Svystunova', 'None', '02/08/1964', 'Other', 'Lutsk City. St. Chernyshevsky 128A Apartment, Ukraine', '', 'Lutsk City', 'Volyn Oblast', '43000', 'Ukraine [380]', '+380985199330', 'Home', '+380985199330', 'Work', 'Viktoria', 'Svystunova', 'Junior', 'Lutsk City. St. Chernyshevsky 128A Apartment, Ukraine', '+380985199330', 'Brother', 'viktoriasvistunova2@gmail.com', 'Viktoria.Svystunova', '91056215', '$1,200,000.00', 'Checking', '957454006755', '27-08-2020 07:06:00', 'ViktoriaSvystunova981987.jpg', '', '2731', '', '', '', 'Verified', '', '7437685690', '6039', '3682', ''),
(26, 'Abbas', 'Farid', 'Shaikh', 'Sr', '02/22/1983', 'Inheritance or Trust', 'ekta c.h.s flat no. 610 (B) wing Andheri West Mumbai gillBert hill road', '', 'West Mumbai', 'Mumbai', '400058', 'India [91]', '+918655978597', 'Home', '+918655978597', 'Work', 'Abbas', 'Farid', 'Junior', 'ekta c.h.s flat no. 610 (B) wing Andheri West Mumbai gillBert hill road', '+918655978597', 'Brother', 'shaikhabbs289@gmail.com', 'Abbas.Shaikh', '48943177', '$1,500,000.00', 'Checking', '612057886304', '27-08-2020 10:10:54', 'AbbasShaikh367628.jpg', '', '2070', '', '6625162233', '500', 'Verified', '', '5877598801', '5046', '5551', '');

--
-- Indexes for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_list`
--
ALTER TABLE `admin_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

