--
-- Host: localhost    Database: sub_global
-- ------------------------------------------------------


--
-- Table structure for table `amc_invoice`
--

CREATE TABLE `amc_invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amc_id` int(11) DEFAULT NULL,
  `modernization_id` int(11) DEFAULT NULL,
  `invoice_serial_no` int(11) NOT NULL,
  `invoice_no` varchar(100) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `date` varchar(100) NOT NULL,
  `type` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `amc_invoice`
--


--
-- Table structure for table `amc_invoice_setting`
--

CREATE TABLE `amc_invoice_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amc_id` int(11) DEFAULT NULL,
  `modernization_id` int(11) DEFAULT NULL,
  `no_of_invoice` int(11) NOT NULL,
  `remainder_dates` longtext,
  `amount_details` longtext NOT NULL,
  `type` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `amc_invoice_setting`
--


--
-- Table structure for table `amc_payments`
--

CREATE TABLE `amc_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amc_id` int(11) NOT NULL,
  `payment` varchar(100) NOT NULL,
  `tds` varchar(100) NOT NULL,
  `date` varchar(100) NOT NULL,
  `cheque_no` varchar(100) NOT NULL,
  `bank_name` varchar(600) NOT NULL,
  `bank_details` mediumtext NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `amc_payments`
--


--
-- Table structure for table `amc_proposal`
--

CREATE TABLE `amc_proposal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `letter_head` longtext NOT NULL,
  `contract_date` varchar(100) NOT NULL,
  `ge_no` varchar(1000) NOT NULL,
  `no_of_elevator` varchar(11) NOT NULL,
  `ref_no` varchar(1000) NOT NULL,
  `start_date` varchar(100) NOT NULL,
  `end_date` varchar(60) NOT NULL,
  `subject` longtext NOT NULL,
  `contract_type` varchar(100) NOT NULL,
  `gst` varchar(100) DEFAULT NULL,
  `grand_total` varchar(100) NOT NULL,
  `term_condition` longtext NOT NULL,
  `payment_terms` longtext NOT NULL,
  `suspension_subject` mediumtext,
  `suspension_content` longtext,
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0:not confirmed,1:confirmed,2:suspension',
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `amc_proposal`
--


--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `company_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `phone_no` varchar(20) NOT NULL,
  `alt_number` varchar(20) DEFAULT NULL,
  `GST` varchar(50) NOT NULL,
  `type_of_project` varchar(100) DEFAULT NULL,
  `address` mediumtext,
  `plot_no` varchar(50) DEFAULT NULL,
  `sector_no` varchar(50) DEFAULT NULL,
  `sitename_address` varchar(255) DEFAULT NULL,
  `areaname` varchar(255) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `lead_status` varchar(11) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client`
--

INSERT INTO `client` VALUES (1,'Nandu','Nandraj Gangurde','nandu@test.com','8421157611','7888059992','1234567',NULL,'Mumbai sakanaka','12','609/12','Vijay nagar Thane (W)','Shivaji Nagar',NULL,NULL,'2019-08-14 10:15:45','2019-08-14 10:15:45'),(2,'Mr. Gole','M/s. Gole Brothers','info@globalelevators.in','9870786215','9820786215','27aabcg1405h1z2',NULL,'office no-1, ssss','17','20','Plot no-17, Sector-20, Ulwe','ulwe',NULL,NULL,'2019-08-14 12:24:27','2019-08-14 12:24:27'),(3,'TestClient','TEST Builder','test@admin.com','8421157611','7888059992','1234567',NULL,'Thane (W)','12','23','Heel Views Thane (W)','Shivaji Nagar',NULL,NULL,'2019-08-14 12:38:33','2019-08-14 12:38:33'),(4,'Rajesh','Rajesh Bulidcon','Aaa@aa.com','9999999',NULL,'Bagjslmaggs',NULL,'Addrrss 1','25','9','Plot no 25, sector 15 , nerul','Nerul',NULL,NULL,'2019-08-17 04:55:49','2019-08-17 04:55:49');

--
-- Table structure for table `contract`
--

CREATE TABLE `contract` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_no` varchar(100) NOT NULL,
  `client_id` int(11) NOT NULL,
  `quotation_id` int(11) NOT NULL,
  `no_of_job` int(11) NOT NULL,
  `phases_details` mediumtext NOT NULL,
  `upload_details` mediumtext NOT NULL,
  `job_details` mediumtext NOT NULL,
  `job_price` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contract`
--


--
-- Table structure for table `enquiry`
--

CREATE TABLE `enquiry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(100) DEFAULT NULL,
  `client_id` int(11) NOT NULL,
  `site_address` mediumtext,
  `site_name` varchar(100) DEFAULT NULL,
  `details` mediumtext,
  `approved_by_admin` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0: intiail 1:sent_for_approval 2:approved_by_admin',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0: new 1: old 2:revised',
  `client_finalization` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0:not finalized 1:finalized',
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `enquiry`
--

