function up()
{
DBManager::get()->exec("\n\t CREATE TABLE IF NOT EXISTS `fleximport_processes` (\n `process_id` varchar(32) NOT NULL DEFAULT '',\n `name` varchar(100) NOT NULL DEFAULT '',\n `description` TEXT NULL,\n `triggered_by_cronjob` tinyint(11) DEFAULT NULL,\n `chdate` int(11) NOT NULL,\n `mkdate` int(11) NOT NULL,\n PRIMARY KEY (`process_id`)\n );\n\t ");
DBManager::get()->exec("\n ALTER TABLE `fleximport_tables` ADD `process_id` VARCHAR(32) NULL AFTER `table_id`;\n ");
$statement = DBManager::get()->prepare("\n SELECT COUNT(*) as number\n FROM fleximport_tables\n ");
$statement->execute();
if ($statement->fetch(PDO::FETCH_COLUMN, 0) > 0) {
$process = new FleximportProcess();
$process['name'] = "Import";
$process['triggered_by_cronjob'] = 1;
$process->store();
$statement = DBManager::get()->prepare("\n UPDATE `fleximport_tables`\n SET process_id = :process_id\n ");
$statement->execute(array('process_id' => $process->getId()));
}
DBManager::get()->exec("\n ALTER TABLE `fleximport_tables` CHANGE `source` \n `source` enum('csv_upload','csv_weblink','csv_studipfile','database','extern','sqlview') NOT NULL DEFAULT 'csv_upload';\n ");
SimpleORMap::expireTableScheme();
}
