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

START TRANSACTION;



--
-- Database: `786p_database`
--

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

--
-- Table structure for table `account_table`
--

CREATE TABLE `account_table` (
  `account_id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `landowner_id` int(11) DEFAULT NULL,
  `broker_id` int(11) DEFAULT NULL,
  `give_type` enum('CHEQUE','CASH') DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `reference_name` varchar(100) DEFAULT NULL,
  `payment_date` varchar(15) DEFAULT NULL,
  `mr_no` int(11) DEFAULT NULL,
  `cheque_id` int(11) DEFAULT NULL,
  `customer_cheque_no` varchar(20) DEFAULT NULL,
  `cheque_date` varchar(15) DEFAULT NULL,
  `bank_id` tinyint(4) DEFAULT NULL,
  `bank_name2` varchar(250) DEFAULT NULL,
  `branch_name` varchar(50) DEFAULT NULL,
  `pay_amount` decimal(11,2) DEFAULT NULL,
  `description` varchar(300) DEFAULT NULL,
  `unit_price` int(11) DEFAULT NULL,
  `days` smallint(6) DEFAULT NULL,
  `payment_type` enum('R','P') DEFAULT NULL,
  `con_type_payment` varchar(50) NOT NULL DEFAULT 'Normal',
  `cheque_type` varchar(15) NOT NULL DEFAULT 'NEW' COMMENT 'NEW, USED',
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `account_table`
--

INSERT INTO `account_table` (`account_id`, `customer_id`, `supplier_id`, `contractor_id`, `employee_id`, `landowner_id`, `broker_id`, `give_type`, `project_id`, `cat_id`, `reference_name`, `payment_date`, `mr_no`, `cheque_id`, `customer_cheque_no`, `cheque_date`, `bank_id`, `bank_name2`, `branch_name`, `pay_amount`, `description`, `unit_price`, `days`, `payment_type`, `con_type_payment`, `cheque_type`, `user_id`) VALUES
(1, NULL, NULL, 1, NULL, NULL, NULL, '', 2, NULL, NULL, '2023-08-05', NULL, NULL, NULL, NULL, 1, NULL, NULL, '900.00', 'TEST', NULL, NULL, 'P', 'Normal', 'NEW', 1),
(4, NULL, NULL, NULL, NULL, 1, NULL, 'CASH', 2, NULL, NULL, '2023-08-05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '26000.00', 'TEST', NULL, NULL, 'P', 'Normal', 'NEW', 10),
(5, 16, NULL, NULL, NULL, NULL, NULL, 'CASH', 1, NULL, NULL, '2023-08-05', 123, NULL, NULL, NULL, NULL, NULL, NULL, '2000.00', 'AUGUST RENT', NULL, NULL, 'R', 'Normal', 'NEW', 10);

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

--
-- Table structure for table `agreement_info`
--

CREATE TABLE `agreement_info` (
  `agreement_id` int(11) NOT NULL,
  `title_name` varchar(250) NOT NULL,
  `description` varchar(600) DEFAULT NULL,
  `file_name` varchar(250) DEFAULT NULL,
  `date` varchar(15) NOT NULL,
  `expire_date` varchar(20) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `create_date` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `agreement_info`
--

INSERT INTO `agreement_info` (`agreement_id`, `title_name`, `description`, `file_name`, `date`, `expire_date`, `created_by`, `updated_by`, `create_date`) VALUES
(1, 'SANDEEP_PASSPORT', 'SANDEEP PASSPORT', 'dc95a5e5f89507546115994f00eb330c.jpg', '', '2023-08-10', 10, 10, '2023-08-05'),
(2, 'SANDEEP_RENTAL_AGREEMENT', 'SANDEEP RENTAL AGREEMENT', '2dd9d1b102e57d32cdb11b84aea89807.jpg', '', '2023-08-24', 10, 0, '2023-08-05'),
(3, 'HILAL_QANBER_AGREEMENT_END', '', '81ed1e72219e16ed2f2bc922f80db1e0.jpg', '', '2023-08-30', 10, 10, '2023-08-05');

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

--
-- Table structure for table `assetbuy`
--

CREATE TABLE `assetbuy` (
  `buy_id` int(11) NOT NULL,
  `buy_type` varchar(20) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `purpose_name` varchar(250) DEFAULT NULL,
  `equipment_name` varchar(200) DEFAULT NULL,
  `buy_date` varchar(20) NOT NULL,
  `equipment_qty` int(11) DEFAULT NULL,
  `equipment_price` decimal(11,2) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `give_type` varchar(20) DEFAULT NULL,
  `bank_id` int(11) DEFAULT NULL,
  `branch_name` varchar(100) DEFAULT NULL,
  `cheque_id` int(11) DEFAULT NULL,
  `cheque_date` varchar(20) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `asset_information`
--

CREATE TABLE `asset_information` (
  `asset_id` int(11) NOT NULL,
  `asset_type` enum('Office','Project') DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `asset_name` varchar(200) DEFAULT NULL,
  `buy_date` varchar(15) DEFAULT NULL,
  `quantity` smallint(6) DEFAULT NULL,
  `price` decimal(11,2) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `bank_information`
--

CREATE TABLE `bank_information` (
  `bank_id` tinyint(4) NOT NULL,
  `bank_name` varchar(200) DEFAULT NULL,
  `account_no` varchar(30) DEFAULT NULL,
  `account_name` varchar(50) DEFAULT NULL,
  `branch_name` varchar(50) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bank_information`
--

INSERT INTO `bank_information` (`bank_id`, `bank_name`, `account_no`, `account_name`, `branch_name`, `create_date`, `user_id`) VALUES
(1, 'QATAR NATIONAL BANK', '8237836473647', 'RINISH', 'HAMAMA QATAR', '05/08/2023', 1);

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

--
-- Table structure for table `broker_information`
--

CREATE TABLE `broker_information` (
  `broker_id` int(11) NOT NULL,
  `broker_name` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `project_id` int(11) NOT NULL,
  `broker_type` enum('LAND','FLAT') DEFAULT NULL,
  `flat_no` varchar(50) DEFAULT NULL,
  `pay_amount` decimal(11,2) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `broker_information`
--

INSERT INTO `broker_information` (`broker_id`, `broker_name`, `address`, `mobile_no`, `email_id`, `photo`, `signature`, `nid_no`, `create_date`, `project_id`, `broker_type`, `flat_no`, `pay_amount`, `user_id`) VALUES
(1, 'MALIK INVESTOR', 'DOHA, QATAR', '7829333010', 'malik@gmail.com', NULL, NULL, '', NULL, 2, 'FLAT', 'FT101', '1.00', 1),
(2, 'GMON BROKER', 'doha', '7829333010', 'gmon@gmail.com', NULL, NULL, '783478347874394', NULL, 1, 'LAND', NULL, '10000.00', 1);

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

--
-- Table structure for table `budget_cost`
--

CREATE TABLE `budget_cost` (
  `budget_cost_id` int(11) NOT NULL,
  `budget_cost_type` enum('Office','Project') DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `bc_date` varchar(15) DEFAULT NULL,
  `quantity` smallint(6) DEFAULT NULL,
  `budget_price` decimal(11,2) DEFAULT NULL,
  `actual_price` decimal(11,2) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `cash_register`
--

CREATE TABLE `cash_register` (
  `register_id` int(11) NOT NULL,
  `register_no` varchar(30) NOT NULL,
  `register_date` varchar(15) NOT NULL,
  `purpose_id` tinyint(4) NOT NULL,
  `note` varchar(250) DEFAULT NULL,
  `total_amount` decimal(11,2) NOT NULL DEFAULT 0.00,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cash_register_detail`
--

CREATE TABLE `cash_register_detail` (
  `register_detail_id` int(11) NOT NULL,
  `register_id` int(11) NOT NULL,
  `description` varchar(150) NOT NULL,
  `amount` decimal(11,2) NOT NULL DEFAULT 0.00,
  `remark` varchar(200) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cheque_book`
--

CREATE TABLE `cheque_book` (
  `cheque_id` int(11) NOT NULL,
  `bank_id` tinyint(4) NOT NULL,
  `book_no` tinyint(4) NOT NULL,
  `cheque_no` int(11) NOT NULL,
  `counts` tinyint(4) NOT NULL,
  `cheque_status` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `company_info`
--

CREATE TABLE `company_info` (
  `id` bigint(20) NOT NULL,
  `company_name` varchar(50) DEFAULT NULL,
  `short_name` varchar(10) NOT NULL,
  `email_address` varchar(50) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `date_format` varchar(20) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `create_date` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `company_info`
--

INSERT INTO `company_info` (`id`, `company_name`, `short_name`, `email_address`, `phone`, `website`, `address`, `date_format`, `logo`, `create_date`) VALUES
(1, '786 Property', '786Propert', 'info@786property.com', '01723695251', 'www.786property.com', '786 properties', 'dd/mm/yyyy', '786-5.png', '2017-12-25');

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

--
-- Table structure for table `contractor_detail`
--

CREATE TABLE `contractor_detail` (
  `contractor_detail_id` int(11) NOT NULL,
  `contractor_id` int(11) DEFAULT NULL,
  `cproduct_id` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `payment_amount` decimal(11,2) DEFAULT NULL,
  `comments` varchar(350) DEFAULT NULL,
  `bill_no` varchar(50) NOT NULL,
  `bill_date` varchar(15) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `contractor_detail`
--

INSERT INTO `contractor_detail` (`contractor_detail_id`, `contractor_id`, `cproduct_id`, `project_id`, `payment_amount`, `comments`, `bill_no`, `bill_date`, `user_id`) VALUES
(1, 1, NULL, 2, '1000.00', 'TEST', 'ABC', '2023-08-05', 1);

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

--
-- Table structure for table `contractor_information`
--

CREATE TABLE `contractor_information` (
  `contractor_id` int(11) NOT NULL,
  `contractor_name` varchar(50) NOT NULL,
  `prop_name` varchar(100) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `contractor_type` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `contact_policy` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `contractor_information`
--

INSERT INTO `contractor_information` (`contractor_id`, `contractor_name`, `prop_name`, `address`, `mobile_no`, `email_id`, `photo`, `signature`, `contractor_type`, `nid_no`, `create_date`, `contact_policy`, `user_id`) VALUES
(1, 'CONTRACTOR _TEST', 'JAMALUDHEEN', 'TEST', '7829333010', 'shafeekibnukader@gmail.com', NULL, NULL, 'INTERIOR CONTRACTOR', '', NULL, 'A GRADE', 1);

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

--
-- Table structure for table `contractor_product`
--

CREATE TABLE `contractor_product` (
  `cproduct_id` int(11) NOT NULL,
  `cproduct_name` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `customer_additional_cost`
--

CREATE TABLE `customer_additional_cost` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `cost` int(11) NOT NULL,
  `detail` varchar(250) NOT NULL,
  `create_date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `customer_additional_cost`
--

INSERT INTO `customer_additional_cost` (`id`, `customer_id`, `cost`, `detail`, `create_date`, `user_id`) VALUES
(1, 1, 2000, 'LIGHT FITTINGS', '2023-08-05', 1);

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

--
-- Table structure for table `customer_information`
--

CREATE TABLE `customer_information` (
  `customer_id` int(11) NOT NULL,
  `customer_name` varchar(50) DEFAULT NULL,
  `customer_no` varchar(20) NOT NULL,
  `nominee` varchar(200) NOT NULL,
  `date_of_birth` varchar(20) DEFAULT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `mother_name` varchar(100) DEFAULT NULL,
  `occupation` varchar(100) DEFAULT NULL,
  `nominee_relation` varchar(200) DEFAULT NULL,
  `customer_type` enum('Regular','Default') NOT NULL DEFAULT 'Regular',
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `reference_by` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `booking_date` varchar(20) NOT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `late_payment_policy` varchar(500) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `flat_no` varchar(50) DEFAULT NULL,
  `total_value` decimal(14,2) DEFAULT NULL,
  `return_value` decimal(11,2) DEFAULT NULL,
  `return_parcent` int(11) NOT NULL DEFAULT 0,
  `tatal_installment` smallint(6) DEFAULT NULL,
  `installment_date` smallint(6) DEFAULT NULL,
  `installment_value` decimal(10,2) DEFAULT NULL,
  `car_parking` enum('YES','NO') DEFAULT NULL,
  `attachment` varchar(200) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `customer_information`
--

INSERT INTO `customer_information` (`customer_id`, `customer_name`, `customer_no`, `nominee`, `date_of_birth`, `father_name`, `mother_name`, `occupation`, `nominee_relation`, `customer_type`, `address`, `mobile_no`, `email_id`, `photo`, `signature`, `reference_by`, `nid_no`, `booking_date`, `create_date`, `late_payment_policy`, `project_id`, `flat_no`, `total_value`, `return_value`, `return_parcent`, `tatal_installment`, `installment_date`, `installment_value`, `car_parking`, `attachment`, `user_id`) VALUES
(17, 'GLENN CASTRO MANALASTAS', '002', 'Nill', '1980-01-05', '', '', '', 'Nill', 'Regular', 'Sponsor- QAPCO DOHA,QATAR', '33516808', 'g.manalastas@qapco.com.qa', NULL, NULL, 'Febeek Agent', '', '01/05/2023', NULL, '8', 14, 'F1-1BHK', '20400.00', NULL, 0, 6, 1, '3400.00', 'NO', 'b8291b89-ec55-4d5d-8924-ce7304c772f5.jpeg', 13);

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

--
-- Table structure for table `director_share`
--

CREATE TABLE `director_share` (
  `share_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `share_name` varchar(100) NOT NULL,
  `share_quantity` int(11) NOT NULL,
  `share_amount` decimal(10,2) NOT NULL,
  `share_date` varchar(15) NOT NULL,
  `share_duration` smallint(6) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `employee_information`
--

CREATE TABLE `employee_information` (
  `employee_id` int(11) NOT NULL,
  `employee_name` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `joining_date` varchar(15) NOT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `company_policy` varchar(500) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  `salary` decimal(11,2) DEFAULT NULL,
  `bonus_percentage` smallint(3) DEFAULT NULL,
  `c_sim_use` enum('YES','NO') DEFAULT NULL,
  `sim_mob_no` varchar(20) DEFAULT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `mother_name` varchar(100) DEFAULT NULL,
  `reference_by` varchar(100) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `employee_information`
--

INSERT INTO `employee_information` (`employee_id`, `employee_name`, `address`, `mobile_no`, `email_id`, `photo`, `signature`, `nid_no`, `joining_date`, `create_date`, `company_policy`, `post_id`, `salary`, `bonus_percentage`, `c_sim_use`, `sim_mob_no`, `father_name`, `mother_name`, `reference_by`, `user_id`) VALUES
(1, 'MALIK INVESTOR', 'DAMAM', '7829333010', 'malik@gmail.com', NULL, NULL, '1234343434343434', '15/08/2023', NULL, 'POLICY', 16, '1234.00', 1, 'NO', '', 'A', 'B', 'ABC', 1);

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

--
-- Table structure for table `employee_loan`
--

CREATE TABLE `employee_loan` (
  `loan_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `loan_name` varchar(150) NOT NULL,
  `loan_date` varchar(15) NOT NULL,
  `loan_amount` decimal(11,2) NOT NULL,
  `ad_type` varchar(20) NOT NULL,
  `ad_amount` decimal(11,2) NOT NULL,
  `give_type` varchar(20) DEFAULT NULL,
  `bank_id` int(11) NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `cheque_id` int(11) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `note` varchar(200) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `employee_loan_ad`
--

CREATE TABLE `employee_loan_ad` (
  `loan_ad_id` int(11) NOT NULL,
  `loan_id` int(11) NOT NULL,
  `ad_date` varchar(20) NOT NULL,
  `cheque` varchar(20) NOT NULL,
  `bank_name` varchar(150) DEFAULT NULL,
  `branch_name` varchar(100) DEFAULT NULL,
  `paid_amount` decimal(11,2) NOT NULL,
  `ad_month` varchar(15) NOT NULL,
  `remarks` varchar(150) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `employee_salary`
--

CREATE TABLE `employee_salary` (
  `emp_salary_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `pay_amount` decimal(11,2) NOT NULL,
  `deposit_amount` decimal(11,2) NOT NULL,
  `give_type` varchar(20) DEFAULT NULL,
  `bank_id` int(11) NOT NULL,
  `cheque_id` int(11) NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `pay_month` varchar(30) NOT NULL,
  `create_date` varchar(20) NOT NULL,
  `pay_year` int(11) NOT NULL,
  `pay_month_date` varchar(15) NOT NULL,
  `remarks` varchar(100) DEFAULT NULL,
  `category` enum('1','2') NOT NULL COMMENT '1=Director,2=Employee',
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `expense_category`
--

CREATE TABLE `expense_category` (
  `cat_id` int(11) NOT NULL,
  `cat_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `expense_category`
--

INSERT INTO `expense_category` (`cat_id`, `cat_name`) VALUES
(1, 'Office Rent'),
(2, 'Mobile Bill'),
(3, 'Entertaiment Bill'),
(5, 'Office Stationary Bill'),
(6, 'Utility Bill'),
(7, 'Convenience Bill'),
(9, 'Others Bill'),
(10, 'Lunch Bill'),
(11, 'PETROL EXPENSE'),
(12, 'WORKSHOP EXPENSE'),
(13, 'SPONSOR CASH'),
(14, 'OFFICE RENT');

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

--
-- Table structure for table `flat_info`
--

CREATE TABLE `flat_info` (
  `flat_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `flat_no` varchar(50) NOT NULL,
  `flat_size` varchar(250) DEFAULT NULL,
  `room_number` int(11) DEFAULT NULL,
  `bath_number` int(11) DEFAULT NULL,
  `dinning_yes` varchar(30) DEFAULT NULL,
  `attach_bath` int(11) DEFAULT NULL,
  `kitchen_yes` varchar(50) DEFAULT NULL,
  `flat_description` varchar(6000) DEFAULT NULL,
  `create_date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `flat_info`
--

INSERT INTO `flat_info` (`flat_id`, `project_id`, `flat_no`, `flat_size`, `room_number`, `bath_number`, `dinning_yes`, `attach_bath`, `kitchen_yes`, `flat_description`, `create_date`, `user_id`, `customer_id`) VALUES
(1, 2, 'F4-2BHK', '2BHK', 8, 1, 'YES', 0, 'YES', 'UN FURNISHED', '', 10, NULL),
(2, 2, 'G1-1BHK', '1BHK', 1, 1, 'YES', 0, 'YES', 'NON-FURNISHED', '', 13, NULL),
(3, 2, 'G2-1BHK', '1BHK', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(4, 2, 'G3-1BHK', '1BHK', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(5, 2, 'G4-1BHK', '1BHK', 4, 1, 'YES', 0, 'YES', 'UN FURNISHED', '', 10, NULL),
(6, 2, 'F1-STUDIO', 'STUDIO', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(7, 2, 'F2-STUDIO', 'STUDIO', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(8, 2, 'F3-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'FULLY FURNISHED', '', 10, NULL),
(9, 2, 'F5-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(10, 2, 'F6-STUDIO', 'STUDIO', 10, 1, 'YES', 1, 'YES', 'UNFURNISHED', '', 10, NULL),
(11, 2, 'OH1-STUDIO', 'STUDIO', 11, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(12, 2, 'OH2-STUDIO', 'STUDIO', 12, 1, 'YES', 1, 'YES', 'UNFURNISHED', '', 10, NULL),
(13, 2, 'OH3-STUDIO', 'STUDIO', 13, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(14, 2, 'OH4-1BHK', '1BHK', 14, 1, 'YES', 1, 'YES', 'UNFURNISHED', '', 10, NULL),
(15, 2, 'OH5-STUDIO', 'STUDIO', 15, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(16, 2, 'OH6-STUDIO', 'STUDIO', 16, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 10, NULL),
(17, 1, 'G1-STUDIO', 'STUDIO', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(18, 1, 'G2-1BHK', '1BHK', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(19, 1, 'G3-STUDIO', 'STUDIO', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(20, 1, 'G4-STUDIO', 'STUDIO', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(21, 1, 'G5 STUDIO', 'STUDIO', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(22, 1, 'F1-STUDIO', 'F1', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(23, 1, 'F2-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(24, 1, 'F3-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(25, 1, 'F4 STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UNFURNISHED', '', 13, NULL),
(26, 1, 'F5 STUDIO', 'STUDIO', 10, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(27, 1, 'PH1-STUDIO', 'STUDIO', 11, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(28, 1, 'OH1-STUDIO', 'STUDIO', 12, 1, 'YES', 1, 'YES', 'UNFURNISHED', '', 13, NULL),
(29, 1, 'OH2-STUDIO', 'STUDIO', 13, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(30, 1, 'OH3-STUDIO', 'STUDIO', 14, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(31, 1, 'OH4-STUDIO', 'STUDIO', 15, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(32, 1, 'OH5-STUDIO', 'STUDIO', 16, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(33, 3, 'G1-STUDIO', 'STUDIO', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(34, 3, 'G2-1BHK', '1BHK', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(35, 3, 'G3-STUDIO', 'STUDIO', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(36, 3, 'G4-STUDIO', 'STUDIO', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(37, 3, 'F1-1BHK', '1BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(38, 3, 'F2-STUDIO', 'STUDIO', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(39, 3, 'F3-1BHK', '1BHK', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(40, 3, 'OH1-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(41, 3, 'OH2-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(42, 3, 'OH3-STUDIO', 'STUDIO', 10, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(43, 4, 'G1-2BHK', '2BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(44, 4, 'G2-STUDIO', 'STUDIO', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(45, 4, 'G3-STUDIO', 'STUDIO', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(46, 4, 'F1-STUDIO', 'STUDIO', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(47, 4, 'F2-1BHK', '1BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(48, 4, 'F3-STUDIO', 'STUDIO', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(49, 4, 'OH1-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(50, 4, 'OH2-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(51, 4, 'OH3-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(52, 4, 'OH4-STUDIO', 'STUDIO', 10, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(53, 4, 'OH5-STUDIO', 'STUDIO', 11, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(54, 5, 'G1-1BHK', '1BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(55, 5, 'G2-STUDIO', 'STUDIO', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(56, 5, 'G3-STUDIO', 'STUDIO', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(57, 5, 'G4-STUDIO', 'STUDIO', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(58, 5, 'F1-1BHK', '1BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(59, 5, 'F2-1BHK', '1BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(60, 5, 'F3-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(61, 5, 'F4 STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(62, 5, 'OH1-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(63, 6, 'G1-1BHK', '1BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(64, 6, 'G2-STUDIO', 'STUDIO', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(65, 6, 'G3-STUDIO', 'STUDIO', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(66, 6, 'G4-STUDIO', 'STUDIO', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(67, 6, 'F1-2BHK', '2BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(68, 6, 'F2-2BHK', '2BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(69, 6, 'PH1-2BHK', '2BHK', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(70, 6, 'OH1-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(71, 7, 'G1-STUDIO', 'STUDIO', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(72, 7, 'G2-STUDIO', 'STUDIO', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(73, 7, 'G3-STUDIO', 'STUDIO', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(74, 7, 'G4-STUDIO', 'STUDIO', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(75, 7, 'G5 STUDIO', 'STUDIO', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(76, 7, 'F1-1BHK', '1BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(77, 7, 'F2-1BHK', '1BHK', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(78, 7, 'F3-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(79, 7, 'PH1-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(80, 7, 'OH1-STUDIO', 'STUDIO', 10, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(81, 7, 'OH2-STUDIO', 'STUDIO', 11, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(82, 7, 'OH3-STUDIO', 'STUDIO', 12, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(83, 8, 'G1-2BHK', '2BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(84, 8, 'G2-3BHK', '3BHK', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(85, 8, 'F1-2BHK', '2BHK', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(86, 8, 'F2-3BHK', '3BHK', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(87, 8, 'PH1-1BHK', '1BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(88, 8, 'PH2-1BHK', '1BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(89, 8, 'OH1-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'FULLY FURNISHED', '', 13, NULL),
(90, 8, 'OH2-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(91, 9, 'G1-2BHK', '2BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(92, 9, 'G2-3BHK', '3BHK', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(93, 9, 'F1-2BHK', '2BHK', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(94, 9, 'F2-3BHK', '3BHK', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(95, 9, 'PH1-1BHK', '1BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(96, 9, 'PH2-1BHK', '1BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(97, 9, 'PH2-1BHK', '1BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(98, 9, 'PH2-1BHK', '1BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(99, 9, 'OH1-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(100, 9, 'OH2-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(101, 10, 'G1-1BHK', '1BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(102, 10, 'G2-STUDIO', 'STUDIO', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(103, 10, 'G3-1BHK', '1BHK', 3, 1, 'YES', 1, 'YES', 'FULLY FURNISHED', '', 13, NULL),
(104, 10, 'F1-1BHK', '1BHK', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(105, 10, 'F2-1BHK', '1BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(106, 10, 'PH1-STUDIO', 'STUDIO', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(107, 10, 'OH1-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(108, 10, 'OH2-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(109, 10, 'OH3-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(110, 11, 'G1-1BHK', '1BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(111, 11, 'G2-STUDIO', 'STUDIO', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(112, 11, 'G3-1BHK', '1BHK', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(113, 11, 'F1-1BHK', '1BHK', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(114, 11, 'F2-STUDIO', 'STUDIO', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(115, 11, 'F3-STUDIO', 'STUDIO', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(116, 11, 'PH1-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(117, 11, 'OH1-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(118, 11, 'OH2-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(119, 11, 'OH3-STUDIO', 'STUDIO', 10, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(120, 12, 'G1-1BHK', '1BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(121, 12, 'G2-1BHK', '1BHK', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(122, 12, 'G3-STUDIO', 'STUDIO', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(123, 12, 'G4-STUDIO', 'STUDIO', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(124, 12, 'F1-1BHK', '1BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(125, 12, 'F2-1BHK', '1BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(126, 12, 'F3-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(127, 12, 'F4 STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(128, 12, 'OH1-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(129, 12, 'OH2-STUDIO', 'STUDIO', 10, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(130, 12, 'OH3-STUDIO', 'STUDIO', 11, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(131, 12, 'OH4-STUDIO', 'STUDIO', 12, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(132, 13, 'G1-1BHK', '1BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(133, 13, 'G2-1BHK', '1BHK', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(134, 13, 'G3-STUDIO', 'STUDIO', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(135, 13, 'G4-STUDIO', 'STUDIO', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(136, 13, 'F1-STUDIO', 'STUDIO', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(137, 13, 'F2-STUDIO', 'STUDIO', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(138, 13, 'F3-1BHK', '1BHK', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(139, 13, 'F4-1BHK', '1BHK', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(140, 13, 'OH1-STUDIO', 'STUDIO', 9, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(141, 13, 'OH2-STUDIO', 'STUDIO', 10, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(142, 13, 'OH3-STUDIO', 'STUDIO', 11, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(143, 13, 'OH4-STUDIO', 'STUDIO', 12, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(144, 14, 'G1-2BHK', '2BHK', 1, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(145, 14, 'G2-1BHK', '1BHK', 2, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(146, 14, 'F1-1BHK', '1BHK', 3, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(147, 14, 'F2-1BHK', '1BHK', 4, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(148, 14, 'F3-1BHK', '1BHK', 5, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(149, 14, 'PH1-1BHK', '1BHK', 6, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(150, 14, 'PH2-STUDIO', 'STUDIO', 7, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL),
(151, 14, 'OH1-STUDIO', 'STUDIO', 8, 1, 'YES', 1, 'YES', 'UN FURNISHED', '', 13, NULL);

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

--
-- Table structure for table `landowner_detail`
--

CREATE TABLE `landowner_detail` (
  `land_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `land_size` varchar(200) NOT NULL,
  `payment_amount` decimal(11,2) NOT NULL,
  `deed_date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `landowner_detail`
--

INSERT INTO `landowner_detail` (`land_id`, `project_id`, `land_size`, `payment_amount`, `deed_date`, `user_id`) VALUES
(1, 2, 'TEST', '312000.00', '2023-08-05', 10);

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

--
-- Table structure for table `landowner_information`
--

CREATE TABLE `landowner_information` (
  `landowner_id` int(11) NOT NULL,
  `landowner_name` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `per_amount` decimal(11,2) DEFAULT NULL,
  `land_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `landowner_information`
--

INSERT INTO `landowner_information` (`landowner_id`, `landowner_name`, `address`, `mobile_no`, `email_id`, `photo`, `signature`, `nid_no`, `create_date`, `per_amount`, `land_id`, `user_id`) VALUES
(1, 'MOHAMED QANBER', 'TEST', '123', 'QANBER@GMAIL.COM', NULL, NULL, '12300', '2023-08-05', '312000.00', 1, 10);

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

--
-- Table structure for table `marketing_list`
--

CREATE TABLE `marketing_list` (
  `marketing_id` int(11) NOT NULL,
  `customer_name` varchar(120) NOT NULL,
  `address` varchar(250) NOT NULL,
  `phone_no` varchar(30) NOT NULL,
  `date` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `oldassetsell`
--

CREATE TABLE `oldassetsell` (
  `assetsell_id` int(11) NOT NULL,
  `sell_type` varchar(20) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `asset_name` varchar(150) NOT NULL,
  `sell_date` varchar(20) NOT NULL,
  `quantity` smallint(6) NOT NULL,
  `total_price` decimal(8,2) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `org_info`
--

CREATE TABLE `org_info` (
  `org_id` tinyint(4) NOT NULL,
  `org_name` varchar(120) NOT NULL,
  `phone_no` varchar(20) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `org_info`
--

INSERT INTO `org_info` (`org_id`, `org_name`, `phone_no`, `email`, `address`) VALUES
(1, 'iNTECH PROPERTIES LTD', '01725888', 'opex@gmail.com', 'USA');

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

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `post_id` smallint(6) NOT NULL,
  `post_name` varchar(100) NOT NULL,
  `post_lavel` enum('Director','Employee') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`post_id`, `post_name`, `post_lavel`) VALUES
(2, 'Manager', 'Employee'),
(4, 'Asst. Manager', 'Employee'),
(5, 'Chairman', 'Director'),
(6, 'Vice Chairman', 'Director'),
(7, 'Manging Director', 'Director'),
(8, 'Director', 'Director'),
(9, 'Office Peon', 'Employee'),
(10, 'Security Guard', 'Employee'),
(11, 'Project Engineer', 'Employee'),
(12, 'Assistent Project Engineer', 'Employee'),
(13, 'Project Supervisor', 'Employee'),
(14, 'Excutive Officer', 'Employee'),
(15, 'Chairman', 'Director'),
(16, 'VILLA INVESTOR', 'Director');

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

--
-- Table structure for table `project_information`
--

CREATE TABLE `project_information` (
  `project_id` int(11) NOT NULL,
  `project_name` varchar(200) DEFAULT NULL,
  `project_address` varchar(250) DEFAULT NULL,
  `total_flat_des` varchar(500) DEFAULT NULL,
  `sale_des` varchar(200) DEFAULT NULL,
  `project_deed_date` varchar(20) DEFAULT NULL,
  `project_start_date` varchar(20) DEFAULT NULL,
  `hand_over_date` varchar(20) DEFAULT NULL,
  `project_status` varchar(20) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `project_information`
--

INSERT INTO `project_information` (`project_id`, `project_name`, `project_address`, `total_flat_des`, `sale_des`, `project_deed_date`, `project_start_date`, `hand_over_date`, `project_status`, `create_date`, `user_id`) VALUES
(1, 'THUMAMA_VILLA_NO_2', 'THUMAMA ZONE 46 STREET 820', 'TOTAL 16 FLATS', 'TEST', '05/08/2023', '05/08/2023', '04/08/2023', 'Complete', NULL, 10),
(2, 'HILAL_VILLA_NO_12', 'HILAL ZONE 41 STREET 910', 'TOTAL 16 DIVISION', '1 YEAR CONTRACT', '09/12/2020', '05/08/2023', '05/08/2023', 'Complete', NULL, 10),
(3, 'DUHAIL_VILLA_NO_8', 'DUHAIL ZONE 31 STREET 882', 'TOTAL 10 FLATS', 'TEST', '01/08/2023', '22/08/2023', '31/08/2023', 'Complete', NULL, 10),
(4, 'AINKHALED_VILLA_NO_93', 'AINKHALED ZONE 56 STREET 864', 'TOTAL 11 FLATS', 'TEST', '01/01/2020', '01/01/2020', '30/12/2024', 'Complete', NULL, 10),
(5, 'OLD AIRPORT_VILLA_NO_17', 'OLD AIRPORT ZONE 45 STREET 740', 'TOTAL 9 FLATS', 'TEST', '01/04/2020', '01/04/2020', '30/03/2026', 'Complete', NULL, 10),
(6, 'NEW SALATA_VILLA_NO_6', 'NEW SALATA ZONE 40 STREET 887', 'TOTAL 8 FLATS', 'TEST', '01/04/2020', '01/04/2020', '30/03/2024', 'Complete', NULL, 10),
(7, 'AINKHALED_VILLA_NO_38', 'AINKHALED ZONE 56 STREET 300', 'TOTAL 12 FLATS', 'TEST', '02/08/2023', '15/08/2023', '09/08/2023', 'Complete', NULL, 10),
(8, 'MAMOURA_VILLA_NO_65', 'MAMOURA ZONE 56 STREET 733', 'TOTAL 8 FLATS', 'TEST', '03/08/2023', '07/09/2023', '24/08/2023', 'Complete', NULL, 10),
(9, 'MAMOURA_VILLA_NO_67', 'MAMOURA ZONE 56 STREET 733', 'TOTAL 8 FLATS', 'TEST', '01/08/2023', '17/08/2023', '31/08/2023', 'Complete', NULL, 10),
(10, 'THUMAMA_VILLA_NO_30', 'THUMAMA ZONE 46 STREET 914', 'TOTAL 9 FLATS', 'TEST', '01/11/2022', '01/11/2022', '31/10/2024', 'Complete', NULL, 13),
(11, 'THUMAMA_VILLA_NO_32', 'THUMAMA ZONE 46 STREET 914', 'TOTAL 10 FLATS', 'TEST', '01/11/2022', '01/11/2022', '31/10/2024', 'Complete', NULL, 13),
(12, 'NUAIJA_VILLA_NO_81', 'NUAIJA ZONE 44 STREET 880', 'TOTAL 12 FLATS', 'TEST', '01/05/2023', '18/04/2023', '30/04/2024', 'Complete', NULL, 13),
(13, 'NUAIJA_VILLA_NO_83', 'NUAIJA ZONE  44 STREET 880', 'TOTAL 12 FLATS', 'TEST', '01/05/2023', '18/04/2023', '30/04/2024', 'Complete', NULL, 13),
(14, 'THUMAMA_VILLA_NO_28', 'THUMAMA ZONE46 STREET 906', 'TOTAL 8 FLATS', 'TEST', '01/06/2023', '01/05/2023', '30/05/2024', 'Complete', NULL, 10);

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

--
-- Table structure for table `register_deposit_money`
--

CREATE TABLE `register_deposit_money` (
  `deposit_id` int(11) NOT NULL,
  `purpose_id` int(11) NOT NULL,
  `deposit_date` varchar(15) NOT NULL,
  `amount` decimal(11,2) NOT NULL DEFAULT 0.00,
  `note` varchar(250) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `requisition_detail`
--

CREATE TABLE `requisition_detail` (
  `detail_id` int(11) NOT NULL,
  `req_id` int(11) NOT NULL,
  `req_name` varchar(200) NOT NULL,
  `quantity` varchar(80) NOT NULL,
  `remark` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `requisition_information`
--

CREATE TABLE `requisition_information` (
  `req_id` int(11) NOT NULL,
  `req_type` enum('Office','Project') DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `item_name` varchar(200) DEFAULT NULL,
  `req_date` varchar(15) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `salary_table`
--

CREATE TABLE `salary_table` (
  `salary_id` int(11) NOT NULL,
  `employee_id` tinyint(4) DEFAULT NULL,
  `salary` decimal(11,2) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `change_date` varchar(15) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `share_adjaustment`
--

CREATE TABLE `share_adjaustment` (
  `share_ad_id` int(11) NOT NULL,
  `share_id` int(11) NOT NULL,
  `ad_date` varchar(15) NOT NULL,
  `mr_no` int(11) NOT NULL,
  `pay_amount` decimal(11,2) NOT NULL,
  `cheque_no` varchar(20) DEFAULT NULL,
  `bank_id` varchar(11) DEFAULT NULL,
  `branch_name` varchar(120) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `supplier_detail`
--

CREATE TABLE `supplier_detail` (
  `supplier_detail_id` int(11) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `sproduct_id` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `unit_price` decimal(11,2) NOT NULL,
  `quantity` float NOT NULL,
  `payment_amount` decimal(11,2) DEFAULT NULL,
  `mr_no` varchar(30) DEFAULT NULL,
  `purchase_date` varchar(20) NOT NULL,
  `comments` varchar(350) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `supplier_information`
--

CREATE TABLE `supplier_information` (
  `supplier_id` int(11) NOT NULL,
  `supplier_name` varchar(50) NOT NULL,
  `prop_name` varchar(100) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `email_id` varchar(50) DEFAULT NULL,
  `photo` varchar(150) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `reference_by` varchar(100) DEFAULT NULL,
  `nid_no` varchar(25) DEFAULT NULL,
  `create_date` varchar(20) DEFAULT NULL,
  `supply_policy` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `supplier_information`
--

INSERT INTO `supplier_information` (`supplier_id`, `supplier_name`, `prop_name`, `address`, `mobile_no`, `email_id`, `photo`, `signature`, `reference_by`, `nid_no`, `create_date`, `supply_policy`, `user_id`) VALUES
(1, 'AC SUPPLIER', 'JAMALUDHEEN', 'test', '7829333010', 'supplier@gmail.com', NULL, NULL, 'test', '', NULL, 'test', 1),
(2, 'IT SUPPLIER', 'TEST', 'TEST', '7829333010', 'shafeekibnukader@gmail.com', NULL, NULL, 'AGENT', '', NULL, 'TEST', 1),
(3, 'KHARAMA_DOHA', 'ELECTRICITY', 'KHARAMA', '2332323233', 'KHARAMA@GMAIL.COM', NULL, NULL, 'AGENT NAME', '', NULL, 'ELECTRICITY', 10);

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

--
-- Table structure for table `supplier_product`
--

CREATE TABLE `supplier_product` (
  `sproduct_id` int(11) NOT NULL,
  `sproduct_name` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `supplier_product`
--

INSERT INTO `supplier_product` (`sproduct_id`, `sproduct_name`) VALUES
(1, 'AIR CONDITION'),
(2, 'TABLE');

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

--
-- Table structure for table `sys_menu`
--

CREATE TABLE `sys_menu` (
  `menu_id` int(11) NOT NULL,
  `menu_label` varchar(100) NOT NULL,
  `link` varchar(100) NOT NULL DEFAULT '#',
  `icon` varchar(100) NOT NULL DEFAULT 'fa fa-external-link-square',
  `parent` int(11) NOT NULL DEFAULT 0,
  `sort` int(11) NOT NULL,
  `head_office` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;



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

--
-- Table structure for table `sys_user_role`
--

CREATE TABLE `sys_user_role` (
  `user_role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `sys_user_role`
--

INSERT INTO `sys_user_role` (`user_role_id`, `user_id`, `menu_id`) VALUES
(163, 10, 1),
(164, 10, 2),
(165, 10, 3),
(166, 10, 4),
(167, 10, 6),
(168, 10, 7),
(169, 10, 8),
(170, 10, 9),
(171, 10, 10),
(172, 10, 11),
(173, 10, 12),
(174, 10, 13),
(175, 10, 14),
(176, 10, 15),
(177, 10, 16),
(178, 10, 17),
(179, 10, 18),
(180, 10, 19),
(181, 10, 20),
(182, 10, 21),
(183, 10, 22),
(184, 10, 23),
(185, 10, 24),
(186, 10, 25),
(187, 10, 26),
(188, 10, 27),
(189, 10, 28),
(190, 10, 29),
(191, 10, 30),
(192, 10, 31),
(193, 10, 32),
(194, 10, 35),
(195, 10, 33),
(196, 10, 34),
(197, 10, 36),
(198, 10, 37),
(199, 10, 47),
(200, 10, 38),
(201, 10, 39),
(202, 10, 40),
(203, 10, 41),
(204, 10, 42),
(205, 10, 43),
(206, 10, 44),
(207, 10, 45),
(208, 10, 46),
(209, 10, 48),
(210, 10, 49),
(211, 10, 50),
(212, 10, 51),
(213, 10, 52),
(214, 10, 53),
(215, 10, 54),
(216, 10, 55),
(217, 10, 56),
(218, 10, 57),
(219, 10, 58),
(220, 10, 59),
(221, 10, 60),
(222, 10, 61),
(223, 10, 73),
(224, 10, 76),
(225, 10, 80),
(226, 10, 82),
(227, 10, 62),
(228, 10, 63),
(229, 10, 64),
(230, 10, 65),
(231, 10, 66),
(232, 10, 67),
(233, 10, 75),
(234, 10, 77),
(235, 10, 81),
(236, 10, 69),
(237, 10, 70),
(238, 10, 71),
(239, 10, 74),
(240, 10, 72),
(241, 10, 78),
(242, 10, 5),
(243, 10, 79),
(244, 11, 1),
(245, 11, 6),
(246, 11, 8),
(247, 11, 9),
(248, 11, 10),
(249, 12, 1),
(250, 12, 6),
(251, 12, 8),
(252, 12, 9),
(253, 12, 10),
(335, 9, 1),
(336, 9, 2),
(337, 9, 3),
(338, 9, 4),
(339, 9, 6),
(340, 9, 7),
(341, 9, 8),
(342, 9, 9),
(343, 9, 10),
(344, 9, 11),
(345, 9, 12),
(346, 9, 13),
(347, 9, 14),
(348, 9, 15),
(349, 9, 16),
(350, 9, 17),
(351, 9, 18),
(352, 9, 19),
(353, 9, 20),
(354, 9, 21),
(355, 9, 22),
(356, 9, 23),
(357, 9, 24),
(358, 9, 25),
(359, 9, 26),
(360, 9, 27),
(361, 9, 28),
(362, 9, 29),
(363, 9, 30),
(364, 9, 31),
(365, 9, 32),
(366, 9, 35),
(367, 9, 33),
(368, 9, 34),
(369, 9, 36),
(370, 9, 37),
(371, 9, 47),
(372, 9, 38),
(373, 9, 39),
(374, 9, 40),
(375, 9, 41),
(376, 9, 42),
(377, 9, 43),
(378, 9, 44),
(379, 9, 45),
(380, 9, 46),
(381, 9, 48),
(382, 9, 49),
(383, 9, 50),
(384, 9, 51),
(385, 9, 52),
(386, 9, 53),
(387, 9, 54),
(388, 9, 55),
(389, 9, 56),
(390, 9, 57),
(391, 9, 58),
(392, 9, 59),
(393, 9, 60),
(394, 9, 61),
(395, 9, 73),
(396, 9, 76),
(397, 9, 80),
(398, 9, 82),
(399, 9, 62),
(400, 9, 63),
(401, 9, 64),
(402, 9, 65),
(403, 9, 66),
(404, 9, 67),
(405, 9, 75),
(406, 9, 77),
(407, 9, 81),
(408, 9, 69),
(409, 9, 70),
(410, 9, 71),
(411, 9, 74),
(412, 9, 72),
(413, 9, 78),
(414, 9, 5),
(415, 9, 79),
(416, 13, 1),
(417, 13, 2),
(418, 13, 3),
(419, 13, 4),
(420, 13, 6),
(421, 13, 7),
(422, 13, 8),
(423, 13, 9),
(424, 13, 10),
(425, 13, 11),
(426, 13, 12),
(427, 13, 13),
(428, 13, 14),
(429, 13, 15),
(430, 13, 16),
(431, 13, 17),
(432, 13, 18),
(433, 13, 19),
(434, 13, 20),
(435, 13, 21),
(436, 13, 22),
(437, 13, 23),
(438, 13, 24),
(439, 13, 25),
(440, 13, 26),
(441, 13, 27),
(442, 13, 28),
(443, 13, 29),
(444, 13, 30),
(445, 13, 31),
(446, 13, 32),
(447, 13, 35),
(448, 13, 33),
(449, 13, 34),
(450, 13, 36),
(451, 13, 37),
(452, 13, 47),
(453, 13, 38),
(454, 13, 39),
(455, 13, 40),
(456, 13, 41),
(457, 13, 42),
(458, 13, 43),
(459, 13, 44),
(460, 13, 45),
(461, 13, 46),
(462, 13, 48),
(463, 13, 49),
(464, 13, 50),
(465, 13, 51),
(466, 13, 52),
(467, 13, 53),
(468, 13, 54),
(469, 13, 55),
(470, 13, 56),
(471, 13, 57),
(472, 13, 58),
(473, 13, 59),
(474, 13, 60),
(475, 13, 61),
(476, 13, 73),
(477, 13, 76),
(478, 13, 80),
(479, 13, 82),
(480, 13, 62),
(481, 13, 63),
(482, 13, 64),
(483, 13, 65),
(484, 13, 66),
(485, 13, 67),
(486, 13, 75),
(487, 13, 77),
(488, 13, 81),
(489, 13, 69),
(490, 13, 70),
(491, 13, 71),
(492, 13, 74),
(493, 13, 72),
(494, 13, 78),
(495, 13, 5),
(496, 13, 79);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_table`
--
ALTER TABLE `account_table`
  ADD PRIMARY KEY (`account_id`);

--
-- Indexes for table `agreement_info`
--
ALTER TABLE `agreement_info`
  ADD PRIMARY KEY (`agreement_id`);

--
-- Indexes for table `assetbuy`
--
ALTER TABLE `assetbuy`
  ADD PRIMARY KEY (`buy_id`);

--
-- Indexes for table `asset_information`
--
ALTER TABLE `asset_information`
  ADD PRIMARY KEY (`asset_id`);

--
-- Indexes for table `bank_information`
--
ALTER TABLE `bank_information`
  ADD PRIMARY KEY (`bank_id`);

--
-- Indexes for table `broker_information`
--
ALTER TABLE `broker_information`
  ADD PRIMARY KEY (`broker_id`);

--
-- Indexes for table `budget_cost`
--
ALTER TABLE `budget_cost`
  ADD PRIMARY KEY (`budget_cost_id`);

--
-- Indexes for table `cash_register`
--
ALTER TABLE `cash_register`
  ADD PRIMARY KEY (`register_id`);

--
-- Indexes for table `cash_register_detail`
--
ALTER TABLE `cash_register_detail`
  ADD PRIMARY KEY (`register_detail_id`);

--
-- Indexes for table `cheque_book`
--
ALTER TABLE `cheque_book`
  ADD PRIMARY KEY (`cheque_id`);

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

--
-- Indexes for table `contractor_detail`
--
ALTER TABLE `contractor_detail`
  ADD PRIMARY KEY (`contractor_detail_id`);

--
-- Indexes for table `contractor_information`
--
ALTER TABLE `contractor_information`
  ADD PRIMARY KEY (`contractor_id`);

--
-- Indexes for table `contractor_product`
--
ALTER TABLE `contractor_product`
  ADD PRIMARY KEY (`cproduct_id`);

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

--
-- Indexes for table `customer_information`
--
ALTER TABLE `customer_information`
  ADD PRIMARY KEY (`customer_id`),
  ADD KEY `fk_customer_information_project_id` (`project_id`);

--
-- Indexes for table `director_share`
--
ALTER TABLE `director_share`
  ADD PRIMARY KEY (`share_id`),
  ADD UNIQUE KEY `employee_id` (`employee_id`);

--
-- Indexes for table `employee_information`
--
ALTER TABLE `employee_information`
  ADD PRIMARY KEY (`employee_id`);

--
-- Indexes for table `employee_loan`
--
ALTER TABLE `employee_loan`
  ADD PRIMARY KEY (`loan_id`);

--
-- Indexes for table `employee_loan_ad`
--
ALTER TABLE `employee_loan_ad`
  ADD PRIMARY KEY (`loan_ad_id`);

--
-- Indexes for table `employee_salary`
--
ALTER TABLE `employee_salary`
  ADD PRIMARY KEY (`emp_salary_id`);

--
-- Indexes for table `expense_category`
--
ALTER TABLE `expense_category`
  ADD PRIMARY KEY (`cat_id`);

--
-- Indexes for table `flat_info`
--
ALTER TABLE `flat_info`
  ADD PRIMARY KEY (`flat_id`);

--
-- Indexes for table `landowner_detail`
--
ALTER TABLE `landowner_detail`
  ADD PRIMARY KEY (`land_id`);

--
-- Indexes for table `landowner_information`
--
ALTER TABLE `landowner_information`
  ADD PRIMARY KEY (`landowner_id`);

--
-- Indexes for table `marketing_list`
--
ALTER TABLE `marketing_list`
  ADD PRIMARY KEY (`marketing_id`);

--
-- Indexes for table `oldassetsell`
--
ALTER TABLE `oldassetsell`
  ADD PRIMARY KEY (`assetsell_id`);

--
-- Indexes for table `org_info`
--
ALTER TABLE `org_info`
  ADD PRIMARY KEY (`org_id`);

--
-- Indexes for table `post`
--
ALTER TABLE `post`
  ADD PRIMARY KEY (`post_id`);

--
-- Indexes for table `project_information`
--
ALTER TABLE `project_information`
  ADD PRIMARY KEY (`project_id`);

--
-- Indexes for table `register_deposit_money`
--
ALTER TABLE `register_deposit_money`
  ADD PRIMARY KEY (`deposit_id`);

--
-- Indexes for table `requisition_detail`
--
ALTER TABLE `requisition_detail`
  ADD PRIMARY KEY (`detail_id`);

--
-- Indexes for table `requisition_information`
--
ALTER TABLE `requisition_information`
  ADD PRIMARY KEY (`req_id`);

--
-- Indexes for table `salary_table`
--
ALTER TABLE `salary_table`
  ADD PRIMARY KEY (`salary_id`);

--
-- Indexes for table `share_adjaustment`
--
ALTER TABLE `share_adjaustment`
  ADD PRIMARY KEY (`share_ad_id`);

--
-- Indexes for table `supplier_detail`
--
ALTER TABLE `supplier_detail`
  ADD PRIMARY KEY (`supplier_detail_id`);

--
-- Indexes for table `supplier_information`
--
ALTER TABLE `supplier_information`
  ADD PRIMARY KEY (`supplier_id`);

--
-- Indexes for table `supplier_product`
--
ALTER TABLE `supplier_product`
  ADD PRIMARY KEY (`sproduct_id`);

--
-- Indexes for table `sys_menu`
--
ALTER TABLE `sys_menu`
  ADD PRIMARY KEY (`menu_id`);

--
-- Indexes for table `sys_user_role`
--
ALTER TABLE `sys_user_role`
  ADD PRIMARY KEY (`user_role_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `assetbuy`
--
ALTER TABLE `assetbuy`
  MODIFY `buy_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_information`
--
ALTER TABLE `asset_information`
  MODIFY `asset_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_information`
--
ALTER TABLE `bank_information`
  MODIFY `bank_id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `budget_cost`
--
ALTER TABLE `budget_cost`
  MODIFY `budget_cost_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_register`
--
ALTER TABLE `cash_register`
  MODIFY `register_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_register_detail`
--
ALTER TABLE `cash_register_detail`
  MODIFY `register_detail_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cheque_book`
--
ALTER TABLE `cheque_book`
  MODIFY `cheque_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `company_info`
--
ALTER TABLE `company_info`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contractor_detail`
--
ALTER TABLE `contractor_detail`
  MODIFY `contractor_detail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contractor_information`
--
ALTER TABLE `contractor_information`
  MODIFY `contractor_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contractor_product`
--
ALTER TABLE `contractor_product`
  MODIFY `cproduct_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `customer_information`
--
ALTER TABLE `customer_information`
  MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `director_share`
--
ALTER TABLE `director_share`
  MODIFY `share_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_information`
--
ALTER TABLE `employee_information`
  MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `employee_loan`
--
ALTER TABLE `employee_loan`
  MODIFY `loan_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_loan_ad`
--
ALTER TABLE `employee_loan_ad`
  MODIFY `loan_ad_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_salary`
--
ALTER TABLE `employee_salary`
  MODIFY `emp_salary_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense_category`
--
ALTER TABLE `expense_category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `flat_info`
--
ALTER TABLE `flat_info`
  MODIFY `flat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=152;

--
-- AUTO_INCREMENT for table `landowner_detail`
--
ALTER TABLE `landowner_detail`
  MODIFY `land_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `landowner_information`
--
ALTER TABLE `landowner_information`
  MODIFY `landowner_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `marketing_list`
--
ALTER TABLE `marketing_list`
  MODIFY `marketing_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oldassetsell`
--
ALTER TABLE `oldassetsell`
  MODIFY `assetsell_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `org_info`
--
ALTER TABLE `org_info`
  MODIFY `org_id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `post`
--
ALTER TABLE `post`
  MODIFY `post_id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `project_information`
--
ALTER TABLE `project_information`
  MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `register_deposit_money`
--
ALTER TABLE `register_deposit_money`
  MODIFY `deposit_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `requisition_detail`
--
ALTER TABLE `requisition_detail`
  MODIFY `detail_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `requisition_information`
--
ALTER TABLE `requisition_information`
  MODIFY `req_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `salary_table`
--
ALTER TABLE `salary_table`
  MODIFY `salary_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `share_adjaustment`
--
ALTER TABLE `share_adjaustment`
  MODIFY `share_ad_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_detail`
--
ALTER TABLE `supplier_detail`
  MODIFY `supplier_detail_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `sys_menu`
--
ALTER TABLE `sys_menu`
  MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `sys_user_role`
--
ALTER TABLE `sys_user_role`
  MODIFY `user_role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=497;
COMMIT;

