File Manager

X7ROOT File Manager

Current Path: /home/gfecatvj/sites/realesbar-X/database/migrations

home / gfecatvj / sites / realesbar-X / database / migrations /

📁 ..
📄 2014_10_12_000000_create_users_table.php(1.6 KB)
📄 2014_10_12_100000_create_password_resets_table.php(688 B)
📄 2019_08_19_000000_create_failed_jobs_table.php(774 B)
📄 2020_07_27_025632_create_bloggers_table.php(1013 B)
📄 2020_07_27_030335_create_articles_table.php(1.34 KB)
📄 2020_07_27_031703_create_agents_table.php(997 B)
📄 2020_07_27_033636_create_categories_table.php(625 B)
📄 2020_07_28_001906_create_associations_table.php(877 B)
📄 2020_07_28_001953_create_agencies_table.php(916 B)
📄 2020_07_28_003344_create_comments_table.php(1.3 KB)
📄 2020_07_28_003914_create_pcomments_table.php(1.29 KB)
📄 2020_07_28_004150_create_properties_table.php(2.4 KB)
📄 2020_07_28_004234_create_feedbacks_table.php(952 B)
📄 2020_07_28_005908_create_messages_table.php(930 B)
📄 2020_07_28_011128_create_ratings_table.php(580 B)
📄 2020_07_28_032641_create_roles_table.php(646 B)

Editing: 2020_07_28_004150_create_properties_table.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreatePropertiesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('properties', function (Blueprint $table) {
            $table->id();
            $table->smallInteger('status')->comment('1 for draft, 2 for submited,3 for approved,4 for rejected');
            $table->boolean('featured')->default(false);
            $table->smallInteger('agent_id')->unsigned()->default(0);
            $table->foreign('agent_id')->references('id')->on('users')->onDelete('cascade');
            $table->mediumText('aqu_option')->nullable();
            $table->mediumText('title');
            $table->double('price', 8, 2)->nullable();
            $table->mediumText('price_postfix');
            $table->smallInteger('bedrooms');
            $table->smallInteger('bathrooms')->nullable();
            $table->year('year_built')->nullable();
            $table->smallInteger('garages')->nullable();
            $table->integer('area')->nullable();
            $table->mediumText('area_postfix')->nullable();
            $table->enum('purpose', ['sale', 'rent']);
            $table->enum('type', ['house', 'apartment','office', 'land']);
            $table->enum('property_status', ['available', 'sold','pending']);
            $table->string('description');
            $table->json('img')->nullable();
            $table->json('floor_plan')->nullable();
            $table->mediumText('video_link')->nullable();
            $table->mediumText('country');
            $table->mediumText('region');
            $table->mediumText('city');
            $table->mediumText('address')->nullable();
            $table->string('location_latitude')->nullable();
            $table->string('location_longitude')->nullable();
            $table->text('nearby')->nullable();
            $table->json('amenities')->nullable();
            $table->integer('view_count')->default(0);
            $table->boolean('is_approved')->default(false);
            $table->timestamp('last_updated')->nullable();
            $table->timestamp('date_added')->nullable();
        });
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('properties');
    }
}

X7ROOT File Manager

Editing: 2020_07_28_004150_create_properties_table.php

Upload File

Create Folder