File modules/cms/update/version/DBVersion000033.class.php
Last commit: Sun Oct 1 02:59:13 2023 +0200 Jan Dankert New: Fixing the year 2038 problem with 8-byte-integers for the unix timestamps.
1 <?php 2 3 namespace cms\update\version; 4 5 use cms\base\Startup; 6 use database\DbVersion; 7 use database\Column; 8 use security\Password; 9 10 /** 11 * Migrate file values to content. 12 * 13 * @author dankert 14 * 15 */ 16 class DBVersion000033 extends DbVersion 17 { 18 /** 19 * Modify date columns to bigint to fix the year 2038 problem. 20 */ 21 public function update() 22 { 23 foreach( [ 24 $this->table('object' )->column('create_date' ), 25 $this->table('object' )->column('lastchange_date'), 26 $this->table('object' )->column('published_date')->nullable(), 27 $this->table('object' )->column('valid_from')->nullable(), 28 $this->table('object' )->column('valid_to' )->nullable(), 29 $this->table('value' )->column('date')->nullable(), 30 $this->table('value' )->column('lastchange_date'), 31 $this->table('version')->column('installed'), 32 $this->table('user' )->column('password_expires')->nullable(), 33 $this->table('user' )->column('last_login')->nullable(), 34 $this->table('user' )->column('password_locked_until')->nullable(), 35 $this->table('auth' )->column('expires'), 36 $this->table('auth' )->column('create_date'), 37 ] as $column ) { 38 $column->type( Column::TYPE_INT )->size( Column::SIZE_INT_BIG )->modify(); 39 } 40 } 41 } 42
Downloadmodules/cms/update/version/DBVersion000033.class.php
History Sun, 1 Oct 2023 02:59:13 +0200 Jan Dankert New: Fixing the year 2038 problem with 8-byte-integers for the unix timestamps.