openrat-cms

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

DBVersion000018.class.php (737B)

      1 <?php
      2 
      3 namespace cms\update\version;
      4 
      5 use database\DbVersion;
      6 use database\Column;
      7 use security\Password;
      8 
      9 /**
     10  * Elements should have a name and a separate label.
     11  *
     12  * @author dankert
     13  *
     14  */
     15 class DBVersion000018 extends DbVersion
     16 {
     17     /**
     18      *
     19      */
     20     public function update()
     21     {
     22     	$table = $this->table('element');
     23         $table->column('label'  )->type(Column::TYPE_VARCHAR)->size(100)->defaultValue('')->add();
     24 
     25         // Initial Value for Labels is the element name.
     26         $tableElement = $table->getSqlName();
     27 
     28         $updateStmt = $this->getDb()->sql(<<<SQL
     29 UPDATE $tableElement
     30    SET label=name
     31 SQL
     32         );
     33         $updateStmt->execute();
     34 
     35         $table->addUniqueIndex(['templateid','label']);
     36     }
     37 }
     38