INSERT INTO `enquiry` VALUES (1,'ENQ-19/20-1',1,NULL,NULL,'[{\"elevator_type\":\"Hydraulic\",\"operation_type\":\"Manual Door\",\"no_of_requirement\":\"1\",\"landings\":\"2\",\"stop\":\"5\",\"floor_served\":\"8\",\"floor_designation\":\"Steps\",\"well_wide\":\"600\",\"well_deep\":\"900\",\"car_wide\":\"500\",\"car_deep\":\"800\",\"opening_wide\":\"550\",\"opening_deep\":\"850\",\"overhead\":\"50\",\"pit\":\"10\",\"elevatore_use\":\"Passenger\",\"number_passenger\":\"4\",\"load\":\"272\",\"cabin\":\"S.S.Cabin\",\"cabin_back_panel\":\"Decorative Finish\",\"cabin_side_panel\":\"Mirror finish\",\"cabin_front_panel\":\"Mirror finish\",\"cabin_corner_panel\":\"Gold finish\",\"cabin_back_panel_other\":null,\"cabin_side_panel_other\":null,\"cabin_front_panel_other\":null,\"cabin_corner_panel_other\":null,\"speed_type\":\"Single\",\"speed\":\"0.7\",\"type_of_control\":\"Micro Contoller\",\"controller\":\"Duplex\",\"collective\":\"Down Collective\",\"attendant\":\"Yes\",\"opening_side\":\"Right angle side\",\"opening_floor\":\"3\",\"machine_position\":\"Hydraulic power pack unit at lowest floor\",\"flat_round\":\"round\",\"half_full\":\"full\",\"axil_flow\":\"no\",\"blower\":\"yes\",\"led\":null,\"car_door_type\":\"M.S\",\"car_door_desc\":\"Imperforated\",\"car_material\":\"M.S.Powder coated finish\",\"car_material_other\":null,\"landing_door_type\":\"M.S\",\"landing_door_desc\":\"Imperforated\",\"landing_material\":\"M.S.Powder coated finish\",\"landing_door_option\":\"yes\",\"landing_material_other\":null,\"landing_door_floor\":null,\"landing_second_material\":\"M.S.Powder coated finish\",\"landing_second_material_other\":null,\"false_cieling\":\"Mirror finish\",\"false_cieling_other\":null,\"platform\":\"Alluminium Chequred Plate\",\"normal_operation\":[\"Direction Indicator in Steady Arrow\"],\"safety_feature\":[\"Intercom facility\",\"CCTV wiring Provision\"],\"power_supply\":\"415 Volts, 3 Phase, 50 Cycles 5%\",\"lighting_supply\":\"230 Volts, 1 Phase, 50 Cycles 5%\",\"other_info\":[\"Minor civil work\",\"Door frame\"],\"amount\":\"250000\",\"tax_pay\":\"Yes\",\"tax_slab\":\"18%\",\"sales_person_name\":\"Mr. Sachin Supekar\",\"pwd\":\"no\",\"notes\":\"<p><span style=\\\"font-weight: bold; color: rgb(106, 106, 106); font-family: arial, sans-serif; font-size: 14px;\\\">Lorem ipsum<\\/span><span style=\\\"color: rgb(84, 84, 84); font-family: arial, sans-serif; font-size: 14px;\\\">, or&nbsp;<\\/span><span style=\\\"font-weight: bold; color: rgb(106, 106, 106); font-family: arial, sans-serif; font-size: 14px;\\\">lipsum<\\/span><span style=\\\"color: rgb(84, 84, 84); font-family: arial, sans-serif; font-size: 14px;\\\">&nbsp;as it is sometimes known,<\\/span><br><span style=\\\"color: rgb(84, 84, 84); font-family: arial, sans-serif; font-size: 14px;\\\">is dummy text used in laying out print, graphic or web designs.<\\/span><br><span style=\\\"color: rgb(84, 84, 84); font-family: arial, sans-serif; font-size: 14px;\\\">The passage is attributed to an unknown<\\/span><br><br><br><br><br><br><\\/p>\"}]',2,0,1,'2019-08-17 08:37:53','2019-11-12 06:21:19');

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(100) NOT NULL,
  `contract_id` int(11) NOT NULL,
  `phase_no` int(11) NOT NULL,
  `phase_amount` varchar(20) NOT NULL,
  `amount_paid` varchar(11) NOT NULL DEFAULT '0',
  `bill_date` varchar(200) DEFAULT NULL,
  `type` tinyint(2) NOT NULL COMMENT '1: Erection 2 : AMC 3: Modernization 4: Replacement',
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoices`
--


--
-- Table structure for table `mordernization`
--

CREATE TABLE `mordernization` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `contract_number` varchar(11) NOT NULL,
  `subject` text,
  `body` mediumtext,
  `service_id` mediumtext,
  `service_name` mediumtext,
  `description` mediumtext,
  `qty` mediumtext,
  `rate` mediumtext,
  `gst` mediumtext,
  `amount` mediumtext,
  `grand_total` int(11) DEFAULT NULL,
  `note` text,
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0:not confirmed,1:confirmed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mordernization`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `date` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `quotation`
--

