openrat-cms

# OpenRat Content Management System
git clone http://git.code.weiherhei.de/openrat-cms.git
Log | Files | Refs

DBVersion000020.class.php (1028B)

      1 <?php
      2 
      3 use database\DbVersion;
      4 
      5 /**
      6  * Aliases for node objects.
      7  *
      8  * @author dankert
      9  *
     10  */
     11 class DBVersion000020 extends DbVersion
     12 {
     13     /**
     14      *
     15      */
     16     public function update()
     17     {
     18         $this->addTable('alias');
     19 
     20         $this->addColumn('alias','objectid'     ,OR_DB_COLUMN_TYPE_INT,null,null,OR_DB_COLUMN_NOT_NULLABLE);
     21         $this->addColumn('alias','languageid'   ,OR_DB_COLUMN_TYPE_INT,null,null,OR_DB_COLUMN_NULLABLE);
     22         $this->addColumn('alias','link_objectid',OR_DB_COLUMN_TYPE_INT,null,null,OR_DB_COLUMN_NOT_NULLABLE);
     23 
     24 
     25         $this->addPrimaryKey ('alias','id');
     26 
     27         $this->addConstraint ('alias','objectid'     ,'object'  ,'id');
     28         $this->addConstraint ('alias','languageid'   ,'language','id');
     29         $this->addConstraint ('alias','link_objectid','object'  ,'id');
     30 
     31         $this->addUniqueIndex('alias','objectid'                );
     32         $this->addUniqueIndex('alias','link_objectid,languageid');
     33         $this->addIndex      ('alias','link_objectid'           );
     34 
     35     }
     36 }
     37