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

Last commit: Sun Oct 1 02:58:08 2023 +0200	Jan Dankert	Refactoring: No it is possible to use 8 byte integers in the database


     1 <?php
     2 
     3 namespace cms\update\version;
     4 
     5 use database\DbVersion;
     6 use database\Column;
     7 use security\Password;
     8 
     9 /**
    10  * The format of a value is stored in the value table, so users can change the format of a value, independent of the element.
    11  *
    12  * @author dankert
    13  *
    14  */
    15 class DBVersion000019 extends DbVersion
    16 {
    17     /**
    18      *
    19      */
    20     public function update()
    21     {
    22     	$table = $this->table('value');
    23         $table->column('format'  )->type(Column::TYPE_INT)->defaultValue(0)->add();
    24 
    25         // Initial Value: Copy from element.
    26         $tableValue   = $this->table('value')->getSqlName();
    27         $tableElement = $this->table('element')->getSqlName();
    28 
    29         $updateStmt = $this->getDb()->sql(<<<SQL
    30 UPDATE $tableValue
    31    SET format=(select format from $tableElement where $tableValue.elementid=$tableElement.id)
    32 SQL
    33         );
    34         $updateStmt->execute();
    35     }
    36 }
    37 



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


History
Sun, 1 Oct 2023 02:58:08 +0200	Jan Dankert	Refactoring: No it is possible to use 8 byte integers in the database
Sun, 7 Mar 2021 00:10:20 +0100	Jan Dankert	Refactoring: Hopefully more performance while accessing the database resultsets.
Fri, 25 Sep 2020 01:00:58 +0200	Jan Dankert	Refactoring: More OO in the database updater :)
Sun, 23 Feb 2020 00:30:10 +0100	Jan Dankert	Refactoring: Namespacing for module 'database-update', now called 'cms\update'.