-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 14, 2022 at 07:23 PM
-- Server version: 10.5.17-MariaDB
-- PHP Version: 7.4.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `es984622_database`
--

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

--
-- Table structure for table `docs`
--

CREATE TABLE `docs` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `doc` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `is_read` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `docs`
--

INSERT INTO `docs` (`id`, `email`, `doc`, `title`, `is_read`, `created_at`) VALUES
(6, 'mark@aol.com', '1656628573.pdf', 'Settlement Doc', 1, '2022-06-30 22:36:13'),
(7, 'Terido@aol.com', '1656628573.pdf', 'Settlement Doc', 0, '2022-06-30 22:36:13'),
(8, 'mark55@aol.com', '1656707329.pdf', 'Settlement Doc', 1, '2022-07-01 20:28:49'),
(9, 'j.tribolati@gmail.com', '1663123004.pdf', 'Final ALTA Settlement Statement', 0, '2022-09-14 02:36:44'),
(10, 'lisaskim03@gmail.com', '1663123004.pdf', 'Final ALTA Settlement Statement', 1, '2022-09-14 02:36:44'),
(12, 'mirthalopez55@aol.com', '1663178165.pdf', 'Final ALTA Settlement Statement', 0, '2022-09-14 17:56:05');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `sender` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `reply` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `is_read` int(11) DEFAULT 0,
  `reply_at` datetime DEFAULT NULL,
  `reply_doc` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `email`, `subject`, `sender`, `content`, `reply`, `created_at`, `is_read`, `reply_at`, `reply_doc`) VALUES
