File modules/cms/update/version/DBVersion000021.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 
     8 /**
     9  * Authentication tokens.
    10  *
    11  * @author dankert
    12  *
    13  */
    14 class DBVersion000021 extends DbVersion
    15 {
    16     /**
    17      *
    18      */
    19     public function update()
    20     {
    21         $table = $this->table('auth')->add();
    22 
    23         $table->column('selector'     )->type(Column::TYPE_VARCHAR )->size(150 )->add();
    24         $table->column('userid'       )->type(Column::TYPE_INT  )->add();
    25         $table->column('token'        )->type(Column::TYPE_VARCHAR )->size(150 )->add();
    26         $table->column('token_algo'   )->type(Column::TYPE_INT  )->defaultValue(0   )->add();
    27         $table->column('expires'      )->type(Column::TYPE_INT  )->add();
    28         $table->column('create_date'  )->type(Column::TYPE_INT  )->add();
    29         $table->column('platform'     )->type(Column::TYPE_VARCHAR)->add();
    30         $table->column('name'         )->type(Column::TYPE_VARCHAR)->add();
    31 
    32 
    33         $table->addPrimaryKey ();
    34 
    35         $table->addConstraint ('userid', 'user');
    36 
    37         $table->addUniqueIndex('selector');
    38     }
    39 }
    40 



Download modules/cms/update/version/DBVersion000021.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
Wed, 7 Jul 2021 22:29:06 +0200	Jan Dankert	Refactoring: Split values and content, new table "content".
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'.