butcherman / Tech_Bench

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateCustomerFilesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('customer_files', function(Blueprint $table) {

            $table->increments('cust_file_id');

            $table->integer('file_id')->unsigned();

            $table->integer('file_type_id')->unsigned();

            $table->integer('cust_id')->unsigned();

            $table->integer('user_id')->unsigned();

            $table->text('name');

            $table->timestamps();

            $table->foreign('file_id')->references('file_id')->on('files')->onUpdate('cascade');

            $table->foreign('file_type_id')->references('file_type_id')->on('customer_file_types')->onUpdate('cascade');

            $table->foreign('cust_id')->references('cust_id')->on('customers')->onUpdate('cascade')->onDelete('cascade');

            $table->foreign('user_id')->references('user_id')->on('users')->onUpdate('cascade');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('customer_files');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateFileLinkFilesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('file_link_files', function(Blueprint $table) {

            $table->increments('link_file_id');

            $table->integer('link_id')->unsigned();

            $table->integer('file_id')->unsigned();

            $table->integer('user_id')->unsigned()->nullable();

            $table->text('added_by')->nullable();

            $table->boolean('upload')->default(1);

            $table->longText('note')->nullable();

            $table->timestamps();

            $table->foreign('link_id')->references('link_id')->on('file_links')->onUpdate('cascade')->onDelete('cascade');

            $table->foreign('file_id')->references('file_id')->on('files')->onUpdate('cascade');

            $table->foreign('user_id')->references('user_id')->on('users')->onUpdate('cascade');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('file_link_files');

    }

}