CREATE TABLE `quotation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `enquiry_id` int(11) NOT NULL,
  `invoice_no` varchar(100) NOT NULL,
  `site_address` mediumtext NOT NULL,
  `requirement_details` mediumtext NOT NULL,
  `site_name` varchar(400) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `services_details` mediumtext NOT NULL,
  `no_of_job` int(11) NOT NULL,
  `main_type` mediumtext NOT NULL,
  `cost_each` mediumtext NOT NULL,
  `type_elevator` mediumtext NOT NULL,
  `no_of_requirement` mediumtext NOT NULL,
  `phases_details` mediumtext NOT NULL,
  `other_details` mediumtext NOT NULL,
  `state` varchar(100) NOT NULL,
  `date` varchar(100) NOT NULL,
  `quotation_subject` mediumtext,
  `quotation_body` mediumtext,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quotation`
--

INSERT INTO `quotation` VALUES (1,9,6,'QTY-19/20-1','nishi chs, plot no-21, Sector-16A, Vashi,','[{\"person_contacted\":\"Mr. Radharishnan\",\"amount\":\"500000\",\"elevator_type\":\"With Machine Room\",\"operation_type\":\"Manual Door\",\"no_of_requirement\":\"1\",\"travel_height\":\"18\",\"floor_served\":\"4th\",\"landings\":\"4\",\"floor_designation\":\"g+1+2+3+4\",\"well_wide\":\"1300\",\"well_deep\":\"1300\",\"car_wide\":\"900\",\"car_deep\":\"850\",\"opening_wide\":\"700\",\"opening_deep\":\"2000\",\"overhead\":\"4200\",\"pit\":\"1500\",\"type_car\":\"MS\",\"type_of_control\":\"Micro Processor ACVVVF\",\"controller\":\"Simplex\",\"collective\":\"Down Collective\",\"attendant\":\"No\",\"speed_type\":\"Variable\",\"speed\":\"0.32\",\"elevatore_use\":\"Passenger\",\"number_passenger\":\"4\",\"load\":\"272\",\"stop\":\"4\",\"opening\":null,\"opening_side\":\"Same side\",\"opening_floor\":null,\"machine_position\":\"Yes\",\"cabin\":\"M.S. Cabin\",\"cabin_back_panel\":\"M.S.Powder coated finish\",\"cabin_front_panel\":\"M.S.Powder coated finish\",\"cabin_corner_panel\":\"M.S.Powder coated finish\",\"cabin_side_panel\":\"Hairline finish\",\"cabin_back_panel_other\":null,\"cabin_side_panel_other\":null,\"cabin_front_panel_other\":null,\"cabin_corner_panel_other\":null,\"flat_round\":\"round\",\"half_full\":\"half\",\"axil_flow\":\"yes\",\"blower\":\"yes\",\"led\":\"2\",\"car_door_type\":\"M.S\",\"car_door_desc\":\"Collapsible\",\"car_material\":\"M.S.Powder coated finish\",\"car_material_other\":null,\"landing_door_type\":\"M.S\",\"landing_door_desc\":\"Collapsible\",\"landing_material\":\"M.S.Powder coated finish\",\"landing_door_option\":\"yes\",\"landing_material_other\":null,\"landing_door_floor\":null,\"landing_door_floor_second\":null,\"landing_second_material\":\"M.S.Powder coated finish\",\"landing_second_material_other\":null,\"false_cieling\":\"M.S. In powder coated finish\",\"false_cieling_other\":null,\"platform\":\"PVC antiskid flooring in black colour\",\"normal_operation\":[\"Digital floor position in Seven Segment\",\"Car door open bell compulsary for Manual operation\",\"Overload system Compulsary for all operations\",\"Voice announcement System\",\"Direction Indicator in Steady Arrow\"],\"safety_feature\":[\"Battery operated Emergency Alarm\",\"Emergency Light\",\"Auto Rescue Device\"],\"power_supply\":\"415 Volts, 3 Phase, 50 Cycles 5%\",\"lighting_supply\":\"230 Volts, 1 Phase, 50 Cycles 5%\",\"other_info\":[\"Scafolding in the shaft\",\"Minor civil work\",\"Door frame\",\"Electrical work\"],\"notes\":\"1. for S.S.Cabin our cost will be Rs. 32000\\/-extra.\"}]','nidhi','545000','[[{\"title\":[\"TECHNICAL DETAILS FOR Manual Door LIFT\"],\"key\":[\"Type\",\"No of Units\",\"Load & Passenger\",\"Speed\",\"Control\",\"Operation\"],\"value\":[\"Passenger\",\"1\",\"272 Kgs 4 Passenger\",\"0.32 m\\/s Variable Speed\",\"Micro Processor ACVVVF control panel\",\"Simplex Down Collective system without attendant\"]},{\"title\":[\"LIFT WELL DETAILS\"],\"key\":[\"Travels\",\"Stops & Openings\",\"Hoistway Available\",\"Overhead required\",\"Pit Required\",\"Machine Type & Position\"],\"value\":[\"Ground Floor to 4th floor\",\"4 stops &  Opening (Same side)\",\"1300 mm wide 1300 mm deep\",\"4200 mm\",\"1500 mm\",\"Yes\"]},{\"title\":[\"CABIN DETAILS\"],\"key\":[\"Car Opening\",\"Clear Opening\",\"Cabin Type\",\"Other\",\"Cabin Door\",\"Platform\",\"False Ceiling\",\"Fan & Light\"],\"value\":[\"900 mm wide 850 mm deep\",\"1300 mm wide 1300 mm deep\",\"M.S. CabinBack panel M.S. Cabin.M.S.Powder coated finish <br> Corner panel M.S. Cabin.M.S.Powder coated finish <br> Side Panel M.S. Cabin.Hairline finish <br> Front Panel M.S. Cabin.M.S.Powder coated finish\",\"half size Mirror &  M.S. Cabin.round handrail\",\"M.S Collapsible with in M.S.Powder coated finish with\",\"PVC antiskid flooring in black colour\",\"M.S. In powder coated finish\",\"2nos of LED lights &\"]},{\"title\":[\"LANDING DETAILS\"],\"key\":[\"Landing Door\",\"Height required\"],\"value\":[\"M.S Collapsible with in M.S.Powder coated finish with  at 1s to 4th <br>\",\"2700\"]},{\"title\":[\"SIGNALS DETAILS\"],\"key\":[\"Normal Operation\",\"Safety Feature\"],\"value\":[\", Digital floor position in Seven Segment, Car door open bell compulsary for Manual operation, Overload system Compulsary for all operations, Voice announcement System, Direction Indicator in Steady Arrow\",\", Battery operated Emergency Alarm, Emergency Light, Auto Rescue Device\"]},{\"title\":[\"BY CLIENT\"],\"key\":[\"Power Supply\",\"Lighting Supply\",\"Other\"],\"value\":[\"415 Volts, 3 Phase, 50 Cycles 5%\",\"230 Volts, 1 Phase, 50 Cycles 5%\",\", Scafolding in the shaft, Minor civil work, Door frame, Electrical work\"]}]]',1,'[\"Passenger\"]','[\"545000\"]','[\"With Machine Room\"]','[\"1\"]','{\"percentage\":[\"20\",\"50\",\"30\",\"10\",\"0\"],\"amount\":[\"109000\",\"272500\",\"163500\",\"54500\",null],\"description\":[\"Advance\",null,null,null,null]}','{\"month\":\"2-3\",\"time\":\"2-3\",\"kg\":\"2500\"}','maharashtra','13/8/2019','Supply, Installation and maintenance of 1 No. of Passenger-With Machine Room at Proposed site at same as above','&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thank you for considering us and giving us a chance to provide a quotation for your project. We would like\r\nto introduce us as an ISO 9001:2008 certified company and one of the leading elevator manufacturer in Navi\r\nMumbai area with more than 3000 installations. We have installed all types of elevators from home elevators to\r\nCar elevators with 3000 Kgs capacity, machine room less (MRL) applications as well as hydraulic applications,\r\nelevators up to 1.5 mps speed. To provide best quality material with best workmanship and best after sale\r\nservice is what we believe into.<br>\r\n<u><b>Validity:</b></u><br>\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The amount quoted by us is valid for acceptance for a period of 30 days from the date of this offer. <br><br>\r\n<u><b>Contract Amount:</b></u><br>\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The contract amount quoted is for complete execution of entire job as per the specifications &amp; contract\r\nterms. If any other taxes are applicable; it will be charged extra.<br><br>\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;We earnestly hope that you will find our offer very attractive and distinct one and favour us with your\r\nvaluable orders.<br><br>\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanking you &amp; assuring you of our best services at all times and looking forward to a long-term business\r\nrelationship, we remain.<br><br>','2019-08-13 06:56:22','2019-08-13 06:56:22');

--
-- Table structure for table `sales_person`
--

CREATE TABLE `sales_person` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `phone_no` varchar(20) NOT NULL,
  `address` mediumtext NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sales_person`
--


--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` mediumtext NOT NULL,
  `rate` varchar(20) DEFAULT NULL,
  `gst` varchar(20) DEFAULT NULL,
  `hsn` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `services`
--



