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

START TRANSACTION;



--
-- Database: `sassolut_ran_inspection`
--

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

--
-- Table structure for table `assigned_inspections`
--

CREATE TABLE `assigned_inspections` (
  `id` int(11) NOT NULL,
  `client_name` varchar(200) DEFAULT NULL,
  `client_description` varchar(200) DEFAULT NULL,
  `client_address` varchar(200) DEFAULT NULL,
  `client_email` varchar(200) DEFAULT NULL,
  `client_phone` varchar(255) DEFAULT NULL,
  `assigned_date` varchar(200) DEFAULT NULL,
  `agent_id` varchar(200) DEFAULT NULL,
  `assigned_agent` varchar(200) DEFAULT NULL,
  `assigned_agent_email` varchar(200) DEFAULT NULL,
  `broker_name` varchar(255) DEFAULT NULL,
  `broker_email` varchar(255) DEFAULT NULL,
  `broker_phone` varchar(255) DEFAULT NULL,
  `type_of_room` varchar(200) DEFAULT NULL,
  `style` varchar(200) DEFAULT NULL,
  `home_age` varchar(200) DEFAULT NULL,
  `bathroom` varchar(200) DEFAULT NULL,
  `additional_room` varchar(200) DEFAULT NULL,
  `garage_type` varchar(200) DEFAULT NULL,
  `doors` varchar(200) DEFAULT NULL,
  `crawl_space` varchar(200) DEFAULT NULL,
  `basement` varchar(200) DEFAULT NULL,
  `ac_unit` varchar(200) DEFAULT NULL,
  `furnace` varchar(200) DEFAULT NULL,
  `water_heater` varchar(200) DEFAULT NULL,
  `dining_room` varchar(200) DEFAULT NULL,
  `living_room` varchar(200) DEFAULT NULL,
  `utilities` varchar(200) DEFAULT NULL,
  `main_entrance` varchar(200) DEFAULT NULL,
  `scope_inspection` varchar(2000) DEFAULT NULL,
  `weater_condition` varchar(200) DEFAULT NULL,
  `recent_rain` varchar(200) DEFAULT NULL,
  `ground_cover` varchar(200) DEFAULT NULL,
  `state_of_occupancy` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `assigned_inspections`
--

INSERT INTO `assigned_inspections` (`id`, `client_name`, `client_description`, `client_address`, `client_email`, `client_phone`, `assigned_date`, `agent_id`, `assigned_agent`, `assigned_agent_email`, `broker_name`, `broker_email`, `broker_phone`, `type_of_room`, `style`, `home_age`, `bathroom`, `additional_room`, `garage_type`, `doors`, `crawl_space`, `basement`, `ac_unit`, `furnace`, `water_heater`, `dining_room`, `living_room`, `utilities`, `main_entrance`, `scope_inspection`, `weater_condition`, `recent_rain`, `ground_cover`, `state_of_occupancy`, `created_at`, `updated_at`) VALUES
(62, 'Carter otrig', NULL, 'Texas In ', 'carter@gmail.xom', '65959599569', '7-28-2023', '43', 'Mark Bezos', 'Markbezos@gmail.com', 'Mark Bezos', 'example@gmail.com', '1234567890', 'Single family', '2 Story', '23', '2 bathrooms', '2 rooms', 'attached', '2 doors', 'no', 'no', '3 units', 'furnance 3', '4', 'yes', 'yes', 'null', 'East', 'All components designated for inspection in the INACHI Standards of Practice are inspected, except as may be noted in the \"Limitations of Inspection\" sections within this report. It is the goal of the inspection to put a home buyer in a better position to make a buying decision. Not all improvements will be identified during this inspection. Unexpected repairs should still be anticipated. The inspection should not be considered a guarantee or warranty of any kind. Please refer to the pre-inspection contract for a full explanation of the scope of the inspection.', 'Snow ', 'No', 'Dry', 'Partially Furnished', '2023-07-27 17:53:31', NULL),
(63, 'Joe Dirt', NULL, '123 Dinger Street', 'Dirt@yahoo.com', '254', '7-28-2023', '46', 'Carter Otrig', 'carter.otrig@gmail.com', 'Carter Otrig', 'example@gmail.com', '3025258192', 'Single family', '1 Story', '24', '4 bathrooms', '2 rooms', 'attached', '3 doors', 'no', 'no', '2 units', 'furnance 2', '2', 'not', 'not', 'null', 'North', 'Standards of Practice', 'Sunny', 'Yes', 'Dry', 'Vacant', '2023-07-28 17:15:57', NULL);

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `comment_title` varchar(200) DEFAULT NULL,
  `comment` mediumtext DEFAULT NULL,
  `inspection_type` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `comment_title`, `comment`, `inspection_type`, `created_at`, `updated_at`) VALUES
