-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 02, 2024 at 11:31 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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: `realestate`
--

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

--
-- Table structure for table `accountstypes`
--

CREATE TABLE `accountstypes` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accountstypes`
--

INSERT INTO `accountstypes` (`ID`, `Code`, `Name`) VALUES
(21, 'N001P001', 'Sales'),
(22, 'N001P001', 'Revenue'),
(23, 'N001P001', 'Expenses'),
(24, 'N001P001', 'Bank'),
(25, 'N001P001', 'Assets'),
(26, 'N001P001', 'Liability'),
(27, 'N001P001', 'Trade Receivable'),
(28, 'N001P001', 'Trade Payable'),
(29, 'N001P001', 'Taxation'),
(30, 'N001P001', 'Rent Receivable');

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

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

CREATE TABLE `banks` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Account` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `banks` (`ID`, `Code`, `Name`, `Account`) VALUES
(2, 'N001P001', 'CBZ Bank Account', '27635637728'),
(3, 'N001P001', 'NMB Bank Account', '647663564773');

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cashbook`
--

CREATE TABLE `cashbook` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cashbook`
--

INSERT INTO `cashbook` (`ID`, `Code`, `AccCode`, `Name`) VALUES
(8, 'N001P001', '8400', 'CABS USD');

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

--
-- Table structure for table `currencys`
--

CREATE TABLE `currencys` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Symbol` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `currencys`
--

INSERT INTO `currencys` (`ID`, `Code`, `Symbol`, `Name`) VALUES
(9, 'N001P001', 'ZIG', 'ZIMBABWE GOLD'),
(10, 'N001P001', 'USD', 'USD Dollar'),
(11, 'N001P001', 'RAND', 'RAND');

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

--
-- Table structure for table `customerinvoicegenaration`
--

CREATE TABLE `customerinvoicegenaration` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Status` varchar(255) NOT NULL,
  `AddedBy` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `CustomeCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `ContactPerson` varchar(255) NOT NULL,
  `Contact1` varchar(255) NOT NULL,
  `Contact2` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`ID`, `Code`, `AccCode`, `CustomeCode`, `Name`, `ContactPerson`, `Contact1`, `Contact2`, `Email`, `Address`, `EntryDate`) VALUES
(9, 'N001P001', 'CUS001', 'N001C001', 'Gimatech Solutions Pvt Ltd', 'Taurayi Gift Nhiwatiwa', '0772662776', '0772662776', 'taurayigiftnhiwatiwa@gmail.com', '15307 1st Sunningdale', '2024-07-16');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `floors`
--

CREATE TABLE `floors` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `FloorNumber` varchar(255) NOT NULL,
  `Rooms` varchar(255) NOT NULL,
  `Space` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `floors`
--

INSERT INTO `floors` (`ID`, `Code`, `FloorNumber`, `Rooms`, `Space`, `EntryDate`) VALUES
(4, 'N001P001', '1', '11', '300sm', '2024-07-16'),
(5, 'N001P001', '10', '12', '30000sm', '2024-07-22'),
(6, 'N001P001', '2', '12', '300sm', '2024-07-22'),
(7, 'N001P001', '3', '12', '300sm', '2024-07-22');

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

--
-- Table structure for table `homecurrency`
--

CREATE TABLE `homecurrency` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `homecurrency`
--

INSERT INTO `homecurrency` (`ID`, `Code`, `Currency`) VALUES
(4, 'N001P001', '10');

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

--
-- Table structure for table `invoicegenaration`
--

CREATE TABLE `invoicegenaration` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Status` varchar(255) NOT NULL,
  `AddedBy` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `invoicegenaration`
--

INSERT INTO `invoicegenaration` (`ID`, `Code`, `Status`, `AddedBy`) VALUES
(64, 'N001P001', '1', 'N001'),
(65, 'N001P001', '1', 'N001'),
(66, 'N001P001', '1', 'N001'),
(67, 'N001P001', '1', 'N001');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `journals`
--

CREATE TABLE `journals` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `journals`
--

INSERT INTO `journals` (`ID`, `Code`, `AccCode`, `Name`) VALUES
(4, 'N001P001', 'GJ001', 'General Journal'),
(5, 'N001P001', 'TEN001', 'Tenant Journal'),
(6, 'N001P001', 'CUS001', 'Customer Journal'),
(7, 'N001P001', 'SUP001', 'Supplier Journal'),
(8, 'N001P001', 'CRJ001', 'Customer Return Journal'),
(9, 'N001P001', 'SJR001', 'Supplier Journal Return'),
(10, 'N001P001', 'TEN002', 'Tenant Return');

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

--
-- Table structure for table `mainaccounts`
--

CREATE TABLE `mainaccounts` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Acctype` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `AccName` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mainaccounts`
--

