<?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(); });
<?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(); });
<?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(); });
<?php use Virge\Database\Component\Schema; Schema::create(function () { Schema::table('your_table_name'); });