PHP Classes

File: system/Commands/Sessions/Views/migration.tpl.php

Recommend this page to a friend!
  Classes of Faris AL-Otabi   Task App   system/Commands/Sessions/Views/migration.tpl.php   Download  
File: system/Commands/Sessions/Views/migration.tpl.php
Role: Auxiliary script
Content type: text/plain
Description: Configuration script
Class: Task App
Create and manage tasks to be done
Author: By
Last change:
Date: 17 days ago
Size: 1,189 bytes
 

Contents

Class file image Download
@php namespace <?= $namespace ?>\Database\Migrations;

use CodeIgniter\Database\Migration;

class Migration_create_<?= $tableName ?>_table extends Migration
{
<?php if (isset($DBGroup)) : ?>
protected $DBGroup = '<?= $DBGroup ?>';
<?php endif ?>

    public function up()
    {
        $this->forge->addField([
            'id' => [
                'type' => 'VARCHAR',
                'constraint' => 128,
                'null' => false
            ],
            'ip_address' => [
                'type' => 'VARCHAR',
                'constraint' => 45,
                'null' => false
            ],
            'timestamp' => [
                'type' => 'INT',
                'constraint' => 10,
                'unsigned' => true,
                'null' => false,
                'default' => 0
            ],
            'data' => [
                'type' => 'TEXT',
                'null' => false,
                'default' => ''
            ],
        ]);
    <?php if ($matchIP === true) : ?>
$this->forge->addKey(['id', 'ip_address'], true);
    <?php else: ?>
$this->forge->addKey('id', true);
    <?php endif ?>
$this->forge->addKey('timestamp');
        $this->forge->createTable('<?= $tableName ?>', true);
    }

    //--------------------------------------------------------------------

    public function down()
    {
        $this->forge->dropTable('<?= $tableName ?>', true);
    }
}