Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
gilour
/
database
/
migrations
:
2015_01_20_100417_create_salary_table.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateSalaryTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('salary', function(Blueprint $table) { $table->increments('id'); $table->unsignedInteger("employee_id"); $table->foreign('employee_id') ->references('id')->on('employees') ->onUpdate('cascade') ->onDelete('cascade'); $table->string('type',100); $table->double('salary',10); $table->string('remarks'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('salary'); } }