DBVersion000024.class.php (463B)
1 <?php 2 3 namespace cms\update\version; 4 5 use database\DbVersion; 6 use database\Column; 7 8 /** 9 * Groups my contain subgroups. 10 * 11 * @author Jan Dankert 12 * 13 */ 14 class DBVersion000024 extends DbVersion 15 { 16 /** 17 * 18 */ 19 public function update() 20 { 21 $groupTable = $this->table('group'); 22 $groupTable->column('parentid')->type(Column::TYPE_INT )->nullable()->add(); 23 $groupTable->addIndex('parentid'); 24 $groupTable->addConstraint('parentid', 'group'); 25 } 26 }