(9, 'DavidHelfy@aol.com', 'Escrow Activation ', 'David Helfy', 'Hello Ivanka, Please find the escrow activation instruction under the document section, download and follow the details in the document. Thank You, David', NULL, '2022-06-29 13:34:09', 0, '0000-00-00 00:00:00', NULL),
(10, 'DavidHelfy@aol.com', 'Escrow Activation ', 'David Helfy', 'Hello Ivanka, Please find the escrow activation instruction under the document section, download and follow the details in the document. Thank You, David', NULL, '2022-06-30 17:04:40', 0, '0000-00-00 00:00:00', NULL),
(11, 'grtioerra@gmail.com', 'aaa', 'aaaaaa', 'sfwerwerwerwerwerwerwerewr', 'xxxxxxxxxxxxxxxxxxxxxxxx', '2022-06-30 21:01:55', 1, '0000-00-00 00:00:00', NULL),
(15, 'grtioerra@gmail.com', 'aaa', 'ssq', 'qweqwewqewqe', 'aaaaasd', '2022-06-30 21:02:55', 1, '0000-00-00 00:00:00', NULL),
(16, 'mark@aol.com', 'Escrow Activation', 'David Helfy', 'Dear Mark,\r\n\r\nKindly check the document area to review your activation instruction.\r\n\r\nThank You\r\nSettlement Agent\r\nDavid Helflich', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '2022-06-30 22:38:21', 1, '0000-00-00 00:00:00', NULL),
(17, 'Terido@aol.com', 'Escrow Activation', 'David Helfy', 'Dear Mark,\r\n\r\nKindly check the document area to review your activation instruction.\r\n\r\nThank You\r\nSettlement Agent\r\nDavid Helflich', NULL, '2022-06-30 22:38:21', 0, '0000-00-00 00:00:00', NULL),
(18, 'dhelfy@wfp.com', 'Escrow Activation', 'David Helfy', 'Dear Mark,\r\n\r\nKindly check the document area to review your activation instruction.\r\n\r\nThank You\r\nSettlement Agent\r\nDavid Helflich', NULL, '2022-06-30 22:38:21', 0, '0000-00-00 00:00:00', NULL),
(19, 'tony@wfp.com', 'Escrow Activation', 'David Helfy', 'Dear Mark,\r\n\r\nKindly check the document area to review your activation instruction.\r\n\r\nThank You\r\nSettlement Agent\r\nDavid Helflich', NULL, '2022-06-30 22:38:21', 0, '0000-00-00 00:00:00', NULL),
(20, 'mark55@aol.com', 'Escrow Activation', 'David Helfy', 'we are ready to close your escrow', 'Find attached', '2022-07-01 20:25:16', 1, '0000-00-00 00:00:00', NULL),
(21, 'mark55@aol.com', 'Escrow Activation', 'David Helfy', 'we are ready to close your escrow', NULL, '2022-07-04 16:23:26', 1, '0000-00-00 00:00:00', NULL),
(22, 'daryljudy@src.com', 'Escrow Activation', 'David Helfy', 'We are ready to close your escrow', 'aawqeweqwewqe', '2022-07-04 18:13:53', 1, '2022-07-04 18:27:13', NULL),
(23, 'daryljudy@src.com', 'Escrow Activation', 'David Helfy', 'qeqe21312312312312', NULL, '2022-09-14 23:24:25', 0, NULL, NULL),
(25, 'mirthalopez455@aol.com', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards\r\nEscrow Processor,\r\nAabelle Santa Maria', NULL, '2022-09-14 23:28:42', 0, NULL, NULL),
(26, 'Aabelle.SantaMaria@settlementtrustco.com', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards\r\nEscrow Processor,\r\nAabelle Santa Maria', 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZZz', '2022-09-14 23:28:42', 1, '2022-09-15 00:49:34', '1663202974.pdf'),
(27, 'daryljudy@wfp.cpm', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards\r\nEscrow Processor,\r\nAabelle Santa Maria', NULL, '2022-09-14 23:28:42', 0, NULL, NULL),
(29, 'mirthalopez455@aol.com', 'Escrow Activation ', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards\r\nEscrow Processor,\r\nAabelle Santa Maria', NULL, '2022-09-14 23:29:39', 0, NULL, NULL),
(31, 'daryljudy@wfp.cpm', 'Escrow Activation ', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards\r\nEscrow Processor,\r\nAabelle Santa Maria', NULL, '2022-09-14 23:29:39', 0, NULL, NULL),
(33, 'mirthalopez455@aol.com', 'Escrow Activation ', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards\r\nEscrow Processor,\r\nAabelle Santa Maria', NULL, '2022-09-15 00:16:20', 0, NULL, NULL),
(35, 'daryljudy@wfp.cpm', 'Escrow Activation ', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards\r\nEscrow Processor,\r\nAabelle Santa Maria', NULL, '2022-09-15 00:16:20', 0, NULL, NULL),
(36, 'daryljudy@src.com', 'Escrow Activation', 'David Helfy', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', NULL, '2022-09-15 00:20:53', 0, NULL, NULL),
(37, 'Aabelle.SantaMaria@settlementtrustco.com', 'Escrow Activation', 'David Helfy', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'CCCCCCCCCCCCCCCCCCCCCCC', '2022-09-15 00:21:56', 1, '2022-09-15 00:44:15', '1663202655.txt'),
(38, 'lisaskim03@gmail.com', 'Escrow Activation', 'David Helfy', 'asdqweqwewqewe', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '2022-09-15 01:02:22', 1, '2022-09-15 01:03:17', '1663203797.pdf'),
(39, 'j.tribolati@gmail.com', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards,\r\nEscrow Processor.\r\nAabelle Santa Maria', 'yes we are good to go', '2022-09-15 01:14:11', 1, '2022-09-15 01:17:56', '1663204676.pdf'),
(40, 'mirthalopez455@aol.com', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards,\r\nEscrow Processor.\r\nAabelle Santa Maria', NULL, '2022-09-15 01:14:11', 0, NULL, NULL),
(41, 'Aabelle.SantaMaria@settlementtrustco.com', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards,\r\nEscrow Processor.\r\nAabelle Santa Maria', NULL, '2022-09-15 01:14:11', 0, NULL, NULL),
(42, 'daryljudy@wfp.cpm', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards,\r\nEscrow Processor.\r\nAabelle Santa Maria', NULL, '2022-09-15 01:14:11', 0, NULL, NULL),
(43, 'lisaskim03@gmail.com', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards,\r\nEscrow Processor.\r\nAabelle Santa Maria', NULL, '2022-09-15 01:14:28', 0, NULL, NULL),
(44, 'mirthalopez55@aol.com', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards,\r\nEscrow Processor.\r\nAabelle Santa Maria', NULL, '2022-09-15 01:14:28', 0, NULL, NULL),
(45, 'Aabelle.SantaMaria@settlementtrustco.com', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards,\r\nEscrow Processor.\r\nAabelle Santa Maria', NULL, '2022-09-15 01:14:28', 0, NULL, NULL),
(46, 'daryljudy@wfp.cpm', 'Escrow Activation', 'Aabelle Santa Maria', 'Greetings John & Lisa,\r\n\r\nIn preparation for your upcoming closing settlement scheduled for 09/21/2022 at Settlement Trust LLC, I advise we start the escrow activation per your approval. I have also uploaded the combined ALTA settlement statement in the document section for your review. Please provide a mobile number I can reach you at. Get back to me as soon as possible.\r\n\r\nKind Regards,\r\nEscrow Processor.\r\nAabelle Santa Maria', NULL, '2022-09-15 01:14:28', 0, NULL, NULL);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `num` varchar(255) DEFAULT NULL,
  `opened_date` datetime DEFAULT NULL,
  `settlement_agency` varchar(255) DEFAULT NULL,
  `closing_date` datetime DEFAULT NULL,
  `selling_agent` varchar(255) DEFAULT NULL,
  `listing_agent` varchar(255) DEFAULT NULL,
  `stop_point` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `address`, `num`, `opened_date`, `settlement_agency`, `closing_date`, `selling_agent`, `listing_agent`, `stop_point`) VALUES
(18, '1830 St Street', '', '2022-04-04 00:00:00', 'Smart Title', '2022-06-04 00:00:00', 'Anthony Salinas', 'Washington Fine Properties', 1),
(20, '1830 Blvd South Side', '', '2022-04-05 00:00:00', 'Trent Title Settlement Inc', '2022-05-05 00:00:00', 'Anthony Salinas', 'Kate Winslet', 1),
(22, '1120 more street', '32045', '2022-03-05 00:00:00', 'Trent Title Settlement Inc', '2022-06-06 00:00:00', 'Anthony Salinas', 'Washington Fine Properties', 0),
(23, '1120 more street', '32045', '2022-03-05 00:00:00', 'Trent Title Settlement Inc', '2022-06-06 00:00:00', 'Anthony Salinas', 'Washington Fine Properties', 2),
(24, '1831 St Street', '32045', '2022-03-05 00:00:00', 'Smart Title', '2022-07-07 00:00:00', 'Anthony Salinas', 'Washington Fine Properties', 0),
(25, '2315 S Street Northwest, Washington DC 20008  ', 'ST-DC-1321', '2022-09-09 00:00:00', 'Settlement Trust LLC', '2022-09-21 00:00:00', 'Margo Wilson & HRL', 'Washington Fine Properties', 1),
(26, '2315 S Street Northwest, Washington DC 20008', 'ST-DC-1321', '2022-09-09 00:00:00', 'Settlement Trust LLC', '2022-09-21 00:00:00', 'Margo Wilson & HRL', 'Washington Fine Properties', 1);

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

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

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `role` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

INSERT INTO `users` (`id`, `email`, `fullname`, `order_id`, `role`) VALUES
(7, 'Aabelle.SantaMaria@settlementtrustco.com', 'Aabelle Santa Maria', 25, 'admin'),
(8, 'j.tribolati@gmail.com', 'John Tribolati & Lisa Kim', 25, 'buyer'),
(9, 'mirthalopez455@aol.com', 'Mirtha Tapia de Lopez & Augusto Lopezâ€Claros', 25, 'seller'),
(10, 'Aabelle.santamaria@settlementrustco.com', 'Aabelle Santa Maria', 26, 'admin'),
(11, 'lisaskim03@gmail.com', 'John Tribolati & Lisa Kim', 26, 'buyer'),
(12, 'mirthalopez55@aol.com', 'Mirtha Tapia de Lopez & Augusto Lopezâ€Claros', 26, 'seller');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `docs`
--
ALTER TABLE `docs`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `docs`
--
ALTER TABLE `docs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED 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 */;
