source: database/migrations/2019_10_13_161454_create_user_profiles.php@ f457265

Last change on this file since f457265 was f457265, checked in by Berat Kjufliju <kufliju@…>, 4 years ago

ADD technoweek offer, companies

  • Property mode set to 100644
File size: 1.4 KB
Line 
1<?php
2
3use Illuminate\Support\Facades\Schema;
4use Illuminate\Database\Schema\Blueprint;
5use Illuminate\Database\Migrations\Migration;
6
7class CreateUserProfiles extends Migration
8{
9 /**
10 * Run the migrations.
11 *
12 * @return void
13 */
14 public function up()
15 {
16 Schema::create('user_profiles', function (Blueprint $table) {
17 $table->increments('id');
18 $table->integer('user_id')->unsigned();
19 $table->boolean('is_company_profile')->default(false);
20 $table->string('profile_link')->unique();
21 $table->string('short_bio')->nullable();
22 $table->string('profile_photo_link')->nullable();
23 $table->string('cover_photo_link')->nullable();
24 $table->string('technoblog_email')->unique();
25 $table->string('facebook_link')->nullable();
26 $table->string('instagram_link')->nullable();
27 $table->string('twitter_link')->nullable();
28 $table->string('youtube_link')->nullable();
29 $table->string('skype_link')->nullable();
30 $table->timestamps();
31
32 $table->foreign('user_id')->references("id")->on("users")->onDelete("cascade")->onUpdate("cascade");
33 });
34 }
35
36 /**
37 * Reverse the migrations.
38 *
39 * @return void
40 */
41 public function down()
42 {
43 Schema::dropIfExists('user_profiles');
44 }
45}
Note: See TracBrowser for help on using the repository browser.