INSERT INTO `mainaccounts` (`ID`, `Code`, `Acctype`, `AccCode`, `AccName`) VALUES
(26, 'N001P001', '22', '1000', 'Rent Received'),
(27, 'N001P001', '23', '4000', 'OP Costs'),
(28, 'N001P001', '27', '7100', 'Accounts Receivable'),
(29, 'N001P001', '28', '9100', 'Accounts Payable'),
(30, 'N001P001', '24', '8400', 'CABS USD'),
(31, 'N001P001', '24', '8401', 'CABS ZIG'),
(32, 'N001P001', '26', '9550', 'Take on Suspense'),
(36, 'N001P001', '30', '6000', 'Tenant Receivable');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1);

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

--
-- Table structure for table `otheraccounts`
--

CREATE TABLE `otheraccounts` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `otheraccounts`
--

INSERT INTO `otheraccounts` (`ID`, `Code`, `AccCode`, `Name`) VALUES
(16, 'N001P001', '9100', 'Suppliers'),
(17, 'N001P001', '7100', 'Customers'),
(18, 'N001P001', '6000', 'Tenants');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `propertydetails`
--

CREATE TABLE `propertydetails` (
  `ID` int(100) NOT NULL,
  `Ownerreg` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `Type` varchar(255) NOT NULL,
  `Floors` varchar(255) NOT NULL,
  `Area` varchar(255) NOT NULL,
  `Groups` varchar(255) NOT NULL,
  `Rooms` varchar(255) NOT NULL,
  `Space` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `propertydetails`
--

INSERT INTO `propertydetails` (`ID`, `Ownerreg`, `Code`, `Name`, `Address`, `Type`, `Floors`, `Area`, `Groups`, `Rooms`, `Space`) VALUES
(32, 'N001', 'N001P001', 'Regal Star House', '25 George Silundika Harare', 'Story Building1', '10', 'CBD Harare', 'Commercial', '11', '30000sm');

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

--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rates`
--

INSERT INTO `rates` (`ID`, `Code`, `Currency`, `Rate`, `EntryDate`) VALUES
(7, 'N001P001', '9', '15', '2024-07-15'),
(8, 'N001P001', '9', '15', '2024-07-15'),
(9, 'N001P001', '9', '17', '2024-07-15'),
(10, 'N001P001', '11', '17', '2024-07-15'),
(11, 'N001P001', '9', '13.56', '2024-08-02');

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Floor` varchar(255) NOT NULL,
  `Room` varchar(255) NOT NULL,
  `Space` varchar(255) NOT NULL,
  `Tenant` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`ID`, `Code`, `Floor`, `Room`, `Space`, `Tenant`, `EntryDate`) VALUES
