PHP Virge\Database\Component Schema::timestamp示例

示例#1

文件： events.php 项目： siosphere/virge-events

<?php

use Virge\Database\Component\Schema;
Schema::create(function () {
    Schema::table('async_event');
    Schema::id('id');
    Schema::string('name');
    Schema::string('class_name');
    Schema::text('params');
    Schema::timestamp('run_at');
    Schema::timestamp('started_on');
    Schema::timestamp('finished_on');
    Schema::timestamp('started_by');
    Schema::text('output');
    Schema::end();
});

示例#2

文件： database.php 项目： siosphere/virge-db

<?php

use Virge\Database\Component\Schema;
/**
 * Setup schema migration database tables (using the schema migration tool)
 * @author Michael Kramer
 */
Schema::create(function () {
    Schema::table('virge_migration');
    Schema::id('id');
    Schema::string('filename')->setIndex('INDEX');
    Schema::timestamp('executed_on');
    Schema::string('executed_by');
    Schema::text('summary');
    //all output
    Schema::end();
});

示例#3

文件： database.php 项目： siosphere/virge-cron

<?php

use Virge\Database\Component\Schema;
/**
 * Setup schema migration database tables (using the schema migration tool)
 * @author Michael Kramer
 */
Schema::create(function () {
    Schema::table('virge_cron_job');
    Schema::id('id');
    Schema::string('name');
    Schema::string('callable');
    Schema::text('arguments');
    Schema::timestamp('scheduled_for');
    Schema::timestamp('started_on');
    Schema::string('started_by');
    Schema::timestamp('finished_on');
    Schema::text('summary');
    //all output
    Schema::end();
});