Table organization - added new col temp_inactive (VARCHAR(1), Not Nullable, Default = 'N', Comment = 'Y means temporarily inactive during upgrade' )
Updated the records in this table with 'Y' in this col where it exists in the test db.

UPDATE organization SET temp_inactive = 'Y' WHERE id IN(51, 1634, 1710, 1863);

Table current_devices - renamed col 'timestamp' to 'last_meter_import' Added comment 'This will be the most current date of meter read when imported.' 

CREATE TABLE current_devices_orig AS(SELECT * FROM current_devices);


ON 6/5/2019 These were completed in preparation for go-live reconciliation reporting:
	Copied organization table in floorplans db, appending _orig to table name
	Then added new column to organization - - 'temp_inactive' (VARCHAR(1), Not Nullable, Default = 'N', Comment = 'Y means temporarily inactive during upgrade' )
	Matched the inactive records from test to prod, because the data was ONLY in test
		UPDATE organization SET temp_inactive = 'Y' WHERE id IN(51, 1634, 1710, 1863);
		
	Copied current_devices table in floorplans db, appending _orig to table name
	Then renamed col 'timestamp' to 'last_meter_import' and added comment 'This will be the most current date of meter read when imported.'
	
	Copied 4 billing tables in floorplans db, appending _orig to each table name
		CREATE TABLE billing_data_orig AS SELECT * FROM billing_data;
		CREATE TABLE billing_data_archive_orig AS SELECT * FROM billing_data_archive;
		CREATE TABLE billing_report_todo_orig AS SELECT * FROM billing_report_todo;
		CREATE TABLE billing_report_completed_orig AS SELECT * FROM billing_report_completed;
		
	Dropped the 4 original tables (without suffix)
	Copied the structure and data from test (spcsta5_bdutil) to prod (spcsta5_floorplans)
	
	Still need to move my files over
	
	Renamed 2 folders and 5 files (below) by appending _old 
		TCPDF
		scripts
		
		reports.php
		reportsAjax.php
		runReport.php
		scriptsAjax.js
		scriptsJavascript.js
		
	Copied the same 2 folders and 5 files from dmsv10 to dms
	
	To be deleted after no issues arise
		The 6 tables above that were renamed with _orig as suffix
		All 7 of the folders and files just renamed with the _old suffix
		run_reports.php from prod and test - Ask Bob first. This is not in use as far as I can see and has an error in the code anyway. It calls
			getReports.php for the action, but there is no such file.
			
	Archive data from meter after x years???
	IN TEST ONLY - I have:
		Created table meter_orig and copied the data from meter into it.
		Created table meter_archive and copied all records from meter table yr 2014, 2015 into it. (314036 rows, 724895 rows)
		Deleted all records for yr 2014, 2015 from meter.
		
			CREATE TABLE meter_orig AS SELECT * FROM meter;
			CREATE TABLE meter_archive AS SELECT * FROM meter WHERE 1 > 2;

			SELECT * FROM meter WHERE DATE_FORMAT( date_timestamp,  "%y" ) = 14;
			DELETE FROM meter WHERE DATE_FORMAT( date_timestamp,  "%y" ) = 14;

			SELECT * FROM meter WHERE DATE_FORMAT( date_timestamp,  "%y" ) = 15;
			DELETE FROM meter WHERE DATE_FORMAT( date_timestamp,  "%y" ) = 15;

			INSERT INTO meter_archive SELECT * FROM `meter` WHERE DATE_FORMAT( date_timestamp,  "%y" ) = 14;
			INSERT INTO meter_archive SELECT * FROM `meter` WHERE DATE_FORMAT( date_timestamp,  "%y" ) = 15;
			
			This is bad data that should be deleted??? TEST - 51 records, PROD - 33 records
			SELECT * FROM meter WHERE DATE_FORMAT( date_timestamp,  "%y" ) = 00 OR date_timestamp IS NULL;