-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 08, 2021 at 08:23 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `supercryptex`
--

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

--
-- Table structure for table `ip_attempt`
--

CREATE TABLE `ip_attempt` (
  `ip` varchar(100) NOT NULL,
  `time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `todo`
--

CREATE TABLE `todo` (
  `todo_id` int(50) NOT NULL,
  `user_id` int(50) NOT NULL,
  `todo_title` varchar(100) NOT NULL,
  `todo_desc` varchar(500) NOT NULL,
  `todo_todo` varchar(1000) NOT NULL,
  `todo_color` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `transfer`
--

CREATE TABLE `transfer` (
  `transfer_id` int(50) NOT NULL,
  `sender_id` int(50) NOT NULL,
  `sender_name` varchar(100) NOT NULL,
  `sender_fullname` varchar(100) NOT NULL,
  `sender_public_key` varchar(100) NOT NULL,
  `receiver_id` int(50) NOT NULL,
  `receiver_name` varchar(100) NOT NULL,
  `receiver_fullname` varchar(100) NOT NULL,
  `file_path` varchar(500) NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `transfer_time` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `birthday` date NOT NULL,
  `phone` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `host_private` varchar(100) DEFAULT NULL,
  `host_public` varchar(100) DEFAULT NULL,
  `client_private` varchar(100) DEFAULT NULL,
  `client_public` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `name`, `fullname`, `email`, `birthday`, `phone`, `address`, `country`, `password`, `host_private`, `host_public`, `client_private`, `client_public`) VALUES
(5, 'joshua', 'Joshua Allan', 'joshua@joshua.com', '1999-04-28', '081973187777', 'Somewhere', 'Afghanistan', '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257', 'MTU4M3w2MjB8MTQ5M3w5MDU=', 'MTU4M3w5Mzl8MTE1MA==', 'MTU5N3w5MTd8NTY4', 'MTU5N3w5NTd8MjQzfDY0OQ=='),
(6, 'alice', 'Alice', 'alice@alice.com', '2021-05-10', '123', 'Somewhere', 'Afghanistan', '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257', 'MTkwMXwyMDR8MjEwfDUxOQ==', 'MTkwMXwxODEwfDEwMjQ=', 'MTY5N3wxMDJ8MTM3NA==', 'MTY5N3wzNDd8MzQ5fDY4NQ=='),
(7, 'test', 'Test Unit', 'test@test.com', '2021-05-10', '123', 'Somewhere', 'Afghanistan', '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257', 'MTQ1MXwxMTM5fDk0OXwxMzE=', 'MTQ1MXwxMzE1fDI2OQ==', 'MjIxM3wxNTQ5fDk1OQ==', 'MjIxM3wyMDA2fDY0MXwyMTM3'),
(8, 'bob', 'Bob', 'bob@bob.com', '2021-05-10', '123', 'Somewhere', 'Afghanistan', '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257', 'MjA4M3w1MTV8NDY4fDExMjk=', 'MjA4M3wxMzc5fDEzNTM=', 'MTc4OXw0MDR8MTI0OA==', 'MTc4OXwxMjE5fDg0MXw4MzM='),
(9, 'eka', 'Eka Budiharjo', 'eka@eka.com', '2021-05-10', '123', 'Somewhere', 'Afghanistan', '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257', 'MjYwOXwxNDA4fDIwNjZ8MzQ3', 'MjYwOXwyNTd8Mjg=', 'MTI1OXwyOTJ8Nzk=', 'MTI1OXwxMDk5fDMyNnwxMTg5'),
(10, 'dennish', 'Yoshua Dennish', 'dennish@dennish.com', '2021-05-10', '123', 'Somewhere', 'Afghanistan', '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257', 'MjU5M3wxOTUxfDIwNTJ8NDQ1', 'MjU5M3wxODY4fDE4MTk=', 'MjI5N3wyMTAwfDQzMA==', 'MjI5N3w0NzR8MjIxNnwyMDEx'),
(11, 'administrator', 'Administrator', 'administrator@administrator.com', '2021-05-21', '123', 'Somewhere', 'Afghanistan', '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257', 'MTg2N3wxMDIwfDI2OHw3NDM=', 'MTg2N3w0NDJ8OTY4', 'Mjc5MXwyNzQzfDIwNTk=', 'Mjc5MXwyMTg1fDEwMzZ8MTcyMQ=='),
(12, 'guest', 'Guest', 'guest@guest.com', '2021-05-21', '123', 'Somewhere', 'Afghanistan', '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257', 'MTg3OXw1OTV8MTYxN3wxNTQ5', 'MTg3OXwxMzYyfDEyNjg=', 'MTU0M3wxNDY2fDMxOA==', 'MTU0M3w2OTV8NTAzfDUxMQ==');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `todo`
--
ALTER TABLE `todo`
  ADD PRIMARY KEY (`todo_id`);

--
-- Indexes for table `transfer`
--
ALTER TABLE `transfer`
  ADD PRIMARY KEY (`transfer_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `todo`
--
ALTER TABLE `todo`
  MODIFY `todo_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `transfer`
--
ALTER TABLE `transfer`
  MODIFY `transfer_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
