openrat-cms

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

DBVersion000002.class.php (550B)

      1 <?php
      2 
      3 namespace cms\update\version;
      4 
      5 use database\DbVersion;
      6 use database\Column;
      7 
      8 /**
      9  * new table: version.
     10  *
     11  * @author dankert
     12  *
     13  */
     14 class DBVersion000002 extends DbVersion
     15 {
     16 	public function update()
     17 	{
     18 		$table = $this->table('version')->add();
     19 
     20 		$table->column('version'  )->type(Column::TYPE_INT)->add();
     21 		$table->column('status'   )->type(Column::TYPE_INT)->add();
     22 		$table->column('installed')->type(Column::TYPE_INT)->add();
     23 		
     24 		$table->addPrimaryKey ();
     25 		$table->addIndex      ('status');
     26 		$table->addUniqueIndex('version');
     27 	}
     28 }