butcherman / Tech_Bench

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateCustomerContactPhonesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

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

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

            $table->text('phone_number');

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

            $table->timestamps();

            $table->foreign('cont_id')->references('cont_id')->on('customer_contacts')->onUpdate('cascade')->onDelete('cascade');

            $table->foreign('phone_type_id')->references('phone_type_id')->on('phone_number_types')->onUpdate('cascade');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('customer_contact_phones');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateCustomerNotesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('note_id');

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

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

            $table->boolean('urgent')->default(0)->nullable();

            $table->text('subject');

            $table->longText('description');

            $table->timestamps();

            $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_notes');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateFileLinksTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('link_id');

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

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

            $table->text('link_hash');

            $table->text('link_name');

            $table->date('expire');

            $table->boolean('allow_upload');

            $table->timestamps();

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

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

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('file_links');

    }

}