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(); }