TimemanVersion19Converter::createTemporaryTables

private function createTemporaryTables()
{
	if (!Application::getConnection()->isTableExists('b_timeman_converter_collected_schedules'))
	{
		Application::getConnection()->query("
			CREATE TABLE IF NOT EXISTS `b_timeman_converter_collected_schedules` (
				`ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
				`SCHEDULE_KEY` VARCHAR(50) NOT NULL DEFAULT '',
				`SCHEDULE_FORM_DATA` TEXT NOT NULL,
				`ASSIGNMENTS` MEDIUMTEXT NOT NULL,
				`ASSIGNMENTS_EXCLUDED` MEDIUMTEXT NOT NULL,
				`SCHEDULE_ID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
				`SHIFT_ID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
				`USERS_RECORDS_UPDATED` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
				PRIMARY KEY (`ID`),
				UNIQUE INDEX `SCHEDULE_KEY` (`SCHEDULE_KEY`)
			);
		");
	}
	if (!Application::getConnection()->isTableExists('b_timeman_converter_violation_rules'))
	{
		Application::getConnection()->query("
			CREATE TABLE IF NOT EXISTS `b_timeman_converter_violation_rules` (
				`ENTITY_CODE` VARCHAR(50) NOT NULL,
				`FORM_DATA` TEXT NOT NULL,
				`VIOLATION_RULES_SAVED` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
				UNIQUE INDEX `ENTITY_CODE` (`ENTITY_CODE`)
			);
		");
	}
	if (!Application::getConnection()->isTableExists('b_timeman_converter_log'))
	{
		Application::getConnection()->query("
			CREATE TABLE IF NOT EXISTS `b_timeman_converter_log` (
				`ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
				`TIMESTAMP_X` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
				`LOG_MESSAGE` MEDIUMTEXT NOT NULL,
				`FILE_LINE` INT(11) NOT NULL,
				PRIMARY KEY (`ID`)
			);
		");
	}
	if (!Application::getConnection()->isTableExists('b_timeman_converter_processed_entities'))
	{
		Application::getConnection()->query("
			CREATE TABLE IF NOT EXISTS `b_timeman_converter_processed_entities` (
				`ENTITY_CODE` VARCHAR(50) NULL DEFAULT NULL,
				UNIQUE INDEX `ENTITY_CODE` (`ENTITY_CODE`)
			)
		");
	}
}