function tearDown()
 {
     SimpleORMap::expireTableScheme();
     Config::set(null);
     StudipCacheFactory::setConfig(null);
     $GLOBALS['CACHING_ENABLE'] = false;
 }

 function up()
 {
     $db = DbManager::get();
     $db->exec("ALTER TABLE `datafields` CHANGE `type` `type` ENUM('bool','textline','textarea','selectbox','date','time','email','phone','radio','combo','link','selectboxmultiple') NOT NULL DEFAULT 'textline'");
     $db->exec("ALTER TABLE `datafields` ADD `is_userfilter` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `is_required`");
     SimpleORMap::expireTableScheme();
 }

 function up()
 {
     $db = DBManager::get();
     $db->exec("ALTER TABLE `resources_requests` ADD `metadate_id` VARCHAR( 32 ) NOT NULL DEFAULT '' AFTER `termin_id`");
     $db->exec("ALTER TABLE `resources_requests` DROP INDEX  `closed` , ADD INDEX  `closed` (  `closed` ,  `request_id`, `resource_id` )");
     $db->exec("ALTER TABLE `resources_requests` ADD INDEX (  `metadate_id` )");
     SimpleORMap::expireTableScheme();
 }

 public function up()
 {
     DBManager::get()->exec("\n            ALTER TABLE `pluginmarket_plugins`\n            ADD `rating` DOUBLE NULL AFTER `language` ;\n        ");
     SimpleORMap::expireTableScheme();
     foreach (MarketPlugin::findBySQL("1=1") as $plugin) {
         $plugin['rating'] = $plugin->calculateRating();
         $plugin->store();
     }
 }

 public function down()
 {
     $db = DBManager::get();
     $db->exec("ALTER TABLE scm CHANGE tab_name tab_name varchar(20) NOT NULL DEFAULT 'Info',\n                                   CHANGE content content text");
     $db->exec("ALTER TABLE user_info CHANGE lebenslauf lebenslauf text,\n                                         CHANGE publi publi text NOT NULL");
     $db->exec("ALTER TABLE wiki CHANGE keyword keyword varchar(128) BINARY NOT NULL DEFAULT '',\n                                    CHANGE body body text");
     $db->exec("ALTER TABLE wiki_links CHANGE from_keyword from_keyword char(128) BINARY NOT NULL DEFAULT '',\n                                          CHANGE to_keyword to_keyword char(128) BINARY NOT NULL DEFAULT ''");
     $db->exec("ALTER TABLE wiki_locks CHANGE keyword keyword varchar(128) BINARY NOT NULL DEFAULT ''");
     SimpleORMap::expireTableScheme();
 }

 function down()
 {
     $db = DBManager::get();
     $db->exec("ALTER TABLE `lock_rules` CHANGE `permission` `permission` ENUM( 'tutor', 'dozent', 'admin', 'root' ) NOT NULL DEFAULT 'dozent'");
     $db->exec("ALTER TABLE `lock_rules` DROP `object_type`");
     $db->exec("ALTER TABLE `lock_rules` DROP `user_id`");
     $db->exec("ALTER TABLE `user_info` DROP `lock_rule`");
     $db->exec("ALTER TABLE `Institute` DROP `lock_rule`");
     SimpleORMap::expireTableScheme();
 }

 public function down()
 {
     $query = "ALTER TABLE `seminare`\n                  DROP COLUMN `is_complete`";
     DBManager::get()->exec($query);
     SimpleORMap::expireTableScheme();
     $query = "DELETE FROM `config` WHERE `field` = :field";
     $statement = DBManager::get()->prepare($query);
     $statement->bindValue(':field', 'ADMIN_COURSES_SHOW_COMPLETE');
     $statement->execute();
 }

 public function __construct($id = null)
 {
     $this->db_table = 'doc_filetype_forbidden';
     $this->belongs_to['userConfig'] = array('class_name' => 'DocUsergroupConfig', 'foreign_key' => 'usergroup');
     $this->belongs_to['filetype'] = array('class_name' => 'DocFiletype', 'foreign_key' => 'dateityp_id');
     parent::__construct($id);
 }

 protected static function configure($config = array())
 {
     $config['db_table'] = 'archiv_user';
     $config['belongs_to']['user'] = array('class_name' => 'User', 'foreign_key' => 'user_id');
     $config['belongs_to']['course'] = array('class_name' => 'ArchivedCourse', 'foreign_key' => 'seminar_id');
     parent::configure($config);
 }

 /**
  * Give primary key of record as param to fetch
  * corresponding record from db if available, if not preset primary key
  * with given value. Give null to create new record
  *
  * @param mixed $id primary key of table
  */
 public function __construct($id = null)
 {
     $this->db_table = 'seminar_tabs';
     $this->belongs_to['course'] = array('class_name' => '\\Course', 'foreign_key' => 'seminar_id');
     // workaround for Stud.IP ticket:5312
     //$options = $this->getRelationOptions('course');
     //$options = $this->getRelationOptions('parent');
     /**
             $this->has_many['children'] = array(
                 'class_name'        => 'Mooc\\DB\\Block',
                 'assoc_foreign_key' => 'parent_id',
                 'assoc_func'        => 'findByParent_id',
                 'on_delete'         => 'delete',
                 'on_store'          => 'store'
             );
     
             $this->registerCallback('before_create', 'ensureSeminarId');
             $this->registerCallback('before_create', 'ensurePositionId');
             $this->registerCallback('before_store',  'validate');
     
             $this->registerCallback('after_delete',  'destroyFields');
             $this->registerCallback('after_delete',  'destroyUserProgress');
             $this->registerCallback('after_delete',  'updatePositionsAfterDelete');
     
             $events = words('after_create after_update after_store after_delete');
             $this->registerCallback($events, 'callbackToMetrics');
     		**/
     parent::__construct($id);
 }

 function delete()
 {
     $old_assign_object = new AssignObject($this->id);
     $ret = parent::delete();
     $old_assign_object->delete();
     return $ret;
 }

 protected static function configure($config = array())
 {
     $config['db_table'] = 'archiv';
     $config['has_many']['members'] = array('class_name' => 'ArchivedCourseMember', 'on_delete' => 'delete', 'on_store' => 'store');
     $config['belongs_to']['home_institut'] = array('class_name' => 'Institute', 'foreign_key' => 'heimat_inst_id');
     parent::configure($config);
 }

 protected static function configure($config = array())
 {
     $config['db_table'] = 'questionnaire_answers';
     $config['belongs_to']['question'] = array('class_name' => 'QuestionnaireQuestion');
     $config['serialized_fields']['answerdata'] = "JSONArrayObject";
     parent::configure($config);
 }

 protected static function configure($config = array())
 {
     $config['db_table'] = 'questionnaires';
     $config['has_many']['questions'] = array('class_name' => 'QuestionnaireQuestion', 'on_delete' => 'delete', 'on_store' => 'store');
     $config['has_many']['assignments'] = array('class_name' => 'QuestionnaireAssignment', 'on_delete' => 'delete', 'on_store' => 'store');
     parent::configure($config);
 }

 /**
  * Initialize a new directory entry object for the given id.
  *
  * @param string $id  directory entry id
  * @throws InvalidArgumentException if id of directory entry is invalid
  */
 public function __construct($id = null)
 {
     parent::__construct($id);
     if ($id !== null && $this->isNew()) {
         throw new InvalidArgumentException('directory entry not found');
     }
 }

 public function store()
 {
     if (!$this['public_key']) {
         $this->createKeys();
     }
     return parent::store();
 }

 protected static function configure($config = array())
 {
     $config['db_table'] = 'contact';
     $config['belongs_to']['owner'] = array('class_name' => 'User', 'foreign_key' => 'owner_id');
     $config['belongs_to']['friend'] = array('class_name' => 'User', 'foreign_key' => 'user_id');
     $config['has_many']['group_assignments'] = array('class_name' => 'StatusgruppeUser', 'foreign_key' => 'user_id', 'assoc_foreign_key' => 'user_id', 'on_delete' => 'delete', 'on_store' => 'store');
     parent::configure($config);
 }

 protected static function configure($config = array())
 {
     $config['db_table'] = 'eval';
     $config['belongs_to']['author'] = array('class_name' => 'User', 'foreign_key' => 'author_id');
     $config['has_and_belongs_to_many']['participants'] = array('class_name' => 'User', 'thru_table' => 'eval_user');
     $config['additional_fields']['enddate'] = true;
     parent::configure($config);
 }

 function __construct($id = null)
 {
     if (version_compare($GLOBALS['SOFTWARE_VERSION'], "3.2", "<")) {
         $this->registerCallback('before_store', 'cbSerializeData');
         $this->registerCallback('after_store after_initialize', 'cbUnserializeData');
     }
     parent::__construct($id);
 }

 /**
  * Deletes the asset.
  *
  * @return int indicating how many rows were deleted
  */
 public function delete()
 {
     $filename = $this->getFilepath();
     if (file_exists($filename)) {
         unlink($filename);
     }
     return parent::delete();
 }