openrat-cms

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README

DBVersion000020.class.php (897B)

      1 <?php
      2 
      3 namespace cms\update\version;
      4 
      5 use database\DbVersion;
      6 use database\Column;
      7 
      8 /**
      9  * Aliases for node objects.
     10  *
     11  * @author dankert
     12  *
     13  */
     14 class DBVersion000020 extends DbVersion
     15 {
     16     /**
     17      *
     18      */
     19     public function update()
     20     {
     21         $table = $this->table('alias')->add();
     22 
     23         $table->column('objectid'     )->type(Column::TYPE_INT)->add();
     24         $table->column('languageid'   )->type(Column::TYPE_INT)->nullable()->add();
     25         $table->column('link_objectid')->type(Column::TYPE_INT)->add();
     26 
     27 
     28         $table->addPrimaryKey ();
     29 
     30         $table->addConstraint ('objectid', 'object');
     31         $table->addConstraint ('languageid', 'language');
     32         $table->addConstraint ('link_objectid', 'object');
     33 
     34         $table->addUniqueIndex('objectid');
     35         $table->addUniqueIndex(['link_objectid','languageid']);
     36         $table->addIndex      ('link_objectid');
     37     }
     38 }
     39