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

START TRANSACTION;



--
-- Database: `scrixuez_smartbank`
--

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

--
-- Table structure for table `activitylog`
--

CREATE TABLE `activitylog` (
  `id` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `ip` varchar(100),
  `browser` varchar(100),
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `activitylog`
--

INSERT INTO `activitylog` (`id`, `email`, `ip`, `browser`, `date`) VALUES
(1, 'admin@yourdomain.com', '12.456.64.21', '', '2022-01-29 15:17:24'),
(2, 'admin@yourdomain.com', '12.456.64.21', '', '2022-01-29 15:17:29');

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

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` int(11) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `bank_region` varchar(100) NOT NULL DEFAULT 'local'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`id`, `bank_name`, `bank_region`) VALUES
(1, 'Zenith Bank PLC', 'local'),
(2, 'Access Bank PLC', 'local'),
(4, 'Bitcoin Bank', 'international'),
(5, 'Eco Bank', 'international');

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

--
-- Table structure for table `beneficiaries`
--

CREATE TABLE `beneficiaries` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `account` varchar(20) NOT NULL,
  `bank` varchar(500) NOT NULL,
  `method` varchar(100) NOT NULL DEFAULT 'local',
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `userid` int(11) NOT NULL,
  `country` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `beneficiaries`
--

INSERT INTO `beneficiaries` (`id`, `name`, `account`, `bank`, `method`, `date`, `userid`, `country`) VALUES
(3, 'John wick', '11212232222', 'Bitcoin Bank', 'international', '2022-09-30 01:35:22', 271, 'JO'),
(4, 'Wow User', '5670925805', 'Access Bank PLC', 'local', '2022-10-01 02:47:40', 272, 'MY'),
(5, 'Alfred Firm', '2930863816', 'Zenith Bank PLC', 'local', '2022-10-07 02:02:21', 273, 'JM'),
(6, 'Dorime Group', '428493245', 'Access Bank PLC', 'local', '2022-10-08 06:18:58', 273, 'JM');

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` int(11) NOT NULL,
  `network` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rate` double DEFAULT NULL,
  `usd` double NOT NULL,
  `btctnx` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(45) NOT NULL DEFAULT 0,
  `tnxid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `loan`
--

CREATE TABLE `loan` (
  `id` int(11) NOT NULL,
  `account` varchar(20) NOT NULL,
  `date` varchar(20) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `amount` int(200) NOT NULL,
  `duration` varchar(200) NOT NULL,
  `reason` varchar(200) DEFAULT NULL,
  `loanid` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `lt` varchar(100) DEFAULT NULL,
  `status` int(19) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `md`
--

CREATE TABLE `md` (
  `id` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `account` varchar(200) NOT NULL,
  `cheque` varchar(200) DEFAULT NULL,
  `amount` varchar(200) NOT NULL DEFAULT '0',
  `cid` varchar(200) NOT NULL,
  `status` int(200) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `messageadmin`
--

CREATE TABLE `messageadmin` (
  `id` int(100) NOT NULL,
  `account` varchar(100) NOT NULL,
  `message` longtext DEFAULT NULL,
  `reply` longtext DEFAULT NULL,
  `msgid` varchar(199) NOT NULL,
  `status` int(10) NOT NULL DEFAULT 0,
  `astatus` int(23) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `net_abbr` varchar(10) NOT NULL,
  `net_name` varchar(225) NOT NULL,
  `net_addr` varchar(100) NOT NULL,
  `net_icon` varchar(100) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `net_abbr`, `net_name`, `net_addr`, `net_icon`, `date`, `status`) VALUES
(1, 'BTC', 'Bitcoin', 'bc1qv2ev7qygcf5q7glutfhxvhlyxwda26qgmpllp6', 'f7110d794176790cc4618f846f7df52c.jpeg', '2022-10-08 13:11:48', 1),
(2, 'ETH', 'Etherium', '0xA3Fefc7Cd98C92A355B83D0D8aF8749F83cb024a', '464654fc0f9aae0964c4f0f8851f4f63.jpeg', '2022-10-08 13:12:23', 1);

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

--
-- Table structure for table `tbl_transaction`
--

CREATE TABLE `tbl_transaction` (
  `id` int(10) NOT NULL,
  `tx_no` varchar(20) NOT NULL,
  `tx_type` varchar(10) NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `date` varchar(100) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `to_accno` varchar(20) DEFAULT NULL,
  `account` varchar(100) DEFAULT NULL,
  `status` varchar(10) NOT NULL,
  `comments` varchar(200) DEFAULT NULL,
  `charges` double NOT NULL DEFAULT 0,
  `method` varchar(100) DEFAULT NULL,
  `bank_name` varchar(500) NOT NULL,
  `beneficiary` varchar(500) NOT NULL,
  `sender_name` varchar(500) DEFAULT NULL,
  `country` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `messageadmin`
--
ALTER TABLE `messageadmin`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

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

--
-- AUTO_INCREMENT for table `tbl_transaction`
--
ALTER TABLE `tbl_transaction`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=902;
COMMIT;