(2, 'N001P001', '10', '1004', '18sqm', 'N001T001', '2024-07-22'),
(3, 'N001P001', '10', '1005', '18sqm', 'N001T001', '2024-07-22'),
(4, 'N001P001', '10', '1006', '18sqm', 'N001T001', '2024-07-22');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('PxXougmw1UM0oVnJQlQKk0aknJ0JE4CuasSNu2Ib', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoidUVITWlTZ2lWamlLUkRnZUtTYXo5Y1R3VTdTU1pkMWNmVjdoZkN4QyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9JbnZvaWNlL1RlbmFudCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NDoiTmFtZSI7czoyMjoiVGF1cmF5aSBHaWZ0IE5oaXdhdGl3YSI7czo1OiJSZWdObyI7czo0OiJOMDAxIjtzOjEyOiJQcm9wZXJ0eU5hbWUiO3M6MTY6IlJlZ2FsIFN0YXIgSG91c2UiO3M6MTI6IlByb3BlcnR5Q29kZSI7czo4OiJOMDAxUDAwMSI7fQ==', 1722583278),
('q7oBtqOlmYEBSwyu6XOGv4odK3vKKumgfgP4IWZW', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoidzdnYTJ5RnJlR0RWc2lHRGZZc0djU3E0RFVCYWVPYjlBYnJmZUszaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9QcmludEludm9pY2UvVGVuYW50L0lOVjAwMDQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjQ6Ik5hbWUiO3M6MjI6IlRhdXJheWkgR2lmdCBOaGl3YXRpd2EiO3M6NToiUmVnTm8iO3M6NDoiTjAwMSI7czoxMjoiUHJvcGVydHlOYW1lIjtzOjE2OiJSZWdhbCBTdGFyIEhvdXNlIjtzOjEyOiJQcm9wZXJ0eUNvZGUiO3M6ODoiTjAwMVAwMDEiO30=', 1722590916);

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

--
-- Table structure for table `subaccounts`
--

CREATE TABLE `subaccounts` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `SubCode` varchar(255) NOT NULL,
  `SubName` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subaccounts`
--

INSERT INTO `subaccounts` (`ID`, `Code`, `AccCode`, `SubCode`, `SubName`) VALUES
(22, 'N001P001', '4000', '100', 'Cleaning'),
(23, 'N001P001', '4000', '101', 'Electricity'),
(24, 'N001P001', '4000', '102', 'Plumbing');

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `SupplierCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `ContactPerson` varchar(255) NOT NULL,
  `Contact1` varchar(255) NOT NULL,
  `Contact2` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `Email` text NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`ID`, `Code`, `AccCode`, `SupplierCode`, `Name`, `ContactPerson`, `Contact1`, `Contact2`, `Address`, `Email`, `EntryDate`) VALUES
(4, 'N001P001', 'SUP001', 'N001S001', 'Melsoft Solutions Pvt Ltd', 'Taurayi Gift Nhiwatiwa', '0772662776', '0772662776', '15307 1st Sunningdale', 'taurayigiftnhiwatiwa@gmail.com', '2024-07-16');

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

--
-- Table structure for table `tax`
--

CREATE TABLE `tax` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tax`
--

INSERT INTO `tax` (`ID`, `Code`, `Name`, `Rate`) VALUES
(9, 'N001P001', 'Zero-Rated', '0'),
(11, 'N001P001', 'VAT', '15'),
(12, 'N001P001', 'Exempted', '0'),
(13, 'N001P001', 'Adjustment Input', '15'),
(14, 'N001P001', 'Adjustment Output', '15');

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

--
-- Table structure for table `tenants`
--

CREATE TABLE `tenants` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `AccCode` varchar(255) NOT NULL,
  `TenantCode` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `ContactPerson` varchar(255) NOT NULL,
  `Contact` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `VAT` varchar(255) NOT NULL,
  `TIN` varchar(255) NOT NULL,
  `Floor` varchar(255) NOT NULL,
  `Space` varchar(255) NOT NULL,
  `Rooms` varchar(255) NOT NULL,
  `EntryDate` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tenants`
--

INSERT INTO `tenants` (`ID`, `Code`, `AccCode`, `TenantCode`, `Name`, `ContactPerson`, `Contact`, `Email`, `Address`, `VAT`, `TIN`, `Floor`, `Space`, `Rooms`, `EntryDate`) VALUES
(11, 'N001P001', '6000', 'N001T001', 'Melsoft Solutions Pvt Ltd', 'Ellia Zibayiwa', '0772662776', 'taurayigiftnhiwatiwa@gmail.com', '15307 1st Sunningdale', '0000', '000', '10', '300sm', '3', '2024-07-22');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `EntryDate` varchar(255) NOT NULL,
  `Narration` varchar(255) NOT NULL,
  `Refference` varchar(255) NOT NULL,
  `Accode` varchar(255) NOT NULL,
  `AccSubCode` varchar(255) NOT NULL,
  `ContraCode` varchar(255) NOT NULL,
  `ContraSubCode` varchar(255) NOT NULL,
  `DR` varchar(255) NOT NULL,
  `CR` varchar(255) NOT NULL,
  `Addedby` varchar(255) NOT NULL,
  `Source` varchar(255) NOT NULL,
  `Qnty` varchar(255) NOT NULL,
  `Price` varchar(255) NOT NULL,
  `Tax` varchar(255) NOT NULL,
  `TaxID` varchar(255) NOT NULL,
  `Discount` varchar(255) NOT NULL,
  `Total` varchar(255) NOT NULL,
  `Batch` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`ID`, `Code`, `EntryDate`, `Narration`, `Refference`, `Accode`, `AccSubCode`, `ContraCode`, `ContraSubCode`, `DR`, `CR`, `Addedby`, `Source`, `Qnty`, `Price`, `Tax`, `TaxID`, `Discount`, `Total`, `Batch`, `Currency`, `Rate`) VALUES
(93, 'N001P001', '2024-08-02', 'Operation Cost', 'Refference', '6000', 'N001T001', '4000', '100', '0', '8.311209439528', 'N001', 'Tenant', '1', '7.3746312684366', '15', '11', '2', '7.3746312684366', 'INV0001', '9', '13.56'),
(94, 'N001P001', '2024-08-02', 'Operation Cost', 'Refference', '6000', 'N001T001', '4000', '100', '0', '6.6294117647059', 'N001', 'Tenant', '1', '5.8823529411765', '15', '11', '2', '5.8823529411765', 'INV0002', '11', '17'),
(95, 'N001P001', '2024-08-02', 'Operation Cost', 'Refference', '6000', 'N001T001', '4000', '100', '0', '112.7', 'N001', 'Tenant', '1', '100', '15', '11', '2', '100', 'INV0003', '10', '1'),
(96, 'N001P001', '2024-08-02', 'Operation Cost', 'Refference', '6000', 'N001T001', '4000', '100', '0', '112.7', 'N001', 'Tenant', '1', '100', '15', '11', '2', '100', 'INV0004', '10', '1'),
(97, 'N001P001', '2024-08-02', 'JULY RENT', 'JULY RENT', '6000', 'N001T001', '1000', '0', '0', '805', 'N001', 'Tenant', '1', '700', '15', '11', '0', '700', 'INV0004', '10', '1');

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

