File modules/cms/update/version/DBVersion000032.class.php

Last commit: Thu Feb 16 01:04:38 2023 +0100	Jan Dankert	New: Tags for base objects.


     1 <?php
     2 
     3 namespace cms\update\version;
     4 
     5 use database\Column;
     6 use database\DbVersion;
     7 
     8 /**
     9  * Add tags.
    10  *
    11  * @author dankert
    12  *
    13  */
    14 class DBVersion000032 extends DbVersion
    15 {
    16     /**
    17      *
    18      */
    19     public function update()
    20     {
    21     	$tagTable = $this->table('tag')->add();
    22 		$tagTable->addPrimaryKey();
    23 		$tagTable->column('projectid')->type( Column::TYPE_INT)->add();
    24 		$tagTable->column('name'     )->type( Column::TYPE_VARCHAR)->size(128 )->add();
    25 		$tagTable->addConstraint('projectid', 'project' );
    26 
    27 		$tagObjectTable = $this->table('tag_object')->add();
    28 		$tagObjectTable->addPrimaryKey();
    29 		$tagObjectTable->column('tagid')   ->type( Column::TYPE_INT )->add();
    30 		$tagObjectTable->column('objectid')->type( Column::TYPE_INT )->add();
    31 
    32 		$tagObjectTable->addConstraint('tagid'    , 'tag'   );
    33 		$tagObjectTable->addConstraint('objectid' , 'object');
    34 
    35 		$tagObjectTable->addUniqueIndex( ['tagid','objectid'] );
    36 	}
    37 }
    38 



Download modules/cms/update/version/DBVersion000032.class.php


History
Thu, 16 Feb 2023 01:04:38 +0100	Jan Dankert	New: Tags for base objects.