"Fossies" - the Fresh Open Source Software Archive

Member "4.6.1/db/migrations/04_step_116_participant_view.php" (8 Apr 2021, 901 Bytes) of package /linux/www/studip-4.6.1.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PHP source code syntax highlighting (style: standard) with prefixed line numbers and code folding option. Alternatively you can here view or download the uninterpreted source code file.

    1 <?php
    2 class Step116ParticipantView extends Migration
    3 {
    4     public function description ()
    5     {
    6         return 'creates table necessary for StEP116';
    7     }
    8 
    9     public function up ()
   10     {
   11         $this->announce(" creating table...");
   12 
   13         DBManager::get()->exec("CREATE TABLE IF NOT EXISTS `teilnehmer_view` (
   14                                     `datafield_id` varchar(40) NOT NULL default '',
   15                                     `seminar_id` varchar(40) NOT NULL default '',
   16                                     `active` tinyint(4) default NULL,
   17                                     PRIMARY KEY  (`datafield_id`, `seminar_id`)
   18                                 )");
   19 
   20         $this->announce("done.");
   21 
   22     }
   23 
   24     public function down ()
   25     {
   26         $this->announce(" removing table...");
   27 
   28         DBManager::get()->exec("DROP TABLE `teilnehmer_view`");
   29 
   30         $this->announce("done.");
   31     }
   32 }