--
-- Table structure for table `transactionsjob`
--

CREATE TABLE `transactionsjob` (
  `ID` int(100) NOT NULL,
  `Code` varchar(255) NOT NULL,
  `EntryDate` varchar(255) NOT NULL,
  `Narration` varchar(255) NOT NULL,
  `Refference` varchar(255) NOT NULL,
  `Accode` varchar(255) NOT NULL,
  `AccSubCode` varchar(255) NOT NULL,
  `ContraCode` varchar(255) NOT NULL,
  `ContraSubCode` varchar(255) NOT NULL,
  `DR` varchar(255) NOT NULL,
  `CR` varchar(255) NOT NULL,
  `Addedby` varchar(255) NOT NULL,
  `Source` varchar(255) NOT NULL,
  `Qnty` varchar(255) NOT NULL,
  `Price` varchar(255) NOT NULL,
  `Tax` varchar(255) NOT NULL,
  `TaxID` varchar(255) NOT NULL,
  `Discount` varchar(255) NOT NULL,
  `Total` varchar(255) NOT NULL,
  `Batch` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `usersdetails`
--

CREATE TABLE `usersdetails` (
  `ID` int(100) NOT NULL,
  `EntryDate` varchar(255) NOT NULL,
  `UserCode` varchar(255) NOT NULL,
  `National_ID` varchar(255) NOT NULL,
  `FullName` varchar(255) NOT NULL,
  `Phone` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `Username` varchar(255) NOT NULL,
  `Password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `usersdetails`
--

INSERT INTO `usersdetails` (`ID`, `EntryDate`, `UserCode`, `National_ID`, `FullName`, `Phone`, `Email`, `Address`, `Username`, `Password`) VALUES
(1, '2024-07-04', 'N001', '70-309821S42', 'Taurayi Gift Nhiwatiwa', '+263 77 266 2776', 'taurayigiftnhiwatiwa@gmail.com', '15307 1st Sunningdale 2 Harare', 'Admin', 'Admin');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accountstypes`
--
ALTER TABLE `accountstypes`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cashbook`
--
ALTER TABLE `cashbook`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `currencys`
--
ALTER TABLE `currencys`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `customerinvoicegenaration`
--
ALTER TABLE `customerinvoicegenaration`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `floors`
--
ALTER TABLE `floors`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `homecurrency`
--
ALTER TABLE `homecurrency`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `invoicegenaration`
--
ALTER TABLE `invoicegenaration`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `journals`
--
ALTER TABLE `journals`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `mainaccounts`
--
ALTER TABLE `mainaccounts`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `otheraccounts`
--
ALTER TABLE `otheraccounts`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `propertydetails`
--
ALTER TABLE `propertydetails`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `rates`
--
ALTER TABLE `rates`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `subaccounts`
--
ALTER TABLE `subaccounts`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tax`
--
ALTER TABLE `tax`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tenants`
--
ALTER TABLE `tenants`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `transactionsjob`
--
ALTER TABLE `transactionsjob`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `usersdetails`
--
ALTER TABLE `usersdetails`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accountstypes`
--
ALTER TABLE `accountstypes`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cashbook`
--
ALTER TABLE `cashbook`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `currencys`
--
ALTER TABLE `currencys`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `customerinvoicegenaration`
--
ALTER TABLE `customerinvoicegenaration`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `floors`
--
ALTER TABLE `floors`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `homecurrency`
--
ALTER TABLE `homecurrency`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `invoicegenaration`
--
ALTER TABLE `invoicegenaration`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `journals`
--
ALTER TABLE `journals`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `mainaccounts`
--
ALTER TABLE `mainaccounts`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

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

--
-- AUTO_INCREMENT for table `otheraccounts`
--
ALTER TABLE `otheraccounts`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `propertydetails`
--
ALTER TABLE `propertydetails`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `rates`
--
ALTER TABLE `rates`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `subaccounts`
--
ALTER TABLE `subaccounts`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tax`
--
ALTER TABLE `tax`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tenants`
--
ALTER TABLE `tenants`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT for table `transactionsjob`
--
ALTER TABLE `transactionsjob`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usersdetails`
--
ALTER TABLE `usersdetails`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;
