PNG  IHDR;IDATxܻn0K )(pA 7LeG{ §㻢|ذaÆ 6lذaÆ 6lذaÆ 6lom$^yذag5bÆ 6lذaÆ 6lذa{ 6lذaÆ `}HFkm,mӪôô! x|'ܢ˟;E:9&ᶒ}{v]n&6 h_tڠ͵-ҫZ;Z$.Pkž)!o>}leQfJTu іچ\X=8Rن4`Vwl>nG^is"ms$ui?wbs[m6K4O.4%/bC%t Mז -lG6mrz2s%9s@-k9=)kB5\+͂Zsٲ Rn~GRC wIcIn7jJhۛNCS|j08yiHKֶۛkɈ+;SzL/F*\Ԕ#"5m2[S=gnaPeғL lذaÆ 6l^ḵaÆ 6lذaÆ 6lذa; _ذaÆ 6lذaÆ 6lذaÆ RIENDB` -- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 19, 2021 at 07:53 PM -- Server version: 10.4.11-MariaDB -- PHP Version: 7.2.31 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: `dhhl_soft` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- CREATE TABLE `accounts` ( `id` int(11) NOT NULL, `reference_id` int(11) NOT NULL, `member_id` int(11) DEFAULT NULL, `sell_id` int(11) DEFAULT NULL, `company_log` double DEFAULT NULL, `reference_log` double DEFAULT NULL, `updated_at` datetime NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `accounts` -- INSERT INTO `accounts` (`id`, `reference_id`, `member_id`, `sell_id`, `company_log`, `reference_log`, `updated_at`, `created_at`) VALUES (112, 31, 46, 113, 9937999.99, 60000, '2021-08-09 16:27:08', '2021-07-01 14:54:32'), (113, 32, 47, 114, 556633.75, 585, '2021-07-08 17:09:18', '2021-07-07 15:00:28'), (114, 32, 48, 115, 262000, NULL, '2021-07-08 17:08:32', '2021-07-07 16:11:11'), (115, 32, 47, 116, 1900000, 100000, '2021-07-08 16:39:03', '2021-07-08 16:30:22'), (116, 32, 48, 117, 75000, NULL, '2021-07-08 16:52:45', '2021-07-08 16:52:45'), (117, 31, 46, 118, 60000, NULL, '2021-07-11 11:05:22', '2021-07-11 11:05:22'), (119, 33, 49, 121, 2040000, NULL, '2021-07-11 14:46:00', '2021-07-11 14:37:36'), (120, 33, 49, 122, 150000, NULL, '2021-07-11 14:52:06', '2021-07-11 14:51:27'), (121, 33, 49, 123, 25000, NULL, '2021-08-07 10:24:51', '2021-08-07 10:24:51'), (122, 32, 47, 124, 90000, NULL, '2021-08-07 15:06:40', '2021-08-07 12:10:39'), (124, 34, 50, 126, 805000, NULL, '2021-08-07 18:31:58', '2021-08-07 15:26:15'), (125, 34, 50, 127, 794000, NULL, '2021-08-07 18:47:02', '2021-08-07 18:36:19'), (126, 34, 50, 128, 110000, NULL, '2021-08-07 20:35:26', '2021-08-07 19:34:59'), (127, 32, 47, 129, NULL, NULL, '2021-08-09 07:48:42', '2021-08-09 07:48:42'), (128, 31, 46, 130, 70000, NULL, '2021-08-19 15:11:54', '2021-08-19 15:11:54'), (129, 31, 46, 134, 70000, NULL, '2021-08-19 17:42:05', '2021-08-19 17:42:05'); -- -------------------------------------------------------- -- -- Table structure for table `banks` -- CREATE TABLE `banks` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ac_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `current_balance` double DEFAULT NULL, `after_dp_balance` double DEFAULT NULL, `after_wd_balance` double DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `banks` -- INSERT INTO `banks` (`id`, `name`, `ac_number`, `slip_no`, `current_balance`, `after_dp_balance`, `after_wd_balance`, `status`, `created_at`, `updated_at`) VALUES (15, 'Pubali Bank', '234567890', NULL, 223000, 500000, 223000, 0, '2021-07-07 19:10:51', '2021-07-07 20:30:08'), (16, 'Jamuna Bank', '21343789845', NULL, 175000, 175000, 175000, 0, '2021-07-07 19:11:23', '2021-08-09 01:40:04'); -- -------------------------------------------------------- -- -- Table structure for table `bank_withdraws` -- CREATE TABLE `bank_withdraws` ( `id` bigint(20) UNSIGNED NOT NULL, `bank_id` int(10) UNSIGNED NOT NULL, `amount` double NOT NULL, `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bank_withdraws` -- INSERT INTO `bank_withdraws` (`id`, `bank_id`, `amount`, `slip_no`, `status`, `created_at`, `updated_at`) VALUES (21, 15, 250000, 'xfdffgv435455', 0, '2021-07-01 04:00:00', '2021-07-07 20:24:55'), (22, 15, 27000, 'dfd4665', 0, '2021-07-04 04:00:00', '2021-07-07 20:30:08'), (23, 16, 25000, 'ef445ffd', 0, '2021-06-17 04:00:00', '2021-07-07 20:35:15'), (24, 16, 50000, 'dr43dffdf', 0, '2021-06-30 04:00:00', '2021-07-07 20:35:48'); -- -------------------------------------------------------- -- -- Table structure for table `baynas` -- CREATE TABLE `baynas` ( `id` bigint(20) UNSIGNED NOT NULL, `donor_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `land_volume` double DEFAULT NULL, `stain_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ledger` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shotok_price` double DEFAULT NULL, `total_price` double DEFAULT NULL, `reference_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_file_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dolil_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `paid_amount` double DEFAULT NULL, `deu_amount` double DEFAULT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp(), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `baynas` -- INSERT INTO `baynas` (`id`, `donor_name`, `land_volume`, `stain_number`, `ledger`, `shotok_price`, `total_price`, `reference_name`, `reference_file_no`, `dolil_no`, `details`, `paid_amount`, `deu_amount`, `date`, `created_at`, `updated_at`) VALUES (1, 'Shubhra', 120, '43598jdkf', 'sdhfkjs', 6, 720, NULL, NULL, 'aVX RRR 555d ds', NULL, 67544, -66824, '2021-06-29 19:19:47', '2020-03-03 12:01:41', '2021-02-03 16:15:16'), (2, 'AAA ss', 50, 'aaaaaaaac cccccc', 'aVX RRR 555 dsd', 10, 500, 'Tasnim cc', 'aVX RRR 555 ds', 'aVX RRR 555d ds', 'gdgrc dsd', 100, 400, '2021-06-24 18:00:00', '2021-06-29 13:53:11', '2021-06-29 14:03:12'), (3, 'AAA ss', 50, 'gdg fgd', 'aVX RRR 555', 3, 150, 'Tasnima', 'aVX RRR 555', 'aVX RRR 555', 'fdsfs gds', 60, NULL, '2021-07-01 04:00:00', '2021-07-01 19:46:13', '2021-07-01 19:46:13'), (4, 'AAA ss', 50, 'bgb fg', 'aVX RRR 555', 3, 150, 'Das', 'aVX RRR 555', 'aVX RRR 555', 'gtg', 40, NULL, '2021-07-11 04:00:00', '2021-07-01 19:48:20', '2021-07-01 19:48:20'), (5, 'ali akbar', 12.5, '313', '225', 190000, 2375000, 'masum billah', '20', 'dffe3456666', 'rrrgre brer rgrgr', 300000, 2075000, '2021-07-07 04:00:00', '2021-07-07 20:50:25', '2021-07-07 20:50:25'), (6, 'AAA', 50, 'axdas', 'aVX RRR 555', 3, 150, 'Tasnim', NULL, 'aVX RRR 555d ds', 'sda', 40, 110, '2021-08-17 18:00:00', '2021-08-08 06:43:01', '2021-08-08 06:43:01'); -- -------------------------------------------------------- -- -- Table structure for table `blocks` -- CREATE TABLE `blocks` ( `id` int(11) NOT NULL, `block_no` int(11) DEFAULT NULL, `title` varchar(255) NOT NULL, `booking_amount` double NOT NULL, `installment_amount` double NOT NULL, `ekkalin_amount` double NOT NULL, `status` int(11) DEFAULT NULL, `updated_at` datetime NOT NULL, `created_at` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `blocks` -- INSERT INTO `blocks` (`id`, `block_no`, `title`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `status`, `updated_at`, `created_at`) VALUES (16, 1, 'Standerd', 100000, 10, 40, 0, '2021-07-01 14:44:33', '2021-07-01 14:43:44'), (17, 2, 'Block A', 0, 0, 0, 0, '2021-07-07 16:06:31', '2021-07-07 12:33:52'), (18, 3, 'Duplex', 35000, 8, 15, 0, '2021-07-08 16:50:53', '2021-07-07 16:06:13'), (19, 4, 'Demo Block 01', 10000, 10, 40, 0, '2021-08-07 15:15:25', '2021-07-11 14:07:02'); -- -------------------------------------------------------- -- -- Table structure for table `booking_amounts` -- CREATE TABLE `booking_amounts` ( `id` int(11) NOT NULL, `member_id` int(11) DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `sales_id` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `company_log` double DEFAULT NULL, `refference_log` double DEFAULT NULL, `due` double DEFAULT NULL, `date` datetime DEFAULT NULL, `book_no` int(11) DEFAULT NULL, `remark` text DEFAULT NULL, `money_rec` text DEFAULT NULL, `sale_no` int(11) DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `booking_amounts` -- INSERT INTO `booking_amounts` (`id`, `member_id`, `serial_id`, `reference_id`, `sales_id`, `amount`, `company_log`, `refference_log`, `due`, `date`, `book_no`, `remark`, `money_rec`, `sale_no`, `isDelete`, `status`, `created_at`, `updated_at`) VALUES (4, 50, 5, 34, 126, 50000, NULL, NULL, 200000, '2021-08-07 00:00:00', NULL, 'booking no 1', '12345', NULL, NULL, NULL, '2021-08-07 09:28:46', '2021-08-07 09:28:46'), (5, 50, 5, 34, 126, 10000, NULL, NULL, 190000, '2021-08-07 00:00:00', NULL, 'booking no 2', '4545', NULL, NULL, NULL, '2021-08-07 09:46:02', '2021-08-07 09:46:02'), (6, 50, 5, 34, 126, 190000, NULL, NULL, 0, '2021-08-14 00:00:00', NULL, 'booking no 3', '124', 12, NULL, NULL, '2021-08-07 10:03:46', '2021-08-07 10:03:46'), (7, 50, 5, 34, 127, 10000, NULL, NULL, 240000, '2021-08-09 00:00:00', NULL, 'booking no 1', '33434', 13, NULL, NULL, '2021-08-07 12:42:11', '2021-08-07 12:42:11'), (8, 50, 5, 34, 127, 240000, NULL, NULL, 0, '2021-08-11 00:00:00', NULL, 'booking no 2', '33434', 13, NULL, NULL, '2021-08-07 12:45:41', '2021-08-07 12:45:41'), (9, 50, 5, 34, 128, 50000, NULL, NULL, 200000, '2021-08-08 00:00:00', NULL, 'xus b 1', '2', 14, NULL, NULL, '2021-08-07 14:35:26', '2021-08-07 14:35:26'); -- -------------------------------------------------------- -- -- Table structure for table `booking_forms` -- CREATE TABLE `booking_forms` ( `id` int(11) NOT NULL, `member_id` int(11) DEFAULT NULL, `mem_signature` text DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `sale_id` int(11) DEFAULT NULL, `name` text DEFAULT NULL, `so` text DEFAULT NULL, `mother` text DEFAULT NULL, `dob` text DEFAULT NULL, `profession` text DEFAULT NULL, `religion` text DEFAULT NULL, `present_address` text DEFAULT NULL, `permanent_address` text DEFAULT NULL, `mobile` text DEFAULT NULL, `office` text DEFAULT NULL, `res` text DEFAULT NULL, `email` text DEFAULT NULL, `n_name` text DEFAULT NULL, `n_so` text DEFAULT NULL, `n_address` text DEFAULT NULL, `n_relation` text DEFAULT NULL, `nationality` text DEFAULT NULL, `n_nationality` text DEFAULT NULL, `n_dob` text DEFAULT NULL, `nominee_pic` text DEFAULT NULL, `ref` text DEFAULT NULL, `ref_signature` text DEFAULT NULL, `check_no` text DEFAULT NULL, `name_project` text DEFAULT NULL, `bank` text DEFAULT NULL, `branch` text DEFAULT NULL, `date` text DEFAULT NULL, `tk` text DEFAULT NULL, `tk_word` text DEFAULT NULL, `auth_date` text DEFAULT NULL, `app_date` text DEFAULT NULL, `down_pay` text DEFAULT NULL, `block` text DEFAULT NULL, `block_no` int(11) DEFAULT NULL, `plot_no` int(11) DEFAULT NULL, `face` varchar(191) DEFAULT NULL, `road` varchar(191) DEFAULT NULL, `plot_size` varchar(191) DEFAULT NULL, `ins` text DEFAULT NULL, `booking` int(11) DEFAULT NULL, `rate_per` double DEFAULT NULL, `total_rate` double DEFAULT NULL, `ins_no` int(11) DEFAULT NULL, `ins_am` double DEFAULT NULL, `one` text DEFAULT NULL, `file_no` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `booking_forms` -- INSERT INTO `booking_forms` (`id`, `member_id`, `mem_signature`, `serial_id`, `sale_id`, `name`, `so`, `mother`, `dob`, `profession`, `religion`, `present_address`, `permanent_address`, `mobile`, `office`, `res`, `email`, `n_name`, `n_so`, `n_address`, `n_relation`, `nationality`, `n_nationality`, `n_dob`, `nominee_pic`, `ref`, `ref_signature`, `check_no`, `name_project`, `bank`, `branch`, `date`, `tk`, `tk_word`, `auth_date`, `app_date`, `down_pay`, `block`, `block_no`, `plot_no`, `face`, `road`, `plot_size`, `ins`, `booking`, `rate_per`, `total_rate`, `ins_no`, `ins_am`, `one`, `file_no`, `created_at`, `updated_at`) VALUES (10, 46, NULL, 1, 113, 'Tom Riddle', 'Riddle', 'Riddle', '01-07-2021', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', 'No information', 'No information', 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, 'No information', 'DREAM GREEN CITY', 'No information', 'No information', 'No information', 'No information', 'No information', 'No information', 'No information', 'No information', 'Standerd', 1, NULL, 'north', '6', '10', NULL, 60000, 0, NULL, 3, 3312333.33, 'No information', 1, '2021-07-01 14:54:32', '2021-08-19 14:17:51'), (11, 47, NULL, 2, 114, 'Sharif Molla', 'Md. Karim', 'Kamrunnesa', '1980-07-31', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', NULL, NULL, 'sharif@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'south', 'Main', '5', NULL, 500000, 0, NULL, 128, 11718.75, NULL, 2, '2021-07-07 15:00:28', '2021-07-07 15:00:28'), (12, 48, NULL, 3, 115, 'karim', 'gfgfggfg', 'fdfdf', '1984-01-02', 'Business', 'islam', 'aww23 332e9gg,ff fgfg', 'aww23 332e9gg,ff fgfg', '01521125086', NULL, NULL, 'karim@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Duplex', 3, NULL, 'west', 'Main', '5', NULL, 250000, 0, NULL, 96, 23437.5, NULL, 3, '2021-07-07 16:11:11', '2021-07-07 16:11:11'), (13, 47, NULL, 2, 116, 'Sharif Molla', 'Md. Karim', 'Kamrunnesa', '1980-07-31', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', NULL, NULL, 'sharif@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Block A', 2, NULL, 'north', 'Sub-04/N-01', '5', NULL, 2000000, 0, NULL, NULL, 0, NULL, 4, '2021-07-08 16:30:22', '2021-07-08 16:30:22'), (14, 48, NULL, 3, 117, 'karim', 'gfgfggfg', 'fdfdf', '1984-01-02', 'Business', 'islam', 'aww23 332e9gg,ff fgfg', 'aww23 332e9gg,ff fgfg', '01521125086', NULL, NULL, 'karim@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Duplex', 3, NULL, 'south', 'Sub-09/N-01', '3', NULL, 75000, 0, NULL, 72, 15625, NULL, 5, '2021-07-08 16:52:45', '2021-07-08 16:52:45'), (15, 46, NULL, 1, 118, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Duplex', 3, NULL, 'south', 'Sub-09/N-01', '3', NULL, 60000, 0, NULL, 10, 293700, NULL, 6, '2021-07-11 11:05:22', '2021-07-11 11:05:22'), (16, 46, NULL, 1, 119, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Standerd', 1, NULL, 'north', '5', '10', NULL, 60000, 0, NULL, 10, 994000, NULL, 7, '2021-07-11 11:07:16', '2021-07-11 11:07:16'), (17, 49, NULL, 4, 121, 'From new', 'From', 'From', '1997-01-08', 'Vampire', 'islam', 'From', 'From', '55876685765', NULL, NULL, 'from@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'north', 'Road no:01', '10', NULL, 50000, 0, NULL, 5, 1990000, NULL, 8, '2021-07-11 14:37:36', '2021-07-11 14:37:36'), (18, 49, NULL, 4, 122, 'From new', 'From', 'From', '1997-01-08', 'Vampire', 'islam', 'From', 'From', '55876685765', NULL, NULL, 'from@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'north', 'Road no:01', '10', NULL, 50000, 0, NULL, 5, 1990000, NULL, 9, '2021-07-11 14:51:27', '2021-07-11 14:51:27'), (19, 49, NULL, 4, 123, 'From new', 'From', 'From', '1997-01-08', 'Vampire', 'islam', 'From', 'From', '55876685765', NULL, NULL, 'from@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'north', 'Road no:01', '10', NULL, 25000, 0, NULL, 10, 997500, NULL, 10, '2021-08-07 10:24:51', '2021-08-07 10:24:51'), (20, 47, NULL, 2, 124, 'Sharif Molla', 'Md. Karim', 'Kamrunnesa', '1980-07-31', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', NULL, NULL, 'sharif@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'north', 'Road no:01', '10', NULL, 60000, 0, NULL, 10, 994000, NULL, 11, '2021-08-07 12:10:40', '2021-08-07 12:10:40'), (21, 50, NULL, 5, 125, 'Demo member 1', 'bggv', 'Riddle', '2021-08-07', 'job', 'islam', 'axassdwd', 'axassdwd', '55876685765', NULL, NULL, 'demotkt@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'north', '5', '5', NULL, 60000, 0, NULL, 10, 494000, NULL, 12, '2021-08-07 15:21:16', '2021-08-07 15:21:16'), (22, 50, NULL, 5, 126, 'Demo member 1', 'bggv', 'Riddle', '2021-08-07', 'job', 'islam', 'axassdwd', 'axassdwd', '55876685765', NULL, NULL, 'demotkt@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'north', '5', '5', NULL, 60000, 0, NULL, 10, 494000, NULL, 12, '2021-08-07 15:26:15', '2021-08-07 15:26:15'), (23, 50, NULL, 5, 127, 'Demo member 1', 'bggv', 'Riddle', '2021-08-07', 'job', 'islam', 'axassdwd', 'axassdwd', '55876685765', NULL, NULL, 'demotkt@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'north', '5', '5', NULL, 50000, 0, NULL, 10, 494000, NULL, 13, '2021-08-07 18:36:19', '2021-08-07 18:36:19'), (24, 50, NULL, 5, 128, 'Demo member 1', 'bggv', 'Riddle', '2021-08-07', 'job', 'islam', 'axassdwd', 'axassdwd', '55876685765', NULL, NULL, 'demotkt@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'north', '5', '5', NULL, 60000, 0, NULL, 10, 494000, NULL, 14, '2021-08-07 19:35:00', '2021-08-07 19:35:00'), (25, 47, NULL, 2, 129, 'Sharif Molla', 'Md. Karim', 'Kamrunnesa', '1980-07-31', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', NULL, NULL, 'sharif@gmail.com', NULL, NULL, NULL, NULL, 'Bangladeshi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Demo Block 01', 4, NULL, 'south', '5', '3.5', NULL, NULL, 0, NULL, NULL, 0, NULL, 15, '2021-08-09 07:48:42', '2021-08-09 07:48:42'), (26, 46, NULL, 1, 130, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Standerd', 1, NULL, 'north', '6', '10', NULL, 70000, 0, NULL, 10, 92400, NULL, 1, '2021-08-19 15:11:54', '2021-08-19 15:11:54'), (27, 46, NULL, 1, 134, 'Tom Riddle', 'Riddle', 'Riddle', '2021-07-01', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', NULL, NULL, 'tom@gmail.com', NULL, NULL, NULL, NULL, 'American', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Standerd', 1, NULL, 'north', '6', '10', NULL, 70000, 0, NULL, 10, 92400, NULL, 5, '2021-08-19 17:42:06', '2021-08-19 17:42:06'); -- -------------------------------------------------------- -- -- Table structure for table `commision_plans` -- CREATE TABLE `commision_plans` ( `id` int(11) NOT NULL, `booking_amount` double NOT NULL, `installment_amount` double NOT NULL, `ekkalin_amount` double NOT NULL, `block_id` int(11) NOT NULL, `block_title` varchar(255) NOT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `commision_plans` -- INSERT INTO `commision_plans` (`id`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `block_id`, `block_title`, `status`, `created_at`, `updated_at`) VALUES (46, 100000, 20, 40, 15, 'Block A', 1, '2021-06-20 13:57:49', '2021-07-01 18:44:17'), (47, 100000, 10, 40, 16, 'Standerd', 0, '2021-07-01 18:44:33', '2021-07-01 18:44:33'), (48, 20000, 5, 10, 17, 'Block A', 0, '2021-07-07 16:34:55', '2021-07-07 19:46:58'), (49, 35000, 8, 15, 18, 'Duplex', 0, '2021-07-07 20:07:56', '2021-07-08 20:50:53'), (50, 20000, 10, 40, 19, 'Demo Block 01', 0, '2021-07-11 08:11:45', '2021-07-11 10:25:15'), (51, 10000, 10, 40, 19, 'Demo Block 01', 0, '2021-08-07 09:15:25', '2021-08-07 09:15:25'); -- -------------------------------------------------------- -- -- Table structure for table `companies` -- CREATE TABLE `companies` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `address` text COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `quote` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `companies` -- INSERT INTO `companies` (`id`, `name`, `mobile`, `address`, `logo`, `email`, `quote`, `created_at`, `updated_at`) VALUES (1, 'DREAM HEAVEN HOUSING LTD.', 'Tel: 02-9512433, Mobile: 01915-618117', '5B-1,Ittefaq Bhaban,1,R.K Mission Road,Dhaka-1203', 'logo/OwVRGaogm0VSkK6KELR5DMchN3dzhL5IOCY7tJup.png', 'dreamgreencity@gmail.com www.dhhl.ltd', '5B-1 ittefaq Bhaban, 1 R.K Mission Road, Wari, Dhaka - 1203', '2020-03-03 12:19:38', '2021-07-10 10:36:37'); -- -------------------------------------------------------- -- -- Table structure for table `custom_bookings` -- CREATE TABLE `custom_bookings` ( `id` int(11) NOT NULL, `amount` double DEFAULT NULL, `remark` text DEFAULT NULL, `money_rec` text DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `member_id` int(11) DEFAULT NULL, `sales_id` int(11) DEFAULT NULL, `date` datetime DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `due` double DEFAULT NULL, `company_log` double DEFAULT NULL, `refference_log` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `custom_bookings` -- INSERT INTO `custom_bookings` (`id`, `amount`, `remark`, `money_rec`, `isDelete`, `created_at`, `updated_at`, `member_id`, `sales_id`, `date`, `serial_id`, `reference_id`, `due`, `company_log`, `refference_log`) VALUES (1, 50000, 'xus b 1', '2', 1, '2021-08-07 13:49:42', '2021-08-07 14:35:26', 50, 128, '2021-08-08 00:00:00', 5, 34, 200000, 110000, NULL); -- -------------------------------------------------------- -- -- Table structure for table `custom_installments` -- CREATE TABLE `custom_installments` ( `id` bigint(11) NOT NULL, `amount` double DEFAULT NULL, `remark` text DEFAULT NULL, `via` text DEFAULT NULL, `bank_name` text DEFAULT NULL, `image` text DEFAULT NULL, `account_no` text DEFAULT NULL, `money_rec` text DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL, `member_id` int(11) NOT NULL, `saled_id` int(11) DEFAULT NULL, `date` datetime DEFAULT NULL, `serial_id` int(11) NOT NULL, `reference_id` int(11) NOT NULL, `due` double NOT NULL, `ins_no` int(11) DEFAULT NULL, `company_log` double DEFAULT NULL, `refference_log` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `demo_installments` -- CREATE TABLE `demo_installments` ( `id` bigint(20) NOT NULL, `member_id` int(11) DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `reference_id` int(11) DEFAULT NULL, `sales_id` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `company_log` double DEFAULT NULL, `refference_log` double DEFAULT NULL, `due` double DEFAULT NULL, `date` date DEFAULT NULL, `ins_no` int(11) DEFAULT NULL, `remark` text DEFAULT NULL, `via` text DEFAULT NULL, `bank_name` text DEFAULT NULL, `image` text DEFAULT NULL, `account_no` text DEFAULT NULL, `money_rec` text DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `demo_installments` -- INSERT INTO `demo_installments` (`id`, `member_id`, `serial_id`, `reference_id`, `sales_id`, `amount`, `company_log`, `refference_log`, `due`, `date`, `ins_no`, `remark`, `via`, `bank_name`, `image`, `account_no`, `money_rec`, `isDelete`, `created_at`, `updated_at`) VALUES (40, 46, 1, 31, 113, 3312333.33, 3312333.33, NULL, 3315333.34, '2021-07-07', 2, 'installment no 2', 'bank', 'city bank', 'members/kVXiRuJJlLRe8gzY1o9XbZIhtLm27mkZy0QeLN6u.jpeg', '2222222222222 444', '11111', 2, '2021-07-01 23:39:55', '2021-07-01 23:40:17'), (41, 46, 1, 31, 113, 3312333.33, 3312333.33, NULL, 3315333.34, '2021-07-14', 2, NULL, 'nagad', NULL, '', '2222222222222', '11111', 1, '2021-07-01 23:40:47', '2021-07-01 23:41:05'), (42, 46, 1, 31, 113, 3312333.33, 3312333.33, NULL, 3000.0099999997765, '2021-06-28', 3, NULL, 'bank', 'Jamuna', 'members/oQdRFd58tffWZWShtw9XIk0OsoiC47G46CHTCWQ2.jpeg', '35788765443223', NULL, 1, '2021-07-07 16:06:29', '2021-07-07 16:42:32'), (43, 47, 2, 32, 114, 15000, 15000, NULL, 1462781.25, '2021-07-28', 3, NULL, 'bank', 'Pubali', 'members/NnC9EFuLXKDOTfuEFGi4a1WvA2efTPujkFOiZznw.jpeg', '46667777755', NULL, 1, '2021-07-08 19:51:46', '2021-07-08 19:53:06'), (44, 49, 4, 33, 122, 1990000, 1990000, NULL, 7860000, '2021-07-11', 2, NULL, 'bkash', NULL, '', '2222222222222', '11111', 0, '2021-07-11 09:31:31', '2021-07-11 09:31:31'); -- -------------------------------------------------------- -- -- Table structure for table `deposits` -- CREATE TABLE `deposits` ( `id` bigint(20) UNSIGNED NOT NULL, `slip_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_id` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `deposits` -- INSERT INTO `deposits` (`id`, `slip_no`, `bank_id`, `amount`, `status`, `created_at`, `updated_at`) VALUES (20, '354545rt', 15, 500000, 0, '2021-06-07 04:00:00', '2021-07-07 20:21:45'), (21, '565787', 16, 250000, 0, '2021-06-29 04:00:00', '2021-07-07 20:22:53'); -- -------------------------------------------------------- -- -- Table structure for table `expences` -- CREATE TABLE `expences` ( `id` bigint(20) UNSIGNED NOT NULL, `expence_head_id` int(10) UNSIGNED NOT NULL, `date` date DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `amount` double DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `expences` -- INSERT INTO `expences` (`id`, `expence_head_id`, `date`, `description`, `note`, `amount`, `isDelete`, `created_at`, `updated_at`) VALUES (2, 6, '2020-03-04', 'CNG Refuel', 'fef', 768, 0, '2020-03-04 04:26:51', '2021-06-21 12:08:18'), (6, 4, '2021-03-11', 'Mr - lksij\r\nklsjdoj\r\nlkasjdjasd', 'korim rigestruy ভালু না । রা', 100000, 0, '2021-03-11 16:09:20', '2021-03-11 16:11:04'), (7, 5, '2021-03-21', 'alu , si 1 , kjsadhniiaskdn', 'lkjasdkjnid', 500000, 0, '2021-03-21 12:29:41', '2021-03-21 12:29:41'), (8, 5, '2021-03-22', 'kgnb', 'kighkjgh', 100000, 0, '2021-03-21 12:30:06', '2021-03-21 12:30:06'), (10, 7, '2021-03-20', '2 days Vehicle Gas', NULL, 1735, 0, '2021-03-22 12:20:13', '2021-03-22 12:20:13'), (11, 8, '2021-03-20', 'Office Mobile Recharge', 'Imtiaj', 100, 0, '2021-03-22 12:25:49', '2021-03-22 12:25:49'), (17, 11, '2021-06-07', NULL, NULL, 375000, 0, '2021-06-07 13:31:13', '2021-06-07 13:31:13'), (18, 5, '2021-06-21', 'Note', 'Note', 700, 0, '2021-06-21 05:35:31', '2021-07-01 19:22:49'), (19, 7, '2021-06-05', 'Oil + Gas = 700 +400', NULL, 1100, NULL, '2021-07-07 15:31:43', '2021-07-07 15:31:43'), (20, 7, '2021-06-17', 'Oil', NULL, 755, NULL, '2021-07-07 15:32:14', '2021-07-07 15:32:14'), (21, 7, '2021-06-25', 'Gas', NULL, 972, NULL, '2021-07-07 15:32:59', '2021-07-07 15:32:59'), (22, 7, '2021-07-05', 'Gas + Toll', NULL, 1165, NULL, '2021-07-07 15:33:54', '2021-07-07 15:33:54'); -- -------------------------------------------------------- -- -- Table structure for table `expence_heads` -- CREATE TABLE `expence_heads` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `expence_heads` -- INSERT INTO `expence_heads` (`id`, `name`, `slug`, `isDelete`, `created_at`, `updated_at`) VALUES (13, 'Hermione Granger', 'hermione-granger', 1, '2021-06-21 12:07:35', '2021-06-21 12:07:40'), (4, 'Land purchaseew', 'land-purchaseew', 0, '2021-03-11 15:53:30', '2021-06-21 12:07:48'), (5, 'Comission', 'comission', 0, '2021-03-21 12:28:28', '2021-03-21 12:28:28'), (6, 'interest', 'interest', 0, '2021-03-21 13:25:40', '2021-03-21 13:25:40'), (7, 'Vechile Gas', 'vechile-gas', 0, '2021-03-22 12:18:06', '2021-03-22 12:18:06'), (8, 'Office Mobile Bill', 'office-mobile-bill', 0, '2021-03-22 12:24:23', '2021-03-22 12:24:23'), (10, 'Land Purchase', 'land-purchase', 0, '2021-06-07 10:53:25', '2021-06-07 10:53:25'), (11, 'Land Purchase File No. 19 Investor name: Ahmed Loan - 500000', 'land-purchase-file-no-19-investor-name-ahmed-loan-500000', 0, '2021-06-07 13:30:42', '2021-06-07 13:30:42'), (12, 'Land Purchase File No. 19 Marketer Commission - 62500', 'land-purchase-file-no-19-marketer-commission-62500', 0, '2021-06-07 13:33:09', '2021-06-07 13:33:09'); -- -------------------------------------------------------- -- -- Table structure for table `incomes` -- CREATE TABLE `incomes` ( `id` int(11) NOT NULL, `income_head_id` int(11) DEFAULT NULL, `date` date DEFAULT NULL, `description` text DEFAULT NULL, `note` text DEFAULT NULL, `amount` double DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `incomes` -- INSERT INTO `incomes` (`id`, `income_head_id`, `date`, `description`, `note`, `amount`, `isDelete`, `created_at`, `updated_at`) VALUES (3, 1, '2021-06-21', 'fdf', 'sfsdf', 50000, 0, '2021-06-21 11:34:01', '2021-06-21 11:34:01'), (5, 5, '2021-06-28', 'fdfsf', 'sfef', 99000, 0, '2021-06-28 18:09:17', '2021-06-28 18:09:17'), (6, 6, '2021-07-06', 'Billal Hossain (992)File No:192', NULL, 75000, 0, '2021-07-06 16:58:54', '2021-07-06 16:58:54'), (7, 6, '2021-06-25', 'Booking. Hasan (885), File No: 187', NULL, 125000, 0, '2021-07-06 17:00:44', '2021-07-06 17:00:44'), (8, 7, '2021-06-05', 'Ins. Md. Shafiq (889) File No: 174', NULL, 17500, 0, '2021-07-06 17:01:48', '2021-07-06 17:10:16'), (10, 7, '2021-07-03', 'Ggfhj 655 hggg 665', NULL, 30000, 0, '2021-07-06 17:08:47', '2021-07-06 17:08:47'), (11, 7, '2021-06-30', 'Ins. Karim (765) File No: 21', NULL, 14500, 0, '2021-07-07 11:27:10', '2021-07-07 11:27:10'), (12, 8, '2021-07-08', 'Md, Abdus Salam', 'As Director', 2000000, 0, '2021-07-08 17:15:36', '2021-07-08 17:15:36'), (13, 9, '2021-07-08', 'file no. 33, Reference : Md. Abdus Salam', NULL, 26000, 0, '2021-07-08 17:17:00', '2021-07-08 17:17:00'), (14, 10, '2021-07-08', 'Karimullah', NULL, 350000, 0, '2021-07-08 17:17:31', '2021-07-08 17:17:31'); -- -------------------------------------------------------- -- -- Table structure for table `income_heads` -- CREATE TABLE `income_heads` ( `id` int(11) NOT NULL, `name` text DEFAULT NULL, `slug` text DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `income_heads` -- INSERT INTO `income_heads` (`id`, `name`, `slug`, `isDelete`, `created_at`, `updated_at`) VALUES (1, 'The vinchissd dddds', 'the-vinchissd-dddds', 0, '2021-06-21 10:09:35', '2021-06-21 18:46:02'), (2, 'asas', 'asas', 1, '2021-06-21 10:09:41', '2021-06-21 10:14:56'), (3, 'Demon Salvator', 'demon-salvator', 1, '2021-06-21 17:56:25', '2021-06-21 18:07:10'), (4, 'The vinchi', 'the-vinchi', 1, '2021-06-21 18:08:29', '2021-06-21 18:08:36'), (5, 'Hermione Granger', 'hermione-granger', 0, '2021-06-21 18:08:39', '2021-06-21 18:08:39'), (6, 'BOOKING', 'booking', 0, '2021-07-06 16:56:00', '2021-07-06 16:56:00'), (7, 'Installment', 'installment', 0, '2021-07-06 16:56:22', '2021-07-06 16:56:22'), (8, 'capital', 'capital', 0, '2021-07-08 17:11:45', '2021-07-08 17:11:45'), (9, 'Commission Return', 'commission-return', 0, '2021-07-08 17:12:41', '2021-07-08 17:12:41'), (10, 'loan received', 'loan-received', 0, '2021-07-08 17:13:06', '2021-07-08 17:13:06'); -- -------------------------------------------------------- -- -- Table structure for table `installments` -- CREATE TABLE `installments` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` int(10) UNSIGNED NOT NULL, `serial_id` int(11) DEFAULT NULL, `reference_id` int(11) NOT NULL, `sales_id` int(10) UNSIGNED NOT NULL, `amount` double DEFAULT NULL, `company_log` double UNSIGNED DEFAULT NULL, `refference_log` double UNSIGNED DEFAULT NULL, `due` double DEFAULT NULL, `date` date DEFAULT NULL, `ins_no` int(11) DEFAULT NULL, `remark` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `money_rec` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `updated_at` date DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `installments` -- INSERT INTO `installments` (`id`, `member_id`, `serial_id`, `reference_id`, `sales_id`, `amount`, `company_log`, `refference_log`, `due`, `date`, `ins_no`, `remark`, `money_rec`, `isDelete`, `status`, `created_at`, `updated_at`) VALUES (171, 46, 1, 31, 113, 3312333.33, 321233.333, 10000, 6624666.67, '2021-07-01', 1, 'installment no 1', '4545', NULL, NULL, '2021-07-01', '2021-07-01'), (172, 46, 1, 31, 113, 3312333.33, 3312333.33, NULL, 3315333.34, '2021-07-14', 2, NULL, '11111', NULL, NULL, '2021-07-01', '2021-07-01'), (173, 46, 1, 31, 113, 3312333.33, 3312333.33, NULL, 3000.0099999997765, '2021-06-28', 3, NULL, NULL, NULL, NULL, '2021-07-07', '2021-07-07'), (174, 47, 2, 32, 114, 11718.75, 0.9375, 585, 1488281.25, '2021-07-06', 1, 'cash', '1003', NULL, NULL, '2021-07-08', '2021-07-08'), (175, 47, 2, 32, 114, 10500, 10500, NULL, 1477781.25, '2021-07-17', 2, 'cash', '1009', NULL, NULL, '2021-07-08', '2021-07-08'), (176, 47, 2, 32, 114, 15000, 15000, NULL, 1462781.25, '2021-07-28', 3, NULL, NULL, NULL, NULL, '2021-07-08', '2021-07-08'), (177, 48, 3, 32, 115, 12000, 12000, NULL, 2238000, '2021-07-08', 1, 'cash', '1014', NULL, NULL, '2021-07-08', '2021-07-08'), (178, 47, 2, 32, 114, 20000, 20000, NULL, 1442781.25, '2021-07-08', 4, 'cash', '1025', NULL, NULL, '2021-07-08', '2021-07-08'), (179, 49, 4, 33, 121, 1990000, 1990000, NULL, 7960000, '2021-07-11', 1, 'installment no 1', '11111', NULL, NULL, '2021-07-11', '2021-07-11'), (180, 49, 4, 33, 122, 100000, 100000, NULL, 9850000, '2021-07-11', 1, 'installment no 1 1', '33434', NULL, NULL, '2021-07-11', '2021-07-11'), (181, 50, 5, 34, 126, 1000, 1000, NULL, 4689000, '2021-08-08', 1, 'installment no 1', '33434', NULL, NULL, '2021-08-07', '2021-08-07'), (182, 50, 5, 34, 126, 494000, 494000, NULL, 4445000, '2021-08-08', 2, 'installment no 2', '121212', NULL, NULL, '2021-08-07', '2021-08-07'), (183, 50, 5, 34, 127, 494000, 494000, NULL, 4206000, '2021-08-08', 1, 'installment no 1', '33434', NULL, NULL, '2021-08-07', '2021-08-07'), (184, 46, 1, 31, 113, 1000, 1000, NULL, 2000.0099999997765, '2021-08-09', 0, 'installment no 1', '11111', NULL, NULL, '2021-08-09', '2021-08-09'); -- -------------------------------------------------------- -- -- Table structure for table `land_purchases` -- CREATE TABLE `land_purchases` ( `id` bigint(20) UNSIGNED NOT NULL, `date` date DEFAULT NULL, `owner_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_file_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dolil_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rs_dag` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `land_poriman` double DEFAULT NULL, `commision_percentage` double DEFAULT NULL, `investor_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `investor_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `investor_total_invest` double DEFAULT NULL, `total_commision` double DEFAULT NULL, `investor_interest` double DEFAULT NULL, `investor_total_interest` double DEFAULT NULL, `investor_total_invest_1` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `registri_amount` double DEFAULT NULL, `total_fee` double DEFAULT NULL, `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shotok_price` double DEFAULT NULL, `total_price` double DEFAULT NULL, `paid_amount` double DEFAULT NULL, `deu_amount` double DEFAULT NULL, `ledger` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `land_purchases` -- INSERT INTO `land_purchases` (`id`, `date`, `owner_name`, `reference_name`, `reference_file_no`, `dolil_no`, `rs_dag`, `land_poriman`, `commision_percentage`, `investor_name`, `investor_number`, `investor_total_invest`, `total_commision`, `investor_interest`, `investor_total_interest`, `investor_total_invest_1`, `registri_amount`, `total_fee`, `details`, `shotok_price`, `total_price`, `paid_amount`, `deu_amount`, `ledger`, `status`, `created_at`, `updated_at`) VALUES (8, '2021-05-26', 'Anik', 'Das', '11', '77', '124', 10, 5, 'RRf', '1223455', 50, 50, 5, 83.33333333333334, NULL, 100, 263.33333333333337, 'No details', 3, 30, 40, 223.33333333333337, 'aaa', NULL, '2021-05-26 15:29:48', '2021-05-26 15:29:48'), (7, '2021-05-10', 'Angel', 'tA', '11', '44', '124', 10, 5, 'RR', '1223455', 50, 50, 5, 83.33333333333334, NULL, 100, 263.33333333333337, 'No details', 3, 30, 40, 223.33333333333337, 'aaa', NULL, '2021-05-10 12:21:50', '2021-05-10 12:22:37'), (9, '2021-06-02', 'aVX RRR 555', 'aVX RRR 555', 'aVX RRR 555', 'aVX RRR 555', 'aVX RRR 555 aVX RRR 555 aVX RRR 555', 10, 5, 'aVX RRR 555', 'aVX RRR 555', 50, 50, 5, 83.33333333333334, NULL, 100, 263.33333333333337, 'aVX RRR 555 aVX RRR 555aVX RRR 555', 3, 30, 40, 223.33333333333337, 'aVX RRR 555', NULL, '2021-06-02 10:53:13', '2021-06-02 10:53:13'), (10, '2021-06-03', 'Rokon', 'Sahjalal', '12', 'D5667 দেশে', '#নয়াদিল্লি: দেশে করোনা সংক্রমণে আশার খবর। বেশ কয়েকদিন ধরে লাগাতার কমতে থাকা সংক্রমণ অব্যাহত থাকল শনিবারও। গত ২৪ ঘণ্টায় দেশে নতুন করে করোনাভাইরাসে (India Coronavirus Update) আক্রান্ত হয়েছেন ১.১৪ লক্ষ মানুষ। একদিনে মৃত্যু হয়েছে ২,৬৬৭ জনের। কেন্দ্রীয় স্বাস্থ্যমন্ত্রক সূত্রে খবর, এখনও পর্যন্ত দেশে মোট করোনা আক্রান্তের সংখ্যা ২.৮৮ কোটি। দেশে করোনায় মৃত্যু হয়েছে ৩.৪৬ লক্ষ মানুষের। শনিবার প্রায় ২০ লক্ষ মানুষের করোনা পরীক্ষা করা হয়েছে। এই নিয়ে দেশে এখনও পর্যন্ত করোনা পরীক্ষা হয়েছে ৩৬,৪৭,৪৬,৫২২ জনের', 12.56, 4500, 'ahmed-50000 | Forkan-300000', '01919774996', 500000, 56520, 5000, 20833.333333333336, NULL, 34000, 1618553.3333333333, '#নয়াদিল্লি: দেশে করোনা সংক্রমণে আশার খবর। বেশ কয়েকদিন ধরে লাগাতার কমতে থাকা সংক্রমণ অব্যাহত থাকল শনিবারও। গত ২৪ ঘণ্টায় দেশে নতুন করে করোনাভাইরাসে (India Coronavirus Update) আক্রান্ত হয়েছেন ১.১৪ লক্ষ মানুষ। একদিনে মৃত্যু হয়েছে ২,৬৬৭ জনের। কেন্দ্রীয় স্বাস্থ্যমন্ত্রক সূত্রে খবর, এখনও পর্যন্ত দেশে মোট করোনা আক্রান্তের সংখ্যা ২.৮৮ কোটি। দেশে করোনায় মৃত্যু হয়েছে ৩.৪৬ লক্ষ মানুষের। শনিবার প্রায় ২০ লক্ষ মানুষের করোনা পরীক্ষা করা হয়েছে। এই নিয়ে দেশে এখনও পর্যন্ত করোনা পরীক্ষা হয়েছে ৩৬,৪৭,৪৬,৫২২ জনের', 120000, 1507200, 1618533, 20.333333333255723, 'দেশে করোনা সংক্রমণে আশার খ', NULL, '2021-06-06 11:56:14', '2021-06-07 13:36:15'), (11, '2021-06-07', 'Ali Akbar', 'Masum Billah', '19', '3436', '313', 12.5, 5000, 'Ahmmad Ali', '01712869532', 2375000, 62500, 5000, 62500, NULL, 56000, 2556000, 'Jomir Mullo Puratai Dewa Hoiche. Ahammad Ali sir Ar loan Porishod kora hoini.', 190000, 2375000, 2375000, 181000, '686', NULL, '2021-06-06 14:44:50', '2021-06-07 13:23:06'), (12, '2021-07-01', 'Anika', 'Tasnim', 'aVX RRR 555', 'aVX RRR 555', 'rtr grt', 10, 5, 'aVX RRR 555', '1223455', 50, 50, 5, 83.33333333333334, '65', 100, 263.33333333333337, 'gfgdg', 3, 30, 60, 203.33333333333337, 'aVX RRR 555', NULL, '2021-07-01 19:43:54', '2021-07-01 19:43:54'), (13, '2021-07-27', 'ali akbar', 'masum billah', '20', 'লিল 23254', '313', 12, 500, 'rahim-50000, karim-200000', '3', 200000, 6000, 500, 5263.1578947368425, NULL, 625, 239888.15789473685, NULL, 19000, 228000, 30000, 2414276.3157894737, '225', NULL, '2021-07-07 20:58:29', '2021-07-26 23:58:46'); -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nid` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `signature_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `serial_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_id` int(10) UNSIGNED NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `members` -- INSERT INTO `members` (`id`, `name`, `hus_father`, `nationality`, `birthday`, `mother`, `profession`, `religion`, `present_address`, `permanent_address`, `mobile`, `nid`, `email`, `created_at`, `updated_at`, `picture`, `signature_image`, `serial_id`, `reference_id`, `password`) VALUES (47, 'Sharif Molla', 'Md. Karim', 'Bangladeshi', '1980-07-31', 'Kamrunnesa', 'Probashi', 'islam', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', '01918873065', 'B765x4338', 'sharif@gmail.com', '2021-07-07 16:20:05', '2021-07-07 16:20:05', 'members/recniIJhDQYaY8RyYerzAEld7Yit3qYcwksr8SyV.jpeg', 'members/ektefSAQolTk90F4fJLWAbfllHR83nNgqUTdpSzH.jpeg', '000002', 32, '123456'), (46, 'Tom Riddle', 'Riddle', 'American', '2021-07-01', 'Riddle', 'Wizard', 'christian', 'Hogwarts', 'Hogwarts', '55876685765', 'cdcds 3333', 'tom@gmail.com', '2021-07-01 18:43:17', '2021-07-10 10:28:58', 'members/80ybyAFk6WFIKsLUOIQoxlZv29vkv6DhMDen0TAK.jpeg', 'members/5Kmu6wmqqbdBMqGLldtndDbf9KlvUzANVSQVNAaq.jpeg', '000001', 31, '123456'), (48, 'karim', 'gfgfggfg', 'Bangladeshi', '1984-01-02', 'fdfdf', 'Business', 'islam', 'aww23 332e9gg,ff fgfg', 'aww23 332e9gg,ff fgfg', '01521125086', '3433344225455', 'karim@gmail.com', '2021-07-07 20:01:59', '2021-07-07 20:01:59', 'members/CqH7fqYEobPpsp0bUv36RmMRlkPf5DWVKFIcwgGp.jpeg', 'members/YpyQoWXuaCZ2G6OYSl19FHuk3pK103nb1vxbr9eC.jpeg', '000003', 32, '123456'), (49, 'From new', 'From', 'American', '1997-01-08', 'From', 'Vampire', 'islam', 'From', 'From', '55876685765', 'cdcds 3333', 'from@gmail.com', '2021-07-11 08:14:47', '2021-07-11 08:14:47', 'members/Qlse5oUtNp9RuReBja2z22ZGEkdZfQxGqC9vEMW1.jpeg', 'members/F9TX6OvJJ0tFzOL5Rr4KvU9gckhM4wVkC3mvpPgu.jpeg', '000004', 33, '123456'), (50, 'Demo member 1', 'bggv', 'American', '1984-12-12', 'Riddle', 'job', 'islam', 'axassdwd', 'axassdwd', '55876685765', 'cdcds 3333', 'demotkt@gmail.com', '2021-08-07 09:14:29', '2021-08-08 10:37:12', 'members/lGP123t1u0EHEQOteOiKuODZ3oSuQoVpBjkmRqLi.jpeg', 'members/d0I9I6JMeEWq7hCM4EypBRmJurmTiScI8eCXzVBx.png', '000005', 34, '123456'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2020_01_31_143519_create_land_purchases_table', 1), (4, '2020_01_31_162552_create_members_table', 1), (5, '2020_01_31_190024_create_baynas_table', 1), (6, '2020_01_31_192032_create_plots_table', 1), (7, '2020_02_01_065631_create_banks_table', 1), (8, '2020_02_01_072110_create_deposits_table', 1), (9, '2020_02_01_082138_add_picture_to_member_table', 1), (10, '2020_02_01_103646_create_references_table', 1), (11, '2020_02_01_174219_create_nominees_table', 1), (12, '2020_02_02_151623_add_role_to_table_users', 1), (13, '2020_02_02_164945_create_expence_heads_table', 1), (14, '2020_02_02_165029_create_expences_table', 1), (15, '2020_02_04_151412_create_sales_table', 1), (16, '2020_02_04_154015_add_serial_id_to_members_table', 1), (17, '2020_02_21_045445_create_sub_memebers_table', 1), (18, '2020_02_21_062807_create_installments_table', 1), (19, '2020_02_21_080045_add_reference_id_to_members_table', 1), (20, '2020_02_22_054809_add_amount_to_references_table', 1), (21, '2020_02_22_061714_create_reference_incomes_table', 1), (22, '2020_02_22_064256_create_reference_withdraws_table', 1), (23, '2020_02_25_145851_create_companies_table', 1), (24, '2020_02_28_153109_create_purchase_installments_table', 1), (25, '2020_02_28_181508_create_bank_withdraws_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `nominees` -- CREATE TABLE `nominees` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nationality` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nid` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `member_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `saled_id` int(11) DEFAULT NULL, `relation` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `nominees` -- INSERT INTO `nominees` (`id`, `name`, `hus_father`, `address`, `religion`, `nationality`, `nid`, `picture`, `member_id`, `saled_id`, `relation`, `birthday`, `status`, `created_at`, `updated_at`) VALUES (17, 'rahim', 'gdf', 'gytgt55ghiu86tyg', 'islam', 'Bangladeshi', '55446778888876655', 'nominees/Sv5BviIiY4XftA1uAC4U5BQREL2LkndL4tEzc6gi.jpeg', '48', NULL, NULL, '2003-02-14', NULL, '2021-07-07 20:08:50', '2021-07-07 20:08:50'), (16, 'Mahadi', 'Sharif Molla', '17/B, farashgonj Road, Shyambazar, Dhaka-1100', NULL, 'Bangladeshi', '54432217899008', 'nominees/PRGo1IPypqdA5517nLZi7u5S5SY84EqrBbga4bs7.jpeg', '47', NULL, NULL, '2014-10-27', NULL, '2021-07-07 16:24:02', '2021-07-07 16:24:02'), (15, 'Demon Salvator', 'Salvator', 'Mistic falls', 'christian', 'American', '45353535352 abc', 'nominees/P7EkbLTkuh3d9VyLDSibZBmsi3VjrQHtwjHIh1w0.png', '46', NULL, 'brother', '2021-07-01', NULL, '2021-07-01 19:12:23', '2021-07-01 19:14:57'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `plots` -- CREATE TABLE `plots` ( `id` bigint(20) UNSIGNED NOT NULL, `plot_size` double DEFAULT NULL, `block` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `block_id` int(11) NOT NULL, `road` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `face` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quantity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `plots` -- INSERT INTO `plots` (`id`, `plot_size`, `block`, `block_id`, `road`, `face`, `quantity`, `status`, `created_at`, `updated_at`) VALUES (25, 10, 'Standerd', 16, '6', 'north', '46', 0, '2021-07-01 18:44:05', '2021-08-19 11:42:05'), (26, 5, 'Block A', 17, 'Main', 'south', '17', 0, '2021-07-07 16:36:07', '2021-07-07 19:00:28'), (27, 5, 'Duplex', 18, 'Main', 'west', '51', 0, '2021-07-07 20:06:35', '2021-07-07 20:11:11'), (28, 5, 'Block A', 17, 'Sub-04/N-01', 'north', '19', 0, '2021-07-08 20:28:58', '2021-07-08 20:30:22'), (29, 3, 'Duplex', 18, 'Sub-09/N-01', 'south', '18', 0, '2021-07-08 20:49:49', '2021-07-11 05:05:22'), (30, 10, 'Standerd', 16, '5', 'north', '49', 0, '2021-07-11 05:06:50', '2021-07-11 05:07:16'), (31, 10, 'Demo Block 01', 19, 'Road no:01', 'north', '45', 0, '2021-07-11 08:09:17', '2021-08-07 06:10:39'), (32, 5, 'Demo Block 01', 19, '5', 'north', '46', 0, '2021-08-07 09:15:05', '2021-08-07 13:34:59'), (33, 3.5, 'Demo Block 01', 19, '5', 'south', '49', 0, '2021-08-08 10:23:51', '2021-08-09 01:48:42'); -- -------------------------------------------------------- -- -- Table structure for table `purchase_installments` -- CREATE TABLE `purchase_installments` ( `id` bigint(20) UNSIGNED NOT NULL, `land_purchase_id` int(10) UNSIGNED NOT NULL, `date` date NOT NULL, `amount` double NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `purchase_installments` -- INSERT INTO `purchase_installments` (`id`, `land_purchase_id`, `date`, `amount`, `created_at`, `updated_at`) VALUES (5, 7, '2021-05-10', 100, '2021-05-10 12:22:13', '2021-05-10 12:22:13'); -- -------------------------------------------------------- -- -- Table structure for table `references` -- CREATE TABLE `references` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `father_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mother_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nid` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `signature_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `amount` double DEFAULT NULL, `booking_amount` double NOT NULL, `installment_amount` double NOT NULL, `ekkalin_amount` double NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `references` -- INSERT INTO `references` (`id`, `name`, `father_name`, `mother_name`, `nid`, `dob`, `email`, `profession`, `present_address`, `permanent_address`, `mobile`, `religion`, `image`, `signature_image`, `status`, `created_at`, `updated_at`, `amount`, `booking_amount`, `installment_amount`, `ekkalin_amount`, `password`) VALUES (32, 'Md. Abdus Salam', 'Haji Osimoddin', 'Hajera Khatun', '65499664', '1956-06-04', 'salam@gmail.com', 'Business', '17/b, Shyambazar Dhaka - 1100', '17/b, Shyambazar Dhaka - 1100', '01712087567', 'muslim', 'members/OdC1jf0baQuKwcemRRALpwQWdXdZt8DfyWaRIDoi.jpeg', 'members/zLJIeEpQdZ2toI6NJoV9QfcRcUm1ZJO19uHLJ64n.jpeg', 0, '2021-07-07 16:15:44', '2021-07-07 16:15:44', NULL, 0, 0, 0, '123456'), (31, 'Hermione Granger', 'Granger', 'Granger', '45353535352 abc', '2021-07-01', 'hermione@gmail.com', 'Witch', 'Hogwarts', 'Hogwarts', '33333333333333', 'kristan', 'members/cj1UlLpZkWakT0BTRtKgN4X04ozZVISB8Xsw8bEr.jpeg', 'members/LVPSRo990RaVmSdUZcahQJBK8NZ8CdFRanpB9o1k.jpeg', 0, '2021-07-01 18:41:46', '2021-07-01 18:41:46', NULL, 0, 0, 0, '123456'), (33, 'New Here', 'Here', 'Here', '45353535352 abc', '1995-12-31', 'new@gmail.com', 'Witch', 'New new', 'New new', '3333333', 'muslim', 'members/2DcIgB1RDaiAtzOjx3OA9krPAyimet1J2nK2WiCY.jpeg', 'members/Wi97rTKeehXInpeasQBC5UwlH7uVzzeNLQ3PjHNA.jpeg', 0, '2021-07-11 08:13:41', '2021-07-11 08:13:41', NULL, 0, 0, 0, '123456'), (34, 'Demo sale 1', 'Demo sale', 'Demo sale', '45353535352 abc', '2021-08-07', 'demo@gmail.com', 'Witch', 'aasAS', 'aasAS', 'Tel: 02-9512433, Mobile: 01915-618117', 'muslim', 'members/2qMErw9X6rpDl7gUyA8pdSLW78OreevWR6l9BS3D.jpeg', 'members/sg6lgKA4Glc1Vazg3KR3pOK4liJuNNHTfL6chJyj.jpeg', 0, '2021-08-07 09:13:07', '2021-08-07 09:13:07', NULL, 0, 0, 0, '123456'); -- -------------------------------------------------------- -- -- Table structure for table `reference_incomes` -- CREATE TABLE `reference_incomes` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` int(10) UNSIGNED NOT NULL, `reference_id` int(10) UNSIGNED NOT NULL, `sell_id` int(11) DEFAULT NULL, `intall_id` int(11) DEFAULT NULL, `paid_amount` double DEFAULT NULL, `installment_amount` double DEFAULT NULL, `block_id` int(11) NOT NULL, `block_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `plot_size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `face` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `road` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `booking_amount` double NOT NULL, `installment_per_amount` double NOT NULL, `ekkalin_per_amount` double NOT NULL, `amount` double DEFAULT NULL, `rest_amount` double DEFAULT NULL, `status` int(11) NOT NULL, `status_d` int(11) DEFAULT NULL, `isDelete` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `reference_incomes` -- INSERT INTO `reference_incomes` (`id`, `member_id`, `reference_id`, `sell_id`, `intall_id`, `paid_amount`, `installment_amount`, `block_id`, `block_name`, `plot_size`, `face`, `road`, `booking_amount`, `installment_per_amount`, `ekkalin_per_amount`, `amount`, `rest_amount`, `status`, `status_d`, `isDelete`, `created_at`, `updated_at`) VALUES (309, 46, 31, 134, NULL, 70000, 92400, 16, 'Standerd', '10', 'north', '6', 100000, 10, 40, 1000000, 1000000, 2, NULL, 0, '2021-08-19 11:42:05', '2021-08-19 11:42:05'), (308, 46, 31, 130, NULL, 70000, 92400, 16, 'Standerd', '10', 'north', '6', 100000, 10, 40, 1000000, 1000000, 2, NULL, 0, '2021-08-19 09:11:54', '2021-08-19 09:11:54'), (305, 50, 34, 128, NULL, 60000, 494000, 19, 'Demo Block 01', '5', 'north', '5', 20000, 10, 40, 100000, 100000, 2, NULL, 0, '2021-08-07 13:34:59', '2021-08-07 13:34:59'), (306, 47, 32, 129, NULL, NULL, 0, 19, 'Demo Block 01', '3.5', 'south', '5', 20000, 10, 40, 0, 0, 1, NULL, 0, '2021-08-09 01:48:42', '2021-08-09 01:48:42'), (307, 46, 31, 113, 184, NULL, 1000, 16, 'Standerd', '10', 'north', '6', 100000, 10, 40, 100, 100, 3, NULL, 0, '2021-08-09 10:27:08', '2021-08-09 10:27:08'); -- -------------------------------------------------------- -- -- Table structure for table `reference_withdraws` -- CREATE TABLE `reference_withdraws` ( `id` bigint(20) UNSIGNED NOT NULL, `reference_id` int(10) UNSIGNED NOT NULL, `member_id` int(11) DEFAULT NULL, `income_id` int(11) NOT NULL, `sell_id` int(11) DEFAULT NULL, `amount` double DEFAULT NULL, `status` int(11) DEFAULT NULL, `status_purpose` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `updated_at` date DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sales` -- CREATE TABLE `sales` ( `id` bigint(20) UNSIGNED NOT NULL, `plot_id` int(10) UNSIGNED NOT NULL, `plot_no` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rate_per` double DEFAULT NULL, `total_rate` double DEFAULT NULL, `block_id` int(11) DEFAULT NULL, `member_id` int(10) UNSIGNED NOT NULL, `nominee_id` int(11) DEFAULT NULL, `serial_id` int(11) DEFAULT NULL, `installment` int(11) DEFAULT NULL, `installment_amount` double DEFAULT NULL, `due_amount` double DEFAULT NULL, `paid` double DEFAULT NULL, `discount` double DEFAULT NULL, `target_booking` double DEFAULT NULL, `date` date DEFAULT NULL, `remark` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sale_no` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `status_del` int(11) DEFAULT NULL, `money_rec` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `reference_id` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sales` -- INSERT INTO `sales` (`id`, `plot_id`, `plot_no`, `rate_per`, `total_rate`, `block_id`, `member_id`, `nominee_id`, `serial_id`, `installment`, `installment_amount`, `due_amount`, `paid`, `discount`, `target_booking`, `date`, `remark`, `sale_no`, `status`, `status_del`, `money_rec`, `created_at`, `updated_at`, `reference_id`) VALUES (130, 25, '01', 100000, 1000000, 16, 46, NULL, 1, 10, 92400, 924000, 70000, 6000, 500000, '2021-08-19', 'sale no 1', 1, 2, NULL, '01', '2021-08-19 09:11:53', '2021-08-19 09:11:53', 31), (131, 25, '02', 100000, 1000000, 16, 46, NULL, 1, 10, 92400, 924000, 70000, 6000, 500000, '2021-08-19', 'sale no 1', 1, 2, NULL, '01', '2021-08-19 09:11:53', '2021-08-19 09:11:53', 31), (132, 25, '03', 100000, 1000000, 16, 47, NULL, 1, 10, 92400, 924000, 70000, 6000, 500000, '2021-08-19', 'sale no 1', 1, 2, NULL, '01', '2021-08-19 09:11:53', '2021-08-19 09:11:53', 31), (133, 25, '04', 100000, 1000000, 16, 46, NULL, 1, 10, 92400, 924000, 70000, 6000, 500000, '2021-08-19', 'sale no 1', 1, 2, NULL, '01', '2021-08-19 09:11:53', '2021-08-19 09:11:53', 31), (134, 25, '05', 100000, 1000000, 16, 46, NULL, 1, 10, 92400, 924000, 70000, 6000, 500000, '2021-08-19', 'sale no 2', 5, 2, NULL, '02', '2021-08-19 11:42:05', '2021-08-19 11:42:05', 31); -- -------------------------------------------------------- -- -- Table structure for table `sale_details` -- CREATE TABLE `sale_details` ( `id` bigint(20) UNSIGNED NOT NULL, `sales_id` int(10) UNSIGNED NOT NULL, `refference_id` int(11) NOT NULL, `refference_name` text NOT NULL, `plot_id` int(10) UNSIGNED NOT NULL, `member_id` int(10) UNSIGNED NOT NULL, `installment` int(11) DEFAULT NULL, `installment_amount` double DEFAULT NULL, `due_amount` double DEFAULT NULL, `total_rate` double DEFAULT NULL, `paid` double DEFAULT NULL, `discount` int(11) DEFAULT NULL, `target_booking` double DEFAULT NULL, `date` date NOT NULL, `company_log` double UNSIGNED DEFAULT NULL, `refference_log` double UNSIGNED DEFAULT NULL, `booking_amount` double DEFAULT NULL, `install_amount` double DEFAULT NULL, `ekkalin_amount` double DEFAULT NULL, `status` int(11) DEFAULT NULL, `money_rec` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sale_details` -- INSERT INTO `sale_details` (`id`, `sales_id`, `refference_id`, `refference_name`, `plot_id`, `member_id`, `installment`, `installment_amount`, `due_amount`, `total_rate`, `paid`, `discount`, `target_booking`, `date`, `company_log`, `refference_log`, `booking_amount`, `install_amount`, `ekkalin_amount`, `status`, `money_rec`, `created_at`, `updated_at`) VALUES (133, 130, 31, 'Hermione Granger', 25, 46, 10, 92400, 924000, 1000000, 70000, 6000, 500000, '2021-08-19', 70000, NULL, 100000, 10, 40, NULL, 1, '2021-08-19 09:11:53', '2021-08-19 09:11:53'), (134, 134, 31, 'Hermione Granger', 25, 46, 10, 92400, 924000, 1000000, 70000, 6000, 500000, '2021-08-19', 70000, NULL, 100000, 10, 40, NULL, 2, '2021-08-19 11:42:05', '2021-08-19 11:42:05'); -- -------------------------------------------------------- -- -- Table structure for table `sub_memebers` -- CREATE TABLE `sub_memebers` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `hus_father` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `nationality` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birthday` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profession` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `religion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `present_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permanent_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `serial_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `role`) VALUES (2, 'Ahmed Ali', 'ahmed@gmail.com', '$2y$10$fRsqK12OuxD4d6sSeGo4tOK72PnfDoA6UqNKSs0TfvdzreqPr2r8y', NULL, '2020-12-07 06:57:11', '2020-12-07 06:57:11', 'user'), (3, 'Mohammed Ali', 'dreamgreencity@gmail.com', '$2y$10$amB6wUk2iBRu2o.NsY59PuyfDtcisjy0WqYzp3N8iv7bZ6cx0UtHe', NULL, '2020-12-12 13:36:08', '2020-12-12 13:36:08', 'user'), (4, 'Nizam', 'nizamlata1982@gmail.com', '$2y$10$Pb5LkqBMKfr/5nWkxwlgruJGsQUMUs1ve/lo./A4ThCG0zSoUxKla', NULL, '2021-01-14 13:27:06', '2021-01-14 13:27:06', 'user'), (5, 'Rahat', 'mdrahat@gmail.com', '$2y$10$winlzMKkUV6icA4jKh3KQeX92ic1gJ5WGHA8VGWoMsUXiCoZf18QG', NULL, '2021-05-25 13:04:13', '2021-05-25 13:04:13', 'user'); -- -- Indexes for dumped tables -- -- -- Indexes for table `accounts` -- ALTER TABLE `accounts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banks` -- ALTER TABLE `banks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bank_withdraws` -- ALTER TABLE `bank_withdraws` ADD PRIMARY KEY (`id`); -- -- Indexes for table `baynas` -- ALTER TABLE `baynas` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blocks` -- ALTER TABLE `blocks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `booking_amounts` -- ALTER TABLE `booking_amounts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `booking_forms` -- ALTER TABLE `booking_forms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `commision_plans` -- ALTER TABLE `commision_plans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `companies` -- ALTER TABLE `companies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `custom_bookings` -- ALTER TABLE `custom_bookings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `custom_installments` -- ALTER TABLE `custom_installments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `demo_installments` -- ALTER TABLE `demo_installments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `deposits` -- ALTER TABLE `deposits` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expences` -- ALTER TABLE `expences` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expence_heads` -- ALTER TABLE `expence_heads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `incomes` -- ALTER TABLE `incomes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `income_heads` -- ALTER TABLE `income_heads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `installments` -- ALTER TABLE `installments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `land_purchases` -- ALTER TABLE `land_purchases` ADD PRIMARY KEY (`id`); -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `nominees` -- ALTER TABLE `nominees` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `plots` -- ALTER TABLE `plots` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchase_installments` -- ALTER TABLE `purchase_installments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `references` -- ALTER TABLE `references` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reference_incomes` -- ALTER TABLE `reference_incomes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reference_withdraws` -- ALTER TABLE `reference_withdraws` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sales` -- ALTER TABLE `sales` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sale_details` -- ALTER TABLE `sale_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_memebers` -- ALTER TABLE `sub_memebers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `accounts` -- ALTER TABLE `accounts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=130; -- -- AUTO_INCREMENT for table `banks` -- ALTER TABLE `banks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `bank_withdraws` -- ALTER TABLE `bank_withdraws` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `baynas` -- ALTER TABLE `baynas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `blocks` -- ALTER TABLE `blocks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `booking_amounts` -- ALTER TABLE `booking_amounts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `booking_forms` -- ALTER TABLE `booking_forms` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; -- -- AUTO_INCREMENT for table `commision_plans` -- ALTER TABLE `commision_plans` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52; -- -- AUTO_INCREMENT for table `companies` -- ALTER TABLE `companies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `custom_bookings` -- ALTER TABLE `custom_bookings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `custom_installments` -- ALTER TABLE `custom_installments` MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `demo_installments` -- ALTER TABLE `demo_installments` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `deposits` -- ALTER TABLE `deposits` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `expences` -- ALTER TABLE `expences` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `expence_heads` -- ALTER TABLE `expence_heads` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `incomes` -- ALTER TABLE `incomes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `income_heads` -- ALTER TABLE `income_heads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `installments` -- ALTER TABLE `installments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=185; -- -- AUTO_INCREMENT for table `land_purchases` -- ALTER TABLE `land_purchases` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `nominees` -- ALTER TABLE `nominees` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `plots` -- ALTER TABLE `plots` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `purchase_installments` -- ALTER TABLE `purchase_installments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `references` -- ALTER TABLE `references` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `reference_incomes` -- ALTER TABLE `reference_incomes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=310; -- -- AUTO_INCREMENT for table `reference_withdraws` -- ALTER TABLE `reference_withdraws` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100; -- -- AUTO_INCREMENT for table `sales` -- ALTER TABLE `sales` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135; -- -- AUTO_INCREMENT for table `sale_details` -- ALTER TABLE `sale_details` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135; -- -- AUTO_INCREMENT for table `sub_memebers` -- ALTER TABLE `sub_memebers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; 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 */;