(46, 'Test Gutterzzz', 'This is a test gutter comment.', 'null', '2023-02-09 10:40:50', '2023-07-05 19:14:55'),
(47, 'test roof', 'test roof', 'Roof', '2023-02-09 11:36:54', NULL);

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_name` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `state` varchar(200) DEFAULT NULL,
  `province` varchar(200) DEFAULT NULL,
  `zip` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `profilepic` longtext DEFAULT 'CompanyImage.jpg'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `inspection_form`
--

CREATE TABLE `inspection_form` (
  `id` int(11) NOT NULL,
  `inspector_id` int(11) DEFAULT NULL,
  `inspection_id` int(11) DEFAULT NULL,
  `crawl_space` longtext DEFAULT NULL,
  `garage` longtext DEFAULT NULL,
  `ground` longtext DEFAULT NULL,
  `gutter` longtext DEFAULT NULL,
  `interior` longtext DEFAULT NULL,
  `kitchen` longtext DEFAULT NULL,
  `roof` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `inspection_form`
--

INSERT INTO `inspection_form` (`id`, `inspector_id`, `inspection_id`, `crawl_space`, `garage`, `ground`, `gutter`, `interior`, `kitchen`, `roof`, `created_at`, `updated_at`) VALUES
(189, 43, 62, '', '[{\"typeVisibile\":null,\"garageType\":\"1-Car\",\"garageTypeComment\":null,\"Images\":[],\"Value\":[]},{\"automaticVisibile\":null,\"automaticOperation\":\"Operable\",\"automaticComment\":null,\"Images\":[],\"Value\":[]},{\"SafetyReverseVisible\":null,\"safetyReverseOperation\":\"Photo eyes and pressure reverse tested\",\"safetyReverseComment\":null,\"Images\":[],\"Value\":[]},{\"floorMaterial\":\"Concrete\",\"floorCondition\":\"Large Settling Cracks\",\"floorComment\":null,\"Images\":[],\"Source\":\"N/A\",\"Value\":[],\"otherInput\":\"\"},null,{\"overHeadMaterial\":\"Fiber/Glass\",\"overHeadVisible\":null,\"overHeadCondition\":\"Marginal\",\"overHeadRecommend\":\"no\",\"Images\":[],\"overHeadComment\":null,\"Value\":[]},{\"electricalVisible\":\"no\",\"ElectricOperableCheckbox\":false,\"electricalReverse\":\"not visible\",\"electricalGFCIOperableCheckbox\":false,\"electricalOpenGround\":\"Safety Hazard\",\"electricalGFCI\":\"Safety Hazard\",\"electricalComment\":null,\"Images\":[],\"Value\":[]},{\"fireseperationVisible\":null,\"fireseperationCondition\":\"Safety Hazard(s)\",\"fireseperationMoisture\":null,\"fireseperationTypical\":\"No\",\"fireseperationFireDoor\":\"Satisfactory\",\"fireseperationSelfClosure\":\"Inoperative\",\"fireseperationComment\":null,\"Images\":[],\"Value\":[]}]', '[{\"GroundPorchVisible\":null,\"GroundPorchCondition\":\"Marginal\",\"GroundPorchSupportPier\":\"Others\",\"GroundPorchFloor\":\"Poor\",\"GroundPorchComment\":null,\"Images\":[],\"Value\":[{\"title\":\"Test\",\"comment\":\"Test\"}],\"otherInput\":\"Testing\"},null,null,{\"DeckVisible\":null,\"DeckMatetial\":\"Composite\",\"DeckCondition\":null,\"DeckFinish\":\"Others\",\"DeckComment\":null,\"Images\":[],\"FinishInput\":null,\"Value\":[],\"otherInput\":\"\"},null,null,null,null,{\"StoopsVisible\":null,\"StoopsMatetial\":\"Gravel/Dirt \",\"StoopsCondition\":\"Poor\",\"MaterialInput\":null,\"StoopsComment\":null,\"Images\":[],\"Value\":[]},{\"StoopsVisible\":null,\"StoopsMatetial\":\"Gravel\",\"StoopsCondition\":\"Poor\",\"MaterialInput\":null,\"StoopsComment\":null,\"Images\":[],\"Value\":[]}]', '[null,null,null,null,null,null,null,null,null,{\"BuildingType\":\"Masonry\",\"BuildingCondition\":\"Poor\",\"BuildingComment\":null,\"MaterialInput\":null,\"Images\":[],\"Value\":[]},null,null,null,null]', '[[{\"Location\":[{\"comment\":\"Test\",\"key\":0}],\"Type\":[{\"comment\":\"Test\",\"key\":0}],\"WallAndCieling\":\"Marginal\",\"MoistureStains\":\"No\",\"MoistureStainsInputs\":[{\"comment\":\"\",\"key\":0}],\"Floor\":\"Marginal\",\"CielingFan\":\"Satisfactory\",\"Electrical\":\"Cover Plates Missing\",\"Switches\":\"No\",\"Receptables\":\"Operable\",\"OpenGround\":\"\",\"HeatingSource\":\"No\",\"Holes\":\"Ceilings\",\"BedroomsEgrees\":\"No\",\"Doors\":\"Marginal\",\"Windows\":\"Marginal\",\"Comments\":[],\"Images\":[]},{\"Location\":[{\"comment\":\"\",\"key\":0}],\"Type\":[{\"comment\":\"\",\"key\":0}],\"WallAndCieling\":\"Marginal\",\"MoistureStains\":\"No\",\"MoistureStainsInputs\":[{\"comment\":\"\",\"key\":0}],\"Floor\":\"Marginal\",\"CielingFan\":\"Recommend Repair/Replace\",\"Electrical\":\"Cover Plates Missing\",\"Switches\":\"\",\"Receptables\":\"Operable\",\"OpenGround\":\"\",\"HeatingSource\":\"\",\"Holes\":\"Ceilings\",\"BedroomsEgrees\":\"No\",\"Doors\":\"Marginal\",\"Windows\":\"Marginal\",\"Comments\":[],\"Images\":[]}],[{\"Location\":[{\"comment\":\"Test\",\"key\":0}],\"SinksFaucet\":\"Yes\",\"PipesLeak\":\"No\",\"Sinks\":\"\",\"Tubs\":\"N/A\",\"TubsFaucet\":\"Yes\",\"TubsPipesLeaks\":\"No\",\"Showers\":\"\",\"ShowersFaucet\":\"No\",\"ShowersPipesLEak\":\"No\",\"WhirlPool\":\"GFCI Recommended\",\"WhirlPoolOperableCheckBox\":\"No\",\"WhirlPoolGFCICheckBox\":\"No\",\"ShowerTubsArea\":\"Fiber Glass\",\"Condtion\":\"\",\"Cault\":\"No\",\"WhereInputs\":[{\"comment\":\"\",\"key\":0}],\"Drainage\":\"Marginal\",\"WaterFlow\":\"Marginal\",\"MoistureStains\":\"Walls\",\"Doors\":\"Marginal\",\"Window\":\"Satisfactory\",\"ReceptablesPresent\":\"No\",\"ReceptablesPresentCheckbox\":\"\",\"GFCI\":\"Recommend GFCI\",\"GFCIOperableCheckbox\":\"\",\"OpenGround\":\"Potential Safety Hazard\",\"HeatingSource\":\"No\",\"Exhaustfan\":\"Noisy\",\"ExhaustfanOperable\":\"No\",\"Comments\":[],\"Images\":[],\"Toilet\":\"No\",\"ToiletOperableCheckBox\":\"No\",\"otherInput\":\"\"},{\"Location\":[{\"comment\":\"\",\"key\":0}],\"SinksFaucet\":\"No\",\"PipesLeak\":\"No\",\"Sinks\":\"\",\"Tubs\":\"N/A\",\"TubsFaucet\":\"No\",\"TubsPipesLeaks\":\"No\",\"Showers\":\"N/A\",\"ShowersFaucet\":\"No\",\"ShowersPipesLEak\":\"No\",\"WhirlPool\":\"Not Tested\",\"WhirlPoolOperableCheckBox\":\"Yes\",\"WhirlPoolGFCICheckBox\":\"\",\"ShowerTubsArea\":\"Fiber Glass\",\"Condtion\":\"\",\"Cault\":\"Yes\",\"WhereInputs\":[{\"comment\":\"\",\"key\":0}],\"Drainage\":\"Marginal\",\"WaterFlow\":\"Marginal\",\"MoistureStains\":\"Walls\",\"Doors\":\"Marginal\",\"Window\":\"Satisfactory\",\"ReceptablesPresent\":\"No\",\"ReceptablesPresentCheckbox\":\"\",\"GFCI\":\"Recommend GFCI\",\"GFCIOperableCheckbox\":\"\",\"OpenGround\":\"Potential Safety Hazard\",\"HeatingSource\":\"Yes\",\"Exhaustfan\":\"Noisy\",\"ExhaustfanOperable\":\"\",\"Comments\":[],\"Images\":[],\"Toilet\":\"\",\"ToiletOperableCheckBox\":\"Yes\",\"otherInput\":\"\"}],null,{\"SmokeDetector\":\"Present\",\"SmokeDetectorCheckBox\":false,\"SmokeCoDetector\":\"Not Present\",\"SmokeCoDetectorCheckBox\":false,\"SmokeComment\":null,\"Value\":[]},{\"AtticVisible\":null,\"AtticAccess\":\"No Access\",\"AtticAccessInput\":null,\"AtticInspect\":\"In the Attic\",\"AtticLocation\":\"Garage\",\"AtticFlooring\":\"None\",\"AtticInsulation\":null,\"AtticInsulationInput\":null,\"AtticInstalled\":null,\"AtticVapour\":\"Plastic Sheeting\",\"FanExhauseCheckBox\":\"Recommend Repair\",\"FanHVACCheckBox\":null,\"AtticVentilation\":\"Not Visible\",\"AtticFan\":\"Not Visible\",\"AtticHVAC\":\"Leaking\",\"AtticChimney\":\"Need Repair\",\"AtticStructutal\":\"Recommend Repair\",\"AtticRoofStructure\":\"Leaking\",\"AtticCieling\":\"Not Visible\",\"AtticSheathing\":null,\"AtticEvidanceOfCon\":\"No\",\"AtticEvidanceOfMois\":\"No\",\"AtticEvidanceOfLeaking\":\"No\",\"AtticEvidanceOfUnits\":\"Yes\",\"AtticElectrical\":\"No Apparent Defect\",\"AtticComment\":null,\"Value\":[],\"inspectedFormInput\":\"\",\"locationInput\":\"\",\"insulations\":[\"Other\"],\"installeds\":[\"Walls\"],\"sheathing\":[\"Planking\"],\"otherInput\":\"\",\"otherInput2\":\"\"},{\"InteriorplumbingInput\":[{\"comment\":\"\"}],\"InteriorplumbingWaterEntry\":\"Copper/Galv\",\"InteriorplumbingLeadOther\":\"Unknown\",\"InteriorplumbingVisible\":null,\"InteriorplumbingVsibleWater\":\"PVC PLastic\",\"InteriorplumbingCondition\":\"Poor\",\"InteriorplumbingFlow\":\"Satisfactory\",\"InteriorplumbingPipeSupply\":\"Leaking\",\"InteriorplumbingPipeCheckBox\":null,\"InteriorplumbingVentPipe\":\"Galvanized\",\"InteriorplumbingCondition2\":\"Poor\",\"InteriorplumbingSupport\":null,\"InteriorplumbingSupportInputs\":[{\"comment\":\"\"}],\"InteriorplumbingTraps\":\"P-Traps Recommended\",\"InteriorplumbingDrainage\":\"Marginal\",\"InteriorplumbingInterior\":\"No\",\"InteriorplumbingFuelLine\":\"Brass\",\"InteriorplumbingDrainage2\":\"Poor\",\"InteriorplumbingComment\":null,\"LeakingCheckbox\":\"\",\"Value\":[],\"otherInput\":\"\"},{\"MainFuelVisible\":null,\"MainFuelLocation\":[{\"comment\":\"test\",\"key\":0}],\"MainFuelComment\":null,\"Images\":[],\"Value\":[]},{\"SanitaryVisible\":null,\"checkBox\":null,\"SanitarySealed\":\"No\",\"SanitaryCheck\":\"No\",\"SanitaryShutDown\":\"No\",\"SanitaryVented\":\"No\",\"SanitayComment\":null,\"Images\":[],\"Value\":[]},null,{\"Location\":[{\"comment\":\"\",\"key\":0}],\"WaterCondition\":\"Poor\",\"Adequate\":\"No\",\"Amperage\":\"60a\",\"Break\":\"Fuses\",\"ApearsGrounded\":\"Not visible\",\"GFCI\":\"No\",\"GFCICheckbox\":\"No\",\"AFCI\":\"No\",\"AFCICheckbox\":\"Not tested\",\"MainWire\":\"Aluminum\",\"MainWireCheckbox\":\"Marginal\",\"BranchWire\":\"Poor\",\"BranchWireCondition\":\"\",\"Reason\":[{\"comment\":\"\",\"key\":0}],\"ElectricComment\":\"\",\"Images\":[],\"Value\":[]},[{\"Visible\":\"N/A\",\"General\":\"Wall unit\",\"GeneralInputs\":[{\"comment\":\"\",\"key\":0}],\"AgeInputs\":[{\"comment\":\"\",\"key\":0}],\"Evaporator\":\"Not Visible\",\"Refrigerant\":\"Damage\",\"Condensate\":\"To Pump\",\"CondensateInput\":\"\",\"Secondary\":\"Primary Pan appears clogged\",\"Operation\":\"\",\"PresentCheckbox\":\"No\",\"NeededCheckbox\":\"\",\"Condition\":\"Satisfactory\",\"Comments\":[],\"Images\":[]},{\"Visible\":\"\",\"General\":\"Central System\",\"GeneralInputs\":[{\"comment\":\"\",\"key\":0}],\"AgeInputs\":[{\"comment\":\"\",\"key\":0}],\"Evaporator\":\"Needs Cleaning\",\"Refrigerant\":\"Insulation Missing\",\"Condensate\":\"To exterior\",\"CondensateInput\":\"\",\"Secondary\":\"Recommedn Technician Evaluate\",\"Operation\":\"\",\"PresentCheckbox\":\"Yes\",\"NeededCheckbox\":\"Yes\",\"Condition\":\"Satisfactory\",\"Comments\":[],\"Images\":[]}],[{\"Location\":[{\"comment\":\"\",\"key\":0}],\"WallsAndCieling\":\"Satisfactory\",\"MoistureStains\":\"Yes\",\"MoistureStainsInputs\":[{\"comment\":\"\",\"key\":0}],\"Floor\":\"Poor\",\"CielingFan\":\"Recommend Repair/Replace\",\"Electrical\":\"Cover Plates Missing\",\"ElectricalCheckBox\":\"Doors\",\"ElectricalReceptableCheckBox\":\"Operable\",\"ElectricalOpenGroundCheckBox\":\"No\",\"HealingSource\":\"Yes\",\"HealingSourceBox\":\"\",\"Doors\":\"None\",\"Window\":\"None\",\"Comments\":[],\"Images\":[]}],null,{\"laundrySink\":null,\"faucetLeak\":\"No\",\"pipesLeak\":\"Not Visible\",\"crossConnections\":\"Potential Safety Hazard\",\"electricalOpenCheckBox\":\"Safety hazard\",\"heatSource\":\"Yes\",\"dryer\":\"Ceiling\",\"roomVented\":\"Yes\",\"GFCIOperableCheckBox\":null,\"GFCI\":\"Yes\",\"appliances\":\"Washer\",\"washerHookUp\":\"Leaking\",\"gasShutOf\":null,\"Images\":[],\"Value\":[],\"gasShuts\":[\"No\"]},null,null]', '[{\"counterTopCondition\":\"Satisfactory\",\"counterTopComment\":null,\"Images\":[],\"Value\":[]},null,null,null,null,{\"ApplianceDisposal\":\"N/A\",\"ApplianceOven\":\"Not Tested\",\"ApplianceRange\":\"Not Tested\",\"ApplianceDishwasher\":\"Not Tested\",\"ApplianceExaustFan\":\"Not Tested\",\"ApplianceRefregerator\":\"Not Tested\",\"ApplianceMicroWave\":\"Not Tested\",\"ApplianceDishWasherDrain\":\"No\",\"ApplianceReceptablesPresent\":\"No\",\"ApplianceGFCI\":\"Yes\",\"ApplianceOpenGroundReserve\":\"No\",\"ApplianceComment\":null,\"Images\":[],\"Value\":[],\"kitchenDisposalOperableCheckbox\":\"No\",\"kitchenOvenOperableCheckbox\":false,\"kitchenRangeOperableCheckbox\":false,\"kitchenDishwasherOperableCheckbox\":false,\"kitchenExhaustfanOperableCheckbox\":false,\"kitchenRefrigeratorOperableCheckbox\":false,\"kitchenMicrowaveOperableCheckbox\":false,\"kitchenReceptableOperableCheckbox\":\"Yes\",\"kitchenGFCIOperableCheckbox\":\"present\",\"kitchenGFCIReceptaclesCheckbox\":\"Potential Safety Hazard(s)\"}]', '[null,null,null,null,null,null,null,{\"plumbingVentVisible\":null,\"plumbingVentMaterial\":\"Satisfactory\",\"plumbingVentCondition\":null,\"Images\":[],\"Value\":[]}]', '2023-07-27 18:20:06', NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `inspection_form`
--
ALTER TABLE `inspection_form`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inspection_id` (`inspection_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `inspection_form`
--
ALTER TABLE `inspection_form`
  ADD CONSTRAINT `relaiton_between_inspections` FOREIGN KEY (`inspection_id`) REFERENCES `assigned_inspections` (`id`) ON DELETE NO ACTION;
COMMIT;

