/*	===============================================================================================
	Project: ICST | BI2I | Tax Calculator
	-----------------------------------------------------------------------------------------------
	Date: Aug 11, 2017
	Details: 
		1) 	Create a separate schema for BRIDGEi2i
		2) 	Create a copy of the releavnt tables that will be required
	============================================================================================ */


/*	Step 01: Create schema
	===============================================================================================
	Create a new schema using the PHP MyAdmin login.
	Call the schema "bi2i_tax_calc"
*/





/*	Step 02: Create a copy of "deity.rpt_prp_propertysummary
	===============================================================================================
*/
create table bi2i_tax_calc.original_propertysummary as 
select * from deity.rpt_prp_propertysummary
where districtid = 252;